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
- Create a report with a sub-report
- 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
- 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.
- Edit it and change the value of the tag <VerifyDatabaseOnSetDataSource> from "true" to "false".
- 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).
- 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