1487766 - How to increase Time Out for Crystal Reports to web services connection?

Some reports connecting to web services from Crystal Reports generates the following errors:

"Failed to retrieve data from the database."

Followed by

"Cannot determine the queries necessary to get data for this report. Details: Cannot access web service
Read timed out"

Default time out for XML Web service connection is one minute (60000 milliseconds)

To increase the time out, update the option: SocketTimeOut in the CRConfig.xml file:

Navigate to the CRConfig.xml file. By default, it is located at:

C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\java
Make a backup of the CRConfig.xml file.
Open the CRConfig.xml file with a text editor. Near the bottom, you will find:

<XML>
<CacheRowSetSize>100</CacheRowSetSize>
<PreReadNBytes>4096</PreReadNBytes>
<XMLLocalURL></XMLLocalURL>
<SchemaLocalURL></SchemaLocalURL>
<XMLHttpURL></XMLHttpURL>
<SchemaHttpURL></SchemaHTTPURL>
</XML>
Modify the above by adding the SocketTimeout tag, in the XML section:
<XML>
<CacheRowSetSize>100</CacheRowSetSize>
<PreReadNBytes>4096</PreReadNBytes>
<XMLLocalURL></XMLLocalURL>
<SchemaLocalURL></SchemaLocalURL>
<XMLHttpURL></XMLHttpURL>
<SchemaHttpURL></SchemaHTTPURL>
<SocketTimeout>120000</SocketTimeout>
</XML>

Notes:
The "SocketTimeout" controls the timeout between the Server and the Web Service data source.
The default is 60000 milliseconds, or 1 minute.
If you set it to 120000, then that doubles it to 2 minutes.
You may need to increase it to even a bigger value, say 480000, which is 8minutes.

For Unix environment the CRConfig.xml location is: $BOBJEDIR/java/CRConfig.xml

CR, timeout , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To

SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020