Publish Audit Data Fails with 'The query has timed out.'
(Doc ID 3053962.1)
Last updated on OCTOBER 29, 2024
Applies to:
Primavera P6 Enterprise Project Portfolio Management - Version 22.12.8.0 and laterInformation in this document applies to any platform.
Symptoms
Attempting to Publish Audit Data, the job fails with:
[1] CORE(BRE): Executing: px_audit_demand... [1] CORE(BRE): The query has timed out.
LOG FILE
========
2024-08-28 10:42:18:[SERVICE]:[PxService]: BEGIN: Px Service Job
2024-08-28 10:42:18:[SERVICE]:[PxService]: Job Id: 14812551
2024-08-28 10:42:18:[SERVICE]:[PxService]: Job Name: Copy of Publish Audit Data
2024-08-28 10:42:18:[SERVICE]:[PxService]: Job Type: Publish Audit Data (JT_AuditData)
2024-08-28 10:42:18:[SERVICE]:[PxService]: Job Start Time: 2024-08-28 10:42:18
2024-08-28 10:42:18:[SERVICE]:[PxService]: Initializing px service job...
2024-08-28 10:42:18:[SERVICE]:[PxService]: Px service (PRE) task count: 0
2024-08-28 10:42:18:[SERVICE]:[PxService]: Px service (CORE) task count: 1
2024-08-28 10:42:18:[SERVICE]:[PxService]: Px service (POST) task count: 0
2024-08-28 10:42:18:[SERVICE]:[PxService]: Creating Px service task(s)...
2024-08-28 10:42:18:[TASK]:[PxAuditServiceTaskImpl]: [1] CORE(BRE): Executing: px_audit_demand...
[1] CORE(BRE): The query has timed out.
2024-08-28 11:07:18:[SERVICE]:[PxProject]: CORE - Creating/Submitting Px service task (1/1) (PxProject)...
2024-08-28 11:07:18:[TASK]:[PxProject]: Task started[1969-12-31 18:00:00]
2024-08-28 11:07:18:[TASK]:[PxProject]: Task completed[1969-12-31 18:00:00]
2024-08-28 11:07:18:[SERVICE]:[PxService]: Job End Time: 2024-08-28 11:07:18
2024-08-28 11:07:18:[SERVICE]:[PxService]: Job Elapsed Time: 00:25:00.190
Job Status: Failed
2024-08-28 11:07:18:[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! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |