UDF Data Is Not Included When Exporting a Project to MS Project XML Format (Doc ID 2300661.1)

Last updated on SEPTEMBER 05, 2017

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 8.4.0.0 to 15.1.5.0 [Release 8.4 to 15.1]
Primavera P6 Enterprise Project Portfolio Management - Version 15.2.0.0 to 15.2.0.0 [Release 15.2]
Information in this document applies to any platform.

Symptoms

When exporting projects to Microsoft Project 2010 XML format, User Defined Fields (UDFs) are not exported and the following error occurs in the P6WebAccess.html log file:

com.primavera.PhoenixException: DBEngine.executeSelect: {SELECT udftype.udf_type_name UDFTypeName,udftype.udf_type_label UDFTypeLabel FROM udftype WHERE (udftype.udf_type_name=user_field_129)}
null
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'user_field_129'

This issue can be reproduced at will with the following steps:
1. Create a new project.
2. Create a text UDF.
3. Add a new activity.
4. Enter the UDF field data.
5. Export the project to MS Project XML format.
6. Import file into MS Project
7. Note that UDF data is not exported.

Due to this issue, users cannot export UDF data in MS Project 2010 XML format.

Cause

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 hundreds of Community platforms