My Oracle Support Banner

ORA-39083: Object type CONSTRAINT:"AGILE"."LS_PK" Failed to Create with Error When Importing Source Agile Database Schema to Agile 9.3.6 Instance to Upgrade (Doc ID 2950832.1)

Last updated on JANUARY 24, 2024

Applies to:

Oracle Agile PLM Framework - Version 9.3.6.0 and later
Information in this document applies to any platform.

Symptoms

Below error is generated when importing the Source Agile database schema to 9.3.6 instance:

Error

ORA-39083: Object type CONSTRAINT:"AGILE"."LS_PK" failed to create with error:
ORA-01450: maximum key length (6398) exceeded

Failing sql is:
ALTER TABLE "AGILE"."LOCALE_STRINGS" ADD CONSTRAINT "LS_PK" PRIMARY KEY ("LS_BUNDLE", "LS_LOCALE", "LS_KEY") USING INDEX PCTFREE 20 INITRANS 2 MAXTRANS 255  STORAGE(INITIAL 4194304 NEXT 4194304 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "AGILE_INDX2"  ENABLE

Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
ORA-39083: Object type INDEX_STATISTICS failed to create with error:
ORA-20000: INDEX "AGILE"."LS_PK" does not exist or insufficient privileges

Failing sql is:
DECLARE I_N VARCHAR2(60);   I_O VARCHAR2(60);   NV VARCHAR2(1);   c DBMS_METADATA.T_VAR_COLL;   df varchar2(21) := 'YYYY-MM-DD:HH24:MI:SS';  stmt varchar2(300) := ' INSERT INTO "SYS"."IMPDP_STATS" (type,version,flags,c1,c2,c3,c5,n1,n2,n3,n4,n5,n6,n7,n8,n9,n10,n11,n12,d1,cl1) VALUES (''I'',6,:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,NULL,:14,:15,NULL,:16,:17)';BEGIN  DELETE FROM "SYS"."IMPDP_STATS";   i_n := 'LS_PK';   i_o := 'AGILE';   EXECUTE IMMEDIATE stmt USING 2,I_N,NV,NV,I_O,0,0,0,0,0,0,0,0,NV,NV,TO_DATE('2023-05-04 02:19:54',df),NV;  DBMS_STATS.IMPORT_INDEX_STATS('"' || i_o || '"','"' || i_n || '"',NULL,'"IMPDP_STATS"',NULL,'"SYS"');   DELETE FROM "SYS"."IMPDP_STATS"; END;

ORA-39083: Object type INDEX_STATISTICS failed to create with error:
ORA-20000: INDEX "AGILE"."SCI_ITEM_PK" does not exist or insufficient privileges

Failing sql is:
DECLARE I_N VARCHAR2(60);   I_O VARCHAR2(60);   NV VARCHAR2(1);   c DBMS_METADATA.T_VAR_COLL;   df varchar2(21) := 'YYYY-MM-DD:HH24:MI:SS';  stmt varchar2(300) := ' INSERT INTO "SYS"."IMPDP_STATS" (type,version,flags,c1,c2,c3,c5,n1,n2,n3,n4,n5,n6,n7,n8,n9,n10,n11,n12,d1,cl1) VALUES (''I'',6,:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,NULL,:14,:15,NULL,:16,:17)';BEGIN  DELETE FROM "SYS"."IMPDP_STATS";   i_n := 'SCI_ITEM_PK';   i_o := 'AGILE';   EXECUTE IMMEDIATE stmt USING 2,I_N,NV,NV,I_O,0,0,0,0,0,0,0,0,NV,NV,TO_DATE('2023-05-04 02:21:11',df),NV;  DBMS_STATS.IMPORT_INDEX_STATS('"' || i_o || '"','"' || i_n || '"',NULL,'"IMPDP_STATS"',NULL,'"SYS"');   DELETE FROM "SYS"."IMPDP_STATS"; END;

ORA-39083: Object type INDEX_STATISTICS failed to create with error:
ORA-20000: INDEX "AGILE"."ITEM_PK" does not exist or insufficient privileges

Failing sql is:
DECLARE I_N VARCHAR2(60);   I_O VARCHAR2(60);   NV VARCHAR2(1);   c DBMS_METADATA.T_VAR_COLL;   df varchar2(21) := 'YYYY-MM-DD:HH24:MI:SS';  stmt varchar2(300) := ' INSERT INTO "SYS"."IMPDP_STATS" (type,version,flags,c1,c2,c3,c5,n1,n2,n3,n4,n5,n6,n7,n8,n9,n10,n11,n12,d1,cl1) VALUES (''I'',6,:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,NULL,:14,:15,NULL,:16,:17)';BEGIN  DELETE FROM "SYS"."IMPDP_STATS";   i_n := 'ITEM_PK';   i_o := 'AGILE';   EXECUTE IMMEDIATE stmt USING 2,I_N,NV,NV,I_O,123820,257,123820,1,1,50424,1,123820,NV,NV,TO_DATE('2023-05-04 02:19:43',df),NV;  DBMS_STATS.IMPORT_INDEX_STATS('"' || i_o || '"','"' || i_n || '"',NULL,'"IMPDP_STATS"',NULL,'"SYS"');   DELETE FROM "SYS"."IMPDP_STATS"; END;

 

Facts

- Source instance Agile version is lower than 9.3.2 (i.e. 9.3.1.2)


Steps

  1. On the target instance, install Agile 9.3.6 database
  2. On the source instance, run agile9impdp utility to export the database dmp
  3. On the target instance, import the source database dmp by following the steps in Note:2179763.1
  4. See the error in the import log file.

 

Changes

Imported Agile database schema lower than 9.3.2 to 9.3.6 instance

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References

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