My Oracle Support Banner

XML Export Fails With Error 'Severe: DBEngine.executeSelect (complex SELECT statement) null' (Doc ID 2240856.1)

Last updated on FEBRUARY 15, 2019

Applies to:

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


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

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}


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

  1. Login to P6.
  2. Export the project to Primavera XML format.
  3. Note the reported error in the log.


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.