My Oracle Support Banner

When Using P6 Web Services or the Primavera Integration API to Export or Read Activties a Very Large Query Is Generated and the Error "Connection Has Been Recycled" Occurs (Doc ID 2578499.1)

Last updated on AUGUST 21, 2019

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 16.2.0.0 to 17.12.10.0 [Release 16.2 to 17.12]
Primavera P6 Professional Project Management - Version 16.2.0.0 to 17.12.10.0 [Release 16.2 to 17.12]
Primavera Web Services - Version 16.2.0.0 to 17.12.10.0 [Release 16.2 to 17.12]
Information in this document applies to any platform.

Symptoms

When attempting to export a project or read activities using the Primavera Integration API or Primavera Web Services,
the following error occurs.

ERROR
-----------------------
DBEngine.executeSelect: {SELECT task.task_id ActivityId,alias_task.task_id BLActivityId,task.task_code ActivityCode,alias_task.task_code BLActivityCode,task.target_start_date PlannedStart,task.target_end_date PlannedFinish,task.act_end_date ActualFinish,task.reend_date RemainingFinish,task.status_code ActivityStatus,task.cstr_type ConstraintType,task.cstr_type2 ConstraintType2,task.external_late_end_date ExternalLateFinishDate,task.clndr_id CalendarId,task.suspend_date SuspendDate,task.resume_date ResumeDate,task.target_work_qty PlannedLaborUnits,task.proj_id ProjectId,project.def_cost_per_qty DefaultPricePerTime,task.task_type ActivityType,task.remain_work_qty RemainingLaborUnits,task.remain_equip_qty RemainingNonLaborUnits,task.target_equip_qty PlannedNonLaborUnits,task.act_work_qty ActualLaborUnits,task.act_equip_qty ActualNonLaborUnits,task.target_drtn_hr_cnt PlannedDuration,task.act_start_date ActualStart,project.plan_start_date ProjectPlannedStart,project.last_recalc_date
ProjectRemainingStart,task.restart_date RemainingStart,task.total_float_hr_cnt TotalFloat,task.remain_drtn_hr_cnt RemainingDuration,task.free_float_hr_cnt FreeFloat,task.early_end_date EarlyFinish,task.early_start_date EarlyStart,task.late_end_date LateFinish,task.late_start_date LateStart,task.act_work_qty + task.act_equip_qty
ActualUnits,task.remain_work_qty + task.remain_equip_qty RemainingUnits,task.complete_pct_type PercentCompleteType,task.phys_complete_pct DBPhysicalPercentComplete,project.step_complete_flag ProjectPhysicalPctCptUseSteps FROM project,task,task alias_task WHERE task.proj_id=project.proj_id AND
(task.task_code=alias_task.task_code) AND (((alias_task.task_id IN (
)))}
Connection has been recycled.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the following code that makes the call through the API:

"ByteArrayOutputStream os = new ByteArrayOutputStream();
com.primavera.integration.client.xml.xmlexporter.XMLExporter exporter = new com.primavera.integration.client.xml.xmlexporter.XMLExporter(this.getSession());
exporter.exportFullProject(os, projectObjId, com.primavera.integration.client.bo.object.Project.getAllFields());


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.