API tools faq
paste
Advertisement
Guest User

ID Generation Links Failing

a guest
Oct 26th, 2015
127
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 18.28 KB | None | 0 0
raw download clone embed print report
  1. HTTP Status 500 - could not execute query
  2.  
  3. type Exception report
  4.  
  5. message could not execute query
  6.  
  7. description The server encountered an internal error that prevented it from fulfilling this request.
  8.  
  9. exception
  10.  
  11. org.hibernate.exception.SQLGrammarException: could not execute query
  12.     org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
  13.     org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
  14.     org.hibernate.loader.Loader.doList(Loader.java:2536)
  15.     org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
  16.     org.hibernate.loader.Loader.list(Loader.java:2271)
  17.     org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:119)
  18.     org.hibernate.impl.SessionImpl.list(SessionImpl.java:1716)
  19.     org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347)
  20.     org.openmrs.module.idgen.service.db.HibernateIdentifierSourceDAO.getAllIdentifierSources(HibernateIdentifierSourceDAO.java:76)
  21.     sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  22.     sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  23.     sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  24.     java.lang.reflect.Method.invoke(Method.java:483)
  25.     org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
  26.     org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  27.     org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  28.     org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
  29.     org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
  30.     org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
  31.     org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  32.     org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
  33.     com.sun.proxy.$Proxy233.getAllIdentifierSources(Unknown Source)
  34.     org.openmrs.module.idgen.service.BaseIdentifierSourceService.getAllIdentifierSources(BaseIdentifierSourceService.java:93)
  35.     org.openmrs.module.idgen.service.BaseIdentifierSourceService.getIdentifierSourcesByType(BaseIdentifierSourceService.java:105)
  36.     sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  37.     sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  38.     sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  39.     java.lang.reflect.Method.invoke(Method.java:483)
  40.     org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
  41.     org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  42.     org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  43.     org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
  44.     org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
  45.     org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
  46.     org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  47.     org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
  48.     com.sun.proxy.$Proxy234.getIdentifierSourcesByType(Unknown Source)
  49.     sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  50.     sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  51.     sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  52.     java.lang.reflect.Method.invoke(Method.java:483)
  53.     org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
  54.     org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  55.     org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  56.     org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
  57.     org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
  58.     org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
  59.     org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  60.     org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:51)
  61.     org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  62.     org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
  63.     com.sun.proxy.$Proxy240.getIdentifierSourcesByType(Unknown Source)
  64.     sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  65.     sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  66.     sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  67.     java.lang.reflect.Method.invoke(Method.java:483)
  68.     org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
  69.     org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  70.     org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  71.     org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
  72.     org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
  73.     org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
  74.     org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  75.     org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
  76.     com.sun.proxy.$Proxy240.getIdentifierSourcesByType(Unknown Source)
  77.     org.openmrs.module.idgen.web.controller.IdentifierSourceController.manageIdentifierSources(IdentifierSourceController.java:121)
  78.     sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  79.     sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  80.     sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  81.     java.lang.reflect.Method.invoke(Method.java:483)
  82.     org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176)
  83.     org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:440)
  84.     org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:428)
  85.     org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:925)
  86.     org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:856)
  87.     org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:953)
  88.     org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:844)
  89.     javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
  90.     org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:829)
  91.     javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
  92.     org.openmrs.module.web.filter.ForcePasswordChangeFilter.doFilter(ForcePasswordChangeFilter.java:61)
  93.     org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:72)
  94.     org.openmrs.module.web.filter.ModuleFilter.doFilter(ModuleFilter.java:54)
  95.     org.openmrs.web.filter.OpenmrsFilter.doFilterInternal(OpenmrsFilter.java:109)
  96.     org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  97.     org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:230)
  98.     org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  99.     org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:105)
  100.     org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:105)
  101.     org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:105)
  102.     org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
  103.     org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  104. root cause
  105.  
  106. com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'this_1_.length' in 'field list'
  107.     sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  108.     sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  109.     sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  110.     java.lang.reflect.Constructor.newInstance(Constructor.java:408)
  111.     com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
  112.     com.mysql.jdbc.Util.getInstance(Util.java:386)
  113.     com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
  114.     com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
  115.     com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
  116.     com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)
  117.     com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)
  118.     com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2825)
  119.     com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2156)
  120.     com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2313)
  121.     com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
  122.     org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
  123.     org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
  124.     org.hibernate.loader.Loader.doQuery(Loader.java:802)
  125.     org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
  126.     org.hibernate.loader.Loader.doList(Loader.java:2533)
  127.     org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
  128.     org.hibernate.loader.Loader.list(Loader.java:2271)
  129.     org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:119)
  130.     org.hibernate.impl.SessionImpl.list(SessionImpl.java:1716)
  131.     org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347)
  132.     org.openmrs.module.idgen.service.db.HibernateIdentifierSourceDAO.getAllIdentifierSources(HibernateIdentifierSourceDAO.java:76)
  133.     sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  134.     sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  135.     sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  136.     java.lang.reflect.Method.invoke(Method.java:483)
  137.     org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
  138.     org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  139.     org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  140.     org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
  141.     org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
  142.     org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
  143.     org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  144.     org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
  145.     com.sun.proxy.$Proxy233.getAllIdentifierSources(Unknown Source)
  146.     org.openmrs.module.idgen.service.BaseIdentifierSourceService.getAllIdentifierSources(BaseIdentifierSourceService.java:93)
  147.     org.openmrs.module.idgen.service.BaseIdentifierSourceService.getIdentifierSourcesByType(BaseIdentifierSourceService.java:105)
  148.     sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  149.     sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  150.     sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  151.     java.lang.reflect.Method.invoke(Method.java:483)
  152.     org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
  153.     org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  154.     org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  155.     org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
  156.     org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
  157.     org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
  158.     org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  159.     org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
  160.     com.sun.proxy.$Proxy234.getIdentifierSourcesByType(Unknown Source)
  161.     sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  162.     sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  163.     sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  164.     java.lang.reflect.Method.invoke(Method.java:483)
  165.     org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
  166.     org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  167.     org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  168.     org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
  169.     org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
  170.     org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
  171.     org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  172.     org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:51)
  173.     org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  174.     org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
  175.     com.sun.proxy.$Proxy240.getIdentifierSourcesByType(Unknown Source)
  176.     sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  177.     sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  178.     sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  179.     java.lang.reflect.Method.invoke(Method.java:483)
  180.     org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
  181.     org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  182.     org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  183.     org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
  184.     org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
  185.     org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
  186.     org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  187.     org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
  188.     com.sun.proxy.$Proxy240.getIdentifierSourcesByType(Unknown Source)
  189.     org.openmrs.module.idgen.web.controller.IdentifierSourceController.manageIdentifierSources(IdentifierSourceController.java:121)
  190.     sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  191.     sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  192.     sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  193.     java.lang.reflect.Method.invoke(Method.java:483)
  194.     org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176)
  195.     org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:440)
  196.     org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:428)
  197.     org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:925)
  198.     org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:856)
  199.     org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:953)
  200.     org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:844)
  201.     javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
  202.     org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:829)
  203.     javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
  204.     org.openmrs.module.web.filter.ForcePasswordChangeFilter.doFilter(ForcePasswordChangeFilter.java:61)
  205.     org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:72)
  206.     org.openmrs.module.web.filter.ModuleFilter.doFilter(ModuleFilter.java:54)
  207.     org.openmrs.web.filter.OpenmrsFilter.doFilterInternal(OpenmrsFilter.java:109)
  208.     org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  209.     org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:230)
  210.     org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  211.     org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:105)
  212.     org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:105)
  213.     org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:105)
  214.     org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
  215.     org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  216. note The full stack trace of the root cause is available in the Apache Tomcat/6.0.44 logs.
  217.  
  218. Apache Tomcat/6.0.44
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!