You are not logged in.
Hi,
This is an example (i am using Oracle-DB:
I have a master-detail report:
Query (master with parameter PM_USER, MyDate): select * from all_users where username = '{?PM_USER}'
Table (detail with parameters PM_OWNER, PM_CREATED): ALL_OBJECTS
Filter in crystal reports:
{ALL_OBJECTS.CREATED} >= {?PM_CREATED} and
{ALL_OBJECTS.OWNER} = {?PM_OWNER}
PM_USER is linked to PM_OWNER
MyDate is linked to PM_CREATED
The report runs fine in crystal reports designer.
In report server the following error is thrown:
Error: An error occurred during report execution.
The report could not be executed: net.datenwerke.rs.core.service.reportmanager.exceptions.ReportExecutorException: The report could not be executed: null
To get help please contact an 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:535)
at net.datenwerke.rs.core.server.reportexport.ReportExportServlet.doExportReport(ReportExportServlet.java:416)
at net.datenwerke.rs.core.server.reportexport.ReportExportServlet.exportReport(ReportExportServlet.java:346)
at net.datenwerke.rs.core.server.reportexport.ReportExportServlet.exportReportViaSession(ReportExportServlet.java:339)
at net.datenwerke.rs.core.server.reportexport.ReportExportServlet.doGet(ReportExportServlet.java:168)
at net.datenwerke.rs.core.server.reportexport.ReportExportServlet$$EnhancerByGuice$$eaa7398b.CGLIB$doGet$0()
at net.datenwerke.rs.core.server.reportexport.ReportExportServlet$$EnhancerByGuice$$eaa7398b$$FastClassByGuice$$2b9b5d43.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:109)
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$$eaa7398b.doGet()
at javax.servlet.http.HttpServlet.service(HttpServlet.java:622) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at net.datenwerke.rs.core.server.reportexport.ReportExportServlet$$EnhancerByGuice$$eaa7398b.CGLIB$service$14()
at net.datenwerke.rs.core.server.reportexport.ReportExportServlet$$EnhancerByGuice$$eaa7398b$$FastClassByGuice$$2b9b5d43.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:109)
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$$eaa7398b.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.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:192)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:474)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:783)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:798)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1434)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
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:104)
at net.datenwerke.rs.crystal.service.crystal.reportengine.CrystalReportEngine.doExecute(CrystalReportEngine.java:63)
at net.datenwerke.rs.core.service.reportmanager.engine.ReportEngine.execute(ReportEngine.java:150)
at net.datenwerke.rs.core.service.reportmanager.ReportExecutorServiceImpl.execute(ReportExecutorServiceImpl.java:186) ...
58 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:93) ...
61 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) ...
62 more Caused by: com.crystaldecisions.sdk.occa.report.lib.ReportSDKException:
InternalFormatterException---- 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) ...
67 more Caused by: com.crystaldecisions.reports.exportinterface2.exceptions.InternalFormatterException:
InternalFormatterException at com.crystaldecisions.reports.formatter.export2.a.a(SourceFile:258)
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) ...
70 more Caused by: com.crystaldecisions.reports.dataengine.DataEngineException:
Ausnahme in Formel ""{@Record_Selection}"" bei ""{ALL_OBJECTS.OWNER}"":
Dieser Feldname ist unbekannt. at com.crystaldecisions.reports.dataengine.DataSourceManager.do(SourceFile:692)
at com.crystaldecisions.reports.dataengine.DataSourceManager.new(SourceFile:607)
at com.crystaldecisions.reports.dataengine.DataSourceManager.new(SourceFile:614)
at com.crystaldecisions.reports.dataengine.DataSourceManagerCoordinator.a(SourceFile:505)
at com.crystaldecisions.reports.dataengine.DataSourceManager.a(SourceFile:1060)
at com.crystaldecisions.reports.dataengine.DataProcessor2.a(SourceFile:729)
at com.crystaldecisions.reports.formatter.formatter.objectformatter.ObjectFormatter.(SourceFile:179)
at com.crystaldecisions.reports.formatter.formatter.objectformatter.ObjectFormatter.if(SourceFile:135)
at com.crystaldecisions.reports.formatter.formatter.paginator.PageFormatterBase.(SourceFile:75)
at com.crystaldecisions.reports.formatter.formatter.paginator.PageFormatter.(SourceFile:183)
at com.crystaldecisions.reports.formatter.formatter.paginator.PageFormatter.a(SourceFile:162)
at com.crystaldecisions.reports.formatter.export2.a.a(SourceFile:202) ...
92 more Caused by: com.crystaldecisions.reports.formulas.FormulaException:
Ausnahme in Formel ""{@Record_Selection}"" bei ""{ALL_OBJECTS.OWNER}"": Dieser Feldname ist unbekannt.
at com.crystaldecisions.reports.formulas.o.a(SourceFile:1041)
at com.crystaldecisions.reports.formulas.o.do(SourceFile:1013)
at com.crystaldecisions.reports.formulas.o.new(SourceFile:688)
at com.crystaldecisions.reports.formulas.o.else(SourceFile:459)
at com.crystaldecisions.reports.formulas.f.void(SourceFile:65)
at com.crystaldecisions.reports.formulas.FormulaParser.a(SourceFile:345)
at com.crystaldecisions.reports.formulas.r.a(SourceFile:89)
at com.crystaldecisions.reports.formulas.FormulaInfo.a(SourceFile:570)
at com.crystaldecisions.reports.formulas.FormulaService.compile(SourceFile:347)
at com.crystaldecisions.reports.reportdefinition.FormulaCompiler.a(SourceFile:139)
at com.crystaldecisions.reports.reportdefinition.FormulaFieldDefinitionBase.compile(SourceFile:928)
at com.crystaldecisions.reports.reportdefinition.o.a(SourceFile:1360)
at com.crystaldecisions.reports.reportdefinition.o.a(SourceFile:1348)
at com.crystaldecisions.reports.reportdefinition.o.a(SourceFile:4253)
at com.crystaldecisions.reports.dataengine.DataSourceManager.do(SourceFile:687) ... 103 more
Btw. the same reports seems to work if i use a command (select * from all_objects where ...)
instead of the table.
Best Regards
Joachim
Offline
Hi Joachim,
could you please create a simple report that causes this issue and send it to me per email ? Please so simple as possible with the table DDLs, etc.
Regards,
Eduardo
Offline