Query Execution On WBSSPREAD During Project Publication Can Take A Long Time To Complete (Doc ID 1600187.1)

Last updated on JUNE 29, 2016

Applies to:

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

Symptoms

During project publication, the process either fails inserting/updating data into WBSSPREAD with error "ORA-01013" after it reaches [NNN] minutes, where [NNN] is the value set under Thread Pool > Maximum Long Running Task Duration (as well as the Long Running Connection Pool, Maximum Lease Duration), or takes a abnormally long time to complete when inserting/updating into the WBSSPREAD table after increasing the thread pool and long running task duration maximum lease duration values.

Publish Project Log:
---------------------
2013-11-07 17:14:56:[TASK]:[PxWbsSpread]: [43] POST(SQL): ORA-01013


Oracle Database Alertlog Entries shows:
---------------------------------
ORA-01555 caused by SQL statement below (SQL ID: 5n1zan5dzybhx, Query Duration=4475 sec, SCN: 0x0b3e.fb7faa7b):
INSERT INTO WBSSPREAD (OBJECTID ,PROJECTOBJECTID ,PARENTOBJECTID ,CODE ,NAME ,OBSOBJECTID ,OBSNAME ,STARTDATE ,ENDDATE ,ACTUALLABORUNITS ,ACTUALNONLABORUNITS ,ATCOMPLETIONLABORUNITS ,ATCOMPLETIONNONLABORUNITS ,BASELINEPLANNEDLABORUNITS ,BASELINEPLANNEDNONLABORUNITS ,EARNEDVALUELABORUNITS ,ESTIMATEATCOMPLETIONLABORUNITS ,ESTIMATETOCOMPLETELABORUNITS ,PLANNEDLABORUNITS ,PLANNEDNONLABORUNITS ,PLANNEDVALUELABORUNITS ,REMAININGLABORUNITS ,REMAININGNONLABORUNITS ,ACTUALCOST ,ACTUALEXPENSECOST ,ACTUALLABORCOST ,ACTUALMATERIALCOST ,ACTUALNONLABORCOST ,ACTUALTOTALCOST ,ATCOMPLETIONEXPENSECOST ,ATCOMPLETIONLABORCOST ,ATCOMPLETIONMATERIALCOST ,ATCOMPLETIONNONLABORCOST ,ATCOMPLETIONTOTALCOST ,BASELINEPLANNEDEXPENSECOST ,BASELINEPLANNEDLABORCOST ,BASELINEPLANNEDMATERIALCOST ,BASELINEPLANNEDNONLABORCOST ,BASELINEPLANNEDTOTALCOST ,EARNEDVALUECOST ,ESTIMATEATCOMPLETIONCOST ,ESTIMATETOCOMPLETECOST ,PLANNEDEXPENSECOST ,PLANNEDLABORCOST ,PLANNEDMATERIALCOST ,PLANNEDNONLABORCOST ,PLANNEDTOTALCOST ,PLANNEDVALUECOST ,REMAININGEXPE
INSERT INTO WBSSPREAD (OBJECTID ,PROJECTOBJECTID ,PARENTOBJECTID ,CODE ,NAME ,OBSOBJECTID ,OBSNAME ,STARTDATE ,ENDDATE ,ACTUALLABORUNITS ,ACTUALNONLABORUNITS ,ATCOMPLETIONLABORUNITS ,ATCOMPLETIONNONLABORUNITS ,BASELINEPLANNEDLABORUNITS ,BASELINEPLANNEDNONLABORUNITS ,EARNEDVALUELABORUNITS ,ESTIMATEATCOMPLETIONLABORUNITS ,ESTIMATETOCOMPLETELABORUNITS ,PLANNEDLABORUNITS ,PLANNEDNONLABORUNITS ,PLANNEDVALUELABORUNITS ,REMAININGLABORUNITS ,REMAININGNONLABORUNITS ,ACTUALCOST ,ACTUALEXPENSECOST ,ACTUALLABORCOST ,ACTUALMATERIALCOST ,ACTUALNONLABORCOST ,ACTUALTOTALCOST ,ATCOMPLETIONEXPENSECOST ,ATCOMPLETIONLABORCOST ,ATCOMPLETIONMATERIALCOST ,ATCOMPLETIONNONLABORCOST ,ATCOMPLETIONTOTALCOST ,BASELINEPLANNEDEXPENSECOST ,BASELINEPLANNEDLABORCOST ,BASELINEPLANNEDMATERIALCOST ,BASELINEPLANNEDNONLABORCOST ,BASELINEPLANNEDTOTALCOST ,EARNEDVALUECOST ,ESTIMATEATCOMPLETIONCOST ,ESTIMATETOCOMPLETECOST ,PLANNEDEXPENSECOST ,PLANNEDLABORCOST ,PLANNEDMATERIALCOST ,PLANNEDNONLABORCOST ,PLANNEDTOTALCOST ,PLANNEDVALUECOST ,REMAININGEXPET...

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