After Changing Passwords for Each Database in an Instance, the Job Services No Longer Function and All Jobs Are Stuck in a Pending State

(Doc ID 2401371.1)

Last updated on JUNE 14, 2018

Applies to:

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

Symptoms

ACTUAL BEHAVIOR

After changing the passwords on the database, the p6ws deployment is in a failed state and job services will not run for that database.

EXPECTED BEHAVIOR

The p6ws deployment to be in an active state and jobs will finish.

STEPS

The issue can be reproduced at will with the following steps:
1. Schedule a job in P6 (example open the client and do a copy paste operation)
2. See the job is pending indefinitely
3. Check p6ws in the Weblogic Console and see it is in a Failed state

BUSINESS IMPACT

The issue has the following business impact:
Due to this issue, users cannot run jobs in P6 Professional.

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