Exceed the execution time more than 500 seconds

Bilal Ahmed

Organization Name

Quaid-e-azam Thermal Power (Pvt) Limited

Description

We want  to exceed the execution time more than 500 seconds so that report can show output without any exception.

My Bi Publisher Report shows output for transactional data and also we are trying to execute with dates for more than year in parameters but it shows exception with error user requested cancel operation.

Use Case and Business Need

Use Case:

Critical Bi Publisher report with complex sql query used in its data model as per the requirement of business end user.

Business Need:

Output of this custom report shows to much lag and if we generate its output for a year in its date parameter we are facing exception with error User requested cancel operation.

Original Idea Number: 7d55de92d9

Bilal Ahmed

After scheduling report Report status for Job is failed

Status : Job was failed.
JOB_WAIT_TIME_SECONDS{0.7}::JOB_FETCH_TIME_MINUTES{30}::JOB_EXECUTION_TIME_MINUTES{30}::JOB_PRIORITY_COLON_NORMAL::SQL query time exceeds the limit (1800 sec). Stopped processing.::[INSTANCE_ID=bip.bi_server1]