Notifications
Clear all
Topic starter
I know this has been mentioned a while ago but we have been having lots of calls about CPS freezing when the user tries to assign a diagnosis to an order. Actually freezing isn't the correct description, the diagnosis window will come up but it will be grayed out and you can't do anything with it. We have had to either put the document on hold and sometimes it will begin to work or they have to log all the way out of CPS and then log back in. Anyone else experience this? We recently went to 12.0.13 but had it happening even on 12.0.12.
Linda
Posted : May 24, 2017 5:31 am
Make sure that there are no SQL blocks by using the following:
use master
select * from sys.dm_os_waiting_tasks where blocking_session_id <> 0
------ Look for NULL in blocking_task_address-------
If you find a blocking_task_address, you will need to kill it by using the following:
kill [TASK NUMBER HERE]
You may also refer to SPR #65415 - Orders module freezing. The code below was created to be used with 12.0.11 - I cannot guarantee that it works with any newer version of CPS. I have not tried this code in any other version of CPS than 12.0.11 in our LIVE environment.
-- USE AFTER HOURS ONLY --
-- ADDRESSES ORDERS FREEZING ISSUE IN 12.0.11 --
Use Centricityps
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE name='MIKPatientVisitDiags_OrderDiagId_ix'
AND object_id = OBJECT_ID('[dbo].[MIKPatientVisitDiags]'))
begin
CREATE NONCLUSTERED INDEX MIKPatientVisitDiags_OrderDiagId_ix
ON [dbo].[MIKPatientVisitDiags]
( [OrderDiagId] Asc
) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
end
Posted : May 24, 2017 6:52 am
We are on 12.2 SP1 and we just started having this issue. It is patient specific for us. The nurse adds a diagnosis and unchecks the add to problem list because they are just trying to rule out by ordering a test and we actually get an error and the user get kicked out of centricity. So far we have not been able to duplicate in a test patient even adding all the problems and medications to the test patient. Our VAR is working to see if they can identify the issue. We don't have the issue if the nurse leaves the box checked to add to the problem list but we don't want this workflow because nurses can't diagnose. Thank you.
Posted : May 25, 2017 12:55 am
