Error during CDD schema creation: The command failed (0x8004f026) (Doc ID 1475099.1)

Last updated on AUGUST 18, 2015

Applies to:

Oracle Health Sciences InForm - Version 4.1.0 and later
Information in this document applies to any platform.
CDD/TDE

Symptoms

 Error from Event log:

Event Type: Error
Event Source: InForm - uda
Event Category: None
Event ID: 16389
Date:  12/07/2005
Time:  12:12:25
User:  N/A
Computer: <computer name>
Description:
The description for Event ID ( 16389 ) in Source ( InForm - uda ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: Action: Executing SQL statement
DSN: <cdd DSN>
Error: SQL Statement Error #1 State: 37000 Message: [Microsoft][ODBC driver for Oracle][Oracle]ORA-00972: identifier is too long
CODE: -1
SQL: CREATE INDEX XPKt_<index> ON t_<table> (<columns>) tablespace INFORM.

Error from Event log:

Event Type: Error
Event Source: InForm - uda
Event Category: None
Event ID: 16389
Date:  12/07/2005
Time:  12:12:32
User:  N/A
Computer: <computer name>
Description:
The description for Event ID ( 16389 ) in Source ( InForm - uda ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: Action: Executing SQL statement
DSN: <InForm>
Error: SQL Statement Error #1 State: 23000 Message: [Microsoft][ODBC driver for Oracle][Oracle]ORA-00001: unique constraint (INFORMADMIN.XPKPF_ITEMDATA) violated
CODE: -1
SQL: Insert into PF_ItemData (ENTEREDREASON, TRANSACTIONID, ENTEREDDATE, CALCULATEDTYPE, INVALIDATINGREVISIONNUMBER, ENTEREDBY, CONTEXTID, PREVIOUSAUDITORDER, AUDITORDER, SDV) VALUES (?,?,?,?,?,?,?,?,?,?).

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms