2013-12-11 10:11:52.989 (3) [Thread-6]: ST2_JBOSS1--/queue/AdMaxDeployRequestQueue-Receptor queued BPID - PNTRAD16 for processing 2013-12-11 10:11:53.010 (3) [pool-5-thread-1]: DatabasePool with a limit of 50 created 2013-12-11 10:11:53.232 (3) [pool-5-thread-1]: DatabasePool with a limit of 50 created 2013-12-11 10:11:53.345 (3) [pool-5-thread-1]: DatabasePool with a limit of 50 created 2013-12-11 10:11:53.389 (3) [pool-5-thread-1]: Updating account tables for PNTRAD16 2013-12-11 10:11:53.476 (3) [pool-5-thread-1]: Committing Account settings for 24479 2013-12-11 10:11:53.564 (3) [pool-5-thread-1]: Using enhanced campaigns for account PNTRAD16 2013-12-11 10:11:53.605 (3) [pool-5-thread-1]: Updating advert budget for PNTRAD16_1000000024_1603_PNTRAD16-1 2013-12-11 10:11:53.622 (3) [pool-5-thread-1]: Nominal monthly budget was unchanged for AdMax campaign ID: 40030619 2013-12-11 10:11:53.642 (3) [pool-5-thread-1]: Updating advert budget for PNTRAD16_1000000024_1603_PNTRAD16-2 2013-12-11 10:11:53.677 (3) [pool-5-thread-1]: Nominal monthly budget was unchanged for AdMax campaign ID: 40030621 2013-12-11 10:11:53.706 (3) [pool-5-thread-1]: ContentEditorPropertiesRefresher: modification detected on 1382955632000 for contenteditor.properties 2013-12-11 10:11:53.707 (3) [pool-5-thread-1]: Loading content editor configuration. 2013-12-11 10:11:53.708 (3) [pool-5-thread-1]: Loaded property: ce.parentClientCustomerID=9746920925 2013-12-11 10:11:53.708 (3) [pool-5-thread-1]: Loaded property: ce.orderID=6313227170 2013-12-11 10:11:53.708 (3) [pool-5-thread-1]: Loaded property: ce.defaultBudget=9000000 2013-12-11 10:11:53.708 (3) [pool-5-thread-1]: Loaded property: ce.acct.currencycode=GBP 2013-12-11 10:11:53.708 (3) [pool-5-thread-1]: Loaded property: ce.acct.language=en_GB 2013-12-11 10:11:53.709 (3) [pool-5-thread-1]: Loaded property: ce.acct.loginemail=mmstestclientaccount{id}@gmail.com 2013-12-11 10:11:53.709 (3) [pool-5-thread-1]: Loaded property: ce.acct.timezoneid=Etc/GMT 2013-12-11 10:11:53.709 (3) [pool-5-thread-1]: Loaded property: ce.address.name=Andrew Kemp 2013-12-11 10:11:53.709 (3) [pool-5-thread-1]: Loaded property: ce.address.companyname=Yell Limited 2013-12-11 10:11:53.709 (3) [pool-5-thread-1]: Loaded property: ce.address.address1=Queens Walk 2013-12-11 10:11:53.709 (3) [pool-5-thread-1]: Loaded property: ce.address.address2=Oxford Road 2013-12-11 10:11:53.709 (3) [pool-5-thread-1]: Loaded property: ce.address.city=Reading 2013-12-11 10:11:53.709 (3) [pool-5-thread-1]: Loaded property: ce.address.countrycode=GB 2013-12-11 10:11:53.709 (3) [pool-5-thread-1]: Loaded property: ce.address.postalcode=RG1 7PT 2013-12-11 10:11:53.710 (3) [pool-5-thread-1]: Loaded property: ce.address.email=yellsmsdomain@yellgroup.com 2013-12-11 10:11:53.710 (3) [pool-5-thread-1]: Loaded property: ce.address.fax=0118 950 2111 2013-12-11 10:11:53.710 (3) [pool-5-thread-1]: Loaded property: ce.address.phone=0792-149-9166 2013-12-11 10:11:53.710 (3) [pool-5-thread-1]: Loaded property: ce.address.state=RDG 2013-12-11 10:11:53.710 (3) [pool-5-thread-1]: Loaded property: ce.email.performanceenabled=false 2013-12-11 10:11:53.710 (3) [pool-5-thread-1]: Loaded property: ce.email.disapprovedadsenabled=true 2013-12-11 10:11:53.710 (3) [pool-5-thread-1]: Loaded property: ce.email.marketresearchenabled=false 2013-12-11 10:11:53.710 (3) [pool-5-thread-1]: Loaded property: ce.email.newsletterenabled=false 2013-12-11 10:11:53.710 (3) [pool-5-thread-1]: Loaded property: ce.email.promotionsenabled=false 2013-12-11 10:11:53.711 (3) [pool-5-thread-1]: Loaded property: ce.bingParentCustomerID=9024639 2013-12-11 10:11:53.711 (3) [pool-5-thread-1]: Loaded property: ce.bingAcct.loginemail=yellsmsdomain@yellgroup.com 2013-12-11 10:11:53.711 (3) [pool-5-thread-1]: Loaded property: ce.bingKeywordContentType=false 2013-12-11 10:11:53.711 (3) [pool-5-thread-1]: Loaded property: ce.debug.level=3 2013-12-11 10:11:53.711 (3) [pool-5-thread-1]: Loaded property: ce.mobileBidModifier=1.2 2013-12-11 10:11:53.711 (3) [pool-5-thread-1]: Loaded property: ce.migrateGoogleCampaignsToEnhanced=false 2013-12-11 10:11:53.716 (3) [pool-5-thread-1]: Debug Level set to 3 2013-12-11 10:11:53.719 (3) [pool-5-thread-1]: LicensingFileRefresher: modification detected on 1370620065000 for licensing.properties 2013-12-11 10:11:53.720 (3) [pool-5-thread-1]: Licensing environment detected, loading configuration. 2013-12-11 10:11:53.721 (3) [pool-5-thread-1]: Loaded property: tsa.google.mcc.email=gurpreet.singh.hibu@gmail.com 2013-12-11 10:11:53.721 (3) [pool-5-thread-1]: Loaded property: tsa.google.mcc.password=y3llc0m_123 2013-12-11 10:11:53.721 (3) [pool-5-thread-1]: Loaded property: tsa.google.mcc.developerToken=ojCnjZaM6RD1h0yt_DOJZg 2013-12-11 10:11:53.722 (3) [pool-5-thread-1]: Loaded property: tsa.google.mcc.applicationToken=uoIAD-arHiCXJKtlGSg5qw 2013-12-11 10:11:53.729 (3) [pool-5-thread-1]: Loaded property: tsa.google.mcc.isReseller=true 2013-12-11 10:11:53.729 (3) [pool-5-thread-1]: Loaded property: tsa.google.mcc.userAgent=MMS AdWords Software 2013-12-11 10:11:53.729 (3) [pool-5-thread-1]: Loaded property: tsa.google.isSandbox=false 2013-12-11 10:11:53.730 (3) [pool-5-thread-1]: Loaded property: tsa.bing.mcc.username=YellSandboxAPI 2013-12-11 10:11:53.730 (3) [pool-5-thread-1]: Loaded property: tsa.bing.mcc.password=api123 2013-12-11 10:11:53.730 (3) [pool-5-thread-1]: Loaded property: tsa.bing.mcc.developerToken=D9OP84AM 2013-12-11 10:11:53.730 (3) [pool-5-thread-1]: Loaded property: tsa.bing.mcc.isReseller=true 2013-12-11 10:11:53.730 (3) [pool-5-thread-1]: Loaded property: tsa.bing.mcc.userAgent=MMS AdCenter Software 2013-12-11 10:11:53.730 (3) [pool-5-thread-1]: Loaded property: tsa.bing.isSandbox=false 2013-12-11 10:11:53.746 (3) [pool-5-thread-1]: Debug Level set to 3 2013-12-11 10:11:53.809 (3) [pool-5-thread-1]: Start processing DEPLOY request (PNTRAD16) for account PNTRAD16. 4 campaign(s). 2013-12-11 10:11:53.809 (3) [pool-5-thread-1]: Performing sync for account: PNTRAD16 ID#24479 2013-12-11 10:11:54.015 (3) [pool-5-thread-1]: BING Account Worker has 2 campaign(s) to update. 2013-12-11 10:11:54.015 (3) [pool-5-thread-1]: BING Account Worker has 0 campaign(s) to create. 2013-12-11 10:11:54.015 (3) [pool-5-thread-1]: BING Account Worker has 0 campaign(s) to retry and update. 2013-12-11 10:11:54.035 (3) [pool-5-thread-1]: CampaignWorker initialized for account: 24479 2013-12-11 10:11:54.035 (3) [pool-5-thread-1]: Updating PNTRAD16_1000000024_1603_PNTRAD16-1_GT Status: Paused 2013-12-11 10:11:54.035 (3) [pool-5-thread-1]: Updating PNTRAD16_1000000024_1603_PNTRAD16-1_GM Status: Paused 2013-12-11 10:11:54.036 (3) [pool-5-thread-1]: BingCampaignUpdateWorker started... 2013-12-11 10:11:54.205 (3) [pool-5-thread-1]: DatabasePool with a limit of 50 created 2013-12-11 10:11:54.278 (3) [pool-5-thread-1]: PNTRAD16_1000000024_1603_PNTRAD16-1_GT is already set to Paused in the database. 2013-12-11 10:11:54.278 (3) [pool-5-thread-1]: PNTRAD16_1000000024_1603_PNTRAD16-1_GT target sync: 2013-12-11 10:11:54.278 (3) [pool-5-thread-1]: Adding new target proximity_55.935699462890625,4.154699802398682 2013-12-11 10:11:54.279 (3) [pool-5-thread-1]: Deleting old target city_Kirkintillock, SCT GB 2013-12-11 10:11:54.279 (3) [pool-5-thread-1]: PNTRAD16_1000000024_1603_PNTRAD16-1_GM is already set to Paused in the database. 2013-12-11 10:11:54.279 (3) [pool-5-thread-1]: PNTRAD16_1000000024_1603_PNTRAD16-1_GM target sync: 2013-12-11 10:11:54.280 (3) [pool-5-thread-1]: PNTRAD16_1000000024_1603_PNTRAD16-1_GM has no updated targets. 2013-12-11 10:11:54.440 (2) [pool-5-thread-1]: Error: CampID: PNTRAD16-1_GT Info: Error during update request. 2013-12-11 10:11:54.441 (2) [pool-5-thread-1]: Error: CampID: PNTRAD16-1_GM Info: Error during update request. 2013-12-11 10:11:54.442 (1) [pool-5-thread-1]: Exception [BING Account Worker - Error during update request.]:java.sql.SQLException: Column count doesn't match value count at row 1 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946) 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.Statement.executeUpdate(Statement.java:1316) at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1235) at com.carldunham.jst.db.Database.executeUpdate(Database.java:409) at com.carldunham.jst.db.BaseDatabaseTable.multiReplace(BaseDatabaseTable.java:570) at com.thesearchagency.searchengines.bing.contenteditor.dao.campaign.target.CampaignTargetDAO.dbModifyTargetsForNewCampaigns(CampaignTargetDAO.java:948) at com.thesearchagency.searchengines.bing.contenteditor.dao.campaign.target.CampaignTargetDAO.updatePendingAddTargets(CampaignTargetDAO.java:881) at com.thesearchagency.searchengines.bing.contenteditor.dao.campaign.target.CampaignTargetDAO.updatePendingTargets(CampaignTargetDAO.java:401) at com.thesearchagency.searchengines.bing.contenteditor.dao.campaign.CampaignDAO.updateCampaigns(CampaignDAO.java:303) at com.thesearchagency.searchengines.bing.contenteditor.RequestCreator.updateCampaigns(RequestCreator.java:89) at com.thesearchagency.searchengines.bing.contenteditor.BingContentEditor.updateCampaigns(BingContentEditor.java:347) at com.thesearchagency.admaxlistener.worker.BingCampaignUpdateWorker.call(BingCampaignUpdateWorker.java:75) at com.thesearchagency.admaxlistener.worker.BingAccountWorker.updateCampaigns(BingAccountWorker.java:230) at com.thesearchagency.admaxlistener.worker.BingAccountWorker.deploySync(BingAccountWorker.java:131) at com.thesearchagency.admaxlistener.worker.AccountWorker.deploySync(AccountWorker.java:153) at com.thesearchagency.admaxlistener.worker.AccountWorker.call(AccountWorker.java:128) at com.thesearchagency.admaxlistener.worker.RequestWorker.call(RequestWorker.java:167) at com.thesearchagency.admaxlistener.worker.RequestWorker.call(RequestWorker.java:40) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2013-12-11 10:11:54.442 (3) [pool-5-thread-1]: Migrate Google campaigns to Enhanced is:false 2013-12-11 10:11:54.442 (3) [pool-5-thread-1]: GOOGLE Account Worker has 2 campaign(s) to update. 2013-12-11 10:11:54.443 (3) [pool-5-thread-1]: GOOGLE Account Worker has 0 campaign(s) to create. 2013-12-11 10:11:54.443 (3) [pool-5-thread-1]: GOOGLE Account Worker has 0 campaign(s) to retry and update. 2013-12-11 10:11:54.445 (3) [pool-5-thread-1]: CampaignWorker initialized for account: 24479 2013-12-11 10:11:54.445 (3) [pool-5-thread-1]: Updating PNTRAD16_1000000024_1603_PNTRAD16-2_GT Status: Paused 2013-12-11 10:11:54.446 (3) [pool-5-thread-1]: Updating PNTRAD16_1000000024_1603_PNTRAD16-2_GM Status: Paused 2013-12-11 10:11:54.446 (3) [pool-5-thread-1]: CampaignUpdateWorker started... 2013-12-11 10:11:54.513 (3) [pool-5-thread-1]: DatabasePool with a limit of 50 created 2013-12-11 10:11:54.600 (3) [pool-5-thread-1]: PNTRAD16_1000000024_1603_PNTRAD16-2_GT is already set to Paused in the database. 2013-12-11 10:11:54.601 (3) [pool-5-thread-1]: No update necessary: optimizer settings are the same. 2013-12-11 10:11:54.601 (3) [pool-5-thread-1]: No budget optimizer update required. 2013-12-11 10:11:54.601 (3) [pool-5-thread-1]: PNTRAD16_1000000024_1603_PNTRAD16-2_GT target sync: 2013-12-11 10:11:54.601 (3) [pool-5-thread-1]: Adding new target proximity_55935700,4154699 2013-12-11 10:11:54.602 (3) [pool-5-thread-1]: Deleting old target city_Kirkintillock, SCT GB 2013-12-11 10:11:54.602 (3) [pool-5-thread-1]: PNTRAD16_1000000024_1603_PNTRAD16-2_GM is already set to Paused in the database. 2013-12-11 10:11:54.602 (3) [pool-5-thread-1]: No update necessary: optimizer settings are the same. 2013-12-11 10:11:54.602 (3) [pool-5-thread-1]: No budget optimizer update required. 2013-12-11 10:11:54.603 (3) [pool-5-thread-1]: PNTRAD16_1000000024_1603_PNTRAD16-2_GM target sync: 2013-12-11 10:11:54.603 (3) [pool-5-thread-1]: PNTRAD16_1000000024_1603_PNTRAD16-2_GM has no updated targets. 2013-12-11 10:11:54.840 (3) [pool-5-thread-1]: ----------------Google Content Editor starting 2013-12-11 10:11:55.386 (3) [P1T1]: Created shared sesystem connection rw 2013-12-11 10:11:56.655 (3) [P1T1]: CampaignTargetChangeRequest (accountID 24479): Sending 1 update requests 2013-12-11 10:11:56.655 (3) [P1T1]: Removing targets from Google :1 values: [type=city, code=Kirkintillock, SCT GB, exclude=false, id=783, criterionId=1007360] 2013-12-11 10:11:56.660 (2) [P1T1]: Network target found: GoogleSearch with ID 1 2013-12-11 10:11:56.661 (2) [P1T1]: Network target found: SearchNetwork with ID 2 2013-12-11 10:11:56.661 (2) [P1T1]: Network target found: ContentNetwork with ID 3 2013-12-11 10:12:00.019 (3) [P1T1]: CampaignTargetDAO(accountID 24479) Request contained 0 adds, 1 updates, 0 deletes. 2013-12-11 10:12:00.020 (3) [P1T1]: CampaignTargetDAO(accountID 24479) DB updates: 1 items updated, 1 pending changes deleted, 1 pending updates deleted, 0 errors cleared 2013-12-11 10:12:00.094 (3) [P1T1]: CampaignTargetDAO Targets: Added 0, deleted 1 2013-12-11 10:12:00.102 (3) [P1T1]: CampaignTargetDAO Proximity Targets: Added 1, updated 0, deleted 0 2013-12-11 10:12:00.184 (3) [P1T1]: Skipping null/empty batch of deletes 2013-12-11 10:12:00.187 (3) [P1T1]: Skipping null/empty batch of adds 2013-12-11 10:12:00.190 (3) [P1T1]: Skipping null/empty batch of updates 2013-12-11 10:12:00.191 (3) [P1T1]: ... SEUser 23029 finished 2013-12-11 10:12:00.191 (3) [pool-5-thread-1]: ------------Google Content Editor done 2013-12-11 10:12:00.314 (3) [pool-5-thread-1]: SE Update account will run for PNTRAD16_1000000024_1603_PNTRAD16-2_GT 2013-12-11 10:12:00.328 (3) [pool-5-thread-1]: Running content editor replace... 2013-12-11 10:12:00.331 (3) [pool-5-thread-1]: ----------------Google Content Editor starting 2013-12-11 10:12:00.619 (3) [P2T1]: No deleted adgroups found 2013-12-11 10:12:00.927 (3) [P2T1]: Deletes Pending Change 0 adgroups and adding 0 adgroups. 2013-12-11 10:12:01.669 (3) [P2T1]: No deleted keywords found 2013-12-11 10:12:01.679 (3) [P2T1]: Deleting 0 keywords and adding 0 keywords and Updated 0. 2013-12-11 10:12:01.836 (3) [P2T1]: No deleted text ads found 2013-12-11 10:12:01.840 (3) [P2T1]: Deleting 0 text ads and adding 0 text ads. 2013-12-11 10:12:01.911 (3) [P2T1]: replace 0 changed campaigns 2013-12-11 10:12:02.038 (3) [P2T1]: Skipping null/empty batch of deletes 2013-12-11 10:12:02.040 (3) [P2T1]: Skipping null/empty batch of adds 2013-12-11 10:12:02.042 (3) [P2T1]: Skipping null/empty batch of updates 2013-12-11 10:12:02.042 (3) [P2T1]: ... SEUser 23029 finished 2013-12-11 10:12:02.043 (3) [pool-5-thread-1]: ------------Google Content Editor done 2013-12-11 10:12:02.053 (3) [pool-5-thread-1]: Deleted: 0 unregistered textAds 2013-12-11 10:12:02.059 (3) [pool-5-thread-1]: Deleted: 0 unregistered keywords 2013-12-11 10:12:02.061 (3) [pool-5-thread-1]: Updating 0 TextAd display/destination URLs and 0 keyword destination URLs and 0 placement destination URLs in GCE Campaigns: [95739] 2013-12-11 10:12:02.073 (3) [pool-5-thread-1]: Deleted: 0 unregistered textAds 2013-12-11 10:12:02.079 (3) [pool-5-thread-1]: Deleted: 0 unregistered keywords 2013-12-11 10:12:02.082 (3) [pool-5-thread-1]: Updating 0 TextAd display/destination URLs and 0 keyword destination URLs and 0 placement destination URLs in GCE Campaigns: [95741] 2013-12-11 10:12:02.514 (3) [pool-5-thread-1]: PNTRAD16-1_GT has no applicable BCE errors. 2013-12-11 10:12:02.534 (3) [pool-5-thread-1]: PNTRAD16-1_GM has no applicable BCE errors. 2013-12-11 10:12:05.284 (3) [pool-5-thread-1]: Updated Location Extension for campaign: PNTRAD16_1000000024_1603_PNTRAD16-2_GT 2013-12-11 10:12:07.693 (3) [pool-5-thread-1]: Updated Location Extension for campaign: PNTRAD16_1000000024_1603_PNTRAD16-2_GM 2013-12-11 10:12:07.745 (3) [pool-5-thread-1]: PNTRAD16-2_GT has no applicable GCE errors. 2013-12-11 10:12:07.764 (3) [pool-5-thread-1]: PNTRAD16-2_GM has no applicable GCE errors. 2013-12-11 10:12:07.775 (3) [pool-5-thread-1]: No se budget update needed 2013-12-11 10:12:07.776 (3) [pool-5-thread-1]: Updating Admax bid for PNTRAD16_1000000024_1603_PNTRAD16-2_GT Bid: 0.16129032 2013-12-11 10:12:07.792 (1) [pool-5-thread-1]: Exiting insertOrUpdateBid method with return value: 2 2013-12-11 10:12:07.793 (3) [pool-5-thread-1]: No se budget update needed 2013-12-11 10:12:07.794 (3) [pool-5-thread-1]: Updating Admax bid for PNTRAD16_1000000024_1603_PNTRAD16-2_GM Bid: 0.16129032 2013-12-11 10:12:07.797 (1) [pool-5-thread-1]: Exiting insertOrUpdateBid method with return value: 2 2013-12-11 10:12:07.798 (3) [pool-5-thread-1]: BING - PNTRAD16 has 0 campaigns for a SE Update accounts sync. 2013-12-11 10:12:07.798 (3) [pool-5-thread-1]: BING - PNTRAD16 has 0 campaigns for a SE Update groups-listings sync. 2013-12-11 10:12:07.798 (3) [pool-5-thread-1]: PNTRAD16 has 0 campaigns for a SE Update accounts sync. 2013-12-11 10:12:07.798 (3) [pool-5-thread-1]: PNTRAD16 has 0 campaigns for a SE Update groups-listings sync. 2013-12-11 10:12:07.798 (3) [pool-5-thread-1]: 0 Scheduled Job Items to save for PNTRAD16. 2013-12-11 10:12:07.798 (3) [pool-5-thread-1]: Finished sub-campaign processing for DEPLOY deploymentID (PNTRAD16). account PNTRAD16. 4 submitted, 2 ok. 2013-12-11 10:12:07.799 (3) [pool-5-thread-1]: Finished DEPLOY request for PNTRAD16_1000000024_1603_PNTRAD16-1: FAILED 2013-12-11 10:12:07.799 (3) [pool-5-thread-1]: Finished DEPLOY request for PNTRAD16_1000000024_1603_PNTRAD16-2: SUCCEDED 2013-12-11 10:12:07.799 (3) [pool-5-thread-1]: Finished DEPLOY request, deploymentID (PNTRAD16), account PNTRAD16 2013-12-11 10:12:13.087 (3) [pool-6-thread-1]: ST2_JBOSS1--/queue/AdMaxResponseQueue-Responder responded back successfully