Skip to Content

Free-hand SQL connection timeout

Jan 20, 2017 at 03:38 PM


avatar image

We experience a timeout on Free-hand SQL reports of 10 minutes in BO 4.2 SP3. Can somebody tell me if this can be changed?

This occurs on scheduled reports also, so it is not a HTML timeout. It works fine in a Deski, XI 3 report on the same database, so it is not a database timeout.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Jan 20, 2017 at 04:02 PM

check this sap note.There are some timeout issues in BI 4.2 SP03.

2366194 - Refreshing a Web Intelligence report returns Partial Results after 10 minutes (600 seconds) after updating to SAP BusinessObjects Business Intelligence platform 4.2 Support Package 03

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Amit,

Thanks fot the response, sorry for the late reaction. It turns out there is a parameter in the SBO files we had to switch off, called "Query TimeOut Available".

600 Seconds is the default timeout and can be changed in universes, but for FHSQL it cannot be changed.

So switching off the timeout for the entire system was the only option.