My Oracle Support Banner

ERROR: Key: 2,1 missing required related object UserDefinedFieldId. When Attempting to Import XML File to P6 Professional (Doc ID 2595156.1)

Last updated on SEPTEMBER 09, 2020

Applies to:

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


When attempting to import XML file to P6 Professional,
the following error occurs.

Primavera.Domain.Base.UserDefinedFieldValue: Key: 2,1 missing required related object UserDefinedFieldId. Rejecting
UserDefinedFieldValue 'Primavera.Domain.Base.UserDefinedFieldValue: Key: 2,1' not imported
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=, 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 issue can be reproduced at will with the following steps:

  1. File --> Import --> XML
  2. Select the XML file and complete the import wizard
  3. After some time the process fails with a link to the log file
  4. Error appears in the log file




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

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