ERROR reports.reportdefinition : com.crystaldecisions.reports.queryengine.driverImpl.m: JDBC Error: [Microsoft][ODBC Driver Manager] Invalid string or buffer length

[Former Member]

I have developed Java web application which uses Crystal Report 2013 , java 1.6 , Windows 32 bit System, All the reports are loading fine in the Following environment

Development Environment

Windows7 Professional Service pack 1 -32 bit

Java - 1.6

Internet Explorer 11

Oracle Client 10g 32 bit ODBC driver

Testing Environment

Windows Server 2008 R2 Enterprise - 64 bit

java 1.6

Internet Explorer 9

Oracle Client 11g 62 bit ODBC driver

While loading reports in the 64 bit server the error occurs

ERROR reports.reportdefinition :  com.crystaldecisions.reports.queryengine.driverImpl.m: JDBC Error: [Microsoft][ODBC Driver Manager] Invalid string or buffer length

ERROR dataengine.datasource : Failed to read next recurring database record: database row set error.

com.crystaldecisions.reports.reportdefinition.datainterface.j: JDBC Error: [Microsoft][ODBC Driver Manager] Invalid string or buffer length

    at com.crystaldecisions.reports.reportdefinition.datainterface.q.a(Unknown Source)

    at com.crystaldecisions.reports.dataengine.n.m(Unknown Source)

    at com.crystaldecisions.reports.dataengine.n.l(Unknown Source)

    at com.crystaldecisions.reports.dataengine.n.bn(Unknown Source)

    at com.crystaldecisions.reports.dataengine.n.bp(Unknown Source)

    at com.crystaldecisions.reports.dataengine.n.else(Unknown Source)

    at com.crystaldecisions.reports.dataengine.s.a(Unknown Source)

    at com.crystaldecisions.reports.dataengine.bk.a(Unknown Source)

    at com.crystaldecisions.reports.dataengine.bk.ab(Unknown Source)

    at com.crystaldecisions.reports.dataengine.bk.<init>(Unknown Source)

    at com.crystaldecisions.reports.dataengine.bk.if(Unknown Source)

    at com.crystaldecisions.reports.dataengine.bk.a(Unknown Source)

    at com.crystaldecisions.reports.formatter.formatter.objectformatter.bv.a(Unknown Source)

    at com.crystaldecisions.reports.formatter.formatter.objectformatter.bv.a(Unknown Source)

    at com.crystaldecisions.reports.formatter.formatter.objectformatter.be.a(Unknown Source)

    at com.crystaldecisions.reports.formatter.formatter.objectformatter.be.h(Unknown Source)

    at com.crystaldecisions.reports.formatter.formatter.objectformatter.i.h(Unknown Source)

    at com.crystaldecisions.reports.formatter.formatter.objectformatter.be.for(Unknown Source)

    at com.crystaldecisions.reports.formatter.formatter.objectformatter.bt.a(Unknown Source)

    at com.crystaldecisions.reports.formatter.formatter.objectformatter.bv.a(Unknown Source)

    at com.crystaldecisions.reports.formatter.formatter.objectformatter.bv.a(Unknown Source)

    at com.crystaldecisions.reports.formatter.formatter.objectformatter.bf.a(Unknown Source)

    at com.crystaldecisions.reports.formatter.formatter.objectformatter.cd.for(Unknown Source)

    at com.crystaldecisions.reports.formatter.formatter.objectformatter.cd.for(Unknown Source)

    at com.crystaldecisions.reports.formatter.formatter.objectformatter.b3.for(Unknown Source)

    at com.crystaldecisions.reports.formatter.formatter.objectformatter.bt.a(Unknown Source)

    at com.crystaldecisions.reports.formatter.formatter.objectformatter.cd.a(Unknown Source)

    at com.crystaldecisions.reports.formatter.formatter.objectformatter.cd.a(Unknown Source)

    at com.crystaldecisions.reports.formatter.formatter.objectformatter.cd.a(Unknown Source)

    at com.crystaldecisions.reports.formatter.formatter.objectformatter.ca.a(Unknown Source)

    at com.crystaldecisions.reports.formatter.formatter.objectformatter.a9.a(Unknown Source)

    at com.crystaldecisions.reports.formatter.formatter.e.m.a(Unknown Source)

    at com.crystaldecisions.reports.formatter.formatter.objectformatter.cd.for(Unknown Source)

    at com.crystaldecisions.reports.formatter.formatter.objectformatter.cd.for(Unknown Source)

    at com.crystaldecisions.reports.formatter.formatter.objectformatter.b3.for(Unknown Source)

    at com.crystaldecisions.reports.formatter.formatter.e.m.for(Unknown Source)

    at com.crystaldecisions.reports.formatter.formatter.objectformatter.bt.a(Unknown Source)

    at com.crystaldecisions.reports.formatter.formatter.e.p.l(Unknown Source)

    at com.crystaldecisions.reports.formatter.formatter.e.p.void(Unknown Source)

    at com.crystaldecisions.reports.formatter.formatter.e.p.l(Unknown Source)

    at com.crystaldecisions.reports.formatter.formatter.e.p.aE(Unknown Source)

    at com.crystaldecisions.reports.formatter.a.c.a(Unknown Source)

    at com.crystaldecisions.reports.formatter.a.c.if(Unknown Source)

    at com.crystaldecisions.reports.formatter.a.c.a(Unknown Source)

    at com.businessobjects.reports.sdk.b.b.int(Unknown Source)

    at com.businessobjects.reports.sdk.JRCCommunicationAdapter.request(Unknown Source)

    at com.crystaldecisions.proxy.remoteagent.x.a(Unknown Source)

    at com.crystaldecisions.proxy.remoteagent.q.a(Unknown Source)

    at com.crystaldecisions.sdk.occa.report.application.dd.a(Unknown Source)

    at com.crystaldecisions.sdk.occa.report.application.ReportSource.a(Unknown Source)

    at com.crystaldecisions.sdk.occa.report.application.ReportSource.a(Unknown Source)

    at com.crystaldecisions.sdk.occa.report.application.PrintOutputController.export(Unknown Source)

    at com.crystaldecisions.sdk.occa.report.application.PrintOutputController.export(Unknown Source)

    at com.crystaldecisions.reports.sdk.PrintOutputController.export(Unknown Source)

    at com.erm.controller.ALMReportsController.queryDll(ALMReportsController.java:1681)

    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

    at java.lang.reflect.Method.invoke(Unknown Source)

    at org.springframework.web.servlet.mvc.multiaction.MultiActionController.invokeNamedMethod(MultiActionController.java:471)

    at org.springframework.web.servlet.mvc.multiaction.MultiActionController.handleRequestInternal(MultiActionController.java:408)

    at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)

    at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)

    at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:925)

    at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:856)

    at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:936)

    at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:838)

    at javax.servlet.http.HttpServlet.service(HttpServlet.java:643)

    at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:812)

    at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)

    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

    at com.erm.authentication.HttpSecurityFilter.doFilter(HttpSecurityFilter.java:658)

    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

    at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)

    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)

    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)

    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)

    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)

    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)

    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)

    at java.lang.Thread.run(Unknown Source)

Caused by: com.crystaldecisions.reports.queryengine.driverImpl.m: JDBC Error: [Microsoft][ODBC Driver Manager] Invalid string or buffer length

    at com.crystaldecisions.reports.queryengine.driverImpl.o.if(Unknown Source)

    at com.crystaldecisions.reports.queryengine.ap.if(Unknown Source)

    at com.crystaldecisions.reports.queryengine.l.bN(Unknown Source)

    at com.crystaldecisions.reports.queryengine.ap.eg(Unknown Source)

    at com.crystaldecisions.reports.queryengine.ap.e(Unknown Source)

    at com.crystaldecisions.reports.queryengine.b2.f(Unknown Source)

    at com.crystaldecisions.reports.queryengine.b2.dy(Unknown Source)

    ... 89 more

Caused by: java.sql.SQLException: [Microsoft][ODBC Driver Manager] Invalid string or buffer length

    at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)

    at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)

    at sun.jdbc.odbc.JdbcOdbc.SQLGetDataString(Unknown Source)

    at sun.jdbc.odbc.JdbcOdbcResultSet.getDataString(Unknown Source)

    at sun.jdbc.odbc.JdbcOdbcResultSet.getBigDecimal(Unknown Source)

[DellSC · Accepted solution]

I'm not sure whether there is a 64-bit version of the Crystal SDK for java.  Crystal Reports itself is a 32-bit application.  I would try using a 32-bit ODBC connection instead of the 64-bit connection to see whether that solves your problem.

-Dell

[former_member183750]

A few things to note:

1) Crystal Report 2013 doe snot install any SDK. Thus the assumption is that you are using CR from teh following link:

SAP BusinessObjects - SAP Crystal Reports, Version For Eclipse Download

2) Since you are using a 64 bit connection (Oracle Client 11g 62 bit ODBC driver) you will have to make sure you are using 64 bit JVM. Otherwise, follow Dell's advice and use a 32 bit ODBC datasource.

3) On one test you are using Oracle Client 10g 32 bit ODBC driver and the other you are using Oracle Client 11g 64 bit ODBC driver. You might want to see if you can run your app using Client 11g 32 bit ODBC driver.

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada