dhis2-devs team mailing list archive

["Dapo Adejumo" <dapo_adejumo@xxxxxxxxx>]

Hi Devs,

I am not sure if this is a bug - but analytics are failing using 2.17
(17612) . Logs are attached, any idea why this may be happening?

Thanks

 

...............

Regards,

Dapo Adejumo

+2348033683677

Skype : dapojorge

 

Analytics table process failed, please check the logs. Message: Exception during execution Cause: java.util.concurrent.ExecutionException: org.springframework.dao.DataIntegrityViolationException: StatementCallback; SQL [insert into analytics_temp_2011 ("WvnXLJQg6vR","Xb8MVrtez6o","UnOmEE9l51L","RR8jNDrhGKL","bVXoPNpgXAi","dAOtelbj68d","KAnPRETzLNh","GvScnquL6Se","PUrZmTIlCyV","zKUIte9NQVI","WLQLDowcGDZ","zhOEXizCfpv","FNy77BoJMs9","gvouMf8sojT","Ryd8YxcKWcz","uidlevel1","uidlevel2","uidlevel3","uidlevel4","uidlevel5","daily","weekly","monthly","bimonthly","quarterly","sixmonthly","sixmonthlyapril","yearly","financialapril","financialjuly","financialoct","de","co","ou","level",daysxvalue, daysno, value, textvalue) select degs."WvnXLJQg6vR",degs."Xb8MVrtez6o",degs."UnOmEE9l51L",ougs."RR8jNDrhGKL",ougs."bVXoPNpgXAi",ougs."dAOtelbj68d",ougs."KAnPRETzLNh",ougs."GvScnquL6Se",ougs."PUrZmTIlCyV",ougs."zKUIte9NQVI",ougs."WLQLDowcGDZ",ougs."zhOEXizCfpv",ougs."FNy77BoJMs9",dcs."gvouMf8sojT",acs."Ryd8YxcKWcz",ous."uidlevel1",ous."uidlevel2",ous."uidlevel3",ous."uidlevel4",ous."uidlevel5",ps."daily",ps."weekly",ps."monthly",ps."bimonthly",ps."quarterly",ps."sixmonthly",ps."sixmonthlyapril",ps."yearly",ps."financialapril",ps."financialjuly",ps."financialoct",de.uid,co.uid,ous.organisationunituid,ous.level,cast(dv.value as double precision) * ps.daysno as daysxvalue, ps.daysno as daysno, cast(dv.value as double precision) as value, null as textvalue from datavalue dv left join _dataelementgroupsetstructure degs on dv.dataelementid=degs.dataelementid left join _organisationunitgroupsetstructure ougs on dv.sourceid=ougs.organisationunitid left join _categoryoptiongroupsetstructure cogs on dv.attributeoptioncomboid=cogs.categoryoptioncomboid left join _categorystructure dcs on dv.categoryoptioncomboid=dcs.categoryoptioncomboid left join _categorystructure acs on dv.attributeoptioncomboid=acs.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 _dataelementstructure des on de.dataelementid = des.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 >= '2011-01-01' and pe.startdate <= '2011-12-31' and dv.value is not null and dv.value ~* '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$' and ( dv.value != '0' or de.aggregationtype = 'average' or de.zeroissignificant = true ) ]; ERROR: null value in column "ou" violates not-null constraint
Detail: Failing row contains (d46FIWZqIhI, null, null, null, null, null, null, rtZY2mEY1Sp, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 201103, 201102B, 2011Q1, 2011S1, 2011AprilS2, 2011, 2010April, 2010July, 2010Oct, o4NSxSAlNu1, Y2SrnZVI87k, null, null, 62, 31, 2, null).; nested exception is org.postgresql.util.PSQLException: ERROR: null value in column "ou" violates not-null constraint
Detail: Failing row contains (d46FIWZqIhI, null, null, null, null, null, null, rtZY2mEY1Sp, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 201103, 201102B, 2011Q1, 2011S1, 2011AprilS2, 2011, 2010April, 2010July, 2010Oct, o4NSxSAlNu1, Y2SrnZVI87k, null, null, 62, 31, 2, null).
at java.util.concurrent.FutureTask.report(FutureTask.java:122)
at java.util.concurrent.FutureTask.get(FutureTask.java:188)
at org.hisp.dhis.system.util.ConcurrentUtils.waitForCompletion(ConcurrentUtils.java:51)
at org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.populateTables(DefaultAnalyticsTableService.java:216)
at org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.update(DefaultAnalyticsTableService.java:123)
at org.hisp.dhis.analytics.scheduling.AnalyticsTableTask.run(AnalyticsTableTask.java:136)
at org.hisp.dhis.scheduling.ScheduledTasks.run(ScheduledTasks.java:60)
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
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:745)
Caused by: org.springframework.dao.DataIntegrityViolationException: StatementCallback; SQL [insert into analytics_temp_2011 ("WvnXLJQg6vR","Xb8MVrtez6o","UnOmEE9l51L","RR8jNDrhGKL","bVXoPNpgXAi","dAOtelbj68d","KAnPRETzLNh","GvScnquL6Se","PUrZmTIlCyV","zKUIte9NQVI","WLQLDowcGDZ","zhOEXizCfpv","FNy77BoJMs9","gvouMf8sojT","Ryd8YxcKWcz","uidlevel1","uidlevel2","uidlevel3","uidlevel4","uidlevel5","daily","weekly","monthly","bimonthly","quarterly","sixmonthly","sixmonthlyapril","yearly","financialapril","financialjuly","financialoct","de","co","ou","level",daysxvalue, daysno, value, textvalue) select degs."WvnXLJQg6vR",degs."Xb8MVrtez6o",degs."UnOmEE9l51L",ougs."RR8jNDrhGKL",ougs."bVXoPNpgXAi",ougs."dAOtelbj68d",ougs."KAnPRETzLNh",ougs."GvScnquL6Se",ougs."PUrZmTIlCyV",ougs."zKUIte9NQVI",ougs."WLQLDowcGDZ",ougs."zhOEXizCfpv",ougs."FNy77BoJMs9",dcs."gvouMf8sojT",acs."Ryd8YxcKWcz",ous."uidlevel1",ous."uidlevel2",ous."uidlevel3",ous."uidlevel4",ous."uidlevel5",ps."daily",ps."weekly",ps."monthly",ps."bimonthly",ps."quarterly",ps."sixmonthly",ps."sixmonthlyapril",ps."yearly",ps."financialapril",ps."financialjuly",ps."financialoct",de.uid,co.uid,ous.organisationunituid,ous.level,cast(dv.value as double precision) * ps.daysno as daysxvalue, ps.daysno as daysno, cast(dv.value as double precision) as value, null as textvalue from datavalue dv left join _dataelementgroupsetstructure degs on dv.dataelementid=degs.dataelementid left join _organisationunitgroupsetstructure ougs on dv.sourceid=ougs.organisationunitid left join _categoryoptiongroupsetstructure cogs on dv.attributeoptioncomboid=cogs.categoryoptioncomboid left join _categorystructure dcs on dv.categoryoptioncomboid=dcs.categoryoptioncomboid left join _categorystructure acs on dv.attributeoptioncomboid=acs.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 _dataelementstructure des on de.dataelementid = des.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 >= '2011-01-01' and pe.startdate <= '2011-12-31' and dv.value is not null and dv.value ~* '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$' and ( dv.value != '0' or de.aggregationtype = 'average' or de.zeroissignificant = true ) ]; ERROR: null value in column "ou" violates not-null constraint
Detail: Failing row contains (d46FIWZqIhI, null, null, null, null, null, null, rtZY2mEY1Sp, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 201103, 201102B, 2011Q1, 2011S1, 2011AprilS2, 2011, 2010April, 2010July, 2010Oct, o4NSxSAlNu1, Y2SrnZVI87k, null, null, 62, 31, 2, null).; nested exception is org.postgresql.util.PSQLException: ERROR: null value in column "ou" violates not-null constraint
Detail: Failing row contains (d46FIWZqIhI, null, null, null, null, null, null, rtZY2mEY1Sp, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 201103, 201102B, 2011Q1, 2011S1, 2011AprilS2, 2011, 2010April, 2010July, 2010Oct, o4NSxSAlNu1, Y2SrnZVI87k, null, null, 62, 31, 2, null).
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:243)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:413)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:437)
at org.hisp.dhis.analytics.table.AbstractJdbcTableManager.populateAndLog(AbstractJdbcTableManager.java:352)
at org.hisp.dhis.analytics.table.JdbcAnalyticsTableManager.populateTable(JdbcAnalyticsTableManager.java:233)
at org.hisp.dhis.analytics.table.JdbcAnalyticsTableManager.populateTableAsync(JdbcAnalyticsTableManager.java:160)
at sun.reflect.GeneratedMethodAccessor1066.invoke(Unknown Source)
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:190)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:97)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
... 1 more
Caused by: org.postgresql.util.PSQLException: ERROR: null value in column "ou" violates not-null constraint
Detail: Failing row contains (d46FIWZqIhI, null, null, null, null, null, null, rtZY2mEY1Sp, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 201103, 201102B, 2011Q1, 2011S1, 2011AprilS2, 2011, 2010April, 2010July, 2010Oct, o4NSxSAlNu1, Y2SrnZVI87k, null, null, 62, 31, 2, null).
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:405)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:397)
at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:1006)
at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:429)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:402)
... 13 more