My Oracle Support Banner

P6 Global Scheduled Services Are Stuck In A "Running" State (Doc ID 1400104.1)

Last updated on AUGUST 09, 2024

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 8.1.1.0 and later
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 8.2.4.0 and later
Information in this document applies to any platform.

Symptoms

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';

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


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