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

Ngoc_Thanh_Nguyen · 7 September 2014 16:20

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

at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.jav

···

a:216)

at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:1

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

at org.mortbay.jetty.Server.handle(Server.java:326)

at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:54

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()

at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:2

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()

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)