dhis2-devs team mailing list archive

[Bharath <chbharathk@xxxxxxxxx>]

I think this seems space issue, because yesterday we freed some memory in
hard disk and tried, it worked. Thanks.


On Thu, Dec 5, 2013 at 12:26 AM, Lars Helge Øverland <larshelge@xxxxxxxxx>wrote:

> Hm this one I am not sure about. It says:
>
> Column 'userid' cannot be null
>
> But which table in this statement has a "userid" column? Not sure about
> that, can you investigate?
>
> Lars
>
>
>
>
>
>
>
>
>
> On Wed, Dec 4, 2013 at 7:56 PM, Lars Helge Øverland <larshelge@xxxxxxxxx>wrote:
>
>>
>>
>>
>>
>> On Tue, Nov 26, 2013 at 5:06 PM, Bharath <chbharathk@xxxxxxxxx> wrote:
>>
>>> Hi, when we are running getting the below exception, can you plz help
>>>
>>> DataBase: MYSQL
>>>
>>> DHIS version: 2.13
>>>
>>> insert into analytics_temp_2013 (RRzlD3voz84,NpequZ9BYNW,
>>> PbWDjOt5Zav,YbQ9R6qGpFM,HBR9gw7Q6MX,o9rIsKtcvPT,f1Qyuns5mjJ,OqP9wmDkyxK,
>>> uidlevel1,uidlevel2,uidlevel3,uidlevel4,uidlevel5,daily,
>>> weekly,forteen,monthly,bimonthly,quarterly,sixmonthly,yearly,
>>> financialapril,financialjuly,financialoct,de,co,level,daysxvalue,
>>> daysno, value) select degs.RRzlD3voz84,ougs.
>>> NpequZ9BYNW,ougs.PbWDjOt5Zav,ougs.YbQ9R6qGpFM,ougs.
>>> HBR9gw7Q6MX,ougs.o9rIsKtcvPT,ougs.f1Qyuns5mjJ,ougs.
>>> OqP9wmDkyxK,ous.uidlevel1,ous.uidlevel2,ous.uidlevel3,ous.
>>> uidlevel4,ous.uidlevel5,ps.daily,ps.weekly,ps.forteen,ps.
>>> monthly,ps.bimonthly,ps.quarterly,ps.sixmonthly,ps.
>>> yearly,ps.financialapril,ps.financialjuly,ps.financialoct,
>>> de.uid,co.uid,ous.level,cast(dv.value as decimal(26,1)) * ps.daysno as
>>> daysxvalue, ps.daysno as daysno, cast(dv.value as decimal(26,1)) as value
>>> from datavalue dv left join _dataelementgroupsetstructure degs on
>>> dv.dataelementid=degs.dataelementid left join _
>>> organisationunitgroupsetstructure ougs on dv.sourceid=ougs.organisationunitid
>>> left join _categorystructure cs on dv.categoryoptioncomboid=cs.categoryoptioncomboid
>>> left join _orgunitstructure ous on dv.sourceid=ous.organisationunitid
>>> left join _periodstructure ps on dv.periodid=ps.periodid left join
>>> dataelement de on dv.dataelementid=de.dataelementid left join
>>> categoryoptioncombo co on dv.categoryoptioncomboid=co.categoryoptioncomboid
>>> left join period pe on dv.periodid=pe.periodid where de.valuetype = 'int'
>>> and de.domaintype = 'aggregate' and pe.startdate >= '2013-01-01' and
>>> pe.startdate <= '2013-12-31' and dv.value is not null and dv.value
>>> regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$' and ( dv.value != '0' or
>>> de.aggregationtype = 'average' or de.zeroissignificant = true )
>>> (JdbcAnalyticsTableManager.java [SimpleAsyncTaskExecutor-1])
>>> * INFO  2013-11-26 06:11:35,501 [Level: ERROR, category: DATAMART, time:
>>> Tue Nov 26 06:11:35 GMT-05:00 2013, message: Process failed: Exception
>>> during execution] (InMemoryNotifier.java [taskScheduler-1])
>>> * WARN  2013-11-26 06:11:35,517 SQL Error: 1048, SQLState: 23000
>>> (SqlExceptionHelper.java [taskScheduler-1])
>>> * ERROR 2013-11-26 06:11:35,519 Column 'userid' cannot be null
>>> (SqlExceptionHelper.java [taskScheduler-1])
>>> * ERROR 2013-11-26 06:11:35,521 Unexpected error occurred in scheduled
>>> task. (TaskUtils.java [taskScheduler-1])
>>> org.hibernate.exception.ConstraintViolationException: could not execute
>>> statement
>>>         at org.hibernate.exception.internal.SQLExceptionTypeDelegate.
>>> convert(SQLExceptionTypeDelegate.java:74)
>>>         at org.hibernate.exception.internal.
>>> StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.
>>> java:49)
>>>         at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(
>>> SqlExceptionHelper.java:125)
>>>         at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(
>>> SqlExceptionHelper.java:110)
>>>         at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.
>>> executeUpdate(ResultSetReturnImpl.java:136)
>>>         at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.
>>> executeAndExtract(IdentityGenerator.java:96)
>>>         at org.hibernate.id.insert.AbstractReturningDelegate.
>>> performInsert(AbstractReturningDelegate.java:58)
>>>         at org.hibernate.persister.entity.AbstractEntityPersister.
>>> insert(AbstractEntityPersister.java:2966)
>>>         at org.hibernate.persister.entity.AbstractEntityPersister.
>>> insert(AbstractEntityPersister.java:3477)
>>>         at org.hibernate.action.internal.EntityIdentityInsertAction.
>>> execute(EntityIdentityInsertAction.java:81)
>>>         at org.hibernate.engine.spi.ActionQueue.execute(
>>> ActionQueue.java:362)
>>>         at org.hibernate.engine.spi.ActionQueue.
>>> addResolvedEntityInsertAction(ActionQueue.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.
>>> addInsertAction(AbstractSaveEventListener.java:321)
>>>         at org.hibernate.event.internal.AbstractSaveEventListener.
>>> performSaveOrReplicate(AbstractSaveEventListener.java:286)
>>>         at org.hibernate.event.internal.AbstractSaveEventListener.
>>> performSave(AbstractSaveEventListener.java:192)
>>>         at org.hibernate.event.internal.AbstractSaveEventListener.
>>> saveWithGeneratedId(AbstractSaveEventListener.java:125)
>>>         at org.hibernate.event.internal.DefaultSaveOrUpdateEventListen
>>> er.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListen
>>> er.java:204)
>>>         at org.hibernate.event.internal.DefaultSaveOrUpdateEventListen
>>> er.entityIsTransient(DefaultSaveOrUpdateEventListener.java:189)
>>>         at org.hibernate.event.internal.DefaultSaveOrUpdateEventListen
>>> er.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:114)
>>>         at org.hibernate.event.internal.DefaultSaveOrUpdateEventListen
>>> er.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:90)
>>>         at org.hibernate.internal.SessionImpl.fireSaveOrUpdate(
>>> SessionImpl.java:734)
>>>         at org.hibernate.internal.SessionImpl.saveOrUpdate(
>>> SessionImpl.java:726)
>>>         at org.hibernate.engine.spi.CascadingAction$5.cascade(
>>> CascadingAction.java:258)
>>>         at org.hibernate.engine.internal.Cascade.cascadeToOne(Cascade.
>>> java:387)
>>>         at org.hibernate.engine.internal.Cascade.cascadeAssociation(
>>> Cascade.java:330)
>>>         at org.hibernate.engine.internal.Cascade.cascadeProperty(
>>> Cascade.java:208)
>>>         at org.hibernate.engine.internal.Cascade.
>>> cascadeCollectionElements(Cascade.java:416)
>>>         at org.hibernate.engine.internal.Cascade.cascadeCollection(
>>> Cascade.java:357)
>>>         at org.hibernate.engine.internal.Cascade.cascadeAssociation(
>>> Cascade.java:333)
>>>         at org.hibernate.engine.internal.Cascade.cascadeProperty(
>>> Cascade.java:208)
>>>         at org.hibernate.engine.internal.Cascade.cascade(Cascade.java:
>>> 165)
>>>         at org.hibernate.event.internal.AbstractSaveEventListener.
>>> cascadeAfterSave(AbstractSaveEventListener.java:449)
>>>         at org.hibernate.event.internal.AbstractSaveEventListener.
>>> performSaveOrReplicate(AbstractSaveEventListener.java:292)
>>>         at org.hibernate.event.internal.AbstractSaveEventListener.
>>> performSave(AbstractSaveEventListener.java:192)
>>>         at org.hibernate.event.internal.AbstractSaveEventListener.
>>> saveWithGeneratedId(AbstractSaveEventListener.java:125)
>>>         at org.hibernate.event.internal.DefaultSaveOrUpdateEventListen
>>> er.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListen
>>> er.java:204)
>>>         at org.hibernate.event.internal.DefaultSaveEventListener.
>>> saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:55)
>>>         at org.hibernate.event.internal.DefaultSaveOrUpdateEventListen
>>> er.entityIsTransient(DefaultSaveOrUpdateEventListener.java:189)
>>>         at org.hibernate.event.internal.DefaultSaveEventListener.
>>> performSaveOrUpdate(DefaultSaveEventListener.java:49)
>>>         at org.hibernate.event.internal.DefaultSaveOrUpdateEventListen
>>> er.onSaveOrUpdate(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(
>>> HibernateGenericStore.java:269)
>>>         at org.hisp.dhis.common.hibernate.HibernateIdentifiableObjectSto
>>> re.save(HibernateIdentifiableObjectStore.java:60)
>>>         at org.hisp.dhis.common.hibernate.HibernateIdentifiableObjectSto
>>> re.save(HibernateIdentifiableObjectStore.java:51)
>>>         at org.hisp.dhis.message.DefaultMessageService.
>>> saveMessageConversation(DefaultMessageService.java:234)
>>>         at org.hisp.dhis.message.DefaultMessageService.sendMessage(
>>> DefaultMessageService.java:152)
>>>         at org.hisp.dhis.message.DefaultMessageService.sendFeedback(
>>> DefaultMessageService.java:163)
>>>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>>         at sun.reflect.NativeMethodAccessorImpl.invoke(
>>> NativeMethodAccessorImpl.java:57)
>>>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(
>>> DelegatingMethodAccessorImpl.java:43)
>>>         at java.lang.reflect.Method.invoke(Method.java:606)
>>>         at org.springframework.aop.support.AopUtils.
>>> invokeJoinpointUsingReflection(AopUtils.java:317)
>>>         at org.springframework.aop.framework.ReflectiveMethodInvocation.
>>> invokeJoinpoint(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.invoke(TransactionInterceptor.java:94)
>>>         at org.springframework.aop.framework.ReflectiveMethodInvocation.
>>> proceed(ReflectiveMethodInvocation.java:172)
>>>         at org.springframework.aop.framework.JdkDynamicAopProxy.
>>> invoke(JdkDynamicAopProxy.java:204)
>>>         at com.sun.proxy.$Proxy66.sendFeedback(Unknown Source)
>>>         at org.hisp.dhis.analytics.scheduling.AnalyticsTableTask.
>>> run(AnalyticsTableTask.java:115)
>>>         at org.hisp.dhis.scheduling.ScheduledTasks.run(
>>> ScheduledTasks.java:60)
>>>         at org.springframework.scheduling.support.
>>> DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnabl
>>> e.java:53)
>>>         at java.util.concurrent.Executors$RunnableAdapter.
>>> call(Executors.java:471)
>>>         at java.util.concurrent.FutureTask$Sync.innerRun(
>>> FutureTask.java:334)
>>>         at java.util.concurrent.FutureTask.run(FutureTask.java:166)
>>>         at java.util.concurrent.ScheduledThreadPoolExecutor$
>>> ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178)
>>>         at java.util.concurrent.ScheduledThreadPoolExecutor$
>>> ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292)
>>>         at java.util.concurrent.ThreadPoolExecutor.runWorker(
>>> ThreadPoolExecutor.java:1145)
>>>         at java.util.concurrent.ThreadPoolExecutor$Worker.run(
>>> ThreadPoolExecutor.java:615)
>>>         at java.lang.Thread.run(Thread.java:724)
>>> Caused by: com.mysql.jdbc.exceptions.jdbc4.
>>> MySQLIntegrityConstraintViolationException: Column 'userid' cannot be
>>> null
>>>         at sun.reflect.GeneratedConstructorAccessor262.newInstance(Unknown
>>> Source)
>>>         at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(
>>> DelegatingConstructorAccessorImpl.java:45)
>>>         at java.lang.reflect.Constructor.newInstance(Constructor.java:
>>> 526)
>>>         at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
>>>         at com.mysql.jdbc.Util.getInstance(Util.java:386)
>>>         at com.mysql.jdbc.SQLError.createSQLException(SQLError.
>>> java:1039)
>>>         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4096)
>>>         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4028)
>>>         at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2490)
>>>         at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651)
>>>         at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:
>>> 2683)
>>>         at com.mysql.jdbc.PreparedStatement.executeInternal(
>>> PreparedStatement.java:2144)
>>>         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(NewProxyPreparedStatement.java:105)
>>>         at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.
>>> executeUpdate(ResultSetReturnImpl.java:133)
>>>         ... 70 more
>>>
>>>
>>>
>>> --
>>>
>>> Regards,
>>> Bharath Kumar. Ch
>>>
>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~dhis2-devs
>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>


-- 

Regards,
Bharath Kumar. Ch