SAP Knowledge Base Article - Public

2085892 - Error: "Failed to Retrieve data from database" while refreshing a report based on XML

Symptom

  • Error: "Failed to retreive data from Database"
  • In Crystal Reports, when trying to refresh a report based on XML, the following error occurs:
    "Failed to retreive data from Database"

Environment

  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013

Reproducing the Issue

  1. Launch Crystal Reports designer
  2. Create a new report based on XML with large data using the XML and Webservices connection
  3. Refresh the report, you will receive the error.

Resolution

  1. Navigate to the location of CRConfig.xml file, by Default: C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\java\ 
  2. Open the CRConfig.xml file in Notepad 
  3. Modify and Set the JVMMaxHeap with the following value instead of default value:
    <JVMMaxHeap>512000000</JVMMaxHeap>
  4. Also, Set the JVMMinHeap with the following value instead of default value:
    <JVMMinHeap>256000000</JVMMinHeap>
  5. Save the CRConfig.xml file
  6. Close Crystal Reports designer and launch it again
  7. Refresh the report, it will work fine

Keywords

failed to retreive data, crystal report, cr, xml, javaheap, jvm , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

SAP Crystal Reports 2011 ; SAP Crystal Reports 2011, feature pack 03 ; SAP Crystal Reports 2013