Publish Audit Data Fails with 'Executing: px_audit_demand [1] CORE(BRE): Connection has been recycled' after Upgrade to 24.12 on Oracle Database
(Doc ID 3068964.1)
Last updated on MARCH 19, 2025
Applies to:
Primavera P6 Enterprise Project Portfolio Management - Version 24.12 to 24.12.1.0 [Release 24.12]Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 25.1 to 25.1 [Release 25.1]
Information in this document applies to any platform.
Symptoms
After upgrade to 24.12, 24.12.1, or 25.1 on Oracle database, the Publish Audi Data job is failing. The Publish Audit job log will show the following exception (typically after 1 hour).
2025-01-22 14:00:07:[SERVICE]:[PxService]: Creating Px service task(s)...
2025-01-22 14:00:07:[TASK]:[PxAuditServiceTaskImpl]: [1] CORE(BRE): Executing: px_audit_demand...
[1] CORE(BRE): Connection has been recycled. Database: XXXXXXXX, Pool: PML, Id: 3011
2025-01-22 15:00:07:[SERVICE]:[PxProject]: CORE - Creating/Submitting Px service task (1/1) (PxProject)...
2025-01-22 15:00:07:[TASK]:[PxProject]: Task started[1970-01-01 00:00:00]
2025-01-22 15:00:07:[TASK]:[PxProject]: Task completed[1970-01-01 00:00:00]
2025-01-22 15:00:07:[SERVICE]:[PxService]: Job End Time: 2025-01-22 15:00:07
2025-01-22 15:00:07:[SERVICE]:[PxService]: Job Elapsed Time: 01:00:00.009
Job Status: Failed
2025-01-22 15:00:07:[SERVICE]:[PxService]: END: Px Service Job
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! |