Hi, has anyone had a chance to look at this? Regards Olav
> 20. mai 2015 kl. 21.53 skrev Olav P <[email protected]>: > > Public bug reported: > > Analytics process fails with latest 2.18 on mysql. BadSQLgrammar. Error > below. Tested with "real" database, and with a blank database where I've > added a few values to test. > > > * INFO 2015-05-20 21:43:02,748 Data element category option combo table > generated (DefaultResourceTableService.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:02,955 [Level: INFO, category: DATAMART, time: Wed > May 20 21:43:02 CEST 2015, message: Updating analytics tables] > (InMemoryNotifier.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:02,959 Starting update, processes: 7, org unit > levels: 3: 0:00:00.000 (Clock.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:02,965 Approval enabled: false > (JdbcAnalyticsTableManager.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:02,966 Get tables using earliest: null > (AbstractJdbcTableManager.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,065 Table update start: analytics, partitions: > [analytics_1990, analytics_1991, analytics_1992, analytics_1993, > analytics_1994, analytics_1995, analytics_1996, analytics_1997, > analytics_1998, analytics_1999, analytics_2000, analytics_2001, > analytics_2002, analytics_2003, analytics_2004, analytics_2005, > analytics_2006, analytics_2007, analytics_2008, analytics_2009, > analytics_2010, analytics_2011, analytics_2012, analytics_2013, > analytics_2014], last years: null, earliest: null: 0:00:00.108 (Clock.java > [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,065 [Level: INFO, category: DATAMART, time: Wed > May 20 21:43:03 CEST 2015, message: Performing pre-create table work, > processes: 7, org unit levels: 3] (InMemoryNotifier.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,068 Performed pre-create table work: 0:00:00.111 > (Clock.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,068 [Level: INFO, category: DATAMART, time: Wed > May 20 21:43:03 CEST 2015, message: Creating analytics tables] > (InMemoryNotifier.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,076 Creating table: analytics_temp_1990, columns: > 26 (JdbcAnalyticsTableManager.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,084 Creating table: analytics_temp_1991, columns: > 26 (JdbcAnalyticsTableManager.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,091 Creating table: analytics_temp_1992, columns: > 26 (JdbcAnalyticsTableManager.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,099 Creating table: analytics_temp_1993, columns: > 26 (JdbcAnalyticsTableManager.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,108 Creating table: analytics_temp_1994, columns: > 26 (JdbcAnalyticsTableManager.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,116 Creating table: analytics_temp_1995, columns: > 26 (JdbcAnalyticsTableManager.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,125 Creating table: analytics_temp_1996, columns: > 26 (JdbcAnalyticsTableManager.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,134 Creating table: analytics_temp_1997, columns: > 26 (JdbcAnalyticsTableManager.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,143 Creating table: analytics_temp_1998, columns: > 26 (JdbcAnalyticsTableManager.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,152 Creating table: analytics_temp_1999, columns: > 26 (JdbcAnalyticsTableManager.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,161 Creating table: analytics_temp_2000, columns: > 26 (JdbcAnalyticsTableManager.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,170 Creating table: analytics_temp_2001, columns: > 26 (JdbcAnalyticsTableManager.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,178 Creating table: analytics_temp_2002, columns: > 26 (JdbcAnalyticsTableManager.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,185 Creating table: analytics_temp_2003, columns: > 26 (JdbcAnalyticsTableManager.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,191 Creating table: analytics_temp_2004, columns: > 26 (JdbcAnalyticsTableManager.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,198 Creating table: analytics_temp_2005, columns: > 26 (JdbcAnalyticsTableManager.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,205 Creating table: analytics_temp_2006, columns: > 26 (JdbcAnalyticsTableManager.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,213 Creating table: analytics_temp_2007, columns: > 26 (JdbcAnalyticsTableManager.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,221 Creating table: analytics_temp_2008, columns: > 26 (JdbcAnalyticsTableManager.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,229 Creating table: analytics_temp_2009, columns: > 26 (JdbcAnalyticsTableManager.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,238 Creating table: analytics_temp_2010, columns: > 26 (JdbcAnalyticsTableManager.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,246 Creating table: analytics_temp_2011, columns: > 26 (JdbcAnalyticsTableManager.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,254 Creating table: analytics_temp_2012, columns: > 26 (JdbcAnalyticsTableManager.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,264 Creating table: analytics_temp_2013, columns: > 26 (JdbcAnalyticsTableManager.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,273 Creating table: analytics_temp_2014, columns: > 26 (JdbcAnalyticsTableManager.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,275 Created analytics tables: 0:00:00.318 > (Clock.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,275 [Level: INFO, category: DATAMART, time: Wed > May 20 21:43:03 CEST 2015, message: Populating analytics tables] > (InMemoryNotifier.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,276 Populate table task number: 7 > (DefaultAnalyticsTableService.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,301 [Level: ERROR, category: DATAMART, time: Wed > May 20 21:43:03 CEST 2015, message: Process failed: Exception during > execution] (InMemoryNotifier.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,333 SMSLib: A Java API library for sending and > receiving SMS via a GSM modem or other supported gateways. > This software is distributed under the terms of the Apache v2.0 License. > Web Site: http://smslib.org (Service.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,334 Version: 3.5.3 (Service.java > [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,334 JRE Version: 1.8.0_25 (Service.java > [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,334 JRE Impl Version: 25.25-b02 (Service.java > [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,335 O/S: Mac OS X / x86_64 / 10.10.3 > (Service.java [taskScheduler-1]) > * ERROR 2015-05-20 21:43:03,348 Unexpected error occurred in scheduled task. > (TaskUtils.java [taskScheduler-1]) > java.lang.RuntimeException: Exception during execution > at > org.hisp.dhis.system.util.ConcurrentUtils.waitForCompletion(ConcurrentUtils.java:55) > at > org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.populateTables(DefaultAnalyticsTableService.java:216) > at > org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.update(DefaultAnalyticsTableService.java:128) > at > org.hisp.dhis.analytics.scheduling.AnalyticsTableTask.run(AnalyticsTableTask.java:137) > at org.hisp.dhis.scheduling.ScheduledTasks.run(ScheduledTasks.java:60) > at > org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) > at > java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) > at java.util.concurrent.FutureTask.run(FutureTask.java:266) > at > java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) > at > java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > at java.lang.Thread.run(Thread.java:745) > Caused by: java.util.concurrent.ExecutionException: > org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL > grammar [insert into analytics_temp_1991 > (`Ryvpin5RJZM`,`uM9aEW3ptDy`,`OJ8CtfEKUO7`,`MaShSyRIODt`,`DRilySX62w8`,`Jf8GswsWlGW`,`Kt01M6IvAjA`,`Ly8b2oSN196`,`uidlevel1`,`uidlevel2`,`uidlevel3`,`daily`,`weekly`,`monthly`,`bimonthly`,`quarterly`,`sixmonthly`,`sixmonthlyapril`,`yearly`,`financialapril`,`financialjuly`,`financialoct`,`de`,`co`,`ou`,`level`,daysxvalue, > daysno, value, textvalue) select > ougs.`Ryvpin5RJZM`,ougs.`uM9aEW3ptDy`,ougs.`OJ8CtfEKUO7`,dcs.`MaShSyRIODt`,dcs.`DRilySX62w8`,dcs.`Jf8GswsWlGW`,dcs.`Kt01M6IvAjA`,dcs.`Ly8b2oSN196`,ous.`uidlevel1`,ous.`uidlevel2`,ous.`uidlevel3`,ps.`daily`,ps.`weekly`,ps.`monthly`,ps.`bimonthly`,ps.`quarterly`,ps.`sixmonthly`,ps.`sixmonthlyapril`,ps.`yearly`,ps.`financialapril`,ps.`financialjuly`,ps.`financialoct`,de.uid,co.uid,ou.uid,ous.level,cast(dv.value > as decimal(26,1)) * ps.daysno as daysxvalue, ps.daysno as d aysno, cast(dv.value as decimal(26,1)) as value, null as textvalue from datavalue dv left join _dataelementgroupsetstructure degs on dv.dataelementid=degs.dataelementid left join _organisationunitgroupsetstructure ougs on dv.sourceid=ougs.organisationunitid left join _categoryoptiongroupsetstructure cogs on dv.attributeoptioncomboid=cogs.categoryoptioncomboid left join _categorystructure dcs on dv.categoryoptioncomboid=dcs.categoryoptioncomboid left join _categorystructure acs on dv.attributeoptioncomboid=acs.categoryoptioncomboid left join _orgunitstructure ous on dv.sourceid=ous.organisationunitid left join _dataelementstructure des on dv.dataelementid = des.dataelementid inner join dataelement de on dv.dataelementid=de.dataelementid inner join categoryoptioncombo co on dv.categoryoptioncomboid=co.categoryoptioncomboid inner join _categoryoptioncomboname aon on dv.attributeoptioncomboid=aon.categoryoptioncomboid inner join period pe on dv.periodid=pe.periodid inner join _periodstr ucture ps on dv.periodid=ps.periodid inner join organisationunit ou on dv.sourceid=ou.organisationunitid where de.valuetype = 'int' and de.domaintype = 'AGGREGATE' and pe.startdate >= '1991-01-01' and pe.startdate <= '1991-12-31' and dv.value is not null and dv.value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$' and ( dv.value != '0' or de.aggregationtype = 'average' or de.zeroissignificant = true ) ]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'wmrdhis.analytics_temp_1991' doesn't exist > at java.util.concurrent.FutureTask.report(FutureTask.java:122) > at java.util.concurrent.FutureTask.get(FutureTask.java:192) > at > org.hisp.dhis.system.util.ConcurrentUtils.waitForCompletion(ConcurrentUtils.java:51) > ... 12 more > Caused by: org.springframework.jdbc.BadSqlGrammarException: > StatementCallback; bad SQL grammar [insert into analytics_temp_1991 > (`Ryvpin5RJZM`,`uM9aEW3ptDy`,`OJ8CtfEKUO7`,`MaShSyRIODt`,`DRilySX62w8`,`Jf8GswsWlGW`,`Kt01M6IvAjA`,`Ly8b2oSN196`,`uidlevel1`,`uidlevel2`,`uidlevel3`,`daily`,`weekly`,`monthly`,`bimonthly`,`quarterly`,`sixmonthly`,`sixmonthlyapril`,`yearly`,`financialapril`,`financialjuly`,`financialoct`,`de`,`co`,`ou`,`level`,daysxvalue, > daysno, value, textvalue) select > ougs.`Ryvpin5RJZM`,ougs.`uM9aEW3ptDy`,ougs.`OJ8CtfEKUO7`,dcs.`MaShSyRIODt`,dcs.`DRilySX62w8`,dcs.`Jf8GswsWlGW`,dcs.`Kt01M6IvAjA`,dcs.`Ly8b2oSN196`,ous.`uidlevel1`,ous.`uidlevel2`,ous.`uidlevel3`,ps.`daily`,ps.`weekly`,ps.`monthly`,ps.`bimonthly`,ps.`quarterly`,ps.`sixmonthly`,ps.`sixmonthlyapril`,ps.`yearly`,ps.`financialapril`,ps.`financialjuly`,ps.`financialoct`,de.uid,co.uid,ou.uid,ous.level,cast(dv.value > as decimal(26,1)) * ps.daysno as daysxvalue, ps.daysno as daysno, > cast(dv.value as decimal(26,1)) as value, null as textvalue from datavalue dv left join _dataelementgroupsetstructure degs on dv.dataelementid=degs.dataelementid left join _organisationunitgroupsetstructure ougs on dv.sourceid=ougs.organisationunitid left join _categoryoptiongroupsetstructure cogs on dv.attributeoptioncomboid=cogs.categoryoptioncomboid left join _categorystructure dcs on dv.categoryoptioncomboid=dcs.categoryoptioncomboid left join _categorystructure acs on dv.attributeoptioncomboid=acs.categoryoptioncomboid left join _orgunitstructure ous on dv.sourceid=ous.organisationunitid left join _dataelementstructure des on dv.dataelementid = des.dataelementid inner join dataelement de on dv.dataelementid=de.dataelementid inner join categoryoptioncombo co on dv.categoryoptioncomboid=co.categoryoptioncomboid inner join _categoryoptioncomboname aon on dv.attributeoptioncomboid=aon.categoryoptioncomboid inner join period pe on dv.periodid=pe.periodid inner join _periodstructure ps on dv.periodid=ps.periodid inne r join organisationunit ou on dv.sourceid=ou.organisationunitid where de.valuetype = 'int' and de.domaintype = 'AGGREGATE' and pe.startdate >= '1991-01-01' and pe.startdate <= '1991-12-31' and dv.value is not null and dv.value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$' and ( dv.value != '0' or de.aggregationtype = 'average' or de.zeroissignificant = true ) ]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'wmrdhis.analytics_temp_1991' doesn't exist > at > org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231) > at > org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73) > at > org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416) > at > org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:440) > at > org.hisp.dhis.analytics.table.AbstractJdbcTableManager.populateAndLog(AbstractJdbcTableManager.java:330) > at > org.hisp.dhis.analytics.table.JdbcAnalyticsTableManager.populateTable(JdbcAnalyticsTableManager.java:253) > at > org.hisp.dhis.analytics.table.JdbcAnalyticsTableManager.populateTableAsync(JdbcAnalyticsTableManager.java:173) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:483) > 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.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:110) > at java.util.concurrent.FutureTask.run(FutureTask.java:266) > ... 1 more > Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table > 'wmrdhis.analytics_temp_1991' doesn't exist > at sun.reflect.GeneratedConstructorAccessor71.newInstance(Unknown > Source) > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.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:405) > ... 14 more > > ** Affects: dhis2 > Importance: Undecided > Status: New > > -- > You received this bug notification because you are subscribed to the bug > report. > https://bugs.launchpad.net/bugs/1457198 > > Title: > analytics fails with mysql on 2.18 > > Status in DHIS 2: > New > > Bug description: > Analytics process fails with latest 2.18 on mysql. BadSQLgrammar. > Error below. Tested with "real" database, and with a blank database > where I've added a few values to test. > > > > * INFO 2015-05-20 21:43:02,748 Data element category option combo table > generated (DefaultResourceTableService.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:02,955 [Level: INFO, category: DATAMART, time: Wed > May 20 21:43:02 CEST 2015, message: Updating analytics tables] > (InMemoryNotifier.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:02,959 Starting update, processes: 7, org unit > levels: 3: 0:00:00.000 (Clock.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:02,965 Approval enabled: false > (JdbcAnalyticsTableManager.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:02,966 Get tables using earliest: null > (AbstractJdbcTableManager.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,065 Table update start: analytics, partitions: > [analytics_1990, analytics_1991, analytics_1992, analytics_1993, > analytics_1994, analytics_1995, analytics_1996, analytics_1997, > analytics_1998, analytics_1999, analytics_2000, analytics_2001, > analytics_2002, analytics_2003, analytics_2004, analytics_2005, > analytics_2006, analytics_2007, analytics_2008, analytics_2009, > analytics_2010, analytics_2011, analytics_2012, analytics_2013, > analytics_2014], last years: null, earliest: null: 0:00:00.108 (Clock.java > [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,065 [Level: INFO, category: DATAMART, time: Wed > May 20 21:43:03 CEST 2015, message: Performing pre-create table work, > processes: 7, org unit levels: 3] (InMemoryNotifier.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,068 Performed pre-create table work: 0:00:00.111 > (Clock.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,068 [Level: INFO, category: DATAMART, time: Wed > May 20 21:43:03 CEST 2015, message: Creating analytics tables] > (InMemoryNotifier.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,076 Creating table: analytics_temp_1990, > columns: 26 (JdbcAnalyticsTableManager.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,084 Creating table: analytics_temp_1991, > columns: 26 (JdbcAnalyticsTableManager.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,091 Creating table: analytics_temp_1992, > columns: 26 (JdbcAnalyticsTableManager.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,099 Creating table: analytics_temp_1993, > columns: 26 (JdbcAnalyticsTableManager.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,108 Creating table: analytics_temp_1994, > columns: 26 (JdbcAnalyticsTableManager.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,116 Creating table: analytics_temp_1995, > columns: 26 (JdbcAnalyticsTableManager.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,125 Creating table: analytics_temp_1996, > columns: 26 (JdbcAnalyticsTableManager.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,134 Creating table: analytics_temp_1997, > columns: 26 (JdbcAnalyticsTableManager.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,143 Creating table: analytics_temp_1998, > columns: 26 (JdbcAnalyticsTableManager.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,152 Creating table: analytics_temp_1999, > columns: 26 (JdbcAnalyticsTableManager.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,161 Creating table: analytics_temp_2000, > columns: 26 (JdbcAnalyticsTableManager.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,170 Creating table: analytics_temp_2001, > columns: 26 (JdbcAnalyticsTableManager.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,178 Creating table: analytics_temp_2002, > columns: 26 (JdbcAnalyticsTableManager.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,185 Creating table: analytics_temp_2003, > columns: 26 (JdbcAnalyticsTableManager.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,191 Creating table: analytics_temp_2004, > columns: 26 (JdbcAnalyticsTableManager.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,198 Creating table: analytics_temp_2005, > columns: 26 (JdbcAnalyticsTableManager.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,205 Creating table: analytics_temp_2006, > columns: 26 (JdbcAnalyticsTableManager.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,213 Creating table: analytics_temp_2007, > columns: 26 (JdbcAnalyticsTableManager.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,221 Creating table: analytics_temp_2008, > columns: 26 (JdbcAnalyticsTableManager.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,229 Creating table: analytics_temp_2009, > columns: 26 (JdbcAnalyticsTableManager.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,238 Creating table: analytics_temp_2010, > columns: 26 (JdbcAnalyticsTableManager.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,246 Creating table: analytics_temp_2011, > columns: 26 (JdbcAnalyticsTableManager.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,254 Creating table: analytics_temp_2012, > columns: 26 (JdbcAnalyticsTableManager.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,264 Creating table: analytics_temp_2013, > columns: 26 (JdbcAnalyticsTableManager.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,273 Creating table: analytics_temp_2014, > columns: 26 (JdbcAnalyticsTableManager.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,275 Created analytics tables: 0:00:00.318 > (Clock.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,275 [Level: INFO, category: DATAMART, time: Wed > May 20 21:43:03 CEST 2015, message: Populating analytics tables] > (InMemoryNotifier.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,276 Populate table task number: 7 > (DefaultAnalyticsTableService.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,301 [Level: ERROR, category: DATAMART, time: Wed > May 20 21:43:03 CEST 2015, message: Process failed: Exception during > execution] (InMemoryNotifier.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,333 SMSLib: A Java API library for sending and > receiving SMS via a GSM modem or other supported gateways. > This software is distributed under the terms of the Apache v2.0 License. > Web Site: http://smslib.org (Service.java [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,334 Version: 3.5.3 (Service.java > [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,334 JRE Version: 1.8.0_25 (Service.java > [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,334 JRE Impl Version: 25.25-b02 (Service.java > [taskScheduler-1]) > * INFO 2015-05-20 21:43:03,335 O/S: Mac OS X / x86_64 / 10.10.3 > (Service.java [taskScheduler-1]) > * ERROR 2015-05-20 21:43:03,348 Unexpected error occurred in scheduled task. > (TaskUtils.java [taskScheduler-1]) > java.lang.RuntimeException: Exception during execution > at > org.hisp.dhis.system.util.ConcurrentUtils.waitForCompletion(ConcurrentUtils.java:55) > at > org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.populateTables(DefaultAnalyticsTableService.java:216) > at > org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.update(DefaultAnalyticsTableService.java:128) > at > org.hisp.dhis.analytics.scheduling.AnalyticsTableTask.run(AnalyticsTableTask.java:137) > at org.hisp.dhis.scheduling.ScheduledTasks.run(ScheduledTasks.java:60) > at > org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) > at > java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) > at java.util.concurrent.FutureTask.run(FutureTask.java:266) > at > java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) > at > java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > at java.lang.Thread.run(Thread.java:745) > Caused by: java.util.concurrent.ExecutionException: > org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL > grammar [insert into analytics_temp_1991 > (`Ryvpin5RJZM`,`uM9aEW3ptDy`,`OJ8CtfEKUO7`,`MaShSyRIODt`,`DRilySX62w8`,`Jf8GswsWlGW`,`Kt01M6IvAjA`,`Ly8b2oSN196`,`uidlevel1`,`uidlevel2`,`uidlevel3`,`daily`,`weekly`,`monthly`,`bimonthly`,`quarterly`,`sixmonthly`,`sixmonthlyapril`,`yearly`,`financialapril`,`financialjuly`,`financialoct`,`de`,`co`,`ou`,`level`,daysxvalue, > daysno, value, textvalue) select > ougs.`Ryvpin5RJZM`,ougs.`uM9aEW3ptDy`,ougs.`OJ8CtfEKUO7`,dcs.`MaShSyRIODt`,dcs.`DRilySX62w8`,dcs.`Jf8GswsWlGW`,dcs.`Kt01M6IvAjA`,dcs.`Ly8b2oSN196`,ous.`uidlevel1`,ous.`uidlevel2`,ous.`uidlevel3`,ps.`daily`,ps.`weekly`,ps.`monthly`,ps.`bimonthly`,ps.`quarterly`,ps.`sixmonthly`,ps.`sixmonthlyapril`,ps.`yearly`,ps.`financialapril`,ps.`financialjuly`,ps.`financialoct`,de.uid,co.uid,ou.uid,ous.level,cast(dv.value > as decimal(26,1)) * ps.daysno as daysxvalue, ps.daysno as daysno, cast(dv.value as decimal(26,1)) as value, null as textvalue from datavalue dv left join _dataelementgroupsetstructure degs on dv.dataelementid=degs.dataelementid left join _organisationunitgroupsetstructure ougs on dv.sourceid=ougs.organisationunitid left join _categoryoptiongroupsetstructure cogs on dv.attributeoptioncomboid=cogs.categoryoptioncomboid left join _categorystructure dcs on dv.categoryoptioncomboid=dcs.categoryoptioncomboid left join _categorystructure acs on dv.attributeoptioncomboid=acs.categoryoptioncomboid left join _orgunitstructure ous on dv.sourceid=ous.organisationunitid left join _dataelementstructure des on dv.dataelementid = des.dataelementid inner join dataelement de on dv.dataelementid=de.dataelementid inner join categoryoptioncombo co on dv.categoryoptioncomboid=co.categoryoptioncomboid inner join _categoryoptioncomboname aon on dv.attributeoptioncomboid=aon.categoryoptioncomboid inner join period pe on dv.periodid=pe.periodid inner join _periodst ructure ps on dv.periodid=ps.periodid inner join organisationunit ou on dv.sourceid=ou.organisationunitid where de.valuetype = 'int' and de.domaintype = 'AGGREGATE' and pe.startdate >= '1991-01-01' and pe.startdate <= '1991-12-31' and dv.value is not null and dv.value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$' and ( dv.value != '0' or de.aggregationtype = 'average' or de.zeroissignificant = true ) ]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'wmrdhis.analytics_temp_1991' doesn't exist > at java.util.concurrent.FutureTask.report(FutureTask.java:122) > at java.util.concurrent.FutureTask.get(FutureTask.java:192) > at > org.hisp.dhis.system.util.ConcurrentUtils.waitForCompletion(ConcurrentUtils.java:51) > ... 12 more > Caused by: org.springframework.jdbc.BadSqlGrammarException: > StatementCallback; bad SQL grammar [insert into analytics_temp_1991 > (`Ryvpin5RJZM`,`uM9aEW3ptDy`,`OJ8CtfEKUO7`,`MaShSyRIODt`,`DRilySX62w8`,`Jf8GswsWlGW`,`Kt01M6IvAjA`,`Ly8b2oSN196`,`uidlevel1`,`uidlevel2`,`uidlevel3`,`daily`,`weekly`,`monthly`,`bimonthly`,`quarterly`,`sixmonthly`,`sixmonthlyapril`,`yearly`,`financialapril`,`financialjuly`,`financialoct`,`de`,`co`,`ou`,`level`,daysxvalue, > daysno, value, textvalue) select > ougs.`Ryvpin5RJZM`,ougs.`uM9aEW3ptDy`,ougs.`OJ8CtfEKUO7`,dcs.`MaShSyRIODt`,dcs.`DRilySX62w8`,dcs.`Jf8GswsWlGW`,dcs.`Kt01M6IvAjA`,dcs.`Ly8b2oSN196`,ous.`uidlevel1`,ous.`uidlevel2`,ous.`uidlevel3`,ps.`daily`,ps.`weekly`,ps.`monthly`,ps.`bimonthly`,ps.`quarterly`,ps.`sixmonthly`,ps.`sixmonthlyapril`,ps.`yearly`,ps.`financialapril`,ps.`financialjuly`,ps.`financialoct`,de.uid,co.uid,ou.uid,ous.level,cast(dv.value > as decimal(26,1)) * ps.daysno as daysxvalue, ps.daysno as daysno, > cast(dv.value as decimal(26,1)) a s value, null as textvalue from datavalue dv left join _dataelementgroupsetstructure degs on dv.dataelementid=degs.dataelementid left join _organisationunitgroupsetstructure ougs on dv.sourceid=ougs.organisationunitid left join _categoryoptiongroupsetstructure cogs on dv.attributeoptioncomboid=cogs.categoryoptioncomboid left join _categorystructure dcs on dv.categoryoptioncomboid=dcs.categoryoptioncomboid left join _categorystructure acs on dv.attributeoptioncomboid=acs.categoryoptioncomboid left join _orgunitstructure ous on dv.sourceid=ous.organisationunitid left join _dataelementstructure des on dv.dataelementid = des.dataelementid inner join dataelement de on dv.dataelementid=de.dataelementid inner join categoryoptioncombo co on dv.categoryoptioncomboid=co.categoryoptioncomboid inner join _categoryoptioncomboname aon on dv.attributeoptioncomboid=aon.categoryoptioncomboid inner join period pe on dv.periodid=pe.periodid inner join _periodstructure ps on dv.periodid=ps.periodid inn er join organisationunit ou on dv.sourceid=ou.organisationunitid where de.valuetype = 'int' and de.domaintype = 'AGGREGATE' and pe.startdate >= '1991-01-01' and pe.startdate <= '1991-12-31' and dv.value is not null and dv.value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$' and ( dv.value != '0' or de.aggregationtype = 'average' or de.zeroissignificant = true ) ]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'wmrdhis.analytics_temp_1991' doesn't exist > at > org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231) > at > org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73) > at > org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416) > at > org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:440) > at > org.hisp.dhis.analytics.table.AbstractJdbcTableManager.populateAndLog(AbstractJdbcTableManager.java:330) > at > org.hisp.dhis.analytics.table.JdbcAnalyticsTableManager.populateTable(JdbcAnalyticsTableManager.java:253) > at > org.hisp.dhis.analytics.table.JdbcAnalyticsTableManager.populateTableAsync(JdbcAnalyticsTableManager.java:173) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:483) > 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.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:110) > at java.util.concurrent.FutureTask.run(FutureTask.java:266) > ... 1 more > Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table > 'wmrdhis.analytics_temp_1991' doesn't exist > at sun.reflect.GeneratedConstructorAccessor71.newInstance(Unknown > Source) > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.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:405) > ... 14 more > > To manage notifications about this bug go to: > https://bugs.launchpad.net/dhis2/+bug/1457198/+subscriptions _______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
