2335332 - Reports with Subreports don't work after upgrading to BI 4.0 or BI 4.1 in a custom app

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

• SAP BusinessObjects Business Intelligence platform 4.0
• SAP BusinessObjects Business Intelligence platform 4.1

As of BOE Enteprise 4.0, database logon information is no longer propagated to sub-reports, it needs to be set explicitly.

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);

database logon subreport controller CRSDK00000615 2147215357 -2147215357 RAS , KBA , BI-DEV-JAV , BI Software Development Kits (SDKs) - Java , Problem