Notifications
Clear all
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
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
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
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
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
