dhis2-devs team mailing list archive

Thread
Date
Re: Analytics error

To: bharath kumar <chbharathk@xxxxxxxxx>
From: Lars Helge Øverland <larshelge@xxxxxxxxx>
Date: Thu, 5 Dec 2013 08:18:41 +0100
Cc: DHIS 2 Developers list <dhis2-devs@xxxxxxxxxxxxxxxxxxx>
In-reply-to: <CAF6QxwZ1+voeagxnk2RY+Fuk=+WLwoJOMHr2bQAQQ2_GKJ+MNQ@mail.gmail.com>
Great.
On Dec 5, 2013 5:35 AM, "Bharath" <chbharathk@xxxxxxxxx> wrote:

> 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.
>>>> HibernateIdentifiableObjectStore.save(HibernateIdentifiableObjectSto
>>>> re.java:60)
>>>>         at org.hisp.dhis.common.hibernate.
>>>> HibernateIdentifiableObjectStore.save(HibernateIdentifiableObjectSto
>>>> re.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
>
References

Analytics error
From: Bharath, 2013-11-26
Re: Analytics error
From: Lars Helge Øverland, 2013-12-04
Re: Analytics error
From: Lars Helge Øverland, 2013-12-04
Re: Analytics error
From: Bharath, 2013-12-05