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 laterInformation 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
- On the target instance, install Agile 9.3.6 database
- On the source instance, run agile9impdp utility to export the database dmp
- On the target instance, import the source database dmp by following the steps in Note:2179763.1
- 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 |