My Oracle Support Banner

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 19, 2020

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 18.8.5.0 and later
Information in this document applies to any platform.

Symptoms

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.8.0.29254, 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.

Oracle database:

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)

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!


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