Details
-
Type: Bug
-
Status: Closed
-
Priority: Major
-
Resolution: Fixed
-
Affects Version/s: Giraffe
-
Fix Version/s: Giraffe
-
Component/s: Admax (bidding/budgeting)
-
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
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)