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_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to : [email protected]
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
