P6 Global Scheduled Services Are Stuck In A "Running" State
(Doc ID 1400104.1)
Last updated on FEBRUARY 15, 2023
Applies to:Primavera P6 Enterprise Project Portfolio Management - Version 188.8.131.52 and later
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 184.108.40.206 and later
Information in this document applies to any platform.
Edited global data is not updated in reports run from P6 Web or BI Publisher directly. For example, updated Resource Code Assignments are not displaying in the report output.
Execute the query below as the schema owner (default admuser for Oracle, sa for SQL Server) to determine which Global Scheduled Services are stuck in a JS_Running state:
SELECT job_id, job_type, status_code, last_run_date FROM JOBSVC WHERE job_type = 'JT_EnterpriseData' or job_type = 'JT_Security' or job_type = 'JT_EnterpriseSum' or job_type = 'JT_ResourceMgmt';
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