← Back to team overview

dhis2-devs team mailing list archive

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

 

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@xxxxxxxxx> 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@xxxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
> 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>

Follow ups

References