P6 Web Services Randomly Times Out (Doc ID 2774027.1)

Last updated on NOVEMBER 17, 2022

Applies to:

Symptoms

When attempting to run a custom integration that uses P6 Web Services it suddenly becomes very slow for all requests. There are many timeouts. Errors like the following can be found in the P6 Web Services WebLogic logs even though the queries run very fast when run directly against the database.

ERROR
-----------------------

com.ctc.wstx.exc.WstxIOException: An established connection was aborted by the software in your host machine

Exception caught in CRUD Provider:
com.primavera.bo.base.DBEngineException: DBEngine.executeSelect: {SELECT TOP 10000001 sumtask.restart_date RemainingStart,sumtask.act_start_date ActualStart,project.plan_start_date ProjectPlannedStart,projwbs.proj_node_flag ProjectFlag,project.project_flag ProjectProjectFlag,sumtask.active_cnt + sumtask.complete_cnt + sumtask.notstarted_cnt ActivityCount,projwbs.anticip_start_date AnticipatedStart,projwbs.wbs_id WbsId,projwbs.proj_id ProjectId,projwbs.phase_id PhaseId,projwbs.obs_id ObsId,sumtask.reend_date RemainingFinish,sumtask.act_end_date ActualFinish,projwbs.anticip_end_date AnticipatedFinish,Case When project.orig_proj_id = project.proj_id Then 'Y' Else 'N' End IsScenario,projwbs.wbs_short_name ShortName,projwbs.parent_wbs_id ParentWbsId,projwbs.wbs_name Name FROM project,projwbs LEFT OUTER JOIN sumtask ON projwbs.wbs_id=sumtask.wbs_id WHERE projwbs.proj_id=project.proj_id AND projwbs.proj_id = '1234' AND projwbs.proj_node_flag = 'N' AND Case When project.orig_proj_id = project.proj_id Then 'Y' Else 'N' End = 'N' order by projwbs.wbs_id asc}

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.