Uploaded image for project: 'AdMaxLocal'
  1. AdMaxLocal
  2. AML-106

Brand Campaign deployment - one of the calls to seupdate doesn't pass in correct parameters

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.3.0
    • Fix Version/s: 1.3.0
    • 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

        Attachments

          Activity

            People

            • Assignee:
              caitlyn Caitlyn Duggan (Inactive)
              Reporter:
              caitlyn Caitlyn Duggan (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: