How To Identify And Remove Jobs That Are Stuck In A "Running" State In Pre-8.x Job Services (Doc ID 1929891.1)

Last updated on JULY 05, 2016

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 6.2.1 to 7.0 SP5 [Release 6.2 to 7.0]
Information in this document applies to any platform.

Symptoms

On: P6 Scheduled Services and Pre-R8.x Job Services,

Job Service job has not completed in from a certain period of time although it was schedule to do so.

If you run the query below while the Job Service process is not started it will still return results:

 SELECT job_id, job_type, status_code, last_run_date FROM JOBSVC where status_code='JS_Running';

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