1283126 - Error: “Impossible to extract data from the databases”

SAP Knowledge Base Article - Public

1283126 - Error: “Impossible to extract data from the databases”

Symptom

  • Error: “Impossible to extract data from the databases”
  • Report crashed when number of rows retrieved is more than 3867
  • Report crashed through a JRC application displaying a report that extracts more than 3867 rows

Reproducing the Issue

Environment information
  • Windows 2003 (x86) Server SP1
  • Crystal Report XI R2 SP4
      To reproduce the issue:
·        Generate a report through a designer using a java bean connectivity that returns more than 3867
·        Integrate the following snippet code to your JRC application in order to display the report:
                                 //Open report.ReportClientDocument reportClientDoc = new ReportClientDocument();            
                                 reportClientDoc.open(REPORT_NAME, 0);                    
                               //Store the report source in session will be used by the CrystalReportViewer.                 
                               session.setAttribute("reportSource", reportClientDoc.getReportSource());               
                             //Launch CrystalReportViewer page that contains the report viewer.                         
                                response.sendRedirect("CrystalReportViewer.jsp"); 
                         For more information about implementing and deploying JRC application, refer to the topic named “Java Reporting Component Software Development Kit” in the DevLibrary:
                          http://devlibrary.businessobjects.com/BusinessObjectsXIR2SP2/en/devsuite.htm
·        Run the JRC application and Error: “Impossible to extract data from the databases” occurs.
 

Resolution

To resolve the issue, set the value of the JVMMaxHeap parameter in the CRConfig.xml file located at: “C:\Program Files\Business Objects\Common\3.5\java” to 256MB

 

For more information about the parameters in the CRConfig.xml, refer to the following link:

http://devlibrary.businessobjects.com/BusinessObjectsXIR2SP2/en/en/JRC_SDK/jrc_java_dg_doc/doc/jrcsdk_java_dg/CRDBJavaServer_Ref2.html#60055

Keywords

KBA , BI-DEV-JAV , BI Software Development Kits (SDKs) - Java , Problem

Product

SAP Crystal Reports XI R2