Unable to add new conditon

akakorozya · September 17, 2018, 12:15pm

This is the demo page you asked me to test if “Save Condition” Can work Unfortunately the demo site is down https://demo.openmrs.org/openmrs/

dkayiwa · September 17, 2018, 2:04pm

When did you last check the demo site?

jwnasambu · September 17, 2018, 2:32pm

@akakorozya the demo site is on just enter the requirements. When you keep quite no one can tell that you need help. Kindly share you will be helped.

akakorozya · September 17, 2018, 5:19pm

The demo site is now up and running. However I am still unable to change default_locate neither Save Condition with the following exception for changing default_locale

type Exception report

message Request processing failed; nested exception is org.hibernate.exception.GenericJDBCException: could not execute batch

description The server encountered an internal error that prevented it from fulfilling this request.

exception

org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.hibernate.exception.GenericJDBCException: could not execute batch org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:978) org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:868) javax.servlet.http.HttpServlet.service(HttpServlet.java:650) org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:842) javax.servlet.http.HttpServlet.service(HttpServlet.java:731) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:72) org.openmrs.module.owa.filter.OwaFilter.doFilter(OwaFilter.java:57) org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:70) org.openmrs.module.web.filter.ModuleFilter.doFilter(ModuleFilter.java:54) org.openmrs.web.filter.OpenmrsFilter.doFilterInternal(OpenmrsFilter.java:108) org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:150) org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:105) org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:105) org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:105) org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) root cause

org.hibernate.exception.GenericJDBCException: could not execute batch org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54) org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126) org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:136) org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(BatchingBatch.java:114) org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(AbstractBatchImpl.java:163) org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.executeBatch(JdbcCoordinatorImpl.java:226) org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:484) org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:351) org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:350) org.hibernate.event.internal.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:67) org.hibernate.internal.SessionImpl.autoFlushIfRequired(SessionImpl.java:1227) org.hibernate.internal.SessionImpl.list(SessionImpl.java:1293) org.hibernate.internal.QueryImpl.list(QueryImpl.java:103) org.hibernate.internal.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:966) org.openmrs.api.db.hibernate.HibernateUserDAO.hasDuplicateUsername(HibernateUserDAO.java:142) org.openmrs.api.impl.UserServiceImpl.hasDuplicateUsername(UserServiceImpl.java:119) org.openmrs.api.impl.UserServiceImpl.saveUser(UserServiceImpl.java:146) sun.reflect.GeneratedMethodAccessor1255.invoke(Unknown Source) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.lang.reflect.Method.invoke(Method.java:498) org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99) org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281) org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207) com.sun.proxy.$Proxy164.saveUser(Unknown Source) sun.reflect.GeneratedMethodAccessor1255.invoke(Unknown Source) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.lang.reflect.Method.invoke(Method.java:498) org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) org.springframework.cache.interceptor.CacheInterceptor$1.invoke(CacheInterceptor.java:52) org.springframework.cache.interceptor.CacheAspectSupport.invokeOperation(CacheAspectSupport.java:317) org.springframework.cache.interceptor.CacheAspectSupport.execute(CacheAspectSupport.java:350) org.springframework.cache.interceptor.CacheAspectSupport.execute(CacheAspectSupport.java:299) org.springframework.cache.interceptor.CacheInterceptor.invoke(CacheInterceptor.java:61) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) org.openmrs.aop.LoggingAdvice.invoke(LoggingAdvice.java:121) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207) com.sun.proxy.$Proxy165.saveUser(Unknown Source) org.openmrs.web.controller.OptionsFormController.onSubmit(OptionsFormController.java:272) org.springframework.web.servlet.mvc.SimpleFormController.processFormSubmission(SimpleFormController.java:274) org.openmrs.web.controller.OptionsFormController.processFormSubmission(OptionsFormController.java:99) org.springframework.web.servlet.mvc.AbstractFormController.handleRequestInternal(AbstractFormController.java:275) org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:146) org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:50) org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:943) org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:877) org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:966) org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:868) javax.servlet.http.HttpServlet.service(HttpServlet.java:650) org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:842) javax.servlet.http.HttpServlet.service(HttpServlet.java:731) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:72) org.openmrs.module.owa.filter.OwaFilter.doFilter(OwaFilter.java:57) org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:70) org.openmrs.module.web.filter.ModuleFilter.doFilter(ModuleFilter.java:54) org.openmrs.web.filter.OpenmrsFilter.doFilterInternal(OpenmrsFilter.java:108) org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:150) org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:105) org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:105) org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:105) org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) root cause

java.sql.BatchUpdateException: admin user account is locked com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2055) com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1467) com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1135) org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:127) org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(BatchingBatch.java:114) org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(AbstractBatchImpl.java:163) org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.executeBatch(JdbcCoordinatorImpl.java:226) org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:484) org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:351) org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:350) org.hibernate.event.internal.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:67) org.hibernate.internal.SessionImpl.autoFlushIfRequired(SessionImpl.java:1227) org.hibernate.internal.SessionImpl.list(SessionImpl.java:1293) org.hibernate.internal.QueryImpl.list(QueryImpl.java:103) org.hibernate.internal.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:966) org.openmrs.api.db.hibernate.HibernateUserDAO.hasDuplicateUsername(HibernateUserDAO.java:142) org.openmrs.api.impl.UserServiceImpl.hasDuplicateUsername(UserServiceImpl.java:119) org.openmrs.api.impl.UserServiceImpl.saveUser(UserServiceImpl.java:146) sun.reflect.GeneratedMethodAccessor1255.invoke(Unknown Source) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.lang.reflect.Method.invoke(Method.java:498) org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99) org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281) org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207) com.sun.proxy.$Proxy164.saveUser(Unknown Source) sun.reflect.GeneratedMethodAccessor1255.invoke(Unknown Source) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.lang.reflect.Method.invoke(Method.java:498) org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) org.springframework.cache.interceptor.CacheInterceptor$1.invoke(CacheInterceptor.java:52) org.springframework.cache.interceptor.CacheAspectSupport.invokeOperation(CacheAspectSupport.java:317) org.springframework.cache.interceptor.CacheAspectSupport.execute(CacheAspectSupport.java:350) org.springframework.cache.interceptor.CacheAspectSupport.execute(CacheAspectSupport.java:299) org.springframework.cache.interceptor.CacheInterceptor.invoke(CacheInterceptor.java:61) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) org.openmrs.aop.LoggingAdvice.invoke(LoggingAdvice.java:121) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207) com.sun.proxy.$Proxy165.saveUser(Unknown Source) org.openmrs.web.controller.OptionsFormController.onSubmit(OptionsFormController.java:272) org.springframework.web.servlet.mvc.SimpleFormController.processFormSubmission(SimpleFormController.java:274) org.openmrs.web.controller.OptionsFormController.processFormSubmission(OptionsFormController.java:99) org.springframework.web.servlet.mvc.AbstractFormController.handleRequestInternal(AbstractFormController.java:275) org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:146) org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:50) org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:943) org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:877) org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:966) org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:868) javax.servlet.http.HttpServlet.service(HttpServlet.java:650) org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:842) javax.servlet.http.HttpServlet.service(HttpServlet.java:731) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:72) org.openmrs.module.owa.filter.OwaFilter.doFilter(OwaFilter.java:57) org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:70) org.openmrs.module.web.filter.ModuleFilter.doFilter(ModuleFilter.java:54) org.openmrs.web.filter.OpenmrsFilter.doFilterInternal(OpenmrsFilter.java:108) org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:150) org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:105) org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:105) org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:105) org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) root cause

java.sql.SQLException: admin user account is locked com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1086) com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237) com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169) com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617) com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778) com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2825) com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2156) com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2441) com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2007) com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1467) com.mchange.v2.c3p0.impl.NewProxyPreparedSta

dkayiwa · September 17, 2018, 5:29pm

Can you share a screenshot or url of the exact page you are using to change the default_locale?

akakorozya · September 17, 2018, 6:05pm

dkayiwa · September 18, 2018, 6:01am

Can you change it from here? https://demo.openmrs.org/openmrs/admin/maintenance/settings.list

akakorozya · September 18, 2018, 6:27am

Yes, there I can successfully change

dkayiwa · September 18, 2018, 7:08am

So are you now able to add a new condition?

akakorozya · September 18, 2018, 7:47am

Unfortunately No!! See the screen shot

dkayiwa · September 18, 2018, 7:55am

Is that on the demo server?

akakorozya · September 18, 2018, 7:55am

Yes, it is

dkayiwa · September 18, 2018, 8:03am

But you have not yet changed the setting that i told you to.

akakorozya · September 18, 2018, 8:10am

Yes, I did as per the screenshot below

dkayiwa · September 18, 2018, 8:20am

That does not look like the value i told you to set. Can you read my post again?

akakorozya · September 18, 2018, 8:24am

THANKS!!! I have changed to “en” from “en_GB” now it works Thank you again

akakorozya · September 18, 2018, 8:28am

However it seems to be fixed on the demo server, but not on my cloud server. What what should I do to now??

dkayiwa · September 18, 2018, 8:35am

You need to do the same change on your local server.

akakorozya · September 18, 2018, 8:49am

I have done the same but still unable to save condition

dkayiwa · September 18, 2018, 9:30am

Can you share a screenshot of this setting value on your server?