Details
-
Type: Bug
-
Status: Closed
-
Priority: Major
-
Resolution: Fixed
-
Affects Version/s: 1.3.0
-
Fix Version/s: 1.3.0
-
Component/s: Admax Deployment Service
-
Labels:None
-
Environment:
SMB Core – SaaS – Trunk Pulse build 551
SMB – Optus – Trunk Pulse build 725
SMB Core – Bid Manager – Trunk Pulse build 582
Description
On Core ADS deployCustomerCampaign call, seupdate is run for the existing Optus campaigns as such:
2012-07-10 12:24:00.341 (3) [pool-3-thread-7]: JobExecutor running job [2012-07-10_122355_a6958_campaignUpdateWorkerCampaignSync_i1V11zhgOz]: /usr/bin/java -Xms256m -Xmx1536m -Xincgc -cp /usr/local/tsa/bidmgr/libs/jst.jar:/usr/local/tsa/bidmgr/libs/tsa.jar:/usr/local/tsa/bidmgr/libs/bidmgrtsa.jar:/usr/local/tsa/bidmgr/libs/jdb.jar:/usr/local/tsa/bidmgr/libs/bidmgrse.jar:/usr/local/tsa/bidmgr/libs/bidmgrclients.jar:/usr/local/tsa/bidmgr/libs/bidmgrseov.jar:/usr/local/tsa/bidmgr/libs/bidmgrsefwht.jar:/usr/local/tsa/bidmgr/libs/bidmgrsegoogle.jar:/usr/local/tsa/bidmgr/libs/adwords-api-reseller-8.4.2R1.jar:/usr/local/tsa/bidmgr/libs/bidmgrsemsn.jar:/usr/local/tsa/bidmgr/libs/bidmgrsemsnwsdl.jar:/usr/local/tsa/bidmgr/libs/bidmgrseyahoo.jar:/usr/local/tsa/bidmgr/libs/bidmgrseyahoowsdl.jar:/usr/local/tsa/bidmgr/libs/bidmgrsessp.jar:/usr/local/tsa/bidmgr/libs/bidmgrsesspwsdl.jar:/usr/local/tsa/bidmgr/libs/bidmgrseask.jar:/usr/local/tsa/bidmgr/libs/bidmgrseaskwsdl.jar:/usr/local/tsa/bidmgr/libs/model.jar:/usr/local/tsa/bidmgr/libs/log4j.jar:/usr/local/tsa/bidmgr/libs/axis14/axis.jar:/usr/local/tsa/bidmgr/libs/thirdparty/xercesImpl.jar:/usr/local/tsa/bidmgr/libs/thirdparty/jaxp-1.2.jar:/usr/local/tsa/bidmgr/libs/thirdparty/commons-httpclient.jar:/usr/local/tsa/bidmgr/libs/thirdparty/commons-codec.jar:/usr/local/tsa/bidmgr/libs/thirdparty/commons-logging.jar:/usr/local/tsa/bidmgr/libs/thirdparty/commons-collections-3.2.1.jar:/usr/local/tsa/bidmgr/libs/thirdparty/commons-discovery.jar:/usr/local/tsa/bidmgr/libs/thirdparty/wsdl4j.jar:/usr/local/tsa/bidmgr/libs/thirdparty/jaxrpc.jar:/usr/local/tsa/bidmgr/libs/thirdparty/saaj.jar:/usr/local/tsa/bidmgr/libs/thirdparty/mysql.jar:/usr/local/tsa/bidmgr/libs/thirdparty/commons-cli.jar:/usr/local/tsa/bidmgr/libs/thirdparty/activation.jar:/usr/local/tsa/bidmgr/libs/thirdparty/mail.jar com.thesearchagency.searchengines.SearchEngineUpdater -d 3 --inactive --seaccount --groups --listings
Notice that there is nothing passed into --seaccount
That is part 1 of the bug
Part 2 is that seupdate fails, but shows success in admax listener log:
// seupdate log: /var/local/tsa/admaxlistener/job_logs/2012-07-10_122355_a6958_campaignUpdateWorkerCampaignSync_i1V11zhgOz
2012-07-10 12:24:00.997 (3) [main]: Debug Level set to 3
2012-07-10 12:24:00.998 (3) [main]: =============== Starting Search Engine Updater ================
2012-07-10 12:24:01.051 (2) [main]: Exception [handling search engine user]: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 ')))) and (((`tsacommon`.`searchEngineUsers`.`enabled`="true"))))) order by rand(' 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:364)
at com.carldunham.jst.db.Database.executeQuery(Database.java:316)
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:163)
at com.thesearchagency.searchengines.SearchEngineAccountDispatcher.run(SearchEngineAccountDispatcher.java:367)
at com.thesearchagency.searchengines.SearchEngineUpdater.run(SearchEngineUpdater.java:336)
at com.thesearchagency.searchengines.SearchEngineUpdater.main(SearchEngineUpdater.java:389)
2012-07-10 12:24:01.051 (3) [main]: After joining threads, calling doPostJoinActions
2012-07-10 12:24:01.052 (3) [main]: =============== Completed Search Engine Updater ================
2012-07-10 12:24:01.054 (3) [main]: Search Engine Updater: 0.056s
// admax listener log:
2012-07-10 12:24:01.080 (3) [pool-3-thread-7]: JobExecutor finished running job [2012-07-10_122355_a6958_campaignUpdateWorkerCampaignSync_i1V11zhgOz], exit code=0 in 0.737s
2012-07-10 12:24:01.080 (3) [pool-3-thread-7]: JobExecutor finished 2012-07-10_122355_a6958_campaignUpdateWorkerCampaignSync_i1V11zhgOz. hasError=false, numTries=1