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:

Symptoms

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=18.8.12.33012, 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.

Changes

Cause