Sure Lars, Will test and let you know the results. On Wed, Dec 9, 2015 at 5:49 PM, Lars Helge Øverland <larshe...@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.h...@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 < >> 1523...@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
_______________________________________________ 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
