Skip to Content
0
Former Member
May 26, 2010 at 01:09 AM

Crystal Report Server Upgrade XI R2 SP2 to XI R2 SP5, setTableLocation fail

87 Views

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