Crystal Reports JNDI

marrythaigirlsg · 2014-06-25 07:38:43

Hello.

I managed to setup ReportServer for Crystal reports by following the guide here: http://blog.datenwerke.net/2013/08/sap- … erver.html

I also managed to display the jrc_view_report.rpt in the guide.

Now I'm trying to display my own crystal reports but the problem is my reports have commands that invoke a JNDI name upon executing and I can't seem to find a way to add a JNDI name in ReportServer.

marrythaigirlsg · 2014-06-26 05:47:58

I managed to add the JNDI name to tomcat via tomcat\conf\context.xml and tomcat\webapps\reportserver\WEB-INF\web.xml but now I have another error:

Error code:-2147217394 Error code name:missingParameterValueError

I already passed in the parameters for my reports following the guide here: http://blog.datenwerke.net/2013/05/call … downs.html

But it still have the missingParameterValueError.

http://localhost:8080/reportserver/reportserver/reportexport?id=3935&format=pdf&p_school=1234p_level=1&p_reportName=testReport

Full error:

Fehler: An error occured during report execution.
The report could not be executed: net.datenwerke.rs.core.service.reportmanager.exceptions.ReportExecutorException: The report could not be executed: null
Im Falle eines nicht nachvollziehbaren Fehlers kontaktieren Sie bitte einen Administrator.
Details:
net.datenwerke.rs.core.service.reportmanager.exceptions.ReportExecutorException: The report could not be executed: net.datenwerke.rs.core.service.reportmanager.exceptions.ReportExecutorException: The report could not be executed: null at net.datenwerke.rs.core.service.reportmanager.ReportExecutorServiceImpl.execute(ReportExecutorServiceImpl.java:218) at net.datenwerke.rs.core.service.reportmanager.ReportExecutorServiceImpl.execute(ReportExecutorServiceImpl.java:119) at net.datenwerke.rs.core.server.reportexport.ReportExportServlet.exeucteReport(ReportExportServlet.java:467) at net.datenwerke.rs.core.server.reportexport.ReportExportServlet.exportReport(ReportExportServlet.java:358) at net.datenwerke.rs.core.server.reportexport.ReportExportServlet.exportReportById(ReportExportServlet.java:242) at net.datenwerke.rs.core.server.reportexport.ReportExportServlet.exportReportByIdViaRequest(ReportExportServlet.java:233) at net.datenwerke.rs.core.server.reportexport.ReportExportServlet.doGet(ReportExportServlet.java:153) at net.datenwerke.rs.core.server.reportexport.ReportExportServlet$$EnhancerByGuice$$f3cf4e3d.CGLIB$doGet$1() at net.datenwerke.rs.core.server.reportexport.ReportExportServlet$$EnhancerByGuice$$f3cf4e3d$$FastClassByGuice$$181eff53.invoke() at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228) at
com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) at com.google.inject.persist.jpa.JpaLocalTxnInterceptor.invoke(JpaLocalTxnInterceptor.java:66) at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:110) at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52) at net.datenwerke.rs.core.server.reportexport.ReportExportServlet$$EnhancerByGuice$$f3cf4e3d.doGet() at javax.servlet.http.HttpServlet.service(HttpServlet.java:621) at javax.servlet.http.HttpServlet.service(HttpServlet.java:728) at net.datenwerke.rs.core.server.reportexport.ReportExportServlet$$EnhancerByGuice$$f3cf4e3d.CGLIB$service$14() at net.datenwerke.rs.core.server.reportexport.ReportExportServlet$$EnhancerByGuice$$f3cf4e3d$$FastClassByGuice$$181eff53.invoke() at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228) at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:110) at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52) at net.datenwerke.rs.core.server.reportexport.ReportExportServlet$$EnhancerByGuice$$f3cf4e3d.service() 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.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:118) at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:113) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:947) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1009) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589) at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:1852) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: net.datenwerke.rs.core.service.reportmanager.exceptions.ReportExecutorRuntimeException: net.datenwerke.rs.core.service.reportmanager.exceptions.ReportExecutorException: The report could not be executed: null at net.datenwerke.rs.crystal.service.crystal.reportengine.CrystalReportEngine.executeReport(CrystalReportEngine.java:161) at net.datenwerke.rs.crystal.service.crystal.reportengine.CrystalReportEngine.doExecute(CrystalReportEngine.java:78) at net.datenwerke.rs.core.service.reportmanager.engine.ReportEngine.execute(ReportEngine.java:127) at net.datenwerke.rs.core.service.reportmanager.ReportExecutorServiceImpl.execute(ReportExecutorServiceImpl.java:186) ... 51 more Caused by: net.datenwerke.rs.core.service.reportmanager.exceptions.ReportExecutorException: The report could not be executed: null at net.datenwerke.rs.crystal.service.crystal.reportengine.output.generator.CrystalPDFOutputGenerator.exportReport(CrystalPDFOutputGenerator.java:58) at net.datenwerke.rs.crystal.service.crystal.reportengine.CrystalReportEngine.executeReport(CrystalReportEngine.java:150) ... 54 more Caused by: java.lang.reflect.InvocationTargetException 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 net.datenwerke.rs.crystal.service.crystal.reportengine.output.generator.CrystalPDFOutputGenerator.exportReport(CrystalPDFOutputGenerator.java:52) ... 55 more Caused by: com.crystaldecisions.sdk.occa.report.lib.ReportSDKParameterFieldException: InternalFormatterException---- Error code:-2147217394 Error code name:missingParameterValueError at com.crystaldecisions.sdk.occa.report.application.PrintOutputController.if(SourceFile:237) at com.crystaldecisions.sdk.occa.report.application.PrintOutputController.export(SourceFile:147) at com.crystaldecisions.sdk.occa.report.application.PrintOutputController.export(SourceFile:128) at com.crystaldecisions.sdk.occa.report.application.PrintOutputController.export(SourceFile:111) ... 60 more

marrythaigirlsg · 2014-06-26 06:02:31

Oh sorry, I just realized that I can add parameters through the ReportServer Administration module (Reportmanager>myReport>Parameters), and after adding, I am now able to access via the URL, it works now.

http://localhost:8080/reportserver/reportserver/reportexport?id=3935&format=pdf&p_school=1234p_level=1&p_reportName=testReport

ReportServer Forum

#1 2014-06-25 07:38:43

Crystal Reports JNDI

#2 2014-06-26 05:47:58

Re: Crystal Reports JNDI

#3 2014-06-26 06:02:31

Re: Crystal Reports JNDI

Board footer