BI Publisher Report Time Out At 600 Seconds After Setting The SQL Query Timeout Time = 3600 Seconds In The Data Model Options, Log Shows XDO.CFG Setting For Parameter max_online_sql_timeout_limit=600 (Doc ID 2187539.1)

Last updated on OCTOBER 04, 2016

Applies to:

BI Publisher (formerly XML Publisher) - Version 11.1.1.7.x and later
Information in this document applies to any platform.

Symptoms

BI Publisher 12.2 version, Enterprise Administration, System Configuration

 




Long running BI Publisher reports time out after 600 seconds, even after setting the "SQL Query Timeout" system property to 3600 seconds.


After recent patching or upgrades some larger BI Publisher reports begin to time out.

In the log you may see the parameter max_online_sql_timeout_limit = 600 causing the query to timeout.



The issue can be reproduced at will with the following steps:
1. Query the DATA MODEL and submit it to run.
2. After the specified timeout limit has reached, the issue is observed.



The issue has the following business impact:
Due to this issue, users cannot carry out their normal operations as per their business needs.

 

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