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

Service Pack 7 issue with Index creation (at least CEMR)

Bugs, Known Issues, Open Cases

Last Post by Anonymous 1 second ago

5 Posts

4 Users

0 Reactions

66 Views

RSS

DavidShower

(@davidshower)

Posts: 1255

Noble Member

Topic starter

Did our upgrade this weekend and it only took about 10 minutes to complete. I called my EMR support engineer we had contracted for and he had me look at the db_check.log in our Oracle\Admin\SID\log folder. He had warned me earlier that I would need to check this log. There were messages about indexes being dropped and the CREATE statements for them. There were no success messages. I reran the create statements from the 3 indicated in my log. One created (and took quite a while), one created after making the read only index tablespace read write to do it, and the other had created successfully and returned a message that the object already existed.

Posted : January 12, 2015 5:58 am

ronmoses

(@ronmoses)

Posts: 158

Estimable Member

What three indexes were they? We're CPS, but still I'd like to see if our upgraded SP7 databases are affected.

Posted : January 12, 2015 6:58 am

DavidShower

(@davidshower)

Posts: 1255

Noble Member

Topic starter

ML.AUDIT_EVENT_PID_IDX (the one that took a long time to create) , ML.MS_DDS_COPYRIGHT_PIX (read only tablespace), and ML.DOCIMAGES_SDID_IDX

Posted : January 12, 2015 7:01 am

petemarkey

(@petemarkey)

Posts: 373

Honorable Member

Thanks for sharing this, as apparently GE doesn't care to as I don't see this potential issue in the install guide or the release notes. Why make software that works when they can just make you pay for support to actually fix it after you install it.

Posted : January 12, 2015 5:14 pm

tnolte

(@tnolte)

Posts: 6

Active Member

We applied it to our EMR Cert database earlier this week. I looked at the db_check.log file which had 4 index rebuilds in it. The pl/sql results were 'procedure successfully completed'.
the EMR indexes were:
LIST OF INDEXES OWNED BY ML THAT HAVE BEEN DROPPED
==================================================
1 ML.AUDIT_EVENT_PID_IDX
2 ML.MS_DDS_COPYRIGHT_PIX

LIST OF INDEXES OWNED BY ML HAVING ALTERED UNIQUENESS
=====================================================
1 ML.AUDIT_EVENT_DETAIL_PIX
2 ML.DOCIMAGES_SDID_IDX
After looking at the database it seems that they indexes were dropped and created in the TUT schema. this may be a coding error.

select object_name, created, last_ddl_time, owner from all_objects where object_name like '%AUDIT_EVENT_PID_IDX%';
order by object_name;
OBJECT_NAME CREATED OWNER
------------------------------ --------- ------------------------------
AUDIT_EVENT_PID_IDX 13-JAN-15 TUT
1 row selected.
OBJECT_NAME CREATED OWNER
------------------------------ --------- ------------------------------
MS_DDS_COPYRIGHT 18-MAR-14 ML
MS_DDS_COPYRIGHT 13-JAN-15 TUT
2 rows selected.
. . .
I have attempted to log an incident on this but cannot get to anyone on the 1-800 number. Might have to resort to the online entry. trouble with that is nobody from GE ever seems to reply to those.

Posted : January 15, 2015 9:22 am

Share:

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