Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: Giraffe
    • Fix Version/s: Giraffe
    • Labels:
      None
    • Environment:

      QA 4

      Bidmgr : bidmgr-distribution-2.9.6-BETA2-dev-t20160920-1059

    • Sprint:
      Sprint 2

      Description

      seupdater is failing

      Steps:

      1.Run [TSAApp@aml-qa4-core1 bidmgr]$ ./seupdate.sh -d3 -a 1858 --inactive --listings -S 3

      2. Check the debug log

      Actual Result:

      As seupdater is failing there is no entry to TSA DB - searchEngineListings

      Snippet of Listener Log:

      016-09-21 12:54:10.505 (3) [P3T7]: Sync Flag: true - syncing groups and listings for (6776) "035336cf-ed03-46de-9de2-50e1fee651da_11086_6_11835_GM" for user (2493) "035336cf-ed03-46de-9de2-50e1fee651da_2_q
      a4amltest_PerformanceAccountGiraffe"
      2016-09-21 12:54:10.530 (3) [P3T6]: Groups: 91 added, 0 modified, 0 disabled.
      2016-09-21 12:54:10.543 (3) [P3T7]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
      2016-09-21 12:54:10,546 [P3T7] INFO c.t.s.c.b.i.s.AdGroupServiceClient - Getting Bing adGroups(s) for campaign 269054222
      2016-09-21 12:54:10,552 [P3T7] INFO o.a.c.w.s.f.ReflectionServiceFactoryBean - Creating Service

      {https://bingads.microsoft.com/CampaignManagement/v10}

      CampaignManagementService from class com.microsoft.bing
      ads.v10.campaignmanagement.ICampaignManagementService
      2016-09-21 12:54:10.591 (1) [P3T1]: Exception [Error saving record]:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'title' in 'NEW'
      at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
      at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
      at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
      at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
      at com.mysql.jdbc.Util.getInstance(Util.java:386)
      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664)
      at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2809)
      at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1811)
      at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1899)
      at com.carldunham.jst.db.Database.executeUpdate(Database.java:412)
      at com.carldunham.jst.db.BaseDatabaseTable.insert(BaseDatabaseTable.java:345)
      at com.carldunham.jst.db.BaseDatabaseTableRow.save(BaseDatabaseTableRow.java:484)
      at com.carldunham.jst.db.BaseDatabaseTableRow.save(BaseDatabaseTableRow.java:418)
      at com.thesearchagency.searchengines.SearchEngineUpdater$SearchEngineAccountWorker.syncListings(SearchEngineUpdater.java:1837)
      at com.thesearchagency.searchengines.SearchEngineUpdater$SearchEngineAccountWorker.call(SearchEngineUpdater.java:1578)
      at com.thesearchagency.searchengines.SearchEngineUpdater$SearchEngineAccountWorker.call(SearchEngineUpdater.java:1539)
      at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
      at java.util.concurrent.FutureTask.run(FutureTask.java:138)
      at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
      at java.lang.Thread.run(Thread.java:662)

      2016-09-21 12:54:10.634 (1) [P3T1]: Exception [Error saving record]:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'title' in 'NEW'
      at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
      at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
      at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
      at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
      at com.mysql.jdbc.Util.getInstance(Util.java:386)
      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)

        Attachments

          Activity

            People

            • Assignee:
              Madhan Madhan Pulipati [X] (Inactive)
              Reporter:
              atul.sanagar Atul Sanagar (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: