Query timeout expired

building reports crystal reports
1

Hi CRE Gurus!

I’m having problems with certain CRE 4.1 reports which throws an error (below) and would like to seek your help.

The database returned the following error: [Microsoft][ODBC SQL Server Driver]Query timeout expired[CrystalCommonRCI.RCI_REPLACEMENT_STRING]
---- Error code:0 [CRWEB00000119]

NOTES:

-This happens on the 10th minute that the report is running.
-Error occurs when ran in LaunchPad/CMC/Scheduled
-This report is rather large and usually runs for 4 hours but we also have -reports that runs for hours (2 or more) but does not get any errors.
-Tried setting the “Remote Server Connection” settings of the DB to 0 (zero) for unlimited timeout time.
-updated the timeout settings of some services in CMC related to -sessions/connections and Crystal Reports
-Restarted the services already

Hope you can help me. :slight_smile:

jvmauricio :philippines: (BOB member since 2009-08-03)

2

Is this report based on a universe? If so, what is the query timeout set to in the universe?

-Dell

hilfy :us: (BOB member since 2007-04-16)

3

Hi Dell,

No universe. only a direct connection from SQL Server.

Thanks!
John

jvmauricio :philippines: (BOB member since 2009-08-03)

4

Hey guys,

I found the solution to this problem by updating the SBO files of the connection being used.

  1. Make a backup Copy and Edit the sqlsrv.sbo file located in “C:\Program Files (x86)\SAP BusinessObjects\BusinessObjects Enterprise XI4.0\dataAccess\connectionServer” in a default BI4 installation. 

  2. Change the parameter named “Query TimeOut Available” to False as below

False

  1. Restart the SIA 

Hope this helps.

Thanks!
John

jvmauricio :philippines: (BOB member since 2009-08-03)