Error 'ORA-12899: value too large for column' or 'String or binary data would be truncated' When Importing a Microsoft Project XML Document
(Doc ID 2523351.1)
Last updated on MARCH 22, 2022
Applies to:Primavera P6 Enterprise Project Portfolio Management - Version 220.127.116.11 and later
Information in this document applies to any platform.
When attempting to MS PRoject XML Files fails to import with the following error:
Microsoft SQL Server database:
Prism.Modularity.ModuleInitializeException: An exception occurred while initializing module 'CommandLineModule'.
- The exception message was: One or more errors occurred.
- The Assembly that the module was trying to be loaded from was:Primavera.Mercury.CommandLineModule, Version=18.104.22.168254, Culture=neutral, PublicKeyToken=null
Check the InnerException property of the exception for more information. If the exception occurred while creating an object in a DI container, you can exception.GetRootException() to help locate the root cause of the problem.
---> System.AggregateException: One or more errors occurred. ---> System.Exception: Exception while commiting the changes to the database.
String or binary data would be truncated.
The statement has been terminated. ---> System.Data.SqlClient.SqlException: String or binary data would be truncated.
The statement has been terminated.
ORA-12899: value too large for column "ADMUSER"."PROJECT"."PROJ_SHORT_NAME" (actual: 47, maximum: 40) ---> Oracle.ManagedDataAccess.Client.OracleException: ORA-12899: value too large for column "ADMUSER"."PROJECT"."PROJ_SHORT_NAME" (actual: 47, maximum: 40)
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!