I upgraded Crystal Report Server Crystal Reports Server (Enterprise) XI R2 SP2 to Crystal Reports Server (Enterprise) XI R2 SP5.
Before Upgrade, Reports were generated properly, but after that, I got the following Error.
-
com.crystaldecisions.sdk.occa.report.lib.ReportSDKServerException: The table 'AP_GL_R216' could not be found.
Error in File C:\WINDOWS\TEMP\{325E2C60-E2FE-4E1B-9291-E607283AE07A}.rpt:
The table could not be found.---- Error code:-2147482939 Error code name:failed
at com.crystaldecisions.sdk.occa.report.lib.ReportSDKServerException.throwReportSDKServerException(Unknown Source)
at com.crystaldecisions.proxy.remoteagent.r.a(Unknown Source)
at com.crystaldecisions.sdk.occa.report.application.cd.a(Unknown Source)
at com.crystaldecisions.sdk.occa.report.application.z.a(Unknown Source)
at com.crystaldecisions.sdk.occa.report.application.ak.if(Unknown Source)
at com.crystaldecisions.sdk.occa.report.application.ad.int(Unknown Source)
at com.crystaldecisions.sdk.occa.report.application.bj.for(Unknown Source)
at com.crystaldecisions.proxy.remoteagent.u.a(Unknown Source)
at com.crystaldecisions.proxy.remoteagent.u.if(Unknown Source)
at com.crystaldecisions.sdk.occa.report.application.DatabaseController.if(Unknown Source)
at com.crystaldecisions.sdk.occa.report.application.DatabaseController.setTableLocation(Unknown Source)
at com.iflex.fcr.bh.reports.FCRJReporter.setReportDB(FCRJReporter.java:945)
-
FCRJReporter.setReportDB Code is as follows.
-
Table oldTable = (Table)tables.getTable(x);
Table newTable = (Table)tables.getTable(x);
//create a new ConnectionInfo object
ConnectionInfo conInfo = new ConnectionInfo();
conInfo.setKind( ConnectionInfoKind.from_int(5) );
conInfo.setUserName(db_username);
conInfo.setPassword(decrPassword);
//create a Property Bag for the Connection Info attributes
PropertyBag pBag = new PropertyBag();
// set the property bag values
pBag.putStringValue("QE_ServerDescription",serverName);
pBag.putStringValue("QE_SQLDB", "true");
pBag.putStringValue("QE_DatabaseType", "ODBC (RDO)");
pBag.putStringValue("QE_DatabaseName", "");
pBag.putStringValue("SSO Enabled", "false");
pBag.putStringValue("Database DLL", "crdb_odbc.dll");
// create a property bag for the 'QE_LogonProperties' key
PropertyBag logonProps = new PropertyBag();
// set the properties for the logonProps PropertyBag
logonProps.putStringValue("DSN", databaseName);
logonProps.putStringValue("UseDSNProperties", "false");
// add the logonProps PropertyBag to pBag
pBag.put("QE_LogonProperties", logonProps);
// set pBag into the conInfo attributes
conInfo.setAttributes(pBag);
newTable.setName(oldTable.getName());
newTable.setAlias(oldTable.getAlias());
newTable.setQualifiedName(db_username.toUpperCase()+"."+oldTable.getName());
newTable.setConnectionInfo(conInfo);
System.out.println("Start TableLocation" + newTable.getQualifiedName());
report.getDatabaseController().setTableLocation(oldTable, newTable);
-
In last line this is failing to Execute, with SP2 there has been no problem.
Thanks,
Jitendra
Edited by: JitendraS on May 26, 2010 3:10 AM
Edited by: JitendraS on May 26, 2010 3:10 AM
Edited by: JitendraS on May 26, 2010 3:15 AM