[Bug 1523882] [NEW] Getting exception when upgraded application from Version 2.16 to 2.21 with Mysql dataase

Public bug reported:

Dear All,

We recently upgraded DHIS 2.16 to 2.21 where database is Mysql some of
the errors are listed below.(We are using aggregated data not tracker)

Basically we are getting 3 errors
- Error1: In mysql programrule table is not created automatically

- Error2: While generating resource tables got the error, think the
query should be DROP TABLE IF EXISTS orgunitstructure; Same applies for
all resource tables.

- Error3: Tried to copy resource table structures from old db and tried
generate resource table option, this time got the error:

The details of errors are given below.

While upgrading we ran all the sql update scripts.

Error1:
In mysql programrule table is not created automatically. While starting getting the below error:

* ERROR 2015-12-07 17:36:56,864 Problem updating: programrule, id column: programruleid (IdentityPopulator.java [localho
st-startStop-1])
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * from programrule WHERE uid
IS NULL]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'dhis.programrule'
doesn't exist
        at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTrans
lator.java:231)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptio
nTranslator.java:73)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:471)
        at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:526)
        at org.hisp.dhis.common.IdentityPopulator.execute(IdentityPopulator.java:86)
        at org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:117)
        at org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:86)
        at org.hisp.dhis.system.startup.StartupListener.contextInitialized(StartupListener.java:71)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4729)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5167)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:945)
        at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1768)
        at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
        at java.util.concurrent.FutureTask.run(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'dhis.programrule' doesn't exist
        at sun.reflect.GeneratedConstructorAccessor53.newInstance(Unknown Source)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
        at java.lang.reflect.Constructor.newInstance(Unknown Source)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
        at com.mysql.jdbc.Util.getInstance(Util.java:360)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
        at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1446)
        at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35)
        at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:455)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:405)
        ... 19 more
* INFO 2015-12-07 17:36:57,144 Executing startup routine [6 of 13, runlevel 5]: TableCreator (DefaultStartupRoutineExec
utor.java [localhost-startStop-1])

···

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Error2: While generating resource tables got the below error, think the
query should be DROP TABLE IF EXISTS _orgunitstructure; Same applies
for all resource tables.

* INFO 2015-12-07 17:41:06,417 [Level: INFO, category: RESOURCETABLE_UPDATE, time: Mon Dec 07 17:41:06 IST 2015, messag
e: Generating resource tables] (InMemoryNotifier.java [taskScheduler-1])
* INFO 2015-12-07 17:41:06,465 Create table SQL: create table _orgunitstructure_temp (organisationunitid integer not nu
ll primary key, organisationunituid character(11), level integer, `idlevel1` integer, `uidlevel1` character(11), `idleve
l2` integer, `uidlevel2` character(11), `idlevel3` integer, `uidlevel3` character(11)); (JdbcResourceTableStore.java [ta
skScheduler-1])
* INFO 2015-12-07 17:41:06,495 Populate table content rows: 203 (JdbcResourceTableStore.java [taskScheduler-1])
* INFO 2015-12-07 17:41:06,546 Create index SQL: create unique index in_orgunitstructure_organisationunituid_VWU2G on _
orgunitstructure_temp(organisationunituid) (JdbcResourceTableStore.java [taskScheduler-1])
* INFO 2015-12-07 17:41:06,582 [Level: ERROR, category: RESOURCETABLE_UPDATE, time: Mon Dec 07 17:41:06 IST 2015, messa
ge: Process failed: StatementCallback; bad SQL grammar [drop table _orgunitstructure;]; nested exception is com.mysql.jd
bc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'dhis._orgunitstructure'] (InMemoryNotifier.java [tas
kScheduler-1])

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Error3: Tried to copy resource table structures from old db and tried
generate resource table option, this time got the below error:

* INFO 2015-12-07 18:05:19,296 [Level: ERROR, category: RESOURCETABLE_UPDATE, time: Mon Dec 07 18:05:19 IST 2015, messa
ge: Process failed: StatementCallback; bad SQL grammar [create unique index in_dataelementstructure_dataelementuid_M86c6
on _dataelementstructure_temp(dataelementuid);create index in_dataelementstructure_datasetid_fVMFF on _dataelementstruc
ture_temp(datasetid);create index in_dataelementstructure_datasetuid_nsdEu on _dataelementstructure_temp(datasetuid);cre
ate index in_dataelementstructure_periodtypeid_EkjZg on _dataelementstructure_temp(periodtypeid);]; nested exception is
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that c
orresponds to your MySQL server version for the right syntax to use near 'create index in_dataelementstructure_datasetid
_fVMFF on _dataelementstructure_te' at line 1] (InMemoryNotifier.java [taskScheduler-5])
* ERROR 2015-12-07 18:05:19,319 Unexpected error occurred in scheduled task. (TaskUtils.java [taskScheduler-5])
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [create unique index in_dataelements
tructure_dataelementuid_M86c6 on _dataelementstructure_temp(dataelementuid);create index in_dataelementstructure_dataset
id_fVMFF on _dataelementstructure_temp(datasetid);create index in_dataelementstructure_datasetuid_nsdEu on _dataelements
tructure_temp(datasetuid);create index in_dataelementstructure_periodtypeid_EkjZg on _dataelementstructure_temp(periodty
peid);]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL sy
ntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'create index in_d
ataelementstructure_datasetid_fVMFF on _dataelementstructure_te' at line 1
        at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTrans
lator.java:231)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptio
nTranslator.java:73)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:440)
        at org.hisp.dhis.resourcetable.jdbc.JdbcResourceTableStore.generateResourceTable(JdbcResourceTableStore.java:118
)
        at org.hisp.dhis.resourcetable.DefaultResourceTableService.generateDataElementTable(DefaultResourceTableService.
java:198)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:
190)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
        at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterce
ptor.java:99)
        at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspec
tSupport.java:281)
        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
        at com.sun.proxy.$Proxy143.generateDataElementTable(Unknown Source)
        at org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.generateAll(ResourceTableTask.java:121)
        at org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.run(ResourceTableTask.java:84)
        at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.ja
va:54)
        at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
        at java.util.concurrent.FutureTask.run(Unknown Source)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown Source)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the ma
nual that corresponds to your MySQL server version for the right syntax to use near 'create index in_dataelementstructur
e_datasetid_fVMFF on _dataelementstructure_te' at line 1
        at sun.reflect.GeneratedConstructorAccessor53.newInstance(Unknown Source)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
        at java.lang.reflect.Constructor.newInstance(Unknown Source)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
        at com.mysql.jdbc.Util.getInstance(Util.java:360)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
        at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:848)
        at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:742)
        at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:1006)
        at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:432)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:405)
        ... 26 more

** Affects: dhis2
     Importance: Undecided
         Status: New

--
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1523882

Title:
  Getting exception when upgraded application from Version 2.16 to 2.21
  with Mysql dataase

Status in DHIS:
  New

Bug description:
  Dear All,

  We recently upgraded DHIS 2.16 to 2.21 where database is Mysql some of
  the errors are listed below.(We are using aggregated data not tracker)

  Basically we are getting 3 errors
  - Error1: In mysql programrule table is not created automatically

  - Error2: While generating resource tables got the error, think the
  query should be DROP TABLE IF EXISTS orgunitstructure; Same applies
  for all resource tables.

  - Error3: Tried to copy resource table structures from old db and
  tried generate resource table option, this time got the error:

  The details of errors are given below.

  While upgrading we ran all the sql update scripts.

  Error1:
  In mysql programrule table is not created automatically. While starting getting the below error:

  * ERROR 2015-12-07 17:36:56,864 Problem updating: programrule, id column: programruleid (IdentityPopulator.java [localho
  st-startStop-1])
  org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * from programrule WHERE uid
   IS NULL]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'dhis.programrule'
   doesn't exist
          at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTrans
  lator.java:231)
          at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptio
  nTranslator.java:73)
          at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416)
          at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:471)
          at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:526)
          at org.hisp.dhis.common.IdentityPopulator.execute(IdentityPopulator.java:86)
          at org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:117)
          at org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:86)
          at org.hisp.dhis.system.startup.StartupListener.contextInitialized(StartupListener.java:71)
          at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4729)
          at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5167)
          at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
          at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)
          at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)
          at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
          at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:945)
          at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1768)
          at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
          at java.util.concurrent.FutureTask.run(Unknown Source)
          at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
          at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
          at java.lang.Thread.run(Unknown Source)
  Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'dhis.programrule' doesn't exist
          at sun.reflect.GeneratedConstructorAccessor53.newInstance(Unknown Source)
          at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
          at java.lang.reflect.Constructor.newInstance(Unknown Source)
          at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
          at com.mysql.jdbc.Util.getInstance(Util.java:360)
          at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978)
          at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
          at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
          at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
          at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
          at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)
          at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
          at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1446)
          at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35)
          at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:455)
          at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:405)
          ... 19 more
  * INFO 2015-12-07 17:36:57,144 Executing startup routine [6 of 13, runlevel 5]: TableCreator (DefaultStartupRoutineExec
  utor.java [localhost-startStop-1])

  ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

  Error2: While generating resource tables got the below error, think
  the query should be DROP TABLE IF EXISTS _orgunitstructure; Same
  applies for all resource tables.

  * INFO 2015-12-07 17:41:06,417 [Level: INFO, category: RESOURCETABLE_UPDATE, time: Mon Dec 07 17:41:06 IST 2015, messag
  e: Generating resource tables] (InMemoryNotifier.java [taskScheduler-1])
  * INFO 2015-12-07 17:41:06,465 Create table SQL: create table _orgunitstructure_temp (organisationunitid integer not nu
  ll primary key, organisationunituid character(11), level integer, `idlevel1` integer, `uidlevel1` character(11), `idleve
  l2` integer, `uidlevel2` character(11), `idlevel3` integer, `uidlevel3` character(11)); (JdbcResourceTableStore.java [ta
  skScheduler-1])
  * INFO 2015-12-07 17:41:06,495 Populate table content rows: 203 (JdbcResourceTableStore.java [taskScheduler-1])
  * INFO 2015-12-07 17:41:06,546 Create index SQL: create unique index in_orgunitstructure_organisationunituid_VWU2G on _
  orgunitstructure_temp(organisationunituid) (JdbcResourceTableStore.java [taskScheduler-1])
  * INFO 2015-12-07 17:41:06,582 [Level: ERROR, category: RESOURCETABLE_UPDATE, time: Mon Dec 07 17:41:06 IST 2015, messa
  ge: Process failed: StatementCallback; bad SQL grammar [drop table _orgunitstructure;]; nested exception is com.mysql.jd
  bc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'dhis._orgunitstructure'] (InMemoryNotifier.java [tas
  kScheduler-1])

  ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

  Error3: Tried to copy resource table structures from old db and tried
  generate resource table option, this time got the below error:

  * INFO 2015-12-07 18:05:19,296 [Level: ERROR, category: RESOURCETABLE_UPDATE, time: Mon Dec 07 18:05:19 IST 2015, messa
  ge: Process failed: StatementCallback; bad SQL grammar [create unique index in_dataelementstructure_dataelementuid_M86c6
   on _dataelementstructure_temp(dataelementuid);create index in_dataelementstructure_datasetid_fVMFF on _dataelementstruc
  ture_temp(datasetid);create index in_dataelementstructure_datasetuid_nsdEu on _dataelementstructure_temp(datasetuid);cre
  ate index in_dataelementstructure_periodtypeid_EkjZg on _dataelementstructure_temp(periodtypeid);]; nested exception is
  com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that c
  orresponds to your MySQL server version for the right syntax to use near 'create index in_dataelementstructure_datasetid
  _fVMFF on _dataelementstructure_te' at line 1] (InMemoryNotifier.java [taskScheduler-5])
  * ERROR 2015-12-07 18:05:19,319 Unexpected error occurred in scheduled task. (TaskUtils.java [taskScheduler-5])
  org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [create unique index in_dataelements
  tructure_dataelementuid_M86c6 on _dataelementstructure_temp(dataelementuid);create index in_dataelementstructure_dataset
  id_fVMFF on _dataelementstructure_temp(datasetid);create index in_dataelementstructure_datasetuid_nsdEu on _dataelements
  tructure_temp(datasetuid);create index in_dataelementstructure_periodtypeid_EkjZg on _dataelementstructure_temp(periodty
  peid);]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL sy
  ntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'create index in_d
  ataelementstructure_datasetid_fVMFF on _dataelementstructure_te' at line 1
          at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTrans
  lator.java:231)
          at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptio
  nTranslator.java:73)
          at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416)
          at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:440)
          at org.hisp.dhis.resourcetable.jdbc.JdbcResourceTableStore.generateResourceTable(JdbcResourceTableStore.java:118
  )
          at org.hisp.dhis.resourcetable.DefaultResourceTableService.generateDataElementTable(DefaultResourceTableService.
  java:198)
          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
          at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
          at java.lang.reflect.Method.invoke(Unknown Source)
          at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:
  190)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
          at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterce
  ptor.java:99)
          at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspec
  tSupport.java:281)
          at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
          at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
          at com.sun.proxy.$Proxy143.generateDataElementTable(Unknown Source)
          at org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.generateAll(ResourceTableTask.java:121)
          at org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.run(ResourceTableTask.java:84)
          at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.ja
  va:54)
          at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
          at java.util.concurrent.FutureTask.run(Unknown Source)
          at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown Source)
          at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
          at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
          at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
          at java.lang.Thread.run(Unknown Source)
  Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the ma
  nual that corresponds to your MySQL server version for the right syntax to use near 'create index in_dataelementstructur
  e_datasetid_fVMFF on _dataelementstructure_te' at line 1
          at sun.reflect.GeneratedConstructorAccessor53.newInstance(Unknown Source)
          at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
          at java.lang.reflect.Constructor.newInstance(Unknown Source)
          at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
          at com.mysql.jdbc.Util.getInstance(Util.java:360)
          at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978)
          at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
          at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
          at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
          at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
          at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)
          at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
          at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:848)
          at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:742)
          at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:1006)
          at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:432)
          at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:405)
          ... 26 more

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1523882/+subscriptions

Hellow Neeraj,
With such a huge leap between version, I recommend, before deploying 2.21 on the 2.16 database, you go through upgrade notes between each version and effect all database changes step wise.

i.e.

From 2.16 to 2.17 you can visit:

https://www.dhis2.org/217-upgrade

From 2.17 to 2.18 and above, the upgrade notes are are available on https://www.dhis2.org/downloads

Goodluck.

···

--
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1523882

Title:
  Getting exception when upgraded application from Version 2.16 to 2.21
  with Mysql dataase

Status in DHIS:
  New

Bug description:
  Dear All,

  We recently upgraded DHIS 2.16 to 2.21 where database is Mysql some of
  the errors are listed below.(We are using aggregated data not tracker)

  Basically we are getting 3 errors
  - Error1: In mysql programrule table is not created automatically

  - Error2: While generating resource tables got the error, think the
  query should be DROP TABLE IF EXISTS orgunitstructure; Same applies
  for all resource tables.

  - Error3: Tried to copy resource table structures from old db and
  tried generate resource table option, this time got the error:

  The details of errors are given below.

  While upgrading we ran all the sql update scripts.

  Error1:
  In mysql programrule table is not created automatically. While starting getting the below error:

  * ERROR 2015-12-07 17:36:56,864 Problem updating: programrule, id column: programruleid (IdentityPopulator.java [localho
  st-startStop-1])
  org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * from programrule WHERE uid
   IS NULL]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'dhis.programrule'
   doesn't exist
          at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTrans
  lator.java:231)
          at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptio
  nTranslator.java:73)
          at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416)
          at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:471)
          at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:526)
          at org.hisp.dhis.common.IdentityPopulator.execute(IdentityPopulator.java:86)
          at org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:117)
          at org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:86)
          at org.hisp.dhis.system.startup.StartupListener.contextInitialized(StartupListener.java:71)
          at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4729)
          at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5167)
          at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
          at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)
          at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)
          at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
          at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:945)
          at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1768)
          at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
          at java.util.concurrent.FutureTask.run(Unknown Source)
          at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
          at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
          at java.lang.Thread.run(Unknown Source)
  Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'dhis.programrule' doesn't exist
          at sun.reflect.GeneratedConstructorAccessor53.newInstance(Unknown Source)
          at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
          at java.lang.reflect.Constructor.newInstance(Unknown Source)
          at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
          at com.mysql.jdbc.Util.getInstance(Util.java:360)
          at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978)
          at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
          at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
          at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
          at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
          at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)
          at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
          at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1446)
          at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35)
          at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:455)
          at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:405)
          ... 19 more
  * INFO 2015-12-07 17:36:57,144 Executing startup routine [6 of 13, runlevel 5]: TableCreator (DefaultStartupRoutineExec
  utor.java [localhost-startStop-1])

  ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

  Error2: While generating resource tables got the below error, think
  the query should be DROP TABLE IF EXISTS _orgunitstructure; Same
  applies for all resource tables.

  * INFO 2015-12-07 17:41:06,417 [Level: INFO, category: RESOURCETABLE_UPDATE, time: Mon Dec 07 17:41:06 IST 2015, messag
  e: Generating resource tables] (InMemoryNotifier.java [taskScheduler-1])
  * INFO 2015-12-07 17:41:06,465 Create table SQL: create table _orgunitstructure_temp (organisationunitid integer not nu
  ll primary key, organisationunituid character(11), level integer, `idlevel1` integer, `uidlevel1` character(11), `idleve
  l2` integer, `uidlevel2` character(11), `idlevel3` integer, `uidlevel3` character(11)); (JdbcResourceTableStore.java [ta
  skScheduler-1])
  * INFO 2015-12-07 17:41:06,495 Populate table content rows: 203 (JdbcResourceTableStore.java [taskScheduler-1])
  * INFO 2015-12-07 17:41:06,546 Create index SQL: create unique index in_orgunitstructure_organisationunituid_VWU2G on _
  orgunitstructure_temp(organisationunituid) (JdbcResourceTableStore.java [taskScheduler-1])
  * INFO 2015-12-07 17:41:06,582 [Level: ERROR, category: RESOURCETABLE_UPDATE, time: Mon Dec 07 17:41:06 IST 2015, messa
  ge: Process failed: StatementCallback; bad SQL grammar [drop table _orgunitstructure;]; nested exception is com.mysql.jd
  bc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'dhis._orgunitstructure'] (InMemoryNotifier.java [tas
  kScheduler-1])

  ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

  Error3: Tried to copy resource table structures from old db and tried
  generate resource table option, this time got the below error:

  * INFO 2015-12-07 18:05:19,296 [Level: ERROR, category: RESOURCETABLE_UPDATE, time: Mon Dec 07 18:05:19 IST 2015, messa
  ge: Process failed: StatementCallback; bad SQL grammar [create unique index in_dataelementstructure_dataelementuid_M86c6
   on _dataelementstructure_temp(dataelementuid);create index in_dataelementstructure_datasetid_fVMFF on _dataelementstruc
  ture_temp(datasetid);create index in_dataelementstructure_datasetuid_nsdEu on _dataelementstructure_temp(datasetuid);cre
  ate index in_dataelementstructure_periodtypeid_EkjZg on _dataelementstructure_temp(periodtypeid);]; nested exception is
  com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that c
  orresponds to your MySQL server version for the right syntax to use near 'create index in_dataelementstructure_datasetid
  _fVMFF on _dataelementstructure_te' at line 1] (InMemoryNotifier.java [taskScheduler-5])
  * ERROR 2015-12-07 18:05:19,319 Unexpected error occurred in scheduled task. (TaskUtils.java [taskScheduler-5])
  org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [create unique index in_dataelements
  tructure_dataelementuid_M86c6 on _dataelementstructure_temp(dataelementuid);create index in_dataelementstructure_dataset
  id_fVMFF on _dataelementstructure_temp(datasetid);create index in_dataelementstructure_datasetuid_nsdEu on _dataelements
  tructure_temp(datasetuid);create index in_dataelementstructure_periodtypeid_EkjZg on _dataelementstructure_temp(periodty
  peid);]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL sy
  ntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'create index in_d
  ataelementstructure_datasetid_fVMFF on _dataelementstructure_te' at line 1
          at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTrans
  lator.java:231)
          at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptio
  nTranslator.java:73)
          at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416)
          at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:440)
          at org.hisp.dhis.resourcetable.jdbc.JdbcResourceTableStore.generateResourceTable(JdbcResourceTableStore.java:118
  )
          at org.hisp.dhis.resourcetable.DefaultResourceTableService.generateDataElementTable(DefaultResourceTableService.
  java:198)
          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
          at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
          at java.lang.reflect.Method.invoke(Unknown Source)
          at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:
  190)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
          at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterce
  ptor.java:99)
          at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspec
  tSupport.java:281)
          at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
          at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
          at com.sun.proxy.$Proxy143.generateDataElementTable(Unknown Source)
          at org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.generateAll(ResourceTableTask.java:121)
          at org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.run(ResourceTableTask.java:84)
          at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.ja
  va:54)
          at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
          at java.util.concurrent.FutureTask.run(Unknown Source)
          at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown Source)
          at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
          at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
          at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
          at java.lang.Thread.run(Unknown Source)
  Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the ma
  nual that corresponds to your MySQL server version for the right syntax to use near 'create index in_dataelementstructur
  e_datasetid_fVMFF on _dataelementstructure_te' at line 1
          at sun.reflect.GeneratedConstructorAccessor53.newInstance(Unknown Source)
          at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
          at java.lang.reflect.Constructor.newInstance(Unknown Source)
          at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
          at com.mysql.jdbc.Util.getInstance(Util.java:360)
          at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978)
          at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
          at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
          at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
          at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
          at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)
          at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
          at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:848)
          at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:742)
          at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:1006)
          at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:432)
          at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:405)
          ... 26 more

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1523882/+subscriptions

Thanks John,

Will go through these notes and try to update.

···

On Tue, Dec 8, 2015 at 9:21 PM, John Francis Mukulu < 1523882@bugs.launchpad.net> wrote:

Hellow Neeraj,
With such a huge leap between version, I recommend, before deploying 2.21
on the 2.16 database, you go through upgrade notes between each version
and effect all database changes step wise.

i.e.
>From 2.16 to 2.17 you can visit:
https://www.dhis2.org/217-upgrade

>From 2.17 to 2.18 and above, the upgrade notes are are available on
https://www.dhis2.org/downloads
Goodluck.

--
You received this bug notification because you are subscribed to the bug
report.
https://bugs.launchpad.net/bugs/1523882

Title:
  Getting exception when upgraded application from Version 2.16 to 2.21
  with Mysql dataase

Status in DHIS:
  New

Bug description:
  Dear All,

  We recently upgraded DHIS 2.16 to 2.21 where database is Mysql some of
  the errors are listed below.(We are using aggregated data not tracker)

  Basically we are getting 3 errors
  - Error1: In mysql programrule table is not created automatically

  - Error2: While generating resource tables got the error, think the
  query should be DROP TABLE IF EXISTS orgunitstructure; Same applies
  for all resource tables.

  - Error3: Tried to copy resource table structures from old db and
  tried generate resource table option, this time got the error:

  The details of errors are given below.

  While upgrading we ran all the sql update scripts.

  Error1:
  In mysql programrule table is not created automatically. While starting
getting the below error:

  * ERROR 2015-12-07 17:36:56,864 Problem updating: programrule, id
column: programruleid (IdentityPopulator.java [localho
  st-startStop-1])
  org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad
SQL grammar [SELECT * from programrule WHERE uid
   IS NULL]; nested exception is
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
'dhis.programrule'
   doesn't exist
          at
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTrans
  lator.java:231)
          at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptio
  nTranslator.java:73)
          at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416)
          at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:471)
          at
org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:526)
          at
org.hisp.dhis.common.IdentityPopulator.execute(IdentityPopulator.java:86)
          at
org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:117)
          at
org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:86)
          at
org.hisp.dhis.system.startup.StartupListener.contextInitialized(StartupListener.java:71)
          at
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4729)
          at
org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5167)
          at
org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
          at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)
          at
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)
          at
org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
          at
org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:945)
          at
org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1768)
          at java.util.concurrent.Executors$RunnableAdapter.call(Unknown
Source)
          at java.util.concurrent.FutureTask.run(Unknown Source)
          at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown
Source)
          at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown
Source)
          at java.lang.Thread.run(Unknown Source)
  Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
Table 'dhis.programrule' doesn't exist
          at
sun.reflect.GeneratedConstructorAccessor53.newInstance(Unknown Source)
          at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
          at java.lang.reflect.Constructor.newInstance(Unknown Source)
          at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
          at com.mysql.jdbc.Util.getInstance(Util.java:360)
          at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978)
          at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
          at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
          at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
          at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
          at
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)
          at
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
          at
com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1446)
          at
com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35)
          at
org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:455)
          at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:405)
          ... 19 more
  * INFO 2015-12-07 17:36:57,144 Executing startup routine [6 of 13,
runlevel 5]: TableCreator (DefaultStartupRoutineExec
  utor.java [localhost-startStop-1])

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

  Error2: While generating resource tables got the below error, think
  the query should be DROP TABLE IF EXISTS _orgunitstructure; Same
  applies for all resource tables.

  * INFO 2015-12-07 17:41:06,417 [Level: INFO, category:
RESOURCETABLE_UPDATE, time: Mon Dec 07 17:41:06 IST 2015, messag
  e: Generating resource tables] (InMemoryNotifier.java [taskScheduler-1])
  * INFO 2015-12-07 17:41:06,465 Create table SQL: create table
_orgunitstructure_temp (organisationunitid integer not nu
  ll primary key, organisationunituid character(11), level integer,
`idlevel1` integer, `uidlevel1` character(11), `idleve
  l2` integer, `uidlevel2` character(11), `idlevel3` integer, `uidlevel3`
character(11)); (JdbcResourceTableStore.java [ta
  skScheduler-1])
  * INFO 2015-12-07 17:41:06,495 Populate table content rows: 203
(JdbcResourceTableStore.java [taskScheduler-1])
  * INFO 2015-12-07 17:41:06,546 Create index SQL: create unique index
in_orgunitstructure_organisationunituid_VWU2G on _
  orgunitstructure_temp(organisationunituid) (JdbcResourceTableStore.java
[taskScheduler-1])
  * INFO 2015-12-07 17:41:06,582 [Level: ERROR, category:
RESOURCETABLE_UPDATE, time: Mon Dec 07 17:41:06 IST 2015, messa
  ge: Process failed: StatementCallback; bad SQL grammar [drop table
_orgunitstructure;]; nested exception is com.mysql.jd
  bc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table
'dhis._orgunitstructure'] (InMemoryNotifier.java [tas
  kScheduler-1])

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

  Error3: Tried to copy resource table structures from old db and tried
  generate resource table option, this time got the below error:

  * INFO 2015-12-07 18:05:19,296 [Level: ERROR, category:
RESOURCETABLE_UPDATE, time: Mon Dec 07 18:05:19 IST 2015, messa
  ge: Process failed: StatementCallback; bad SQL grammar [create unique
index in_dataelementstructure_dataelementuid_M86c6
   on _dataelementstructure_temp(dataelementuid);create index
in_dataelementstructure_datasetid_fVMFF on _dataelementstruc
  ture_temp(datasetid);create index
in_dataelementstructure_datasetuid_nsdEu on
_dataelementstructure_temp(datasetuid);cre
  ate index in_dataelementstructure_periodtypeid_EkjZg on
_dataelementstructure_temp(periodtypeid);]; nested exception is
  com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an
error in your SQL syntax; check the manual that c
  orresponds to your MySQL server version for the right syntax to use near
'create index in_dataelementstructure_datasetid
  _fVMFF on _dataelementstructure_te' at line 1] (InMemoryNotifier.java
[taskScheduler-5])
  * ERROR 2015-12-07 18:05:19,319 Unexpected error occurred in scheduled
task. (TaskUtils.java [taskScheduler-5])
  org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad
SQL grammar [create unique index in_dataelements
  tructure_dataelementuid_M86c6 on
_dataelementstructure_temp(dataelementuid);create index
in_dataelementstructure_dataset
  id_fVMFF on _dataelementstructure_temp(datasetid);create index
in_dataelementstructure_datasetuid_nsdEu on _dataelements
  tructure_temp(datasetuid);create index
in_dataelementstructure_periodtypeid_EkjZg on
_dataelementstructure_temp(periodty
  peid);]; nested exception is
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an
error in your SQL sy
  ntax; check the manual that corresponds to your MySQL server version for
the right syntax to use near 'create index in_d
  ataelementstructure_datasetid_fVMFF on _dataelementstructure_te' at line
1
          at
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTrans
  lator.java:231)
          at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptio
  nTranslator.java:73)
          at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416)
          at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:440)
          at
org.hisp.dhis.resourcetable.jdbc.JdbcResourceTableStore.generateResourceTable(JdbcResourceTableStore.java:118
  )
          at
org.hisp.dhis.resourcetable.DefaultResourceTableService.generateDataElementTable(DefaultResourceTableService.
  java:198)
          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
          at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
Source)
          at java.lang.reflect.Method.invoke(Unknown Source)
          at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
          at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:
  190)
          at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
          at
org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterce
  ptor.java:99)
          at
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspec
  tSupport.java:281)
          at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
          at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
          at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
          at com.sun.proxy.$Proxy143.generateDataElementTable(Unknown
Source)
          at
org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.generateAll(ResourceTableTask.java:121)
          at
org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.run(ResourceTableTask.java:84)
          at
org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.ja
  va:54)
          at java.util.concurrent.Executors$RunnableAdapter.call(Unknown
Source)
          at java.util.concurrent.FutureTask.run(Unknown Source)
          at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown
Source)
          at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown
Source)
          at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown
Source)
          at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown
Source)
          at java.lang.Thread.run(Unknown Source)
  Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
You have an error in your SQL syntax; check the ma
  nual that corresponds to your MySQL server version for the right syntax
to use near 'create index in_dataelementstructur
  e_datasetid_fVMFF on _dataelementstructure_te' at line 1
          at
sun.reflect.GeneratedConstructorAccessor53.newInstance(Unknown Source)
          at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
          at java.lang.reflect.Constructor.newInstance(Unknown Source)
          at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
          at com.mysql.jdbc.Util.getInstance(Util.java:360)
          at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978)
          at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
          at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
          at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
          at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
          at
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)
          at
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
          at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:848)
          at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:742)
          at
com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:1006)
          at
org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:432)
          at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:405)
          ... 26 more

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1523882/+subscriptions

--
Thanks,
Neeraj Gupta

--
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1523882

Title:
  Getting exception when upgraded application from Version 2.16 to 2.21
  with Mysql dataase

Status in DHIS:
  New

Bug description:
  Dear All,

  We recently upgraded DHIS 2.16 to 2.21 where database is Mysql some of
  the errors are listed below.(We are using aggregated data not tracker)

  Basically we are getting 3 errors
  - Error1: In mysql programrule table is not created automatically

  - Error2: While generating resource tables got the error, think the
  query should be DROP TABLE IF EXISTS orgunitstructure; Same applies
  for all resource tables.

  - Error3: Tried to copy resource table structures from old db and
  tried generate resource table option, this time got the error:

  The details of errors are given below.

  While upgrading we ran all the sql update scripts.

  Error1:
  In mysql programrule table is not created automatically. While starting getting the below error:

  * ERROR 2015-12-07 17:36:56,864 Problem updating: programrule, id column: programruleid (IdentityPopulator.java [localho
  st-startStop-1])
  org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * from programrule WHERE uid
   IS NULL]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'dhis.programrule'
   doesn't exist
          at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTrans
  lator.java:231)
          at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptio
  nTranslator.java:73)
          at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416)
          at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:471)
          at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:526)
          at org.hisp.dhis.common.IdentityPopulator.execute(IdentityPopulator.java:86)
          at org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:117)
          at org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:86)
          at org.hisp.dhis.system.startup.StartupListener.contextInitialized(StartupListener.java:71)
          at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4729)
          at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5167)
          at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
          at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)
          at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)
          at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
          at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:945)
          at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1768)
          at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
          at java.util.concurrent.FutureTask.run(Unknown Source)
          at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
          at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
          at java.lang.Thread.run(Unknown Source)
  Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'dhis.programrule' doesn't exist
          at sun.reflect.GeneratedConstructorAccessor53.newInstance(Unknown Source)
          at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
          at java.lang.reflect.Constructor.newInstance(Unknown Source)
          at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
          at com.mysql.jdbc.Util.getInstance(Util.java:360)
          at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978)
          at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
          at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
          at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
          at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
          at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)
          at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
          at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1446)
          at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35)
          at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:455)
          at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:405)
          ... 19 more
  * INFO 2015-12-07 17:36:57,144 Executing startup routine [6 of 13, runlevel 5]: TableCreator (DefaultStartupRoutineExec
  utor.java [localhost-startStop-1])

  ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

  Error2: While generating resource tables got the below error, think
  the query should be DROP TABLE IF EXISTS _orgunitstructure; Same
  applies for all resource tables.

  * INFO 2015-12-07 17:41:06,417 [Level: INFO, category: RESOURCETABLE_UPDATE, time: Mon Dec 07 17:41:06 IST 2015, messag
  e: Generating resource tables] (InMemoryNotifier.java [taskScheduler-1])
  * INFO 2015-12-07 17:41:06,465 Create table SQL: create table _orgunitstructure_temp (organisationunitid integer not nu
  ll primary key, organisationunituid character(11), level integer, `idlevel1` integer, `uidlevel1` character(11), `idleve
  l2` integer, `uidlevel2` character(11), `idlevel3` integer, `uidlevel3` character(11)); (JdbcResourceTableStore.java [ta
  skScheduler-1])
  * INFO 2015-12-07 17:41:06,495 Populate table content rows: 203 (JdbcResourceTableStore.java [taskScheduler-1])
  * INFO 2015-12-07 17:41:06,546 Create index SQL: create unique index in_orgunitstructure_organisationunituid_VWU2G on _
  orgunitstructure_temp(organisationunituid) (JdbcResourceTableStore.java [taskScheduler-1])
  * INFO 2015-12-07 17:41:06,582 [Level: ERROR, category: RESOURCETABLE_UPDATE, time: Mon Dec 07 17:41:06 IST 2015, messa
  ge: Process failed: StatementCallback; bad SQL grammar [drop table _orgunitstructure;]; nested exception is com.mysql.jd
  bc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'dhis._orgunitstructure'] (InMemoryNotifier.java [tas
  kScheduler-1])

  ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

  Error3: Tried to copy resource table structures from old db and tried
  generate resource table option, this time got the below error:

  * INFO 2015-12-07 18:05:19,296 [Level: ERROR, category: RESOURCETABLE_UPDATE, time: Mon Dec 07 18:05:19 IST 2015, messa
  ge: Process failed: StatementCallback; bad SQL grammar [create unique index in_dataelementstructure_dataelementuid_M86c6
   on _dataelementstructure_temp(dataelementuid);create index in_dataelementstructure_datasetid_fVMFF on _dataelementstruc
  ture_temp(datasetid);create index in_dataelementstructure_datasetuid_nsdEu on _dataelementstructure_temp(datasetuid);cre
  ate index in_dataelementstructure_periodtypeid_EkjZg on _dataelementstructure_temp(periodtypeid);]; nested exception is
  com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that c
  orresponds to your MySQL server version for the right syntax to use near 'create index in_dataelementstructure_datasetid
  _fVMFF on _dataelementstructure_te' at line 1] (InMemoryNotifier.java [taskScheduler-5])
  * ERROR 2015-12-07 18:05:19,319 Unexpected error occurred in scheduled task. (TaskUtils.java [taskScheduler-5])
  org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [create unique index in_dataelements
  tructure_dataelementuid_M86c6 on _dataelementstructure_temp(dataelementuid);create index in_dataelementstructure_dataset
  id_fVMFF on _dataelementstructure_temp(datasetid);create index in_dataelementstructure_datasetuid_nsdEu on _dataelements
  tructure_temp(datasetuid);create index in_dataelementstructure_periodtypeid_EkjZg on _dataelementstructure_temp(periodty
  peid);]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL sy
  ntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'create index in_d
  ataelementstructure_datasetid_fVMFF on _dataelementstructure_te' at line 1
          at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTrans
  lator.java:231)
          at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptio
  nTranslator.java:73)
          at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416)
          at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:440)
          at org.hisp.dhis.resourcetable.jdbc.JdbcResourceTableStore.generateResourceTable(JdbcResourceTableStore.java:118
  )
          at org.hisp.dhis.resourcetable.DefaultResourceTableService.generateDataElementTable(DefaultResourceTableService.
  java:198)
          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
          at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
          at java.lang.reflect.Method.invoke(Unknown Source)
          at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:
  190)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
          at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterce
  ptor.java:99)
          at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspec
  tSupport.java:281)
          at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
          at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
          at com.sun.proxy.$Proxy143.generateDataElementTable(Unknown Source)
          at org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.generateAll(ResourceTableTask.java:121)
          at org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.run(ResourceTableTask.java:84)
          at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.ja
  va:54)
          at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
          at java.util.concurrent.FutureTask.run(Unknown Source)
          at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown Source)
          at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
          at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
          at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
          at java.lang.Thread.run(Unknown Source)
  Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the ma
  nual that corresponds to your MySQL server version for the right syntax to use near 'create index in_dataelementstructur
  e_datasetid_fVMFF on _dataelementstructure_te' at line 1
          at sun.reflect.GeneratedConstructorAccessor53.newInstance(Unknown Source)
          at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
          at java.lang.reflect.Constructor.newInstance(Unknown Source)
          at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
          at com.mysql.jdbc.Util.getInstance(Util.java:360)
          at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978)
          at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
          at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
          at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
          at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
          at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)
          at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
          at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:848)
          at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:742)
          at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:1006)
          at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:432)
          at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:405)
          ... 26 more

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1523882/+subscriptions

Neeraj, I think this issue should be fixed when we renamed the programrule > condition column. Can you try again with latest 2.21?

···

On Wed, Dec 9, 2015 at 1:06 PM, Neeraj neeraj.hisp@gmail.com wrote:

Thanks John,

Will go through these notes and try to update.

On Tue, Dec 8, 2015 at 9:21 PM, John Francis Mukulu <

1523882@bugs.launchpad.net> wrote:

Hellow Neeraj,

With such a huge leap between version, I recommend, before deploying 2.21

on the 2.16 database, you go through upgrade notes between each version

and effect all database changes step wise.

i.e.

From 2.16 to 2.17 you can visit:

https://www.dhis2.org/217-upgrade

From 2.17 to 2.18 and above, the upgrade notes are are available on

https://www.dhis2.org/downloads

Goodluck.

You received this bug notification because you are subscribed to the bug

report.
https://bugs.launchpad.net/bugs/1523882

Title:

Getting exception when upgraded application from Version 2.16 to 2.21

with Mysql dataase

Status in DHIS:

New

Bug description:

Dear All,

We recently upgraded DHIS 2.16 to 2.21 where database is Mysql some of

the errors are listed below.(We are using aggregated data not tracker)

Basically we are getting 3 errors

  • Error1: In mysql programrule table is not created automatically
  • Error2: While generating resource tables got the error, think the

query should be DROP TABLE IF EXISTS orgunitstructure; Same applies

for all resource tables.

  • Error3: Tried to copy resource table structures from old db and

tried generate resource table option, this time got the error:

The details of errors are given below.

While upgrading we ran all the sql update scripts.

Error1:

In mysql programrule table is not created automatically. While starting

getting the below error:

  • ERROR 2015-12-07 17:36:56,864 Problem updating: programrule, id

column: programruleid (IdentityPopulator.java [localho

st-startStop-1])

org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad

SQL grammar [SELECT * from programrule WHERE uid

IS NULL]; nested exception is

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table

‘dhis.programrule’

doesn’t exist

      at

org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTrans

lator.java:231)

      at

org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptio

nTranslator.java:73)

      at

org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416)

      at

org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:471)

      at

org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:526)

      at

org.hisp.dhis.common.IdentityPopulator.execute(IdentityPopulator.java:86)

      at

org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:117)

      at

org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:86)

      at

org.hisp.dhis.system.startup.StartupListener.contextInitialized(StartupListener.java:71)

      at

org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4729)

      at

org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5167)

      at

org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)

      at

org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)

      at

org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)

      at

org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)

      at

org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:945)

      at

org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1768)

      at java.util.concurrent.Executors$RunnableAdapter.call(Unknown

Source)

      at java.util.concurrent.FutureTask.run(Unknown Source)
      at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown

Source)

      at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown

Source)

      at java.lang.Thread.run(Unknown Source)

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:

Table ‘dhis.programrule’ doesn’t exist

      at

sun.reflect.GeneratedConstructorAccessor53.newInstance(Unknown Source)

      at

sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

      at java.lang.reflect.Constructor.newInstance(Unknown Source)
      at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
      at com.mysql.jdbc.Util.getInstance(Util.java:360)
      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
      at

com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)

      at

com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)

      at

com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1446)

      at

com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35)

      at

org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:455)

      at

org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:405)

      ... 19 more
  • INFO 2015-12-07 17:36:57,144 Executing startup routine [6 of 13,

runlevel 5]: TableCreator (DefaultStartupRoutineExec

utor.java [localhost-startStop-1])



Error2: While generating resource tables got the below error, think

the query should be DROP TABLE IF EXISTS _orgunitstructure; Same

applies for all resource tables.

  • INFO 2015-12-07 17:41:06,417 [Level: INFO, category:

RESOURCETABLE_UPDATE, time: Mon Dec 07 17:41:06 IST 2015, messag

e: Generating resource tables] (InMemoryNotifier.java [taskScheduler-1])

  • INFO 2015-12-07 17:41:06,465 Create table SQL: create table

_orgunitstructure_temp (organisationunitid integer not nu

ll primary key, organisationunituid character(11), level integer,

idlevel1 integer, uidlevel1 character(11), `idleve

l2integer,uidlevel2character(11),idlevel3integer,uidlevel3`

character(11)); (JdbcResourceTableStore.java [ta

skScheduler-1])

  • INFO 2015-12-07 17:41:06,495 Populate table content rows: 203

(JdbcResourceTableStore.java [taskScheduler-1])

  • INFO 2015-12-07 17:41:06,546 Create index SQL: create unique index

in_orgunitstructure_organisationunituid_VWU2G on _

orgunitstructure_temp(organisationunituid) (JdbcResourceTableStore.java

[taskScheduler-1])

  • INFO 2015-12-07 17:41:06,582 [Level: ERROR, category:

RESOURCETABLE_UPDATE, time: Mon Dec 07 17:41:06 IST 2015, messa

ge: Process failed: StatementCallback; bad SQL grammar [drop table

_orgunitstructure;]; nested exception is com.mysql.jd

bc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table

‘dhis._orgunitstructure’] (InMemoryNotifier.java [tas

kScheduler-1])



Error3: Tried to copy resource table structures from old db and tried

generate resource table option, this time got the below error:

  • INFO 2015-12-07 18:05:19,296 [Level: ERROR, category:

RESOURCETABLE_UPDATE, time: Mon Dec 07 18:05:19 IST 2015, messa

ge: Process failed: StatementCallback; bad SQL grammar [create unique

index in_dataelementstructure_dataelementuid_M86c6

on _dataelementstructure_temp(dataelementuid);create index

in_dataelementstructure_datasetid_fVMFF on _dataelementstruc

ture_temp(datasetid);create index

in_dataelementstructure_datasetuid_nsdEu on

_dataelementstructure_temp(datasetuid);cre

ate index in_dataelementstructure_periodtypeid_EkjZg on

_dataelementstructure_temp(periodtypeid);]; nested exception is

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an

error in your SQL syntax; check the manual that c

orresponds to your MySQL server version for the right syntax to use near

'create index in_dataelementstructure_datasetid

_fVMFF on _dataelementstructure_te’ at line 1] (InMemoryNotifier.java

[taskScheduler-5])

  • ERROR 2015-12-07 18:05:19,319 Unexpected error occurred in scheduled

task. (TaskUtils.java [taskScheduler-5])

org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad

SQL grammar [create unique index in_dataelements

tructure_dataelementuid_M86c6 on

_dataelementstructure_temp(dataelementuid);create index

in_dataelementstructure_dataset

id_fVMFF on _dataelementstructure_temp(datasetid);create index

in_dataelementstructure_datasetuid_nsdEu on _dataelements

tructure_temp(datasetuid);create index

in_dataelementstructure_periodtypeid_EkjZg on

_dataelementstructure_temp(periodty

peid);]; nested exception is

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an

error in your SQL sy

ntax; check the manual that corresponds to your MySQL server version for

the right syntax to use near 'create index in_d

ataelementstructure_datasetid_fVMFF on _dataelementstructure_te’ at line

1

      at

org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTrans

lator.java:231)

      at

org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptio

nTranslator.java:73)

      at

org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416)

      at

org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:440)

      at

org.hisp.dhis.resourcetable.jdbc.JdbcResourceTableStore.generateResourceTable(JdbcResourceTableStore.java:118

)

      at

org.hisp.dhis.resourcetable.DefaultResourceTableService.generateDataElementTable(DefaultResourceTableService.

java:198)

      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown

Source)

      at java.lang.reflect.Method.invoke(Unknown Source)
      at

org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)

      at

org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:

      at

org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)

      at

org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterce

ptor.java:99)

      at

org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspec

tSupport.java:281)

      at

org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)

      at

org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)

      at

org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)

      at com.sun.proxy.$Proxy143.generateDataElementTable(Unknown

Source)

      at

org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.generateAll(ResourceTableTask.java:121)

      at

org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.run(ResourceTableTask.java:84)

      at

org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.ja

va:54)

      at java.util.concurrent.Executors$RunnableAdapter.call(Unknown

Source)

      at java.util.concurrent.FutureTask.run(Unknown Source)
      at

java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown

Source)

      at

java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown

Source)

      at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown

Source)

      at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown

Source)

      at java.lang.Thread.run(Unknown Source)

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:

You have an error in your SQL syntax; check the ma

nual that corresponds to your MySQL server version for the right syntax

to use near 'create index in_dataelementstructur

e_datasetid_fVMFF on _dataelementstructure_te’ at line 1

      at

sun.reflect.GeneratedConstructorAccessor53.newInstance(Unknown Source)

      at

sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

      at java.lang.reflect.Constructor.newInstance(Unknown Source)
      at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
      at com.mysql.jdbc.Util.getInstance(Util.java:360)
      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
      at

com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)

      at

com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)

      at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:848)
      at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:742)
      at

com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:1006)

      at

org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:432)

      at

org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:405)

      ... 26 more

To manage notifications about this bug go to:

https://bugs.launchpad.net/dhis2/+bug/1523882/+subscriptions

Thanks,

Neeraj Gupta

You received this bug notification because you are a member of DHIS 2

developers, which is subscribed to DHIS.

https://bugs.launchpad.net/bugs/1523882

Title:

Getting exception when upgraded application from Version 2.16 to 2.21

with Mysql dataase

Status in DHIS:

New

Bug description:

Dear All,

We recently upgraded DHIS 2.16 to 2.21 where database is Mysql some of

the errors are listed below.(We are using aggregated data not tracker)

Basically we are getting 3 errors

  • Error1: In mysql programrule table is not created automatically

  • Error2: While generating resource tables got the error, think the

query should be DROP TABLE IF EXISTS orgunitstructure; Same applies

for all resource tables.

  • Error3: Tried to copy resource table structures from old db and

tried generate resource table option, this time got the error:

The details of errors are given below.

While upgrading we ran all the sql update scripts.

Error1:

In mysql programrule table is not created automatically. While starting getting the below error:

  • ERROR 2015-12-07 17:36:56,864 Problem updating: programrule, id column: programruleid (IdentityPopulator.java [localho

st-startStop-1])

org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * from programrule WHERE uid

IS NULL]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table ‘dhis.programrule’

doesn’t exist

      at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTrans

lator.java:231)

      at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptio

nTranslator.java:73)

      at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416)

      at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:471)

      at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:526)

      at org.hisp.dhis.common.IdentityPopulator.execute(IdentityPopulator.java:86)

      at org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:117)

      at org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:86)

      at org.hisp.dhis.system.startup.StartupListener.contextInitialized(StartupListener.java:71)

      at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4729)

      at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5167)

      at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)

      at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)

      at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)

      at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)

      at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:945)

      at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1768)

      at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

      at java.util.concurrent.FutureTask.run(Unknown Source)

      at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

      at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

      at java.lang.Thread.run(Unknown Source)

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table ‘dhis.programrule’ doesn’t exist

      at sun.reflect.GeneratedConstructorAccessor53.newInstance(Unknown Source)

      at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

      at java.lang.reflect.Constructor.newInstance(Unknown Source)

      at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)

      at com.mysql.jdbc.Util.getInstance(Util.java:360)

      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978)

      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)

      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)

      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)

      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)

      at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)

      at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)

      at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1446)

      at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35)

      at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:455)

      at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:405)

      ... 19 more
  • INFO 2015-12-07 17:36:57,144 Executing startup routine [6 of 13, runlevel 5]: TableCreator (DefaultStartupRoutineExec

utor.java [localhost-startStop-1])



Error2: While generating resource tables got the below error, think

the query should be DROP TABLE IF EXISTS _orgunitstructure; Same

applies for all resource tables.

  • INFO 2015-12-07 17:41:06,417 [Level: INFO, category: RESOURCETABLE_UPDATE, time: Mon Dec 07 17:41:06 IST 2015, messag

e: Generating resource tables] (InMemoryNotifier.java [taskScheduler-1])

  • INFO 2015-12-07 17:41:06,465 Create table SQL: create table _orgunitstructure_temp (organisationunitid integer not nu

ll primary key, organisationunituid character(11), level integer, idlevel1 integer, uidlevel1 character(11), `idleve

l2integer,uidlevel2character(11),idlevel3integer,uidlevel3` character(11)); (JdbcResourceTableStore.java [ta

skScheduler-1])

  • INFO 2015-12-07 17:41:06,495 Populate table content rows: 203 (JdbcResourceTableStore.java [taskScheduler-1])

  • INFO 2015-12-07 17:41:06,546 Create index SQL: create unique index in_orgunitstructure_organisationunituid_VWU2G on _

orgunitstructure_temp(organisationunituid) (JdbcResourceTableStore.java [taskScheduler-1])

  • INFO 2015-12-07 17:41:06,582 [Level: ERROR, category: RESOURCETABLE_UPDATE, time: Mon Dec 07 17:41:06 IST 2015, messa

ge: Process failed: StatementCallback; bad SQL grammar [drop table _orgunitstructure;]; nested exception is com.mysql.jd

bc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table ‘dhis._orgunitstructure’] (InMemoryNotifier.java [tas

kScheduler-1])



Error3: Tried to copy resource table structures from old db and tried

generate resource table option, this time got the below error:

  • INFO 2015-12-07 18:05:19,296 [Level: ERROR, category: RESOURCETABLE_UPDATE, time: Mon Dec 07 18:05:19 IST 2015, messa

ge: Process failed: StatementCallback; bad SQL grammar [create unique index in_dataelementstructure_dataelementuid_M86c6

on _dataelementstructure_temp(dataelementuid);create index in_dataelementstructure_datasetid_fVMFF on _dataelementstruc

ture_temp(datasetid);create index in_dataelementstructure_datasetuid_nsdEu on _dataelementstructure_temp(datasetuid);cre

ate index in_dataelementstructure_periodtypeid_EkjZg on _dataelementstructure_temp(periodtypeid);]; nested exception is

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that c

orresponds to your MySQL server version for the right syntax to use near 'create index in_dataelementstructure_datasetid

_fVMFF on _dataelementstructure_te’ at line 1] (InMemoryNotifier.java [taskScheduler-5])

  • ERROR 2015-12-07 18:05:19,319 Unexpected error occurred in scheduled task. (TaskUtils.java [taskScheduler-5])

org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [create unique index in_dataelements

tructure_dataelementuid_M86c6 on _dataelementstructure_temp(dataelementuid);create index in_dataelementstructure_dataset

id_fVMFF on _dataelementstructure_temp(datasetid);create index in_dataelementstructure_datasetuid_nsdEu on _dataelements

tructure_temp(datasetuid);create index in_dataelementstructure_periodtypeid_EkjZg on _dataelementstructure_temp(periodty

peid);]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL sy

ntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'create index in_d

ataelementstructure_datasetid_fVMFF on _dataelementstructure_te’ at line 1

      at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTrans

lator.java:231)

      at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptio

nTranslator.java:73)

      at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416)

      at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:440)

      at org.hisp.dhis.resourcetable.jdbc.JdbcResourceTableStore.generateResourceTable(JdbcResourceTableStore.java:118

)

      at org.hisp.dhis.resourcetable.DefaultResourceTableService.generateDataElementTable(DefaultResourceTableService.

java:198)

      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

      at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

      at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

      at java.lang.reflect.Method.invoke(Unknown Source)

      at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)

      at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)

      at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterce

ptor.java:99)

      at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspec

tSupport.java:281)

      at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)

      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)

      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)

      at com.sun.proxy.$Proxy143.generateDataElementTable(Unknown Source)

      at org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.generateAll(ResourceTableTask.java:121)

      at org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.run(ResourceTableTask.java:84)

      at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.ja

va:54)

      at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

      at java.util.concurrent.FutureTask.run(Unknown Source)

      at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown Source)

      at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)

      at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

      at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

      at java.lang.Thread.run(Unknown Source)

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the ma

nual that corresponds to your MySQL server version for the right syntax to use near 'create index in_dataelementstructur

e_datasetid_fVMFF on _dataelementstructure_te’ at line 1

      at sun.reflect.GeneratedConstructorAccessor53.newInstance(Unknown Source)

      at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

      at java.lang.reflect.Constructor.newInstance(Unknown Source)

      at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)

      at com.mysql.jdbc.Util.getInstance(Util.java:360)

      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978)

      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)

      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)

      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)

      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)

      at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)

      at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)

      at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:848)

      at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:742)

      at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:1006)

      at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:432)

      at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:405)

      ... 26 more

To manage notifications about this bug go to:

https://bugs.launchpad.net/dhis2/+bug/1523882/+subscriptions


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

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

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

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

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

Sure Lars, Will test and let you know the results.

···

On Wed, Dec 9, 2015 at 5:49 PM, Lars Helge Øverland <larshelge@gmail.com> wrote:

Neeraj, I think this issue should be fixed when we renamed the programrule
> condition column. Can you try again with latest 2.21?

On Wed, Dec 9, 2015 at 1:06 PM, Neeraj <neeraj.hisp@gmail.com> wrote:

Thanks John,

Will go through these notes and try to update.

On Tue, Dec 8, 2015 at 9:21 PM, John Francis Mukulu < >> 1523882@bugs.launchpad.net> wrote:

> Hellow Neeraj,
> With such a huge leap between version, I recommend, before deploying
2.21
> on the 2.16 database, you go through upgrade notes between each version
> and effect all database changes step wise.
>
>
> i.e.
> >From 2.16 to 2.17 you can visit:
> https://www.dhis2.org/217-upgrade
>
> >From 2.17 to 2.18 and above, the upgrade notes are are available on
> https://www.dhis2.org/downloads
> Goodluck.
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https://bugs.launchpad.net/bugs/1523882
>
> Title:
> Getting exception when upgraded application from Version 2.16 to 2.21
> with Mysql dataase
>
> Status in DHIS:
> New
>
> Bug description:
> Dear All,
>
> We recently upgraded DHIS 2.16 to 2.21 where database is Mysql some of
> the errors are listed below.(We are using aggregated data not tracker)
>
> Basically we are getting 3 errors
> - Error1: In mysql programrule table is not created automatically
>
> - Error2: While generating resource tables got the error, think the
> query should be DROP TABLE IF EXISTS orgunitstructure; Same applies
> for all resource tables.
>
> - Error3: Tried to copy resource table structures from old db and
> tried generate resource table option, this time got the error:
>
> The details of errors are given below.
>
> While upgrading we ran all the sql update scripts.
>
> Error1:
> In mysql programrule table is not created automatically. While
starting
> getting the below error:
>
>
> * ERROR 2015-12-07 17:36:56,864 Problem updating: programrule, id
> column: programruleid (IdentityPopulator.java [localho
> st-startStop-1])
> org.springframework.jdbc.BadSqlGrammarException: StatementCallback;
bad
> SQL grammar [SELECT * from programrule WHERE uid
> IS NULL]; nested exception is
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
> 'dhis.programrule'
> doesn't exist
> at
>
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTrans
> lator.java:231)
> at
>
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptio
> nTranslator.java:73)
> at
>
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416)
> at
> org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:471)
> at
>
org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:526)
> at
>
org.hisp.dhis.common.IdentityPopulator.execute(IdentityPopulator.java:86)
> at
>
org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:117)
> at
>
org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:86)
> at
>
org.hisp.dhis.system.startup.StartupListener.contextInitialized(StartupListener.java:71)
> at
>
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4729)
> at
>
org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5167)
> at
> org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
> at
>
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)
> at
> org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)
> at
> org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
> at
> org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:945)
> at
>
org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1768)
> at java.util.concurrent.Executors$RunnableAdapter.call(Unknown
> Source)
> at java.util.concurrent.FutureTask.run(Unknown Source)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown
> Source)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown
> Source)
> at java.lang.Thread.run(Unknown Source)
> Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
> Table 'dhis.programrule' doesn't exist
> at
> sun.reflect.GeneratedConstructorAccessor53.newInstance(Unknown Source)
> at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown
Source)
> at java.lang.reflect.Constructor.newInstance(Unknown Source)
> at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
> at com.mysql.jdbc.Util.getInstance(Util.java:360)
> at
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
> at
> com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)
> at
> com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
> at
> com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1446)
> at
>
com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35)
> at
>
org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:455)
> at
>
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:405)
> ... 19 more
> * INFO 2015-12-07 17:36:57,144 Executing startup routine [6 of 13,
> runlevel 5]: TableCreator (DefaultStartupRoutineExec
> utor.java [localhost-startStop-1])
>
>
>
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
>
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Error2: While generating resource tables got the below error, think
> the query should be DROP TABLE IF EXISTS _orgunitstructure; Same
> applies for all resource tables.
>
> * INFO 2015-12-07 17:41:06,417 [Level: INFO, category:
> RESOURCETABLE_UPDATE, time: Mon Dec 07 17:41:06 IST 2015, messag
> e: Generating resource tables] (InMemoryNotifier.java
[taskScheduler-1])
> * INFO 2015-12-07 17:41:06,465 Create table SQL: create table
> _orgunitstructure_temp (organisationunitid integer not nu
> ll primary key, organisationunituid character(11), level integer,
> `idlevel1` integer, `uidlevel1` character(11), `idleve
> l2` integer, `uidlevel2` character(11), `idlevel3` integer,
`uidlevel3`
> character(11)); (JdbcResourceTableStore.java [ta
> skScheduler-1])
> * INFO 2015-12-07 17:41:06,495 Populate table content rows: 203
> (JdbcResourceTableStore.java [taskScheduler-1])
> * INFO 2015-12-07 17:41:06,546 Create index SQL: create unique index
> in_orgunitstructure_organisationunituid_VWU2G on _
> orgunitstructure_temp(organisationunituid)
(JdbcResourceTableStore.java
> [taskScheduler-1])
> * INFO 2015-12-07 17:41:06,582 [Level: ERROR, category:
> RESOURCETABLE_UPDATE, time: Mon Dec 07 17:41:06 IST 2015, messa
> ge: Process failed: StatementCallback; bad SQL grammar [drop table
> _orgunitstructure;]; nested exception is com.mysql.jd
> bc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table
> 'dhis._orgunitstructure'] (InMemoryNotifier.java [tas
> kScheduler-1])
>
>
>
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
>
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Error3: Tried to copy resource table structures from old db and tried
> generate resource table option, this time got the below error:
>
> * INFO 2015-12-07 18:05:19,296 [Level: ERROR, category:
> RESOURCETABLE_UPDATE, time: Mon Dec 07 18:05:19 IST 2015, messa
> ge: Process failed: StatementCallback; bad SQL grammar [create unique
> index in_dataelementstructure_dataelementuid_M86c6
> on _dataelementstructure_temp(dataelementuid);create index
> in_dataelementstructure_datasetid_fVMFF on _dataelementstruc
> ture_temp(datasetid);create index
> in_dataelementstructure_datasetuid_nsdEu on
> _dataelementstructure_temp(datasetuid);cre
> ate index in_dataelementstructure_periodtypeid_EkjZg on
> _dataelementstructure_temp(periodtypeid);]; nested exception is
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an
> error in your SQL syntax; check the manual that c
> orresponds to your MySQL server version for the right syntax to use
near
> 'create index in_dataelementstructure_datasetid
> _fVMFF on _dataelementstructure_te' at line 1] (InMemoryNotifier.java
> [taskScheduler-5])
> * ERROR 2015-12-07 18:05:19,319 Unexpected error occurred in scheduled
> task. (TaskUtils.java [taskScheduler-5])
> org.springframework.jdbc.BadSqlGrammarException: StatementCallback;
bad
> SQL grammar [create unique index in_dataelements
> tructure_dataelementuid_M86c6 on
> _dataelementstructure_temp(dataelementuid);create index
> in_dataelementstructure_dataset
> id_fVMFF on _dataelementstructure_temp(datasetid);create index
> in_dataelementstructure_datasetuid_nsdEu on _dataelements
> tructure_temp(datasetuid);create index
> in_dataelementstructure_periodtypeid_EkjZg on
> _dataelementstructure_temp(periodty
> peid);]; nested exception is
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an
> error in your SQL sy
> ntax; check the manual that corresponds to your MySQL server version
for
> the right syntax to use near 'create index in_d
> ataelementstructure_datasetid_fVMFF on _dataelementstructure_te' at
line
> 1
> at
>
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTrans
> lator.java:231)
> at
>
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptio
> nTranslator.java:73)
> at
>
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416)
> at
>
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:440)
> at
>
org.hisp.dhis.resourcetable.jdbc.JdbcResourceTableStore.generateResourceTable(JdbcResourceTableStore.java:118
> )
> at
>
org.hisp.dhis.resourcetable.DefaultResourceTableService.generateDataElementTable(DefaultResourceTableService.
> java:198)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
> Source)
> at java.lang.reflect.Method.invoke(Unknown Source)
> at
>
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
> at
>
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:
> 190)
> at
>
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
> at
>
org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterce
> ptor.java:99)
> at
>
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspec
> tSupport.java:281)
> at
>
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
> at
>
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
> at
>
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
> at com.sun.proxy.$Proxy143.generateDataElementTable(Unknown
> Source)
> at
>
org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.generateAll(ResourceTableTask.java:121)
> at
>
org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.run(ResourceTableTask.java:84)
> at
>
org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.ja
> va:54)
> at java.util.concurrent.Executors$RunnableAdapter.call(Unknown
> Source)
> at java.util.concurrent.FutureTask.run(Unknown Source)
> at
>
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown
> Source)
> at
>
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown
> Source)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown
> Source)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown
> Source)
> at java.lang.Thread.run(Unknown Source)
> Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
> You have an error in your SQL syntax; check the ma
> nual that corresponds to your MySQL server version for the right
syntax
> to use near 'create index in_dataelementstructur
> e_datasetid_fVMFF on _dataelementstructure_te' at line 1
> at
> sun.reflect.GeneratedConstructorAccessor53.newInstance(Unknown Source)
> at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown
Source)
> at java.lang.reflect.Constructor.newInstance(Unknown Source)
> at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
> at com.mysql.jdbc.Util.getInstance(Util.java:360)
> at
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
> at
> com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)
> at
> com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
> at
com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:848)
> at
com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:742)
> at
>
com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:1006)
> at
>
org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:432)
> at
>
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:405)
> ... 26 more
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/dhis2/+bug/1523882/+subscriptions
>

--
Thanks,
Neeraj Gupta

--
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.

https://bugs.launchpad.net/bugs/1523882

Title:
  Getting exception when upgraded application from Version 2.16 to 2.21
  with Mysql dataase

Status in DHIS:
  New

Bug description:
  Dear All,

  We recently upgraded DHIS 2.16 to 2.21 where database is Mysql some of
  the errors are listed below.(We are using aggregated data not tracker)

  Basically we are getting 3 errors
  - Error1: In mysql programrule table is not created automatically

  - Error2: While generating resource tables got the error, think the
  query should be DROP TABLE IF EXISTS orgunitstructure; Same applies
  for all resource tables.

  - Error3: Tried to copy resource table structures from old db and
  tried generate resource table option, this time got the error:

  The details of errors are given below.

  While upgrading we ran all the sql update scripts.

  Error1:
  In mysql programrule table is not created automatically. While starting
getting the below error:

  * ERROR 2015-12-07 17:36:56,864 Problem updating: programrule, id
column: programruleid (IdentityPopulator.java [localho
  st-startStop-1])
  org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad
SQL grammar [SELECT * from programrule WHERE uid
   IS NULL]; nested exception is
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
'dhis.programrule'
   doesn't exist
          at
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTrans
  lator.java:231)
          at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptio
  nTranslator.java:73)
          at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416)
          at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:471)
          at
org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:526)
          at
org.hisp.dhis.common.IdentityPopulator.execute(IdentityPopulator.java:86)
          at
org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:117)
          at
org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:86)
          at
org.hisp.dhis.system.startup.StartupListener.contextInitialized(StartupListener.java:71)
          at
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4729)
          at
org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5167)
          at
org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
          at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)
          at
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)
          at
org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
          at
org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:945)
          at
org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1768)
          at java.util.concurrent.Executors$RunnableAdapter.call(Unknown
Source)
          at java.util.concurrent.FutureTask.run(Unknown Source)
          at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown
Source)
          at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown
Source)
          at java.lang.Thread.run(Unknown Source)
  Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
Table 'dhis.programrule' doesn't exist
          at
sun.reflect.GeneratedConstructorAccessor53.newInstance(Unknown Source)
          at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
          at java.lang.reflect.Constructor.newInstance(Unknown Source)
          at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
          at com.mysql.jdbc.Util.getInstance(Util.java:360)
          at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978)
          at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
          at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
          at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
          at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
          at
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)
          at
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
          at
com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1446)
          at
com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35)
          at
org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:455)
          at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:405)
          ... 19 more
  * INFO 2015-12-07 17:36:57,144 Executing startup routine [6 of 13,
runlevel 5]: TableCreator (DefaultStartupRoutineExec
  utor.java [localhost-startStop-1])

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

  Error2: While generating resource tables got the below error, think
  the query should be DROP TABLE IF EXISTS _orgunitstructure; Same
  applies for all resource tables.

  * INFO 2015-12-07 17:41:06,417 [Level: INFO, category:
RESOURCETABLE_UPDATE, time: Mon Dec 07 17:41:06 IST 2015, messag
  e: Generating resource tables] (InMemoryNotifier.java [taskScheduler-1])
  * INFO 2015-12-07 17:41:06,465 Create table SQL: create table
_orgunitstructure_temp (organisationunitid integer not nu
  ll primary key, organisationunituid character(11), level integer,
`idlevel1` integer, `uidlevel1` character(11), `idleve
  l2` integer, `uidlevel2` character(11), `idlevel3` integer, `uidlevel3`
character(11)); (JdbcResourceTableStore.java [ta
  skScheduler-1])
  * INFO 2015-12-07 17:41:06,495 Populate table content rows: 203
(JdbcResourceTableStore.java [taskScheduler-1])
  * INFO 2015-12-07 17:41:06,546 Create index SQL: create unique index
in_orgunitstructure_organisationunituid_VWU2G on _
  orgunitstructure_temp(organisationunituid) (JdbcResourceTableStore.java
[taskScheduler-1])
  * INFO 2015-12-07 17:41:06,582 [Level: ERROR, category:
RESOURCETABLE_UPDATE, time: Mon Dec 07 17:41:06 IST 2015, messa
  ge: Process failed: StatementCallback; bad SQL grammar [drop table
_orgunitstructure;]; nested exception is com.mysql.jd
  bc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table
'dhis._orgunitstructure'] (InMemoryNotifier.java [tas
  kScheduler-1])

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

  Error3: Tried to copy resource table structures from old db and tried
  generate resource table option, this time got the below error:

  * INFO 2015-12-07 18:05:19,296 [Level: ERROR, category:
RESOURCETABLE_UPDATE, time: Mon Dec 07 18:05:19 IST 2015, messa
  ge: Process failed: StatementCallback; bad SQL grammar [create unique
index in_dataelementstructure_dataelementuid_M86c6
   on _dataelementstructure_temp(dataelementuid);create index
in_dataelementstructure_datasetid_fVMFF on _dataelementstruc
  ture_temp(datasetid);create index
in_dataelementstructure_datasetuid_nsdEu on
_dataelementstructure_temp(datasetuid);cre
  ate index in_dataelementstructure_periodtypeid_EkjZg on
_dataelementstructure_temp(periodtypeid);]; nested exception is
  com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an
error in your SQL syntax; check the manual that c
  orresponds to your MySQL server version for the right syntax to use
near 'create index in_dataelementstructure_datasetid
  _fVMFF on _dataelementstructure_te' at line 1] (InMemoryNotifier.java
[taskScheduler-5])
  * ERROR 2015-12-07 18:05:19,319 Unexpected error occurred in scheduled
task. (TaskUtils.java [taskScheduler-5])
  org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad
SQL grammar [create unique index in_dataelements
  tructure_dataelementuid_M86c6 on
_dataelementstructure_temp(dataelementuid);create index
in_dataelementstructure_dataset
  id_fVMFF on _dataelementstructure_temp(datasetid);create index
in_dataelementstructure_datasetuid_nsdEu on _dataelements
  tructure_temp(datasetuid);create index
in_dataelementstructure_periodtypeid_EkjZg on
_dataelementstructure_temp(periodty
  peid);]; nested exception is
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an
error in your SQL sy
  ntax; check the manual that corresponds to your MySQL server version
for the right syntax to use near 'create index in_d
  ataelementstructure_datasetid_fVMFF on _dataelementstructure_te' at
line 1
          at
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTrans
  lator.java:231)
          at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptio
  nTranslator.java:73)
          at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416)
          at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:440)
          at
org.hisp.dhis.resourcetable.jdbc.JdbcResourceTableStore.generateResourceTable(JdbcResourceTableStore.java:118
  )
          at
org.hisp.dhis.resourcetable.DefaultResourceTableService.generateDataElementTable(DefaultResourceTableService.
  java:198)
          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
          at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
Source)
          at java.lang.reflect.Method.invoke(Unknown Source)
          at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
          at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:
  190)
          at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
          at
org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterce
  ptor.java:99)
          at
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspec
  tSupport.java:281)
          at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
          at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
          at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
          at com.sun.proxy.$Proxy143.generateDataElementTable(Unknown
Source)
          at
org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.generateAll(ResourceTableTask.java:121)
          at
org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.run(ResourceTableTask.java:84)
          at
org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.ja
  va:54)
          at java.util.concurrent.Executors$RunnableAdapter.call(Unknown
Source)
          at java.util.concurrent.FutureTask.run(Unknown Source)
          at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown
Source)
          at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown
Source)
          at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown
Source)
          at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown
Source)
          at java.lang.Thread.run(Unknown Source)
  Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
You have an error in your SQL syntax; check the ma
  nual that corresponds to your MySQL server version for the right syntax
to use near 'create index in_dataelementstructur
  e_datasetid_fVMFF on _dataelementstructure_te' at line 1
          at
sun.reflect.GeneratedConstructorAccessor53.newInstance(Unknown Source)
          at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
          at java.lang.reflect.Constructor.newInstance(Unknown Source)
          at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
          at com.mysql.jdbc.Util.getInstance(Util.java:360)
          at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978)
          at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
          at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
          at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
          at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
          at
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)
          at
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
          at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:848)
          at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:742)
          at
com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:1006)
          at
org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:432)
          at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:405)
          ... 26 more

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1523882/+subscriptions

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

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

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

--
Thanks,
Neeraj Gupta

--
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1523882

Title:
  Getting exception when upgraded application from Version 2.16 to 2.21
  with Mysql dataase

Status in DHIS:
  New

Bug description:
  Dear All,

  We recently upgraded DHIS 2.16 to 2.21 where database is Mysql some of
  the errors are listed below.(We are using aggregated data not tracker)

  Basically we are getting 3 errors
  - Error1: In mysql programrule table is not created automatically

  - Error2: While generating resource tables got the error, think the
  query should be DROP TABLE IF EXISTS orgunitstructure; Same applies
  for all resource tables.

  - Error3: Tried to copy resource table structures from old db and
  tried generate resource table option, this time got the error:

  The details of errors are given below.

  While upgrading we ran all the sql update scripts.

  Error1:
  In mysql programrule table is not created automatically. While starting getting the below error:

  * ERROR 2015-12-07 17:36:56,864 Problem updating: programrule, id column: programruleid (IdentityPopulator.java [localho
  st-startStop-1])
  org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * from programrule WHERE uid
   IS NULL]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'dhis.programrule'
   doesn't exist
          at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTrans
  lator.java:231)
          at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptio
  nTranslator.java:73)
          at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416)
          at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:471)
          at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:526)
          at org.hisp.dhis.common.IdentityPopulator.execute(IdentityPopulator.java:86)
          at org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:117)
          at org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:86)
          at org.hisp.dhis.system.startup.StartupListener.contextInitialized(StartupListener.java:71)
          at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4729)
          at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5167)
          at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
          at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)
          at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)
          at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
          at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:945)
          at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1768)
          at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
          at java.util.concurrent.FutureTask.run(Unknown Source)
          at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
          at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
          at java.lang.Thread.run(Unknown Source)
  Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'dhis.programrule' doesn't exist
          at sun.reflect.GeneratedConstructorAccessor53.newInstance(Unknown Source)
          at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
          at java.lang.reflect.Constructor.newInstance(Unknown Source)
          at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
          at com.mysql.jdbc.Util.getInstance(Util.java:360)
          at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978)
          at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
          at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
          at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
          at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
          at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)
          at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
          at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1446)
          at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35)
          at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:455)
          at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:405)
          ... 19 more
  * INFO 2015-12-07 17:36:57,144 Executing startup routine [6 of 13, runlevel 5]: TableCreator (DefaultStartupRoutineExec
  utor.java [localhost-startStop-1])

  ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

  Error2: While generating resource tables got the below error, think
  the query should be DROP TABLE IF EXISTS _orgunitstructure; Same
  applies for all resource tables.

  * INFO 2015-12-07 17:41:06,417 [Level: INFO, category: RESOURCETABLE_UPDATE, time: Mon Dec 07 17:41:06 IST 2015, messag
  e: Generating resource tables] (InMemoryNotifier.java [taskScheduler-1])
  * INFO 2015-12-07 17:41:06,465 Create table SQL: create table _orgunitstructure_temp (organisationunitid integer not nu
  ll primary key, organisationunituid character(11), level integer, `idlevel1` integer, `uidlevel1` character(11), `idleve
  l2` integer, `uidlevel2` character(11), `idlevel3` integer, `uidlevel3` character(11)); (JdbcResourceTableStore.java [ta
  skScheduler-1])
  * INFO 2015-12-07 17:41:06,495 Populate table content rows: 203 (JdbcResourceTableStore.java [taskScheduler-1])
  * INFO 2015-12-07 17:41:06,546 Create index SQL: create unique index in_orgunitstructure_organisationunituid_VWU2G on _
  orgunitstructure_temp(organisationunituid) (JdbcResourceTableStore.java [taskScheduler-1])
  * INFO 2015-12-07 17:41:06,582 [Level: ERROR, category: RESOURCETABLE_UPDATE, time: Mon Dec 07 17:41:06 IST 2015, messa
  ge: Process failed: StatementCallback; bad SQL grammar [drop table _orgunitstructure;]; nested exception is com.mysql.jd
  bc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'dhis._orgunitstructure'] (InMemoryNotifier.java [tas
  kScheduler-1])

  ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

  Error3: Tried to copy resource table structures from old db and tried
  generate resource table option, this time got the below error:

  * INFO 2015-12-07 18:05:19,296 [Level: ERROR, category: RESOURCETABLE_UPDATE, time: Mon Dec 07 18:05:19 IST 2015, messa
  ge: Process failed: StatementCallback; bad SQL grammar [create unique index in_dataelementstructure_dataelementuid_M86c6
   on _dataelementstructure_temp(dataelementuid);create index in_dataelementstructure_datasetid_fVMFF on _dataelementstruc
  ture_temp(datasetid);create index in_dataelementstructure_datasetuid_nsdEu on _dataelementstructure_temp(datasetuid);cre
  ate index in_dataelementstructure_periodtypeid_EkjZg on _dataelementstructure_temp(periodtypeid);]; nested exception is
  com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that c
  orresponds to your MySQL server version for the right syntax to use near 'create index in_dataelementstructure_datasetid
  _fVMFF on _dataelementstructure_te' at line 1] (InMemoryNotifier.java [taskScheduler-5])
  * ERROR 2015-12-07 18:05:19,319 Unexpected error occurred in scheduled task. (TaskUtils.java [taskScheduler-5])
  org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [create unique index in_dataelements
  tructure_dataelementuid_M86c6 on _dataelementstructure_temp(dataelementuid);create index in_dataelementstructure_dataset
  id_fVMFF on _dataelementstructure_temp(datasetid);create index in_dataelementstructure_datasetuid_nsdEu on _dataelements
  tructure_temp(datasetuid);create index in_dataelementstructure_periodtypeid_EkjZg on _dataelementstructure_temp(periodty
  peid);]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL sy
  ntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'create index in_d
  ataelementstructure_datasetid_fVMFF on _dataelementstructure_te' at line 1
          at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTrans
  lator.java:231)
          at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptio
  nTranslator.java:73)
          at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416)
          at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:440)
          at org.hisp.dhis.resourcetable.jdbc.JdbcResourceTableStore.generateResourceTable(JdbcResourceTableStore.java:118
  )
          at org.hisp.dhis.resourcetable.DefaultResourceTableService.generateDataElementTable(DefaultResourceTableService.
  java:198)
          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
          at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
          at java.lang.reflect.Method.invoke(Unknown Source)
          at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:
  190)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
          at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterce
  ptor.java:99)
          at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspec
  tSupport.java:281)
          at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
          at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
          at com.sun.proxy.$Proxy143.generateDataElementTable(Unknown Source)
          at org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.generateAll(ResourceTableTask.java:121)
          at org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.run(ResourceTableTask.java:84)
          at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.ja
  va:54)
          at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
          at java.util.concurrent.FutureTask.run(Unknown Source)
          at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown Source)
          at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
          at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
          at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
          at java.lang.Thread.run(Unknown Source)
  Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the ma
  nual that corresponds to your MySQL server version for the right syntax to use near 'create index in_dataelementstructur
  e_datasetid_fVMFF on _dataelementstructure_te' at line 1
          at sun.reflect.GeneratedConstructorAccessor53.newInstance(Unknown Source)
          at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
          at java.lang.reflect.Constructor.newInstance(Unknown Source)
          at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
          at com.mysql.jdbc.Util.getInstance(Util.java:360)
          at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978)
          at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
          at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
          at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
          at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
          at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)
          at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
          at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:848)
          at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:742)
          at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:1006)
          at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:432)
          at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:405)
          ... 26 more

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1523882/+subscriptions

Thanks Lars,

Problem with Program rules is fixed and we ran DHIS 2.21 war file with empty MySQL database and found below problem again.

Version:
2.21
Build revision:
20959
Build date:
2015-12-10 13:44

  • ERROR 2015-12-10 17:15:26,966 Unexpected error occurred in scheduled task. (Ta

skUtils.java [taskScheduler-1])

org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL gram

mar [CREATE TABLE _dataelementstructure_temp (dataelementid INTEGER NOT NULL PRI

MARY KEY, dataelementuid CHARACTER(11), dataelementname VARCHAR(230), datasetid

INTEGER, datasetuid CHARACTER(11), datasetname VARCHAR(230), datasetapprovalleve

l INTEGER, periodtypeid INTEGER, periodtypename VARCHAR(230))]; nested exception

is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table '_dataeleme

ntstructure_temp’ already exists

at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTra

nslate(SQLExceptionSubclassTranslator.java:91)

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslat

or.translate(AbstractFallbackSQLExceptionTranslator.java:73)

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslat

or.translate(AbstractFallbackSQLExceptionTranslator.java:81)

at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:

at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:

at org.hisp.dhis.resourcetable.jdbc.JdbcResourceTableStore.generateResou

rceTable(JdbcResourceTableStore.java:84)

at org.hisp.dhis.resourcetable.DefaultResourceTableService.generateDataE

lementTable(DefaultResourceTableService.java:198)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.

java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces

sorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:483)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti

on(AopUtils.java:317)

at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo

inpoint(ReflectiveMethodInvocation.java:190)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(

ReflectiveMethodInvocation.java:157)

at org.springframework.transaction.interceptor.TransactionInterceptor$1.

proceedWithInvocation(TransactionInterceptor.java:99)

at org.springframework.transaction.interceptor.TransactionAspectSupport.

invokeWithinTransaction(TransactionAspectSupport.java:281)

at org.springframework.transaction.interceptor.TransactionInterceptor.in

voke(TransactionInterceptor.java:96)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(

ReflectiveMethodInvocation.java:179)

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami

cAopProxy.java:207)

at com.sun.proxy.$Proxy140.generateDataElementTable(Unknown Source)

at org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.generateAll(

ResourceTableTask.java:121)

at org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.run(Resource

TableTask.java:84)

at org.springframework.scheduling.support.DelegatingErrorHandlingRunnabl

e.run(DelegatingErrorHandlingRunnable.java:54)

at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:51

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: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table '_da

taelementstructure_temp’ already exists

at sun.reflect.GeneratedConstructorAccessor82.newInstance(Unknown Source

)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC

onstructorAccessorImpl.java:45)

at java.lang.reflect.Constructor.newInstance(Constructor.java:408)

at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)

at com.mysql.jdbc.Util.getInstance(Util.java:360)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)

at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:848)

at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:742)

at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.

java:1006)

at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.

doInStatement(JdbcTemplate.java:432)

at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:

… 26 more

···

On Wed, Dec 9, 2015 at 5:49 PM, Lars Helge Øverland larshelge@gmail.com wrote:

Neeraj, I think this issue should be fixed when we renamed the programrule > condition column. Can you try again with latest 2.21?


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

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

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

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

On Wed, Dec 9, 2015 at 1:06 PM, Neeraj neeraj.hisp@gmail.com wrote:

Thanks John,

Will go through these notes and try to update.

On Tue, Dec 8, 2015 at 9:21 PM, John Francis Mukulu <

1523882@bugs.launchpad.net> wrote:

Hellow Neeraj,

With such a huge leap between version, I recommend, before deploying 2.21

on the 2.16 database, you go through upgrade notes between each version

and effect all database changes step wise.

i.e.

From 2.16 to 2.17 you can visit:

https://www.dhis2.org/217-upgrade

From 2.17 to 2.18 and above, the upgrade notes are are available on

https://www.dhis2.org/downloads

Goodluck.

You received this bug notification because you are subscribed to the bug

report.
https://bugs.launchpad.net/bugs/1523882

Title:

Getting exception when upgraded application from Version 2.16 to 2.21

with Mysql dataase

Status in DHIS:

New

Bug description:

Dear All,

We recently upgraded DHIS 2.16 to 2.21 where database is Mysql some of

the errors are listed below.(We are using aggregated data not tracker)

Basically we are getting 3 errors

  • Error1: In mysql programrule table is not created automatically
  • Error2: While generating resource tables got the error, think the

query should be DROP TABLE IF EXISTS orgunitstructure; Same applies

for all resource tables.

  • Error3: Tried to copy resource table structures from old db and

tried generate resource table option, this time got the error:

The details of errors are given below.

While upgrading we ran all the sql update scripts.

Error1:

In mysql programrule table is not created automatically. While starting

getting the below error:

  • ERROR 2015-12-07 17:36:56,864 Problem updating: programrule, id

column: programruleid (IdentityPopulator.java [localho

st-startStop-1])

org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad

SQL grammar [SELECT * from programrule WHERE uid

IS NULL]; nested exception is

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table

‘dhis.programrule’

doesn’t exist

      at

org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTrans

lator.java:231)

      at

org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptio

nTranslator.java:73)

      at

org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416)

      at

org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:471)

      at

org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:526)

      at

org.hisp.dhis.common.IdentityPopulator.execute(IdentityPopulator.java:86)

      at

org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:117)

      at

org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:86)

      at

org.hisp.dhis.system.startup.StartupListener.contextInitialized(StartupListener.java:71)

      at

org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4729)

      at

org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5167)

      at

org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)

      at

org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)

      at

org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)

      at

org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)

      at

org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:945)

      at

org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1768)

      at java.util.concurrent.Executors$RunnableAdapter.call(Unknown

Source)

      at java.util.concurrent.FutureTask.run(Unknown Source)
      at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown

Source)

      at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown

Source)

      at java.lang.Thread.run(Unknown Source)

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:

Table ‘dhis.programrule’ doesn’t exist

      at

sun.reflect.GeneratedConstructorAccessor53.newInstance(Unknown Source)

      at

sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

      at java.lang.reflect.Constructor.newInstance(Unknown Source)
      at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
      at com.mysql.jdbc.Util.getInstance(Util.java:360)
      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
      at

com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)

      at

com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)

      at

com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1446)

      at

com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35)

      at

org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:455)

      at

org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:405)

      ... 19 more
  • INFO 2015-12-07 17:36:57,144 Executing startup routine [6 of 13,

runlevel 5]: TableCreator (DefaultStartupRoutineExec

utor.java [localhost-startStop-1])



Error2: While generating resource tables got the below error, think

the query should be DROP TABLE IF EXISTS _orgunitstructure; Same

applies for all resource tables.

  • INFO 2015-12-07 17:41:06,417 [Level: INFO, category:

RESOURCETABLE_UPDATE, time: Mon Dec 07 17:41:06 IST 2015, messag

e: Generating resource tables] (InMemoryNotifier.java [taskScheduler-1])

  • INFO 2015-12-07 17:41:06,465 Create table SQL: create table

_orgunitstructure_temp (organisationunitid integer not nu

ll primary key, organisationunituid character(11), level integer,

idlevel1 integer, uidlevel1 character(11), `idleve

l2integer,uidlevel2character(11),idlevel3integer,uidlevel3`

character(11)); (JdbcResourceTableStore.java [ta

skScheduler-1])

  • INFO 2015-12-07 17:41:06,495 Populate table content rows: 203

(JdbcResourceTableStore.java [taskScheduler-1])

  • INFO 2015-12-07 17:41:06,546 Create index SQL: create unique index

in_orgunitstructure_organisationunituid_VWU2G on _

orgunitstructure_temp(organisationunituid) (JdbcResourceTableStore.java

[taskScheduler-1])

  • INFO 2015-12-07 17:41:06,582 [Level: ERROR, category:

RESOURCETABLE_UPDATE, time: Mon Dec 07 17:41:06 IST 2015, messa

ge: Process failed: StatementCallback; bad SQL grammar [drop table

_orgunitstructure;]; nested exception is com.mysql.jd

bc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table

‘dhis._orgunitstructure’] (InMemoryNotifier.java [tas

kScheduler-1])



Error3: Tried to copy resource table structures from old db and tried

generate resource table option, this time got the below error:

  • INFO 2015-12-07 18:05:19,296 [Level: ERROR, category:

RESOURCETABLE_UPDATE, time: Mon Dec 07 18:05:19 IST 2015, messa

ge: Process failed: StatementCallback; bad SQL grammar [create unique

index in_dataelementstructure_dataelementuid_M86c6

on _dataelementstructure_temp(dataelementuid);create index

in_dataelementstructure_datasetid_fVMFF on _dataelementstruc

ture_temp(datasetid);create index

in_dataelementstructure_datasetuid_nsdEu on

_dataelementstructure_temp(datasetuid);cre

ate index in_dataelementstructure_periodtypeid_EkjZg on

_dataelementstructure_temp(periodtypeid);]; nested exception is

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an

error in your SQL syntax; check the manual that c

orresponds to your MySQL server version for the right syntax to use near

'create index in_dataelementstructure_datasetid

_fVMFF on _dataelementstructure_te’ at line 1] (InMemoryNotifier.java

[taskScheduler-5])

  • ERROR 2015-12-07 18:05:19,319 Unexpected error occurred in scheduled

task. (TaskUtils.java [taskScheduler-5])

org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad

SQL grammar [create unique index in_dataelements

tructure_dataelementuid_M86c6 on

_dataelementstructure_temp(dataelementuid);create index

in_dataelementstructure_dataset

id_fVMFF on _dataelementstructure_temp(datasetid);create index

in_dataelementstructure_datasetuid_nsdEu on _dataelements

tructure_temp(datasetuid);create index

in_dataelementstructure_periodtypeid_EkjZg on

_dataelementstructure_temp(periodty

peid);]; nested exception is

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an

error in your SQL sy

ntax; check the manual that corresponds to your MySQL server version for

the right syntax to use near 'create index in_d

ataelementstructure_datasetid_fVMFF on _dataelementstructure_te’ at line

1

      at

org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTrans

lator.java:231)

      at

org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptio

nTranslator.java:73)

      at

org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416)

      at

org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:440)

      at

org.hisp.dhis.resourcetable.jdbc.JdbcResourceTableStore.generateResourceTable(JdbcResourceTableStore.java:118

)

      at

org.hisp.dhis.resourcetable.DefaultResourceTableService.generateDataElementTable(DefaultResourceTableService.

java:198)

      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown

Source)

      at java.lang.reflect.Method.invoke(Unknown Source)
      at

org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)

      at

org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:

      at

org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)

      at

org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterce

ptor.java:99)

      at

org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspec

tSupport.java:281)

      at

org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)

      at

org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)

      at

org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)

      at com.sun.proxy.$Proxy143.generateDataElementTable(Unknown

Source)

      at

org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.generateAll(ResourceTableTask.java:121)

      at

org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.run(ResourceTableTask.java:84)

      at

org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.ja

va:54)

      at java.util.concurrent.Executors$RunnableAdapter.call(Unknown

Source)

      at java.util.concurrent.FutureTask.run(Unknown Source)
      at

java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown

Source)

      at

java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown

Source)

      at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown

Source)

      at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown

Source)

      at java.lang.Thread.run(Unknown Source)

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:

You have an error in your SQL syntax; check the ma

nual that corresponds to your MySQL server version for the right syntax

to use near 'create index in_dataelementstructur

e_datasetid_fVMFF on _dataelementstructure_te’ at line 1

      at

sun.reflect.GeneratedConstructorAccessor53.newInstance(Unknown Source)

      at

sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

      at java.lang.reflect.Constructor.newInstance(Unknown Source)
      at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
      at com.mysql.jdbc.Util.getInstance(Util.java:360)
      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
      at

com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)

      at

com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)

      at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:848)
      at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:742)
      at

com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:1006)

      at

org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:432)

      at

org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:405)

      ... 26 more

To manage notifications about this bug go to:

https://bugs.launchpad.net/dhis2/+bug/1523882/+subscriptions

Thanks,

Neeraj Gupta

You received this bug notification because you are a member of DHIS 2

developers, which is subscribed to DHIS.

https://bugs.launchpad.net/bugs/1523882

Title:

Getting exception when upgraded application from Version 2.16 to 2.21

with Mysql dataase

Status in DHIS:

New

Bug description:

Dear All,

We recently upgraded DHIS 2.16 to 2.21 where database is Mysql some of

the errors are listed below.(We are using aggregated data not tracker)

Basically we are getting 3 errors

  • Error1: In mysql programrule table is not created automatically

  • Error2: While generating resource tables got the error, think the

query should be DROP TABLE IF EXISTS orgunitstructure; Same applies

for all resource tables.

  • Error3: Tried to copy resource table structures from old db and

tried generate resource table option, this time got the error:

The details of errors are given below.

While upgrading we ran all the sql update scripts.

Error1:

In mysql programrule table is not created automatically. While starting getting the below error:

  • ERROR 2015-12-07 17:36:56,864 Problem updating: programrule, id column: programruleid (IdentityPopulator.java [localho

st-startStop-1])

org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * from programrule WHERE uid

IS NULL]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table ‘dhis.programrule’

doesn’t exist

      at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTrans

lator.java:231)

      at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptio

nTranslator.java:73)

      at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416)

      at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:471)

      at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:526)

      at org.hisp.dhis.common.IdentityPopulator.execute(IdentityPopulator.java:86)

      at org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:117)

      at org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:86)

      at org.hisp.dhis.system.startup.StartupListener.contextInitialized(StartupListener.java:71)

      at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4729)

      at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5167)

      at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)

      at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)

      at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)

      at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)

      at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:945)

      at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1768)

      at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

      at java.util.concurrent.FutureTask.run(Unknown Source)

      at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

      at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

      at java.lang.Thread.run(Unknown Source)

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table ‘dhis.programrule’ doesn’t exist

      at sun.reflect.GeneratedConstructorAccessor53.newInstance(Unknown Source)

      at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

      at java.lang.reflect.Constructor.newInstance(Unknown Source)

      at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)

      at com.mysql.jdbc.Util.getInstance(Util.java:360)

      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978)

      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)

      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)

      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)

      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)

      at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)

      at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)

      at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1446)

      at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35)

      at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:455)

      at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:405)

      ... 19 more
  • INFO 2015-12-07 17:36:57,144 Executing startup routine [6 of 13, runlevel 5]: TableCreator (DefaultStartupRoutineExec

utor.java [localhost-startStop-1])



Error2: While generating resource tables got the below error, think

the query should be DROP TABLE IF EXISTS _orgunitstructure; Same

applies for all resource tables.

  • INFO 2015-12-07 17:41:06,417 [Level: INFO, category: RESOURCETABLE_UPDATE, time: Mon Dec 07 17:41:06 IST 2015, messag

e: Generating resource tables] (InMemoryNotifier.java [taskScheduler-1])

  • INFO 2015-12-07 17:41:06,465 Create table SQL: create table _orgunitstructure_temp (organisationunitid integer not nu

ll primary key, organisationunituid character(11), level integer, idlevel1 integer, uidlevel1 character(11), `idleve

l2integer,uidlevel2character(11),idlevel3integer,uidlevel3` character(11)); (JdbcResourceTableStore.java [ta

skScheduler-1])

  • INFO 2015-12-07 17:41:06,495 Populate table content rows: 203 (JdbcResourceTableStore.java [taskScheduler-1])

  • INFO 2015-12-07 17:41:06,546 Create index SQL: create unique index in_orgunitstructure_organisationunituid_VWU2G on _

orgunitstructure_temp(organisationunituid) (JdbcResourceTableStore.java [taskScheduler-1])

  • INFO 2015-12-07 17:41:06,582 [Level: ERROR, category: RESOURCETABLE_UPDATE, time: Mon Dec 07 17:41:06 IST 2015, messa

ge: Process failed: StatementCallback; bad SQL grammar [drop table _orgunitstructure;]; nested exception is com.mysql.jd

bc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table ‘dhis._orgunitstructure’] (InMemoryNotifier.java [tas

kScheduler-1])



Error3: Tried to copy resource table structures from old db and tried

generate resource table option, this time got the below error:

  • INFO 2015-12-07 18:05:19,296 [Level: ERROR, category: RESOURCETABLE_UPDATE, time: Mon Dec 07 18:05:19 IST 2015, messa

ge: Process failed: StatementCallback; bad SQL grammar [create unique index in_dataelementstructure_dataelementuid_M86c6

on _dataelementstructure_temp(dataelementuid);create index in_dataelementstructure_datasetid_fVMFF on _dataelementstruc

ture_temp(datasetid);create index in_dataelementstructure_datasetuid_nsdEu on _dataelementstructure_temp(datasetuid);cre

ate index in_dataelementstructure_periodtypeid_EkjZg on _dataelementstructure_temp(periodtypeid);]; nested exception is

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that c

orresponds to your MySQL server version for the right syntax to use near 'create index in_dataelementstructure_datasetid

_fVMFF on _dataelementstructure_te’ at line 1] (InMemoryNotifier.java [taskScheduler-5])

  • ERROR 2015-12-07 18:05:19,319 Unexpected error occurred in scheduled task. (TaskUtils.java [taskScheduler-5])

org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [create unique index in_dataelements

tructure_dataelementuid_M86c6 on _dataelementstructure_temp(dataelementuid);create index in_dataelementstructure_dataset

id_fVMFF on _dataelementstructure_temp(datasetid);create index in_dataelementstructure_datasetuid_nsdEu on _dataelements

tructure_temp(datasetuid);create index in_dataelementstructure_periodtypeid_EkjZg on _dataelementstructure_temp(periodty

peid);]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL sy

ntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'create index in_d

ataelementstructure_datasetid_fVMFF on _dataelementstructure_te’ at line 1

      at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTrans

lator.java:231)

      at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptio

nTranslator.java:73)

      at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416)

      at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:440)

      at org.hisp.dhis.resourcetable.jdbc.JdbcResourceTableStore.generateResourceTable(JdbcResourceTableStore.java:118

)

      at org.hisp.dhis.resourcetable.DefaultResourceTableService.generateDataElementTable(DefaultResourceTableService.

java:198)

      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

      at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

      at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

      at java.lang.reflect.Method.invoke(Unknown Source)

      at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)

      at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)

      at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterce

ptor.java:99)

      at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspec

tSupport.java:281)

      at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)

      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)

      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)

      at com.sun.proxy.$Proxy143.generateDataElementTable(Unknown Source)

      at org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.generateAll(ResourceTableTask.java:121)

      at org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.run(ResourceTableTask.java:84)

      at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.ja

va:54)

      at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

      at java.util.concurrent.FutureTask.run(Unknown Source)

      at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown Source)

      at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)

      at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

      at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

      at java.lang.Thread.run(Unknown Source)

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the ma

nual that corresponds to your MySQL server version for the right syntax to use near 'create index in_dataelementstructur

e_datasetid_fVMFF on _dataelementstructure_te’ at line 1

      at sun.reflect.GeneratedConstructorAccessor53.newInstance(Unknown Source)

      at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

      at java.lang.reflect.Constructor.newInstance(Unknown Source)

      at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)

      at com.mysql.jdbc.Util.getInstance(Util.java:360)

      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978)

      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)

      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)

      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)

      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)

      at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)

      at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)

      at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:848)

      at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:742)

      at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:1006)

      at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:432)

      at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:405)

      ... 26 more

To manage notifications about this bug go to:

https://bugs.launchpad.net/dhis2/+bug/1523882/+subscriptions


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

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

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

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

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

Thanks,
Neeraj Gupta

Just to add on, we got the problem while generating resource tables.

···

On Wed, Dec 9, 2015 at 5:49 PM, Lars Helge Øverland larshelge@gmail.com wrote:

Neeraj, I think this issue should be fixed when we renamed the programrule > condition column. Can you try again with latest 2.21?


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

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

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

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


Thanks,
Neeraj Gupta

On Wed, Dec 9, 2015 at 1:06 PM, Neeraj neeraj.hisp@gmail.com wrote:

Thanks John,

Will go through these notes and try to update.

On Tue, Dec 8, 2015 at 9:21 PM, John Francis Mukulu <

1523882@bugs.launchpad.net> wrote:

Hellow Neeraj,

With such a huge leap between version, I recommend, before deploying 2.21

on the 2.16 database, you go through upgrade notes between each version

and effect all database changes step wise.

i.e.

From 2.16 to 2.17 you can visit:

https://www.dhis2.org/217-upgrade

From 2.17 to 2.18 and above, the upgrade notes are are available on

https://www.dhis2.org/downloads

Goodluck.

You received this bug notification because you are subscribed to the bug

report.
https://bugs.launchpad.net/bugs/1523882

Title:

Getting exception when upgraded application from Version 2.16 to 2.21

with Mysql dataase

Status in DHIS:

New

Bug description:

Dear All,

We recently upgraded DHIS 2.16 to 2.21 where database is Mysql some of

the errors are listed below.(We are using aggregated data not tracker)

Basically we are getting 3 errors

  • Error1: In mysql programrule table is not created automatically
  • Error2: While generating resource tables got the error, think the

query should be DROP TABLE IF EXISTS orgunitstructure; Same applies

for all resource tables.

  • Error3: Tried to copy resource table structures from old db and

tried generate resource table option, this time got the error:

The details of errors are given below.

While upgrading we ran all the sql update scripts.

Error1:

In mysql programrule table is not created automatically. While starting

getting the below error:

  • ERROR 2015-12-07 17:36:56,864 Problem updating: programrule, id

column: programruleid (IdentityPopulator.java [localho

st-startStop-1])

org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad

SQL grammar [SELECT * from programrule WHERE uid

IS NULL]; nested exception is

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table

‘dhis.programrule’

doesn’t exist

      at

org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTrans

lator.java:231)

      at

org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptio

nTranslator.java:73)

      at

org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416)

      at

org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:471)

      at

org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:526)

      at

org.hisp.dhis.common.IdentityPopulator.execute(IdentityPopulator.java:86)

      at

org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:117)

      at

org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:86)

      at

org.hisp.dhis.system.startup.StartupListener.contextInitialized(StartupListener.java:71)

      at

org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4729)

      at

org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5167)

      at

org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)

      at

org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)

      at

org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)

      at

org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)

      at

org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:945)

      at

org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1768)

      at java.util.concurrent.Executors$RunnableAdapter.call(Unknown

Source)

      at java.util.concurrent.FutureTask.run(Unknown Source)
      at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown

Source)

      at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown

Source)

      at java.lang.Thread.run(Unknown Source)

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:

Table ‘dhis.programrule’ doesn’t exist

      at

sun.reflect.GeneratedConstructorAccessor53.newInstance(Unknown Source)

      at

sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

      at java.lang.reflect.Constructor.newInstance(Unknown Source)
      at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
      at com.mysql.jdbc.Util.getInstance(Util.java:360)
      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
      at

com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)

      at

com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)

      at

com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1446)

      at

com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35)

      at

org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:455)

      at

org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:405)

      ... 19 more
  • INFO 2015-12-07 17:36:57,144 Executing startup routine [6 of 13,

runlevel 5]: TableCreator (DefaultStartupRoutineExec

utor.java [localhost-startStop-1])



Error2: While generating resource tables got the below error, think

the query should be DROP TABLE IF EXISTS _orgunitstructure; Same

applies for all resource tables.

  • INFO 2015-12-07 17:41:06,417 [Level: INFO, category:

RESOURCETABLE_UPDATE, time: Mon Dec 07 17:41:06 IST 2015, messag

e: Generating resource tables] (InMemoryNotifier.java [taskScheduler-1])

  • INFO 2015-12-07 17:41:06,465 Create table SQL: create table

_orgunitstructure_temp (organisationunitid integer not nu

ll primary key, organisationunituid character(11), level integer,

idlevel1 integer, uidlevel1 character(11), `idleve

l2integer,uidlevel2character(11),idlevel3integer,uidlevel3`

character(11)); (JdbcResourceTableStore.java [ta

skScheduler-1])

  • INFO 2015-12-07 17:41:06,495 Populate table content rows: 203

(JdbcResourceTableStore.java [taskScheduler-1])

  • INFO 2015-12-07 17:41:06,546 Create index SQL: create unique index

in_orgunitstructure_organisationunituid_VWU2G on _

orgunitstructure_temp(organisationunituid) (JdbcResourceTableStore.java

[taskScheduler-1])

  • INFO 2015-12-07 17:41:06,582 [Level: ERROR, category:

RESOURCETABLE_UPDATE, time: Mon Dec 07 17:41:06 IST 2015, messa

ge: Process failed: StatementCallback; bad SQL grammar [drop table

_orgunitstructure;]; nested exception is com.mysql.jd

bc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table

‘dhis._orgunitstructure’] (InMemoryNotifier.java [tas

kScheduler-1])



Error3: Tried to copy resource table structures from old db and tried

generate resource table option, this time got the below error:

  • INFO 2015-12-07 18:05:19,296 [Level: ERROR, category:

RESOURCETABLE_UPDATE, time: Mon Dec 07 18:05:19 IST 2015, messa

ge: Process failed: StatementCallback; bad SQL grammar [create unique

index in_dataelementstructure_dataelementuid_M86c6

on _dataelementstructure_temp(dataelementuid);create index

in_dataelementstructure_datasetid_fVMFF on _dataelementstruc

ture_temp(datasetid);create index

in_dataelementstructure_datasetuid_nsdEu on

_dataelementstructure_temp(datasetuid);cre

ate index in_dataelementstructure_periodtypeid_EkjZg on

_dataelementstructure_temp(periodtypeid);]; nested exception is

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an

error in your SQL syntax; check the manual that c

orresponds to your MySQL server version for the right syntax to use near

'create index in_dataelementstructure_datasetid

_fVMFF on _dataelementstructure_te’ at line 1] (InMemoryNotifier.java

[taskScheduler-5])

  • ERROR 2015-12-07 18:05:19,319 Unexpected error occurred in scheduled

task. (TaskUtils.java [taskScheduler-5])

org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad

SQL grammar [create unique index in_dataelements

tructure_dataelementuid_M86c6 on

_dataelementstructure_temp(dataelementuid);create index

in_dataelementstructure_dataset

id_fVMFF on _dataelementstructure_temp(datasetid);create index

in_dataelementstructure_datasetuid_nsdEu on _dataelements

tructure_temp(datasetuid);create index

in_dataelementstructure_periodtypeid_EkjZg on

_dataelementstructure_temp(periodty

peid);]; nested exception is

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an

error in your SQL sy

ntax; check the manual that corresponds to your MySQL server version for

the right syntax to use near 'create index in_d

ataelementstructure_datasetid_fVMFF on _dataelementstructure_te’ at line

1

      at

org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTrans

lator.java:231)

      at

org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptio

nTranslator.java:73)

      at

org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416)

      at

org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:440)

      at

org.hisp.dhis.resourcetable.jdbc.JdbcResourceTableStore.generateResourceTable(JdbcResourceTableStore.java:118

)

      at

org.hisp.dhis.resourcetable.DefaultResourceTableService.generateDataElementTable(DefaultResourceTableService.

java:198)

      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown

Source)

      at java.lang.reflect.Method.invoke(Unknown Source)
      at

org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)

      at

org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:

      at

org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)

      at

org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterce

ptor.java:99)

      at

org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspec

tSupport.java:281)

      at

org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)

      at

org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)

      at

org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)

      at com.sun.proxy.$Proxy143.generateDataElementTable(Unknown

Source)

      at

org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.generateAll(ResourceTableTask.java:121)

      at

org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.run(ResourceTableTask.java:84)

      at

org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.ja

va:54)

      at java.util.concurrent.Executors$RunnableAdapter.call(Unknown

Source)

      at java.util.concurrent.FutureTask.run(Unknown Source)
      at

java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown

Source)

      at

java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown

Source)

      at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown

Source)

      at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown

Source)

      at java.lang.Thread.run(Unknown Source)

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:

You have an error in your SQL syntax; check the ma

nual that corresponds to your MySQL server version for the right syntax

to use near 'create index in_dataelementstructur

e_datasetid_fVMFF on _dataelementstructure_te’ at line 1

      at

sun.reflect.GeneratedConstructorAccessor53.newInstance(Unknown Source)

      at

sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

      at java.lang.reflect.Constructor.newInstance(Unknown Source)
      at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
      at com.mysql.jdbc.Util.getInstance(Util.java:360)
      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
      at

com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)

      at

com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)

      at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:848)
      at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:742)
      at

com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:1006)

      at

org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:432)

      at

org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:405)

      ... 26 more

To manage notifications about this bug go to:

https://bugs.launchpad.net/dhis2/+bug/1523882/+subscriptions

Thanks,

Neeraj Gupta

You received this bug notification because you are a member of DHIS 2

developers, which is subscribed to DHIS.

https://bugs.launchpad.net/bugs/1523882

Title:

Getting exception when upgraded application from Version 2.16 to 2.21

with Mysql dataase

Status in DHIS:

New

Bug description:

Dear All,

We recently upgraded DHIS 2.16 to 2.21 where database is Mysql some of

the errors are listed below.(We are using aggregated data not tracker)

Basically we are getting 3 errors

  • Error1: In mysql programrule table is not created automatically

  • Error2: While generating resource tables got the error, think the

query should be DROP TABLE IF EXISTS orgunitstructure; Same applies

for all resource tables.

  • Error3: Tried to copy resource table structures from old db and

tried generate resource table option, this time got the error:

The details of errors are given below.

While upgrading we ran all the sql update scripts.

Error1:

In mysql programrule table is not created automatically. While starting getting the below error:

  • ERROR 2015-12-07 17:36:56,864 Problem updating: programrule, id column: programruleid (IdentityPopulator.java [localho

st-startStop-1])

org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * from programrule WHERE uid

IS NULL]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table ‘dhis.programrule’

doesn’t exist

      at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTrans

lator.java:231)

      at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptio

nTranslator.java:73)

      at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416)

      at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:471)

      at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:526)

      at org.hisp.dhis.common.IdentityPopulator.execute(IdentityPopulator.java:86)

      at org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:117)

      at org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:86)

      at org.hisp.dhis.system.startup.StartupListener.contextInitialized(StartupListener.java:71)

      at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4729)

      at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5167)

      at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)

      at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)

      at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)

      at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)

      at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:945)

      at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1768)

      at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

      at java.util.concurrent.FutureTask.run(Unknown Source)

      at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

      at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

      at java.lang.Thread.run(Unknown Source)

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table ‘dhis.programrule’ doesn’t exist

      at sun.reflect.GeneratedConstructorAccessor53.newInstance(Unknown Source)

      at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

      at java.lang.reflect.Constructor.newInstance(Unknown Source)

      at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)

      at com.mysql.jdbc.Util.getInstance(Util.java:360)

      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978)

      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)

      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)

      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)

      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)

      at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)

      at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)

      at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1446)

      at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35)

      at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:455)

      at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:405)

      ... 19 more
  • INFO 2015-12-07 17:36:57,144 Executing startup routine [6 of 13, runlevel 5]: TableCreator (DefaultStartupRoutineExec

utor.java [localhost-startStop-1])



Error2: While generating resource tables got the below error, think

the query should be DROP TABLE IF EXISTS _orgunitstructure; Same

applies for all resource tables.

  • INFO 2015-12-07 17:41:06,417 [Level: INFO, category: RESOURCETABLE_UPDATE, time: Mon Dec 07 17:41:06 IST 2015, messag

e: Generating resource tables] (InMemoryNotifier.java [taskScheduler-1])

  • INFO 2015-12-07 17:41:06,465 Create table SQL: create table _orgunitstructure_temp (organisationunitid integer not nu

ll primary key, organisationunituid character(11), level integer, idlevel1 integer, uidlevel1 character(11), `idleve

l2integer,uidlevel2character(11),idlevel3integer,uidlevel3` character(11)); (JdbcResourceTableStore.java [ta

skScheduler-1])

  • INFO 2015-12-07 17:41:06,495 Populate table content rows: 203 (JdbcResourceTableStore.java [taskScheduler-1])

  • INFO 2015-12-07 17:41:06,546 Create index SQL: create unique index in_orgunitstructure_organisationunituid_VWU2G on _

orgunitstructure_temp(organisationunituid) (JdbcResourceTableStore.java [taskScheduler-1])

  • INFO 2015-12-07 17:41:06,582 [Level: ERROR, category: RESOURCETABLE_UPDATE, time: Mon Dec 07 17:41:06 IST 2015, messa

ge: Process failed: StatementCallback; bad SQL grammar [drop table _orgunitstructure;]; nested exception is com.mysql.jd

bc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table ‘dhis._orgunitstructure’] (InMemoryNotifier.java [tas

kScheduler-1])



Error3: Tried to copy resource table structures from old db and tried

generate resource table option, this time got the below error:

  • INFO 2015-12-07 18:05:19,296 [Level: ERROR, category: RESOURCETABLE_UPDATE, time: Mon Dec 07 18:05:19 IST 2015, messa

ge: Process failed: StatementCallback; bad SQL grammar [create unique index in_dataelementstructure_dataelementuid_M86c6

on _dataelementstructure_temp(dataelementuid);create index in_dataelementstructure_datasetid_fVMFF on _dataelementstruc

ture_temp(datasetid);create index in_dataelementstructure_datasetuid_nsdEu on _dataelementstructure_temp(datasetuid);cre

ate index in_dataelementstructure_periodtypeid_EkjZg on _dataelementstructure_temp(periodtypeid);]; nested exception is

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that c

orresponds to your MySQL server version for the right syntax to use near 'create index in_dataelementstructure_datasetid

_fVMFF on _dataelementstructure_te’ at line 1] (InMemoryNotifier.java [taskScheduler-5])

  • ERROR 2015-12-07 18:05:19,319 Unexpected error occurred in scheduled task. (TaskUtils.java [taskScheduler-5])

org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [create unique index in_dataelements

tructure_dataelementuid_M86c6 on _dataelementstructure_temp(dataelementuid);create index in_dataelementstructure_dataset

id_fVMFF on _dataelementstructure_temp(datasetid);create index in_dataelementstructure_datasetuid_nsdEu on _dataelements

tructure_temp(datasetuid);create index in_dataelementstructure_periodtypeid_EkjZg on _dataelementstructure_temp(periodty

peid);]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL sy

ntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'create index in_d

ataelementstructure_datasetid_fVMFF on _dataelementstructure_te’ at line 1

      at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTrans

lator.java:231)

      at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptio

nTranslator.java:73)

      at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416)

      at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:440)

      at org.hisp.dhis.resourcetable.jdbc.JdbcResourceTableStore.generateResourceTable(JdbcResourceTableStore.java:118

)

      at org.hisp.dhis.resourcetable.DefaultResourceTableService.generateDataElementTable(DefaultResourceTableService.

java:198)

      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

      at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

      at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

      at java.lang.reflect.Method.invoke(Unknown Source)

      at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)

      at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)

      at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterce

ptor.java:99)

      at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspec

tSupport.java:281)

      at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)

      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)

      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)

      at com.sun.proxy.$Proxy143.generateDataElementTable(Unknown Source)

      at org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.generateAll(ResourceTableTask.java:121)

      at org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.run(ResourceTableTask.java:84)

      at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.ja

va:54)

      at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

      at java.util.concurrent.FutureTask.run(Unknown Source)

      at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown Source)

      at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)

      at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

      at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

      at java.lang.Thread.run(Unknown Source)

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the ma

nual that corresponds to your MySQL server version for the right syntax to use near 'create index in_dataelementstructur

e_datasetid_fVMFF on _dataelementstructure_te’ at line 1

      at sun.reflect.GeneratedConstructorAccessor53.newInstance(Unknown Source)

      at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

      at java.lang.reflect.Constructor.newInstance(Unknown Source)

      at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)

      at com.mysql.jdbc.Util.getInstance(Util.java:360)

      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978)

      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)

      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)

      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)

      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)

      at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)

      at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)

      at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:848)

      at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:742)

      at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:1006)

      at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:432)

      at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:405)

      ... 26 more

To manage notifications about this bug go to:

https://bugs.launchpad.net/dhis2/+bug/1523882/+subscriptions


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

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

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

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

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

** Changed in: dhis2
    Milestone: None => 2.22

** Changed in: dhis2
     Assignee: (unassigned) => Lars Helge Øverland (larshelge)

** Changed in: dhis2
   Importance: Undecided => Medium

** Changed in: dhis2
       Status: New => Fix Committed

···

--
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1523882

Title:
  Getting exception when upgraded application from Version 2.16 to 2.21
  with Mysql dataase

Status in DHIS:
  Fix Committed

Bug description:
  Dear All,

  We recently upgraded DHIS 2.16 to 2.21 where database is Mysql some of
  the errors are listed below.(We are using aggregated data not tracker)

  Basically we are getting 3 errors
  - Error1: In mysql programrule table is not created automatically

  - Error2: While generating resource tables got the error, think the
  query should be DROP TABLE IF EXISTS orgunitstructure; Same applies
  for all resource tables.

  - Error3: Tried to copy resource table structures from old db and
  tried generate resource table option, this time got the error:

  The details of errors are given below.

  While upgrading we ran all the sql update scripts.

  Error1:
  In mysql programrule table is not created automatically. While starting getting the below error:

  * ERROR 2015-12-07 17:36:56,864 Problem updating: programrule, id column: programruleid (IdentityPopulator.java [localho
  st-startStop-1])
  org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * from programrule WHERE uid
   IS NULL]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'dhis.programrule'
   doesn't exist
          at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTrans
  lator.java:231)
          at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptio
  nTranslator.java:73)
          at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416)
          at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:471)
          at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:526)
          at org.hisp.dhis.common.IdentityPopulator.execute(IdentityPopulator.java:86)
          at org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:117)
          at org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:86)
          at org.hisp.dhis.system.startup.StartupListener.contextInitialized(StartupListener.java:71)
          at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4729)
          at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5167)
          at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
          at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)
          at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)
          at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
          at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:945)
          at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1768)
          at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
          at java.util.concurrent.FutureTask.run(Unknown Source)
          at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
          at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
          at java.lang.Thread.run(Unknown Source)
  Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'dhis.programrule' doesn't exist
          at sun.reflect.GeneratedConstructorAccessor53.newInstance(Unknown Source)
          at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
          at java.lang.reflect.Constructor.newInstance(Unknown Source)
          at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
          at com.mysql.jdbc.Util.getInstance(Util.java:360)
          at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978)
          at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
          at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
          at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
          at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
          at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)
          at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
          at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1446)
          at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35)
          at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:455)
          at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:405)
          ... 19 more
  * INFO 2015-12-07 17:36:57,144 Executing startup routine [6 of 13, runlevel 5]: TableCreator (DefaultStartupRoutineExec
  utor.java [localhost-startStop-1])

  ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

  Error2: While generating resource tables got the below error, think
  the query should be DROP TABLE IF EXISTS _orgunitstructure; Same
  applies for all resource tables.

  * INFO 2015-12-07 17:41:06,417 [Level: INFO, category: RESOURCETABLE_UPDATE, time: Mon Dec 07 17:41:06 IST 2015, messag
  e: Generating resource tables] (InMemoryNotifier.java [taskScheduler-1])
  * INFO 2015-12-07 17:41:06,465 Create table SQL: create table _orgunitstructure_temp (organisationunitid integer not nu
  ll primary key, organisationunituid character(11), level integer, `idlevel1` integer, `uidlevel1` character(11), `idleve
  l2` integer, `uidlevel2` character(11), `idlevel3` integer, `uidlevel3` character(11)); (JdbcResourceTableStore.java [ta
  skScheduler-1])
  * INFO 2015-12-07 17:41:06,495 Populate table content rows: 203 (JdbcResourceTableStore.java [taskScheduler-1])
  * INFO 2015-12-07 17:41:06,546 Create index SQL: create unique index in_orgunitstructure_organisationunituid_VWU2G on _
  orgunitstructure_temp(organisationunituid) (JdbcResourceTableStore.java [taskScheduler-1])
  * INFO 2015-12-07 17:41:06,582 [Level: ERROR, category: RESOURCETABLE_UPDATE, time: Mon Dec 07 17:41:06 IST 2015, messa
  ge: Process failed: StatementCallback; bad SQL grammar [drop table _orgunitstructure;]; nested exception is com.mysql.jd
  bc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'dhis._orgunitstructure'] (InMemoryNotifier.java [tas
  kScheduler-1])

  ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

  Error3: Tried to copy resource table structures from old db and tried
  generate resource table option, this time got the below error:

  * INFO 2015-12-07 18:05:19,296 [Level: ERROR, category: RESOURCETABLE_UPDATE, time: Mon Dec 07 18:05:19 IST 2015, messa
  ge: Process failed: StatementCallback; bad SQL grammar [create unique index in_dataelementstructure_dataelementuid_M86c6
   on _dataelementstructure_temp(dataelementuid);create index in_dataelementstructure_datasetid_fVMFF on _dataelementstruc
  ture_temp(datasetid);create index in_dataelementstructure_datasetuid_nsdEu on _dataelementstructure_temp(datasetuid);cre
  ate index in_dataelementstructure_periodtypeid_EkjZg on _dataelementstructure_temp(periodtypeid);]; nested exception is
  com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that c
  orresponds to your MySQL server version for the right syntax to use near 'create index in_dataelementstructure_datasetid
  _fVMFF on _dataelementstructure_te' at line 1] (InMemoryNotifier.java [taskScheduler-5])
  * ERROR 2015-12-07 18:05:19,319 Unexpected error occurred in scheduled task. (TaskUtils.java [taskScheduler-5])
  org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [create unique index in_dataelements
  tructure_dataelementuid_M86c6 on _dataelementstructure_temp(dataelementuid);create index in_dataelementstructure_dataset
  id_fVMFF on _dataelementstructure_temp(datasetid);create index in_dataelementstructure_datasetuid_nsdEu on _dataelements
  tructure_temp(datasetuid);create index in_dataelementstructure_periodtypeid_EkjZg on _dataelementstructure_temp(periodty
  peid);]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL sy
  ntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'create index in_d
  ataelementstructure_datasetid_fVMFF on _dataelementstructure_te' at line 1
          at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTrans
  lator.java:231)
          at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptio
  nTranslator.java:73)
          at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416)
          at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:440)
          at org.hisp.dhis.resourcetable.jdbc.JdbcResourceTableStore.generateResourceTable(JdbcResourceTableStore.java:118
  )
          at org.hisp.dhis.resourcetable.DefaultResourceTableService.generateDataElementTable(DefaultResourceTableService.
  java:198)
          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
          at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
          at java.lang.reflect.Method.invoke(Unknown Source)
          at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:
  190)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
          at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterce
  ptor.java:99)
          at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspec
  tSupport.java:281)
          at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
          at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
          at com.sun.proxy.$Proxy143.generateDataElementTable(Unknown Source)
          at org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.generateAll(ResourceTableTask.java:121)
          at org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.run(ResourceTableTask.java:84)
          at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.ja
  va:54)
          at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
          at java.util.concurrent.FutureTask.run(Unknown Source)
          at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown Source)
          at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
          at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
          at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
          at java.lang.Thread.run(Unknown Source)
  Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the ma
  nual that corresponds to your MySQL server version for the right syntax to use near 'create index in_dataelementstructur
  e_datasetid_fVMFF on _dataelementstructure_te' at line 1
          at sun.reflect.GeneratedConstructorAccessor53.newInstance(Unknown Source)
          at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
          at java.lang.reflect.Constructor.newInstance(Unknown Source)
          at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
          at com.mysql.jdbc.Util.getInstance(Util.java:360)
          at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978)
          at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
          at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
          at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
          at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
          at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)
          at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
          at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:848)
          at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:742)
          at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:1006)
          at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:432)
          at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:405)
          ... 26 more

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1523882/+subscriptions

** Changed in: dhis2
       Status: Fix Committed => Fix Released

···

--
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1523882

Title:
  Getting exception when upgraded application from Version 2.16 to 2.21
  with Mysql dataase

Status in DHIS:
  Fix Released

Bug description:
  Dear All,

  We recently upgraded DHIS 2.16 to 2.21 where database is Mysql some of
  the errors are listed below.(We are using aggregated data not tracker)

  Basically we are getting 3 errors
  - Error1: In mysql programrule table is not created automatically

  - Error2: While generating resource tables got the error, think the
  query should be DROP TABLE IF EXISTS orgunitstructure; Same applies
  for all resource tables.

  - Error3: Tried to copy resource table structures from old db and
  tried generate resource table option, this time got the error:

  The details of errors are given below.

  While upgrading we ran all the sql update scripts.

  Error1:
  In mysql programrule table is not created automatically. While starting getting the below error:

  * ERROR 2015-12-07 17:36:56,864 Problem updating: programrule, id column: programruleid (IdentityPopulator.java [localho
  st-startStop-1])
  org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * from programrule WHERE uid
   IS NULL]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'dhis.programrule'
   doesn't exist
          at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTrans
  lator.java:231)
          at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptio
  nTranslator.java:73)
          at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416)
          at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:471)
          at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:526)
          at org.hisp.dhis.common.IdentityPopulator.execute(IdentityPopulator.java:86)
          at org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:117)
          at org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:86)
          at org.hisp.dhis.system.startup.StartupListener.contextInitialized(StartupListener.java:71)
          at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4729)
          at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5167)
          at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
          at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)
          at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)
          at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
          at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:945)
          at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1768)
          at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
          at java.util.concurrent.FutureTask.run(Unknown Source)
          at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
          at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
          at java.lang.Thread.run(Unknown Source)
  Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'dhis.programrule' doesn't exist
          at sun.reflect.GeneratedConstructorAccessor53.newInstance(Unknown Source)
          at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
          at java.lang.reflect.Constructor.newInstance(Unknown Source)
          at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
          at com.mysql.jdbc.Util.getInstance(Util.java:360)
          at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978)
          at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
          at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
          at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
          at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
          at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)
          at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
          at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1446)
          at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35)
          at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:455)
          at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:405)
          ... 19 more
  * INFO 2015-12-07 17:36:57,144 Executing startup routine [6 of 13, runlevel 5]: TableCreator (DefaultStartupRoutineExec
  utor.java [localhost-startStop-1])

  ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

  Error2: While generating resource tables got the below error, think
  the query should be DROP TABLE IF EXISTS _orgunitstructure; Same
  applies for all resource tables.

  * INFO 2015-12-07 17:41:06,417 [Level: INFO, category: RESOURCETABLE_UPDATE, time: Mon Dec 07 17:41:06 IST 2015, messag
  e: Generating resource tables] (InMemoryNotifier.java [taskScheduler-1])
  * INFO 2015-12-07 17:41:06,465 Create table SQL: create table _orgunitstructure_temp (organisationunitid integer not nu
  ll primary key, organisationunituid character(11), level integer, `idlevel1` integer, `uidlevel1` character(11), `idleve
  l2` integer, `uidlevel2` character(11), `idlevel3` integer, `uidlevel3` character(11)); (JdbcResourceTableStore.java [ta
  skScheduler-1])
  * INFO 2015-12-07 17:41:06,495 Populate table content rows: 203 (JdbcResourceTableStore.java [taskScheduler-1])
  * INFO 2015-12-07 17:41:06,546 Create index SQL: create unique index in_orgunitstructure_organisationunituid_VWU2G on _
  orgunitstructure_temp(organisationunituid) (JdbcResourceTableStore.java [taskScheduler-1])
  * INFO 2015-12-07 17:41:06,582 [Level: ERROR, category: RESOURCETABLE_UPDATE, time: Mon Dec 07 17:41:06 IST 2015, messa
  ge: Process failed: StatementCallback; bad SQL grammar [drop table _orgunitstructure;]; nested exception is com.mysql.jd
  bc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'dhis._orgunitstructure'] (InMemoryNotifier.java [tas
  kScheduler-1])

  ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

  Error3: Tried to copy resource table structures from old db and tried
  generate resource table option, this time got the below error:

  * INFO 2015-12-07 18:05:19,296 [Level: ERROR, category: RESOURCETABLE_UPDATE, time: Mon Dec 07 18:05:19 IST 2015, messa
  ge: Process failed: StatementCallback; bad SQL grammar [create unique index in_dataelementstructure_dataelementuid_M86c6
   on _dataelementstructure_temp(dataelementuid);create index in_dataelementstructure_datasetid_fVMFF on _dataelementstruc
  ture_temp(datasetid);create index in_dataelementstructure_datasetuid_nsdEu on _dataelementstructure_temp(datasetuid);cre
  ate index in_dataelementstructure_periodtypeid_EkjZg on _dataelementstructure_temp(periodtypeid);]; nested exception is
  com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that c
  orresponds to your MySQL server version for the right syntax to use near 'create index in_dataelementstructure_datasetid
  _fVMFF on _dataelementstructure_te' at line 1] (InMemoryNotifier.java [taskScheduler-5])
  * ERROR 2015-12-07 18:05:19,319 Unexpected error occurred in scheduled task. (TaskUtils.java [taskScheduler-5])
  org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [create unique index in_dataelements
  tructure_dataelementuid_M86c6 on _dataelementstructure_temp(dataelementuid);create index in_dataelementstructure_dataset
  id_fVMFF on _dataelementstructure_temp(datasetid);create index in_dataelementstructure_datasetuid_nsdEu on _dataelements
  tructure_temp(datasetuid);create index in_dataelementstructure_periodtypeid_EkjZg on _dataelementstructure_temp(periodty
  peid);]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL sy
  ntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'create index in_d
  ataelementstructure_datasetid_fVMFF on _dataelementstructure_te' at line 1
          at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTrans
  lator.java:231)
          at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptio
  nTranslator.java:73)
          at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416)
          at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:440)
          at org.hisp.dhis.resourcetable.jdbc.JdbcResourceTableStore.generateResourceTable(JdbcResourceTableStore.java:118
  )
          at org.hisp.dhis.resourcetable.DefaultResourceTableService.generateDataElementTable(DefaultResourceTableService.
  java:198)
          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
          at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
          at java.lang.reflect.Method.invoke(Unknown Source)
          at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:
  190)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
          at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterce
  ptor.java:99)
          at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspec
  tSupport.java:281)
          at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
          at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
          at com.sun.proxy.$Proxy143.generateDataElementTable(Unknown Source)
          at org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.generateAll(ResourceTableTask.java:121)
          at org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.run(ResourceTableTask.java:84)
          at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.ja
  va:54)
          at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
          at java.util.concurrent.FutureTask.run(Unknown Source)
          at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown Source)
          at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
          at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
          at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
          at java.lang.Thread.run(Unknown Source)
  Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the ma
  nual that corresponds to your MySQL server version for the right syntax to use near 'create index in_dataelementstructur
  e_datasetid_fVMFF on _dataelementstructure_te' at line 1
          at sun.reflect.GeneratedConstructorAccessor53.newInstance(Unknown Source)
          at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
          at java.lang.reflect.Constructor.newInstance(Unknown Source)
          at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
          at com.mysql.jdbc.Util.getInstance(Util.java:360)
          at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978)
          at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
          at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
          at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
          at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
          at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)
          at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
          at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:848)
          at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:742)
          at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:1006)
          at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:432)
          at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:405)
          ... 26 more

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1523882/+subscriptions