My Oracle Support Banner

XML Export Fails with Error Severe: DBEngine.executeSelect (Doc ID 2240856.1)

Last updated on SEPTEMBER 20, 2018

Applies to:

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

Symptoms

When attempting to export a project to Primavera XML format in the P6 Professional application, the following error occurs.


SEVERE: DBEngine.executeSelect: {SELECT * FROM (SELECT udfvalue.proj_id ProjectId,udfvalue.udf_text UDFText,udftype.logical_data_type UDFDataType,udfvalue.udf_date UDFEndDate,udfvalue.udf_number UDFCost,udfvalue.udf_number UDFNumber,udfvalue.udf_text UDFRAGType,udfvalue.udf_code_id UDFCodeId,udfvalue.udf_number UDFInteger,udfvalue.udf_date UDFStartDate,udftype.udf_type_label UDFTypeLabel,udfvalue.udf_type_id UDFTypeId,udftype.table_name UDFBusinessObjectType,udfvalue.fk_id ForeignKeyId,udfcode.short_name UDFCodeShortName FROM udfcode,udftype,udfvalue WHERE udfvalue.udf_code_id=udfcode.udf_code_id(+) AND udfvalue.udf_type_id=udftype.udf_type_id AND ((udfvalue.proj_id = 79275 OR (udftype.table_name = 'RSRC' AND udfvalue.fk_id IN(select distinct rsrc_id from TASKRSRC where proj_id = 79275))) AND udfvalue.udf_type_id != 3028) order by udfvalue.udf_type_id asc, udfvalue.fk_id asc) WHERE rownum <=1025}
null

 The issue can be reproduced at will with the following steps:

  1. Log in P6
  2. Export the project to Primavera XML format
  3. Note the error

Changes

 

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
Changes
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.