ED2 KC- Analytics Exception: util.ConcurrentUtils.waitForCompletion

---

Solution: Check postgresql.log - it is likely a resource issue due to lack of available memory. Re-run analytics with a smaller subset (1 last year) or with a smaller sever load. Ultimately, if it is a memory issue the server will need resources added.

Analytics Logs

Concurrency issue between Analytics and Continuous Analytics Task Scheduler

ERROR 2021-07-07T12:26:12,496 Analytics table process failed: java.lang.RuntimeException: Exception during execution
    at org.hisp.dhis.commons.util.ConcurrentUtils.waitForCompletion(ConcurrentUtils.java:61)
    at org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.populateTables(DefaultAnalyticsTableService.java:276)
    at org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.update(DefaultAnalyticsTableService.java:166)
    at org.hisp.dhis.analytics.table.DefaultAnalyticsTableGenerator.generateTables(DefaultAnalyticsTableGenerator.java:137)
    at org.hisp.dhis.analytics.table.scheduling.ContinuousAnalyticsTableJob.execute(ContinuousAnalyticsTableJob.java:133)
    at org.hisp.dhis.scheduling.DefaultJobInstance.executeJob(DefaultJobInstance.java:173)
    at org.hisp.dhis.scheduling.DefaultJobInstance.execute(DefaultJobInstance.java:103)
    at org.hisp.dhis.scheduling.DefaultSchedulingManager.lambda$scheduleJob$2(DefaultSchedulingManager.java:193)
    at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
    at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at java.lang.Thread.run(Thread.java:748)
Caused by: java.util.concurrent.ExecutionException: org.springframework.dao.DataIntegrityViolationException: StatementCallback; SQL [insert into analytics_event_temp_fcg17cszswm_0 ("uidlevel1","uidlevel2","uidlevel3","uidlevel4","uidlevel5","uidlevel6","uidlevel7","uidlevel8","UOCVGT5pFb8","L78PtSgQ9hK","jpzvMY9zchJ","flod1BpeZpn","TWpLqJ9fEay","loEYmakRywD","uefNVIO6XHd","CH9nCUgbkn0","bYDNVZ4dDyq","mYo1OdNpe7B","rrmQnyX6CR3","jEmHPhfcznZ","t5Vb25H4Ld4","Dn3TvKMmRW2","iddhd4Zv29T","r4cXrdCPiK6","qcC7MoB5lZK","SUv2ytWYvYB","tbAGVEDuceX","KhF0NroJxnN","pYbRl3AUrtH","daily","weekly","weeklywednesday","weeklythursday","weeklysaturday","weeklysunday","biweekly","monthly","bimonthly","quarterly","sixmonthly","sixmonthlyapril","sixmonthlynov","yearly","financialapril","financialjuly","financialoct","financialnov","vhLREXkrIJS","TusePAOpoIs","AAaeOiqtONW","RhqVPUmGKlg","j2OId961SVu","HniOzDKFKRy","sF21TWc3jjD","sg9wqNbxonT","gZiBah1cxJL","h7iShQec76l","DHz7wUPwAqq","dJhrdgd6mqG","i5M3hVUNoTa","rSajAOLRz4d","rLJXDJKR2iZ","PCXMsdQfECN","U3SZgreH6Cq","LuUmtvGJMNN","WJAUMgILETw","LeIyYtQfh02","vwvQP8pVbVm","uu5obcfohEr","Jr6l3dZgD0D","nNMCNTblkTS","E6H8xGn1Dbt","Podr9dkZ1dM","txIrJG1iX4k","WulmkqvCSgG","C2mZj8xy186","fF4njAkbI7x","uE6G4GBVYdu","Ap91q7nHJSv","UFQs8yaBKpb","KxZAW9VsCDP","JUN4RtGATWq","n7ozbVAwH3V","wLu9eSHn0ga","MpQ6w0boP3Y","Nd37ZwZCIXI","VOS0tRHvZju","WrfrJhESJSw","qtkiHQdcs9N","QOtbuNC1EW9","V0TRtyOfde6","IV8UxuL6q7f","dOC7FnbSidv","y3vT9glyteD","EwX5bPPTgxW","qarF0snI3hT","N3YmEIoyfHm","XyNEDCO6HlL","l6p3rF8u68g","ujOGgL8BK2u","fNCDsWFtBz5","xgzq611f4Xn","KLPISLZrQJI","lRn9yETdEQZ","x7YVAFRmlOS","GtCF482duhv","KvO7C0RmC5h","ShaNUo8NIlu","YILWYLQmgQa","yayj7VDug5H","K0jCfidQXY4","WmkqxSERsb8","YZR1m5rxYzu","lsjx8mJCBkc","CCHujRxKxAO","MiIwYI5g79h","V9miEYsKXmm","wgDiBFsD7RC","EwSDIGnQW2f","q4EJDBDFUtP","uIMxi8QEtnB","aIzfji1fWbj","miTN72ZQZe8","UJ3NpQiHkSS","dLOnHV3cSHI","lg6wDWxQPpg","GDs5QDdE2nG","RUWJ65OE1Wt","W2iXxuW8EzR","CXKuKgyC8fs","hlSFLIAQXSL","I6LaG8DnSl1","W8izlRF3Pjj","ZENwfUnoSMP","lklZVCcDFcD","e8NiqL3qqr9","miv2k8RIVnC","PXmq2b0jqiu","Dk7Nf36OFnp","YjTDrKjzjUh","gG9y8G2inZO","Fkpc9dsNjVV","AGOF2yYdvHj","C1h6VNqwOC3","jx6dZuKlZjT","EFlkdjpm0hw","psi","pi","ps","ao","enrollmentdate","incidentdate","executiondate","duedate","completeddate","created","lastupdated","pistatus","psistatus","psigeometry","longitude","latitude","ou","ouname","oucode") select ous."uidlevel1",ous."uidlevel2",ous."uidlevel3",ous."uidlevel4",ous."uidlevel5",ous."uidlevel6",ous."uidlevel7",ous."uidlevel8",ougs."UOCVGT5pFb8",ougs."L78PtSgQ9hK",ougs."jpzvMY9zchJ",ougs."flod1BpeZpn",ougs."TWpLqJ9fEay",ougs."loEYmakRywD",ougs."uefNVIO6XHd",ougs."CH9nCUgbkn0",ougs."bYDNVZ4dDyq",ougs."mYo1OdNpe7B",ougs."rrmQnyX6CR3",ougs."jEmHPhfcznZ",ougs."t5Vb25H4Ld4",ougs."Dn3TvKMmRW2",ougs."iddhd4Zv29T",ougs."r4cXrdCPiK6",ougs."qcC7MoB5lZK",ougs."SUv2ytWYvYB",ougs."tbAGVEDuceX",ougs."KhF0NroJxnN",ougs."pYbRl3AUrtH",dps."daily",dps."weekly",dps."weeklywednesday",dps."weeklythursday",dps."weeklysaturday",dps."weeklysunday",dps."biweekly",dps."monthly",dps."bimonthly",dps."quarterly",dps."sixmonthly",dps."sixmonthlyapril",dps."sixmonthlynov",dps."yearly",dps."financialapril",dps."financialjuly",dps."financialoct",dps."financialnov",(select case when eventdatavalues #>> '{vhLREXkrIJS, value}' = 'true' then 1 when eventdatavalues #>> '{vhLREXkrIJS, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "vhLREXkrIJS",(select case when eventdatavalues #>> '{TusePAOpoIs, value}' = 'true' then 1 when eventdatavalues #>> '{TusePAOpoIs, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "TusePAOpoIs",(select eventdatavalues #>> '{AAaeOiqtONW, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "AAaeOiqtONW",(select case when eventdatavalues #>> '{RhqVPUmGKlg, value}' = 'true' then 1 when eventdatavalues #>> '{RhqVPUmGKlg, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "RhqVPUmGKlg",(select case when eventdatavalues #>> '{j2OId961SVu, value}' = 'true' then 1 when eventdatavalues #>> '{j2OId961SVu, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "j2OId961SVu",(select case when eventdatavalues #>> '{HniOzDKFKRy, value}' = 'true' then 1 when eventdatavalues #>> '{HniOzDKFKRy, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "HniOzDKFKRy",(select case when eventdatavalues #>> '{sF21TWc3jjD, value}' = 'true' then 1 when eventdatavalues #>> '{sF21TWc3jjD, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "sF21TWc3jjD",(select eventdatavalues #>> '{sg9wqNbxonT, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "sg9wqNbxonT",(select case when eventdatavalues #>> '{gZiBah1cxJL, value}' = 'true' then 1 when eventdatavalues #>> '{gZiBah1cxJL, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "gZiBah1cxJL",(select case when eventdatavalues #>> '{h7iShQec76l, value}' = 'true' then 1 when eventdatavalues #>> '{h7iShQec76l, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "h7iShQec76l",(select case when eventdatavalues #>> '{DHz7wUPwAqq, value}' = 'true' then 1 when eventdatavalues #>> '{DHz7wUPwAqq, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "DHz7wUPwAqq",(select cast(eventdatavalues #>> '{dJhrdgd6mqG, value}' as bigint) from programstageinstance where programstageinstanceid=psi.programstageinstanceid  and eventdatavalues #>> '{dJhrdgd6mqG,value}' ~* '^(-?[0-9]+)(\.[0-9]+)?$') as "dJhrdgd6mqG",(select eventdatavalues #>> '{i5M3hVUNoTa, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "i5M3hVUNoTa",(select case when eventdatavalues #>> '{rSajAOLRz4d, value}' = 'true' then 1 when eventdatavalues #>> '{rSajAOLRz4d, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "rSajAOLRz4d",(select eventdatavalues #>> '{rLJXDJKR2iZ, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "rLJXDJKR2iZ",(select case when eventdatavalues #>> '{PCXMsdQfECN, value}' = 'true' then 1 when eventdatavalues #>> '{PCXMsdQfECN, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "PCXMsdQfECN",(select case when eventdatavalues #>> '{U3SZgreH6Cq, value}' = 'true' then 1 when eventdatavalues #>> '{U3SZgreH6Cq, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "U3SZgreH6Cq",(select case when eventdatavalues #>> '{LuUmtvGJMNN, value}' = 'true' then 1 when eventdatavalues #>> '{LuUmtvGJMNN, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "LuUmtvGJMNN",(select case when eventdatavalues #>> '{WJAUMgILETw, value}' = 'true' then 1 when eventdatavalues #>> '{WJAUMgILETw, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "WJAUMgILETw",(select case when eventdatavalues #>> '{LeIyYtQfh02, value}' = 'true' then 1 when eventdatavalues #>> '{LeIyYtQfh02, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "LeIyYtQfh02",(select eventdatavalues #>> '{vwvQP8pVbVm, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "vwvQP8pVbVm",(select case when eventdatavalues #>> '{uu5obcfohEr, value}' = 'true' then 1 when eventdatavalues #>> '{uu5obcfohEr, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "uu5obcfohEr",(select case when eventdatavalues #>> '{Jr6l3dZgD0D, value}' = 'true' then 1 when eventdatavalues #>> '{Jr6l3dZgD0D, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "Jr6l3dZgD0D",(select case when eventdatavalues #>> '{nNMCNTblkTS, value}' = 'true' then 1 when eventdatavalues #>> '{nNMCNTblkTS, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "nNMCNTblkTS",(select case when eventdatavalues #>> '{E6H8xGn1Dbt, value}' = 'true' then 1 when eventdatavalues #>> '{E6H8xGn1Dbt, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "E6H8xGn1Dbt",(select case when eventdatavalues #>> '{Podr9dkZ1dM, value}' = 'true' then 1 when eventdatavalues #>> '{Podr9dkZ1dM, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "Podr9dkZ1dM",(select case when eventdatavalues #>> '{txIrJG1iX4k, value}' = 'true' then 1 when eventdatavalues #>> '{txIrJG1iX4k, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "txIrJG1iX4k",(select case when eventdatavalues #>> '{WulmkqvCSgG, value}' = 'true' then 1 when eventdatavalues #>> '{WulmkqvCSgG, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "WulmkqvCSgG",(select case when eventdatavalues #>> '{C2mZj8xy186, value}' = 'true' then 1 when eventdatavalues #>> '{C2mZj8xy186, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "C2mZj8xy186",(select case when eventdatavalues #>> '{fF4njAkbI7x, value}' = 'true' then 1 when eventdatavalues #>> '{fF4njAkbI7x, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "fF4njAkbI7x",(select cast(eventdatavalues #>> '{uE6G4GBVYdu, value}' as timestamp) from programstageinstance where programstageinstanceid=psi.programstageinstanceid  and eventdatavalues #>> '{uE6G4GBVYdu,value}' ~* '^\d{4}-\d{2}-\d{2}(\s|T)?((\d{2}:)(\d{2}:)?(\d{2}))?$') as "uE6G4GBVYdu",(select eventdatavalues #>> '{Ap91q7nHJSv, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "Ap91q7nHJSv",(select eventdatavalues #>> '{UFQs8yaBKpb, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "UFQs8yaBKpb",(select eventdatavalues #>> '{KxZAW9VsCDP, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "KxZAW9VsCDP",(select case when eventdatavalues #>> '{JUN4RtGATWq, value}' = 'true' then 1 when eventdatavalues #>> '{JUN4RtGATWq, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "JUN4RtGATWq",(select case when eventdatavalues #>> '{n7ozbVAwH3V, value}' = 'true' then 1 when eventdatavalues #>> '{n7ozbVAwH3V, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "n7ozbVAwH3V",(select eventdatavalues #>> '{wLu9eSHn0ga, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "wLu9eSHn0ga",(select case when eventdatavalues #>> '{MpQ6w0boP3Y, value}' = 'true' then 1 when eventdatavalues #>> '{MpQ6w0boP3Y, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "MpQ6w0boP3Y",(select case when eventdatavalues #>> '{Nd37ZwZCIXI, value}' = 'true' then 1 when eventdatavalues #>> '{Nd37ZwZCIXI, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "Nd37ZwZCIXI",(select case when eventdatavalues #>> '{VOS0tRHvZju, value}' = 'true' then 1 when eventdatavalues #>> '{VOS0tRHvZju, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "VOS0tRHvZju",(select eventdatavalues #>> '{WrfrJhESJSw, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "WrfrJhESJSw",(select case when eventdatavalues #>> '{qtkiHQdcs9N, value}' = 'true' then 1 when eventdatavalues #>> '{qtkiHQdcs9N, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "qtkiHQdcs9N",(select case when eventdatavalues #>> '{QOtbuNC1EW9, value}' = 'true' then 1 when eventdatavalues #>> '{QOtbuNC1EW9, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "QOtbuNC1EW9",(select case when eventdatavalues #>> '{V0TRtyOfde6, value}' = 'true' then 1 when eventdatavalues #>> '{V0TRtyOfde6, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "V0TRtyOfde6",(select eventdatavalues #>> '{IV8UxuL6q7f, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "IV8UxuL6q7f",(select case when eventdatavalues #>> '{dOC7FnbSidv, value}' = 'true' then 1 when eventdatavalues #>> '{dOC7FnbSidv, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "dOC7FnbSidv",(select case when eventdatavalues #>> '{y3vT9glyteD, value}' = 'true' then 1 when eventdatavalues #>> '{y3vT9glyteD, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "y3vT9glyteD",(select eventdatavalues #>> '{EwX5bPPTgxW, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "EwX5bPPTgxW",(select eventdatavalues #>> '{qarF0snI3hT, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "qarF0snI3hT",(select eventdatavalues #>> '{N3YmEIoyfHm, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "N3YmEIoyfHm",(select case when eventdatavalues #>> '{XyNEDCO6HlL, value}' = 'true' then 1 when eventdatavalues #>> '{XyNEDCO6HlL, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "XyNEDCO6HlL",(select case when eventdatavalues #>> '{l6p3rF8u68g, value}' = 'true' then 1 when eventdatavalues #>> '{l6p3rF8u68g, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "l6p3rF8u68g",(select eventdatavalues #>> '{ujOGgL8BK2u, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "ujOGgL8BK2u",(select case when eventdatavalues #>> '{fNCDsWFtBz5, value}' = 'true' then 1 when eventdatavalues #>> '{fNCDsWFtBz5, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "fNCDsWFtBz5",(select eventdatavalues #>> '{xgzq611f4Xn, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "xgzq611f4Xn",(select case when eventdatavalues #>> '{KLPISLZrQJI, value}' = 'true' then 1 when eventdatavalues #>> '{KLPISLZrQJI, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "KLPISLZrQJI",(select eventdatavalues #>> '{lRn9yETdEQZ, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "lRn9yETdEQZ",(select eventdatavalues #>> '{x7YVAFRmlOS, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "x7YVAFRmlOS",(select case when eventdatavalues #>> '{GtCF482duhv, value}' = 'true' then 1 when eventdatavalues #>> '{GtCF482duhv, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "GtCF482duhv",(select eventdatavalues #>> '{KvO7C0RmC5h, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "KvO7C0RmC5h",(select eventdatavalues #>> '{ShaNUo8NIlu, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "ShaNUo8NIlu",(select eventdatavalues #>> '{YILWYLQmgQa, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "YILWYLQmgQa",(select case when eventdatavalues #>> '{yayj7VDug5H, value}' = 'true' then 1 when eventdatavalues #>> '{yayj7VDug5H, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "yayj7VDug5H",(select eventdatavalues #>> '{K0jCfidQXY4, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "K0jCfidQXY4",(select case when eventdatavalues #>> '{WmkqxSERsb8, value}' = 'true' then 1 when eventdatavalues #>> '{WmkqxSERsb8, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "WmkqxSERsb8",(select case when eventdatavalues #>> '{YZR1m5rxYzu, value}' = 'true' then 1 when eventdatavalues #>> '{YZR1m5rxYzu, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "YZR1m5rxYzu",(select eventdatavalues #>> '{lsjx8mJCBkc, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "lsjx8mJCBkc",(select case when eventdatavalues #>> '{CCHujRxKxAO, value}' = 'true' then 1 when eventdatavalues #>> '{CCHujRxKxAO, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "CCHujRxKxAO",(select cast(eventdatavalues #>> '{MiIwYI5g79h, value}' as timestamp) from programstageinstance where programstageinstanceid=psi.programstageinstanceid  and eventdatavalues #>> '{MiIwYI5g79h,value}' ~* '^\d{4}-\d{2}-\d{2}(\s|T)?((\d{2}:)(\d{2}:)?(\d{2}))?$') as "MiIwYI5g79h",(select eventdatavalues #>> '{V9miEYsKXmm, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "V9miEYsKXmm",(select case when eventdatavalues #>> '{wgDiBFsD7RC, value}' = 'true' then 1 when eventdatavalues #>> '{wgDiBFsD7RC, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "wgDiBFsD7RC",(select case when eventdatavalues #>> '{EwSDIGnQW2f, value}' = 'true' then 1 when eventdatavalues #>> '{EwSDIGnQW2f, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "EwSDIGnQW2f",(select cast(eventdatavalues #>> '{q4EJDBDFUtP, value}' as bigint) from programstageinstance where programstageinstanceid=psi.programstageinstanceid  and eventdatavalues #>> '{q4EJDBDFUtP,value}' ~* '^(-?[0-9]+)(\.[0-9]+)?$') as "q4EJDBDFUtP",(select case when eventdatavalues #>> '{uIMxi8QEtnB, value}' = 'true' then 1 when eventdatavalues #>> '{uIMxi8QEtnB, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "uIMxi8QEtnB",(select eventdatavalues #>> '{aIzfji1fWbj, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "aIzfji1fWbj",(select eventdatavalues #>> '{miTN72ZQZe8, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "miTN72ZQZe8",(select case when eventdatavalues #>> '{UJ3NpQiHkSS, value}' = 'true' then 1 when eventdatavalues #>> '{UJ3NpQiHkSS, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "UJ3NpQiHkSS",(select eventdatavalues #>> '{dLOnHV3cSHI, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "dLOnHV3cSHI",(select case when eventdatavalues #>> '{lg6wDWxQPpg, value}' = 'true' then 1 when eventdatavalues #>> '{lg6wDWxQPpg, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "lg6wDWxQPpg",(select eventdatavalues #>> '{GDs5QDdE2nG, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "GDs5QDdE2nG",(select case when eventdatavalues #>> '{RUWJ65OE1Wt, value}' = 'true' then 1 when eventdatavalues #>> '{RUWJ65OE1Wt, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "RUWJ65OE1Wt",(select eventdatavalues #>> '{W2iXxuW8EzR, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "W2iXxuW8EzR",(select eventdatavalues #>> '{CXKuKgyC8fs, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "CXKuKgyC8fs",(select cast(eventdatavalues #>> '{hlSFLIAQXSL, value}' as double precision) from programstageinstance where programstageinstanceid=psi.programstageinstanceid  and eventdatavalues #>> '{hlSFLIAQXSL,value}' ~* '^(-?[0-9]+)(\.[0-9]+)?$') as "hlSFLIAQXSL",(select case when eventdatavalues #>> '{I6LaG8DnSl1, value}' = 'true' then 1 when eventdatavalues #>> '{I6LaG8DnSl1, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "I6LaG8DnSl1",(select case when eventdatavalues #>> '{W8izlRF3Pjj, value}' = 'true' then 1 when eventdatavalues #>> '{W8izlRF3Pjj, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "W8izlRF3Pjj",(select eventdatavalues #>> '{ZENwfUnoSMP, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "ZENwfUnoSMP",(select case when eventdatavalues #>> '{lklZVCcDFcD, value}' = 'true' then 1 when eventdatavalues #>> '{lklZVCcDFcD, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "lklZVCcDFcD",(select case when eventdatavalues #>> '{e8NiqL3qqr9, value}' = 'true' then 1 when eventdatavalues #>> '{e8NiqL3qqr9, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "e8NiqL3qqr9",(select eventdatavalues #>> '{miv2k8RIVnC, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "miv2k8RIVnC",(select case when eventdatavalues #>> '{PXmq2b0jqiu, value}' = 'true' then 1 when eventdatavalues #>> '{PXmq2b0jqiu, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "PXmq2b0jqiu",(select case when eventdatavalues #>> '{Dk7Nf36OFnp, value}' = 'true' then 1 when eventdatavalues #>> '{Dk7Nf36OFnp, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "Dk7Nf36OFnp",(select case when eventdatavalues #>> '{YjTDrKjzjUh, value}' = 'true' then 1 when eventdatavalues #>> '{YjTDrKjzjUh, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "YjTDrKjzjUh",(select case when eventdatavalues #>> '{gG9y8G2inZO, value}' = 'true' then 1 when eventdatavalues #>> '{gG9y8G2inZO, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "gG9y8G2inZO",(select case when eventdatavalues #>> '{Fkpc9dsNjVV, value}' = 'true' then 1 when eventdatavalues #>> '{Fkpc9dsNjVV, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "Fkpc9dsNjVV",(select eventdatavalues #>> '{AGOF2yYdvHj, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "AGOF2yYdvHj",(select case when eventdatavalues #>> '{C1h6VNqwOC3, value}' = 'true' then 1 when eventdatavalues #>> '{C1h6VNqwOC3, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "C1h6VNqwOC3",(select case when eventdatavalues #>> '{jx6dZuKlZjT, value}' = 'true' then 1 when eventdatavalues #>> '{jx6dZuKlZjT, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "jx6dZuKlZjT",(select eventdatavalues #>> '{EFlkdjpm0hw, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "EFlkdjpm0hw",psi.uid,pi.uid,ps.uid,ao.uid,pi.enrollmentdate,pi.incidentdate,psi.executiondate,psi.duedate,psi.completeddate,psi.created,psi.lastupdated,pi.status,psi.status,psi.geometry,CASE WHEN 'POINT' = GeometryType(psi.geometry) THEN ST_X(psi.geometry) ELSE null END,CASE WHEN 'POINT' = GeometryType(psi.geometry) THEN ST_Y(psi.geometry) ELSE null END,ou.uid,ou.name,ou.code from programstageinstance psi inner join programinstance pi on psi.programinstanceid=pi.programinstanceid inner join programstage ps on psi.programstageid=ps.programstageid inner join program pr on pi.programid=pr.programid and pi.deleted is false inner join categoryoptioncombo ao on psi.attributeoptioncomboid=ao.categoryoptioncomboid left join trackedentityinstance tei on pi.trackedentityinstanceid=tei.trackedentityinstanceid and tei.deleted is false inner join organisationunit ou on psi.organisationunitid=ou.organisationunitid left join _orgunitstructure ous on psi.organisationunitid=ous.organisationunitid left join _organisationunitgroupsetstructure ougs on psi.organisationunitid=ougs.organisationunitid and (cast(date_trunc('month', psi.executiondate) as date)=ougs.startdate or ougs.startdate is null) inner join _categorystructure acs on psi.attributeoptioncomboid=acs.categoryoptioncomboid left join _dateperiodstructure dps on cast(psi.executiondate as date)=dps.dateperiod where psi.lastupdated < '2021-07-07T12:22:07' and psi.lastupdated >= '2021-07-06T00:14:09' and pr.programid=103424431 and psi.organisationunitid is not null and psi.executiondate is not null and psi.deleted is false ]; ERROR: date/time field value out of range: "0000-01-01"; nested exception is org.postgresql.util.PSQLException: ERROR: date/time field value out of range: "0000-01-01"
    at java.util.concurrent.FutureTask.report(FutureTask.java:122)
    at java.util.concurrent.FutureTask.get(FutureTask.java:192)
    at org.hisp.dhis.commons.util.ConcurrentUtils.waitForCompletion(ConcurrentUtils.java:57)
    ... 15 more
Caused by: org.springframework.dao.DataIntegrityViolationException: StatementCallback; SQL [insert into analytics_event_temp_fcg17cszswm_0 ("uidlevel1","uidlevel2","uidlevel3","uidlevel4","uidlevel5","uidlevel6","uidlevel7","uidlevel8","UOCVGT5pFb8","L78PtSgQ9hK","jpzvMY9zchJ","flod1BpeZpn","TWpLqJ9fEay","loEYmakRywD","uefNVIO6XHd","CH9nCUgbkn0","bYDNVZ4dDyq","mYo1OdNpe7B","rrmQnyX6CR3","jEmHPhfcznZ","t5Vb25H4Ld4","Dn3TvKMmRW2","iddhd4Zv29T","r4cXrdCPiK6","qcC7MoB5lZK","SUv2ytWYvYB","tbAGVEDuceX","KhF0NroJxnN","pYbRl3AUrtH","daily","weekly","weeklywednesday","weeklythursday","weeklysaturday","weeklysunday","biweekly","monthly","bimonthly","quarterly","sixmonthly","sixmonthlyapril","sixmonthlynov","yearly","financialapril","financialjuly","financialoct","financialnov","vhLREXkrIJS","TusePAOpoIs","AAaeOiqtONW","RhqVPUmGKlg","j2OId961SVu","HniOzDKFKRy","sF21TWc3jjD","sg9wqNbxonT","gZiBah1cxJL","h7iShQec76l","DHz7wUPwAqq","dJhrdgd6mqG","i5M3hVUNoTa","rSajAOLRz4d","rLJXDJKR2iZ","PCXMsdQfECN","U3SZgreH6Cq","LuUmtvGJMNN","WJAUMgILETw","LeIyYtQfh02","vwvQP8pVbVm","uu5obcfohEr","Jr6l3dZgD0D","nNMCNTblkTS","E6H8xGn1Dbt","Podr9dkZ1dM","txIrJG1iX4k","WulmkqvCSgG","C2mZj8xy186","fF4njAkbI7x","uE6G4GBVYdu","Ap91q7nHJSv","UFQs8yaBKpb","KxZAW9VsCDP","JUN4RtGATWq","n7ozbVAwH3V","wLu9eSHn0ga","MpQ6w0boP3Y","Nd37ZwZCIXI","VOS0tRHvZju","WrfrJhESJSw","qtkiHQdcs9N","QOtbuNC1EW9","V0TRtyOfde6","IV8UxuL6q7f","dOC7FnbSidv","y3vT9glyteD","EwX5bPPTgxW","qarF0snI3hT","N3YmEIoyfHm","XyNEDCO6HlL","l6p3rF8u68g","ujOGgL8BK2u","fNCDsWFtBz5","xgzq611f4Xn","KLPISLZrQJI","lRn9yETdEQZ","x7YVAFRmlOS","GtCF482duhv","KvO7C0RmC5h","ShaNUo8NIlu","YILWYLQmgQa","yayj7VDug5H","K0jCfidQXY4","WmkqxSERsb8","YZR1m5rxYzu","lsjx8mJCBkc","CCHujRxKxAO","MiIwYI5g79h","V9miEYsKXmm","wgDiBFsD7RC","EwSDIGnQW2f","q4EJDBDFUtP","uIMxi8QEtnB","aIzfji1fWbj","miTN72ZQZe8","UJ3NpQiHkSS","dLOnHV3cSHI","lg6wDWxQPpg","GDs5QDdE2nG","RUWJ65OE1Wt","W2iXxuW8EzR","CXKuKgyC8fs","hlSFLIAQXSL","I6LaG8DnSl1","W8izlRF3Pjj","ZENwfUnoSMP","lklZVCcDFcD","e8NiqL3qqr9","miv2k8RIVnC","PXmq2b0jqiu","Dk7Nf36OFnp","YjTDrKjzjUh","gG9y8G2inZO","Fkpc9dsNjVV","AGOF2yYdvHj","C1h6VNqwOC3","jx6dZuKlZjT","EFlkdjpm0hw","psi","pi","ps","ao","enrollmentdate","incidentdate","executiondate","duedate","completeddate","created","lastupdated","pistatus","psistatus","psigeometry","longitude","latitude","ou","ouname","oucode") select ous."uidlevel1",ous."uidlevel2",ous."uidlevel3",ous."uidlevel4",ous."uidlevel5",ous."uidlevel6",ous."uidlevel7",ous."uidlevel8",ougs."UOCVGT5pFb8",ougs."L78PtSgQ9hK",ougs."jpzvMY9zchJ",ougs."flod1BpeZpn",ougs."TWpLqJ9fEay",ougs."loEYmakRywD",ougs."uefNVIO6XHd",ougs."CH9nCUgbkn0",ougs."bYDNVZ4dDyq",ougs."mYo1OdNpe7B",ougs."rrmQnyX6CR3",ougs."jEmHPhfcznZ",ougs."t5Vb25H4Ld4",ougs."Dn3TvKMmRW2",ougs."iddhd4Zv29T",ougs."r4cXrdCPiK6",ougs."qcC7MoB5lZK",ougs."SUv2ytWYvYB",ougs."tbAGVEDuceX",ougs."KhF0NroJxnN",ougs."pYbRl3AUrtH",dps."daily",dps."weekly",dps."weeklywednesday",dps."weeklythursday",dps."weeklysaturday",dps."weeklysunday",dps."biweekly",dps."monthly",dps."bimonthly",dps."quarterly",dps."sixmonthly",dps."sixmonthlyapril",dps."sixmonthlynov",dps."yearly",dps."financialapril",dps."financialjuly",dps."financialoct",dps."financialnov",(select case when eventdatavalues #>> '{vhLREXkrIJS, value}' = 'true' then 1 when eventdatavalues #>> '{vhLREXkrIJS, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "vhLREXkrIJS",(select case when eventdatavalues #>> '{TusePAOpoIs, value}' = 'true' then 1 when eventdatavalues #>> '{TusePAOpoIs, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "TusePAOpoIs",(select eventdatavalues #>> '{AAaeOiqtONW, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "AAaeOiqtONW",(select case when eventdatavalues #>> '{RhqVPUmGKlg, value}' = 'true' then 1 when eventdatavalues #>> '{RhqVPUmGKlg, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "RhqVPUmGKlg",(select case when eventdatavalues #>> '{j2OId961SVu, value}' = 'true' then 1 when eventdatavalues #>> '{j2OId961SVu, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "j2OId961SVu",(select case when eventdatavalues #>> '{HniOzDKFKRy, value}' = 'true' then 1 when eventdatavalues #>> '{HniOzDKFKRy, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "HniOzDKFKRy",(select case when eventdatavalues #>> '{sF21TWc3jjD, value}' = 'true' then 1 when eventdatavalues #>> '{sF21TWc3jjD, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "sF21TWc3jjD",(select eventdatavalues #>> '{sg9wqNbxonT, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "sg9wqNbxonT",(select case when eventdatavalues #>> '{gZiBah1cxJL, value}' = 'true' then 1 when eventdatavalues #>> '{gZiBah1cxJL, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "gZiBah1cxJL",(select case when eventdatavalues #>> '{h7iShQec76l, value}' = 'true' then 1 when eventdatavalues #>> '{h7iShQec76l, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "h7iShQec76l",(select case when eventdatavalues #>> '{DHz7wUPwAqq, value}' = 'true' then 1 when eventdatavalues #>> '{DHz7wUPwAqq, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "DHz7wUPwAqq",(select cast(eventdatavalues #>> '{dJhrdgd6mqG, value}' as bigint) from programstageinstance where programstageinstanceid=psi.programstageinstanceid  and eventdatavalues #>> '{dJhrdgd6mqG,value}' ~* '^(-?[0-9]+)(\.[0-9]+)?$') as "dJhrdgd6mqG",(select eventdatavalues #>> '{i5M3hVUNoTa, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "i5M3hVUNoTa",(select case when eventdatavalues #>> '{rSajAOLRz4d, value}' = 'true' then 1 when eventdatavalues #>> '{rSajAOLRz4d, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "rSajAOLRz4d",(select eventdatavalues #>> '{rLJXDJKR2iZ, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "rLJXDJKR2iZ",(select case when eventdatavalues #>> '{PCXMsdQfECN, value}' = 'true' then 1 when eventdatavalues #>> '{PCXMsdQfECN, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "PCXMsdQfECN",(select case when eventdatavalues #>> '{U3SZgreH6Cq, value}' = 'true' then 1 when eventdatavalues #>> '{U3SZgreH6Cq, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "U3SZgreH6Cq",(select case when eventdatavalues #>> '{LuUmtvGJMNN, value}' = 'true' then 1 when eventdatavalues #>> '{LuUmtvGJMNN, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "LuUmtvGJMNN",(select case when eventdatavalues #>> '{WJAUMgILETw, value}' = 'true' then 1 when eventdatavalues #>> '{WJAUMgILETw, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "WJAUMgILETw",(select case when eventdatavalues #>> '{LeIyYtQfh02, value}' = 'true' then 1 when eventdatavalues #>> '{LeIyYtQfh02, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "LeIyYtQfh02",(select eventdatavalues #>> '{vwvQP8pVbVm, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "vwvQP8pVbVm",(select case when eventdatavalues #>> '{uu5obcfohEr, value}' = 'true' then 1 when eventdatavalues #>> '{uu5obcfohEr, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "uu5obcfohEr",(select case when eventdatavalues #>> '{Jr6l3dZgD0D, value}' = 'true' then 1 when eventdatavalues #>> '{Jr6l3dZgD0D, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "Jr6l3dZgD0D",(select case when eventdatavalues #>> '{nNMCNTblkTS, value}' = 'true' then 1 when eventdatavalues #>> '{nNMCNTblkTS, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "nNMCNTblkTS",(select case when eventdatavalues #>> '{E6H8xGn1Dbt, value}' = 'true' then 1 when eventdatavalues #>> '{E6H8xGn1Dbt, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "E6H8xGn1Dbt",(select case when eventdatavalues #>> '{Podr9dkZ1dM, value}' = 'true' then 1 when eventdatavalues #>> '{Podr9dkZ1dM, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "Podr9dkZ1dM",(select case when eventdatavalues #>> '{txIrJG1iX4k, value}' = 'true' then 1 when eventdatavalues #>> '{txIrJG1iX4k, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "txIrJG1iX4k",(select case when eventdatavalues #>> '{WulmkqvCSgG, value}' = 'true' then 1 when eventdatavalues #>> '{WulmkqvCSgG, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "WulmkqvCSgG",(select case when eventdatavalues #>> '{C2mZj8xy186, value}' = 'true' then 1 when eventdatavalues #>> '{C2mZj8xy186, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "C2mZj8xy186",(select case when eventdatavalues #>> '{fF4njAkbI7x, value}' = 'true' then 1 when eventdatavalues #>> '{fF4njAkbI7x, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "fF4njAkbI7x",(select cast(eventdatavalues #>> '{uE6G4GBVYdu, value}' as timestamp) from programstageinstance where programstageinstanceid=psi.programstageinstanceid  and eventdatavalues #>> '{uE6G4GBVYdu,value}' ~* '^\d{4}-\d{2}-\d{2}(\s|T)?((\d{2}:)(\d{2}:)?(\d{2}))?$') as "uE6G4GBVYdu",(select eventdatavalues #>> '{Ap91q7nHJSv, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "Ap91q7nHJSv",(select eventdatavalues #>> '{UFQs8yaBKpb, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "UFQs8yaBKpb",(select eventdatavalues #>> '{KxZAW9VsCDP, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "KxZAW9VsCDP",(select case when eventdatavalues #>> '{JUN4RtGATWq, value}' = 'true' then 1 when eventdatavalues #>> '{JUN4RtGATWq, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "JUN4RtGATWq",(select case when eventdatavalues #>> '{n7ozbVAwH3V, value}' = 'true' then 1 when eventdatavalues #>> '{n7ozbVAwH3V, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "n7ozbVAwH3V",(select eventdatavalues #>> '{wLu9eSHn0ga, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "wLu9eSHn0ga",(select case when eventdatavalues #>> '{MpQ6w0boP3Y, value}' = 'true' then 1 when eventdatavalues #>> '{MpQ6w0boP3Y, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "MpQ6w0boP3Y",(select case when eventdatavalues #>> '{Nd37ZwZCIXI, value}' = 'true' then 1 when eventdatavalues #>> '{Nd37ZwZCIXI, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "Nd37ZwZCIXI",(select case when eventdatavalues #>> '{VOS0tRHvZju, value}' = 'true' then 1 when eventdatavalues #>> '{VOS0tRHvZju, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "VOS0tRHvZju",(select eventdatavalues #>> '{WrfrJhESJSw, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "WrfrJhESJSw",(select case when eventdatavalues #>> '{qtkiHQdcs9N, value}' = 'true' then 1 when eventdatavalues #>> '{qtkiHQdcs9N, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "qtkiHQdcs9N",(select case when eventdatavalues #>> '{QOtbuNC1EW9, value}' = 'true' then 1 when eventdatavalues #>> '{QOtbuNC1EW9, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "QOtbuNC1EW9",(select case when eventdatavalues #>> '{V0TRtyOfde6, value}' = 'true' then 1 when eventdatavalues #>> '{V0TRtyOfde6, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "V0TRtyOfde6",(select eventdatavalues #>> '{IV8UxuL6q7f, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "IV8UxuL6q7f",(select case when eventdatavalues #>> '{dOC7FnbSidv, value}' = 'true' then 1 when eventdatavalues #>> '{dOC7FnbSidv, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "dOC7FnbSidv",(select case when eventdatavalues #>> '{y3vT9glyteD, value}' = 'true' then 1 when eventdatavalues #>> '{y3vT9glyteD, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "y3vT9glyteD",(select eventdatavalues #>> '{EwX5bPPTgxW, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "EwX5bPPTgxW",(select eventdatavalues #>> '{qarF0snI3hT, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "qarF0snI3hT",(select eventdatavalues #>> '{N3YmEIoyfHm, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "N3YmEIoyfHm",(select case when eventdatavalues #>> '{XyNEDCO6HlL, value}' = 'true' then 1 when eventdatavalues #>> '{XyNEDCO6HlL, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "XyNEDCO6HlL",(select case when eventdatavalues #>> '{l6p3rF8u68g, value}' = 'true' then 1 when eventdatavalues #>> '{l6p3rF8u68g, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "l6p3rF8u68g",(select eventdatavalues #>> '{ujOGgL8BK2u, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "ujOGgL8BK2u",(select case when eventdatavalues #>> '{fNCDsWFtBz5, value}' = 'true' then 1 when eventdatavalues #>> '{fNCDsWFtBz5, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "fNCDsWFtBz5",(select eventdatavalues #>> '{xgzq611f4Xn, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "xgzq611f4Xn",(select case when eventdatavalues #>> '{KLPISLZrQJI, value}' = 'true' then 1 when eventdatavalues #>> '{KLPISLZrQJI, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "KLPISLZrQJI",(select eventdatavalues #>> '{lRn9yETdEQZ, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "lRn9yETdEQZ",(select eventdatavalues #>> '{x7YVAFRmlOS, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "x7YVAFRmlOS",(select case when eventdatavalues #>> '{GtCF482duhv, value}' = 'true' then 1 when eventdatavalues #>> '{GtCF482duhv, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "GtCF482duhv",(select eventdatavalues #>> '{KvO7C0RmC5h, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "KvO7C0RmC5h",(select eventdatavalues #>> '{ShaNUo8NIlu, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "ShaNUo8NIlu",(select eventdatavalues #>> '{YILWYLQmgQa, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "YILWYLQmgQa",(select case when eventdatavalues #>> '{yayj7VDug5H, value}' = 'true' then 1 when eventdatavalues #>> '{yayj7VDug5H, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "yayj7VDug5H",(select eventdatavalues #>> '{K0jCfidQXY4, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "K0jCfidQXY4",(select case when eventdatavalues #>> '{WmkqxSERsb8, value}' = 'true' then 1 when eventdatavalues #>> '{WmkqxSERsb8, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "WmkqxSERsb8",(select case when eventdatavalues #>> '{YZR1m5rxYzu, value}' = 'true' then 1 when eventdatavalues #>> '{YZR1m5rxYzu, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "YZR1m5rxYzu",(select eventdatavalues #>> '{lsjx8mJCBkc, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "lsjx8mJCBkc",(select case when eventdatavalues #>> '{CCHujRxKxAO, value}' = 'true' then 1 when eventdatavalues #>> '{CCHujRxKxAO, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "CCHujRxKxAO",(select cast(eventdatavalues #>> '{MiIwYI5g79h, value}' as timestamp) from programstageinstance where programstageinstanceid=psi.programstageinstanceid  and eventdatavalues #>> '{MiIwYI5g79h,value}' ~* '^\d{4}-\d{2}-\d{2}(\s|T)?((\d{2}:)(\d{2}:)?(\d{2}))?$') as "MiIwYI5g79h",(select eventdatavalues #>> '{V9miEYsKXmm, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "V9miEYsKXmm",(select case when eventdatavalues #>> '{wgDiBFsD7RC, value}' = 'true' then 1 when eventdatavalues #>> '{wgDiBFsD7RC, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "wgDiBFsD7RC",(select case when eventdatavalues #>> '{EwSDIGnQW2f, value}' = 'true' then 1 when eventdatavalues #>> '{EwSDIGnQW2f, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "EwSDIGnQW2f",(select cast(eventdatavalues #>> '{q4EJDBDFUtP, value}' as bigint) from programstageinstance where programstageinstanceid=psi.programstageinstanceid  and eventdatavalues #>> '{q4EJDBDFUtP,value}' ~* '^(-?[0-9]+)(\.[0-9]+)?$') as "q4EJDBDFUtP",(select case when eventdatavalues #>> '{uIMxi8QEtnB, value}' = 'true' then 1 when eventdatavalues #>> '{uIMxi8QEtnB, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "uIMxi8QEtnB",(select eventdatavalues #>> '{aIzfji1fWbj, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "aIzfji1fWbj",(select eventdatavalues #>> '{miTN72ZQZe8, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "miTN72ZQZe8",(select case when eventdatavalues #>> '{UJ3NpQiHkSS, value}' = 'true' then 1 when eventdatavalues #>> '{UJ3NpQiHkSS, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "UJ3NpQiHkSS",(select eventdatavalues #>> '{dLOnHV3cSHI, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "dLOnHV3cSHI",(select case when eventdatavalues #>> '{lg6wDWxQPpg, value}' = 'true' then 1 when eventdatavalues #>> '{lg6wDWxQPpg, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "lg6wDWxQPpg",(select eventdatavalues #>> '{GDs5QDdE2nG, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "GDs5QDdE2nG",(select case when eventdatavalues #>> '{RUWJ65OE1Wt, value}' = 'true' then 1 when eventdatavalues #>> '{RUWJ65OE1Wt, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "RUWJ65OE1Wt",(select eventdatavalues #>> '{W2iXxuW8EzR, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "W2iXxuW8EzR",(select eventdatavalues #>> '{CXKuKgyC8fs, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "CXKuKgyC8fs",(select cast(eventdatavalues #>> '{hlSFLIAQXSL, value}' as double precision) from programstageinstance where programstageinstanceid=psi.programstageinstanceid  and eventdatavalues #>> '{hlSFLIAQXSL,value}' ~* '^(-?[0-9]+)(\.[0-9]+)?$') as "hlSFLIAQXSL",(select case when eventdatavalues #>> '{I6LaG8DnSl1, value}' = 'true' then 1 when eventdatavalues #>> '{I6LaG8DnSl1, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "I6LaG8DnSl1",(select case when eventdatavalues #>> '{W8izlRF3Pjj, value}' = 'true' then 1 when eventdatavalues #>> '{W8izlRF3Pjj, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "W8izlRF3Pjj",(select eventdatavalues #>> '{ZENwfUnoSMP, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "ZENwfUnoSMP",(select case when eventdatavalues #>> '{lklZVCcDFcD, value}' = 'true' then 1 when eventdatavalues #>> '{lklZVCcDFcD, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "lklZVCcDFcD",(select case when eventdatavalues #>> '{e8NiqL3qqr9, value}' = 'true' then 1 when eventdatavalues #>> '{e8NiqL3qqr9, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "e8NiqL3qqr9",(select eventdatavalues #>> '{miv2k8RIVnC, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "miv2k8RIVnC",(select case when eventdatavalues #>> '{PXmq2b0jqiu, value}' = 'true' then 1 when eventdatavalues #>> '{PXmq2b0jqiu, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "PXmq2b0jqiu",(select case when eventdatavalues #>> '{Dk7Nf36OFnp, value}' = 'true' then 1 when eventdatavalues #>> '{Dk7Nf36OFnp, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "Dk7Nf36OFnp",(select case when eventdatavalues #>> '{YjTDrKjzjUh, value}' = 'true' then 1 when eventdatavalues #>> '{YjTDrKjzjUh, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "YjTDrKjzjUh",(select case when eventdatavalues #>> '{gG9y8G2inZO, value}' = 'true' then 1 when eventdatavalues #>> '{gG9y8G2inZO, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "gG9y8G2inZO",(select case when eventdatavalues #>> '{Fkpc9dsNjVV, value}' = 'true' then 1 when eventdatavalues #>> '{Fkpc9dsNjVV, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "Fkpc9dsNjVV",(select eventdatavalues #>> '{AGOF2yYdvHj, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "AGOF2yYdvHj",(select case when eventdatavalues #>> '{C1h6VNqwOC3, value}' = 'true' then 1 when eventdatavalues #>> '{C1h6VNqwOC3, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "C1h6VNqwOC3",(select case when eventdatavalues #>> '{jx6dZuKlZjT, value}' = 'true' then 1 when eventdatavalues #>> '{jx6dZuKlZjT, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "jx6dZuKlZjT",(select eventdatavalues #>> '{EFlkdjpm0hw, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "EFlkdjpm0hw",psi.uid,pi.uid,ps.uid,ao.uid,pi.enrollmentdate,pi.incidentdate,psi.executiondate,psi.duedate,psi.completeddate,psi.created,psi.lastupdated,pi.status,psi.status,psi.geometry,CASE WHEN 'POINT' = GeometryType(psi.geometry) THEN ST_X(psi.geometry) ELSE null END,CASE WHEN 'POINT' = GeometryType(psi.geometry) THEN ST_Y(psi.geometry) ELSE null END,ou.uid,ou.name,ou.code from programstageinstance psi inner join programinstance pi on psi.programinstanceid=pi.programinstanceid inner join programstage ps on psi.programstageid=ps.programstageid inner join program pr on pi.programid=pr.programid and pi.deleted is false inner join categoryoptioncombo ao on psi.attributeoptioncomboid=ao.categoryoptioncomboid left join trackedentityinstance tei on pi.trackedentityinstanceid=tei.trackedentityinstanceid and tei.deleted is false inner join organisationunit ou on psi.organisationunitid=ou.organisationunitid left join _orgunitstructure ous on psi.organisationunitid=ous.organisationunitid left join _organisationunitgroupsetstructure ougs on psi.organisationunitid=ougs.organisationunitid and (cast(date_trunc('month', psi.executiondate) as date)=ougs.startdate or ougs.startdate is null) inner join _categorystructure acs on psi.attributeoptioncomboid=acs.categoryoptioncomboid left join _dateperiodstructure dps on cast(psi.executiondate as date)=dps.dateperiod where psi.lastupdated < '2021-07-07T12:22:07' and psi.lastupdated >= '2021-07-06T00:14:09' and pr.programid=103424431 and psi.organisationunitid is not null and psi.executiondate is not null and psi.deleted is false ]; ERROR: date/time field value out of range: "0000-01-01"; nested exception is org.postgresql.util.PSQLException: ERROR: date/time field value out of range: "0000-01-01"
    at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:104)
    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
    at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1443)
    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:388)
    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:418)
    at org.hisp.dhis.analytics.table.AbstractJdbcTableManager.invokeTimeAndLog(AbstractJdbcTableManager.java:556)
    at org.hisp.dhis.analytics.table.AbstractEventJdbcTableManager.populateTableInternal(AbstractEventJdbcTableManager.java:192)
    at org.hisp.dhis.analytics.table.JdbcEventAnalyticsTableManager.populateTable(JdbcEventAnalyticsTableManager.java:323)
    at org.hisp.dhis.analytics.table.AbstractJdbcTableManager.populateTablesAsync(AbstractJdbcTableManager.java:278)
    at sun.reflect.GeneratedMethodAccessor4021.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
    at org.springframework.aop.interceptor.AsyncExecutionInterceptor.lambda$invoke$0(AsyncExecutionInterceptor.java:115)
    at java.util.concurrent.FutureTask.run(FutureTask.java:266)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
    ... 3 more
Caused by: org.postgresql.util.PSQLException: ERROR: date/time field value out of range: "0000-01-01"
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
    at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
    at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
    at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
    at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
    at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
    at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:266)
    at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:75)
    at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:409)
    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376)
    ... 18 more
 (DefaultAnalyticsTableGenerator.java [taskScheduler-18])
java.lang.RuntimeException: Exception during execution
    at org.hisp.dhis.commons.util.ConcurrentUtils.waitForCompletion(ConcurrentUtils.java:61) ~[dhis-support-commons-2.34.5.jar:?]
    at org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.populateTables(DefaultAnalyticsTableService.java:276) ~[dhis-service-analytics-2.34.5.jar:?]
    at org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.update(DefaultAnalyticsTableService.java:166) ~[dhis-service-analytics-2.34.5.jar:?]
    at org.hisp.dhis.analytics.table.DefaultAnalyticsTableGenerator.generateTables(DefaultAnalyticsTableGenerator.java:137) ~[dhis-service-analytics-2.34.5.jar:?]
    at org.hisp.dhis.analytics.table.scheduling.ContinuousAnalyticsTableJob.execute(ContinuousAnalyticsTableJob.java:133) ~[dhis-service-analytics-2.34.5.jar:?]
    at org.hisp.dhis.scheduling.DefaultJobInstance.executeJob(DefaultJobInstance.java:173) ~[dhis-service-core-2.34.5.jar:?]
    at org.hisp.dhis.scheduling.DefaultJobInstance.execute(DefaultJobInstance.java:103) ~[dhis-service-core-2.34.5.jar:?]
    at org.hisp.dhis.scheduling.DefaultSchedulingManager.lambda$scheduleJob$2(DefaultSchedulingManager.java:193) ~[dhis-service-core-2.34.5.jar:?]
    at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) [spring-context-5.2.4.RELEASE.jar:5.2.4.RELEASE]
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [?:1.8.0_262]
    at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) [?:1.8.0_262]
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) [?:1.8.0_262]
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) [?:1.8.0_262]
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_262]
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_262]
    at java.lang.Thread.run(Thread.java:748) [?:1.8.0_262]
Caused by: java.util.concurrent.ExecutionException: org.springframework.dao.DataIntegrityViolationException: StatementCallback; SQL [insert into analytics_event_temp_fcg17cszswm_0 ("uidlevel1","uidlevel2","uidlevel3","uidlevel4","uidlevel5","uidlevel6","uidlevel7","uidlevel8","UOCVGT5pFb8","L78PtSgQ9hK","jpzvMY9zchJ","flod1BpeZpn","TWpLqJ9fEay","loEYmakRywD","uefNVIO6XHd","CH9nCUgbkn0","bYDNVZ4dDyq","mYo1OdNpe7B","rrmQnyX6CR3","jEmHPhfcznZ","t5Vb25H4Ld4","Dn3TvKMmRW2","iddhd4Zv29T","r4cXrdCPiK6","qcC7MoB5lZK","SUv2ytWYvYB","tbAGVEDuceX","KhF0NroJxnN","pYbRl3AUrtH","daily","weekly","weeklywednesday","weeklythursday","weeklysaturday","weeklysunday","biweekly","monthly","bimonthly","quarterly","sixmonthly","sixmonthlyapril","sixmonthlynov","yearly","financialapril","financialjuly","financialoct","financialnov","vhLREXkrIJS","TusePAOpoIs","AAaeOiqtONW","RhqVPUmGKlg","j2OId961SVu","HniOzDKFKRy","sF21TWc3jjD","sg9wqNbxonT","gZiBah1cxJL","h7iShQec76l","DHz7wUPwAqq","dJhrdgd6mqG","i5M3hVUNoTa","rSajAOLRz4d","rLJXDJKR2iZ","PCXMsdQfECN","U3SZgreH6Cq","LuUmtvGJMNN","WJAUMgILETw","LeIyYtQfh02","vwvQP8pVbVm","uu5obcfohEr","Jr6l3dZgD0D","nNMCNTblkTS","E6H8xGn1Dbt","Podr9dkZ1dM","txIrJG1iX4k","WulmkqvCSgG","C2mZj8xy186","fF4njAkbI7x","uE6G4GBVYdu","Ap91q7nHJSv","UFQs8yaBKpb","KxZAW9VsCDP","JUN4RtGATWq","n7ozbVAwH3V","wLu9eSHn0ga","MpQ6w0boP3Y","Nd37ZwZCIXI","VOS0tRHvZju","WrfrJhESJSw","qtkiHQdcs9N","QOtbuNC1EW9","V0TRtyOfde6","IV8UxuL6q7f","dOC7FnbSidv","y3vT9glyteD","EwX5bPPTgxW","qarF0snI3hT","N3YmEIoyfHm","XyNEDCO6HlL","l6p3rF8u68g","ujOGgL8BK2u","fNCDsWFtBz5","xgzq611f4Xn","KLPISLZrQJI","lRn9yETdEQZ","x7YVAFRmlOS","GtCF482duhv","KvO7C0RmC5h","ShaNUo8NIlu","YILWYLQmgQa","yayj7VDug5H","K0jCfidQXY4","WmkqxSERsb8","YZR1m5rxYzu","lsjx8mJCBkc","CCHujRxKxAO","MiIwYI5g79h","V9miEYsKXmm","wgDiBFsD7RC","EwSDIGnQW2f","q4EJDBDFUtP","uIMxi8QEtnB","aIzfji1fWbj","miTN72ZQZe8","UJ3NpQiHkSS","dLOnHV3cSHI","lg6wDWxQPpg","GDs5QDdE2nG","RUWJ65OE1Wt","W2iXxuW8EzR","CXKuKgyC8fs","hlSFLIAQXSL","I6LaG8DnSl1","W8izlRF3Pjj","ZENwfUnoSMP","lklZVCcDFcD","e8NiqL3qqr9","miv2k8RIVnC","PXmq2b0jqiu","Dk7Nf36OFnp","YjTDrKjzjUh","gG9y8G2inZO","Fkpc9dsNjVV","AGOF2yYdvHj","C1h6VNqwOC3","jx6dZuKlZjT","EFlkdjpm0hw","psi","pi","ps","ao","enrollmentdate","incidentdate","executiondate","duedate","completeddate","created","lastupdated","pistatus","psistatus","psigeometry","longitude","latitude","ou","ouname","oucode") select ous."uidlevel1",ous."uidlevel2",ous."uidlevel3",ous."uidlevel4",ous."uidlevel5",ous."uidlevel6",ous."uidlevel7",ous."uidlevel8",ougs."UOCVGT5pFb8",ougs."L78PtSgQ9hK",ougs."jpzvMY9zchJ",ougs."flod1BpeZpn",ougs."TWpLqJ9fEay",ougs."loEYmakRywD",ougs."uefNVIO6XHd",ougs."CH9nCUgbkn0",ougs."bYDNVZ4dDyq",ougs."mYo1OdNpe7B",ougs."rrmQnyX6CR3",ougs."jEmHPhfcznZ",ougs."t5Vb25H4Ld4",ougs."Dn3TvKMmRW2",ougs."iddhd4Zv29T",ougs."r4cXrdCPiK6",ougs."qcC7MoB5lZK",ougs."SUv2ytWYvYB",ougs."tbAGVEDuceX",ougs."KhF0NroJxnN",ougs."pYbRl3AUrtH",dps."daily",dps."weekly",dps."weeklywednesday",dps."weeklythursday",dps."weeklysaturday",dps."weeklysunday",dps."biweekly",dps."monthly",dps."bimonthly",dps."quarterly",dps."sixmonthly",dps."sixmonthlyapril",dps."sixmonthlynov",dps."yearly",dps."financialapril",dps."financialjuly",dps."financialoct",dps."financialnov",(select case when eventdatavalues #>> '{vhLREXkrIJS, value}' = 'true' then 1 when eventdatavalues #>> '{vhLREXkrIJS, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "vhLREXkrIJS",(select case when eventdatavalues #>> '{TusePAOpoIs, value}' = 'true' then 1 when eventdatavalues #>> '{TusePAOpoIs, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "TusePAOpoIs",(select eventdatavalues #>> '{AAaeOiqtONW, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "AAaeOiqtONW",(select case when eventdatavalues #>> '{RhqVPUmGKlg, value}' = 'true' then 1 when eventdatavalues #>> '{RhqVPUmGKlg, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "RhqVPUmGKlg",(select case when eventdatavalues #>> '{j2OId961SVu, value}' = 'true' then 1 when eventdatavalues #>> '{j2OId961SVu, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "j2OId961SVu",(select case when eventdatavalues #>> '{HniOzDKFKRy, value}' = 'true' then 1 when eventdatavalues #>> '{HniOzDKFKRy, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "HniOzDKFKRy",(select case when eventdatavalues #>> '{sF21TWc3jjD, value}' = 'true' then 1 when eventdatavalues #>> '{sF21TWc3jjD, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "sF21TWc3jjD",(select eventdatavalues #>> '{sg9wqNbxonT, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "sg9wqNbxonT",(select case when eventdatavalues #>> '{gZiBah1cxJL, value}' = 'true' then 1 when eventdatavalues #>> '{gZiBah1cxJL, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "gZiBah1cxJL",(select case when eventdatavalues #>> '{h7iShQec76l, value}' = 'true' then 1 when eventdatavalues #>> '{h7iShQec76l, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "h7iShQec76l",(select case when eventdatavalues #>> '{DHz7wUPwAqq, value}' = 'true' then 1 when eventdatavalues #>> '{DHz7wUPwAqq, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "DHz7wUPwAqq",(select cast(eventdatavalues #>> '{dJhrdgd6mqG, value}' as bigint) from programstageinstance where programstageinstanceid=psi.programstageinstanceid  and eventdatavalues #>> '{dJhrdgd6mqG,value}' ~* '^(-?[0-9]+)(\.[0-9]+)?$') as "dJhrdgd6mqG",(select eventdatavalues #>> '{i5M3hVUNoTa, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "i5M3hVUNoTa",(select case when eventdatavalues #>> '{rSajAOLRz4d, value}' = 'true' then 1 when eventdatavalues #>> '{rSajAOLRz4d, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "rSajAOLRz4d",(select eventdatavalues #>> '{rLJXDJKR2iZ, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "rLJXDJKR2iZ",(select case when eventdatavalues #>> '{PCXMsdQfECN, value}' = 'true' then 1 when eventdatavalues #>> '{PCXMsdQfECN, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "PCXMsdQfECN",(select case when eventdatavalues #>> '{U3SZgreH6Cq, value}' = 'true' then 1 when eventdatavalues #>> '{U3SZgreH6Cq, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "U3SZgreH6Cq",(select case when eventdatavalues #>> '{LuUmtvGJMNN, value}' = 'true' then 1 when eventdatavalues #>> '{LuUmtvGJMNN, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "LuUmtvGJMNN",(select case when eventdatavalues #>> '{WJAUMgILETw, value}' = 'true' then 1 when eventdatavalues #>> '{WJAUMgILETw, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "WJAUMgILETw",(select case when eventdatavalues #>> '{LeIyYtQfh02, value}' = 'true' then 1 when eventdatavalues #>> '{LeIyYtQfh02, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "LeIyYtQfh02",(select eventdatavalues #>> '{vwvQP8pVbVm, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "vwvQP8pVbVm",(select case when eventdatavalues #>> '{uu5obcfohEr, value}' = 'true' then 1 when eventdatavalues #>> '{uu5obcfohEr, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "uu5obcfohEr",(select case when eventdatavalues #>> '{Jr6l3dZgD0D, value}' = 'true' then 1 when eventdatavalues #>> '{Jr6l3dZgD0D, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "Jr6l3dZgD0D",(select case when eventdatavalues #>> '{nNMCNTblkTS, value}' = 'true' then 1 when eventdatavalues #>> '{nNMCNTblkTS, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "nNMCNTblkTS",(select case when eventdatavalues #>> '{E6H8xGn1Dbt, value}' = 'true' then 1 when eventdatavalues #>> '{E6H8xGn1Dbt, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "E6H8xGn1Dbt",(select case when eventdatavalues #>> '{Podr9dkZ1dM, value}' = 'true' then 1 when eventdatavalues #>> '{Podr9dkZ1dM, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "Podr9dkZ1dM",(select case when eventdatavalues #>> '{txIrJG1iX4k, value}' = 'true' then 1 when eventdatavalues #>> '{txIrJG1iX4k, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "txIrJG1iX4k",(select case when eventdatavalues #>> '{WulmkqvCSgG, value}' = 'true' then 1 when eventdatavalues #>> '{WulmkqvCSgG, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "WulmkqvCSgG",(select case when eventdatavalues #>> '{C2mZj8xy186, value}' = 'true' then 1 when eventdatavalues #>> '{C2mZj8xy186, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "C2mZj8xy186",(select case when eventdatavalues #>> '{fF4njAkbI7x, value}' = 'true' then 1 when eventdatavalues #>> '{fF4njAkbI7x, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "fF4njAkbI7x",(select cast(eventdatavalues #>> '{uE6G4GBVYdu, value}' as timestamp) from programstageinstance where programstageinstanceid=psi.programstageinstanceid  and eventdatavalues #>> '{uE6G4GBVYdu,value}' ~* '^\d{4}-\d{2}-\d{2}(\s|T)?((\d{2}:)(\d{2}:)?(\d{2}))?$') as "uE6G4GBVYdu",(select eventdatavalues #>> '{Ap91q7nHJSv, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "Ap91q7nHJSv",(select eventdatavalues #>> '{UFQs8yaBKpb, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "UFQs8yaBKpb",(select eventdatavalues #>> '{KxZAW9VsCDP, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "KxZAW9VsCDP",(select case when eventdatavalues #>> '{JUN4RtGATWq, value}' = 'true' then 1 when eventdatavalues #>> '{JUN4RtGATWq, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "JUN4RtGATWq",(select case when eventdatavalues #>> '{n7ozbVAwH3V, value}' = 'true' then 1 when eventdatavalues #>> '{n7ozbVAwH3V, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "n7ozbVAwH3V",(select eventdatavalues #>> '{wLu9eSHn0ga, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "wLu9eSHn0ga",(select case when eventdatavalues #>> '{MpQ6w0boP3Y, value}' = 'true' then 1 when eventdatavalues #>> '{MpQ6w0boP3Y, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "MpQ6w0boP3Y",(select case when eventdatavalues #>> '{Nd37ZwZCIXI, value}' = 'true' then 1 when eventdatavalues #>> '{Nd37ZwZCIXI, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "Nd37ZwZCIXI",(select case when eventdatavalues #>> '{VOS0tRHvZju, value}' = 'true' then 1 when eventdatavalues #>> '{VOS0tRHvZju, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "VOS0tRHvZju",(select eventdatavalues #>> '{WrfrJhESJSw, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "WrfrJhESJSw",(select case when eventdatavalues #>> '{qtkiHQdcs9N, value}' = 'true' then 1 when eventdatavalues #>> '{qtkiHQdcs9N, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "qtkiHQdcs9N",(select case when eventdatavalues #>> '{QOtbuNC1EW9, value}' = 'true' then 1 when eventdatavalues #>> '{QOtbuNC1EW9, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "QOtbuNC1EW9",(select case when eventdatavalues #>> '{V0TRtyOfde6, value}' = 'true' then 1 when eventdatavalues #>> '{V0TRtyOfde6, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "V0TRtyOfde6",(select eventdatavalues #>> '{IV8UxuL6q7f, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "IV8UxuL6q7f",(select case when eventdatavalues #>> '{dOC7FnbSidv, value}' = 'true' then 1 when eventdatavalues #>> '{dOC7FnbSidv, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "dOC7FnbSidv",(select case when eventdatavalues #>> '{y3vT9glyteD, value}' = 'true' then 1 when eventdatavalues #>> '{y3vT9glyteD, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "y3vT9glyteD",(select eventdatavalues #>> '{EwX5bPPTgxW, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "EwX5bPPTgxW",(select eventdatavalues #>> '{qarF0snI3hT, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "qarF0snI3hT",(select eventdatavalues #>> '{N3YmEIoyfHm, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "N3YmEIoyfHm",(select case when eventdatavalues #>> '{XyNEDCO6HlL, value}' = 'true' then 1 when eventdatavalues #>> '{XyNEDCO6HlL, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "XyNEDCO6HlL",(select case when eventdatavalues #>> '{l6p3rF8u68g, value}' = 'true' then 1 when eventdatavalues #>> '{l6p3rF8u68g, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "l6p3rF8u68g",(select eventdatavalues #>> '{ujOGgL8BK2u, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "ujOGgL8BK2u",(select case when eventdatavalues #>> '{fNCDsWFtBz5, value}' = 'true' then 1 when eventdatavalues #>> '{fNCDsWFtBz5, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "fNCDsWFtBz5",(select eventdatavalues #>> '{xgzq611f4Xn, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "xgzq611f4Xn",(select case when eventdatavalues #>> '{KLPISLZrQJI, value}' = 'true' then 1 when eventdatavalues #>> '{KLPISLZrQJI, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "KLPISLZrQJI",(select eventdatavalues #>> '{lRn9yETdEQZ, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "lRn9yETdEQZ",(select eventdatavalues #>> '{x7YVAFRmlOS, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "x7YVAFRmlOS",(select case when eventdatavalues #>> '{GtCF482duhv, value}' = 'true' then 1 when eventdatavalues #>> '{GtCF482duhv, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "GtCF482duhv",(select eventdatavalues #>> '{KvO7C0RmC5h, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "KvO7C0RmC5h",(select eventdatavalues #>> '{ShaNUo8NIlu, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "ShaNUo8NIlu",(select eventdatavalues #>> '{YILWYLQmgQa, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "YILWYLQmgQa",(select case when eventdatavalues #>> '{yayj7VDug5H, value}' = 'true' then 1 when eventdatavalues #>> '{yayj7VDug5H, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "yayj7VDug5H",(select eventdatavalues #>> '{K0jCfidQXY4, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "K0jCfidQXY4",(select case when eventdatavalues #>> '{WmkqxSERsb8, value}' = 'true' then 1 when eventdatavalues #>> '{WmkqxSERsb8, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "WmkqxSERsb8",(select case when eventdatavalues #>> '{YZR1m5rxYzu, value}' = 'true' then 1 when eventdatavalues #>> '{YZR1m5rxYzu, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "YZR1m5rxYzu",(select eventdatavalues #>> '{lsjx8mJCBkc, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "lsjx8mJCBkc",(select case when eventdatavalues #>> '{CCHujRxKxAO, value}' = 'true' then 1 when eventdatavalues #>> '{CCHujRxKxAO, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "CCHujRxKxAO",(select cast(eventdatavalues #>> '{MiIwYI5g79h, value}' as timestamp) from programstageinstance where programstageinstanceid=psi.programstageinstanceid  and eventdatavalues #>> '{MiIwYI5g79h,value}' ~* '^\d{4}-\d{2}-\d{2}(\s|T)?((\d{2}:)(\d{2}:)?(\d{2}))?$') as "MiIwYI5g79h",(select eventdatavalues #>> '{V9miEYsKXmm, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "V9miEYsKXmm",(select case when eventdatavalues #>> '{wgDiBFsD7RC, value}' = 'true' then 1 when eventdatavalues #>> '{wgDiBFsD7RC, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "wgDiBFsD7RC",(select case when eventdatavalues #>> '{EwSDIGnQW2f, value}' = 'true' then 1 when eventdatavalues #>> '{EwSDIGnQW2f, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "EwSDIGnQW2f",(select cast(eventdatavalues #>> '{q4EJDBDFUtP, value}' as bigint) from programstageinstance where programstageinstanceid=psi.programstageinstanceid  and eventdatavalues #>> '{q4EJDBDFUtP,value}' ~* '^(-?[0-9]+)(\.[0-9]+)?$') as "q4EJDBDFUtP",(select case when eventdatavalues #>> '{uIMxi8QEtnB, value}' = 'true' then 1 when eventdatavalues #>> '{uIMxi8QEtnB, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "uIMxi8QEtnB",(select eventdatavalues #>> '{aIzfji1fWbj, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "aIzfji1fWbj",(select eventdatavalues #>> '{miTN72ZQZe8, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "miTN72ZQZe8",(select case when eventdatavalues #>> '{UJ3NpQiHkSS, value}' = 'true' then 1 when eventdatavalues #>> '{UJ3NpQiHkSS, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "UJ3NpQiHkSS",(select eventdatavalues #>> '{dLOnHV3cSHI, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "dLOnHV3cSHI",(select case when eventdatavalues #>> '{lg6wDWxQPpg, value}' = 'true' then 1 when eventdatavalues #>> '{lg6wDWxQPpg, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "lg6wDWxQPpg",(select eventdatavalues #>> '{GDs5QDdE2nG, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "GDs5QDdE2nG",(select case when eventdatavalues #>> '{RUWJ65OE1Wt, value}' = 'true' then 1 when eventdatavalues #>> '{RUWJ65OE1Wt, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "RUWJ65OE1Wt",(select eventdatavalues #>> '{W2iXxuW8EzR, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "W2iXxuW8EzR",(select eventdatavalues #>> '{CXKuKgyC8fs, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "CXKuKgyC8fs",(select cast(eventdatavalues #>> '{hlSFLIAQXSL, value}' as double precision) from programstageinstance where programstageinstanceid=psi.programstageinstanceid  and eventdatavalues #>> '{hlSFLIAQXSL,value}' ~* '^(-?[0-9]+)(\.[0-9]+)?$') as "hlSFLIAQXSL",(select case when eventdatavalues #>> '{I6LaG8DnSl1, value}' = 'true' then 1 when eventdatavalues #>> '{I6LaG8DnSl1, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "I6LaG8DnSl1",(select case when eventdatavalues #>> '{W8izlRF3Pjj, value}' = 'true' then 1 when eventdatavalues #>> '{W8izlRF3Pjj, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "W8izlRF3Pjj",(select eventdatavalues #>> '{ZENwfUnoSMP, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "ZENwfUnoSMP",(select case when eventdatavalues #>> '{lklZVCcDFcD, value}' = 'true' then 1 when eventdatavalues #>> '{lklZVCcDFcD, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "lklZVCcDFcD",(select case when eventdatavalues #>> '{e8NiqL3qqr9, value}' = 'true' then 1 when eventdatavalues #>> '{e8NiqL3qqr9, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "e8NiqL3qqr9",(select eventdatavalues #>> '{miv2k8RIVnC, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "miv2k8RIVnC",(select case when eventdatavalues #>> '{PXmq2b0jqiu, value}' = 'true' then 1 when eventdatavalues #>> '{PXmq2b0jqiu, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "PXmq2b0jqiu",(select case when eventdatavalues #>> '{Dk7Nf36OFnp, value}' = 'true' then 1 when eventdatavalues #>> '{Dk7Nf36OFnp, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "Dk7Nf36OFnp",(select case when eventdatavalues #>> '{YjTDrKjzjUh, value}' = 'true' then 1 when eventdatavalues #>> '{YjTDrKjzjUh, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "YjTDrKjzjUh",(select case when eventdatavalues #>> '{gG9y8G2inZO, value}' = 'true' then 1 when eventdatavalues #>> '{gG9y8G2inZO, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "gG9y8G2inZO",(select case when eventdatavalues #>> '{Fkpc9dsNjVV, value}' = 'true' then 1 when eventdatavalues #>> '{Fkpc9dsNjVV, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "Fkpc9dsNjVV",(select eventdatavalues #>> '{AGOF2yYdvHj, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "AGOF2yYdvHj",(select case when eventdatavalues #>> '{C1h6VNqwOC3, value}' = 'true' then 1 when eventdatavalues #>> '{C1h6VNqwOC3, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "C1h6VNqwOC3",(select case when eventdatavalues #>> '{jx6dZuKlZjT, value}' = 'true' then 1 when eventdatavalues #>> '{jx6dZuKlZjT, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "jx6dZuKlZjT",(select eventdatavalues #>> '{EFlkdjpm0hw, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "EFlkdjpm0hw",psi.uid,pi.uid,ps.uid,ao.uid,pi.enrollmentdate,pi.incidentdate,psi.executiondate,psi.duedate,psi.completeddate,psi.created,psi.lastupdated,pi.status,psi.status,psi.geometry,CASE WHEN 'POINT' = GeometryType(psi.geometry) THEN ST_X(psi.geometry) ELSE null END,CASE WHEN 'POINT' = GeometryType(psi.geometry) THEN ST_Y(psi.geometry) ELSE null END,ou.uid,ou.name,ou.code from programstageinstance psi inner join programinstance pi on psi.programinstanceid=pi.programinstanceid inner join programstage ps on psi.programstageid=ps.programstageid inner join program pr on pi.programid=pr.programid and pi.deleted is false inner join categoryoptioncombo ao on psi.attributeoptioncomboid=ao.categoryoptioncomboid left join trackedentityinstance tei on pi.trackedentityinstanceid=tei.trackedentityinstanceid and tei.deleted is false inner join organisationunit ou on psi.organisationunitid=ou.organisationunitid left join _orgunitstructure ous on psi.organisationunitid=ous.organisationunitid left join _organisationunitgroupsetstructure ougs on psi.organisationunitid=ougs.organisationunitid and (cast(date_trunc('month', psi.executiondate) as date)=ougs.startdate or ougs.startdate is null) inner join _categorystructure acs on psi.attributeoptioncomboid=acs.categoryoptioncomboid left join _dateperiodstructure dps on cast(psi.executiondate as date)=dps.dateperiod where psi.lastupdated < '2021-07-07T12:22:07' and psi.lastupdated >= '2021-07-06T00:14:09' and pr.programid=103424431 and psi.organisationunitid is not null and psi.executiondate is not null and psi.deleted is false ]; ERROR: date/time field value out of range: "0000-01-01"; nested exception is org.postgresql.util.PSQLException: ERROR: date/time field value out of range: "0000-01-01"
    at java.util.concurrent.FutureTask.report(FutureTask.java:122) ~[?:1.8.0_262]
    at java.util.concurrent.FutureTask.get(FutureTask.java:192) ~[?:1.8.0_262]
    at org.hisp.dhis.commons.util.ConcurrentUtils.waitForCompletion(ConcurrentUtils.java:57) ~[dhis-support-commons-2.34.5.jar:?]
    ... 15 more
Caused by: org.springframework.dao.DataIntegrityViolationException: StatementCallback; SQL [insert into analytics_event_temp_fcg17cszswm_0 ("uidlevel1","uidlevel2","uidlevel3","uidlevel4","uidlevel5","uidlevel6","uidlevel7","uidlevel8","UOCVGT5pFb8","L78PtSgQ9hK","jpzvMY9zchJ","flod1BpeZpn","TWpLqJ9fEay","loEYmakRywD","uefNVIO6XHd","CH9nCUgbkn0","bYDNVZ4dDyq","mYo1OdNpe7B","rrmQnyX6CR3","jEmHPhfcznZ","t5Vb25H4Ld4","Dn3TvKMmRW2","iddhd4Zv29T","r4cXrdCPiK6","qcC7MoB5lZK","SUv2ytWYvYB","tbAGVEDuceX","KhF0NroJxnN","pYbRl3AUrtH","daily","weekly","weeklywednesday","weeklythursday","weeklysaturday","weeklysunday","biweekly","monthly","bimonthly","quarterly","sixmonthly","sixmonthlyapril","sixmonthlynov","yearly","financialapril","financialjuly","financialoct","financialnov","vhLREXkrIJS","TusePAOpoIs","AAaeOiqtONW","RhqVPUmGKlg","j2OId961SVu","HniOzDKFKRy","sF21TWc3jjD","sg9wqNbxonT","gZiBah1cxJL","h7iShQec76l","DHz7wUPwAqq","dJhrdgd6mqG","i5M3hVUNoTa","rSajAOLRz4d","rLJXDJKR2iZ","PCXMsdQfECN","U3SZgreH6Cq","LuUmtvGJMNN","WJAUMgILETw","LeIyYtQfh02","vwvQP8pVbVm","uu5obcfohEr","Jr6l3dZgD0D","nNMCNTblkTS","E6H8xGn1Dbt","Podr9dkZ1dM","txIrJG1iX4k","WulmkqvCSgG","C2mZj8xy186","fF4njAkbI7x","uE6G4GBVYdu","Ap91q7nHJSv","UFQs8yaBKpb","KxZAW9VsCDP","JUN4RtGATWq","n7ozbVAwH3V","wLu9eSHn0ga","MpQ6w0boP3Y","Nd37ZwZCIXI","VOS0tRHvZju","WrfrJhESJSw","qtkiHQdcs9N","QOtbuNC1EW9","V0TRtyOfde6","IV8UxuL6q7f","dOC7FnbSidv","y3vT9glyteD","EwX5bPPTgxW","qarF0snI3hT","N3YmEIoyfHm","XyNEDCO6HlL","l6p3rF8u68g","ujOGgL8BK2u","fNCDsWFtBz5","xgzq611f4Xn","KLPISLZrQJI","lRn9yETdEQZ","x7YVAFRmlOS","GtCF482duhv","KvO7C0RmC5h","ShaNUo8NIlu","YILWYLQmgQa","yayj7VDug5H","K0jCfidQXY4","WmkqxSERsb8","YZR1m5rxYzu","lsjx8mJCBkc","CCHujRxKxAO","MiIwYI5g79h","V9miEYsKXmm","wgDiBFsD7RC","EwSDIGnQW2f","q4EJDBDFUtP","uIMxi8QEtnB","aIzfji1fWbj","miTN72ZQZe8","UJ3NpQiHkSS","dLOnHV3cSHI","lg6wDWxQPpg","GDs5QDdE2nG","RUWJ65OE1Wt","W2iXxuW8EzR","CXKuKgyC8fs","hlSFLIAQXSL","I6LaG8DnSl1","W8izlRF3Pjj","ZENwfUnoSMP","lklZVCcDFcD","e8NiqL3qqr9","miv2k8RIVnC","PXmq2b0jqiu","Dk7Nf36OFnp","YjTDrKjzjUh","gG9y8G2inZO","Fkpc9dsNjVV","AGOF2yYdvHj","C1h6VNqwOC3","jx6dZuKlZjT","EFlkdjpm0hw","psi","pi","ps","ao","enrollmentdate","incidentdate","executiondate","duedate","completeddate","created","lastupdated","pistatus","psistatus","psigeometry","longitude","latitude","ou","ouname","oucode") select ous."uidlevel1",ous."uidlevel2",ous."uidlevel3",ous."uidlevel4",ous."uidlevel5",ous."uidlevel6",ous."uidlevel7",ous."uidlevel8",ougs."UOCVGT5pFb8",ougs."L78PtSgQ9hK",ougs."jpzvMY9zchJ",ougs."flod1BpeZpn",ougs."TWpLqJ9fEay",ougs."loEYmakRywD",ougs."uefNVIO6XHd",ougs."CH9nCUgbkn0",ougs."bYDNVZ4dDyq",ougs."mYo1OdNpe7B",ougs."rrmQnyX6CR3",ougs."jEmHPhfcznZ",ougs."t5Vb25H4Ld4",ougs."Dn3TvKMmRW2",ougs."iddhd4Zv29T",ougs."r4cXrdCPiK6",ougs."qcC7MoB5lZK",ougs."SUv2ytWYvYB",ougs."tbAGVEDuceX",ougs."KhF0NroJxnN",ougs."pYbRl3AUrtH",dps."daily",dps."weekly",dps."weeklywednesday",dps."weeklythursday",dps."weeklysaturday",dps."weeklysunday",dps."biweekly",dps."monthly",dps."bimonthly",dps."quarterly",dps."sixmonthly",dps."sixmonthlyapril",dps."sixmonthlynov",dps."yearly",dps."financialapril",dps."financialjuly",dps."financialoct",dps."financialnov",(select case when eventdatavalues #>> '{vhLREXkrIJS, value}' = 'true' then 1 when eventdatavalues #>> '{vhLREXkrIJS, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "vhLREXkrIJS",(select case when eventdatavalues #>> '{TusePAOpoIs, value}' = 'true' then 1 when eventdatavalues #>> '{TusePAOpoIs, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "TusePAOpoIs",(select eventdatavalues #>> '{AAaeOiqtONW, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "AAaeOiqtONW",(select case when eventdatavalues #>> '{RhqVPUmGKlg, value}' = 'true' then 1 when eventdatavalues #>> '{RhqVPUmGKlg, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "RhqVPUmGKlg",(select case when eventdatavalues #>> '{j2OId961SVu, value}' = 'true' then 1 when eventdatavalues #>> '{j2OId961SVu, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "j2OId961SVu",(select case when eventdatavalues #>> '{HniOzDKFKRy, value}' = 'true' then 1 when eventdatavalues #>> '{HniOzDKFKRy, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "HniOzDKFKRy",(select case when eventdatavalues #>> '{sF21TWc3jjD, value}' = 'true' then 1 when eventdatavalues #>> '{sF21TWc3jjD, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "sF21TWc3jjD",(select eventdatavalues #>> '{sg9wqNbxonT, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "sg9wqNbxonT",(select case when eventdatavalues #>> '{gZiBah1cxJL, value}' = 'true' then 1 when eventdatavalues #>> '{gZiBah1cxJL, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "gZiBah1cxJL",(select case when eventdatavalues #>> '{h7iShQec76l, value}' = 'true' then 1 when eventdatavalues #>> '{h7iShQec76l, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "h7iShQec76l",(select case when eventdatavalues #>> '{DHz7wUPwAqq, value}' = 'true' then 1 when eventdatavalues #>> '{DHz7wUPwAqq, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "DHz7wUPwAqq",(select cast(eventdatavalues #>> '{dJhrdgd6mqG, value}' as bigint) from programstageinstance where programstageinstanceid=psi.programstageinstanceid  and eventdatavalues #>> '{dJhrdgd6mqG,value}' ~* '^(-?[0-9]+)(\.[0-9]+)?$') as "dJhrdgd6mqG",(select eventdatavalues #>> '{i5M3hVUNoTa, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "i5M3hVUNoTa",(select case when eventdatavalues #>> '{rSajAOLRz4d, value}' = 'true' then 1 when eventdatavalues #>> '{rSajAOLRz4d, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "rSajAOLRz4d",(select eventdatavalues #>> '{rLJXDJKR2iZ, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "rLJXDJKR2iZ",(select case when eventdatavalues #>> '{PCXMsdQfECN, value}' = 'true' then 1 when eventdatavalues #>> '{PCXMsdQfECN, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "PCXMsdQfECN",(select case when eventdatavalues #>> '{U3SZgreH6Cq, value}' = 'true' then 1 when eventdatavalues #>> '{U3SZgreH6Cq, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "U3SZgreH6Cq",(select case when eventdatavalues #>> '{LuUmtvGJMNN, value}' = 'true' then 1 when eventdatavalues #>> '{LuUmtvGJMNN, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "LuUmtvGJMNN",(select case when eventdatavalues #>> '{WJAUMgILETw, value}' = 'true' then 1 when eventdatavalues #>> '{WJAUMgILETw, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "WJAUMgILETw",(select case when eventdatavalues #>> '{LeIyYtQfh02, value}' = 'true' then 1 when eventdatavalues #>> '{LeIyYtQfh02, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "LeIyYtQfh02",(select eventdatavalues #>> '{vwvQP8pVbVm, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "vwvQP8pVbVm",(select case when eventdatavalues #>> '{uu5obcfohEr, value}' = 'true' then 1 when eventdatavalues #>> '{uu5obcfohEr, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "uu5obcfohEr",(select case when eventdatavalues #>> '{Jr6l3dZgD0D, value}' = 'true' then 1 when eventdatavalues #>> '{Jr6l3dZgD0D, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "Jr6l3dZgD0D",(select case when eventdatavalues #>> '{nNMCNTblkTS, value}' = 'true' then 1 when eventdatavalues #>> '{nNMCNTblkTS, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "nNMCNTblkTS",(select case when eventdatavalues #>> '{E6H8xGn1Dbt, value}' = 'true' then 1 when eventdatavalues #>> '{E6H8xGn1Dbt, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "E6H8xGn1Dbt",(select case when eventdatavalues #>> '{Podr9dkZ1dM, value}' = 'true' then 1 when eventdatavalues #>> '{Podr9dkZ1dM, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "Podr9dkZ1dM",(select case when eventdatavalues #>> '{txIrJG1iX4k, value}' = 'true' then 1 when eventdatavalues #>> '{txIrJG1iX4k, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "txIrJG1iX4k",(select case when eventdatavalues #>> '{WulmkqvCSgG, value}' = 'true' then 1 when eventdatavalues #>> '{WulmkqvCSgG, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "WulmkqvCSgG",(select case when eventdatavalues #>> '{C2mZj8xy186, value}' = 'true' then 1 when eventdatavalues #>> '{C2mZj8xy186, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "C2mZj8xy186",(select case when eventdatavalues #>> '{fF4njAkbI7x, value}' = 'true' then 1 when eventdatavalues #>> '{fF4njAkbI7x, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "fF4njAkbI7x",(select cast(eventdatavalues #>> '{uE6G4GBVYdu, value}' as timestamp) from programstageinstance where programstageinstanceid=psi.programstageinstanceid  and eventdatavalues #>> '{uE6G4GBVYdu,value}' ~* '^\d{4}-\d{2}-\d{2}(\s|T)?((\d{2}:)(\d{2}:)?(\d{2}))?$') as "uE6G4GBVYdu",(select eventdatavalues #>> '{Ap91q7nHJSv, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "Ap91q7nHJSv",(select eventdatavalues #>> '{UFQs8yaBKpb, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "UFQs8yaBKpb",(select eventdatavalues #>> '{KxZAW9VsCDP, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "KxZAW9VsCDP",(select case when eventdatavalues #>> '{JUN4RtGATWq, value}' = 'true' then 1 when eventdatavalues #>> '{JUN4RtGATWq, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "JUN4RtGATWq",(select case when eventdatavalues #>> '{n7ozbVAwH3V, value}' = 'true' then 1 when eventdatavalues #>> '{n7ozbVAwH3V, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "n7ozbVAwH3V",(select eventdatavalues #>> '{wLu9eSHn0ga, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "wLu9eSHn0ga",(select case when eventdatavalues #>> '{MpQ6w0boP3Y, value}' = 'true' then 1 when eventdatavalues #>> '{MpQ6w0boP3Y, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "MpQ6w0boP3Y",(select case when eventdatavalues #>> '{Nd37ZwZCIXI, value}' = 'true' then 1 when eventdatavalues #>> '{Nd37ZwZCIXI, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "Nd37ZwZCIXI",(select case when eventdatavalues #>> '{VOS0tRHvZju, value}' = 'true' then 1 when eventdatavalues #>> '{VOS0tRHvZju, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "VOS0tRHvZju",(select eventdatavalues #>> '{WrfrJhESJSw, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "WrfrJhESJSw",(select case when eventdatavalues #>> '{qtkiHQdcs9N, value}' = 'true' then 1 when eventdatavalues #>> '{qtkiHQdcs9N, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "qtkiHQdcs9N",(select case when eventdatavalues #>> '{QOtbuNC1EW9, value}' = 'true' then 1 when eventdatavalues #>> '{QOtbuNC1EW9, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "QOtbuNC1EW9",(select case when eventdatavalues #>> '{V0TRtyOfde6, value}' = 'true' then 1 when eventdatavalues #>> '{V0TRtyOfde6, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "V0TRtyOfde6",(select eventdatavalues #>> '{IV8UxuL6q7f, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "IV8UxuL6q7f",(select case when eventdatavalues #>> '{dOC7FnbSidv, value}' = 'true' then 1 when eventdatavalues #>> '{dOC7FnbSidv, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "dOC7FnbSidv",(select case when eventdatavalues #>> '{y3vT9glyteD, value}' = 'true' then 1 when eventdatavalues #>> '{y3vT9glyteD, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "y3vT9glyteD",(select eventdatavalues #>> '{EwX5bPPTgxW, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "EwX5bPPTgxW",(select eventdatavalues #>> '{qarF0snI3hT, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "qarF0snI3hT",(select eventdatavalues #>> '{N3YmEIoyfHm, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "N3YmEIoyfHm",(select case when eventdatavalues #>> '{XyNEDCO6HlL, value}' = 'true' then 1 when eventdatavalues #>> '{XyNEDCO6HlL, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "XyNEDCO6HlL",(select case when eventdatavalues #>> '{l6p3rF8u68g, value}' = 'true' then 1 when eventdatavalues #>> '{l6p3rF8u68g, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "l6p3rF8u68g",(select eventdatavalues #>> '{ujOGgL8BK2u, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "ujOGgL8BK2u",(select case when eventdatavalues #>> '{fNCDsWFtBz5, value}' = 'true' then 1 when eventdatavalues #>> '{fNCDsWFtBz5, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "fNCDsWFtBz5",(select eventdatavalues #>> '{xgzq611f4Xn, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "xgzq611f4Xn",(select case when eventdatavalues #>> '{KLPISLZrQJI, value}' = 'true' then 1 when eventdatavalues #>> '{KLPISLZrQJI, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "KLPISLZrQJI",(select eventdatavalues #>> '{lRn9yETdEQZ, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "lRn9yETdEQZ",(select eventdatavalues #>> '{x7YVAFRmlOS, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "x7YVAFRmlOS",(select case when eventdatavalues #>> '{GtCF482duhv, value}' = 'true' then 1 when eventdatavalues #>> '{GtCF482duhv, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "GtCF482duhv",(select eventdatavalues #>> '{KvO7C0RmC5h, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "KvO7C0RmC5h",(select eventdatavalues #>> '{ShaNUo8NIlu, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "ShaNUo8NIlu",(select eventdatavalues #>> '{YILWYLQmgQa, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "YILWYLQmgQa",(select case when eventdatavalues #>> '{yayj7VDug5H, value}' = 'true' then 1 when eventdatavalues #>> '{yayj7VDug5H, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "yayj7VDug5H",(select eventdatavalues #>> '{K0jCfidQXY4, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "K0jCfidQXY4",(select case when eventdatavalues #>> '{WmkqxSERsb8, value}' = 'true' then 1 when eventdatavalues #>> '{WmkqxSERsb8, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "WmkqxSERsb8",(select case when eventdatavalues #>> '{YZR1m5rxYzu, value}' = 'true' then 1 when eventdatavalues #>> '{YZR1m5rxYzu, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "YZR1m5rxYzu",(select eventdatavalues #>> '{lsjx8mJCBkc, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "lsjx8mJCBkc",(select case when eventdatavalues #>> '{CCHujRxKxAO, value}' = 'true' then 1 when eventdatavalues #>> '{CCHujRxKxAO, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "CCHujRxKxAO",(select cast(eventdatavalues #>> '{MiIwYI5g79h, value}' as timestamp) from programstageinstance where programstageinstanceid=psi.programstageinstanceid  and eventdatavalues #>> '{MiIwYI5g79h,value}' ~* '^\d{4}-\d{2}-\d{2}(\s|T)?((\d{2}:)(\d{2}:)?(\d{2}))?$') as "MiIwYI5g79h",(select eventdatavalues #>> '{V9miEYsKXmm, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "V9miEYsKXmm",(select case when eventdatavalues #>> '{wgDiBFsD7RC, value}' = 'true' then 1 when eventdatavalues #>> '{wgDiBFsD7RC, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "wgDiBFsD7RC",(select case when eventdatavalues #>> '{EwSDIGnQW2f, value}' = 'true' then 1 when eventdatavalues #>> '{EwSDIGnQW2f, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "EwSDIGnQW2f",(select cast(eventdatavalues #>> '{q4EJDBDFUtP, value}' as bigint) from programstageinstance where programstageinstanceid=psi.programstageinstanceid  and eventdatavalues #>> '{q4EJDBDFUtP,value}' ~* '^(-?[0-9]+)(\.[0-9]+)?$') as "q4EJDBDFUtP",(select case when eventdatavalues #>> '{uIMxi8QEtnB, value}' = 'true' then 1 when eventdatavalues #>> '{uIMxi8QEtnB, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "uIMxi8QEtnB",(select eventdatavalues #>> '{aIzfji1fWbj, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "aIzfji1fWbj",(select eventdatavalues #>> '{miTN72ZQZe8, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "miTN72ZQZe8",(select case when eventdatavalues #>> '{UJ3NpQiHkSS, value}' = 'true' then 1 when eventdatavalues #>> '{UJ3NpQiHkSS, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "UJ3NpQiHkSS",(select eventdatavalues #>> '{dLOnHV3cSHI, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "dLOnHV3cSHI",(select case when eventdatavalues #>> '{lg6wDWxQPpg, value}' = 'true' then 1 when eventdatavalues #>> '{lg6wDWxQPpg, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "lg6wDWxQPpg",(select eventdatavalues #>> '{GDs5QDdE2nG, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "GDs5QDdE2nG",(select case when eventdatavalues #>> '{RUWJ65OE1Wt, value}' = 'true' then 1 when eventdatavalues #>> '{RUWJ65OE1Wt, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "RUWJ65OE1Wt",(select eventdatavalues #>> '{W2iXxuW8EzR, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "W2iXxuW8EzR",(select eventdatavalues #>> '{CXKuKgyC8fs, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "CXKuKgyC8fs",(select cast(eventdatavalues #>> '{hlSFLIAQXSL, value}' as double precision) from programstageinstance where programstageinstanceid=psi.programstageinstanceid  and eventdatavalues #>> '{hlSFLIAQXSL,value}' ~* '^(-?[0-9]+)(\.[0-9]+)?$') as "hlSFLIAQXSL",(select case when eventdatavalues #>> '{I6LaG8DnSl1, value}' = 'true' then 1 when eventdatavalues #>> '{I6LaG8DnSl1, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "I6LaG8DnSl1",(select case when eventdatavalues #>> '{W8izlRF3Pjj, value}' = 'true' then 1 when eventdatavalues #>> '{W8izlRF3Pjj, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "W8izlRF3Pjj",(select eventdatavalues #>> '{ZENwfUnoSMP, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "ZENwfUnoSMP",(select case when eventdatavalues #>> '{lklZVCcDFcD, value}' = 'true' then 1 when eventdatavalues #>> '{lklZVCcDFcD, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "lklZVCcDFcD",(select case when eventdatavalues #>> '{e8NiqL3qqr9, value}' = 'true' then 1 when eventdatavalues #>> '{e8NiqL3qqr9, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "e8NiqL3qqr9",(select eventdatavalues #>> '{miv2k8RIVnC, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "miv2k8RIVnC",(select case when eventdatavalues #>> '{PXmq2b0jqiu, value}' = 'true' then 1 when eventdatavalues #>> '{PXmq2b0jqiu, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "PXmq2b0jqiu",(select case when eventdatavalues #>> '{Dk7Nf36OFnp, value}' = 'true' then 1 when eventdatavalues #>> '{Dk7Nf36OFnp, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "Dk7Nf36OFnp",(select case when eventdatavalues #>> '{YjTDrKjzjUh, value}' = 'true' then 1 when eventdatavalues #>> '{YjTDrKjzjUh, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "YjTDrKjzjUh",(select case when eventdatavalues #>> '{gG9y8G2inZO, value}' = 'true' then 1 when eventdatavalues #>> '{gG9y8G2inZO, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "gG9y8G2inZO",(select case when eventdatavalues #>> '{Fkpc9dsNjVV, value}' = 'true' then 1 when eventdatavalues #>> '{Fkpc9dsNjVV, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "Fkpc9dsNjVV",(select eventdatavalues #>> '{AGOF2yYdvHj, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "AGOF2yYdvHj",(select case when eventdatavalues #>> '{C1h6VNqwOC3, value}' = 'true' then 1 when eventdatavalues #>> '{C1h6VNqwOC3, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "C1h6VNqwOC3",(select case when eventdatavalues #>> '{jx6dZuKlZjT, value}' = 'true' then 1 when eventdatavalues #>> '{jx6dZuKlZjT, value}' = 'false' then 0 else null end from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "jx6dZuKlZjT",(select eventdatavalues #>> '{EFlkdjpm0hw, value}' from programstageinstance where programstageinstanceid=psi.programstageinstanceid ) as "EFlkdjpm0hw",psi.uid,pi.uid,ps.uid,ao.uid,pi.enrollmentdate,pi.incidentdate,psi.executiondate,psi.duedate,psi.completeddate,psi.created,psi.lastupdated,pi.status,psi.status,psi.geometry,CASE WHEN 'POINT' = GeometryType(psi.geometry) THEN ST_X(psi.geometry) ELSE null END,CASE WHEN 'POINT' = GeometryType(psi.geometry) THEN ST_Y(psi.geometry) ELSE null END,ou.uid,ou.name,ou.code from programstageinstance psi inner join programinstance pi on psi.programinstanceid=pi.programinstanceid inner join programstage ps on psi.programstageid=ps.programstageid inner join program pr on pi.programid=pr.programid and pi.deleted is false inner join categoryoptioncombo ao on psi.attributeoptioncomboid=ao.categoryoptioncomboid left join trackedentityinstance tei on pi.trackedentityinstanceid=tei.trackedentityinstanceid and tei.deleted is false inner join organisationunit ou on psi.organisationunitid=ou.organisationunitid left join _orgunitstructure ous on psi.organisationunitid=ous.organisationunitid left join _organisationunitgroupsetstructure ougs on psi.organisationunitid=ougs.organisationunitid and (cast(date_trunc('month', psi.executiondate) as date)=ougs.startdate or ougs.startdate is null) inner join _categorystructure acs on psi.attributeoptioncomboid=acs.categoryoptioncomboid left join _dateperiodstructure dps on cast(psi.executiondate as date)=dps.dateperiod where psi.lastupdated < '2021-07-07T12:22:07' and psi.lastupdated >= '2021-07-06T00:14:09' and pr.programid=103424431 and psi.organisationunitid is not null and psi.executiondate is not null and psi.deleted is false ]; ERROR: date/time field value out of range: "0000-01-01"; nested exception is org.postgresql.util.PSQLException: ERROR: date/time field value out of range: "0000-01-01"
    at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:104) ~[spring-jdbc-5.2.4.RELEASE.jar:5.2.4.RELEASE]
    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) ~[spring-jdbc-5.2.4.RELEASE.jar:5.2.4.RELEASE]
    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) ~[spring-jdbc-5.2.4.RELEASE.jar:5.2.4.RELEASE]
    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) ~[spring-jdbc-5.2.4.RELEASE.jar:5.2.4.RELEASE]
    at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1443) ~[spring-jdbc-5.2.4.RELEASE.jar:5.2.4.RELEASE]
    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:388) ~[spring-jdbc-5.2.4.RELEASE.jar:5.2.4.RELEASE]
    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:418) ~[spring-jdbc-5.2.4.RELEASE.jar:5.2.4.RELEASE]
    at org.hisp.dhis.analytics.table.AbstractJdbcTableManager.invokeTimeAndLog(AbstractJdbcTableManager.java:556) ~[dhis-service-analytics-2.34.5.jar:?]
    at org.hisp.dhis.analytics.table.AbstractEventJdbcTableManager.populateTableInternal(AbstractEventJdbcTableManager.java:192) ~[dhis-service-analytics-2.34.5.jar:?]
    at org.hisp.dhis.analytics.table.JdbcEventAnalyticsTableManager.populateTable(JdbcEventAnalyticsTableManager.java:323) ~[dhis-service-analytics-2.34.5.jar:?]
    at org.hisp.dhis.analytics.table.AbstractJdbcTableManager.populateTablesAsync(AbstractJdbcTableManager.java:278) ~[dhis-service-analytics-2.34.5.jar:?]
    at sun.reflect.GeneratedMethodAccessor4021.invoke(Unknown Source) ~[?:?]
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_262]
    at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_262]
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344) ~[spring-aop-5.2.4.RELEASE.jar:5.2.4.RELEASE]
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198) ~[spring-aop-5.2.4.RELEASE.jar:5.2.4.RELEASE]
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.2.4.RELEASE.jar:5.2.4.RELEASE]
    at org.springframework.aop.interceptor.AsyncExecutionInterceptor.lambda$invoke$0(AsyncExecutionInterceptor.java:115) ~[spring-aop-5.2.4.RELEASE.jar:5.2.4.RELEASE]
    at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_262]
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) ~[?:1.8.0_262]
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) ~[?:1.8.0_262]
    ... 3 more
Caused by: org.postgresql.util.PSQLException: ERROR: date/time field value out of range: "0000-01-01"
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440) ~[postgresql-42.2.5.jar:42.2.5]
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183) ~[postgresql-42.2.5.jar:42.2.5]
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308) ~[postgresql-42.2.5.jar:42.2.5]
    at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441) ~[postgresql-42.2.5.jar:42.2.5]
    at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365) ~[postgresql-42.2.5.jar:42.2.5]
    at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307) ~[postgresql-42.2.5.jar:42.2.5]
    at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293) ~[postgresql-42.2.5.jar:42.2.5]
    at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270) ~[postgresql-42.2.5.jar:42.2.5]
    at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:266) ~[postgresql-42.2.5.jar:42.2.5]
    at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:75) ~[c3p0-0.9.5.5.jar:0.9.5.5]
    at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:409) ~[spring-jdbc-5.2.4.RELEASE.jar:5.2.4.RELEASE]
    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376) ~[spring-jdbc-5.2.4.RELEASE.jar:5.2.4.RELEASE]
    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:418) ~[spring-jdbc-5.2.4.RELEASE.jar:5.2.4.RELEASE]
    at org.hisp.dhis.analytics.table.AbstractJdbcTableManager.invokeTimeAndLog(AbstractJdbcTableManager.java:556) ~[dhis-service-analytics-2.34.5.jar:?]
    at org.hisp.dhis.analytics.table.AbstractEventJdbcTableManager.populateTableInternal(AbstractEventJdbcTableManager.java:192) ~[dhis-service-analytics-2.34.5.jar:?]
    at org.hisp.dhis.analytics.table.JdbcEventAnalyticsTableManager.populateTable(JdbcEventAnalyticsTableManager.java:323) ~[dhis-service-analytics-2.34.5.jar:?]
    at org.hisp.dhis.analytics.table.AbstractJdbcTableManager.populateTablesAsync(AbstractJdbcTableManager.java:278) ~[dhis-service-analytics-2.34.5.jar:?]
    at sun.reflect.GeneratedMethodAccessor4021.invoke(Unknown Source) ~[?:?]
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_262]
    at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_262]
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344) ~[spring-aop-5.2.4.RELEASE.jar:5.2.4.RELEASE]
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198) ~[spring-aop-5.2.4.RELEASE.jar:5.2.4.RELEASE]
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.2.4.RELEASE.jar:5.2.4.RELEASE]
    at org.springframework.aop.interceptor.AsyncExecutionInterceptor.lambda$invoke$0(AsyncExecutionInterceptor.java:115) ~[spring-aop-5.2.4.RELEASE.jar:5.2.4.RELEASE]
    at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_262]
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) ~[?:1.8.0_262]
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) ~[?:1.8.0_262]
    ... 3 more

Tasks API Errors

Continuous Analytics Tables Tasks

"CONTINUOUS_ANALYTICS_TABLE": {"OMy48sOTSHk": [{"uid": "s75FKBPNlKl","level": "ERROR","category": "CONTINUOUS_ANALYTICS_TABLE","time": "2021-07-07T12:26:12.518","message": "Process failed: Exception during execution","completed": true,"id": "s75FKBPNlKl"}

Analytics Tables Tasks

"ANALYTICS_TABLE":
{"HJDqokyuWlX": [{"uid": "Nwp7qt6n25m","level": "ERROR","category": "ANALYTICS_TABLE","time": "2021-07-07T04:36:34.261","message": "Process failed: Exception during execution","completed": true,"id": "Nwp7qt6n25m"},

UiO Jira Ticket (similar)

https://jira.dhis2.org/browse/DHIS2-10292?jql=text%20~%20%22Process%20failed%3A%20Exception%20during%20execution%22