← Back to team overview

dhis2-devs team mailing list archive

java.sql.SQLException: Field 'periodid' doesn't have a default value

 

Currently I use MySQL 5, Tomcat 7 on Linux.

dhis2 version 2.16

Have any one encountered this issues?

Here is the trace:

equestFilter.java:106)
        at
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(Servlet
Handler.java:1212)
        at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:3
99)
        at
org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.jav
a:216)
        at
org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:1
82)
        at
org.mortbay.jetty.handler.ContextHandler.__handle(ContextHandler.java
:766)
        at
org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java)
        at
org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:450)

        at
org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHand
lerCollection.java:230)
        at
org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.
java:114)
        at
org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:1
52)
        at org.mortbay.jetty.Server.handle(Server.java:326)
        at
org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:54
2)
        at
org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnectio
n.java:945)
        at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756)
        at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218)
        at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
        at
org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.ja
va:410)
        at
org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.j
ava:582)
Caused by: java.sql.SQLException: Field 'periodid' doesn't have a default
value
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2825)
        at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:2156)
        at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:2459)
        at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:2376)
        at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:2360)
        at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewP
roxyPreparedStatement.java:105)
        at
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(
ResultSetReturnImpl.java:133)
        ... 152 more
* INFO  2014-09-07 23:15:05,238 'admin' create org.hisp.dhis.period.Period,
name
: 20141216, uid: 20141216 (AuditLogUtil.java [2062952956@qtp-224922962-27])
* WARN  2014-09-07 23:15:05,243 SQL Error: 1364, SQLState: HY000
(SqlExceptionHe
lper.java [2062952956@qtp-224922962-27])
* ERROR 2014-09-07 23:15:05,244 Field 'periodid' doesn't have a default
value (S
qlExceptionHelper.java [2062952956@qtp-224922962-27])
2014-09-07 23:15:05.245:WARN::/api/dataValues
org.hibernate.exception.GenericJDBCException: could not execute statement
        at
org.hibernate.exception.internal.StandardSQLExceptionConverter.conver
t(StandardSQLExceptionConverter.java:54)
        at
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlException
Helper.java:125)
        at
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlException
Helper.java:110)
        at
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(
ResultSetReturnImpl.java:136)
        at
org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAn
dExtract(IdentityGenerator.java:96)
        at
org.hibernate.id.insert.AbstractReturningDelegate.performInsert(Abstr
actReturningDelegate.java:58)
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(Abstrac
tEntityPersister.java:2966)
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(Abstrac
tEntityPersister.java:3477)
        at
org.hibernate.action.internal.EntityIdentityInsertAction.execute(Enti
tyIdentityInsertAction.java:81)
        at
org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:362)
        at
org.hibernate.engine.spi.ActionQueue.addResolvedEntityInsertAction(Ac
tionQueue.java:203)
        at
org.hibernate.engine.spi.ActionQueue.addInsertAction(ActionQueue.java
:183)
        at
org.hibernate.engine.spi.ActionQueue.addAction(ActionQueue.java:167)
        at
org.hibernate.event.internal.AbstractSaveEventListener.addInsertActio
n(AbstractSaveEventListener.java:321)
        at
org.hibernate.event.internal.AbstractSaveEventListener.performSaveOrR
eplicate(AbstractSaveEventListener.java:286)
        at
org.hibernate.event.internal.AbstractSaveEventListener.performSave(Ab
stractSaveEventListener.java:192)
        at
org.hibernate.event.internal.AbstractSaveEventListener.saveWithGenera
tedId(AbstractSaveEventListener.java:125)
        at
org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.saveWit
hGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:204)
        at
org.hibernate.event.internal.DefaultSaveEventListener.saveWithGenerat
edOrRequestedId(DefaultSaveEventListener.java:55)
        at
org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.entityI
sTransient(DefaultSaveOrUpdateEventListener.java:189)
        at
org.hibernate.event.internal.DefaultSaveEventListener.performSaveOrUp
date(DefaultSaveEventListener.java:49)
        at
org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.onSaveO
rUpdate(DefaultSaveOrUpdateEventListener.java:90)
        at org.hibernate.internal.SessionImpl.fireSave(SessionImpl.java:763)
        at org.hibernate.internal.SessionImpl.save(SessionImpl.java:755)
        at org.hibernate.internal.SessionImpl.save(SessionImpl.java:751)
        at
org.hisp.dhis.hibernate.HibernateGenericStore.save(HibernateGenericSt
ore.java:272)
        at
org.hisp.dhis.common.hibernate.HibernateIdentifiableObjectStore.save(
HibernateIdentifiableObjectStore.java:83)
        at
org.hisp.dhis.period.hibernate.HibernatePeriodStore.addPeriod(Hiberna
tePeriodStore.java:61)
        at
org.hisp.dhis.period.hibernate.HibernatePeriodStore.reloadForceAddPer
iod(HibernatePeriodStore.java:164)
        at
org.hisp.dhis.datavalue.hibernate.HibernateDataValueStore.addDataValu
e(HibernateDataValueStore.java:110)
        at
org.hisp.dhis.datavalue.DefaultDataValueService.addDataValue(DefaultD
ataValueService.java:145)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:57)
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:601)
        at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
on(AopUtils.java:317)
        at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
inpoint(ReflectiveMethodInvocation.java:183)
        at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:150)
        at
org.springframework.transaction.interceptor.TransactionInterceptor$1.
proceedWithInvocation(TransactionInterceptor.java:96)
        at
org.springframework.transaction.interceptor.TransactionAspectSupport.
invokeWithinTransaction(TransactionAspectSupport.java:260)
        at
org.springframework.transaction.interceptor.TransactionInterceptor.in
voke(TransactionInterceptor.java:94)
        at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:172)
        at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java:204)
        at $Proxy61.addDataValue(Unknown Source)
        at
org.hisp.dhis.webapi.controller.DataValueController.saveDataValue(Dat
aValueController.java:204)
        at
org.hisp.dhis.webapi.controller.DataValueController$$FastClassBySprin
gCGLIB$$a4155e9f.invoke(<generated>)
        at
org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:2
04)
        at
org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation
.invokeJoinpoint(CglibAopProxy.java:700)
        at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:150)
        at
org.springframework.security.access.intercept.aopalliance.MethodSecur
ityInterceptor.invoke(MethodSecurityInterceptor.java:64)
        at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:172)
        at
org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterce
ptor.intercept(CglibAopProxy.java:633)
        at
org.hisp.dhis.webapi.controller.DataValueController$$EnhancerBySpring
CGLIB$$ae2be952.saveDataValue(<generated>)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:57)
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:601)
        at
org.springframework.web.method.support.InvocableHandlerMethod.invoke(
InvocableHandlerMethod.java:215)
        at
org.springframework.web.method.support.InvocableHandlerMethod.invokeF
orRequest(InvocableHandlerMethod.java:132)
        at
org.springframework.web.servlet.mvc.method.annotation.ServletInvocabl
eHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
        at
org.springframework.web.servlet.mvc.method.annotation.RequestMappingH
andlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:745)
        at
org.springframework.web.servlet.mvc.method.annotation.RequestMappingH
andlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:685)
        at
org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapt
er.handle(AbstractHandlerMethodAdapter.java:80)
        at
org.springframework.web.servlet.DispatcherServlet.doDispatch(Dispatch
erServlet.java:919)
        at
org.springframework.web.servlet.DispatcherServlet.doService(Dispatche
rServlet.java:851)
        at
org.springframework.web.servlet.FrameworkServlet.processRequest(Frame
workServlet.java:953)
        at
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServ
let.java:855)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
        at
org.springframework.web.servlet.FrameworkServlet.service(FrameworkSer
vlet.java:829)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
        at
org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511
)
        at
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(Servlet
Handler.java:1221)
        at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java:330)
        at
org.springframework.security.web.access.intercept.FilterSecurityInter
ceptor.invoke(FilterSecurityInterceptor.java:118)
        at
org.springframework.security.web.access.intercept.FilterSecurityInter
ceptor.doFilter(FilterSecurityInterceptor.java:84)
        at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java:342)
        at
org.springframework.security.web.access.ExceptionTranslationFilter.do
Filter(ExceptionTranslationFilter.java:113)
        at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java:342)
        at
org.springframework.security.web.session.SessionManagementFilter.doFi
lter(SessionManagementFilter.java:103)
        at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java:342)
        at
org.springframework.security.web.authentication.AnonymousAuthenticati
onFilter.doFilter(AnonymousAuthenticationFilter.java:113)
        at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java:342)
        at
org.springframework.security.web.servletapi.SecurityContextHolderAwar
eRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:154)
        at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java:342)
        at
org.springframework.security.web.savedrequest.RequestCacheAwareFilter
.doFilter(RequestCacheAwareFilter.java:45)
        at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java:342)
        at
org.springframework.security.web.authentication.www.BasicAuthenticati
onFilter.doFilter(BasicAuthenticationFilter.java:150)
        at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java:342)
        at
org.springframework.security.web.authentication.AbstractAuthenticatio
nProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:199)
        at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java:342)
        at
org.springframework.security.web.authentication.AbstractAuthenticatio
nProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:199)
        at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java:342)
        at
org.hisp.dhis.security.filter.CustomAuthenticationFilter.doFilter(Cus
tomAuthenticationFilter.java:64)
        at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java:342)
        at
org.springframework.security.web.authentication.logout.LogoutFilter.d
oFilter(LogoutFilter.java:110)
        at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java:342)
        at
org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(Automati
cAccessFilter.java:113)
        at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java:342)
        at
org.springframework.security.web.context.SecurityContextPersistenceFi
lter.doFilter(SecurityContextPersistenceFilter.java:87)
        at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java:342)
        at
org.springframework.security.web.FilterChainProxy.doFilterInternal(Fi
lterChainProxy.java:192)
        at
org.springframework.security.web.FilterChainProxy.doFilter(FilterChai
nProxy.java:160)
        at
org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(D
elegatingFilterProxy.java:343)
        at
org.springframework.web.filter.DelegatingFilterProxy.doFilter(Delegat
ingFilterProxy.java:260)
        at
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(Servlet
Handler.java:1212)
        at
org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.do
FilterInternal(OpenSessionInViewFilter.java:151)
        at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerR
equestFilter.java:106)
        at
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(Servlet
Handler.java:1212)
        at
org.springframework.web.filter.CharacterEncodingFilter.doFilterIntern
al(CharacterEncodingFilter.java:88)
        at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerR
equestFilter.java:106)
        at
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(Servlet
Handler.java:1212)
        at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:3
99)
        at
org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.jav
a:216)
        at
org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:1
82)
        at
org.mortbay.jetty.handler.ContextHandler.__handle(ContextHandler.java
:766)
        at
org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java)
        at
org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:450)

        at
org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHand
lerCollection.java:230)
        at
org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.
java:114)
        at
org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:1
52)
        at org.mortbay.jetty.Server.handle(Server.java:326)
        at
org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:54
2)
        at
org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnectio
n.java:945)
        at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756)
        at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218)
        at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
        at
org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.ja
va:410)
        at
org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.j
ava:582)