Yes, we upgraded from SP 10 with no patches to SP 11 with no patches. Then we applied the DI and MU patch to SP 11.
I have not installed SP 11 in our test environment.
We do not use the HTML immunizations form, yet it continues to happen to us almost daily.
We are noticing SQL blocking occurring while the issue is symptomatic.
This started happening in our environment almost immediately after upgrading from SP9 to SP11. We skipped sp10 as we saw a lot of bugs with it and went with Blackbird's ICD10 search functionality.
We applied the DI and MU patch immediately after upgrading to SP11.
I have not tried reproducing in our test environment,
Issue occurs almost daily. usually any time between 11am and 2pm for a period of 10-15 minutes. Freezes for everybody at the same time.
If I wait it out it eventually unfreezes and becomes responsive again without needing to restart client.
We are seeing SQL blocking that's occurring during the time that the issue is symptomatic. I am working with my VAR to trace out the source of the blocking.
I wonder if other groups are seeing the sql blocking as well?
Thanks for that info. Our issue is exactly as you described, except that I cannot confirm any SQL blocking. Will you please tell me how you identified this?
We've had the similar issue three times since we upgraded to the SP11 in the beginning of December, 2015. We were down for almost an hour yesterday. Called GE but the support didn't know what might have caused the issue.
We have had shorter outages (10-15 min) that are reported by staff four to five days a week since our upgrade to SP11. Occasionally, the issue persists for much longer. I have allowed it continue for upwards of an hour before taking Centricity offline and restarting its servers. Unfortunately, I restarted both the SQL server and jBoss server at the same time. Next time I will try restarting them independently to help find out which may be to blame.
Everyone,
After suffering from this bug for over a month, I have discovered a way to quickly resume normal operation after the CPS 12 client begins to freeze for users while placing orders. I have not suffered any issues due to this workaround. That being said, please carefully review my method before deciding to use at your practice and DO SO AT YOUR OWN RISK.
When the freezing begins, open SQL Server Management Studio.
- Connect to the SQL server hosting the CentricityPS database.
- Begin a new query:
- Execute it.
- Review the blocking_session_id column and identify the session ID that is causing the block. Here is an example of the output you'll see from step 3. As you can see, the session with an ID of 726 is causing the block.
- Kill the session with an ID of 726 by executing this session:
CPS operation will resume to a normal state.