My Oracle Support Banner

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

Last updated on DECEMBER 13, 2018

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

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