My Oracle Support Banner

Error: An Exception Occurred While Initializing Module 'CommandLineModule' When Importing Oracle Primavera Cloud (OPC) XML to P6 PPM DB (Doc ID 2721338.1)

Last updated on OCTOBER 19, 2020

Applies to:

Primavera P6 Professional Project Management - Version 18.8.17.0 and later
Information in this document applies to any platform.

Symptoms

Error: An exception occurred while initializing module 'CommandLineModule' when Importing OPC XML.

Getting the following Error when trying to Import OPC P6 XML file in P6:

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.17.34489, 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.
  at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
  at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
  at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
  at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
  at System.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader(Boolean isInternal, Boolean forDescribeParameterEncryption)
  at System.Data.SqlClient.SqlCommand.InternalEndExecuteNonQuery(IAsyncResult asyncResult, String endMethod, Boolean isInternal)
  at System.Data.SqlClient.SqlCommand.EndExecut

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Try to Import P6 XML created from OPC.

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


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