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

[Former Member]

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

[Former Member]

In our application we are using crdb_oracle.dll. So where we will get new crdb_oracle.dll file.

Need urgently.

[Former Member]

I found two documents on SAP website for Supported Platforms of both CR XI R2 SP2 and CR XI R2 SP5.

CR XI R2 SP2u2013

Link: http://www.sdn.sap.com/irj/boc/go/portal/prtroot/docs/library/uuid/00225757-ab5c-2c10-c1a8-fb9f9f0f4...

Page 7

Supported Application Servers>> Details

Oracle Application Server 10gR3 (10.1.3)

JDK 1.5.0_xx

CR XI R2 SP5u2013

Link: http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/10ca2a2b-e478-2c10-53bf-9534ee116...

Page 5

Supported Application Servers

Oracle OAS 10G Rel.2 (10.1.2)

JDK 1.4.2_xx

why Supported Application Server Version downgraded in SP5?

[ted_ueda]

The first link you have is not for XI Release 2, but for Crystal Reports 2008 Service Pack 2. The 2008 version is on par with version XI 3.x, which is newer than XI Release 2.

So there's not been any downgrade in supported versions.

Sincerely,

Ted Ueda

[Former Member]

Yes,

I checked again, there is no issue of downgrade, but I am still not able to solve the problem. I checked Crystal Server Logs.

From SP5 Developer version it is getting generated, but once deployed rpt file to server and tried from "Crystal Management Console" it failed.

Following Error is coming in Crystal Log.

ErrorLog 2011 11 14 11:21:15.562 3632 4496 (\servers\ras\dtsagent\cdtsagent.cpp:3191): CDTSagent: oOneRequest reqId=250: CSResultException thrown. ErrorSrc:"CRPE" FileName:"\servers\ras\dtsagent\reporthandler.cpp" LineNum:13495 ErrorCode:709 ErrorMsg:"The table 'AP_GL_R216' could not be found.

Error in File C:\WINDOWS\TEMP\{440C6583-4A03-4D9B-AECE-50D735018F2F}.rpt:

The table could not be found." DetailedErrorMsg:""

[Former Member]

This is the bug in SP2 XI R2 SP5, SAP responded this.

The Problem got resolved when SAP provided new crdb_odbc.dll, with fix for the same.

Edited by: JitendraS on Aug 13, 2010 4:43 AM

[Former Member]

Facing same error of table doesnot exists in the document when upgraded from CR SP3 to SP5.

How to resolve?