Skip to Content
0
Former Member
Mar 12, 2013 at 04:29 PM

Crystal Reports: Error: The condition field for this sort does not exist: ascending

103 Views

Hi Friends,

I get the following error when I try to convert my Crystal report to PDF format. I've bolded the section that I find most interesting.

The only sorted in my report is done my a group on a single field, sorted in ascending order.

013-03-12 17:46:10,362 [http-80-Processor24] ERROR com.businessobjects.reports.sdk.JRCCommunicationAdapter - JRCAgent2 detected an exception: Currently not implemented in the Java Reporting Component

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.request(Unknown Source)

at com.crystaldecisions.proxy.remoteagent.y.a(Unknown Source)

at com.crystaldecisions.proxy.remoteagent.r.a(Unknown Source)

at com.crystaldecisions.sdk.occa.report.application.DataDefController.l(Unknown Source)

at com.crystaldecisions.sdk.occa.report.application.DataDefController.for(Unknown Source)

at com.crystaldecisions.sdk.occa.report.application.ag.onDataSourceChanged(Unknown Source)

at com.crystaldecisions.sdk.occa.report.application.DatabaseController.a(Unknown Source)

at com.crystaldecisions.sdk.occa.report.application.DatabaseController.a(Unknown Source)

at com.crystaldecisions.sdk.occa.report.application.DatabaseController.setDataSource(Unknown Source)

at com.crystaldecisions.reports.sdk.DatabaseController.setDataSource(Unknown Source)

at postilion.realtime.portal.coke.service.reports.ReportStoredProc.export(ReportStoredProc.java:68)

at postilion.realtime.portal.coke.service.reports.ReportStoredProc.readResults(ReportStoredProc.java:104)

at postilion.realtime.portal.coke.service.reports.ReportStoredProc.invoke(ReportStoredProc.java:150)

at postilion.realtime.portal.coke.util.db.DbCallProcessor.exec(DbCallProcessor.java:137)

at postilion.realtime.portal.coke.util.db.DbCallProcessor.execute(DbCallProcessor.java:57)

at postilion.realtime.portal.coke.service.reports.JdbcReportsDao.getReport(JdbcReportsDao.java:872)

at postilion.realtime.portal.coke.service.reports.GetReportAction.doSecureAction(GetReportAction.java:49)

at postilion.services.action.AServiceAction.execute(AServiceAction.java:136)

at postilion.realtime.portal.coke.service.reports.ReportsService.getReport(ReportsService.java:209)

at postilion.realtime.portal.coke.ui.service.reports.ReportsAdapter.getReport(ReportsAdapter.java:186)

at postilion.realtime.portal.coke.ui.bean.reports.RefundReport.export(RefundReport.java:51)

at postilion.realtime.portal.coke.ui.bean.reports.Report.runReport(Report.java:441)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at com.sun.faces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:126)

at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:72)

at javax.faces.component.UICommand.broadcast(UICommand.java:312)

at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:267)

at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:381)

at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:75)

at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:200)

at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:90)

at javax.faces.webapp.FacesServlet.service(FacesServlet.java:197)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)

at postilion.services.sdk.security.SessionFilter.doFilter(SessionFilter.java:141)

at postilion.portal.sdk.jsf.webapp.Filter.doFilter(Filter.java:146)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:879)

at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)

at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)

at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)

at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)

at java.lang.Thread.run(Thread.java:619)

2013-03-12 17:46:10,362 [http-80-Processor24] INFO com.businessobjects.reports.sdk.JRCCommunicationAdapter - JRCAgent2 received request: fetchReportExportRequest

2013-03-12 17:46:10,362 [http-80-Processor24] INFO com.businessobjects.reports.sdk.JRCCommunicationAdapter - JRCAgent2 attempting to acquire license

2013-03-12 17:46:10,362 [http-80-Processor24] INFO com.businessobjects.reports.sdk.JRCCommunicationAdapter - JRCAgent2 successfully acquired license

2013-03-12 17:46:10,409 [http-80-Processor24] DEBUG com.businessobjects.reports.sdk.JRCCommunicationAdapter - PageViewRequestHandler has been successfully created

2013-03-12 17:46:10,534 [http-80-Processor24] ERROR com.crystaldecisions.reports.dataengine.datasource - Failed to create controller

2013-03-12 17:46:10,534 [http-80-Processor24] ERROR com.crystaldecisions.reports.formatter.formatter.objectformatter - com.crystaldecisions.reports.dataengine.a5: Failed to create controller

2013-03-12 17:46:10,534 [http-80-Processor24] ERROR com.businessobjects.reports.sdk.JRCCommunicationAdapter - Failed to export report

com.crystaldecisions.reports.exportinterface.exceptions.ExportException: Failed to create controller

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.i.int(Unknown Source)

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.request(Unknown Source)

at com.crystaldecisions.proxy.remoteagent.y.a(Unknown Source)

at com.crystaldecisions.proxy.remoteagent.r.a(Unknown Source)

at com.crystaldecisions.sdk.occa.report.application.cf.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 postilion.realtime.portal.coke.service.reports.ReportStoredProc.export(ReportStoredProc.java:71)

at postilion.realtime.portal.coke.service.reports.ReportStoredProc.readResults(ReportStoredProc.java:104)

at postilion.realtime.portal.coke.service.reports.ReportStoredProc.invoke(ReportStoredProc.java:150)

at postilion.realtime.portal.coke.util.db.DbCallProcessor.exec(DbCallProcessor.java:137)

at postilion.realtime.portal.coke.util.db.DbCallProcessor.execute(DbCallProcessor.java:57)

at postilion.realtime.portal.coke.service.reports.JdbcReportsDao.getReport(JdbcReportsDao.java:872)

at postilion.realtime.portal.coke.service.reports.GetReportAction.doSecureAction(GetReportAction.java:49)

at postilion.services.action.AServiceAction.execute(AServiceAction.java:136)

at postilion.realtime.portal.coke.service.reports.ReportsService.getReport(ReportsService.java:209)

at postilion.realtime.portal.coke.ui.service.reports.ReportsAdapter.getReport(ReportsAdapter.java:186)

at postilion.realtime.portal.coke.ui.bean.reports.RefundReport.export(RefundReport.java:51)

at postilion.realtime.portal.coke.ui.bean.reports.Report.runReport(Report.java:441)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at com.sun.faces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:126)

at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:72)

at javax.faces.component.UICommand.broadcast(UICommand.java:312)

at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:267)

at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:381)

at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:75)

at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:200)

at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:90)

at javax.faces.webapp.FacesServlet.service(FacesServlet.java:197)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)

at postilion.services.sdk.security.SessionFilter.doFilter(SessionFilter.java:141)

at postilion.portal.sdk.jsf.webapp.Filter.doFilter(Filter.java:146)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:879)

at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)

at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)

at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)

at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)

at java.lang.Thread.run(Thread.java:619)

Caused by: com.crystaldecisions.reports.formatter.formatter.c: Failed to create controller

at com.crystaldecisions.reports.formatter.formatter.objectformatter.bv.<init>(Unknown Source)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.bv.if(Unknown Source)

at com.crystaldecisions.reports.formatter.formatter.e.l.<init>(Unknown Source)

at com.crystaldecisions.reports.formatter.formatter.e.p.<init>(Unknown Source)

at com.crystaldecisions.reports.formatter.formatter.e.p.a(Unknown Source)

at com.crystaldecisions.reports.formatter.a.c.a(Unknown Source)

... 55 more

Caused by: com.crystaldecisions.reports.dataengine.a5: Failed to create controller

at com.crystaldecisions.reports.dataengine.k.l7(Unknown Source)

at com.crystaldecisions.reports.dataengine.k.<init>(Unknown Source)

at com.crystaldecisions.reports.dataengine.j.do(Unknown Source)

at com.crystaldecisions.reports.dataengine.j.a(Unknown Source)

at com.crystaldecisions.reports.dataengine.a6.for(Unknown Source)

at com.crystaldecisions.reports.dataengine.a9.a(Unknown Source)

... 61 more

Caused by: com.crystaldecisions.reports.saveddata.c: The condition field for this sort does not exist: ascending

at com.crystaldecisions.reports.saveddata.a.g.if(Unknown Source)

at com.crystaldecisions.reports.saveddata.a.a(Unknown Source)

at com.crystaldecisions.reports.saveddata.e.a(Unknown Source)

at com.crystaldecisions.reports.saveddata.e.a(Unknown Source)

... 67 more

2013-03-12 17:46:10,550 [http-80-Processor24] ERROR com.businessobjects.reports.sdk.JRCCommunicationAdapter - JRCAgent2 detected an exception: An error occured while exporting the report

at com.crystaldecisions.sdk.occa.report.lib.ReportSDKException.throwReportSDKException(Unknown Source)

at com.businessobjects.reports.sdk.b.i.int(Unknown Source)

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.request(Unknown Source)

at com.crystaldecisions.proxy.remoteagent.y.a(Unknown Source)

at com.crystaldecisions.proxy.remoteagent.r.a(Unknown Source)

at com.crystaldecisions.sdk.occa.report.application.cf.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 postilion.realtime.portal.coke.service.reports.ReportStoredProc.export(ReportStoredProc.java:71)

at postilion.realtime.portal.coke.service.reports.ReportStoredProc.readResults(ReportStoredProc.java:104)

at postilion.realtime.portal.coke.service.reports.ReportStoredProc.invoke(ReportStoredProc.java:150)

at postilion.realtime.portal.coke.util.db.DbCallProcessor.exec(DbCallProcessor.java:137)

at postilion.realtime.portal.coke.util.db.DbCallProcessor.execute(DbCallProcessor.java:57)

at postilion.realtime.portal.coke.service.reports.JdbcReportsDao.getReport(JdbcReportsDao.java:872)

at postilion.realtime.portal.coke.service.reports.GetReportAction.doSecureAction(GetReportAction.java:49)

at postilion.services.action.AServiceAction.execute(AServiceAction.java:136)

at postilion.realtime.portal.coke.service.reports.ReportsService.getReport(ReportsService.java:209)

at postilion.realtime.portal.coke.ui.service.reports.ReportsAdapter.getReport(ReportsAdapter.java:186)

at postilion.realtime.portal.coke.ui.bean.reports.RefundReport.export(RefundReport.java:51)

at postilion.realtime.portal.coke.ui.bean.reports.Report.runReport(Report.java:441)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at com.sun.faces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:126)

at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:72)

at javax.faces.component.UICommand.broadcast(UICommand.java:312)

at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:267)

at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:381)

at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:75)

at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:200)

at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:90)

at javax.faces.webapp.FacesServlet.service(FacesServlet.java:197)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)

at postilion.services.sdk.security.SessionFilter.doFilter(SessionFilter.java:141)

at postilion.portal.sdk.jsf.webapp.Filter.doFilter(Filter.java:146)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:879)

at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)

at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)

at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)

at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)

at java.lang.Thread.run(Thread.java:619)

2013-03-12 17:46:10,550 [http-80-Processor24] INFO com.businessobjects.reports.sdk.JRCCommunicationAdapter - JRCAgent2 releasing license

2013-03-12 17:46:10,550 [http-80-Processor24] INFO com.businessobjects.reports.sdk.JRCCommunicationAdapter - JRCAgent2 received request: closeServerAgent

2013-03-12 17:46:10,550 [http-80-Processor24] INFO com.businessobjects.reports.sdk.JRCCommunicationAdapter - JRCAgent2 has cleaned up and closed down the report

2013-03-12 17:46:10,550 [http-80-Processor24] INFO org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/portal] -

[2013-03-12 17:46:10.550] Error: Service Exception: A data access error has occurred whilst trying to retrieve the data for the report: UserReport.rpt

at postilion.services.action.AServiceAction.execute(AServiceAction.java:194)

at postilion.realtime.portal.coke.service.reports.ReportsService.getReport(ReportsService.java:209)

at postilion.realtime.portal.coke.ui.service.reports.ReportsAdapter.getReport(ReportsAdapter.java:186)

at postilion.realtime.portal.coke.ui.bean.reports.RefundReport.export(RefundReport.java:51)

at postilion.realtime.portal.coke.ui.bean.reports.Report.runReport(Report.java:441)

at javax.faces.component.UICommand.broadcast(UICommand.java:312)

at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:267)

at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:381)

at postilion.services.sdk.security.SessionFilter.doFilter(SessionFilter.java:141)

at postilion.portal.sdk.jsf.webapp.Filter.doFilter(Filter.java:146)

at java.lang.Thread.run(Thread.java:619)

Caused by: postilion.services.sdk.data.XDataAccessException A data access error has occurred whilst trying to retrieve the data for the report: UserReport.rpt

at postilion.realtime.portal.coke.service.reports.ReportStoredProc.retrhow(ReportStoredProc.java:77)

at postilion.realtime.portal.coke.service.reports.ReportStoredProc.readResults(ReportStoredProc.java:108)

at postilion.realtime.portal.coke.service.reports.ReportStoredProc.invoke(ReportStoredProc.java:150)

at postilion.realtime.portal.coke.util.db.DbCallProcessor.exec(DbCallProcessor.java:137)

at postilion.realtime.portal.coke.util.db.DbCallProcessor.execute(DbCallProcessor.java:57)

at postilion.realtime.portal.coke.service.reports.JdbcReportsDao.getReport(JdbcReportsDao.java:872)

at postilion.realtime.portal.coke.service.reports.GetReportAction.doSecureAction(GetReportAction.java:49)

at postilion.services.action.AServiceAction.execute(AServiceAction.java:136)

...

Caused by: com.crystaldecisions.sdk.occa.report.lib.ReportSDKException An error occured while exporting the report

at com.crystaldecisions.sdk.occa.report.application.PrintOutputController.export(null:-1)

at com.crystaldecisions.sdk.occa.report.application.PrintOutputController.export(null:-1)

at com.crystaldecisions.reports.sdk.PrintOutputController.export(null:-1)

at postilion.realtime.portal.coke.service.reports.ReportStoredProc.export(ReportStoredProc.java:71)

at postilion.realtime.portal.coke.service.reports.ReportStoredProc.readResults(ReportStoredProc.java:104)

at postilion.realtime.portal.coke.service.reports.ReportStoredProc.invoke(ReportStoredProc.java:150)

at postilion.realtime.portal.coke.util.db.DbCallProcessor.exec(DbCallProcessor.java:137)

at postilion.realtime.portal.coke.util.db.DbCallProcessor.execute(DbCallProcessor.java:57)

at postilion.realtime.portal.coke.service.reports.JdbcReportsDao.getReport(JdbcReportsDao.java:872)

at postilion.realtime.portal.coke.service.reports.GetReportAction.doSecureAction(GetReportAction.java:49)

at postilion.services.action.AServiceAction.execute(AServiceAction.java:136)

at postilion.realtime.portal.coke.service.reports.ReportsService.getReport(ReportsService.java:209)

at postilion.realtime.portal.coke.ui.service.reports.ReportsAdapter.getReport(ReportsAdapter.java:186)

at postilion.realtime.portal.coke.ui.bean.reports.RefundReport.export(RefundReport.java:51)

at postilion.realtime.portal.coke.ui.bean.reports.Report.runReport(Report.java:441)

at javax.faces.component.UICommand.broadcast(UICommand.java:312)

at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:267)

at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:381)

at postilion.services.sdk.security.SessionFilter.doFilter(SessionFilter.java:141)

at postilion.portal.sdk.jsf.webapp.Filter.doFilter(Filter.java:146)

at java.lang.Thread.run(Thread.java:619)

Regards,

J