(Scheduling) _dateperiodstructure_temp does not exist

Support - Assistance technique
1
···

This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please notify us immediately by reply e-mail and delete this message from your system.

Dear all

I’m getting the error below after the scheduled run of analytics. Does somebody know what the cause is?
I’ve performed maintenance and have rerun resource tables, but still getting the error once per day.

2.24 23577

Thanks,
David

  • INFO 2016-08-30 00:00:00,448 Create table SQL: CREATE TABLE _periodstructure_temp (periodid INTEGER NOT NULL PRIMARY KEY, iso VARCHAR(15) NOT NULL, daysno INTEGER NOT NULL, “daily” VARCHAR(15), “weekly” VARCHAR(15), “monthly” VARCHAR(15), “bimonthly” VARCHAR(15), “quarterly” VARCHAR(15), “sixmonthly” VARCHAR(15), “sixmonthlyapril” VARCHAR(15), “yearly” VARCHAR(15), “financialapril” VARCHAR(15), “financialjuly” VARCHAR(15), “financialoct” VARCHAR(15)) (JdbcResourceTableStore.java [taskScheduler-2])
  • INFO 2016-08-30 00:00:00,452 Populate table content rows: 4 (JdbcResourceTableStore.java [taskScheduler-2])
  • INFO 2016-08-30 00:00:00,453 Create index SQL: create unique index in_periodstructure_iso_TNIGg on _periodstructure_temp(iso) (JdbcResourceTableStore.java [taskScheduler-2])
  • INFO 2016-08-30 00:00:00,459 Swapped resource table, done: _periodstructure in: 00:00:00.018 (JdbcResourceTableStore.java [taskScheduler-2])
  • INFO 2016-08-30 00:00:00,487 Create index SQL: create unique index in_dataelementstructure_dataelementuid_AvU13 on _dataelementstructure_temp(dataelementuid); (JdbcResourceTableStore.java [taskScheduler-1])
  • INFO 2016-08-30 00:00:00,491 Create index SQL: create index in_dataelementstructure_datasetid_d9Bcn on _dataelementstructure_temp(datasetid); (JdbcResourceTableStore.java [taskScheduler-1])
  • INFO 2016-08-30 00:00:00,494 Create index SQL: create index in_dataelementstructure_datasetuid_EAZ0O on _dataelementstructure_temp(datasetuid); (JdbcResourceTableStore.java [taskScheduler-1])
  • INFO 2016-08-30 00:00:00,499 Create index SQL: create index in_dataelementstructure_periodtypeid_thGJu on _dataelementstructure_temp(periodtypeid); (JdbcResourceTableStore.java [taskScheduler-1])
  • INFO 2016-08-30 00:00:00,502 Create index SQL: create index in_dataelementstructure_workflowid_jemUR on _dataelementstructure_temp(workflowid); (JdbcResourceTableStore.java [taskScheduler-1])
  • INFO 2016-08-30 00:00:00,507 Swapped resource table, done: _dataelementstructure in: 00:00:00.276 (JdbcResourceTableStore.java [taskScheduler-1])
  • INFO 2016-08-30 00:00:00,519 Create table SQL: CREATE TABLE _periodstructure_temp (periodid INTEGER NOT NULL PRIMARY KEY, iso VARCHAR(15) NOT NULL, daysno INTEGER NOT NULL, “daily” VARCHAR(15), “weekly” VARCHAR(15), “monthly” VARCHAR(15), “bimonthly” VARCHAR(15), “quarterly” VARCHAR(15), “sixmonthly” VARCHAR(15), “sixmonthlyapril” VARCHAR(15), “yearly” VARCHAR(15), “financialapril” VARCHAR(15), “financialjuly” VARCHAR(15), “financialoct” VARCHAR(15)) (JdbcResourceTableStore.java [taskScheduler-1])
  • INFO 2016-08-30 00:00:00,522 Populate table content rows: 4 (JdbcResourceTableStore.java [taskScheduler-1])
  • INFO 2016-08-30 00:00:00,523 Create index SQL: create unique index in_periodstructure_iso_h3a9y on _periodstructure_temp(iso) (JdbcResourceTableStore.java [taskScheduler-1])
  • INFO 2016-08-30 00:00:00,526 Swapped resource table, done: _periodstructure in: 00:00:00.008 (JdbcResourceTableStore.java [taskScheduler-1])
  • INFO 2016-08-30 00:00:05,916 Create table SQL: create table _dateperiodstructure_temp (dateperiod date not null primary key, “daily” varchar(15), “weekly” varchar(15), “monthly” varchar(15), “bimonthly” varchar(15), “quarterly” varchar(15), “sixmonthly” varchar(15), “sixmonthlyapril” varchar(15), “yearly” varchar(15), “financialapril” varchar(15), “financialjuly” varchar(15), “financialoct” varchar(15)) (JdbcResourceTableStore.java [taskScheduler-2])
  • INFO 2016-08-30 00:00:05,919 Populate table content rows: 18263 (JdbcResourceTableStore.java [taskScheduler-2])
  • INFO 2016-08-30 00:00:06,780 ‘system-process’ create org.hisp.dhis.message.MessageConversation, name: Analytics table process failed, uid: z4M49mzFKXM (AuditLogUtil.java [taskScheduler-2])
  • INFO 2016-08-30 00:00:06,786 Sending email to user: null with email address: post@gmail.com to host: smtp.gmail.com:587 (EmailMessageSender.java [taskScheduler-7])
  • INFO 2016-08-30 00:00:06,780 Create table SQL: create table _dateperiodstructure_temp (dateperiod date not null primary key, “daily” varchar(15), “weekly” varchar(15), “monthly” varchar(15), “bimonthly” varchar(15), “quarterly” varchar(15), “sixmonthly” varchar(15), “sixmonthlyapril” varchar(15), “yearly” varchar(15), “financialapril” varchar(15), “financialjuly” varchar(15), “financialoct” varchar(15)) (JdbcResourceTableStore.java [taskScheduler-1])
  • INFO 2016-08-30 00:00:06,794 Populate table content rows: 18263 (JdbcResourceTableStore.java [taskScheduler-1])
  • INFO 2016-08-30 00:00:06,807 Message failed: (SmsMessageSender.java [taskScheduler-2])
  • INFO 2016-08-30 00:00:06,808 Failure cause: no gateway is set to default (SmsMessageSender.java [taskScheduler-2])
  • ERROR 2016-08-30 00:00:06,811 Unexpected error occurred in scheduled task. (TaskUtils.java [taskScheduler-2])
    org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [insert into _dateperiodstructure_temp values (?,?,?,?,?,?,?,?,?,?,?,?)]; nested exception is org.postgresql.util.PSQLException: ERROR: relation “_dateperiodstructure_temp” does not exist
    Position: 13
    at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231)
    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:645)
    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:658)
    at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:946)
    at org.springframework.jdbc.core.BatchUpdateUtils.executeBatchUpdate(BatchUpdateUtils.java:32)
    at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:996)
    at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:991)
    at org.hisp.dhis.resourcetable.jdbc.JdbcResourceTableStore.batchUpdate(JdbcResourceTableStore.java:163)
    at org.hisp.dhis.resourcetable.jdbc.JdbcResourceTableStore.generateResourceTable(JdbcResourceTableStore.java:117)
    at org.hisp.dhis.resourcetable.DefaultResourceTableService.generateDatePeriodTable(DefaultResourceTableService.java:224)
    at sun.reflect.GeneratedMethodAccessor797.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:302)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
    at com.sun.proxy.$Proxy163.generateDatePeriodTable(Unknown Source)
    at org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.generateResourceTables(DefaultAnalyticsTableService.java:182)
    at org.hisp.dhis.analytics.table.scheduling.AnalyticsTableTask.call(AnalyticsTableTask.java:137)
    at org.hisp.dhis.security.NoSecurityContextRunnable.run(NoSecurityContextRunnable.java:47)
    at org.hisp.dhis.scheduling.ScheduledTasks.run(ScheduledTasks.java:60)
    at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
    at org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:81)
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
    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)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    at java.lang.Thread.run(Thread.java:745)
    Caused by: org.postgresql.util.PSQLException: ERROR: relation “_dateperiodstructure_temp” does not exist
    Position: 13
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2284)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2003)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:360)
    at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:1019)
    at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
    at org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:962)
    at org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:946)
    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:629)
    … 27 more