Skip to Content
avatar image
Former Member

Free-hand SQL connection timeout

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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.