My Oracle Support Banner

11g E-Business Suite BI Publisher Report Time Out At 600 Seconds Due To "SQL Query Timeout Time = 3600 Seconds" In The Data Model Options Whereas Log Shows Configuration File (XDO.cfg) Setting For Parameter "max_online_sql_timeout_limit" As 600 Seconds (Doc ID 2187539.1)

Last updated on FEBRUARY 11, 2019

Applies to:

BI Publisher (formerly XML Publisher) - Version 11.1.1.7.x to 11.1.1.9.x [Release 11.1]
Information in this document applies to any platform.

Symptoms

E-Business Suite R12 BI Publisher, Enterprise Administration System Configuration related issues

 

 

 

 

 

Long running E-Business Suite 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.

Note:

Note intended for Fusion Apps (SaaS).

Changes

 NA

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
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.