ORA-53051: no editDataModel session found And Multimedia Invalid After Upgrade From 11.1.0.7 To 11.2.0.1 (Doc ID 1573062.1)

Last updated on JUNE 21, 2022

Applies to:

Symptoms

Upgrade from 11.1.0.7.0 to 11.2.0.1

Upgrade log shows almost at the end of the log:

Oracle Multimedia
. ORA-00001: unique constraint (ORDDATA.ORDDCM_I_DOCS_PK) violated
. ORA-00001: unique constraint (ORDDATA.ORDDCM_ANON_R_TYPES_PK1) violated
. ORA-00001: unique constraint (ORDDATA.ORDDCM_ANON_R_TYPES_PK1) violated
. ORA-00001: unique constraint (ORDDATA.ORDDCM_ANON_R_TYPES_PK1) violated
. ORA-00001: unique constraint (ORDDATA.DOC_TYPES_PK) violated
. ORA-00001: unique constraint (ORDDATA.DOC_TYPES_PK) violated
. ORA-00001: unique constraint (ORDDATA.DOC_TYPES_PK) violated
. ORA-00001: unique constraint (ORDDATA.DOC_TYPES_PK) violated
. ORA-00001: unique constraint (ORDDATA.DOC_TYPES_PK) violated
. ORA-00001: unique constraint (ORDDATA.DOC_TYPES_PK) violated
. ORA-00001: unique constraint (ORDDATA.DOC_TYPES_PK) violated
. ORA-00001: unique constraint (ORDDATA.DOC_TYPES_PK) violated
. ORA-00001: unique constraint (ORDDATA.ORDDCM_I_DOCS_PK) violated
. ORA-00001: unique constraint (ORDDATA.ORDDCM_I_DOCS_PK) violated
. ORA-00001: unique constraint (ORDDATA.ORDDCM_I_DOCS_PK) violated
. ORA-00001: unique constraint (ORDDATA.ORDDCM_I_DOCS_PK) violated
. ORA-00001: unique constraint (ORDDATA.ORDDCM_I_DOCS_PK) violated
. ORA-00001: unique constraint (ORDDATA.ORDDCM_I_DOCS_PK) violated
. ORA-00001: unique constraint (ORDDATA.ORDDCM_I_DOCS_PK) violated
. ORA-00001: unique constraint (ORDDATA.ORDDCM_I_DOCS_PK) violated
. ORA-00001: unique constraint (ORDDATA.ORDDCM_ANON_A_TYPES_PK1) violated
. ORA-00001: unique constraint (ORDDATA.ORDDCM_ANON_A_TYPES_PK1) violated
. ORA-00001: unique constraint (ORDDATA.ORDDCM_ANON_A_TYPES_PK1) violated
. ORA-00001: unique constraint (ORDDATA.ORDDCM_ANON_A_TYPES_PK1) violated
. INVALID 11.2.0.1.0 00:06:37


Thinking that maybe they were running the upgrade for the second time therefore some PK constraint violated I asked them to run:

execute validate_ordim;

And we get:

SQL> set serveroutput on
SQL> execute validate_ordim;
ORDIM DICOM repository has 0 documents.
The following default DICOM repository documents are not installed:
ordcman.xml
ordcmcmc.xml
ordcmcmd.xml
ordcmct.xml
ordcmmp.xml
ordcmpf.xml
ordcmpv.xml
ordcmsd.xml
ordcmui.xml

PL/SQL procedure successfully completed.

SQL> select version, status from dba_registry where comp_id='ORDIM';

VERSION STATUS
------------------------------ --------------------------------------------
11.2.0.1.0 INVALID


As per couple of notes:

1. ORDIM DICOM repository has 0 documents (Doc ID 1086128.1)
2. How To Reload Oracle Multimedia Related Information When XML Database (=XDB) Has Been Reinstalled (Doc ID 965892.1)
I asked them to execute the following:

conn / as sysdba
set serveroutput on
set echo on
spool ord100.log
alter session set current_schema="ORDSYS";
@?/ord/im/admin/imxreg.sql;
@?/ord/im/admin/impbs.sql;
@?/ord/im/admin/impvs.sql;
@?/ord/im/admin/imtyb.sql;
@?/ord/im/admin/implb.sql;
@?/ord/im/admin/imxrepos.sql;
execute validate_ordim;
select version, status from dba_registry where comp_id='ORDIM';
spool off


The log shows:

SQL> alter session set current_schema="ORDSYS";

Session altered.

SQL> @/oracle/product/11g/GHCDEV01/ord/im/admin/imxrepos.sql;
SQL> Rem Copyright (c) 2006, 2007, Oracle. All rights reserved.
SQL> REM
SQL> REM Internal installation script for Oracle Multimedia
SQL> REM Load XML Schema documents.
SQL> REM
SQL>
SQL> REM Load XML Schema documents
SQL> @@imxrins.sql
SQL> Rem
SQL> Rem imxrins.sql
SQL> Rem
SQL> Rem Copyright (c) 2004, 2009, Oracle and/or its affiliates.
SQL> Rem All rights reserved.
SQL> Rem
SQL> Rem NAME
SQL> Rem imxrins.sql
SQL> Rem
SQL> Rem DESCRIPTION
SQL> Rem This script inserts the oracle default documents into the
SQL> Rem dicom repository
SQL> Rem
SQL> Rem *!*!*!*!* This script is autogenerated by ordim/utl/setupview.pl *!*!*!*!*
SQL> Rem Do not edit it unless you know what you are doing. Edit setup_view.pl
SQL> Rem
SQL> Rem NOTES
SQL> Rem Before running this script user must be connected as a user
SQL> Rem with authority to insert dicom repository documents.
SQL> Rem
SQL> Rem
SQL>
SQL> exec ordsys.ord_dicom_admin.editdatamodel;
BEGIN ordsys.ord_dicom_admin.editdatamodel; END;

*
ERROR at line 1:
ORA-02291: integrity constraint (ORDDATA.SYS_C0011618) violated - parent key
not found
ORA-06512: at "ORDSYS.ORD_DICOM_ADMIN_PRV", line 7103
ORA-06512: at "ORDSYS.ORD_DICOM_ADMIN", line 276
ORA-06512: at line 1

SQL>
SQL>
SQL> -- insert the ordcmsd.xml into the dicom repos
SQL> declare
2 xt sys.XMLtype;
3 ex exception;
4 pragma exception_init(ex, -53002);
5 ordcmXml varchar2(32767);
6 ordClob clob;
7 begin
8 sys.dbms_lob.createTemporary( ordClob, true, sys.dbms_lob.call );
9 ordcmXml := '' ||
10 '' ||
23 '' ||
24 '.
.
.
14813 end;
14814 /
declare
*
ERROR at line 1:
ORA-53051: no editDataModel session found
ORA-06512: at "ORDSYS.ORD_DICOM_ADMIN_PRV", line 6483
ORA-06512: at "ORDSYS.ORD_DICOM_ADMIN", line 125
ORA-06512: at line 14805

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.