My Oracle Support Banner

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 29, 2019

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

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