Skip to Content
0
Former Member
Apr 16, 2014 at 01:40 PM

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

248 Views

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)