Error: " PRMDB-3660-4 PRM DBAcess Error: ORA-00913: too many values" When Importing XER into P6 Professional
(Doc ID 2106112.1)
Last updated on MARCH 20, 2024
Applies to:
Primavera P6 Professional Project Management - Version 15.2.2.0 to 16.1.0.0 [Release 15.2 to 16.1]Primavera P6 Enterprise Project Portfolio Management - Version 15.2.2.0 to 16.1.0.0 [Release 15.2 to 16.1]
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 15.2.2.0 to 16.1.0.0 [Release 15.2 to 16.1]
Information in this document applies to any platform.
Symptoms
When attempting to import an XER into P6 Professional, the following error occurs and the import fails:
EprmDBSQLExecutionFailure
PRMDB-3660-4
PRM DBAcess Error: ORA-00913: too many values
OR
Event Code: PRMDB-0271-D
Message: PRM DBAccess Error: SQL State: 1, SQL Error Code: 110, Level: 15, Procedure: , Line: 1
There are fewer columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the number of
columns specified in the INSERT statement.
OR
Event Code: PRMDB-0652-E
Message:
PRM DBAccess Error: SQL State: 1, SQL Error Code: 3621, Level: 0, Procedure: , Line: 2
The statement has been terminated.
SQL State: 14, SQL Error Code: 8152, Level: 16, Procedure: , Line: 2
String or binary data would be truncated.
SQL State: 1, SQL Error Code: 3621, Level: 0, Procedure: , Line: 1
The statement has been terminated.
SQL State: 14, SQL Error Code: 8152, Level: 16, Procedure: , Line: 1
String or binary data would be truncated.
OR
Event Code: PRMDB-1480-A
Message:
PRM DBAccess Error: SQL State: 1, SQL Error Code: 3621,
Level: 0, Procedure: , Line: 50
The statement has been terminated.
SQL State: 1, SQL Error Code: 547, Level: 16, Procedure: , Line: 50
The INSERT statement conflicted with the FOREIGN KEY constraint "fk_udfvalue_udftype". The conflict occurred in database "PMDB", table "dbo.UDFTYPE", column 'udf_type_id'.
SQL State: 1, SQL Error Code: 3621, Level: 0, Procedure: , Line: 49
The statement has been terminated.
SQL State: 1, SQL Error Code: 547, Level: 16, Procedure: , Line: 49
The INSERT statement conflicted with the FOREIGN KEY
constraint "fk_udfvalue_udftype". The conflict occurred in database "PMDB", table "dbo.UDFTYPE", column 'udf_type_id'.
SQL State: 1, SQL Error Code: 3621, Level: 0, Procedure: , Line: 48
The statement has been terminated.
SQL State: 1, SQL Error Code: 547, Level: 16, Procedure: , Line: 48
The INSERT statement conflicted with the FOREIGN KEY constraint "fk_udfvalue_udftype". The conflict occurred in database "PMDB", table "dbo.UDFTYPE", column 'udf_type_id'.
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 |