Error: "SQL Query Time Exceeds the Limit (600 Sec)" When Running P6 or Unifier Report in BI Publisher
(Doc ID 2750254.1)
Last updated on JANUARY 04, 2024
Applies to:
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 19.12 and laterPrimavera P6 Enterprise Project Portfolio Management - Version 19.12 and later
Primavera Unifier Cloud Service - Version 19.12 and later
Primavera Unifier - Version 19.12 and later
Information in this document applies to any platform.
Symptoms
ACTUAL BEHAVIOR
---------------
P6/Unifier reports in BI Publisher (BIP) are failing because they are reaching the 600 second timeout limit.
The following error occurs:
SQL Query Time Exceeds the Limit (600 Sec)
Note: User may also receive error XMLPGEN-03111 : user requested cancel operation when running report online within BIP UI rather than via Report Job.
EXPECTED BEHAVIOR
-----------------------
Reports should be running successfully and completing more quickly.
STEPS
-----------------------
- Schedule or run the report in BIP
- Report fails to run because it exceeds the 600 second timeout.
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 |