[ADMAX-3039] sepull - error in sql syntax - Admax Local

Details

Type: Bug
Status: Closed
Priority: Minor
Resolution: Fixed
Affects Version/s: None
Fix Version/s: unspecified
Component/s: Data Summarization
Labels:
None
Environment:

xml-06: tsa-build-bidmgr-2012-03-12-p23-r31783

Description

From: Rijesh Aliyattil

Sent: Tuesday, March 13, 2012 12:51 AM

To: data-monitoring

Cc: Jeff Shih; Jeff Theroux; Jeffrey Collemer; Sanjay.Kumar@itcinfotech.com

Subject: RE: #s 03/12

Found Exceptions in sepull3.sh_d_3_T_2012_03_12__timezoneid_32,34_12:03:07.log

2012-03-12 12:03:29.598 (1) [main]: Exception [Could not create tsacommon database instance]:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL s

yntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) and (`vActiveSearchEngineAccounts`.`distributionID`=3))' 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:1169)

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:155)

at com.thesearchagency.searchengines.common.SearchEngineDataStager.getActiveAccountSearchEngineUsers(SearchEngineDataStager.java:209)

at com.thesearchagency.searchengines.common.SearchEngineDataStager.init(SearchEngineDataStager.java:106)

at com.thesearchagency.searchengines.google.GoogleMCCReport.init(GoogleMCCReport.java:157)

at com.thesearchagency.searchengines.google.GoogleMCCReport.main(GoogleMCCReport.java:141)

2012-03-12 12:03:30.170 (3) [main]: =============== Starting Google MCC Report ================

2012-03-12 12:03:30.175 (3) [main]: ----------------Google MCC Report starting

2012-03-12 12:03:30.725 (3) [main]: Instantiating a DateUtil object for time zone America/New_York

2012-03-12 12:03:30.768 (3) [P1T1]: DatabasePool with a limit of 6 created

2012-03-12 12:03:30.966 (3) [main]: Instantiating a DateUtil object for time zone America/Los_Angeles

2012-03-12 12:03:31.239 (3) [main]: Instantiating a DateUtil object for time zone Europe/London

2012-03-12 12:03:34.457 (1) [P1T2]: Exception Could not retrieve TSA accounts/search engine accounts for search engine user #2088:com.mysql.jdbc.exceptions.MySQLSyntaxErrorExc

eption: 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 ')) and (`vActiveSearchEngineAccoun

ts`.`seUserID`=2088) and (`vActiveSearchEngine' 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:1169)

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.JoinTable.select(JoinTable.java:180)

at com.carldunham.jst.db.JoinTable.select(JoinTable.java:169)

at com.carldunham.jst.db.JoinTable.select(JoinTable.java:144)

at com.thesearchagency.searchengines.common.SearchEngineDataStager$SearchEngineUserWorker.initSearchEngineUserAccountMap(SearchEngineDataStager.java:433)

at com.thesearchagency.searchengines.common.SearchEngineDataStager$SearchEngineUserWorker.run(SearchEngineDataStager.java:342)

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

at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)

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

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

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

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

2012-03-12 12:03:34.551 (1) [P1T2]: Exception Could not retrieve TSA accounts/search engine accounts for search engine user #2025:com.mysql.jdbc.exceptions.MySQLSyntaxErrorExc

eption: 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 ')) and (`vActiveSearchEngineAccoun

ts`.`seUserID`=2025) and (`vActiveSearchEngine' at line 1