Symptom
After upgrading from XI R3 or XI R2 to BOE Enterprise 4.0 or BOE Enterprise 4.1, setting the database logon information on the main report no longer propagates to the sub-reports.
This may cause a logon prompt to appear for every sub-report, or if using Oracle ODBC, you will see the error:
com.crystaldecisions.sdk.occa.report.lib.ReportSDKException:Can not create temp file---- Error code:-2147215357 [CRSDK00000615] Error code name:internal
Environment
- SAP BusinessObjects Business Intelligence platform 4.0
- SAP BusinessObjects Business Intelligence platform 4.1
Cause
As of BOE Enteprise 4.0, database logon information is no longer propagated to sub-reports, it needs to be set explicitly.
Resolution
Use the following code to set database logon:
ConnectionInfos boConnectionInfos = rcd.getDatabaseController().getConnectionInfos(null);
for (IConnectionInfo boConnectionInfo : boConnectionInfos) {
foreach (IConnectionInfo boConnectionInfo in boConnectionInfos) {
boConnectionInfo.setUserName("userName");
boConnectionInfo.setPassword("Password");
}
rcd.getDatabaseController().setConnectionInfos(boConnectionInfos);
Keywords
database logon subreport controller CRSDK00000615 2147215357 -2147215357 RAS , KBA , BI-DEV-JAV , BI Software Development Kits (SDKs) - Java , Problem