dhis2-users team mailing list archive

Thread
Date

Error when introducing patient data

To: dhis2-users <dhis2-users@xxxxxxxxxxxxxxxxxxx>
From: Marta Vila <martavila@xxxxxxxxx>
Date: Thu, 4 Oct 2012 09:59:45 +0200

Dear all,

I´ve updated a 2.6 instance of dhis to 2.9. I´ve  done it gradually,
version by version, and everything is ok but the patient data entry screen.
When I try to introduce data to any program I get an error saying something
like "Failure while storing values with error code [object Object]"

I´ve created the option set to replace the categories in the patient domain
data elements, but still I get the error.

Please find attached the pop up image and the log

This is an instance for Peru. It would be nice to give them a complete
instance with some patient forms.
If it doesn´t work... We´ll give them Org.units, GIS and aggregated data
forms... which not bad anyway.

Thanks!

        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a298)
        at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcesso
r.java861)
        at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.pr
ocess(Http11AprProtocol.java579)
        at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java15
84)
        at java.lang.Thread.run(Thread.java619)
 ERROR 2012-10-04 095415,671 Left side ($noIden) of '' operation has null va
lue at dhis-web-caseentryprogramEnrollmentForm.vm[line 22, column 39] (Log4JLo
gChute.java [http-8080-5])
 ERROR 2012-10-04 095415,676 Left side ($noOtherGroup) of '' operation has n
ull value at dhis-web-caseentryprogramEnrollmentForm.vm[line 22, column 60] (L
og4JLogChute.java [http-8080-5])
 ERROR 2012-10-04 095415,676 Left side ($noGroup) of '' operation has null v
alue at dhis-web-caseentryprogramEnrollmentForm.vm[line 22, column 76] (Log4JL
ogChute.java [http-8080-5])
 ERROR 2012-10-04 095415,676 Left side ($noIden) of '' operation has null va
lue at dhis-web-caseentryprogramEnrollmentForm.vm[line 201, column 31] (Log4JL
ogChute.java [http-8080-5])
 ERROR 2012-10-04 095415,676 Left side ($noOtherGroup) of '' operation has n
ull value at dhis-web-caseentryprogramEnrollmentForm.vm[line 201, column 52] (
Log4JLogChute.java [http-8080-5])
 ERROR 2012-10-04 095415,676 Left side ($noGroup) of '' operation has null v
alue at dhis-web-caseentryprogramEnrollmentForm.vm[line 201, column 68] (Log4J
LogChute.java [http-8080-5])
 WARN  2012-10-04 095424,623 SQL Error 1364, SQLState HY000 (SqlExceptionHe
lper.java [http-8080-5])
 ERROR 2012-10-04 095424,625 Field 'organisationunitid' doesn't have a defaul
t value (SqlExceptionHelper.java [http-8080-5])
 ERROR 2012-10-04 095424,628 Error while executing action (ExceptionIntercept
or.java [http-8080-5])
org.springframework.orm.hibernate4.HibernateJdbcException JDBC exception on Hib
ernate data access SQLException for SQL [na]; SQL state [HY000]; error code [1
364]; Field 'organisationunitid' doesn't have a default value; nested exception
is org.hibernate.exception.GenericJDBCException Field 'organisationunitid' does
n't have a default value
        at org.springframework.orm.hibernate4.SessionFactoryUtils.convertHiberna
teAccessException(SessionFactoryUtils.java167)
        at org.springframework.orm.hibernate4.HibernateTransactionManager.conver
tHibernateAccessException(HibernateTransactionManager.java606)
        at org.springframework.orm.hibernate4.HibernateTransactionManager.doComm
it(HibernateTransactionManager.java488)
        at org.springframework.transaction.support.AbstractPlatformTransactionMa
nager.processCommit(AbstractPlatformTransactionManager.java754)
        at org.springframework.transaction.support.AbstractPlatformTransactionMa
nager.commit(AbstractPlatformTransactionManager.java723)
        at org.springframework.transaction.interceptor.TransactionAspectSupport.
commitTransactionAfterReturning(TransactionAspectSupport.java393)
        at org.springframework.transaction.interceptor.TransactionInterceptor.in
voke(TransactionInterceptor.java120)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java172)
        at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invok
e(ExposeInvocationInterceptor.java90)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java172)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java202)
        at $Proxy68.savePatientDataValue(Unknown Source)
        at org.hisp.dhis.caseentry.action.caseentry.SaveValueAction.execute(Save
ValueAction.java169)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java25)
        at java.lang.reflect.Method.invoke(Method.java597)
        at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultA
ctionInvocation.java453)
        at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(Defa
ultActionInvocation.java292)
        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java255)
        at org.hisp.dhis.webportal.interceptor.XWorkPortalUserInterceptor.interc
ept(XWorkPortalUserInterceptor.java87)
        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java249)
        at org.hisp.dhis.webportal.interceptor.XWorkPortalModuleInterceptor.inte
rcept(XWorkPortalModuleInterceptor.java90)
        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java249)
        at org.hisp.dhis.webportal.interceptor.XWorkPortalMenuInterceptor.interc
ept(XWorkPortalMenuInterceptor.java96)
        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java249)
        at org.hisp.dhis.webportal.interceptor.XWorkPortalParamsInterceptor.inte
rcept(XWorkPortalParamsInterceptor.java118)
        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java249)
        at org.hisp.dhis.interceptor.ContextInterceptor.intercept(ContextInterce
ptor.java81)
        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java249)
        at org.hisp.dhis.interceptor.UserSettingInterceptor.intercept(UserSettin
gInterceptor.java80)
        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java249)
        at org.hisp.dhis.security.intercept.LoginInterceptor.intercept(LoginInte
rceptor.java84)
        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java249)
        at org.hisp.dhis.security.intercept.XWorkSecurityInterceptor.intercept(X
WorkSecurityInterceptor.java103)
        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java249)
        at org.hisp.dhis.interceptor.SystemSettingInterceptor.intercept(SystemSe
ttingInterceptor.java88)
        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java249)
        at org.hisp.dhis.interceptor.I18nInterceptor.intercept(I18nInterceptor.j
ava137)
        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java249)
        at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept
(ParametersInterceptor.java211)
        at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept
(MethodFilterInterceptor.java98)
        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java249)
        at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.inter
cept(StaticParametersInterceptor.java190)
        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java249)
        at org.hisp.dhis.interceptor.ExceptionInterceptor.intercept(ExceptionInt
erceptor.java100)
        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java249)
        at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.j
ava54)
        at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.jav
a510)
        at org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatc
her.java432)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java206)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java322)
        at org.springframework.security.web.access.intercept.FilterSecurityInter
ceptor.invoke(FilterSecurityInterceptor.java116)
        at org.springframework.security.web.access.intercept.FilterSecurityInter
ceptor.doFilter(FilterSecurityInterceptor.java83)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java334)
        at org.springframework.security.web.access.ExceptionTranslationFilter.do
Filter(ExceptionTranslationFilter.java113)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java334)
        at org.springframework.security.web.session.SessionManagementFilter.doFi
lter(SessionManagementFilter.java103)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java334)
        at org.springframework.security.web.authentication.AnonymousAuthenticati
onFilter.doFilter(AnonymousAuthenticationFilter.java113)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java334)
        at org.springframework.security.web.servletapi.SecurityContextHolderAwar
eRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java54)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java334)
        at org.springframework.security.web.savedrequest.RequestCacheAwareFilter
.doFilter(RequestCacheAwareFilter.java45)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java334)
        at org.springframework.security.web.authentication.www.BasicAuthenticati
onFilter.doFilter(BasicAuthenticationFilter.java150)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java334)
        at org.springframework.security.web.authentication.AbstractAuthenticatio
nProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java182)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java334)
        at org.springframework.security.web.authentication.logout.LogoutFilter.d
oFilter(LogoutFilter.java105)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java334)
        at org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(Automati
cAccessFilter.java112)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java334)
        at org.springframework.security.web.context.SecurityContextPersistenceFi
lter.doFilter(SecurityContextPersistenceFilter.java87)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java334)
        at org.springframework.security.web.FilterChainProxy.doFilterInternal(Fi
lterChainProxy.java184)
        at org.springframework.security.web.FilterChainProxy.doFilter(FilterChai
nProxy.java155)
        at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(D
elegatingFilterProxy.java346)
        at org.springframework.web.filter.DelegatingFilterProxy.doFilter(Delegat
ingFilterProxy.java259)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java206)
        at org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.do
FilterInternal(OpenSessionInViewFilter.java119)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerR
equestFilter.java76)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a298)
        at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcesso
r.java861)
        at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.pr
ocess(Http11AprProtocol.java579)
        at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java15
84)
        at java.lang.Thread.run(Thread.java619)
Caused by org.hibernate.exception.GenericJDBCException Field 'organisationunit
id' doesn't have a default value
        at org.hibernate.exception.internal.StandardSQLExceptionConverter.conver
t(StandardSQLExceptionConverter.java54)
        at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlException
Helper.java125)
        at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlException
Helper.java110)
        at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandle
r.continueInvocation(AbstractStatementProxyHandler.java129)
        at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(
AbstractProxyHandler.java81)
        at $Proxy120.executeUpdate(Unknown Source)
        at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(
NonBatchingBatch.java56)
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(Abstrac
tEntityPersister.java2859)
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(Abstrac
tEntityPersister.java3300)
        at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsert
Action.java88)
        at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java362)
        at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java
354)
        at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java
275)
        at org.hibernate.event.internal.AbstractFlushingEventListener.performExe
cutions(AbstractFlushingEventListener.java326)
        at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(Defaul
tFlushEventListener.java52)
        at org.hibernate.internal.SessionImpl.flush(SessionImpl.java1214)
        at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java403)

        at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.before
TransactionCommit(JdbcTransaction.java101)
        at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.commit(A
bstractTransactionImpl.java175)
        at org.springframework.orm.hibernate4.HibernateTransactionManager.doComm
it(HibernateTransactionManager.java480)
        ... 93 more
Caused by java.sql.SQLException Field 'organisationunitid' doesn't have a defa
ult value
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java1073)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java4096)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java4028)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java2490)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java2651)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java2683)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va2144)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
2444)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
2362)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
2347)
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewP
roxyPreparedStatement.java105)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java25)
        at java.lang.reflect.Method.invoke(Method.java597)
        at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandle
r.continueInvocation(AbstractStatementProxyHandler.java122)
        ... 109 more

Attachment: error.jpg
Description: JPEG image