Error 'ORA-01438: value larger than specified precision allowed for this column' or 'Arithmetic overflow error converting numeric to data type numeric' When Importing a XER Project
(Doc ID 2992035.1)
Last updated on DECEMBER 14, 2023
Applies to:
Primavera P6 Enterprise Project Portfolio Management - Version 22.12 and laterPrimavera P6 Professional Project Management - Version 22.12 and later
Information in this document applies to any platform.
Symptoms
When attempting to import an XER project in P6 Professional the following error occurs:
Microsoft SQL Server database:
Import Failed: PRM DBAccess Error: SQL State: 1, SQL Error Code: 3621, Level: 0, Procedure: , Line: XX
The statement has been terminated.
SQL State: 8, SQL Error Code: 8115, Level: 16, Procedure: , Line: XX
Arithmetic overflow error converting numeric to data type numeric.
Oracle database:
PRM DBAccess Error: ORA-01438: value larger than specified precision allowed for this column
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 |
Cause |
Solution |
References |