My Oracle Support Banner

DDLDict Utility Fails with GEN-14: More than one primary key column for table! in export_logical_schema.log in PostInstallDbSetup (Doc ID 2793308.1)

Last updated on NOVEMBER 24, 2022

Applies to:

Siebel CRM - Version 21.6 and later
Information in this document applies to any platform.

Symptoms

Applied Siebel 2021.6 and PostInstallDbSetup failed. 

In PostInstallDbSetup_date_time.log:

Thu Jul 8,2021 [14:39:0] : Stage 2 of 3 : Running SeedSchemaManifest Upgrade

Thu Jul 8,2021 [14:48:41] : Return Code from SeedSchemaManifest Upgrade : Failed

In the export_logical_schema.log:

GenericLog GenericError 1 0000000260f51db4:0 2021-07-19 11:45:33 Message: GEN-14,

Additional Message: More than one primary key column for table!

SQLDBUtilityLog SQLDBUtilityLog 3 0000000260f51db4:0 2021-07-19 11:45:33 Unable to load dictionary data.

SQLDBUtilityLog SQLDBUtilityLog 3 0000000260f51db4:0 2021-07-19 11:45:33 Error in DDLDictStartApis function..

GenericLog GenericError 1 0000000260f51db4:0 2021-07-19 11:45:33 (logapi.cpp (184) err=1 sys=2) SBL-GEN-00001: (logapi.cpp: 184) error code = 1, system error = 2, msg1 = (null), msg2 = (null), msg3 = (null), msg4 = (null)

When trying to do a FullPublish, in siebdev.log:

ObjMgrBusCompLog Error 1 0000000260f03d3c:0 2021-07-15 11:07:10 (oracon.cpp (5001)) SBL-DBC-00111: An error has occurred writing to a record.

Please continue or ask your systems administrator to check your application configuration if the problem persists.

SQLParseAndExecute Execute 5 0000000260f03d3c:0 2021-07-15 11:07:10 ORA-00904: "T4"."MODE_CD": invalid identifier

 

 

Changes

 

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.