SAP Knowledge Base Article - Public

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

Symptom

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

     "Failed to retrieve dada 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:
    1.  Find the CRConfig.xml file. On Windows, it's by default located at:                                                              
                                                                                                                                         
          C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\java                                                         
        
    2. Make a backup of the CRConfig.xml file.
         
    3. 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>                                         
         
    4. 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

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

Product

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