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

Can't Load Patient CPS 12

General Discussion

Last Post by Crow 10 years ago

10 Posts

5 Users

0 Reactions

89 Views

RSS

mikeseale

(@mikeseale)

Posts: 344

Reputable Member

Topic starter

We've recently upgrade to CPS 12, and we are slowly starting to notice a few patients won't load whenever we go to view their chart summary. It just has the loading symbol over the banner and all the windows say "Sorry. There was an error loading this data." Doing a MELTrace, UI Trace, and SQL Trace didn't really give anything out of the ordinary. Has anyone else seen this? I'm opening a ticket with GE and will try post what the resolution is if they find one.

Posted : May 29, 2014 4:32 am

redde

(@redde)

Posts: 115

Estimable Member

I'm a little late to this post, but we have had the same issue. Our vendor found something in the database that was set to "Null" for each patient we were having this issue with. They created a script that took care of the issue. We still have to have them run it every so often though.

Posted : July 15, 2014 7:53 am

mikeseale

(@mikeseale)

Posts: 344

Reputable Member

Topic starter

We use this script to fix it:

SELECT PID FROM PatientProfile WHERE PatientId = 'patient id here'

FindChartOpenIssues @Pid = (put the result of the select above here) //If something returns when running this script, run the next script.

UPDATE DOCUMENT SET confType = 0 WHERE confType IS NULL AND PID = (result from first query)

FindChartOpenIssues is a Stored Procedure that we had to create on our database.

Posted : July 15, 2014 11:14 pm

RSBojalad

(@rsbojalad)

Posts: 47

Trusted Member

Is the store procedure still avaiable?

Posted : August 26, 2014 5:53 am

mikeseale

(@mikeseale)

Posts: 344

Reputable Member

Topic starter

Yeah, I posted it here:

https://centricityusers.com/?pa.....es/#p12991

Posted : August 26, 2014 6:11 am

Crow

(@dustincrowell)

Posts: 104

Estimable Member

I've used this script many times and has worked like a charm (much appreciated mikeseale). Today however, I ran the script and the chart still does not open. Does anyone have any other scripts up their sleeves that may work for the error; Sorry. There was an error loading this data?

Thanks in advance.

Posted : September 4, 2014 6:51 am

mdoak

(@mdoak)

Posts: 92

Estimable Member

I have had one or two instances of this caused by some extra space or garbage characters in one of the registration fields. In our case, I believe it was the zip code. Also had a malformed zip code cause some problems with statement files being parsed by Emdeon - that was fun to troubleshoot.

So go to registration for this patient, delete everything out of the zip code (and try some other fields if zip doesn't do the trick) and then repopulate it. I am not sure how this situation comes about, but I have seen it more than once so it seems like zip code data is not properly validated at entry time or something happens to it later.

Posted : September 8, 2014 1:26 am

Crow

(@dustincrowell)

Posts: 104

Estimable Member

Turns out it was an error that had to do with flags. The following script fixed the issue:

select searchname, pid from patientprofile
where patientID = '' -- enter Patient ID
select * from FLAG where CONTEXTID1 = -- enter PID
update FLAG set STATUS = -1 where ID = -- enter ID where status is null

I will definitely check the zip code/registration fields when this error inevitably shows up again.

Thanks for the advice mdoak.

Posted : September 8, 2014 1:43 am

mdoak

(@mdoak)

Posts: 92

Estimable Member

Probably unrelated to the zip code in your case if that was the script that fixed it. Very disconcerting that some stupid flag status prevents a chart from opening. I'm afraid to ask how long it took to get that resolved with GE. 🙂

Posted : September 8, 2014 1:45 am

Crow

(@dustincrowell)

Posts: 104

Estimable Member

I initially had a ticket in with GE but cancelled it because the head of our department had the script on hand so much time was saved.

Posted : September 8, 2014 2:06 am

Share:

24 Forums
9,940 Topics
39.9 K Posts
7 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