Advertisement
aloumaf

error xreport query with parameters

Dec 6th, 2020
66
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 16.15 KB | None
  1. org.openmrs.module.reporting.evaluation.EvaluationException: Failed to evaluate data set '' because:
  2. Failed to evaluate Error evaluating because:
  3. Unable to retrieve columns for query
  4. at org.openmrs.module.reporting.report.definition.evaluator.DefaultReportDefinitionEvaluator.evaluate(DefaultReportDefinitionEvaluator.java:82)
  5. at org.openmrs.module.reporting.report.definition.evaluator.DefaultReportDefinitionEvaluator.evaluate(DefaultReportDefinitionEvaluator.java:35)
  6. at org.openmrs.module.reporting.definition.service.BaseDefinitionService.executeEvaluator(BaseDefinitionService.java:369)
  7. at org.openmrs.module.reporting.definition.service.BaseDefinitionService.evaluateBypassingExclusionOfTestPatients(BaseDefinitionService.java:272)
  8. at org.openmrs.module.reporting.definition.service.BaseDefinitionService.evaluate(BaseDefinitionService.java:229)
  9. at org.openmrs.module.reporting.report.definition.service.ReportDefinitionServiceImpl.evaluate(ReportDefinitionServiceImpl.java:168)
  10. at org.openmrs.module.reporting.report.definition.service.ReportDefinitionServiceImpl.evaluate(ReportDefinitionServiceImpl.java:37)
  11. at org.openmrs.module.reporting.definition.service.BaseDefinitionService.evaluate(BaseDefinitionService.java:353)
  12. at org.openmrs.module.reporting.report.definition.service.ReportDefinitionServiceImpl.evaluate(ReportDefinitionServiceImpl.java:160)
  13. at sun.reflect.GeneratedMethodAccessor1060.invoke(Unknown Source)
  14. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  15. at java.lang.reflect.Method.invoke(Method.java:498)
  16. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
  17. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
  18. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
  19. at org.springframework.cache.interceptor.CacheInterceptor$1.invoke(CacheInterceptor.java:52)
  20. at org.springframework.cache.interceptor.CacheAspectSupport.execute(CacheAspectSupport.java:303)
  21. at org.springframework.cache.interceptor.CacheInterceptor.invoke(CacheInterceptor.java:61)
  22. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  23. at org.openmrs.aop.LoggingAdvice.invoke(LoggingAdvice.java:122)
  24. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  25. at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52)
  26. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  27. at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52)
  28. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  29. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
  30. at com.sun.proxy.$Proxy153.evaluate(Unknown Source)
  31. at sun.reflect.GeneratedMethodAccessor1060.invoke(Unknown Source)
  32. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  33. at java.lang.reflect.Method.invoke(Method.java:498)
  34. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
  35. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:201)
  36. at com.sun.proxy.$Proxy348.evaluate(Unknown Source)
  37. at org.openmrs.module.reporting.report.service.ReportServiceImpl.runReport(ReportServiceImpl.java:471)
  38. at sun.reflect.GeneratedMethodAccessor1041.invoke(Unknown Source)
  39. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  40. at java.lang.reflect.Method.invoke(Method.java:498)
  41. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
  42. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:201)
  43. at com.sun.proxy.$Proxy247.runReport(Unknown Source)
  44. at sun.reflect.GeneratedMethodAccessor1041.invoke(Unknown Source)
  45. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  46. at java.lang.reflect.Method.invoke(Method.java:498)
  47. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
  48. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
  49. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
  50. at org.springframework.cache.interceptor.CacheInterceptor$1.invoke(CacheInterceptor.java:52)
  51. at org.springframework.cache.interceptor.CacheAspectSupport.execute(CacheAspectSupport.java:303)
  52. at org.springframework.cache.interceptor.CacheInterceptor.invoke(CacheInterceptor.java:61)
  53. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  54. at org.openmrs.aop.LoggingAdvice.invoke(LoggingAdvice.java:122)
  55. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  56. at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52)
  57. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  58. at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52)
  59. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  60. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
  61. at com.sun.proxy.$Proxy248.runReport(Unknown Source)
  62. at sun.reflect.GeneratedMethodAccessor1041.invoke(Unknown Source)
  63. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  64. at java.lang.reflect.Method.invoke(Method.java:498)
  65. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
  66. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:201)
  67. at com.sun.proxy.$Proxy248.runReport(Unknown Source)
  68. at org.openmrs.module.reporting.report.task.RunQueuedReportsTask.executeTask(RunQueuedReportsTask.java:59)
  69. at org.openmrs.module.reporting.report.task.ReportingTask.run(ReportingTask.java:37)
  70. at org.openmrs.api.context.Daemon$6.run(Daemon.java:356)
  71. Caused by: org.openmrs.module.reporting.evaluation.EvaluationException: Failed to evaluate Error evaluating because:
  72. Unable to retrieve columns for query
  73. at org.openmrs.module.reporting.definition.service.BaseDefinitionService.executeEvaluator(BaseDefinitionService.java:377)
  74. at org.openmrs.module.reporting.definition.service.BaseDefinitionService.evaluateBypassingExclusionOfTestPatients(BaseDefinitionService.java:264)
  75. at org.openmrs.module.reporting.definition.service.BaseDefinitionService.evaluate(BaseDefinitionService.java:229)
  76. at org.openmrs.module.reporting.dataset.definition.service.DataSetDefinitionServiceImpl.evaluate(DataSetDefinitionServiceImpl.java:41)
  77. at sun.reflect.GeneratedMethodAccessor993.invoke(Unknown Source)
  78. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  79. at java.lang.reflect.Method.invoke(Method.java:498)
  80. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
  81. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
  82. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
  83. at org.springframework.cache.interceptor.CacheInterceptor$1.invoke(CacheInterceptor.java:52)
  84. at org.springframework.cache.interceptor.CacheAspectSupport.execute(CacheAspectSupport.java:303)
  85. at org.springframework.cache.interceptor.CacheInterceptor.invoke(CacheInterceptor.java:61)
  86. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  87. at org.openmrs.aop.LoggingAdvice.invoke(LoggingAdvice.java:122)
  88. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  89. at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52)
  90. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  91. at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52)
  92. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  93. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
  94. at com.sun.proxy.$Proxy164.evaluate(Unknown Source)
  95. at sun.reflect.GeneratedMethodAccessor993.invoke(Unknown Source)
  96. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  97. at java.lang.reflect.Method.invoke(Method.java:498)
  98. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
  99. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:201)
  100. at com.sun.proxy.$Proxy359.evaluate(Unknown Source)
  101. at org.openmrs.module.reporting.report.definition.evaluator.DefaultReportDefinitionEvaluator.evaluate(DefaultReportDefinitionEvaluator.java:78)
  102. ... 66 more
  103. Caused by: java.lang.IllegalArgumentException: Unable to retrieve columns for query
  104. at org.openmrs.module.reporting.evaluation.querybuilder.SqlQueryBuilder.getColumns(SqlQueryBuilder.java:138)
  105. at org.openmrs.module.reporting.evaluation.service.EvaluationServiceImpl.getColumns(EvaluationServiceImpl.java:36)
  106. at sun.reflect.GeneratedMethodAccessor997.invoke(Unknown Source)
  107. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  108. at java.lang.reflect.Method.invoke(Method.java:498)
  109. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
  110. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
  111. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
  112. at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
  113. at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
  114. at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
  115. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  116. at org.springframework.cache.interceptor.CacheInterceptor$1.invoke(CacheInterceptor.java:52)
  117. at org.springframework.cache.interceptor.CacheAspectSupport.execute(CacheAspectSupport.java:303)
  118. at org.springframework.cache.interceptor.CacheInterceptor.invoke(CacheInterceptor.java:61)
  119. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  120. at org.openmrs.aop.LoggingAdvice.invoke(LoggingAdvice.java:122)
  121. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  122. at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52)
  123. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  124. at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52)
  125. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  126. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
  127. at com.sun.proxy.$Proxy152.getColumns(Unknown Source)
  128. at sun.reflect.GeneratedMethodAccessor997.invoke(Unknown Source)
  129. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  130. at java.lang.reflect.Method.invoke(Method.java:498)
  131. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
  132. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
  133. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
  134. at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
  135. at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
  136. at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
  137. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  138. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
  139. at com.sun.proxy.$Proxy347.getColumns(Unknown Source)
  140. at org.openmrs.module.reporting.dataset.definition.evaluator.SqlDataSetEvaluator.evaluate(SqlDataSetEvaluator.java:80)
  141. at org.openmrs.module.reporting.dataset.definition.evaluator.SqlDataSetEvaluator.evaluate(SqlDataSetEvaluator.java:36)
  142. at org.openmrs.module.reporting.definition.service.BaseDefinitionService.executeEvaluator(BaseDefinitionService.java:369)
  143. ... 94 more
  144. Caused by: org.hibernate.exception.SQLGrammarException: error executing work
  145. at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:80)
  146. at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
  147. at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
  148. at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)
  149. at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.coordinateWork(JdbcCoordinatorImpl.java:318)
  150. at org.hibernate.internal.SessionImpl.doWork(SessionImpl.java:2095)
  151. at org.hibernate.internal.SessionImpl.doWork(SessionImpl.java:2080)
  152. at org.openmrs.api.db.hibernate.DbSession.doWork(DbSession.java:1005)
  153. at org.openmrs.module.reporting.evaluation.querybuilder.SqlQueryBuilder.getColumns(SqlQueryBuilder.java:113)
  154. ... 132 more
  155. Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':startDate and :endDate
  156. and pa.person_attribute_type_id = "13"
  157. and v.patient_i' at line 5
  158. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  159. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  160. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  161. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  162. at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
  163. at com.mysql.jdbc.Util.getInstance(Util.java:408)
  164. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
  165. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
  166. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
  167. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
  168. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
  169. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
  170. at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
  171. at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1197)
  172. at com.mysql.jdbc.PreparedStatement.getMetaData(PreparedStatement.java:2524)
  173. at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.getMetaData(NewProxyPreparedStatement.java:64)
  174. at org.openmrs.module.reporting.evaluation.querybuilder.SqlQueryBuilder$1.execute(SqlQueryBuilder.java:120)
  175. at org.hibernate.jdbc.WorkExecutor.executeWork(WorkExecutor.java:54)
  176. at org.hibernate.internal.SessionImpl$2.accept(SessionImpl.java:2076)
  177. at org.hibernate.internal.SessionImpl$2.accept(SessionImpl.java:2073)
  178. at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.coordinateWork(JdbcCoordinatorImpl.java:313)
  179. ... 136 more
  180.  
Advertisement
RAW Paste Data Copied
Advertisement