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 JUNE 15, 2022

Applies to:

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


When attempting to import a Primavera XML file into 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. In P6 Professional select File > Import... from the menu.
  2. Select the Primavera XML format and the desired file, then complete the import wizard.
  3. 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!

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