Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

CPS 11 Security User Management Feature Crashes

General Discussion

Last Post by jmkoi 11 years ago

6 Posts

2 Users

0 Reactions

75 Views

RSS

jmkoi

(@jmkoi)

Posts: 54

Estimable Member

Topic starter

We are nearing our production upgrade, and the administration --> system --> user and resource management --> users --> user management continues to crash when selecting the item. Error messages are

Error occurred in class CoreExceptionHandler, method ShowException
Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.
Exception details have been written to the log file.

ConstraintException: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.
   at GE.CPO.Common.Logic.LogicBase.ExecuteSql(String sql, DataSet ds, TypedParameterCollection paramCollection, String tableName)
   at GE.CPO.Common.Logic.CommonLogic.AllUserResources(Boolean onlyApplicationUsers, String[] sortByColumns)
   at GE.CPO.Common.UI.SelectExResource.ResourceMgmtListView.BuildDataView(DoctorFacilityTypes[] resourceTypes, String initialOrderByColumn, Hashtable searchCriteria)
   at GE.CPO.Common.UI.MgmtListViewCtrl.RefreshAllListViewItems(Boolean forceRefresh)
   at GE.CPO.Common.UI.SelectCtrlEx.RefreshFiltersAndRepopulate()
   at GE.CPO.Common.UI.ResourceMgmt.ResourceMgmtCtrl.SetInitialFilterControlStates()

This is query function in my opinion. I don't understand where a constraing violation could occur Has anyone seen this happen? I haven't received a response from GE yet.

Thanks.

John

Outside In - Data Analyist

@outsidein.org" rel="nofollow" target="_blank">johnk@outsidein.org

Posted : July 16, 2013 8:01 am

Conda

(@crobinson)

Posts: 255

Reputable Member

Please let me know we are doing an upgrade on 8-16-13 to version 11 and I am in charge of doing all of the securities.

Posted : July 16, 2013 9:34 pm

jmkoi

(@jmkoi)

Posts: 54

Estimable Member

Topic starter

Conda said:

Please let me know we are doing an upgrade on 8-16-13 to version 11 and I am in charge of doing all of the securities.

We spent 3 hours on the phone with GE with no resolution. Interestingly, user management works against the demo database and website. I restored the 9.5 database and reran the upgrade. No errors in upgrade, yet still got the same result. This morning GE will be contacting us again with a plan of action. It seems to point to the database, but the message is too generic.

John

Posted : July 18, 2013 1:21 am

jmkoi

(@jmkoi)

Posts: 54

Estimable Member

Topic starter

Conda,

Working with GE, we found we had multiple active doctorfacility records pointing to the same USR records. You may not run into this. GE provided us with the script below. Good luck on your upgrade. We are scheduled for this weekend.

John

-- Step 1: find the duplicates.

select doctorfacilityid, COUNT(*) from USR WHERE DoctorFacilityID IS NOT NULL group by doctorfacilityid having COUNT(*) > 1
go

---------------------------------------------------------------------
-- Step 2: View details for all these duplicates using the doctorfacilityid found in step 1.
select doctorfacilityid,status,* from USR where doctorfacilityid in (44,1131,1997)
go

---------------------------------------------------------------------
-- Step 3: Fix duplicate IDs by picking a loser for each pair, and setting them:
-- a) Inactive (Status='O')
-- b) Removing their DoctorFacilityID (DoctorFacilityID=NULL)

-- for LoginName='junz', DoctorFacilityID was 44
update usr set doctorfacilityid=NULL,status='O' where PVID=1498641295007010

-- For LoginName='skyen', DoctorFacilityID was 1131
update usr set doctorfacilityid=NULL,status='O' where PVID=1520193201009910

-- For LoginName='lyonp', DoctorFacilityID was 1997 (already inactive)
update usr set doctorfacilityid=NULL,status='O' where PVID=1579774883014290
GO

---------------------------------------------------------------------
-- Step 4: confirm no duplciate DoctorFacilityID values in the USR table
select doctorfacilityid, COUNT(*) from USR WHERE DoctorFacilityID IS NOT NULL group by doctorfacilityid having COUNT(*) > 1
go

Posted : August 7, 2013 6:37 am

Conda

(@crobinson)

Posts: 255

Reputable Member

Are you using AD or sequel authentication

Posted : August 8, 2013 12:00 am

jmkoi

(@jmkoi)

Posts: 54

Estimable Member

Topic starter

We are currently using AD authentication will be moving to Application for support reasons. That will be problematic beacuse it appears the AD passwords do not appear to be transferred over. Our strategy is to set the initial password, plus setting the flag to change upon login.

Posted : August 8, 2013 2:05 am

Share:

24 Forums
9,940 Topics
39.9 K Posts
0 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0