Skip to Content
0
Former Member
May 13, 2010 at 07:32 AM

Unexpected ValueType: ValueType=[255]---- Error code:-2147467259 Error code

336 Views

Hi,

I'm having problems with Crystal Reports for Eclipse v2.0.4, the error occured when we set data source of DatabaseController with a JDBC resultset that returned by SQL Server 2008 Type 4 driver (tried both 2.0 & 3.0 driver)

This is the call that failed:

databaseController.setDataSource(resultSet, table.getName(), table.getName());

and this is the exception caught:

Caused by: com.crystaldecisions.sdk.occa.report.lib.ReportSDKException: Unexpected ValueType: ValueType=[255]---- Error code:-2147467259 Error code name:failed

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.if(SourceFile:741)

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.a(SourceFile:167)

at com.businessobjects.reports.sdk.JRCCommunicationAdapter$2.a(SourceFile:529)

at com.businessobjects.reports.sdk.JRCCommunicationAdapter$2.call(SourceFile:527)

at com.crystaldecisions.reports.common.ThreadGuard.syncExecute(SourceFile:102)

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.for(SourceFile:525)

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.int(SourceFile:424)

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.request(SourceFile:352)

at com.businessobjects.sdk.erom.jrc.a.a(SourceFile:54)

at com.businessobjects.sdk.erom.jrc.a.execute(SourceFile:67)

at com.crystaldecisions.proxy.remoteagent.RemoteAgent$a.execute(SourceFile:716)

at com.crystaldecisions.proxy.remoteagent.CommunicationChannel.a(SourceFile:125)

at com.crystaldecisions.proxy.remoteagent.RemoteAgent.a(SourceFile:537)

at com.crystaldecisions.sdk.occa.report.application.ReportClientDocument.if(SourceFile:605)

at com.crystaldecisions.sdk.occa.report.application.ReportClientDocument.a(SourceFile:1688)

at com.crystaldecisions.sdk.occa.report.application.ReportClientDocument.new(SourceFile:2661)

at com.crystaldecisions.sdk.occa.report.application.b9.onDataSourceChanged(SourceFile:301)

at com.crystaldecisions.sdk.occa.report.application.DatabaseController.a(SourceFile:962)

at com.crystaldecisions.sdk.occa.report.application.DatabaseController.a(SourceFile:2834)

at com.crystaldecisions.sdk.occa.report.application.DatabaseController.setDataSource(SourceFile:2557)

at com.crystaldecisions.reports.sdk.DatabaseController.setDataSource(SourceFile:87)

at com.afe.g3sb.server.report.dao.ExportCrystalReports.export(ExportCrystalReports.java:40)

... 9 more

Caused by: java.lang.IllegalArgumentException: Unexpected ValueType: ValueType=[255]

at com.crystaldecisions.reports.common.Utils.a(SourceFile:97)

at com.crystaldecisions.reports.common.Utils.a(SourceFile:151)

at com.businessobjects.reports.sdk.builder.ConnectionDatabaseBuilder.a(SourceFile:275)

at com.businessobjects.reports.sdk.builder.ConnectionDatabaseBuilder.a(SourceFile:357)

at com.businessobjects.reports.sdk.builder.EROMDatabaseBuilder.a(SourceFile:185)

at com.businessobjects.reports.sdk.builder.EROMDatabaseBuilder.int(SourceFile:106)

at com.businessobjects.reports.sdk.builder.EROMReportDocumentBuilder.try(SourceFile:139)

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.do(SourceFile:1300)

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.if(SourceFile:661)

... 30 more

the error occured if resultSet has the following data structure:

int

nchar(15)

nchar(15)

nchar(2)

datetime

smallint

nchar(50)

nchar(2)

varchar(1)

smallint

nchar(30)

nvarchar(2000)

nvarchar(255)

nvarchar(255)

nvarchar(2000)

nvarchar(255)

nvarchar(255)

but if first few "nchar"s were replaced with "char"s, the code will be OK. i.e.

int

char(15) <--

char(15) <--

char(2) <--

datetime

smallint

char(50) <--

char(2) <--

varchar(1)

smallint

char(30) <--

nvarchar(2000)

nvarchar(255)

nvarchar(255)

nvarchar(2000)

nvarchar(255)

nvarchar(255)

Edited by: ming_t on May 13, 2010 9:32 AM