Tabular Report doesent display value

Dear all,

I 'm trying to retreive data in Tabular Report (Tracker)but i’m not seeing any value and i’m sure the data’s are there.In dhis 2.12 version,Tabular Report was working and of cause the data displayed well,the problem came in version 2.13.

Any Help?

Thanks

Venuste

Hi,

Remember that the tabular report also depends on the analytics table.

Once you run the analytics table, you should see you data.

Let’s know if this works.

Cheers

Busoye

···

On 14 Jan 2014, at 08:12, nsanzumuhire venuste vensanze@yahoo.fr wrote:

Dear all,

I 'm trying to retreive data in Tabular Report (Tracker)but i’m not seeing any value and i’m sure the data’s are there.In dhis 2.12 version,Tabular Report was working and of cause the data displayed well,the problem came in version 2.13.

Any Help?

Thanks

Venuste


Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp

I have tried to run Analytics table before,but see below the message.

2014-01-14 05:50:38
Process failed: Exception during execution
2014-01-14 05:50:34
Populating analytics tables
2014-01-14 05:49:58
Creating analytics tables
2014-01-14 05:49:57
Updating event analytics tables
2014-01-14 05:49:57
Table update done
2014-01-14 05:49:57
Swapping analytics tables
2014-01-14 05:49:57
Vacuuming tables
2014-01-14 05:49:57
Creating indexes
2014-01-14 05:49:57
Applying aggregation levels
2014-01-14 05:49:57
Pruned analytics tables
2014-01-14 05:49:57
Populating analytics tables
2014-01-14 05:49:57
Creating analytics tables
2014-01-14 05:49:57
Updating compeleteness target table
2014-01-14 05:49:57
Table update done
2014-01-14 05:49:57
Swapping analytics tables
2014-01-14 05:49:57
Vacuuming tables
2014-01-14 05:49:57
Creating indexes
2014-01-14 05:49:57
Applying aggregation levels
2014-01-14 05:49:57
Pruned analytics tables
2014-01-14 05:49:57
Populating analytics tables
2014-01-14 05:49:57
Creating analytics tables
2014-01-14 05:49:57
Updating completeness tables
2014-01-14 05:49:57
Table update done
2014-01-14 05:49:57
Swapping analytics tables
2014-01-14 05:49:57
Vacuuming tables
2014-01-14 05:49:57
Creating indexes
2014-01-14 05:49:57
Applying aggregation levels
2014-01-14 05:49:57
Pruned analytics tables
2014-01-14 05:49:56
Populating analytics tables
2014-01-14 05:49:56
Creating analytics tables
2014-01-14 05:49:56
Updating analytics tables
2014-01-14 05:49:48
Updating resource tables

Hi,

Remember that the tabular report also depends on the analytics table.

Once you run the analytics table, you should see you data.

Let’s know if this works.

Cheers

Busoye

···

Le Mardi 14 janvier 2014 2h09, Adebusoye Anifalaje busoye@hisp.org a écrit :

On 14 Jan 2014, at 08:12, nsanzumuhire venuste vensanze@yahoo.fr wrote:

Dear all,

I 'm trying to retreive data in Tabular Report (Tracker)but i’m not seeing any value and i’m sure the data’s are there.In dhis 2.12 version,Tabular Report was working and of cause the data displayed well,the problem came in version 2.13.

Any Help?

Thanks

Venuste


Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp

Can you send the relevant section of the log file so we know what is causing the exception?

···

On 14 Jan 2014, at 09:24, nsanzumuhire venuste vensanze@yahoo.fr wrote:

I have tried to run Analytics table before,but see below the message.

2014-01-14 05:50:38
Process failed: Exception during execution
2014-01-14 05:50:34
Populating analytics tables
2014-01-14 05:49:58
Creating analytics tables
2014-01-14 05:49:57
Updating event analytics tables
2014-01-14 05:49:57
Table update done
2014-01-14 05:49:57
Swapping analytics tables
2014-01-14 05:49:57
Vacuuming tables
2014-01-14 05:49:57
Creating indexes
2014-01-14 05:49:57
Applying aggregation levels
2014-01-14 05:49:57
Pruned analytics tables
2014-01-14 05:49:57
Populating analytics tables
2014-01-14 05:49:57
Creating analytics tables
2014-01-14 05:49:57
Updating compeleteness target table
2014-01-14 05:49:57
Table update done
2014-01-14 05:49:57
Swapping analytics tables
2014-01-14 05:49:57
Vacuuming tables
2014-01-14 05:49:57
Creating indexes
2014-01-14 05:49:57
Applying aggregation levels
2014-01-14 05:49:57
Pruned analytics tables
2014-01-14 05:49:57
Populating analytics tables
2014-01-14 05:49:57
Creating analytics tables
2014-01-14 05:49:57
Updating completeness tables
2014-01-14 05:49:57
Table update done
2014-01-14 05:49:57
Swapping analytics tables
2014-01-14 05:49:57
Vacuuming tables
2014-01-14 05:49:57
Creating indexes
2014-01-14 05:49:57
Applying aggregation levels
2014-01-14 05:49:57
Pruned analytics tables
2014-01-14 05:49:56
Populating analytics tables
2014-01-14 05:49:56
Creating analytics tables
2014-01-14 05:49:56
Updating analytics tables
2014-01-14 05:49:48
Updating resource tables

Le Mardi 14 janvier 2014 2h09, Adebusoye Anifalaje busoye@hisp.org a écrit :

Hi,

Remember that the tabular report also depends on the analytics table.

Once you run the analytics table, you should see you data.

Let’s know if this works.

Cheers

Busoye

On 14 Jan 2014, at 08:12, nsanzumuhire venuste vensanze@yahoo.fr wrote:

Dear all,

I 'm trying to retreive data in Tabular Report (Tracker)but i’m not seeing any value and i’m sure the data’s are there.In dhis 2.12 version,Tabular Report was working and of cause the data displayed well,the problem came in version 2.13.

Any Help?

Thanks

Venuste


Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp

sure this is the massage in the log file

xkg8N3",(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=1816) as “zLOYAR0rKyu”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=1827) as “Ow5Zy77AldC”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=1852) as “W4ae1n1WM4Y”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=1857) as “mxYdaIfg7d5”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=1846) as “rwvuPMHIvyx”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=1820) as “x72cfjXk2i7”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6987) as “DXlR3PZQPF7”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=1854) as “xLX3svXa4jn”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=1782) as “TJ6seSoOxNd”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=1783) as “JU74VOAJpIh”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=1850) as “DyuPBsChLJu”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=1833) as “ikXC367DCDD”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=1781) as “qMg8h5ZY44A”,pa.gender,pa.isdead,psi.uid,ps.uid,psi.executiondate,psi.coordinates,ou.uid,ou.name,ou.code from programstageinstance psi left join programinstance pi on psi.programinstanceid=pi.programinstanceid left join programstage ps on psi.programstageid=ps.programstageid left join program pr on pi.programid=pr.programid left join patient pa on pi.patientid=pa.patientid left join organisationunit ou on psi.organisationunitid=ou.organisationunitid left join _orgunitstructure ous on psi.organisationunitid=ous.organisationunitid left join _dateperiodstructure dps on psi.executiondate=dps.dateperiod where psi.executiondate >= ‘2014-01-01’ and psi.executiondate <= ‘2014-12-31’ and pr.programid=1759 and psi.organisationunitid is not null and psi.executiondate is not null (JdbcEventAnalyticsTableManager.java [SimpleAsyncTaskExecutor-350])

  • INFO 2014-01-14 10:13:00,296 Populate SQL: insert into analytics_event_temp_2014_niRDhkGbuMF (“uidlevel1”,“uidlevel2”,“uidlevel3”,“uidlevel4”,“uidlevel5”,“uidlevel6”,“daily”,“weekly”,“monthly”,“bimonthly”,“quarterly”,“sixmonthly”,“yearly”,“financialapril”,“financialjuly”,“financialoct”,“Q8Gxc7FfMoE”,“XIq4QSRV2Nn”,“EyfYDMBXmHE”,“aPqegw8g4oM”,“FSmrWfbzT4T”,“d0yszQlQRCz”,“MK2d1u7WWyd”,“qldaeRjhBAM”,“SzhzrQeyuSA”,“n4T9BVLyZnn”,“qE6dEnkyDHM”,“aGDc7fK8Ube”,“YiizYPd41yd”,“FFEhu3JRq4Z”,“lrY56yr1TGz”,“wuvjFH8EerI”,“gKHH7iMuYrm”,“A6MCHTv1zxR”,“bMmZIPZDLrW”,“Ie9X2FmyBDp”,“PSIXIt15HP9”,“UvXQSGoyrM7”,“I8R3IYWlpLU”,“uKODPJTYh5A”,“XLixUQ6Ktig”,“q4JU6o5B2Tu”,“zWMBEoNi8jp”,“QxEwvzJSeCz”,“hPZAxExB42F”,“a94iMIOlN73”,“qYnTkTsRjva”,“AZJmMLIVfV7”,“ui7WXjXq6XZ”,“wUHzAYfLbga”,“XLwklggqdJV”,“s6sTU2GJ0qV”,“Qb1QjqJsi8d”,“gJE32fgiIEq”,“Go2h83dCA1g”,“Nzqz9OYKFUB”,“QOYX8oOKLJo”,“qqt34kAUNnY”,“VBRD5tdRr0R”,“yNHp0FgRiKx”,“QwBWkKrGwSB”,“IjUZO1QslHs”,“o2tOEz4J0at”,“e6GccfpOvKz”,“h3YnWt4EFS6”,“YeD52betG0T”,“W3zWy2enf9B”,“rnWTGzopUnQ”,“CDwW2cf2N2s”,“gZ4O9dNLanI”,“ckP1yTtgDYq”,“d ImdlYpfyNI”,“mcWKa0YQwzu”,“wYtoPm2kd0j”,“A9W4bNAJsPU”,“ReZZy8lbYua”,gender,isdead,psi,ps,executiondate,coordinates,ou,ouname,oucode) select ous.“uidlevel1”,ous.“uidlevel2”,ous.“uidlevel3”,ous.“uidlevel4”,ous.“uidlevel5”,ous.“uidlevel6”,dps.“daily”,dps.“weekly”,dps.“monthly”,dps.“bimonthly”,dps.“quarterly”,dps.“sixmonthly”,dps.“yearly”,dps.“financialapril”,dps.“financialjuly”,dps.“financialoct”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=1995) as “Q8Gxc7FfMoE”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6956) as “XIq4QSRV2Nn”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2049) as “EyfYDMBXmHE”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=1997) as “aPqegw8g4oM”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2039) as “FSmrWfbzT4T”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=1837) as “d0yszQlQRCz”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2048) as “MK2d1u7WWyd”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2008) as “qldaeRjhBAM”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6941) as “SzhzrQeyuSA”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2036) as “n4T9BVLyZnn”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2020) as “qE6dEnkyDHM”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2004) as “aGDc7fK8Ube”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2009) as “YiizYPd41yd”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6967) as “FFEhu3JRq4Z”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2018) as “lrY56yr1TGz”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2006) as “wuvjFH8EerI”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6966) as “gKHH7iMuYrm”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2026) as “A6MCHTv1zxR”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2007) as “bMmZIPZDLrW”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6961) as “Ie9X2FmyBDp”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2046) as “PSIXIt15HP9”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2022) as “UvXQSGoyrM7”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=1923) as “I8R3IYWlpLU”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6963) as “uKODPJTYh5A”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2037) as “XLixUQ6Ktig”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6957) as “q4JU6o5B2Tu”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2032) as “zWMBEoNi8jp”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6948) as “QxEwvzJSeCz”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6960) as “hPZAxExB42F”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2023) as “a94iMIOlN73”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=1813) as “qYnTkTsRjva”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2016) as “AZJmMLIVfV7”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2038) as “ui7WXjXq6XZ”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6953) as “wUHzAYfLbga”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=1994) as “XLwklggqdJV”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6945) as “s6sTU2GJ0qV”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2003) as “Qb1QjqJsi8d”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6946) as “gJE32fgiIEq”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2028) as “Go2h83dCA1g”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6958) as “Nzqz9OYKFUB”,(select cast(value as double precision) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6969 and value ~ ‘^(-?[0-9]+)(.[0-9]+)?(E\d+)?$’) as “QOYX8oOKLJo”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=1835) as “qqt34kAUNnY”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2013) as “VBRD5tdRr0R”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2005) as “yNHp0FgRiKx”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=1992) as “QwBWkKrGwSB”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2011) as “IjUZO1QslHs”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=1922) as “o2tOEz4J0at”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=1999) as “e6GccfpOvKz”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2001) as “h3YnWt4EFS6”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2030) as “YeD52betG0T”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6955) as “W3zWy2enf9B”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6965) as “rnWTGzopUnQ”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2043) as “CDwW2cf2N2s”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2034) as “gZ4O9dNLanI”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2041) as “ckP1yTtgDYq”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6959) as “dImdlYpfyNI”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2045) as “mcWKa0YQwzu”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2015) as “wYtoPm2kd0j”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6964) as “A9W4bNAJsPU”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6947) as “ReZZy8lbYua”,pa.gender,pa.isdead,psi.uid,ps.uid,psi.executiondate,psi.coordinates,ou.uid,ou.name,ou.code from programstageinstance psi left join programinstance pi on psi.programinstanceid=pi.programinstanceid left join programstage ps on psi.programstageid=ps.programstageid left join program pr on pi.programid=pr.programid left join patient pa on pi.patientid=pa.patientid left join organisationunit ou on psi.organisationunitid=ou.organisationunitid left join _orgunitstructure ous on psi.organisationunitid=ous.organisationunitid left join _dateperiodstructure dps on psi.executiondate=dps.dateperiod where psi.executiondate >= ‘2014-01-01’ and psi.executiondate <= ‘2014-12-31’ and pr.programid=6130 and psi.organisationunitid is not null and psi.executiondate is not null (JdbcEventAnalyticsTableManager.java [SimpleAsyncTaskExecutor-349])
  • INFO 2014-01-14 10:13:00,461 [Level: ERROR, category: DATAMART, time: Tue Jan 14 10:13:00 CAT 2014, message: Process failed: Exception during execution] (InMemoryNotifier.java [taskScheduler-2])
  • ERROR 2014-01-14 10:13:00,466 Unexpected error occurred in scheduled task. (TaskUtils.java [taskScheduler-2])
    java.lang.RuntimeException: Exception during execution
    at org.hisp.dhis.system.util.ConcurrentUtils.waitForCompletion(ConcurrentUtils.java:55)
    at org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.populateTables(DefaultAnalyticsTableService.java:194)
    at org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.update(DefaultAnalyticsTableService.java:113)
    at org.hisp.dhis.analytics.scheduling.AnalyticsTableTask.run(AnalyticsTableTask.java:107)
    at org.hisp.dhis.scheduling.ScheduledTasks.run(ScheduledTasks.java:60)
    at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.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: java.util.concurrent.ExecutionException: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [insert into analytics_event_temp_2013_niRDhkGbuMF (“uidlevel1”,“uidlevel2”,“uidlevel3”,“uidlevel4”,“uidlevel5”,“uidlevel6”,“daily”,“weekly”,“monthly”,“bimonthly”,“quarterly”,“sixmonthly”,“yearly”,“financialapril”,“financialjuly”,“financialoct”,“Q8Gxc7FfMoE”,“XIq4QSRV2Nn”,“EyfYDMBXmHE”,“aPqegw8g4oM”,“FSmrWfbzT4T”,“d0yszQlQRCz”,“MK2d1u7WWyd”,“qldaeRjhBAM”,“SzhzrQeyuSA”,“n4T9BVLyZnn”,“qE6dEnkyDHM”,“aGDc7fK8Ube”,“YiizYPd41yd”,“FFEhu3JRq4Z”,“lrY56yr1TGz”,“wuvjFH8EerI”,“gKHH7iMuYrm”,“A6MCHTv1zxR”,“bMmZIPZDLrW”,“Ie9X2FmyBDp”,“PSIXIt15HP9”,“UvXQSGoyrM7”,“I8R3IYWlpLU”,“uKODPJTYh5A”,“XLixUQ6Ktig”,“q4JU6o5B2Tu”,“zWMBEoNi8jp”,“QxEwvzJSeCz”,“hPZAxExB42F”,“a94iMIOlN73”,“qYnTkTsRjva”,“AZJmMLIVfV7”,“ui7WXjXq6XZ”,“wUHzAYfLbga”,“XLwklggqdJV”,“s6sTU2GJ0qV”,“Qb1QjqJsi8d”,“gJE32fgiIEq”,“Go2h83dCA1g”,“Nzqz9OYKFUB”,“QOYX8oOKLJo”,“qqt34kAUNnY”,“VBRD5tdRr0R”,“yNHp0FgRiKx”,“QwBWkKrGwSB”,“IjUZO1QslHs”,“o2tOEz4J0at”,“e6GccfpOvKz”,“h3YnWt4EFS6”,“YeD52betG0T”,“W3zWy2enf9B”,“rnWTGzopUnQ”,“CDwW2cf2N2s”,“gZ4O9dNLanI”,“ckP1yTtgDYq”,“d ImdlYpfyNI”,“mcWKa0YQwzu”,“wYtoPm2kd0j”,“A9W4bNAJsPU”,“ReZZy8lbYua”,gender,isdead,psi,ps,executiondate,coordinates,ou,ouname,oucode) select ous.“uidlevel1”,ous.“uidlevel2”,ous.“uidlevel3”,ous.“uidlevel4”,ous.“uidlevel5”,ous.“uidlevel6”,dps.“daily”,dps.“weekly”,dps.“monthly”,dps.“bimonthly”,dps.“quarterly”,dps.“sixmonthly”,dps.“yearly”,dps.“financialapril”,dps.“financialjuly”,dps.“financialoct”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=1995) as “Q8Gxc7FfMoE”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6956) as “XIq4QSRV2Nn”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2049) as “EyfYDMBXmHE”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=1997) as “aPqegw8g4oM”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2039) as “FSmrWfbzT4T”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=1837) as “d0yszQlQRCz”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2048) as “MK2d1u7WWyd”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2008) as “qldaeRjhBAM”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6941) as “SzhzrQeyuSA”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2036) as “n4T9BVLyZnn”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2020) as “qE6dEnkyDHM”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2004) as “aGDc7fK8Ube”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2009) as “YiizYPd41yd”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6967) as “FFEhu3JRq4Z”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2018) as “lrY56yr1TGz”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2006) as “wuvjFH8EerI”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6966) as “gKHH7iMuYrm”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2026) as “A6MCHTv1zxR”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2007) as “bMmZIPZDLrW”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6961) as “Ie9X2FmyBDp”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2046) as “PSIXIt15HP9”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2022) as “UvXQSGoyrM7”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=1923) as “I8R3IYWlpLU”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6963) as “uKODPJTYh5A”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2037) as “XLixUQ6Ktig”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6957) as “q4JU6o5B2Tu”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2032) as “zWMBEoNi8jp”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6948) as “QxEwvzJSeCz”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6960) as “hPZAxExB42F”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2023) as “a94iMIOlN73”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=1813) as “qYnTkTsRjva”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2016) as “AZJmMLIVfV7”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2038) as “ui7WXjXq6XZ”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6953) as “wUHzAYfLbga”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=1994) as “XLwklggqdJV”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6945) as “s6sTU2GJ0qV”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2003) as “Qb1QjqJsi8d”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6946) as “gJE32fgiIEq”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2028) as “Go2h83dCA1g”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6958) as “Nzqz9OYKFUB”,(select cast(value as double precision) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6969 and value ~ ‘^(-?[0-9]+)(.[0-9]+)?(E\d+)?$’) as “QOYX8oOKLJo”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=1835) as “qqt34kAUNnY”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2013) as “VBRD5tdRr0R”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2005) as “yNHp0FgRiKx”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=1992) as “QwBWkKrGwSB”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2011) as “IjUZO1QslHs”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=1922) as “o2tOEz4J0at”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=1999) as “e6GccfpOvKz”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2001) as “h3YnWt4EFS6”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2030) as “YeD52betG0T”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6955) as “W3zWy2enf9B”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6965) as “rnWTGzopUnQ”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2043) as “CDwW2cf2N2s”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2034) as “gZ4O9dNLanI”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2041) as “ckP1yTtgDYq”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6959) as “dImdlYpfyNI”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2045) as “mcWKa0YQwzu”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2015) as “wYtoPm2kd0j”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6964) as “A9W4bNAJsPU”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6947) as “ReZZy8lbYua”,pa.gender,pa.isdead,psi.uid,ps.uid,psi.executiondate,psi.coordinates,ou.uid,ou.name,ou.code from programstageinstance psi left join programinstance pi on psi.programinstanceid=pi.programinstanceid left join programstage ps on psi.programstageid=ps.programstageid left join program pr on pi.programid=pr.programid left join patient pa on pi.patientid=pa.patientid left join organisationunit ou on psi.organisationunitid=ou.organisationunitid left join _orgunitstructure ous on psi.organisationunitid=ous.organisationunitid left join _dateperiodstructure dps on psi.executiondate=dps.dateperiod where psi.executiondate >= ‘2013-01-01’ and psi.executiondate <= ‘2013-12-31’ and pr.programid=6130 and psi.organisationunitid is not null and psi.executiondate is not null]; nested exception is org.postgresql.util.PSQLException: ERROR: more than one row returned by a subquery used as an expression
    at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:252)
    at java.util.concurrent.FutureTask.get(FutureTask.java:111)
    at org.hisp.dhis.system.util.ConcurrentUtils.waitForCompletion(ConcurrentUtils.java:51)
    … 13 more
    Caused by: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [insert into analytics_event_temp_2013_niRDhkGbuMF (“uidlevel1”,“uidlevel2”,“uidlevel3”,“uidlevel4”,“uidlevel5”,“uidlevel6”,“daily”,“weekly”,“monthly”,“bimonthly”,“quarterly”,“sixmonthly”,“yearly”,“financialapril”,“financialjuly”,“financialoct”,“Q8Gxc7FfMoE”,“XIq4QSRV2Nn”,“EyfYDMBXmHE”,“aPqegw8g4oM”,“FSmrWfbzT4T”,“d0yszQlQRCz”,“MK2d1u7WWyd”,“qldaeRjhBAM”,“SzhzrQeyuSA”,“n4T9BVLyZnn”,“qE6dEnkyDHM”,“aGDc7fK8Ube”,“YiizYPd41yd”,“FFEhu3JRq4Z”,“lrY56yr1TGz”,“wuvjFH8EerI”,“gKHH7iMuYrm”,“A6MCHTv1zxR”,“bMmZIPZDLrW”,“Ie9X2FmyBDp”,“PSIXIt15HP9”,“UvXQSGoyrM7”,“I8R3IYWlpLU”,“uKODPJTYh5A”,“XLixUQ6Ktig”,“q4JU6o5B2Tu”,“zWMBEoNi8jp”,“QxEwvzJSeCz”,“hPZAxExB42F”,“a94iMIOlN73”,“qYnTkTsRjva”,“AZJmMLIVfV7”,“ui7WXjXq6XZ”,“wUHzAYfLbga”,“XLwklggqdJV”,“s6sTU2GJ0qV”,“Qb1QjqJsi8d”,“gJE32fgiIEq”,“Go2h83dCA1g”,“Nzqz9OYKFUB”,“QOYX8oOKLJo”,“qqt34kAUNnY”,“VBRD5tdRr0R”,“yNHp0FgRiKx”,“QwBWkKrGwSB”,“IjUZO1QslHs”,“o2tOEz4J0at”,“e6GccfpOvKz”,“h3YnWt4EFS6”,“YeD52betG0T”,“W3zWy2enf9B”,“rnWTGzopUnQ”,“CDwW2cf2N2s”,“gZ4O9dNLanI”,“ckP1yTtgDYq”,“d ImdlYpfyNI”,“mcWKa0YQwzu”,“wYtoPm2kd0j”,“A9W4bNAJsPU”,“ReZZy8lbYua”,gender,isdead,psi,ps,executiondate,coordinates,ou,ouname,oucode) select ous.“uidlevel1”,ous.“uidlevel2”,ous.“uidlevel3”,ous.“uidlevel4”,ous.“uidlevel5”,ous.“uidlevel6”,dps.“daily”,dps.“weekly”,dps.“monthly”,dps.“bimonthly”,dps.“quarterly”,dps.“sixmonthly”,dps.“yearly”,dps.“financialapril”,dps.“financialjuly”,dps.“financialoct”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=1995) as “Q8Gxc7FfMoE”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6956) as “XIq4QSRV2Nn”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2049) as “EyfYDMBXmHE”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=1997) as “aPqegw8g4oM”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2039) as “FSmrWfbzT4T”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=1837) as “d0yszQlQRCz”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2048) as “MK2d1u7WWyd”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2008) as “qldaeRjhBAM”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6941) as “SzhzrQeyuSA”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2036) as “n4T9BVLyZnn”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2020) as “qE6dEnkyDHM”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2004) as “aGDc7fK8Ube”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2009) as “YiizYPd41yd”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6967) as “FFEhu3JRq4Z”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2018) as “lrY56yr1TGz”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2006) as “wuvjFH8EerI”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6966) as “gKHH7iMuYrm”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2026) as “A6MCHTv1zxR”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2007) as “bMmZIPZDLrW”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6961) as “Ie9X2FmyBDp”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2046) as “PSIXIt15HP9”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2022) as “UvXQSGoyrM7”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=1923) as “I8R3IYWlpLU”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6963) as “uKODPJTYh5A”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2037) as “XLixUQ6Ktig”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6957) as “q4JU6o5B2Tu”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2032) as “zWMBEoNi8jp”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6948) as “QxEwvzJSeCz”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6960) as “hPZAxExB42F”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2023) as “a94iMIOlN73”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=1813) as “qYnTkTsRjva”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2016) as “AZJmMLIVfV7”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2038) as “ui7WXjXq6XZ”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6953) as “wUHzAYfLbga”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=1994) as “XLwklggqdJV”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6945) as “s6sTU2GJ0qV”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2003) as “Qb1QjqJsi8d”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6946) as “gJE32fgiIEq”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2028) as “Go2h83dCA1g”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6958) as “Nzqz9OYKFUB”,(select cast(value as double precision) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6969 and value ~ ‘^(-?[0-9]+)(.[0-9]+)?(E\d+)?$’) as “QOYX8oOKLJo”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=1835) as “qqt34kAUNnY”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2013) as “VBRD5tdRr0R”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2005) as “yNHp0FgRiKx”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=1992) as “QwBWkKrGwSB”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2011) as “IjUZO1QslHs”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=1922) as “o2tOEz4J0at”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=1999) as “e6GccfpOvKz”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2001) as “h3YnWt4EFS6”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2030) as “YeD52betG0T”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6955) as “W3zWy2enf9B”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6965) as “rnWTGzopUnQ”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2043) as “CDwW2cf2N2s”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2034) as “gZ4O9dNLanI”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2041) as “ckP1yTtgDYq”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6959) as “dImdlYpfyNI”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2045) as “mcWKa0YQwzu”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2015) as “wYtoPm2kd0j”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6964) as “A9W4bNAJsPU”,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6947) as “ReZZy8lbYua”,pa.gender,pa.isdead,psi.uid,ps.uid,psi.executiondate,psi.coordinates,ou.uid,ou.name,ou.code from programstageinstance psi left join programinstance pi on psi.programinstanceid=pi.programinstanceid left join programstage ps on psi.programstageid=ps.programstageid left join program pr on pi.programid=pr.programid left join patient pa on pi.patientid=pa.patientid left join organisationunit ou on psi.organisationunitid=ou.organisationunitid left join _orgunitstructure ous on psi.organisationunitid=ous.organisationunitid left join _dateperiodstructure dps on psi.executiondate=dps.dateperiod where psi.executiondate >= ‘2013-01-01’ and psi.executiondate <= ‘2013-12-31’ and pr.programid=6130 and psi.organisationunitid is not null and psi.executiondate is not null]; nested exception is org.postgresql.util.PSQLException: ERROR: more than one row returned by a subquery used as an expression
    at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:98)
    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407)
    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:428)
    at org.hisp.dhis.analytics.table.JdbcEventAnalyticsTableManager.populateTableAsync(JdbcEventAnalyticsTableManager.java:179)
    at sun.reflect.GeneratedMethodAccessor329.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:183)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
    at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:95)
    at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
    at java.util.concurrent.FutureTask.run(FutureTask.java:166)
    … 1 more
    Caused by: org.postgresql.util.PSQLException: ERROR: more than one row returned by a subquery used as an expression
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:366)
    at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:1006)
    at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:421)
    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)
    … 12 more

Can you send the relevant section of the log file so we know what is causing the exception?

···

Le Mardi 14 janvier 2014 2h53, Adebusoye Anifalaje busoye@hisp.org a écrit :

On 14 Jan 2014, at 09:24, nsanzumuhire venuste vensanze@yahoo.fr wrote:

I have tried to run Analytics table before,but see below the message.

2014-01-14 05:50:38
Process failed: Exception during execution
2014-01-14 05:50:34
Populating
analytics tables
2014-01-14 05:49:58
Creating analytics tables
2014-01-14 05:49:57
Updating event analytics tables
2014-01-14 05:49:57
Table update done
2014-01-14 05:49:57
Swapping analytics tables
2014-01-14 05:49:57
Vacuuming tables
2014-01-14 05:49:57
Creating indexes
2014-01-14 05:49:57
Applying aggregation levels
2014-01-14 05:49:57
Pruned analytics tables
2014-01-14 05:49:57
Populating analytics tables
2014-01-14 05:49:57
Creating analytics tables
2014-01-14 05:49:57
Updating compeleteness target table
2014-01-14 05:49:57
Table update done
2014-01-14 05:49:57
Swapping analytics tables
2014-01-14 05:49:57
Vacuuming tables
2014-01-14 05:49:57
Creating indexes
2014-01-14 05:49:57
Applying aggregation levels
2014-01-14 05:49:57
Pruned analytics tables
2014-01-14 05:49:57
Populating analytics tables
2014-01-14 05:49:57
Creating analytics tables
2014-01-14 05:49:57
Updating completeness tables
2014-01-14 05:49:57
Table update done
2014-01-14 05:49:57
Swapping analytics tables
2014-01-14 05:49:57
Vacuuming tables
2014-01-14 05:49:57
Creating indexes
2014-01-14 05:49:57
Applying
aggregation levels
2014-01-14 05:49:57
Pruned analytics tables
2014-01-14 05:49:56
Populating analytics tables
2014-01-14 05:49:56
Creating analytics tables
2014-01-14 05:49:56
Updating analytics tables
2014-01-14 05:49:48
Updating resource tables

Le Mardi 14 janvier 2014 2h09, Adebusoye Anifalaje busoye@hisp.org a écrit :

Hi,

Remember that the tabular report also depends on the analytics table.

Once you run the analytics table, you should see you data.

Let’s know if this works.

Cheers

Busoye

On 14 Jan 2014, at 08:12, nsanzumuhire venuste vensanze@yahoo.fr wrote:

Dear all,

I 'm trying to retreive data in Tabular
Report (Tracker)but i’m not seeing any value and i’m sure the data’s are there.In dhis 2.12 version,Tabular Report was working and of cause the data displayed well,the problem came in version 2.13.

Any Help?

Thanks

Venuste


Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp

Hi Venuste, this is the significant part:

Caused by: org.postgresql.util.PSQLException: ERROR: more than one row
returned by a subquery used as an expression

So there is some integrity/uniqueness issue with your database. Are you
able to share the database privately so I can have a look?

Lars