Symptom
- 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"
Environment
- SAP Crystal Reports 2013
- SAP Crystal Reports 2016
- SAP Crystal Reports 2020
Cause
- Default time out for XML Web service connection is one minute (60000 milliseconds)
Resolution
- 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
Keywords
CR, timeout , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To