Analytics table update process stucked

Karina_Dian_Lestari · 27 January 2017 11:28

Hi all,

It’s been two hours and analytic still stay like this.

Inline images 1

This is on DHIS2 2.25.

I have done vacuum full and back-up the database before the process. The back-up file is only 4378 KB, I don’t think the analysis process should take a long time.

Does anyone know how to solve this?

Please find attached file to see analytic table log.

Thank you very much.

dhis-analytics-table.log (1.15 MB)

···

–

Best regards,

Karin.

Lars · 27 January 2017 11:54

Hi Karina,

it seems to be stuck on the dateperiodstructure resource table. Are you able to share the database privately?

regards,

Lars

···

On Fri, Jan 27, 2017 at 12:28 PM, Karina Dian Lestari karinadnlstr@gmail.com wrote:

Hi all,

It’s been two hours and analytic still stay like this.

This is on DHIS2 2.25.

I have done vacuum full and back-up the database before the process. The back-up file is only 4378 KB, I don’t think the analysis process should take a long time.

Does anyone know how to solve this?

Please find attached file to see analytic table log.

Thank you very much.

–

Best regards,

Karin.

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

–

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

Gerald_Thomas · 27 January 2017 12:35

Hi Karina,
Please share your postgres.conf file and your server specification.

···

On 1/27/17, Lars Helge Øverland <lars@dhis2.org> wrote:

Hi Karina,

it seems to be stuck on the dateperiodstructure resource table. Are you
able to share the database privately?

regards,

Lars

On Fri, Jan 27, 2017 at 12:28 PM, Karina Dian Lestari < > karinadnlstr@gmail.com> wrote:

Hi all,

It's been two hours and analytic still stay like this.
[image: Inline images 1]

This is on DHIS2 2.25.
I have done vacuum full and back-up the database before the process. The
back-up file is only 4378 KB, I don't think the analysis process should
take a long time.
Does anyone know how to solve this?

Please find attached file to see analytic table log.

Thank you very much.

--
Best regards,
Karin.

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

--
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
lars@dhis2.org
http://www.dhis2.org <https://www.dhis2.org/>

--
Regards,

Gerald

ifeanyiokoye · 26 July 2023 11:19

Hello @Lars @Gerald_Thomas
My analytics table process is currently stuck at this point (dateperiod table). I have restarted the server and tried again but did not help.

This instance is running 2.40.

How was this issue resolved?

@Gassim @dhis2-analytics

Gerald_Thomas · 26 July 2023 11:48

Hi @ifeanyiokoye,

Yes, I have encountered and resolved this issue before. Please execute the following PostgreSQL query:
SELECT * FROM periodtype;

If you find the entry ‘QuarterlyNov’ in the table, you can remove it using the following command:

DELETE FROM periodtype WHERE name = ‘QuarterlyNov’;

After deleting the entry, run the analytics process again to ensure that everything is functioning as expected.

ifeanyiokoye · 27 July 2023 09:12

Thank you @Gerald_Thomas

I will get back to you.

ifeanyiokoye · 28 July 2023 10:59

Hello @Gerald_Thomas
Thank you once again for the guidance.

Here are the results:

Here is the error also from the system messages:

Item failed: generating DatePeriod table System title: … Time: 2023-07-26T15:37:11.090Z Message: PreparedStatementCallback; SQL [insert into _dateperiodstructure_temp values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)]; Batch entry 1,153 insert into _dateperiodstructure_temp values (‘0200-02-29 00:00:00+00’,200,‘2000228’,‘200W9’,‘200WedW9’,‘200ThuW9’,‘200SatW8’,‘200SunW9’,‘200BiW5’,‘20002’,‘20001B’,‘200Q1’,‘200S1’,‘199AprilS2’,‘200NovS1’,‘200’,‘199April’,‘199July’,‘199Oct’,‘200Nov’) was aborted: ERROR: date/time field value out of range: “0200-02-29 00:00:00+00” Call getNextException to see other errors in the batch.; nested exception is java.sql.BatchUpdateException: Batch entry 1,153 insert into _dateperiodstructure_temp values (‘0200-02-29 00:00:00+00’,200,‘2000228’,‘200W9’,‘200WedW9’,‘200ThuW9’,‘200SatW8’,‘200SunW9’,‘200BiW5’,‘20002’,‘20001B’,‘200Q1’,‘200S1’,‘199AprilS2’,‘200NovS1’,‘200’,‘199April’,‘199July’,‘199Oct’,‘200Nov’) was aborted: ERROR: date/time field value out of range: “0200-02-29 00:00:00+00” Call getNextException to see other errors in the batch. Cause: java.sql.BatchUpdateException: Batch entry 1,153 insert into _dateperiodstructure_temp values (‘0200-02-29 00:00:00+00’,200,‘2000228’,‘200W9’,‘200WedW9’,‘200ThuW9’,‘200SatW8’,‘200SunW9’,‘200BiW5’,‘20002’,‘20001B’,‘200Q1’,‘200S1’,‘199AprilS2’,‘200NovS1’,‘200’,‘199April’,‘199July’,‘199Oct’,‘200Nov’) was aborted: ERROR: date/time field value out of range: “0200-02-29 00:00:00+00” Call getNextException to see other errors in the batch. at org.postgresql.jdbc.BatchResultHandler.handleError(BatchResultHandler.java:165) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2367) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2099) at org.postgresql.core.v3.QueryExecutorImpl.flushIfDeadlockRisk(QueryExecutorImpl.java:1456) at org.postgresql.core.v3.QueryExecutorImpl.sendQuery(QueryExecutorImpl.java:1481) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:546) at org.postgresql.jdbc.PgStatement.internalExecuteBatch(PgStatement.java:893) at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:916) at org.postgresql.jdbc.PgPreparedStatement.executeBatch(PgPreparedStatement.java:1684) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:2544) at org.springframework.jdbc.core.JdbcTemplate.lambda$batchUpdate$4(JdbcTemplate.java:1048) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:651) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:691) at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1034) at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1088) at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1079) at org.hisp.dhis.resourcetable.jdbc.JdbcResourceTableStore.batchUpdate(JdbcResourceTableStore.java:198) at org.hisp.dhis.resourcetable.jdbc.JdbcResourceTableStore.generateResourceTable(JdbcResourceTableStore.java:121) at org.hisp.dhis.resourcetable.DefaultResourceTableService.generateDatePeriodTable(DefaultResourceTableService.java:183) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) 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.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:215) at com.sun.proxy.$Proxy244.generateDatePeriodTable(Unknown Source) at org.hisp.dhis.scheduling.JobProgress.lambda$runStage$1(JobProgress.java:251) at org.hisp.dhis.scheduling.JobProgress.lambda$runStage$3(JobProgress.java:300) at org.hisp.dhis.scheduling.JobProgress.runStage(JobProgress.java:345) at org.hisp.dhis.scheduling.JobProgress.runStage(JobProgress.java:299) at org.hisp.dhis.scheduling.JobProgress.runStage(JobProgress.java:279) at org.hisp.dhis.scheduling.JobProgress.runStage(JobProgress.java:268) at org.hisp.dhis.scheduling.JobProgress.runStage(JobProgress.java:251) at org.hisp.dhis.analytics.table.DefaultAnalyticsTableGenerator.generateResourceTablesInternal(DefaultAnalyticsTableGenerator.java:190) at org.hisp.dhis.analytics.table.DefaultAnalyticsTableGenerator.generateTables(DefaultAnalyticsTableGenerator.java:100) at org.hisp.dhis.analytics.table.scheduling.AnalyticsTableJob.execute(AnalyticsTableJob.java:72) at org.hisp.dhis.scheduling.AbstractSchedulingManager.execute(AbstractSchedulingManager.java:325) at org.hisp.dhis.scheduling.DefaultSchedulingManager.lambda$executeNow$6(DefaultSchedulingManager.java:200) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:304) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:829) Caused by: org.postgresql.util.PSQLException: ERROR: date/time field value out of range: “0200-02-29 00:00:00+00” at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2676) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2366) … 51 more

Gerald_Thomas · 7 August 2023 09:55

Dr Ifeanyi Okoye,
What I am seeing is that the upgrade is having issues with the period type: (“periodtype”) that had April, July, and November. I suggest you should delete them and try the upgrade again.

Oficial_MEAL_CATATUM · 12 August 2023 16:44

Hi,
Have you been able to get the solution? we are going through the same thing!

I appreciate your response

Gerald_Thomas · 12 August 2023 18:28

Please send us the result of this query:
SELECT * FROM periodtype;

Gassim · 14 August 2023 13:24

@here you might also find this helpful: Errors executing analytics due invalid date and period response from @maikel

Thanks!

mutali · 17 October 2023 08:54

I do have another error and from Oct 17 10:00:19 hmis tomcat9[3512648]: * WARN Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: Oct 17 10:00:19 hmis tomcat9[3512648]: all proposed solution, I cant find the value causing the error, any hint on this? the DHIS2 version is 2.40.1: * ERROR 2023-10-17T10:00:19,286 PreparedStatementCallback; SQL [insert into _dateperiodstructure_temp values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)]; Batch entry 39,514 insert into _dateperiodstructure_temp values (‘1300-02-29 23:59:44+02’,1300,‘13000309’,‘1300W10’,‘1300WedW10’,‘1300ThuW10’,‘1300SatW10’,‘1300SunW10’,‘1300BiW5’,‘130003’,‘130002B’,‘1300Q1’,‘1300NovQ2’,‘1300S1’,‘1299AprilS2’,‘1300NovS1’,‘1300’,‘1299April’,‘1299July’,‘1299Oct’,‘1300Nov’) was aborted: ERROR: date/time field value out of range: “1300-02-29 23:59:44+02” Call getNextException to see other errors in the batch.; nested exception is java.sql.BatchUpdateException: Batch entry 39,514 insert into _dateperiodstructure_temp values (‘1300-02-29 23:59:44+02’,1300,‘13000309’,‘1300W10’,‘1300WedW10’,‘1300ThuW10’,‘1300SatW10’,‘1300SunW10’,‘1300BiW5’,‘130003’,‘130002B’,‘1300Q1’,‘1300NovQ2’,‘1300S1’,‘1299AprilS2’,‘1300NovS1’,‘1300’,‘1299April’,‘1299July’,‘1299Oct’,‘1300Nov’) was aborted: ERROR: date/time field value out of range: “1300-02-29 23:59:44+02” Call getNextException to see other errors in the batch. (NotificationLoggerUtil.java [taskScheduler-11]) UID:GzLhesyvifP
2023-10-17T10:00:19,288 [RESOURCE_TABLE GzLhesyvifP] Process aborted after 25m24.823s: aborted after error: PreparedStatementCallback; SQL [insert into _dateperiodstructure_temp values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)]; Batch entry 39,514 insert into _dateperiodstructure_temp values (‘1300-02-29 23:59:44+02’,1300,‘13000309’,‘1300W10’,‘1300WedW10’,‘1300ThuW10’,‘1300SatW10’,‘1300SunW10’,‘1300BiW5’,‘130003’,‘130002B’,‘1300Q1’,‘1300NovQ2’,‘1300S1’,‘1299AprilS2’,‘1300NovS1’,‘1300’,‘1299April’,‘1299July’,‘1299Oct’,‘1300Nov’) was aborted: ERROR: date/time field value out of range: “1300-02-29 23:59:44+02” Call getNextException to see other errors in the batch.; nested exception is java.sql.BatchUpdateException: Batch entry 39,514 insert into _dateperiodstructure_temp values (‘1300-02-29 23:59:44+02’,1300,‘13000309’,‘1300W10’,‘1300WedW10’,‘1300ThuW10’,‘1300SatW10’,‘1300SunW10’,‘1300BiW5’,‘130003’,‘130002B’,‘1300Q1’,‘1300NovQ2’,‘1300S1’,‘1299AprilS2’,‘1300NovS1’,‘1300’,‘1299April’,‘1299July’,‘1299Oct’,‘1300Nov’) was aborted: ERROR: date/time field value out of range: “1300-02-29 23:59:44+02” Call getNextException to see other errors in the batch. (ControlledJobProgress.java [taskScheduler-11]) UID:GzLhesyvifP
* ERROR 2023-10-17T10:00:19,289 [RESOURCE_TABLE GzLhesyvifP] Item failed after 25m20.317s: PreparedStatementCallback; SQL [insert into _dateperiodstructure_temp values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)]; Batch entry 39,514 insert into _dateperiodstructure_temp values (‘1300-02-29 23:59:44+02’,1300,‘13000309’,‘1300W10’,‘1300WedW10’,‘1300ThuW10’,‘1300SatW10’,‘1300SunW10’,‘1300BiW5’,‘130003’,‘130002B’,‘1300Q1’,‘1300NovQ2’,‘1300S1’,‘1299AprilS2’,‘1300NovS1’,‘1300’,‘1299April’,‘1299July’,‘1299Oct’,‘1300Nov’) was aborted: ERROR: date/time field value out of range: “1300-02-29 23:59:44+02” Call getNextException to see other errors in the batch.; nested exception is java.sql.BatchUpdateException: Batch entry 39,514 insert into _dateperiodstructure_temp values (‘1300-02-29 23:59:44+02’,1300,‘13000309’,‘1300W10’,‘1300WedW10’,‘1300ThuW10’,‘1300SatW10’,‘1300SunW10’,‘1300BiW5’,‘130003’,‘130002B’,‘1300Q1’,‘1300NovQ2’,‘1300S1’,‘1299AprilS2’,‘1300NovS1’,‘1300’,‘1299April’,‘1299July’,‘1299Oct’,‘1300Nov’) was aborted: ERROR: date/time field value out of range: “1300-02-29 23:59:44+02” Call getNextException to see other errors in the batch. (ControlledJobProgress.java [taskScheduler-11]) UID:GzLhesyvifP
org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [insert into _dateperiodstructure_temp values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)]; Batch entry 39,514 insert into _dateperiodstructure_temp values (‘1300-02-29 23:59:44+02’,1300,‘13000309’,‘1300W10’,‘1300WedW10’,‘1300ThuW10’,‘1300SatW10’,‘1300SunW10’,‘1300BiW5’,‘130003’,‘130002B’,‘1300Q1’,‘1300NovQ2’,‘1300S1’,‘1299AprilS2’,‘1300NovS1’,‘1300’,‘1299April’,‘1299July’,‘1299Oct’,‘1300Nov’) was aborted: ERROR: date/time field value out of range: “1300-02-29 23:59:44+02” Call getNextException to see other errors in the batch.; nested exception is java.sql.BatchUpdateException: Batch entry 39,514 insert into _dateperiodstructure_temp values (‘1300-02-29 23:59:44+02’,1300,‘13000309’,‘1300W10’,‘1300WedW10’,‘1300ThuW10’,‘1300SatW10’,‘1300SunW10’,‘1300BiW5’,‘130003’,‘130002B’,‘1300Q1’,‘1300NovQ2’,‘1300S1’,‘1299AprilS2’,‘1300NovS1’,‘1300’,‘1299April’,‘1299July’,‘1299Oct’,‘1300Nov’) was aborted: ERROR: date/time field value out of range: “1300-02-29 23:59:44+02” Call getNextException to see other errors in the batch.
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:104) ~[spring-jdbc-5.3.29.jar:5.3.29]
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70) ~[spring-jdbc-5.3.29.jar:5.3.29]
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:79) ~[spring-jdbc-5.3.29.jar:5.3.29]
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:79) ~[spring-jdbc-5.3.29.jar:5.3.29]
at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1583) ~[spring-jdbc-5.3.29.jar:5.3.29]
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:675) ~[spring-jdbc-5.3.29.jar:5.3.29]
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:699) ~[spring-jdbc-5.3.29.jar:5.3.29]
at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1042) ~[spring-jdbc-5.3.29.jar:5.3.29]
at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1096) ~[spring-jdbc-5.3.29.jar:5.3.29]
at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1087) ~[spring-jdbc-5.3.29.jar:5.3.29]
at org.hisp.dhis.resourcetable.jdbc.JdbcResourceTableStore.batchUpdate(JdbcResourceTableStore.java:183) ~[dhis-service-administration-2.40.1.jar:?]
at org.hisp.dhis.resourcetable.jdbc.JdbcResourceTableStore.generateResourceTable(JdbcResourceTableStore.java:112) ~[dhis-service-administration-2.40.1.jar:?]
at org.hisp.dhis.resourcetable.DefaultResourceTableService.generateDatePeriodTable(DefaultResourceTableService.java:184) ~[dhis-service-administration-2.40.1.jar:?]
at jdk.internal.reflect.GeneratedMethodAccessor4281.invoke(Unknown Source) ~[?:?]
at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344) ~[spring-aop-5.3.29.jar:5.3.29]
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198) ~[spring-aop-5.3.29.jar:5.3.29]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.3.29.jar:5.3.29]
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123) ~[spring-tx-5.3.29.jar:5.3.29]
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388) ~[spring-tx-5.3.29.jar:5.3.29]
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119) ~[spring-tx-5.3.29.jar:5.3.29]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.3.29.jar:5.3.29]
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:241) ~[spring-aop-5.3.29.jar:5.3.29]
at com.sun.proxy.$Proxy370.generateDatePeriodTable(Unknown Source) ~[?:?]
at org.hisp.dhis.scheduling.JobProgress.lambda$runStage$1(JobProgress.java:227) ~[dhis-api-2.40.1.jar:?]
at org.hisp.dhis.scheduling.JobProgress.lambda$runStage$3(JobProgress.java:282) ~[dhis-api-2.40.1.jar:?]
at org.hisp.dhis.scheduling.JobProgress.runStage(JobProgress.java:325) ~[dhis-api-2.40.1.jar:?]
at org.hisp.dhis.scheduling.JobProgress.runStage(JobProgress.java:277) ~[dhis-api-2.40.1.jar:?]
at org.hisp.dhis.scheduling.JobProgress.runStage(JobProgress.java:252) ~[dhis-api-2.40.1.jar:?]
at org.hisp.dhis.scheduling.JobProgress.runStage(JobProgress.java:242) ~[dhis-api-2.40.1.jar:?]
at org.hisp.dhis.scheduling.JobProgress.runStage(JobProgress.java:227) ~[dhis-api-2.40.1.jar:?]
at org.hisp.dhis.analytics.table.DefaultAnalyticsTableGenerator.generateResourceTablesInternal(DefaultAnalyticsTableGenerator.java:182) ~[dhis-service-analytics-2.40.1.jar:?]
at org.hisp.dhis.analytics.table.DefaultAnalyticsTableGenerator.generateResourceTables(DefaultAnalyticsTableGenerator.java:138) ~[dhis-service-analytics-2.40.1.jar:?]
at org.hisp.dhis.analytics.table.scheduling.ResourceTableJob.execute(ResourceTableJob.java:59) ~[dhis-service-analytics-2.40.1.jar:?]
at org.hisp.dhis.scheduling.AbstractSchedulingManager.execute(AbstractSchedulingManager.java:292) ~[dhis-service-core-2.40.1.jar:?]
at org.hisp.dhis.scheduling.DefaultSchedulingManager.lambda$executeNow$6(DefaultSchedulingManager.java:201) ~[dhis-service-core-2.40.1.jar:?]
at org.glowroot.agent.plugin.executor.RunnableWrapper.run(RunnableWrapper.java:35) [?:0.13.6]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) [?:?]
at java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?]
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) [spring-context-5.3.29.jar:5.3.29]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) [?:?]
at java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:304) [?:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]
at java.lang.Thread.run(Thread.java:829) [?:?]
Caused by: java.sql.BatchUpdateException: Batch entry 39,514 insert into _dateperiodstructure_temp values (‘1300-02-29 23:59:44+02’,1300,‘13000309’,‘1300W10’,‘1300WedW10’,‘1300ThuW10’,‘1300SatW10’,‘1300SunW10’,‘1300BiW5’,‘130003’,‘130002B’,‘1300Q1’,‘1300NovQ2’,‘1300S1’,‘1299AprilS2’,‘1300NovS1’,‘1300’,‘1299April’,‘1299July’,‘1299Oct’,‘1300Nov’) was aborted: ERROR: date/time field value out of range: “1300-02-29 23:59:44+02” Call getNextException to see other errors in the batch.
at org.postgresql.jdbc.BatchResultHandler.handleError(BatchResultHandler.java:165) ~[postgresql-42.6.0.jar:42.6.0]
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2402) ~[postgresql-42.6.0.jar:42.6.0]
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2134) ~[postgresql-42.6.0.jar:42.6.0]
at org.postgresql.core.v3.QueryExecutorImpl.flushIfDeadlockRisk(QueryExecutorImpl.java:1491) ~[postgresql-42.6.0.jar:42.6.0]
at org.postgresql.core.v3.QueryExecutorImpl.sendQuery(QueryExecutorImpl.java:1516) ~[postgresql-42.6.0.jar:42.6.0]
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:560) ~[postgresql-42.6.0.jar:42.6.0]
at org.postgresql.jdbc.PgStatement.internalExecuteBatch(PgStatement.java:896) ~[postgresql-42.6.0.jar:42.6.0]
at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:919) ~[postgresql-42.6.0.jar:42.6.0]
at org.postgresql.jdbc.PgPreparedStatement.executeBatch(PgPreparedStatement.java:1685) ~[postgresql-42.6.0.jar:42.6.0]
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:2544) ~[c3p0-0.9.5.5.jar:0.9.5.5]
at org.springframework.jdbc.core.JdbcTemplate.lambda$batchUpdate$4(JdbcTemplate.java:1056) ~[spring-jdbc-5.3.29.jar:5.3.29]
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:656) ~[spring-jdbc-5.3.29.jar:5.3.29]
… 41 more
Caused by: org.postgresql.util.PSQLException: ERROR: date/time field value out of range: “1300-02-29 23:59:44+02”
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2713) ~[postgresql-42.6.0.jar:42.6.0]
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2401) ~[postgresql-42.6.0.jar:42.6.0]
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2134) ~[postgresql-42.6.0.jar:42.6.0]
at org.postgresql.core.v3.QueryExecutorImpl.flushIfDeadlockRisk(QueryExecutorImpl.java:1491) ~[postgresql-42.6.0.jar:42.6.0]
at org.postgresql.core.v3.QueryExecutorImpl.sendQuery(QueryExecutorImpl.java:1516) ~[postgresql-42.6.0.jar:42.6.0]
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:560) ~[postgresql-42.6.0.jar:42.6.0]
at org.postgresql.jdbc.PgStatement.internalExecuteBatch(PgStatement.java:896) ~[postgresql-42.6.0.jar:42.6.0]
at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:919) ~[postgresql-42.6.0.jar:42.6.0]
at org.postgresql.jdbc.PgPreparedStatement.executeBatch(PgPreparedStatement.java:1685) ~[postgresql-42.6.0.jar:42.6.0]
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:2544) ~[c3p0-0.9.5.5.jar:0.9.5.5]
at org.springframework.jdbc.core.JdbcTemplate.lambda$batchUpdate$4(JdbcTemplate.java:1056) ~[spring-jdbc-5.3.29.jar:5.3.29]
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:656) ~[spring-jdbc-5.3.29.jar:5.3.29]
… 41 more
* ERROR 2023-10-17T10:00:19,713 processing aborted: skipped stage, failing item caused abort. 9 successful and 1 failed items (NotificationLoggerUtil.java [taskScheduler-11]) UID:GzLhesyvifP
* ERROR 2023-10-17T10:00:19,714 [RESOURCE_TABLE GzLhesyvifP] Stage failed after 25m25.231s: processing aborted: skipped stage, failing item caused abort. 9 successful and 1 failed items (ControlledJobProgress.java [taskScheduler-11]) UID:GzLhesyvifP
java.lang.RuntimeException: processing aborted: skipped stage, failing item caused abort. 9 successful and 1 failed items
at org.hisp.dhis.scheduling.ControlledJobProgress.cancellationAsAbort(ControlledJobProgress.java:347) ~[dhis-service-core-2.40.1.jar:?]
at org.hisp.dhis.scheduling.ControlledJobProgress.failedStage(ControlledJobProgress.java:210) ~[dhis-service-core-2.40.1.jar:?]
at org.hisp.dhis.scheduling.JobProgress.autoSkipStage(JobProgress.java:354) ~[dhis-api-2.40.1.jar:?]
at org.hisp.dhis.scheduling.JobProgress.runStage(JobProgress.java:330) ~[dhis-api-2.40.1.jar:?]
at org.hisp.dhis.scheduling.JobProgress.runStage(JobProgress.java:277) ~[dhis-api-2.40.1.jar:?]
at org.hisp.dhis.scheduling.JobProgress.runStage(JobProgress.java:252) ~[dhis-api-2.40.1.jar:?]
at org.hisp.dhis.scheduling.JobProgress.runStage(JobProgress.java:242) ~[dhis-api-2.40.1.jar:?]
at org.hisp.dhis.scheduling.JobProgress.runStage(JobProgress.java:227) ~[dhis-api-2.40.1.jar:?]
at org.hisp.dhis.analytics.table.DefaultAnalyticsTableGenerator.generateResourceTablesInternal(DefaultAnalyticsTableGenerator.java:182) ~[dhis-service-analytics-2.40.1.jar:?]
at org.hisp.dhis.analytics.table.DefaultAnalyticsTableGenerator.generateResourceTables(DefaultAnalyticsTableGenerator.java:138) ~[dhis-service-analytics-2.40.1.jar:?]
at org.hisp.dhis.analytics.table.scheduling.ResourceTableJob.execute(ResourceTableJob.java:59) ~[dhis-service-analytics-2.40.1.jar:?]
at org.hisp.dhis.scheduling.AbstractSchedulingManager.execute(AbstractSchedulingManager.java:292) ~[dhis-service-core-2.40.1.jar:?]
at org.hisp.dhis.scheduling.DefaultSchedulingManager.lambda$executeNow$6(DefaultSchedulingManager.java:201) ~[dhis-service-core-2.40.1.jar:?]
at org.glowroot.agent.plugin.executor.RunnableWrapper.run(RunnableWrapper.java:35) [?:0.13.6]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) [?:?]
at java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?]
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) [spring-context-5.3.29.jar:5.3.29]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) [?:?]
at java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:304) [?:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]
at java.lang.Thread.run(Thread.java:829) [?:?]
* ERROR 2023-10-17T10:00:19,736 Resource tables generation: null (NotificationLoggerUtil.java [taskScheduler-11]) UID:GzLhesyvifP
* ERROR 2023-10-17T10:00:19,737 Process failed: java.util.concurrent.CancellationException (NotificationLoggerUtil.java [taskScheduler-11]) UID:GzLhesyvifP
* ERROR 2023-10-17T10:00:19,737 Job failed: ‘inMemoryResourceTableJob’ (AbstractSchedulingManager.java [taskScheduler-11]) UID:GzLhesyvifP
java.util.concurrent.CancellationException: null
at org.hisp.dhis.scheduling.ControlledJobProgress.startingStage(ControlledJobProgress.java:180) ~[dhis-service-core-2.40.1.jar:?]
at org.hisp.dhis.resourcetable.DefaultResourceTableService.createAllSqlViews(DefaultResourceTableService.java:232) ~[dhis-service-administration-2.40.1.jar:?]
at jdk.internal.reflect.GeneratedMethodAccessor3510.invoke(Unknown Source) ~[?:?]
at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344) ~[spring-aop-5.3.29.jar:5.3.29]
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:234) ~[spring-aop-5.3.29.jar:5.3.29]
at com.sun.proxy.$Proxy370.createAllSqlViews(Unknown Source) ~[?:?]
at org.hisp.dhis.analytics.table.DefaultAnalyticsTableGenerator.generateResourceTablesInternal(DefaultAnalyticsTableGenerator.java:184) ~[dhis-service-analytics-2.40.1.jar:?]
at org.hisp.dhis.analytics.table.DefaultAnalyticsTableGenerator.generateResourceTables(DefaultAnalyticsTableGenerator.java:138) ~[dhis-service-analytics-2.40.1.jar:?]
at org.hisp.dhis.analytics.table.scheduling.ResourceTableJob.execute(ResourceTableJob.java:59) ~[dhis-service-analytics-2.40.1.jar:?]
at org.hisp.dhis.scheduling.AbstractSchedulingManager.execute(AbstractSchedulingManager.java:292) ~[dhis-service-core-2.40.1.jar:?]
at org.hisp.dhis.scheduling.DefaultSchedulingManager.lambda$executeNow$6(DefaultSchedulingManager.java:201) ~[dhis-service-core-2.40.1.jar:?]
at org.glowroot.agent.plugin.executor.RunnableWrapper.run(RunnableWrapper.java:35) [?:0.13.6]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) [?:?]
at java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?]
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) [spring-context-5.3.29.jar:5.3.29]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) [?:?]
at java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:304) [?:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]
at java.lang.Thread.run(Thread.java:829) [?:?]
* ERROR 2023-10-17T10:00:19,745 java.util.concurrent.CancellationException
at org.hisp.dhis.scheduling.ControlledJobProgress.startingStage(ControlledJobProgress.java:180)
at org.hisp.dhis.resourcetable.DefaultResourceTableService.createAllSqlViews(DefaultResourceTableService.java:232)
at jdk.internal.reflect.GeneratedMethodAccessor3510.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:234)
at com.sun.proxy.$Proxy370.createAllSqlViews(Unknown Source)
at org.hisp.dhis.analytics.table.DefaultAnalyticsTableGenerator.generateResourceTablesInternal(DefaultAnalyticsTableGenerator.java:184)
at org.hisp.dhis.analytics.table.DefaultAnalyticsTableGenerator.generateResourceTables(DefaultAnalyticsTableGenerator.java:138)
at org.hisp.dhis.analytics.table.scheduling.ResourceTableJob.execute(ResourceTableJob.java:59)
at org.hisp.dhis.scheduling.AbstractSchedulingManager.execute(AbstractSchedulingManager.java:292)
at org.hisp.dhis.scheduling.DefaultSchedulingManager.lambda$executeNow$6(DefaultSchedulingManager.java:201)
at org.glowroot.agent.plugin.executor.RunnableWrapper.run(RunnableWrapper.java:35)
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:304)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.base/java.lang.Thread.run(Thread.java:829)
(AbstractSchedulingManager.java [taskScheduler-11]) UID:GzLhesyvifP

ifeanyiokoye · 18 October 2023 14:02

@Gassim @Gerald_Thomas Do you know if there has been a definitive fix for this issue?

Gerald_Thomas · 18 October 2023 14:31

Could you please reach out to me at gerald17006@gmail.com or through WhatsApp or Telegram at +23276710495? Let’s collaborate to resolve this issue.

ifeanyiokoye · 19 October 2023 11:33

“1300-02-29 23:59:44+02” This is the value causing the problem from your error log.

I have a similar error in my logs as well. This time the date is “0200-02-29”

The interesting thing is that this issue does not arise until you upgrade to 2.40

Don’t know how this can be resolved. @dhis2-analytics @dhis2-backend

@Gerald_Thomas is providing some guidance that we are currently trying to see if that will help resolve this. Fingers crossed.

mutali · 20 October 2023 07:59

Hi @ifeanyiokoye ,
I had a similar issue like yours and was solved by following the steps here [DHIS2-15573] - Jira but mine is different this time.