TimeZone: Getting mysqlSyntax Exception while running "runAdmaxSummarizer" script...

Getting mysqlSyntax Exception while running "runAdmaxSummarizer" script...

Steps to reproduce:-

1)Event-Listener is started

2011-07-29 12:14:25.824 (3) [main]: Debug Level set to 3

2011-07-29 12:14:26.149 INFO [FailoverTransport]: Successfully connected to tcp://event-msg-broker-01:61616

2011-07-29 12:14:26.331 (3) [main]: Waiting for messages...

2)tsaapp@tvvm-staging-xml1:/usr/local/tsa/bidmgr$ ./event-send.sh -d3 -m runAdmaxSummarizer -T 2011-07-29 -t 6

Executing sepull147.sh -d 3 --timezoneid 6: writing to /tmp/2011-09-15/sepull147.sh_d_3__timezoneid_6_09:41:53.log

3)gsingh@tvvm-staging-xml1:~$ cd /var/local/tsa/log

gsingh@tvvm-staging-xml1:/var/local/tsa/log$ tail -f event-listener.log

Executing sepull147.sh -d 3 --timezoneid 6: writing to /var/local/tsa/log/2011-09-15/sepull147.sh_d_3__timezoneid_6_06:28:00.log

2011-09-15 06:28:01.990 (3) [pool-1-thread-2]: Completed with return code 0

2011-09-15 06:34:47.488 (3) [main]: Processing Event: SetDataAvailability:[ Data: 2011-07-29 TimeZoneIDs: 4 ]

2011-09-15 06:34:47.489 (3) [pool-1-thread-3]: Running command: /usr/local/tsa/bidmgr/event-wrapper.sh setdatanotstarted.sh -d 3 -T 2011-07-29 --timezoneid 4

Executing setdatanotstarted.sh -d 3 -T 2011-07-29 --timezoneid 4: writing to /var/local/tsa/log/2011-09-15/setdatanotstarted.sh_d_3_T_2011_07_29__timezoneid_4_06:34:47.log

2011-09-15 06:34:55.967 (3) [pool-1-thread-3]: Completed with return code 0

2011-09-15 06:44:12.719 (3) [main]: Processing Event: RunAdmaxSummarizer:[ Date: 2011-07-29 TimeZoneIDs: 6 ]

2011-09-15 06:44:12.720 (3) [pool-1-thread-4]: Running command: /usr/local/tsa/bidmgr/event-wrapper.sh admax.sh -d 3 --timezoneid 6

Executing admax.sh -d 3 --timezoneid 6: writing to /var/local/tsa/log/2011-09-15/admax.sh_d_3__timezoneid_6_06:44:12.log

2011-09-15 06:44:21.273 (3) [pool-1-thread-4]: Completed with return code 0

4)gsingh@tvvm-staging-xml1:/var/local/tsa/log$ tail -100f /var/local/tsa/log/2011-09-15/admax.sh_d_3__timezoneid_6_06:44:12.log

Sep 15, 2011 6:44:17 AM org.apache.cxf.service.factory.ReflectionServiceFactoryBean buildServiceFromWSDL

INFO: Creating Service

UserAccountService2.0 from WSDL: http://svc-useracctv2.svc.thesearchagency.com:8080/svc-useracctv2.0/UserAccountService2.0?wsdl

2011-09-15 06:44:20.790 (3) [main]: Debug Level set to 3

2011-09-15 06:44:20.902 (3) [main]: =============== Starting AdMax Summarizer ================

2011-09-15 06:44:20.903 (3) [main]: ----------------AdMax Summarizer starting

2011-09-15 06:44:21.194 (2) [main]: Exception [getting accounts]:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))) order by `tsacommon`.`accounts`.`tier` asc,`tsacommon`.`accounts`.`priority`' at line 1

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

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

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

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

at com.mysql.jdbc.Connection.execSQL(Connection.java:3170)

at com.mysql.jdbc.Connection.execSQL(Connection.java:3099)

at com.mysql.jdbc.Statement.executeQuery(Statement.java:1172)

at com.carldunham.jst.db.Database.executeQuery(Database.java:356)

at com.carldunham.jst.db.Database.executeQuery(Database.java:308)

at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:184)

at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:167)

at com.thesearchagency.AccountDispatcher.selectAccounts(AccountDispatcher.java:389)

at com.thesearchagency.AccountDispatcher.run(AccountDispatcher.java:154)

at com.thesearchagency.admax.AdMaxSummarizer.run(AdMaxSummarizer.java:273)

at com.thesearchagency.admax.AdMaxSummarizer.main(AdMaxSummarizer.java:308)

2011-09-15 06:44:21.198 (3) [main]: ------------AdMax Summarizer done

2011-09-15 06:44:21.198 (3) [main]: =============== Completed AdMax Summarizer ================

2011-09-15 06:44:21.202 (3) [main]: AdMax Summarizer: 0.297s