← Back to team overview

dhis2-users team mailing list archive

  1. dhis2-users team
  2. Mailing list archive
  3. Message #03682

Re: Tabular Report doesent display value

  Thread Previous • Date Previous • • Thread Next 
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
  






Le Mardi 14 janvier 2014 2h53, Adebusoye Anifalaje <busoye@xxxxxxxx> a écrit :
 
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@xxxxxxxx> 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@xxxxxxxx> 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@xxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
>>Unsubscribe : https://launchpad.net/~dhis2-users
>>More help   : https://help.launchpad.net/ListHelp
>>
>
>
>

Follow ups

References

  Thread Previous • Date Previous • • Thread Next