ReportServer Forum

Jeremiah

Member

Registered: 2016-04-07

Crystal Reports and Stored Procdures

Hello,

I am having an issue with a crystal report in the 2.2.2.5639 version of report server.

It has 3 parameters that were loaded into it by Stored procedure.

When I run the report and enter my parameters I get an error 500.

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:527)
    at net.datenwerke.rs.core.server.reportexport.ReportExportServlet.doExportReport(ReportExportServlet.java:407)
    at net.datenwerke.rs.core.server.reportexport.ReportExportServlet.exportReport(ReportExportServlet.java:333)
    at net.datenwerke.rs.core.server.reportexport.ReportExportServlet.exportReportViaSession(ReportExportServlet.java:326)
    at net.datenwerke.rs.core.server.reportexport.ReportExportServlet.doGet(ReportExportServlet.java:164)
    at net.datenwerke.rs.core.server.reportexport.ReportExportServlet$$EnhancerByGuice$$ff663d5.CGLIB$doGet$0(<generated>)

I am trying to figure out what is causing the issue. I have a 2 date fields that provide a between statement. Start and End date. Could the date formatting be the issue?
As I said this all goes back to a stored procedure. I re-did the report and took out the @ from the parameters thinking that was causing it. The database connected correct and I have other crystal reports that work, just not using date fields. Any help would be great.

Also is there a way to change how the date is in the parameters on reportServer? The current one it shows is YYYY MMM DD .

Jeremiah

Member

Registered: 2016-04-07

Re: Crystal Reports and Stored Procdures

I should probably elaborate.
My report has three parameters
A String
Start_Date
End_Date

It runs in Crystal. It runs in Crystal Viewer,
I upload it. Import Parameters. Make sure the settings and name are valid.
Go to run it. Add the parameters Like Text and Pick two date fields. Then It starts and I get an error 500. I am trying to determine if its because it connects back to a stored procedure in Crystal, or if one of the parameters is set wrong and can't pass.

Arno Mittelbach

datenwerke

Registered: 2012-02-14

Re: Crystal Reports and Stored Procdures

Hi Jeremiah,

is there any more of the stacktrace (maybe in the logs)? It looks like it is cut off.

Cheers,
Arno

Jeremiah

Member

Registered: 2016-04-07

Re: Crystal Reports and Stored Procdures

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:527)
	at net.datenwerke.rs.core.server.reportexport.ReportExportServlet.doExportReport(ReportExportServlet.java:407)
	at net.datenwerke.rs.core.server.reportexport.ReportExportServlet.exportReport(ReportExportServlet.java:333)
	at net.datenwerke.rs.core.server.reportexport.ReportExportServlet.exportReportViaSession(ReportExportServlet.java:326)
	at net.datenwerke.rs.core.server.reportexport.ReportExportServlet.doGet(ReportExportServlet.java:164)
	at net.datenwerke.rs.core.server.reportexport.ReportExportServlet$$EnhancerByGuice$$ff663d5.CGLIB$doGet$0(<generated>)
	at net.datenwerke.rs.core.server.reportexport.ReportExportServlet$$EnhancerByGuice$$ff663d5$$FastClassByGuice$$b0151783.invoke(<generated>)
	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$$ff663d5.doGet(<generated>)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:624)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
	at net.datenwerke.rs.core.server.reportexport.ReportExportServlet$$EnhancerByGuice$$ff663d5.CGLIB$service$18(<generated>)
	at net.datenwerke.rs.core.server.reportexport.ReportExportServlet$$EnhancerByGuice$$ff663d5$$FastClassByGuice$$b0151783.invoke(<generated>)
	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$$ff663d5.service(<generated>)
	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:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:436)
	at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:188)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
	at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2517)
	at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2506)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	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:109)
	at net.datenwerke.rs.crystal.service.crystal.reportengine.CrystalReportEngine.doExecute(CrystalReportEngine.java:68)
	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)
	... 53 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:98)
	... 56 more
Caused by: java.lang.reflect.InvocationTargetException
	at sun.reflect.GeneratedMethodAccessor185.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)
	... 57 more
Caused by: com.crystaldecisions.sdk.occa.report.lib.ReportSDKException: Index: 0, Size: 0---- Error code:-2147467259 Error code name:failed
	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)
	... 61 more
Caused by: java.lang.IndexOutOfBoundsException: Index: 0, Size: 0
	at java.util.ArrayList.rangeCheck(Unknown Source)
	at java.util.ArrayList.get(Unknown Source)
	at com.crystaldecisions.reports.dataengine.m.l(SourceFile:370)
	at com.crystaldecisions.reports.dataengine.m.b(SourceFile:333)
	at com.crystaldecisions.reports.dataengine.j.b(SourceFile:515)
	at com.crystaldecisions.reports.dataengine.m.o(SourceFile:408)
	at com.crystaldecisions.reports.dataengine.m.a(SourceFile:173)
	at com.crystaldecisions.reports.dataengine.ContextNode.a(SourceFile:114)
	at com.crystaldecisions.reports.dataengine.ContextNode.a(SourceFile:95)
	at com.crystaldecisions.reports.dataengine.j.case(SourceFile:1080)
	at com.crystaldecisions.reports.dataengine.h.<init>(SourceFile:108)
	at com.crystaldecisions.reports.dataengine.DataContext.a(SourceFile:254)
	at com.crystaldecisions.reports.dataengine.DataProcessor2.a(SourceFile:4660)
	at com.crystaldecisions.reports.dataengine.DataProcessor2.a(SourceFile:4574)
	at com.crystaldecisions.reports.dataengine.DataProcessor2.new(SourceFile:2652)
	at com.crystaldecisions.reports.dataengine.DataProcessor2.byte(SourceFile:2610)
	at com.crystaldecisions.reports.dataengine.DataProcessor2.try(SourceFile:2282)
	at com.crystaldecisions.reports.dataengine.DataProcessor2.int(SourceFile:2442)
	at com.crystaldecisions.reports.dataengine.DataProcessor2.I(SourceFile:1013)
	at com.crystaldecisions.reports.formatter.formatter.objectformatter.ObjectFormatter.fp(SourceFile:526)
	at com.crystaldecisions.reports.formatter.formatter.paginator.PageFormatter.if(SourceFile:613)
	at com.crystaldecisions.reports.formatter.formatter.paginator.PageFormatter.a(SourceFile:578)
	at com.crystaldecisions.reports.formatter.formatter.paginator.PageFormatter.X(SourceFile:387)
	at com.crystaldecisions.reports.formatter.formatter.paginator.PageFormatter.moveToPageN(SourceFile:339)
	at com.crystaldecisions.reports.formatter.export2.a.a(SourceFile:79)
	at com.crystaldecisions.reports.formatter.export2.a.a(SourceFile:253)
	at com.crystaldecisions.reports.formatter.export2.ExportSupervisorEx.if(SourceFile:642)
	at com.crystaldecisions.reports.formatter.export2.ExportSupervisorEx.a(SourceFile:586)
	at com.businessobjects.reports.sdk.requesthandler.ReportViewingRequestHandler.a(SourceFile:637)
	at com.businessobjects.reports.sdk.requesthandler.ReportViewingRequestHandler.int(SourceFile:673)
	at com.businessobjects.reports.sdk.JRCCommunicationAdapter.do(SourceFile:1943)
	at com.businessobjects.reports.sdk.JRCCommunicationAdapter.if(SourceFile:660)
	at com.businessobjects.reports.sdk.JRCCommunicationAdapter.a(SourceFile:166)
	at com.businessobjects.reports.sdk.JRCCommunicationAdapter$2.a(SourceFile:528)
	at com.businessobjects.reports.sdk.JRCCommunicationAdapter$2.call(SourceFile:526)
	at com.crystaldecisions.reports.common.ThreadGuard.syncExecute(SourceFile:102)
	at com.businessobjects.reports.sdk.JRCCommunicationAdapter.for(SourceFile:524)
	at com.businessobjects.reports.sdk.JRCCommunicationAdapter.int(SourceFile:423)
	at com.businessobjects.reports.sdk.JRCCommunicationAdapter.request(SourceFile:351)
	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.ds.a(SourceFile:186)
	at com.crystaldecisions.sdk.occa.report.application.ReportSource.a(SourceFile:1558)
	at com.crystaldecisions.sdk.occa.report.application.ReportSource.a(SourceFile:337)
	at com.crystaldecisions.sdk.occa.report.application.PrintOutputController.if(SourceFile:223)
	... 64 more

Last edited by Jeremiah (2016-04-21 15:11:24)

Arno Mittelbach

datenwerke

Registered: 2012-02-14

Re: Crystal Reports and Stored Procdures

I can't really say much, but the error happens deep within the Crystal libraries. This does, of course, not mean that the parameters are innocent, but I'd suspect that the problem is probably something else. Sorry that I can't be of more help.

Jeremiah

Member

Registered: 2016-04-07

Re: Crystal Reports and Stored Procdures

I think it is an issue with stored procedures parameters or stored procedures themselves.
I made a report, with a drawn out solution using Crystal parameters as opposed to the Stored procedure and made a different layout and it works now.
I'll do more testing as we add reports.

zach.mathew

Member

Registered: 2015-04-17

Re: Crystal Reports and Stored Procdures

Hi Jeremiah,

Did you manage to figure out how to use stored procedure parameters with RS ?