SAP Knowledge Base Article - Public

1324119 - NoError exception when passing a recordset to a sub-report

Symptom

Passing a recordset to a sub-report before passing a recordset to the main report throws the error:
com.crystaldecisions.sdk.occa.report.lib.ReportSDKException:NoError.----Error code:-2147483648 Error code name:failed

Reproducing the Issue

  1. Create a report with a sub-report
  2. Pass a resultset to the sub-report before passing a resultset to the main report

Cause

In previous versions of Crystal Reports, reports were not verified when passing resultsets.  This was changed in CR Server XI R2 and CR Server 2008.  So when a recordset is passed to the sub-report, the main report is verified, which causes the error to be thrown.

Resolution

  1. Find the file clientSDKOptions.xml.  It will usually be located in the folder c:\program files\Business Objects\common\4.0\java\lib of a default Enterprise Install.
  2. Edit it and change the value of the tag <VerifyDatabaseOnSetDataSource> from "true" to "false".
  3. Copy the clientSDKOptions.xml file into the classes folder of your java application (Or into a location which will cause it to be loaded by your app server).
  4. Restart your application server.

Keywords

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

Product

Crystal Reports Server 2008 V0, OEM edition ; Crystal Reports Server XI R2, OEM edition