API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jul 6th, 2012
27
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 32.92 KB | None | 0 0
raw download clone embed print report
  1.  
  2.  
  3.  
  4. pt.webdetails.cda.dataaccess.QueryException: Found an unhandled exception:
  5. at pt.webdetails.cda.dataaccess.SimpleDataAccess.queryDataSource(SimpleDataAccess.java:129)
  6. at pt.webdetails.cda.dataaccess.AbstractDataAccess.doQuery(AbstractDataAccess.java:264)
  7. at pt.webdetails.cda.CdaEngine.doQuery(CdaEngine.java:51)
  8. at pt.webdetails.cda.CdaContentGenerator.doQuery(CdaContentGenerator.java:299)
  9. at pt.webdetails.cda.CdaContentGenerator.createContent(CdaContentGenerator.java:137)
  10. at org.saiku.adhoc.service.cda.PluginUtils.callPlugin(PluginUtils.java:163)
  11. at org.saiku.adhoc.service.cda.PluginUtils.callPlugin(PluginUtils.java:152)
  12. at org.saiku.adhoc.service.cda.PluginUtils.callPlugin(PluginUtils.java:58)
  13. at org.saiku.adhoc.service.cda.SaikuCdaQueryBackend.fetchData(SaikuCdaQueryBackend.java:62)
  14. at org.saiku.adhoc.service.cda.SaikuCdaQueryBackend.queryData(SaikuCdaQueryBackend.java:136)
  15. at org.pentaho.reporting.engine.classic.extensions.datasources.cda.CdaDataFactory.queryData(CdaDataFactory.java:191)
  16. at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStatic(CompoundDataFactory.java:135)
  17. at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryInternal(CachingDataFactory.java:431)
  18. at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryStatic(CachingDataFactory.java:184)
  19. at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStatic(CompoundDataFactory.java:130)
  20. at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:85)
  21. at org.pentaho.reporting.engine.classic.core.states.datarow.ReportDataRow.createDataRow(ReportDataRow.java:97)
  22. at org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performQuery(DefaultFlowController.java:188)
  23. at org.saiku.adhoc.service.report.ReportGeneratorService.processReport(ReportGeneratorService.java:268)
  24. at org.saiku.adhoc.service.report.ReportGeneratorService.renderReportHtml(ReportGeneratorService.java:153)
  25. at org.saiku.adhoc.rest.QueryResource.generateReport(QueryResource.java:271)
  26. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  27. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  28. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  29. at java.lang.reflect.Method.invoke(Method.java:597)
  30. at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$TypeOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:168)
  31. at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:71)
  32. at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:280)
  33. at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
  34. at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)
  35. at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
  36. at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)
  37. at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1341)
  38. at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1273)
  39. at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1223)
  40. at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1213)
  41. at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:414)
  42. at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:537)
  43. at org.codehaus.enunciate.modules.jersey.EnunciateJerseyServletContainer.service(EnunciateJerseyServletContainer.java:239)
  44. at org.saiku.adhoc.service.EnunciateJerseyPluginServlet.service(EnunciateJerseyPluginServlet.java:76)
  45. at org.saiku.adhoc.service.ServletAdapterContentGenerator.createContent(ServletAdapterContentGenerator.java:80)
  46. at org.pentaho.platform.web.servlet.GenericServlet.doGet(GenericServlet.java:261)
  47. at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
  48. at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
  49. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
  50. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  51. at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:102)
  52. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
  53. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  54. at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:84)
  55. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
  56. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  57. at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378)
  58. at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
  59. at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
  60. at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
  61. at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)
  62. at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
  63. at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
  64. at org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:103)
  65. at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
  66. at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105)
  67. at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
  68. at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
  69. at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:169)
  70. at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
  71. at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174)
  72. at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
  73. at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
  74. at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278)
  75. at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
  76. at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
  77. at org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89)
  78. at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
  79. at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
  80. at org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:134)
  81. at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
  82. at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)
  83. at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
  84. at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
  85. at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91)
  86. at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
  87. at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
  88. at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175)
  89. at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99)
  90. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
  91. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  92. at org.pentaho.platform.web.http.filters.SystemStatusFilter.doFilter(SystemStatusFilter.java:60)
  93. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
  94. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  95. at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113)
  96. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
  97. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  98. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
  99. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
  100. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470)
  101. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
  102. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
  103. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
  104. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
  105. at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
  106. at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
  107. at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
  108. at java.lang.Thread.run(Thread.java:662)
  109. Caused by: pt.webdetails.cda.dataaccess.QueryException: ReportDataFactoryException : The generated SQL-query did not execute successfully.; Parent exception: ERROR: invalid input syntax for type double precision: ""
  110. Position: 170
  111.  
  112.  
  113. at pt.webdetails.cda.dataaccess.PREDataAccess.performRawQuery(PREDataAccess.java:166)
  114. at pt.webdetails.cda.dataaccess.SimpleDataAccess.queryDataSource(SimpleDataAccess.java:118)
  115. ... 103 more
  116. Caused by: org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: The generated SQL-query did not execute successfully.
  117. at org.pentaho.reporting.engine.classic.extensions.datasources.pmd.SimplePmdDataFactory.buildTableModel(SimplePmdDataFactory.java:431)
  118. at org.pentaho.reporting.engine.classic.extensions.datasources.pmd.SimplePmdDataFactory.queryData(SimplePmdDataFactory.java:510)
  119. at org.pentaho.reporting.engine.classic.extensions.datasources.pmd.PmdDataFactory.queryData(PmdDataFactory.java:169)
  120. at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStatic(CompoundDataFactory.java:135)
  121. at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:85)
  122. at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryInternal(CachingDataFactory.java:434)
  123. at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryData(CachingDataFactory.java:326)
  124. at pt.webdetails.cda.dataaccess.PREDataAccess.performRawQuery(PREDataAccess.java:148)
  125. ... 104 more
  126. 15:52:09,324 ERROR [CdaContentGenerator] Failed to execute: [ pt.webdetails.cda.dataaccess.QueryException ] - Found an unhandled exception: .( Cause [ pt.webdetails.cda.dataaccess.QueryException ] ReportDataFactoryException : The generated SQL-query did not execute successfully.; Parent exception: ERROR: invalid input syntax for type double precision: ""
  127. Position: 170
  128.  
  129. .( Parent [ org.pentaho.reporting.engine.classic.core.ReportDataFactoryException ] The generated SQL-query did not execute successfully.
  130. pt.webdetails.cda.dataaccess.QueryException: Found an unhandled exception:
  131. at pt.webdetails.cda.dataaccess.SimpleDataAccess.queryDataSource(SimpleDataAccess.java:129)
  132. at pt.webdetails.cda.dataaccess.AbstractDataAccess.doQuery(AbstractDataAccess.java:264)
  133. at pt.webdetails.cda.CdaEngine.doQuery(CdaEngine.java:51)
  134. at pt.webdetails.cda.CdaContentGenerator.doQuery(CdaContentGenerator.java:299)
  135. at pt.webdetails.cda.CdaContentGenerator.createContent(CdaContentGenerator.java:137)
  136. at org.saiku.adhoc.service.cda.PluginUtils.callPlugin(PluginUtils.java:163)
  137. at org.saiku.adhoc.service.cda.PluginUtils.callPlugin(PluginUtils.java:152)
  138. at org.saiku.adhoc.service.cda.PluginUtils.callPlugin(PluginUtils.java:58)
  139. at org.saiku.adhoc.service.cda.SaikuCdaQueryBackend.fetchData(SaikuCdaQueryBackend.java:62)
  140. at org.saiku.adhoc.service.cda.SaikuCdaQueryBackend.queryData(SaikuCdaQueryBackend.java:136)
  141. at org.pentaho.reporting.engine.classic.extensions.datasources.cda.CdaDataFactory.queryData(CdaDataFactory.java:191)
  142. at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStatic(CompoundDataFactory.java:135)
  143. at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryInternal(CachingDataFactory.java:431)
  144. at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryStatic(CachingDataFactory.java:184)
  145. at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStatic(CompoundDataFactory.java:130)
  146. at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:85)
  147. at org.pentaho.reporting.engine.classic.core.states.datarow.ReportDataRow.createDataRow(ReportDataRow.java:97)
  148. at org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performQuery(DefaultFlowController.java:188)
  149. at org.saiku.adhoc.service.report.ReportGeneratorService.processReport(ReportGeneratorService.java:268)
  150. at org.saiku.adhoc.service.report.ReportGeneratorService.renderReportHtml(ReportGeneratorService.java:153)
  151. at org.saiku.adhoc.rest.QueryResource.generateReport(QueryResource.java:271)
  152. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  153. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  154. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  155. at java.lang.reflect.Method.invoke(Method.java:597)
  156. at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$TypeOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:168)
  157. at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:71)
  158. at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:280)
  159. at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
  160. at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)
  161. at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
  162. at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)
  163. at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1341)
  164. at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1273)
  165. at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1223)
  166. at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1213)
  167. at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:414)
  168. at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:537)
  169. at org.codehaus.enunciate.modules.jersey.EnunciateJerseyServletContainer.service(EnunciateJerseyServletContainer.java:239)
  170. at org.saiku.adhoc.service.EnunciateJerseyPluginServlet.service(EnunciateJerseyPluginServlet.java:76)
  171. at org.saiku.adhoc.service.ServletAdapterContentGenerator.createContent(ServletAdapterContentGenerator.java:80)
  172. at org.pentaho.platform.web.servlet.GenericServlet.doGet(GenericServlet.java:261)
  173. at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
  174. at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
  175. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
  176. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  177. at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:102)
  178. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
  179. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  180. at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:84)
  181. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
  182. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  183. at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378)
  184. at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
  185. at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
  186. at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
  187. at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)
  188. at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
  189. at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
  190. at org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:103)
  191. at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
  192. at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105)
  193. at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
  194. at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
  195. at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:169)
  196. at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
  197. at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174)
  198. at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
  199. at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
  200. at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278)
  201. at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
  202. at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
  203. at org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89)
  204. at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
  205. at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
  206. at org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:134)
  207. at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
  208. at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)
  209. at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
  210. at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
  211. at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91)
  212. at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
  213. at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
  214. at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175)
  215. at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99)
  216. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
  217. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  218. at org.pentaho.platform.web.http.filters.SystemStatusFilter.doFilter(SystemStatusFilter.java:60)
  219. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
  220. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  221. at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113)
  222. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
  223. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  224. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
  225. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
  226. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470)
  227. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
  228. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
  229. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
  230. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
  231. at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
  232. at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
  233. at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
  234. at java.lang.Thread.run(Thread.java:662)
  235. Caused by: pt.webdetails.cda.dataaccess.QueryException: ReportDataFactoryException : The generated SQL-query did not execute successfully.; Parent exception: ERROR: invalid input syntax for type double precision: ""
  236. Position: 170
  237.  
  238.  
  239. at pt.webdetails.cda.dataaccess.PREDataAccess.performRawQuery(PREDataAccess.java:166)
  240. at pt.webdetails.cda.dataaccess.SimpleDataAccess.queryDataSource(SimpleDataAccess.java:118)
  241. ... 103 more
  242. Caused by: org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: The generated SQL-query did not execute successfully.
  243. at org.pentaho.reporting.engine.classic.extensions.datasources.pmd.SimplePmdDataFactory.buildTableModel(SimplePmdDataFactory.java:431)
  244. at org.pentaho.reporting.engine.classic.extensions.datasources.pmd.SimplePmdDataFactory.queryData(SimplePmdDataFactory.java:510)
  245. at org.pentaho.reporting.engine.classic.extensions.datasources.pmd.PmdDataFactory.queryData(PmdDataFactory.java:169)
  246. at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStatic(CompoundDataFactory.java:135)
  247. at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:85)
  248. at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryInternal(CachingDataFactory.java:434)
  249. at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryData(CachingDataFactory.java:326)
  250. at pt.webdetails.cda.dataaccess.PREDataAccess.performRawQuery(PREDataAccess.java:148)
  251. ... 104 more
  252. [Fatal Error] :-1:-1: Premature end of file.
  253. 15:52:09,327 ERROR [ReportGeneratorService] org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed to send request
  254. 15:52:09,327 ERROR [QueryResource] Cannot generate report (0860D033-AA50-EA62-8297-3432D04F3B0F)
  255. org.saiku.adhoc.exceptions.SaikuAdhocException: ReportGenerator.ERROR_0001 - The CDA Datafactory could not process the query
  256. at org.saiku.adhoc.service.report.ReportGeneratorService.processReport(ReportGeneratorService.java:296)
  257. at org.saiku.adhoc.service.report.ReportGeneratorService.renderReportHtml(ReportGeneratorService.java:153)
  258. at org.saiku.adhoc.rest.QueryResource.generateReport(QueryResource.java:271)
  259. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  260. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  261. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  262. at java.lang.reflect.Method.invoke(Method.java:597)
  263. at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$TypeOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:168)
  264. at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:71)
  265. at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:280)
  266. at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
  267. at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)
  268. at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
  269. at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)
  270. at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1341)
  271. at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1273)
  272. at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1223)
  273. at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1213)
  274. at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:414)
  275. at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:537)
  276. at org.codehaus.enunciate.modules.jersey.EnunciateJerseyServletContainer.service(EnunciateJerseyServletContainer.java:239)
  277. at org.saiku.adhoc.service.EnunciateJerseyPluginServlet.service(EnunciateJerseyPluginServlet.java:76)
  278. at org.saiku.adhoc.service.ServletAdapterContentGenerator.createContent(ServletAdapterContentGenerator.java:80)
  279. at org.pentaho.platform.web.servlet.GenericServlet.doGet(GenericServlet.java:261)
  280. at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
  281. at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
  282. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
  283. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  284. at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:102)
  285. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
  286. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  287. at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:84)
  288. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
  289. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  290. at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378)
  291. at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
  292. at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
  293. at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
  294. at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)
  295. at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
  296. at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
  297. at org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:103)
  298. at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
  299. at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105)
  300. at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
  301. at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
  302. at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:169)
  303. at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
  304. at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174)
  305. at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
  306. at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
  307. at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278)
  308. at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
  309. at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
  310. at org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89)
  311. at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
  312. at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
  313. at org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:134)
  314. at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
  315. at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)
  316. at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
  317. at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
  318. at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91)
  319. at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
  320. at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
  321. at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175)
  322. at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99)
  323. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
  324. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  325. at org.pentaho.platform.web.http.filters.SystemStatusFilter.doFilter(SystemStatusFilter.java:60)
  326. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
  327. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  328. at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113)
  329. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
  330. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  331. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
  332. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
  333. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470)
  334. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
  335. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
  336. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
  337. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
  338. at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
  339. at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
  340. at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
  341. at java.lang.Thread.run(Thread.java:662)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!