java.sql.SQLException: Unknown JDBC escape sequence: {{PREPARELATER:Customers} GROUP BY PRODUCTS.PRODUCTLINE ORDER BY 2 DESC

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Pentaho BI Platform Tracking by Jared Pshedesky, 1 year ago
Unknown JDBC escape sequence: {{PREPARELATER:Customers} GROUP BY PRODUCTS.PRODUCTLINE ORDER BY 2 DESC
via GitHub by mayhew64
, 1 year ago
Unknown JDBC escape sequence: { ? = call EMPLOYEE_LOGIN(?,?) }
via Stack Overflow by span
, 1 year ago
Unknown JDBC escape sequence: { ? = call MY_FUNCTION(?,?) }
java.sql.SQLException: Unknown JDBC escape sequence: {{PREPARELATER:Customers} GROUP BY PRODUCTS.PRODUCTLINE ORDER BY 2 DESC
at org.hsqldb.jdbc.jdbcConnection.onStartEscapeSequence(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.nativeSQL(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.pentaho.platform.plugin.services.connections.sql.SQLConnection.executeQuery(SQLConnection.java:294)
at org.pentaho.platform.plugin.services.connections.sql.SQLConnection.executeQuery(SQLConnection.java:266)
at org.pentaho.platform.plugin.action.sql.SQLBaseComponent.executePrepared(SQLBaseComponent.java:443)
at org.pentaho.platform.plugin.action.jfreereport.helper.PentahoTableDataFactory.queryData(PentahoTableDataFactory.java:116)
at org.jfree.report.states.CachingDataFactory.queryData(CachingDataFactory.java:284)
at org.jfree.report.states.datarow.ReportDataRow.createDataRow(ReportDataRow.java:89)
at org.jfree.report.states.datarow.DefaultFlowController.performSubReportQuery(DefaultFlowController.java:207)
at org.jfree.report.states.process.ProcessState.(ProcessState.java:150)
at org.jfree.report.states.process.ProcessDetailsHandler.commit(ProcessDetailsHandler.java:88)
at org.jfree.report.states.process.ProcessState.commit(ProcessState.java:320)
at org.jfree.report.layout.output.AbstractReportProcessor.processPage(AbstractReportProcessor.java:1052)
at org.jfree.report.layout.output.AbstractReportProcessor.processReport(AbstractReportProcessor.java:1116)
at org.pentaho.platform.plugin.action.jfreereport.JFreeReportComponent.writePdf(JFreeReportComponent.java:1089)
at org.pentaho.platform.plugin.action.jfreereport.JFreeReportComponent.writeReport(JFreeReportComponent.java:958)
at org.pentaho.platform.plugin.action.jfreereport.JFreeReportComponent.generateReport(JFreeReportComponent.java:911)
at org.pentaho.platform.plugin.action.jfreereport.JFreeReportComponent.executeReportAction(JFreeReportComponent.java:307)
at org.pentaho.platform.plugin.action.jfreereport.JFreeReportComponent.executeAction(JFreeReportComponent.java:295)
at org.pentaho.platform.engine.services.solution.ComponentBase.execute(ComponentBase.java:440)
at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeComponent(RuntimeContext.java:1298)
at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeAction(RuntimeContext.java:1265)
at org.pentaho.platform.engine.services.runtime.RuntimeContext.performActions(RuntimeContext.java:1174)
at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeLoop(RuntimeContext.java:1127)
at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:1012)
at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:908)
at org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:409)
at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:313)
at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:192)
at org.pentaho.platform.engine.services.BaseRequestHandler.handleActionRequest(BaseRequestHandler.java:159)
at org.pentaho.platform.web.servlet.ViewAction.handleActionRequest(ViewAction.java:141)
at org.pentaho.platform.web.servlet.ViewAction.doGet(ViewAction.java:268)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265)
at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)
at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:341)
at org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:81)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142)
at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:164)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:174)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:271)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:110)
at org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:129)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.pentaho.platform.web.http.filters.SystemStatusFilter.doFilter(SystemStatusFilter.java:55)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113)
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:174)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
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.coyote.http11.Http11Processor.process(Http11Processor.java:874)
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 java.lang.Thread.run(Unknown Source)

Users with the same issue

You are the first who have seen this exception.

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.