SAP Knowledge Base Article - Public

1363251 - Database Connector Error: Unexpected Error, when attempting to view the tables in Crystal Reports


  • Database Connector Error:  "Unexpected Error".
  • Able to connect to, but unable to see the tables.
  • When connecting to from Crystal Reports, and trying to expand the connection to see the tables, it generate the error:
    "Database Connector Error:  'Unexpected Error' "


  • Crystal Reports 2008
  • SAP Crystal Reports 2011

Reproducing the Issue

  1. In Crystal Reports, create a new report and connect with
  2. When browsing tables no tables are displayed to create a new report, and it generates an error.


  • A large number of tables and stored procedures causes the java driver to error out due to lack of memory allocated for the driver.


  • Increase the memory allocated for the driver:
    1. Open the crconfig.xml file located at: C:Program Files\Business Objects\common\4.0\java
    2. Browse to the line <JVMMaxHeap>64000000</JVMMaxHeap>
    3. Modify the number 64000000 to 128000000
    4. Save the file.


SForce, CR , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem


Crystal Reports 2008 V1 ; SAP Crystal Reports 2011