ReportServer Forum

Mvjikblackheart

Member

Registered: 2017-07-11

Issue using ReportServer with informix

Hi !

I'm having trouble using ReportServer with an informix(v12) connection; i've tried driver v 4.10, 3.70 and 3.50 with the same result:

- I can execute the query from the master report without problems, it shows all the info of the resulset; as simple as:

select * from table

- When i create a new variant and select any column in "Configure List", then preview ..., the app shows always The report could not be executed: null ; the same occurs when i try to edit filter on any column

- The ReportServer log show:

net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke Intercepted NonFatalException
 java.lang.reflect.UndeclaredThrowableException
        at com.sun.proxy.$Proxy209.prepareStatement(Unknown Source)
        at net.datenwerke.rs.base.service.datasources.table.impl.utils.JasperStyleParameterParser.createStatement(JasperStyleParameterParser.java:223)
        at net.datenwerke.rs.base.service.datasources.table.impl.utils.JasperStyleParameterParser.getStatement(JasperStyleParameterParser.java:144)
        at net.datenwerke.rs.base.service.dbhelper.querybuilder.ManagedQuery.prepareStatement(ManagedQuery.java:95)
        at net.datenwerke.rs.base.service.datasources.table.impl.TableDBDataSource.open(TableDBDataSource.java:281)
        at net.datenwerke.rs.base.service.reportengines.table.SimpleDataSupplier.getData(SimpleDataSupplier.java:424)
        at net.datenwerke.rs.base.service.reportengines.table.SimpleDataSupplier._getColumnValuesPaged(SimpleDataSupplier.java:266)
        at net.datenwerke.rs.base.service.reportengines.table.SimpleDataSupplier.getDistinctColumnValuesPaged(SimpleDataSupplier.java:217)
        at net.datenwerke.rs.base.server.table.TableReportUtilityServiceImpl.getDistinctValuesPaged(TableReportUtilityServiceImpl.java:166)
        at com.google.inject.persist.jpa.JpaLocalTxnInterceptor.invoke(JpaLocalTxnInterceptor.java:66)
        at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:109)
        at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:587)
        at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:333)
        at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:109)
        at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)
        at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:303)
        at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:109)
        at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)
        at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:373)
        at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
        at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:109)
        at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)
        at com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:263)
        at com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:178)
        at com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:91)
        at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:62)
        at com.google.inject.persist.PersistFilter.doFilter(PersistFilter.java:89)
        at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:163)
        at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)
        at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168)
        at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)
        at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168)
        at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)
        at com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:118)
        at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:113)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:94)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
        at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:620)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:509)
        at org.apache.coyote.ajp.AbstractAjpProcessor.process(AbstractAjpProcessor.java:877)
        at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:684)
        at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2508)
        at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2497)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
        at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.reflect.InvocationTargetException
        at sun.reflect.GeneratedMethodAccessor51.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at net.datenwerke.dbpool.proxy.ProxiedConnectionHandler.handleInvocation(ProxiedConnectionHandler.java:25)
        at com.google.common.reflect.AbstractInvocationHandler.invoke(AbstractInvocationHandler.java:79)
        ... 60 more
Caused by: java.sql.SQLException: A syntax error has occurred.
        at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:413)
        at com.informix.jdbc.IfxSqli.a(IfxSqli.java:3537)
        at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3853)
        at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2653)
        at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2569)
        at com.informix.jdbc.IfxSqli.executePrepare(IfxSqli.java:1388)
        at com.informix.jdbc.IfxPreparedStatement.f(IfxPreparedStatement.java:326)
        at com.informix.jdbc.IfxPreparedStatement.a(IfxPreparedStatement.java:306)
        at com.informix.jdbc.IfxPreparedStatement.<init>(IfxPreparedStatement.java:176)
        at com.informix.jdbc.IfxSqliConnect.h(IfxSqliConnect.java:6698)
        at com.informix.jdbc.IfxSqliConnect.prepareStatement(IfxSqliConnect.java:2461)
        at com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:469)
        ... 65 more
Caused by: java.sql.SQLException
        at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:413)
        at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3858)

I'll apreciate any kind of advice and sorry about my bad english

IF_Eduardo

Administrator

Registered: 2016-11-01

Website

Re: Issue using ReportServer with informix

Hi Mvjikblackheart,

I tested with this jar: ifxjdbc.jar, and this URL: jdbc:informix-sqli://IP:9092/DBNAME:informixserver=INSTANCENAME
You have to replace the IP, eventually the port 9092, the DBNAME and the INSTANCENAME.

Please note: ReportServer 3.0.2 has issues with Informix. So please try with the 3.0.3-beta, which corrects these issues (RS-2562 in the 3.0.3-beta release notes). More information on the beta here: https://forum.reportserver.net/viewtopic.php?id=893

Best regards,
Eduardo

Mvjikblackheart

Member

Registered: 2017-07-11

Re: Issue using ReportServer with informix

Hi Mvjikblackheart,

I tested with this jar: ifxjdbc.jar, and this URL: jdbc:informix-sqli://IP:9092/DBNAME:informixserver=INSTANCENAME
You have to replace the IP, eventually the port 9092, the DBNAME and the INSTANCENAME.

Please note: ReportServer 3.0.2 has issues with Informix. So please try with the 3.0.3-beta, which corrects these issues (RS-2562 in the 3.0.3-beta release notes). More information on the beta here: https://forum.reportserver.net/viewtopic.php?id=893

Best regards,
Eduardo

Hi again !!

I just have tested this today and now it works like charm; i'll keep an eye on the new releases and will feed any related issues in the beta post. Best Regards !

MBlackheart.