2014-06-10 08:28:34.169 (3) [Thread-71]: YELL_VM_JBOSS1--/queue/AdMaxDeployRequestQueue-Receptor queued BPID - BNV9UP25 for processing 2014-06-10 08:28:34.175 (3) [pool-3-thread-4]: Updating account tables for BNV9UP25 2014-06-10 08:28:34.191 (3) [pool-3-thread-4]: Committing Account settings for 81702 2014-06-10 08:28:34.197 (3) [pool-3-thread-4]: Using enhanced campaigns for account BNV9UP25 2014-06-10 08:28:34.201 (3) [pool-3-thread-4]: Updating advert budget for BNV9UP25_1000000024_736_BNV9UP25-1 2014-06-10 08:28:34.202 (3) [pool-3-thread-4]: Nominal monthly budget was unchanged for AdMax campaign ID: 5042 2014-06-10 08:28:34.206 (3) [pool-3-thread-4]: Updating advert budget for BNV9UP25_1000000024_736_BNV9UP25-2 2014-06-10 08:28:34.207 (3) [pool-3-thread-4]: Nominal monthly budget was unchanged for AdMax campaign ID: 5043 2014-06-10 08:28:34.210 (3) [pool-3-thread-4]: Updating advert budget for BNV9UP25_1000000024_736_BNV9UP25-3 2014-06-10 08:28:34.212 (3) [pool-3-thread-4]: Nominal monthly budget was unchanged for AdMax campaign ID: 5044 2014-06-10 08:28:34.215 (3) [pool-3-thread-4]: Updating advert budget for BNV9UP25_1000000024_736_BNV9UP25-4 2014-06-10 08:28:34.216 (3) [pool-3-thread-4]: Nominal monthly budget was unchanged for AdMax campaign ID: 5045 2014-06-10 08:28:34.220 (3) [pool-3-thread-4]: Terminating advert budget for BNV9UP25_1000000024_736_BNV9UP25-5 2014-06-10 08:28:34.223 (3) [pool-3-thread-4]: Debug Level set to 3 2014-06-10 08:28:34.223 (3) [pool-3-thread-4]: Debug Level set to 3 2014-06-10 08:28:34.233 (3) [pool-3-thread-4]: Start processing DEPLOY request (BNV9UP25) for account BNV9UP25. 10 campaign(s). 2014-06-10 08:28:34.233 (3) [pool-3-thread-4]: Performing sync for account: BNV9UP25 ID#81702 2014-06-10 08:28:34.294 (3) [pool-3-thread-4]: BING Account Worker has 10 campaign(s) to update. 2014-06-10 08:28:34.294 (3) [pool-3-thread-4]: BING Account Worker has 0 campaign(s) to create. 2014-06-10 08:28:34.294 (3) [pool-3-thread-4]: BING Account Worker has 0 campaign(s) to retry and update. 2014-06-10 08:28:34.294 (3) [pool-3-thread-4]: CampaignWorker initialized for account: 81702 2014-06-10 08:28:34.294 (3) [pool-3-thread-4]: Updating BNV9UP25_1000000024_736_BNV9UP25-1_GT Status: Paused 2014-06-10 08:28:34.294 (3) [pool-3-thread-4]: Updating BNV9UP25_1000000024_736_BNV9UP25-1_GM Status: Paused 2014-06-10 08:28:34.294 (3) [pool-3-thread-4]: Updating BNV9UP25_1000000024_736_BNV9UP25-2_GT Status: Active 2014-06-10 08:28:34.294 (3) [pool-3-thread-4]: Updating BNV9UP25_1000000024_736_BNV9UP25-2_GM Status: Active 2014-06-10 08:28:34.294 (3) [pool-3-thread-4]: Updating BNV9UP25_1000000024_736_BNV9UP25-3_GT Status: Active 2014-06-10 08:28:34.294 (3) [pool-3-thread-4]: Updating BNV9UP25_1000000024_736_BNV9UP25-3_GM Status: Active 2014-06-10 08:28:34.294 (3) [pool-3-thread-4]: Updating BNV9UP25_1000000024_736_BNV9UP25-4_GT Status: Paused 2014-06-10 08:28:34.294 (3) [pool-3-thread-4]: Updating BNV9UP25_1000000024_736_BNV9UP25-4_GM Status: Paused 2014-06-10 08:28:34.295 (3) [pool-3-thread-4]: Updating BNV9UP25_1000000024_736_BNV9UP25-5_GT Status: Deleted 2014-06-10 08:28:34.295 (3) [pool-3-thread-4]: Updating BNV9UP25_1000000024_736_BNV9UP25-5_GM Status: Deleted 2014-06-10 08:28:34.295 (3) [pool-3-thread-4]: BingCampaignUpdateWorker started... 2014-06-10 08:28:34.333 (3) [pool-3-thread-4]: BNV9UP25_1000000024_736_BNV9UP25-1_GT is already set to Paused in the database. 2014-06-10 08:28:34.333 (3) [pool-3-thread-4]: BNV9UP25_1000000024_736_BNV9UP25-1_GT target sync: 2014-06-10 08:28:34.333 (3) [pool-3-thread-4]: Proximity Target unchanged proximity_56.24106216430664,-0.19067199528217316 TEN (miles) 2014-06-10 08:28:34.333 (3) [pool-3-thread-4]: BNV9UP25_1000000024_736_BNV9UP25-1_GT has no updated targets. 2014-06-10 08:28:34.333 (3) [pool-3-thread-4]: BNV9UP25_1000000024_736_BNV9UP25-1_GM is already set to Paused in the database. 2014-06-10 08:28:34.333 (3) [pool-3-thread-4]: BNV9UP25_1000000024_736_BNV9UP25-1_GM target sync: 2014-06-10 08:28:34.333 (3) [pool-3-thread-4]: BNV9UP25_1000000024_736_BNV9UP25-1_GM has no updated targets. 2014-06-10 08:28:34.333 (3) [pool-3-thread-4]: BNV9UP25_1000000024_736_BNV9UP25-2_GT status change (Paused->Active) 2014-06-10 08:28:34.333 (3) [pool-3-thread-4]: BNV9UP25_1000000024_736_BNV9UP25-2_GT target sync: 2014-06-10 08:28:34.333 (3) [pool-3-thread-4]: Proximity Target unchanged proximity_56.24106216430664,-0.19067199528217316 TEN (miles) 2014-06-10 08:28:34.333 (3) [pool-3-thread-4]: BNV9UP25_1000000024_736_BNV9UP25-2_GT has no updated targets. 2014-06-10 08:28:34.333 (3) [pool-3-thread-4]: BNV9UP25_1000000024_736_BNV9UP25-2_GM status change (Paused->Active) 2014-06-10 08:28:34.333 (3) [pool-3-thread-4]: BNV9UP25_1000000024_736_BNV9UP25-2_GM target sync: 2014-06-10 08:28:34.333 (3) [pool-3-thread-4]: BNV9UP25_1000000024_736_BNV9UP25-2_GM has no updated targets. 2014-06-10 08:28:34.333 (3) [pool-3-thread-4]: BNV9UP25_1000000024_736_BNV9UP25-3_GT status change (Paused->Active) 2014-06-10 08:28:34.334 (3) [pool-3-thread-4]: BNV9UP25_1000000024_736_BNV9UP25-3_GT target sync: 2014-06-10 08:28:34.334 (3) [pool-3-thread-4]: Proximity Target unchanged proximity_56.24106216430664,-0.19067199528217316 TEN (miles) 2014-06-10 08:28:34.334 (3) [pool-3-thread-4]: BNV9UP25_1000000024_736_BNV9UP25-3_GT has no updated targets. 2014-06-10 08:28:34.334 (3) [pool-3-thread-4]: BNV9UP25_1000000024_736_BNV9UP25-3_GM status change (Paused->Active) 2014-06-10 08:28:34.334 (3) [pool-3-thread-4]: BNV9UP25_1000000024_736_BNV9UP25-3_GM target sync: 2014-06-10 08:28:34.334 (3) [pool-3-thread-4]: BNV9UP25_1000000024_736_BNV9UP25-3_GM has no updated targets. 2014-06-10 08:28:34.334 (3) [pool-3-thread-4]: BNV9UP25_1000000024_736_BNV9UP25-4_GT is already set to Paused in the database. 2014-06-10 08:28:34.334 (3) [pool-3-thread-4]: BNV9UP25_1000000024_736_BNV9UP25-4_GT target sync: 2014-06-10 08:28:34.334 (3) [pool-3-thread-4]: Proximity Target unchanged proximity_56.24106216430664,-0.19067199528217316 TEN (miles) 2014-06-10 08:28:34.334 (3) [pool-3-thread-4]: BNV9UP25_1000000024_736_BNV9UP25-4_GT has no updated targets. 2014-06-10 08:28:34.334 (3) [pool-3-thread-4]: BNV9UP25_1000000024_736_BNV9UP25-4_GM is already set to Paused in the database. 2014-06-10 08:28:34.334 (3) [pool-3-thread-4]: BNV9UP25_1000000024_736_BNV9UP25-4_GM target sync: 2014-06-10 08:28:34.334 (3) [pool-3-thread-4]: BNV9UP25_1000000024_736_BNV9UP25-4_GM has no updated targets. 2014-06-10 08:28:34.334 (3) [pool-3-thread-4]: BNV9UP25_1000000024_736_BNV9UP25-5_GT status change (Paused->Deleted) 2014-06-10 08:28:34.334 (3) [pool-3-thread-4]: Campaign deleted, skipping target sync. 2014-06-10 08:28:34.334 (3) [pool-3-thread-4]: BNV9UP25_1000000024_736_BNV9UP25-5_GM status change (Paused->Deleted) 2014-06-10 08:28:34.334 (3) [pool-3-thread-4]: Campaign deleted, skipping target sync. 2014-06-10 08:28:34.335 (2) [pool-3-thread-4]: TextAdDAO: database is null 2014-06-10 08:28:34.335 (2) [pool-3-thread-4]: KeywordDAO: database is null 2014-06-10 08:28:34.352 (3) [pool-3-thread-4]: ----------------Bing Content Editor starting 2014-06-10 08:28:34.414 (3) [P10T1]: CampaignChangeRequest (accountID 81702): Sending 6 update requests 2014-06-10 08:28:35.850 (3) [P10T1]: CampaignDAO(accountID 81702) Request contained 0 adds, 6 updates, 0 deletes. 2014-06-10 08:28:35.850 (3) [P10T1]: CampaignDAO(accountID 81702) DB updates: 6 items updated, 6 pending changes deleted, 6 pending updates deleted, 0 errors cleared 2014-06-10 08:28:35.989 (3) [pool-3-thread-4]: ------------Bing Content Editor done 2014-06-10 08:28:36.017 (3) [pool-3-thread-4]: SE Update account will run for BNV9UP25_1000000024_736_BNV9UP25-2_GT 2014-06-10 08:28:36.021 (3) [pool-3-thread-4]: SE Update account will run for BNV9UP25_1000000024_736_BNV9UP25-2_GM 2014-06-10 08:28:36.025 (3) [pool-3-thread-4]: SE Update account will run for BNV9UP25_1000000024_736_BNV9UP25-3_GT 2014-06-10 08:28:36.029 (3) [pool-3-thread-4]: SE Update account will run for BNV9UP25_1000000024_736_BNV9UP25-3_GM 2014-06-10 08:28:36.032 (3) [pool-3-thread-4]: SE Update account will run for BNV9UP25_1000000024_736_BNV9UP25-5_GT 2014-06-10 08:28:36.036 (3) [pool-3-thread-4]: SE Update account will run for BNV9UP25_1000000024_736_BNV9UP25-5_GM 2014-06-10 08:28:36.037 (3) [pool-3-thread-4]: Running content editor replace... 2014-06-10 08:28:36.039 (3) [pool-3-thread-4]: ----------------Bing Content Editor starting 2014-06-10 08:28:36.159 (3) [P11T1]: No deleted adgroups found 2014-06-10 08:28:36.163 (3) [P11T1]: Deletes Pending Change 0 adgroups and adding 0 adgroups. 2014-06-10 08:28:36.529 (3) [P11T1]: No deleted keywords found 2014-06-10 08:28:36.534 (3) [P11T1]: Deleting 0 keywords and adding 0 keywords and Updated 0. 2014-06-10 08:28:36.578 (3) [P11T1]: Deleting 24 text ads and adding 24 text ads. 2014-06-10 08:28:36.583 (3) [P11T1]: replace 8 changed campaigns 2014-06-10 08:28:36.630 (3) [pool-43-thread-1]: TextAdChangeRequest (accountID 81702): Sending 3 delete requests 2014-06-10 08:28:36.670 (3) [pool-43-thread-2]: TextAdChangeRequest (accountID 81702): Sending 3 delete requests 2014-06-10 08:28:36.678 (3) [pool-43-thread-3]: TextAdChangeRequest (accountID 81702): Sending 3 delete requests 2014-06-10 08:28:36.688 (3) [pool-43-thread-4]: TextAdChangeRequest (accountID 81702): Sending 3 delete requests 2014-06-10 08:28:36.689 (3) [pool-43-thread-5]: TextAdChangeRequest (accountID 81702): Sending 3 delete requests 2014-06-10 08:28:36.690 (3) [pool-43-thread-6]: TextAdChangeRequest (accountID 81702): Sending 3 delete requests 2014-06-10 08:28:36.690 (3) [pool-43-thread-7]: TextAdChangeRequest (accountID 81702): Sending 3 delete requests 2014-06-10 08:28:36.691 (3) [pool-43-thread-8]: TextAdChangeRequest (accountID 81702): Sending 3 delete requests 2014-06-10 08:28:37.210 (3) [pool-43-thread-5]: TextAdDAO (accountID 81702) DB deletes: 3 deleted 2014-06-10 08:28:37.459 (2) [pool-43-thread-1]: TrackingID: 8ce60e08-f8aa-4cea-b45d-52972724b87a, Operation Error code[1120], Textual Error code[CampaignServiceInvalidCampaignStatus], msg[The campaign status is invalid for the current operation.], details[null] 2014-06-10 08:28:37.459 (1) [pool-43-thread-1]: Unrecoverable MSN API error (Invalid client data. Check the SOAP fault details for more information) 2014-06-10 08:28:37.478 (2) [pool-43-thread-4]: TrackingID: b9c39a19-21b4-450f-b199-3776df2cec68, Operation Error code[1120], Textual Error code[CampaignServiceInvalidCampaignStatus], msg[The campaign status is invalid for the current operation.], details[null] 2014-06-10 08:28:37.478 (1) [pool-43-thread-4]: Unrecoverable MSN API error (Invalid client data. Check the SOAP fault details for more information) 2014-06-10 08:28:37.671 (3) [pool-43-thread-1]: Exception [SEUser 85361 TextAdChangeRequest delete request: SQL error processing 3 pending delete(s)]:java.sql.BatchUpdateException: Cannot add or update a child row: a foreign key constraint fails (`content_editor_bing`.`bce_textAdError`, CONSTRAINT `bce_textAdError_ibfk_1` FOREIGN KEY (`textAdID`) REFERENCES `bce_textAd` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:665) at com.carldunham.jst.db.Database.commitBatch(Database.java:722) at com.thesearchagency.searchengines.bing.contenteditor.dao.BaseDAO.saveErrorsInsertErrorsHelper(BaseDAO.java:1101) at com.thesearchagency.searchengines.bing.contenteditor.dao.BaseDAO.saveErrors(BaseDAO.java:529) at com.thesearchagency.searchengines.bing.contenteditor.changerequest.BaseChangeRequest.saveErrors(BaseChangeRequest.java:347) at com.thesearchagency.searchengines.bing.contenteditor.changerequest.BaseChangeRequest.handleAPIError(BaseChangeRequest.java:212) at com.thesearchagency.searchengines.bing.contenteditor.changerequest.BaseChangeRequest.makeRequest(BaseChangeRequest.java:131) at com.thesearchagency.searchengines.bing.contenteditor.BingContentEditor$RequestWorker.call(BingContentEditor.java:1257) at com.thesearchagency.searchengines.bing.contenteditor.BingContentEditor$RequestWorker.call(BingContentEditor.java:1239) 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) 2014-06-10 08:28:37.671 (2) [pool-43-thread-1]: Bing Request Errors for accountID 81702(TextAdChangeRequest) id=-1, trackingID=8ce60e08-f8aa-4cea-b45d-52972724b87a: , code=1120: , errorCode=CampaignServiceInvalidCampaignStatus: , message=The campaign status is invalid for the current operation.: 2014-06-10 08:28:37.672 (3) [pool-43-thread-4]: Exception [SEUser 85361 TextAdChangeRequest delete request: SQL error processing 3 pending delete(s)]:java.sql.BatchUpdateException: Cannot add or update a child row: a foreign key constraint fails (`content_editor_bing`.`bce_textAdError`, CONSTRAINT `bce_textAdError_ibfk_1` FOREIGN KEY (`textAdID`) REFERENCES `bce_textAd` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:665) at com.carldunham.jst.db.Database.commitBatch(Database.java:722) at com.thesearchagency.searchengines.bing.contenteditor.dao.BaseDAO.saveErrorsInsertErrorsHelper(BaseDAO.java:1101) at com.thesearchagency.searchengines.bing.contenteditor.dao.BaseDAO.saveErrors(BaseDAO.java:529) at com.thesearchagency.searchengines.bing.contenteditor.changerequest.BaseChangeRequest.saveErrors(BaseChangeRequest.java:347) at com.thesearchagency.searchengines.bing.contenteditor.changerequest.BaseChangeRequest.handleAPIError(BaseChangeRequest.java:212) at com.thesearchagency.searchengines.bing.contenteditor.changerequest.BaseChangeRequest.makeRequest(BaseChangeRequest.java:131) at com.thesearchagency.searchengines.bing.contenteditor.BingContentEditor$RequestWorker.call(BingContentEditor.java:1257) at com.thesearchagency.searchengines.bing.contenteditor.BingContentEditor$RequestWorker.call(BingContentEditor.java:1239) 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) 2014-06-10 08:28:37.672 (2) [pool-43-thread-4]: Bing Request Errors for accountID 81702(TextAdChangeRequest) id=-1, trackingID=b9c39a19-21b4-450f-b199-3776df2cec68: , code=1120: , errorCode=CampaignServiceInvalidCampaignStatus: , message=The campaign status is invalid for the current operation.: 2014-06-10 08:28:37.979 (3) [pool-43-thread-6]: TextAdDAO (accountID 81702) DB deletes: 3 deleted 2014-06-10 08:28:38.383 (2) [pool-43-thread-8]: TrackingID: 886bae0f-dfa1-4403-a941-70381f00aa51, Operation Error code[1120], Textual Error code[CampaignServiceInvalidCampaignStatus], msg[The campaign status is invalid for the current operation.], details[null] 2014-06-10 08:28:38.383 (1) [pool-43-thread-8]: Unrecoverable MSN API error (Invalid client data. Check the SOAP fault details for more information) 2014-06-10 08:28:38.390 (3) [pool-43-thread-8]: Exception [SEUser 85361 TextAdChangeRequest delete request: SQL error processing 3 pending delete(s)]:java.sql.BatchUpdateException: Cannot add or update a child row: a foreign key constraint fails (`content_editor_bing`.`bce_textAdError`, CONSTRAINT `bce_textAdError_ibfk_1` FOREIGN KEY (`textAdID`) REFERENCES `bce_textAd` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:665) at com.carldunham.jst.db.Database.commitBatch(Database.java:722) at com.thesearchagency.searchengines.bing.contenteditor.dao.BaseDAO.saveErrorsInsertErrorsHelper(BaseDAO.java:1101) at com.thesearchagency.searchengines.bing.contenteditor.dao.BaseDAO.saveErrors(BaseDAO.java:529) at com.thesearchagency.searchengines.bing.contenteditor.changerequest.BaseChangeRequest.saveErrors(BaseChangeRequest.java:347) at com.thesearchagency.searchengines.bing.contenteditor.changerequest.BaseChangeRequest.handleAPIError(BaseChangeRequest.java:212) at com.thesearchagency.searchengines.bing.contenteditor.changerequest.BaseChangeRequest.makeRequest(BaseChangeRequest.java:131) at com.thesearchagency.searchengines.bing.contenteditor.BingContentEditor$RequestWorker.call(BingContentEditor.java:1257) at com.thesearchagency.searchengines.bing.contenteditor.BingContentEditor$RequestWorker.call(BingContentEditor.java:1239) 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) 2014-06-10 08:28:38.390 (2) [pool-43-thread-8]: Bing Request Errors for accountID 81702(TextAdChangeRequest) id=-1, trackingID=886bae0f-dfa1-4403-a941-70381f00aa51: , code=1120: , errorCode=CampaignServiceInvalidCampaignStatus: , message=The campaign status is invalid for the current operation.: 2014-06-10 08:28:38.451 (2) [pool-43-thread-7]: TrackingID: 257e31af-befd-498e-ac63-f1004d01debe, Operation Error code[1120], Textual Error code[CampaignServiceInvalidCampaignStatus], msg[The campaign status is invalid for the current operation.], details[null] 2014-06-10 08:28:38.452 (1) [pool-43-thread-7]: Unrecoverable MSN API error (Invalid client data. Check the SOAP fault details for more information) 2014-06-10 08:28:38.466 (3) [pool-43-thread-7]: Exception [SEUser 85361 TextAdChangeRequest delete request: SQL error processing 3 pending delete(s)]:java.sql.BatchUpdateException: Cannot add or update a child row: a foreign key constraint fails (`content_editor_bing`.`bce_textAdError`, CONSTRAINT `bce_textAdError_ibfk_1` FOREIGN KEY (`textAdID`) REFERENCES `bce_textAd` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:665) at com.carldunham.jst.db.Database.commitBatch(Database.java:722) at com.thesearchagency.searchengines.bing.contenteditor.dao.BaseDAO.saveErrorsInsertErrorsHelper(BaseDAO.java:1101) at com.thesearchagency.searchengines.bing.contenteditor.dao.BaseDAO.saveErrors(BaseDAO.java:529) at com.thesearchagency.searchengines.bing.contenteditor.changerequest.BaseChangeRequest.saveErrors(BaseChangeRequest.java:347) at com.thesearchagency.searchengines.bing.contenteditor.changerequest.BaseChangeRequest.handleAPIError(BaseChangeRequest.java:212) at com.thesearchagency.searchengines.bing.contenteditor.changerequest.BaseChangeRequest.makeRequest(BaseChangeRequest.java:131) at com.thesearchagency.searchengines.bing.contenteditor.BingContentEditor$RequestWorker.call(BingContentEditor.java:1257) at com.thesearchagency.searchengines.bing.contenteditor.BingContentEditor$RequestWorker.call(BingContentEditor.java:1239) 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) 2014-06-10 08:28:38.466 (2) [pool-43-thread-7]: Bing Request Errors for accountID 81702(TextAdChangeRequest) id=-1, trackingID=257e31af-befd-498e-ac63-f1004d01debe: , code=1120: , errorCode=CampaignServiceInvalidCampaignStatus: , message=The campaign status is invalid for the current operation.: 2014-06-10 08:28:39.427 (2) [pool-43-thread-2]: TrackingID: 442f9584-cf34-4e6f-8d94-b74761d71c0d, Operation Error code[1120], Textual Error code[CampaignServiceInvalidCampaignStatus], msg[The campaign status is invalid for the current operation.], details[null] 2014-06-10 08:28:39.427 (1) [pool-43-thread-2]: Unrecoverable MSN API error (Invalid client data. Check the SOAP fault details for more information) 2014-06-10 08:28:39.489 (3) [pool-43-thread-2]: Exception [SEUser 85361 TextAdChangeRequest delete request: SQL error processing 3 pending delete(s)]:java.sql.BatchUpdateException: Cannot add or update a child row: a foreign key constraint fails (`content_editor_bing`.`bce_textAdError`, CONSTRAINT `bce_textAdError_ibfk_1` FOREIGN KEY (`textAdID`) REFERENCES `bce_textAd` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:665) at com.carldunham.jst.db.Database.commitBatch(Database.java:722) at com.thesearchagency.searchengines.bing.contenteditor.dao.BaseDAO.saveErrorsInsertErrorsHelper(BaseDAO.java:1101) at com.thesearchagency.searchengines.bing.contenteditor.dao.BaseDAO.saveErrors(BaseDAO.java:529) at com.thesearchagency.searchengines.bing.contenteditor.changerequest.BaseChangeRequest.saveErrors(BaseChangeRequest.java:347) at com.thesearchagency.searchengines.bing.contenteditor.changerequest.BaseChangeRequest.handleAPIError(BaseChangeRequest.java:212) at com.thesearchagency.searchengines.bing.contenteditor.changerequest.BaseChangeRequest.makeRequest(BaseChangeRequest.java:131) at com.thesearchagency.searchengines.bing.contenteditor.BingContentEditor$RequestWorker.call(BingContentEditor.java:1257) at com.thesearchagency.searchengines.bing.contenteditor.BingContentEditor$RequestWorker.call(BingContentEditor.java:1239) 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) 2014-06-10 08:28:39.489 (2) [pool-43-thread-2]: Bing Request Errors for accountID 81702(TextAdChangeRequest) id=-1, trackingID=442f9584-cf34-4e6f-8d94-b74761d71c0d: , code=1120: , errorCode=CampaignServiceInvalidCampaignStatus: , message=The campaign status is invalid for the current operation.: 2014-06-10 08:28:40.240 (2) [pool-43-thread-3]: TrackingID: 5eea9ca6-1897-471b-a8b5-0233556e54dc, Operation Error code[1120], Textual Error code[CampaignServiceInvalidCampaignStatus], msg[The campaign status is invalid for the current operation.], details[null] 2014-06-10 08:28:40.241 (1) [pool-43-thread-3]: Unrecoverable MSN API error (Invalid client data. Check the SOAP fault details for more information) 2014-06-10 08:28:40.276 (3) [pool-43-thread-3]: Exception [SEUser 85361 TextAdChangeRequest delete request: SQL error processing 3 pending delete(s)]:java.sql.BatchUpdateException: Cannot add or update a child row: a foreign key constraint fails (`content_editor_bing`.`bce_textAdError`, CONSTRAINT `bce_textAdError_ibfk_1` FOREIGN KEY (`textAdID`) REFERENCES `bce_textAd` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:665) at com.carldunham.jst.db.Database.commitBatch(Database.java:722) at com.thesearchagency.searchengines.bing.contenteditor.dao.BaseDAO.saveErrorsInsertErrorsHelper(BaseDAO.java:1101) at com.thesearchagency.searchengines.bing.contenteditor.dao.BaseDAO.saveErrors(BaseDAO.java:529) at com.thesearchagency.searchengines.bing.contenteditor.changerequest.BaseChangeRequest.saveErrors(BaseChangeRequest.java:347) at com.thesearchagency.searchengines.bing.contenteditor.changerequest.BaseChangeRequest.handleAPIError(BaseChangeRequest.java:212) at com.thesearchagency.searchengines.bing.contenteditor.changerequest.BaseChangeRequest.makeRequest(BaseChangeRequest.java:131) at com.thesearchagency.searchengines.bing.contenteditor.BingContentEditor$RequestWorker.call(BingContentEditor.java:1257) at com.thesearchagency.searchengines.bing.contenteditor.BingContentEditor$RequestWorker.call(BingContentEditor.java:1239) 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) 2014-06-10 08:28:40.276 (2) [pool-43-thread-3]: Bing Request Errors for accountID 81702(TextAdChangeRequest) id=-1, trackingID=5eea9ca6-1897-471b-a8b5-0233556e54dc: , code=1120: , errorCode=CampaignServiceInvalidCampaignStatus: , message=The campaign status is invalid for the current operation.: 2014-06-10 08:28:40.763 (3) [pool-43-thread-9]: TextAdChangeRequest (accountID 81702): Sending 3 add requests 2014-06-10 08:28:40.764 (3) [pool-43-thread-5]: TextAdChangeRequest (accountID 81702): Sending 3 add requests 2014-06-10 08:28:40.765 (3) [pool-43-thread-1]: TextAdChangeRequest (accountID 81702): Sending 3 add requests 2014-06-10 08:28:40.765 (3) [pool-43-thread-4]: TextAdChangeRequest (accountID 81702): Sending 3 add requests 2014-06-10 08:28:40.766 (3) [pool-43-thread-6]: TextAdChangeRequest (accountID 81702): Sending 3 add requests 2014-06-10 08:28:40.766 (3) [pool-43-thread-8]: TextAdChangeRequest (accountID 81702): Sending 3 add requests 2014-06-10 08:28:40.766 (3) [pool-43-thread-7]: TextAdChangeRequest (accountID 81702): Sending 3 add requests 2014-06-10 08:28:40.766 (3) [pool-43-thread-10]: TextAdChangeRequest (accountID 81702): Sending 3 add requests 2014-06-10 08:28:41.470 (2) [pool-43-thread-9]: TrackingID: 7a8e4c4b-e019-41b6-a7c1-cf8dbdb3396e, Operation Error code[1120], Textual Error code[CampaignServiceInvalidCampaignStatus], msg[The campaign status is invalid for the current operation.], details[null] 2014-06-10 08:28:41.471 (1) [pool-43-thread-9]: Unrecoverable MSN API error (Invalid client data. Check the SOAP fault details for more information) 2014-06-10 08:28:41.473 (3) [pool-43-thread-9]: TextAdChangeRequest (accountID 81702): Errors recorded, no more changes to process 2014-06-10 08:28:41.473 (2) [pool-43-thread-9]: TextAdDAO: database is null 2014-06-10 08:28:41.474 (2) [pool-43-thread-9]: TextAdChangeRequest released connection to pool (legacy - theDAO does not have a pool to release the connection to) 2014-06-10 08:28:41.536 (3) [pool-43-thread-4]: TextAdDAO(accountID 81702) Request contained 3 adds, 0 updates, 0 deletes. 2014-06-10 08:28:41.536 (3) [pool-43-thread-4]: TextAdDAO(accountID 81702) DB updates: 3 items updated, 3 pending changes deleted, 0 pending updates deleted, 0 errors cleared 2014-06-10 08:28:41.539 (3) [pool-43-thread-6]: TextAdDAO(accountID 81702) Request contained 3 adds, 0 updates, 0 deletes. 2014-06-10 08:28:41.539 (3) [pool-43-thread-6]: TextAdDAO(accountID 81702) DB updates: 3 items updated, 3 pending changes deleted, 0 pending updates deleted, 0 errors cleared 2014-06-10 08:28:42.099 (2) [pool-43-thread-8]: TrackingID: 4c01f12e-9770-450f-a679-66661308ee9b, Operation Error code[1120], Textual Error code[CampaignServiceInvalidCampaignStatus], msg[The campaign status is invalid for the current operation.], details[null] 2014-06-10 08:28:42.099 (1) [pool-43-thread-8]: Unrecoverable MSN API error (Invalid client data. Check the SOAP fault details for more information) 2014-06-10 08:28:42.101 (3) [pool-43-thread-8]: TextAdChangeRequest (accountID 81702): Errors recorded, no more changes to process 2014-06-10 08:28:42.101 (2) [pool-43-thread-8]: TextAdDAO: database is null 2014-06-10 08:28:42.103 (2) [pool-43-thread-8]: TextAdChangeRequest released connection to pool (legacy - theDAO does not have a pool to release the connection to) 2014-06-10 08:28:42.223 (2) [pool-43-thread-10]: TrackingID: 5176bd75-79dd-4fcf-8505-b2a5b7ce6695, Operation Error code[1120], Textual Error code[CampaignServiceInvalidCampaignStatus], msg[The campaign status is invalid for the current operation.], details[null] 2014-06-10 08:28:42.223 (1) [pool-43-thread-10]: Unrecoverable MSN API error (Invalid client data. Check the SOAP fault details for more information) 2014-06-10 08:28:42.226 (3) [pool-43-thread-10]: TextAdChangeRequest (accountID 81702): Errors recorded, no more changes to process 2014-06-10 08:28:42.226 (2) [pool-43-thread-10]: TextAdDAO: database is null 2014-06-10 08:28:42.227 (2) [pool-43-thread-10]: TextAdChangeRequest released connection to pool (legacy - theDAO does not have a pool to release the connection to) 2014-06-10 08:28:42.308 (2) [pool-43-thread-7]: TrackingID: 908f3018-ba1e-49c0-ae77-306b4b60f715, Operation Error code[1120], Textual Error code[CampaignServiceInvalidCampaignStatus], msg[The campaign status is invalid for the current operation.], details[null] 2014-06-10 08:28:42.308 (1) [pool-43-thread-7]: Unrecoverable MSN API error (Invalid client data. Check the SOAP fault details for more information) 2014-06-10 08:28:42.310 (3) [pool-43-thread-7]: TextAdChangeRequest (accountID 81702): Errors recorded, no more changes to process 2014-06-10 08:28:42.310 (2) [pool-43-thread-7]: TextAdDAO: database is null 2014-06-10 08:28:42.313 (2) [pool-43-thread-7]: TextAdChangeRequest released connection to pool (legacy - theDAO does not have a pool to release the connection to) 2014-06-10 08:28:43.069 (2) [pool-43-thread-1]: TrackingID: 93f873a6-023e-4cbc-b13b-739250405fed, Operation Error code[1120], Textual Error code[CampaignServiceInvalidCampaignStatus], msg[The campaign status is invalid for the current operation.], details[null] 2014-06-10 08:28:43.069 (1) [pool-43-thread-1]: Unrecoverable MSN API error (Invalid client data. Check the SOAP fault details for more information) 2014-06-10 08:28:43.129 (3) [pool-43-thread-1]: TextAdChangeRequest (accountID 81702): Errors recorded, no more changes to process 2014-06-10 08:28:43.129 (2) [pool-43-thread-1]: TextAdDAO: database is null 2014-06-10 08:28:43.130 (2) [pool-43-thread-1]: TextAdChangeRequest released connection to pool (legacy - theDAO does not have a pool to release the connection to) 2014-06-10 08:28:45.940 (2) [pool-43-thread-5]: TrackingID: 478ac73b-f573-4404-824f-8e57a5c85850, Operation Error code[1120], Textual Error code[CampaignServiceInvalidCampaignStatus], msg[The campaign status is invalid for the current operation.], details[null] 2014-06-10 08:28:45.940 (1) [pool-43-thread-5]: Unrecoverable MSN API error (Invalid client data. Check the SOAP fault details for more information) 2014-06-10 08:28:45.944 (3) [pool-43-thread-5]: TextAdChangeRequest (accountID 81702): Errors recorded, no more changes to process 2014-06-10 08:28:45.944 (2) [pool-43-thread-5]: TextAdDAO: database is null 2014-06-10 08:28:45.945 (2) [pool-43-thread-5]: TextAdChangeRequest released connection to pool (legacy - theDAO does not have a pool to release the connection to) 2014-06-10 08:28:48.401 (3) [pool-3-thread-4]: ------------Bing Content Editor done 2014-06-10 08:28:48.407 (3) [pool-3-thread-4]: Deleted: 0 unregistered textAds 2014-06-10 08:28:48.411 (3) [pool-3-thread-4]: Deleted: 0 unregistered keywords 2014-06-10 08:28:48.411 (3) [pool-3-thread-4]: Updating 0 TextAd display/destination URLs and 0 keyword destination URLs 2014-06-10 08:28:48.420 (3) [pool-3-thread-4]: Deleted: 0 unregistered textAds 2014-06-10 08:28:48.423 (3) [pool-3-thread-4]: Deleted: 0 unregistered keywords 2014-06-10 08:28:48.423 (3) [pool-3-thread-4]: Updating 0 TextAd display/destination URLs and 0 keyword destination URLs 2014-06-10 08:28:48.435 (2) [pool-3-thread-4]: updateTextAdDestinationURLs(): Number of pending deletes (0) != numPendingAds (3) 2014-06-10 08:28:48.436 (3) [pool-3-thread-4]: Deleted: 0 unregistered textAds 2014-06-10 08:28:48.438 (3) [pool-3-thread-4]: Deleted: 0 unregistered keywords 2014-06-10 08:28:48.438 (3) [pool-3-thread-4]: Updating 0 TextAd display/destination URLs and 0 keyword destination URLs 2014-06-10 08:28:48.446 (2) [pool-3-thread-4]: updateTextAdDestinationURLs(): Number of pending deletes (0) != numPendingAds (3) 2014-06-10 08:28:48.447 (3) [pool-3-thread-4]: Deleted: 0 unregistered textAds 2014-06-10 08:28:48.449 (3) [pool-3-thread-4]: Deleted: 0 unregistered keywords 2014-06-10 08:28:48.449 (3) [pool-3-thread-4]: Updating 0 TextAd display/destination URLs and 0 keyword destination URLs 2014-06-10 08:28:48.457 (2) [pool-3-thread-4]: updateTextAdDestinationURLs(): Number of pending deletes (0) != numPendingAds (3) 2014-06-10 08:28:48.459 (3) [pool-3-thread-4]: Deleted: 0 unregistered textAds 2014-06-10 08:28:48.461 (3) [pool-3-thread-4]: Deleted: 0 unregistered keywords 2014-06-10 08:28:48.462 (3) [pool-3-thread-4]: Updating 0 TextAd display/destination URLs and 0 keyword destination URLs 2014-06-10 08:28:48.472 (2) [pool-3-thread-4]: updateTextAdDestinationURLs(): Number of pending deletes (0) != numPendingAds (3) 2014-06-10 08:28:48.474 (3) [pool-3-thread-4]: Deleted: 0 unregistered textAds 2014-06-10 08:28:48.477 (3) [pool-3-thread-4]: Deleted: 0 unregistered keywords 2014-06-10 08:28:48.477 (3) [pool-3-thread-4]: Updating 0 TextAd display/destination URLs and 0 keyword destination URLs 2014-06-10 08:28:48.488 (3) [pool-3-thread-4]: updateTextAdDestinationURLs(): Updated 3 ads with displayURL=www.testingp3.com/ and destinationURL=http://www.testingp3.com/ 2014-06-10 08:28:48.490 (3) [pool-3-thread-4]: Deleted: 0 unregistered textAds 2014-06-10 08:28:48.494 (3) [pool-3-thread-4]: Deleted: 0 unregistered keywords 2014-06-10 08:28:48.494 (3) [pool-3-thread-4]: Updating 3 TextAd display/destination URLs and 0 keyword destination URLs 2014-06-10 08:28:48.496 (3) [pool-3-thread-4]: DestinationURL update for BNV9UP25_1000000024_736_BNV9UP25-4_GT: http://www.testingp3.com/ 2014-06-10 08:28:48.496 (3) [pool-3-thread-4]: DisplayURL update for BNV9UP25_1000000024_736_BNV9UP25-4_GT: http://www.testingp3.com/ 2014-06-10 08:28:48.496 (3) [pool-3-thread-4]: AutotagEnabled BNV9UP25_1000000024_736_BNV9UP25-4_GT: false 2014-06-10 08:28:48.507 (3) [pool-3-thread-4]: updateTextAdDestinationURLs(): Updated 3 ads with displayURL=www.testingp3.com/ and destinationURL=http://www.testingp3.com/ 2014-06-10 08:28:48.508 (3) [pool-3-thread-4]: Deleted: 0 unregistered textAds 2014-06-10 08:28:48.511 (3) [pool-3-thread-4]: Deleted: 0 unregistered keywords 2014-06-10 08:28:48.511 (3) [pool-3-thread-4]: Updating 3 TextAd display/destination URLs and 0 keyword destination URLs 2014-06-10 08:28:48.513 (3) [pool-3-thread-4]: DestinationURL update for BNV9UP25_1000000024_736_BNV9UP25-4_GM: http://www.testingp3.com/ 2014-06-10 08:28:48.513 (3) [pool-3-thread-4]: DisplayURL update for BNV9UP25_1000000024_736_BNV9UP25-4_GM: http://www.testingp3.com/ 2014-06-10 08:28:48.513 (3) [pool-3-thread-4]: AutotagEnabled BNV9UP25_1000000024_736_BNV9UP25-4_GM: false 2014-06-10 08:28:48.519 (2) [pool-3-thread-4]: updateTextAdDestinationURLs(): Number of pending deletes (0) != numPendingAds (3) 2014-06-10 08:28:48.520 (3) [pool-3-thread-4]: Deleted: 0 unregistered textAds 2014-06-10 08:28:48.522 (3) [pool-3-thread-4]: Deleted: 0 unregistered keywords 2014-06-10 08:28:48.522 (3) [pool-3-thread-4]: Updating 0 TextAd display/destination URLs and 0 keyword destination URLs 2014-06-10 08:28:48.531 (2) [pool-3-thread-4]: updateTextAdDestinationURLs(): Number of pending deletes (0) != numPendingAds (3) 2014-06-10 08:28:48.533 (3) [pool-3-thread-4]: Deleted: 0 unregistered textAds 2014-06-10 08:28:48.536 (3) [pool-3-thread-4]: Deleted: 0 unregistered keywords 2014-06-10 08:28:48.536 (3) [pool-3-thread-4]: Updating 0 TextAd display/destination URLs and 0 keyword destination URLs 2014-06-10 08:28:48.538 (3) [pool-3-thread-4]: Running content editor for dest. url updates 2014-06-10 08:28:48.538 (3) [pool-3-thread-4]: =============== Starting Bing Content Editor ================ 2014-06-10 08:28:48.538 (3) [pool-3-thread-4]: ----------------Bing Content Editor starting 2014-06-10 08:28:48.549 (3) [P12T1]: Creating Bing accounts for accountID 81702 2014-06-10 08:28:48.570 (3) [pool-3-thread-4]: ------------Bing Content Editor done 2014-06-10 08:28:48.570 (3) [pool-3-thread-4]: ----------------Bing Content Editor starting 2014-06-10 08:28:48.653 (3) [pool-48-thread-1]: TextAdChangeRequest (accountID 81702): Sending 3 delete requests 2014-06-10 08:28:48.653 (3) [pool-48-thread-2]: TextAdChangeRequest (accountID 81702): Sending 3 delete requests 2014-06-10 08:28:48.654 (3) [pool-48-thread-3]: TextAdChangeRequest (accountID 81702): Sending 3 delete requests 2014-06-10 08:28:48.655 (3) [pool-48-thread-4]: TextAdChangeRequest (accountID 81702): Sending 3 delete requests 2014-06-10 08:28:48.655 (3) [pool-48-thread-5]: TextAdChangeRequest (accountID 81702): Sending 3 delete requests 2014-06-10 08:28:48.656 (3) [pool-48-thread-6]: TextAdChangeRequest (accountID 81702): Sending 3 delete requests 2014-06-10 08:28:48.656 (3) [pool-48-thread-7]: TextAdChangeRequest (accountID 81702): Sending 3 delete requests 2014-06-10 08:28:48.656 (3) [pool-48-thread-8]: TextAdChangeRequest (accountID 81702): Sending 3 delete requests 2014-06-10 08:28:49.284 (2) [pool-48-thread-1]: TrackingID: 94cf4d4a-8d4c-486c-8f67-18bc8a1f2215, Operation Error code[1120], Textual Error code[CampaignServiceInvalidCampaignStatus], msg[The campaign status is invalid for the current operation.], details[null] 2014-06-10 08:28:49.285 (1) [pool-48-thread-1]: Unrecoverable MSN API error (Invalid client data. Check the SOAP fault details for more information) 2014-06-10 08:28:49.296 (3) [pool-48-thread-1]: Exception [SEUser 85361 TextAdChangeRequest delete request: SQL error processing 3 pending delete(s)]:java.sql.BatchUpdateException: Cannot add or update a child row: a foreign key constraint fails (`content_editor_bing`.`bce_textAdError`, CONSTRAINT `bce_textAdError_ibfk_1` FOREIGN KEY (`textAdID`) REFERENCES `bce_textAd` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:665) at com.carldunham.jst.db.Database.commitBatch(Database.java:722) at com.thesearchagency.searchengines.bing.contenteditor.dao.BaseDAO.saveErrorsInsertErrorsHelper(BaseDAO.java:1101) at com.thesearchagency.searchengines.bing.contenteditor.dao.BaseDAO.saveErrors(BaseDAO.java:529) at com.thesearchagency.searchengines.bing.contenteditor.changerequest.BaseChangeRequest.saveErrors(BaseChangeRequest.java:347) at com.thesearchagency.searchengines.bing.contenteditor.changerequest.BaseChangeRequest.handleAPIError(BaseChangeRequest.java:212) at com.thesearchagency.searchengines.bing.contenteditor.changerequest.BaseChangeRequest.makeRequest(BaseChangeRequest.java:131) at com.thesearchagency.searchengines.bing.contenteditor.BingContentEditor$RequestWorker.call(BingContentEditor.java:1257) at com.thesearchagency.searchengines.bing.contenteditor.BingContentEditor$RequestWorker.call(BingContentEditor.java:1239) 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) 2014-06-10 08:28:49.296 (2) [pool-48-thread-1]: Bing Request Errors for accountID 81702(TextAdChangeRequest) id=-1, trackingID=94cf4d4a-8d4c-486c-8f67-18bc8a1f2215: , code=1120: , errorCode=CampaignServiceInvalidCampaignStatus: , message=The campaign status is invalid for the current operation.: 2014-06-10 08:28:49.406 (2) [pool-48-thread-4]: TrackingID: 25dc9303-fe98-4cbb-83b5-19da53785b0b, Operation Error code[1120], Textual Error code[CampaignServiceInvalidCampaignStatus], msg[The campaign status is invalid for the current operation.], details[null] 2014-06-10 08:28:49.406 (1) [pool-48-thread-4]: Unrecoverable MSN API error (Invalid client data. Check the SOAP fault details for more information) 2014-06-10 08:28:49.429 (3) [pool-48-thread-4]: Exception [SEUser 85361 TextAdChangeRequest delete request: SQL error processing 3 pending delete(s)]:java.sql.BatchUpdateException: Cannot add or update a child row: a foreign key constraint fails (`content_editor_bing`.`bce_textAdError`, CONSTRAINT `bce_textAdError_ibfk_1` FOREIGN KEY (`textAdID`) REFERENCES `bce_textAd` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:665) at com.carldunham.jst.db.Database.commitBatch(Database.java:722) at com.thesearchagency.searchengines.bing.contenteditor.dao.BaseDAO.saveErrorsInsertErrorsHelper(BaseDAO.java:1101) at com.thesearchagency.searchengines.bing.contenteditor.dao.BaseDAO.saveErrors(BaseDAO.java:529) at com.thesearchagency.searchengines.bing.contenteditor.changerequest.BaseChangeRequest.saveErrors(BaseChangeRequest.java:347) at com.thesearchagency.searchengines.bing.contenteditor.changerequest.BaseChangeRequest.handleAPIError(BaseChangeRequest.java:212) at com.thesearchagency.searchengines.bing.contenteditor.changerequest.BaseChangeRequest.makeRequest(BaseChangeRequest.java:131) at com.thesearchagency.searchengines.bing.contenteditor.BingContentEditor$RequestWorker.call(BingContentEditor.java:1257) at com.thesearchagency.searchengines.bing.contenteditor.BingContentEditor$RequestWorker.call(BingContentEditor.java:1239) 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) 2014-06-10 08:28:49.429 (2) [pool-48-thread-4]: Bing Request Errors for accountID 81702(TextAdChangeRequest) id=-1, trackingID=25dc9303-fe98-4cbb-83b5-19da53785b0b: , code=1120: , errorCode=CampaignServiceInvalidCampaignStatus: , message=The campaign status is invalid for the current operation.: 2014-06-10 08:28:49.432 (3) [pool-48-thread-5]: TextAdDAO (accountID 81702) DB deletes: 3 deleted 2014-06-10 08:28:49.946 (3) [pool-48-thread-6]: TextAdDAO (accountID 81702) DB deletes: 3 deleted 2014-06-10 08:28:50.125 (2) [pool-48-thread-8]: TrackingID: bc7ad6a9-e37e-47f5-98f4-1104c3d57093, Operation Error code[1120], Textual Error code[CampaignServiceInvalidCampaignStatus], msg[The campaign status is invalid for the current operation.], details[null] 2014-06-10 08:28:50.125 (1) [pool-48-thread-8]: Unrecoverable MSN API error (Invalid client data. Check the SOAP fault details for more information) 2014-06-10 08:28:50.129 (2) [pool-48-thread-7]: TrackingID: 50fc9ec0-4313-46c7-856d-7d13a0446ee9, Operation Error code[1120], Textual Error code[CampaignServiceInvalidCampaignStatus], msg[The campaign status is invalid for the current operation.], details[null] 2014-06-10 08:28:50.129 (1) [pool-48-thread-7]: Unrecoverable MSN API error (Invalid client data. Check the SOAP fault details for more information) 2014-06-10 08:28:50.136 (3) [pool-48-thread-8]: Exception [SEUser 85361 TextAdChangeRequest delete request: SQL error processing 3 pending delete(s)]:java.sql.BatchUpdateException: Cannot add or update a child row: a foreign key constraint fails (`content_editor_bing`.`bce_textAdError`, CONSTRAINT `bce_textAdError_ibfk_1` FOREIGN KEY (`textAdID`) REFERENCES `bce_textAd` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:665) at com.carldunham.jst.db.Database.commitBatch(Database.java:722) at com.thesearchagency.searchengines.bing.contenteditor.dao.BaseDAO.saveErrorsInsertErrorsHelper(BaseDAO.java:1101) at com.thesearchagency.searchengines.bing.contenteditor.dao.BaseDAO.saveErrors(BaseDAO.java:529) at com.thesearchagency.searchengines.bing.contenteditor.changerequest.BaseChangeRequest.saveErrors(BaseChangeRequest.java:347) at com.thesearchagency.searchengines.bing.contenteditor.changerequest.BaseChangeRequest.handleAPIError(BaseChangeRequest.java:212) at com.thesearchagency.searchengines.bing.contenteditor.changerequest.BaseChangeRequest.makeRequest(BaseChangeRequest.java:131) at com.thesearchagency.searchengines.bing.contenteditor.BingContentEditor$RequestWorker.call(BingContentEditor.java:1257) at com.thesearchagency.searchengines.bing.contenteditor.BingContentEditor$RequestWorker.call(BingContentEditor.java:1239) 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) 2014-06-10 08:28:50.136 (2) [pool-48-thread-8]: Bing Request Errors for accountID 81702(TextAdChangeRequest) id=-1, trackingID=bc7ad6a9-e37e-47f5-98f4-1104c3d57093: , code=1120: , errorCode=CampaignServiceInvalidCampaignStatus: , message=The campaign status is invalid for the current operation.: 2014-06-10 08:28:50.138 (3) [pool-48-thread-7]: Exception [SEUser 85361 TextAdChangeRequest delete request: SQL error processing 3 pending delete(s)]:java.sql.BatchUpdateException: Cannot add or update a child row: a foreign key constraint fails (`content_editor_bing`.`bce_textAdError`, CONSTRAINT `bce_textAdError_ibfk_1` FOREIGN KEY (`textAdID`) REFERENCES `bce_textAd` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:665) at com.carldunham.jst.db.Database.commitBatch(Database.java:722) at com.thesearchagency.searchengines.bing.contenteditor.dao.BaseDAO.saveErrorsInsertErrorsHelper(BaseDAO.java:1101) at com.thesearchagency.searchengines.bing.contenteditor.dao.BaseDAO.saveErrors(BaseDAO.java:529) at com.thesearchagency.searchengines.bing.contenteditor.changerequest.BaseChangeRequest.saveErrors(BaseChangeRequest.java:347) at com.thesearchagency.searchengines.bing.contenteditor.changerequest.BaseChangeRequest.handleAPIError(BaseChangeRequest.java:212) at com.thesearchagency.searchengines.bing.contenteditor.changerequest.BaseChangeRequest.makeRequest(BaseChangeRequest.java:131) at com.thesearchagency.searchengines.bing.contenteditor.BingContentEditor$RequestWorker.call(BingContentEditor.java:1257) at com.thesearchagency.searchengines.bing.contenteditor.BingContentEditor$RequestWorker.call(BingContentEditor.java:1239) 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) 2014-06-10 08:28:50.138 (2) [pool-48-thread-7]: Bing Request Errors for accountID 81702(TextAdChangeRequest) id=-1, trackingID=50fc9ec0-4313-46c7-856d-7d13a0446ee9: , code=1120: , errorCode=CampaignServiceInvalidCampaignStatus: , message=The campaign status is invalid for the current operation.: 2014-06-10 08:28:50.570 (2) [pool-48-thread-2]: TrackingID: 565a17a7-c0a3-49d4-843b-98a44787fdc4, Operation Error code[1120], Textual Error code[CampaignServiceInvalidCampaignStatus], msg[The campaign status is invalid for the current operation.], details[null] 2014-06-10 08:28:50.570 (1) [pool-48-thread-2]: Unrecoverable MSN API error (Invalid client data. Check the SOAP fault details for more information) 2014-06-10 08:28:50.577 (3) [pool-48-thread-2]: Exception [SEUser 85361 TextAdChangeRequest delete request: SQL error processing 3 pending delete(s)]:java.sql.BatchUpdateException: Cannot add or update a child row: a foreign key constraint fails (`content_editor_bing`.`bce_textAdError`, CONSTRAINT `bce_textAdError_ibfk_1` FOREIGN KEY (`textAdID`) REFERENCES `bce_textAd` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:665) at com.carldunham.jst.db.Database.commitBatch(Database.java:722) at com.thesearchagency.searchengines.bing.contenteditor.dao.BaseDAO.saveErrorsInsertErrorsHelper(BaseDAO.java:1101) at com.thesearchagency.searchengines.bing.contenteditor.dao.BaseDAO.saveErrors(BaseDAO.java:529) at com.thesearchagency.searchengines.bing.contenteditor.changerequest.BaseChangeRequest.saveErrors(BaseChangeRequest.java:347) at com.thesearchagency.searchengines.bing.contenteditor.changerequest.BaseChangeRequest.handleAPIError(BaseChangeRequest.java:212) at com.thesearchagency.searchengines.bing.contenteditor.changerequest.BaseChangeRequest.makeRequest(BaseChangeRequest.java:131) at com.thesearchagency.searchengines.bing.contenteditor.BingContentEditor$RequestWorker.call(BingContentEditor.java:1257) at com.thesearchagency.searchengines.bing.contenteditor.BingContentEditor$RequestWorker.call(BingContentEditor.java:1239) 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) 2014-06-10 08:28:50.577 (2) [pool-48-thread-2]: Bing Request Errors for accountID 81702(TextAdChangeRequest) id=-1, trackingID=565a17a7-c0a3-49d4-843b-98a44787fdc4: , code=1120: , errorCode=CampaignServiceInvalidCampaignStatus: , message=The campaign status is invalid for the current operation.: 2014-06-10 08:28:53.236 (2) [pool-48-thread-3]: TrackingID: 0b76b4d8-47fe-42c6-971e-a6122dc4ed60, Operation Error code[1120], Textual Error code[CampaignServiceInvalidCampaignStatus], msg[The campaign status is invalid for the current operation.], details[null] 2014-06-10 08:28:53.237 (1) [pool-48-thread-3]: Unrecoverable MSN API error (Invalid client data. Check the SOAP fault details for more information) 2014-06-10 08:28:53.251 (3) [pool-48-thread-3]: Exception [SEUser 85361 TextAdChangeRequest delete request: SQL error processing 3 pending delete(s)]:java.sql.BatchUpdateException: Cannot add or update a child row: a foreign key constraint fails (`content_editor_bing`.`bce_textAdError`, CONSTRAINT `bce_textAdError_ibfk_1` FOREIGN KEY (`textAdID`) REFERENCES `bce_textAd` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:665) at com.carldunham.jst.db.Database.commitBatch(Database.java:722) at com.thesearchagency.searchengines.bing.contenteditor.dao.BaseDAO.saveErrorsInsertErrorsHelper(BaseDAO.java:1101) at com.thesearchagency.searchengines.bing.contenteditor.dao.BaseDAO.saveErrors(BaseDAO.java:529) at com.thesearchagency.searchengines.bing.contenteditor.changerequest.BaseChangeRequest.saveErrors(BaseChangeRequest.java:347) at com.thesearchagency.searchengines.bing.contenteditor.changerequest.BaseChangeRequest.handleAPIError(BaseChangeRequest.java:212) at com.thesearchagency.searchengines.bing.contenteditor.changerequest.BaseChangeRequest.makeRequest(BaseChangeRequest.java:131) at com.thesearchagency.searchengines.bing.contenteditor.BingContentEditor$RequestWorker.call(BingContentEditor.java:1257) at com.thesearchagency.searchengines.bing.contenteditor.BingContentEditor$RequestWorker.call(BingContentEditor.java:1239) 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) 2014-06-10 08:28:53.252 (2) [pool-48-thread-3]: Bing Request Errors for accountID 81702(TextAdChangeRequest) id=-1, trackingID=0b76b4d8-47fe-42c6-971e-a6122dc4ed60: , code=1120: , errorCode=CampaignServiceInvalidCampaignStatus: , message=The campaign status is invalid for the current operation.: 2014-06-10 08:28:53.717 (3) [pool-48-thread-9]: TextAdChangeRequest (accountID 81702): Sending 6 add requests 2014-06-10 08:28:53.718 (3) [pool-48-thread-1]: TextAdChangeRequest (accountID 81702): Sending 6 add requests 2014-06-10 08:28:53.719 (3) [pool-48-thread-4]: TextAdChangeRequest (accountID 81702): Sending 6 add requests 2014-06-10 08:28:53.719 (3) [pool-48-thread-5]: TextAdChangeRequest (accountID 81702): Sending 3 add requests 2014-06-10 08:28:53.719 (3) [pool-48-thread-6]: TextAdChangeRequest (accountID 81702): Sending 3 add requests 2014-06-10 08:28:53.720 (3) [pool-48-thread-8]: TextAdChangeRequest (accountID 81702): Sending 6 add requests 2014-06-10 08:28:53.720 (3) [pool-48-thread-7]: TextAdChangeRequest (accountID 81702): Sending 6 add requests 2014-06-10 08:28:53.721 (3) [pool-48-thread-10]: TextAdChangeRequest (accountID 81702): Sending 6 add requests 2014-06-10 08:28:54.420 (3) [pool-48-thread-6]: TextAdDAO(accountID 81702) Request contained 3 adds, 0 updates, 0 deletes. 2014-06-10 08:28:54.420 (3) [pool-48-thread-6]: TextAdDAO(accountID 81702) DB updates: 3 items updated, 3 pending changes deleted, 0 pending updates deleted, 0 errors cleared 2014-06-10 08:28:54.426 (2) [pool-48-thread-9]: TrackingID: 320b9dc3-3884-491c-8f49-383ff9beb38c, Operation Error code[1120], Textual Error code[CampaignServiceInvalidCampaignStatus], msg[The campaign status is invalid for the current operation.], details[null] 2014-06-10 08:28:54.426 (1) [pool-48-thread-9]: Unrecoverable MSN API error (Invalid client data. Check the SOAP fault details for more information) 2014-06-10 08:28:54.429 (3) [pool-48-thread-9]: TextAdChangeRequest (accountID 81702): Errors recorded, no more changes to process 2014-06-10 08:28:54.429 (2) [pool-48-thread-9]: TextAdDAO: database is null 2014-06-10 08:28:54.430 (2) [pool-48-thread-9]: TextAdChangeRequest released connection to pool (legacy - theDAO does not have a pool to release the connection to) 2014-06-10 08:28:54.563 (3) [pool-48-thread-5]: TextAdDAO(accountID 81702) Request contained 3 adds, 0 updates, 0 deletes. 2014-06-10 08:28:54.563 (3) [pool-48-thread-5]: TextAdDAO(accountID 81702) DB updates: 3 items updated, 3 pending changes deleted, 0 pending updates deleted, 0 errors cleared 2014-06-10 08:28:55.043 (2) [pool-48-thread-8]: TrackingID: 35b5874f-39c5-4bec-bbc1-6d56544b7252, Operation Error code[1120], Textual Error code[CampaignServiceInvalidCampaignStatus], msg[The campaign status is invalid for the current operation.], details[null] 2014-06-10 08:28:55.044 (1) [pool-48-thread-8]: Unrecoverable MSN API error (Invalid client data. Check the SOAP fault details for more information) 2014-06-10 08:28:55.054 (2) [pool-48-thread-7]: TrackingID: 28f26a08-fac4-4a59-a9c1-8e3a0e4b052e, Operation Error code[1120], Textual Error code[CampaignServiceInvalidCampaignStatus], msg[The campaign status is invalid for the current operation.], details[null] 2014-06-10 08:28:55.054 (1) [pool-48-thread-7]: Unrecoverable MSN API error (Invalid client data. Check the SOAP fault details for more information) 2014-06-10 08:28:55.095 (3) [pool-48-thread-8]: TextAdChangeRequest (accountID 81702): Errors recorded, no more changes to process 2014-06-10 08:28:55.095 (2) [pool-48-thread-8]: TextAdDAO: database is null 2014-06-10 08:28:55.096 (2) [pool-48-thread-8]: TextAdChangeRequest released connection to pool (legacy - theDAO does not have a pool to release the connection to) 2014-06-10 08:28:55.097 (3) [pool-48-thread-7]: TextAdChangeRequest (accountID 81702): Errors recorded, no more changes to process 2014-06-10 08:28:55.097 (2) [pool-48-thread-7]: TextAdDAO: database is null 2014-06-10 08:28:55.098 (2) [pool-48-thread-7]: TextAdChangeRequest released connection to pool (legacy - theDAO does not have a pool to release the connection to) 2014-06-10 08:28:55.183 (2) [pool-48-thread-10]: TrackingID: eed104e9-e633-4e87-bb76-d3f214d3a59d, Operation Error code[1120], Textual Error code[CampaignServiceInvalidCampaignStatus], msg[The campaign status is invalid for the current operation.], details[null] 2014-06-10 08:28:55.183 (1) [pool-48-thread-10]: Unrecoverable MSN API error (Invalid client data. Check the SOAP fault details for more information) 2014-06-10 08:28:55.198 (3) [pool-48-thread-10]: TextAdChangeRequest (accountID 81702): Errors recorded, no more changes to process 2014-06-10 08:28:55.198 (2) [pool-48-thread-10]: TextAdDAO: database is null 2014-06-10 08:28:55.199 (2) [pool-48-thread-10]: TextAdChangeRequest released connection to pool (legacy - theDAO does not have a pool to release the connection to) 2014-06-10 08:28:56.228 (2) [pool-48-thread-4]: TrackingID: b047d927-6a27-40ba-a0cc-f337330175ea, Operation Error code[1120], Textual Error code[CampaignServiceInvalidCampaignStatus], msg[The campaign status is invalid for the current operation.], details[null] 2014-06-10 08:28:56.228 (1) [pool-48-thread-4]: Unrecoverable MSN API error (Invalid client data. Check the SOAP fault details for more information) 2014-06-10 08:28:56.230 (3) [pool-48-thread-4]: TextAdChangeRequest (accountID 81702): Errors recorded, no more changes to process 2014-06-10 08:28:56.231 (2) [pool-48-thread-4]: TextAdDAO: database is null 2014-06-10 08:28:56.231 (2) [pool-48-thread-4]: TextAdChangeRequest released connection to pool (legacy - theDAO does not have a pool to release the connection to) 2014-06-10 08:28:57.005 (2) [pool-48-thread-1]: TrackingID: ac603013-867f-447e-8a11-fe3050f200c5, Operation Error code[1120], Textual Error code[CampaignServiceInvalidCampaignStatus], msg[The campaign status is invalid for the current operation.], details[null] 2014-06-10 08:28:57.005 (1) [pool-48-thread-1]: Unrecoverable MSN API error (Invalid client data. Check the SOAP fault details for more information) 2014-06-10 08:28:57.008 (3) [pool-48-thread-1]: TextAdChangeRequest (accountID 81702): Errors recorded, no more changes to process 2014-06-10 08:28:57.008 (2) [pool-48-thread-1]: TextAdDAO: database is null 2014-06-10 08:28:57.009 (2) [pool-48-thread-1]: TextAdChangeRequest released connection to pool (legacy - theDAO does not have a pool to release the connection to) 2014-06-10 08:28:59.361 (3) [pool-3-thread-4]: ------------Bing Content Editor done 2014-06-10 08:28:59.361 (3) [pool-3-thread-4]: =============== Completed Bing Content Editor ================ 2014-06-10 08:28:59.363 (3) [pool-3-thread-4]: BNV9UP25_1000000024_736_BNV9UP25-3_GM had an updated campaign structure. Scheduled SE groups and listings update. 2014-06-10 08:28:59.363 (3) [pool-3-thread-4]: BNV9UP25_1000000024_736_BNV9UP25-4_GM had an updated campaign structure. Scheduled SE groups and listings update. 2014-06-10 08:28:59.364 (3) [pool-3-thread-4]: BNV9UP25_1000000024_736_BNV9UP25-5_GM had an updated campaign structure. Scheduled SE groups and listings update. 2014-06-10 08:28:59.365 (3) [pool-3-thread-4]: BNV9UP25_1000000024_736_BNV9UP25-2_GM had an updated campaign structure. Scheduled SE groups and listings update. 2014-06-10 08:28:59.366 (3) [pool-3-thread-4]: BNV9UP25_1000000024_736_BNV9UP25-4_GT had an updated campaign structure. Scheduled SE groups and listings update. 2014-06-10 08:28:59.367 (3) [pool-3-thread-4]: BNV9UP25_1000000024_736_BNV9UP25-3_GT had an updated campaign structure. Scheduled SE groups and listings update. 2014-06-10 08:28:59.368 (3) [pool-3-thread-4]: BNV9UP25_1000000024_736_BNV9UP25-2_GT had an updated campaign structure. Scheduled SE groups and listings update. 2014-06-10 08:28:59.369 (3) [pool-3-thread-4]: BNV9UP25_1000000024_736_BNV9UP25-5_GT had an updated campaign structure. Scheduled SE groups and listings update. 2014-06-10 08:28:59.369 (3) [pool-3-thread-4]: BNV9UP25_1000000024_736_BNV9UP25-4_GT had an updated campaign structure. Scheduled SE groups and listings update. 2014-06-10 08:28:59.370 (3) [pool-3-thread-4]: BNV9UP25_1000000024_736_BNV9UP25-4_GM had an updated campaign structure. Scheduled SE groups and listings update. 2014-06-10 08:28:59.370 (3) [pool-3-thread-4]: GOOGLE Account Worker has 0 campaign(s) to update. 2014-06-10 08:28:59.370 (3) [pool-3-thread-4]: GOOGLE Account Worker has 0 campaign(s) to create. 2014-06-10 08:28:59.370 (3) [pool-3-thread-4]: GOOGLE Account Worker has 0 campaign(s) to retry and update. 2014-06-10 08:28:59.375 (3) [pool-3-thread-4]: BNV9UP25-3_GM has no applicable BCE errors. 2014-06-10 08:28:59.381 (3) [pool-3-thread-4]: BNV9UP25-4_GM has no applicable BCE errors. 2014-06-10 08:28:59.386 (3) [pool-3-thread-4]: BING Account Worker - Ignoring 0 other operation errors for deleted campaign. 2014-06-10 08:28:59.386 (3) [pool-3-thread-4]: BNV9UP25-5_GM has no applicable BCE errors. 2014-06-10 08:28:59.392 (3) [pool-3-thread-4]: BNV9UP25-2_GM has no applicable BCE errors. 2014-06-10 08:28:59.397 (3) [pool-3-thread-4]: BNV9UP25-1_GT has no applicable BCE errors. 2014-06-10 08:28:59.404 (3) [pool-3-thread-4]: BNV9UP25-4_GT has no applicable BCE errors. 2014-06-10 08:28:59.414 (3) [pool-3-thread-4]: BNV9UP25-3_GT has no applicable BCE errors. 2014-06-10 08:28:59.419 (3) [pool-3-thread-4]: BING Account Worker - Ignoring 0 other operation errors for deleted campaign. 2014-06-10 08:28:59.420 (3) [pool-3-thread-4]: BNV9UP25-5_GT has no applicable BCE errors. 2014-06-10 08:28:59.427 (3) [pool-3-thread-4]: BNV9UP25-2_GT has no applicable BCE errors. 2014-06-10 08:28:59.432 (3) [pool-3-thread-4]: BNV9UP25-1_GM has no applicable BCE errors. 2014-06-10 08:28:59.436 (3) [pool-3-thread-4]: No se budget update needed 2014-06-10 08:28:59.436 (3) [pool-3-thread-4]: Updating Admax bid for BNV9UP25_1000000024_736_BNV9UP25-1_GT Bid: 0.16129032 2014-06-10 08:28:59.438 (1) [pool-3-thread-4]: Exiting insertOrUpdateBid method with return value: 2 2014-06-10 08:28:59.439 (3) [pool-3-thread-4]: No se budget update needed 2014-06-10 08:28:59.439 (3) [pool-3-thread-4]: Updating Admax bid for BNV9UP25_1000000024_736_BNV9UP25-1_GM Bid: 0.16129032 2014-06-10 08:28:59.439 (1) [pool-3-thread-4]: Exiting insertOrUpdateBid method with return value: 2 2014-06-10 08:28:59.441 (3) [pool-3-thread-4]: No se budget update needed 2014-06-10 08:28:59.441 (3) [pool-3-thread-4]: Updating Admax bid for BNV9UP25_1000000024_736_BNV9UP25-2_GT Bid: 0.16129032 2014-06-10 08:28:59.442 (1) [pool-3-thread-4]: Exiting insertOrUpdateBid method with return value: 2 2014-06-10 08:28:59.443 (3) [pool-3-thread-4]: No se budget update needed 2014-06-10 08:28:59.443 (3) [pool-3-thread-4]: Updating Admax bid for BNV9UP25_1000000024_736_BNV9UP25-2_GM Bid: 0.16129032 2014-06-10 08:28:59.443 (1) [pool-3-thread-4]: Exiting insertOrUpdateBid method with return value: 2 2014-06-10 08:28:59.444 (3) [pool-3-thread-4]: No se budget update needed 2014-06-10 08:28:59.444 (3) [pool-3-thread-4]: Updating Admax bid for BNV9UP25_1000000024_736_BNV9UP25-3_GT Bid: 0.16129032 2014-06-10 08:28:59.445 (1) [pool-3-thread-4]: Exiting insertOrUpdateBid method with return value: 2 2014-06-10 08:28:59.446 (3) [pool-3-thread-4]: No se budget update needed 2014-06-10 08:28:59.446 (3) [pool-3-thread-4]: Updating Admax bid for BNV9UP25_1000000024_736_BNV9UP25-3_GM Bid: 0.16129032 2014-06-10 08:28:59.447 (1) [pool-3-thread-4]: Exiting insertOrUpdateBid method with return value: 2 2014-06-10 08:28:59.448 (3) [pool-3-thread-4]: No se budget update needed 2014-06-10 08:28:59.448 (3) [pool-3-thread-4]: Updating Admax bid for BNV9UP25_1000000024_736_BNV9UP25-4_GT Bid: 0.16129032 2014-06-10 08:28:59.448 (1) [pool-3-thread-4]: Exiting insertOrUpdateBid method with return value: 2 2014-06-10 08:28:59.450 (3) [pool-3-thread-4]: No se budget update needed 2014-06-10 08:28:59.450 (3) [pool-3-thread-4]: Updating Admax bid for BNV9UP25_1000000024_736_BNV9UP25-4_GM Bid: 0.16129032 2014-06-10 08:28:59.464 (1) [pool-3-thread-4]: Exiting insertOrUpdateBid method with return value: 2 2014-06-10 08:28:59.476 (3) [pool-3-thread-4]: No se budget update needed 2014-06-10 08:28:59.476 (3) [pool-3-thread-4]: Updating Admax bid for BNV9UP25_1000000024_736_BNV9UP25-5_GT Bid: 0.16129032 2014-06-10 08:28:59.477 (1) [pool-3-thread-4]: Exiting insertOrUpdateBid method with return value: 2 2014-06-10 08:28:59.478 (3) [pool-3-thread-4]: No se budget update needed 2014-06-10 08:28:59.478 (3) [pool-3-thread-4]: Updating Admax bid for BNV9UP25_1000000024_736_BNV9UP25-5_GM Bid: 0.16129032 2014-06-10 08:28:59.479 (1) [pool-3-thread-4]: Exiting insertOrUpdateBid method with return value: 2 2014-06-10 08:28:59.479 (3) [pool-3-thread-4]: BING - BNV9UP25 has 0 campaigns for a SE Update accounts sync. 2014-06-10 08:28:59.479 (3) [pool-3-thread-4]: BING - BNV9UP25 has 0 campaigns for a SE Update groups-listings sync. 2014-06-10 08:28:59.479 (3) [pool-3-thread-4]: BNV9UP25 has 0 campaigns for a SE Update accounts sync. 2014-06-10 08:28:59.479 (3) [pool-3-thread-4]: BNV9UP25 has 0 campaigns for a SE Update groups-listings sync. 2014-06-10 08:28:59.479 (3) [pool-3-thread-4]: 0 Scheduled Job Items to save for BNV9UP25. 2014-06-10 08:28:59.479 (3) [pool-3-thread-4]: Finished sub-campaign processing for DEPLOY deploymentID (BNV9UP25). account BNV9UP25. 10 submitted, 10 ok. 2014-06-10 08:28:59.479 (3) [pool-3-thread-4]: Finished DEPLOY request for BNV9UP25_1000000024_736_BNV9UP25-1: SUCCEDED 2014-06-10 08:28:59.479 (3) [pool-3-thread-4]: Finished DEPLOY request for BNV9UP25_1000000024_736_BNV9UP25-2: SUCCEDED 2014-06-10 08:28:59.479 (3) [pool-3-thread-4]: Finished DEPLOY request for BNV9UP25_1000000024_736_BNV9UP25-3: SUCCEDED 2014-06-10 08:28:59.479 (3) [pool-3-thread-4]: Finished DEPLOY request for BNV9UP25_1000000024_736_BNV9UP25-4: SUCCEDED 2014-06-10 08:28:59.480 (3) [pool-3-thread-4]: Finished DEPLOY request for BNV9UP25_1000000024_736_BNV9UP25-5: SUCCEDED 2014-06-10 08:28:59.480 (3) [pool-3-thread-4]: Finished DEPLOY request, deploymentID (BNV9UP25), account BNV9UP25 2014-06-10 08:29:04.236 (3) [pool-4-thread-1]: YELL_VM_JBOSS1--/queue/AdMaxResponseQueue-Responder responded back successfully 2014-06-10 08:29:10.110 (3) [pool-1-thread-1]: =======================YELL_VM_JBOSS1--/queue/AdMaxDeployRequestQueue Processor======================= /queue/AdMaxDeployRequestQueue-Receptor:ACTIVE:4 /queue/AdMaxDeployRequestQueue-Responder:ACTIVE:4 =======================YELL_VM_JBOSS1--/queue/AdMaxDeployRequestQueue Processor======================= 2014-06-10 08:29:10.110 (3) [pool-1-thread-1]: =======================YELL_VM_JBOSS1--/queue/AdMaxUpdateRequestQueue Processor======================= /queue/AdMaxUpdateRequestQueue-Receptor:ACTIVE:0 /queue/AdMaxUpdateRequestQueue-Responder:ACTIVE:0 =======================YELL_VM_JBOSS1--/queue/AdMaxUpdateRequestQueue Processor======================= 2014-06-10 08:29:30.002 (3) [pool-1-thread-1]: =======================YELL_VM_JBOSS1--/queue/AdMaxDeployRequestQueue Processor======================= /queue/AdMaxDeployRequestQueue-Receptor:ACTIVE:6 /queue/AdMaxDeployRequestQueue-Responder:ACTIVE:6 =======================YELL_VM_JBOSS1--/queue/AdMaxDeployRequestQueue Processor======================= 2014-06-10 08:29:30.002 (3) [pool-1-thread-1]: =======================YELL_VM_JBOSS1--/queue/AdMaxUpdateRequestQueue Processor======================= /queue/AdMaxUpdateRequestQueue-Receptor:ACTIVE:0 /queue/AdMaxUpdateRequestQueue-Responder:ACTIVE:0 =======================YELL_VM_JBOSS1--/queue/AdMaxUpdateRequestQueue Processor======================= 2014-06-10 08:31:10.115 (3) [pool-1-thread-1]: =======================YELL_VM_JBOSS1--/queue/AdMaxDeployRequestQueue Processor======================= /queue/AdMaxDeployRequestQueue-Receptor:ACTIVE:4 /queue/AdMaxDeployRequestQueue-Responder:ACTIVE:4 =======================YELL_VM_JBOSS1--/queue/AdMaxDeployRequestQueue Processor======================= 2014-06-10 08:31:10.115 (3) [pool-1-thread-1]: =======================YELL_VM_JBOSS1--/queue/AdMaxUpdateRequestQueue Processor======================= /queue/AdMaxUpdateRequestQueue-Receptor:ACTIVE:0 /queue/AdMaxUpdateRequestQueue-Responder:ACTIVE:0 =======================YELL_VM_JBOSS1--/queue/AdMaxUpdateRequestQueue Processor======================= 2014-06-10 08:31:30.007 (3) [pool-1-thread-1]: =======================YELL_VM_JBOSS1--/queue/AdMaxDeployRequestQueue Processor======================= /queue/AdMaxDeployRequestQueue-Receptor:ACTIVE:6 /queue/AdMaxDeployRequestQueue-Responder:ACTIVE:6 =======================YELL_VM_JBOSS1--/queue/AdMaxDeployRequestQueue Processor======================= 2014-06-10 08:31:30.007 (3) [pool-1-thread-1]: =======================YELL_VM_JBOSS1--/queue/AdMaxUpdateRequestQueue Processor======================= /queue/AdMaxUpdateRequestQueue-Receptor:ACTIVE:0 /queue/AdMaxUpdateRequestQueue-Responder:ACTIVE:0 =======================YELL_VM_JBOSS1--/queue/AdMaxUpdateRequestQueue Processor======================= 2014-06-10 08:32:41.936 (3) [Thread-109]: YELL_VM_JBOSS1--/queue/AdMaxDeployRequestQueue-Receptor queued BPID - BNV9UP25 for processing 2014-06-10 08:32:41.970 (3) [pool-5-thread-7]: Updating account tables for BNV9UP25 2014-06-10 08:32:41.986 (3) [pool-5-thread-7]: Committing Account settings for 81702 2014-06-10 08:32:41.992 (3) [pool-5-thread-7]: Using enhanced campaigns for account BNV9UP25 2014-06-10 08:32:41.996 (3) [pool-5-thread-7]: Updating advert budget for BNV9UP25_1000000024_736_BNV9UP25-1 2014-06-10 08:32:41.998 (3) [pool-5-thread-7]: Nominal monthly budget was unchanged for AdMax campaign ID: 5042 2014-06-10 08:32:42.001 (3) [pool-5-thread-7]: Updating advert budget for BNV9UP25_1000000024_736_BNV9UP25-2 2014-06-10 08:32:42.003 (3) [pool-5-thread-7]: Nominal monthly budget was unchanged for AdMax campaign ID: 5043 2014-06-10 08:32:42.007 (3) [pool-5-thread-7]: Updating advert budget for BNV9UP25_1000000024_736_BNV9UP25-3 2014-06-10 08:32:42.008 (3) [pool-5-thread-7]: Nominal monthly budget was unchanged for AdMax campaign ID: 5044 2014-06-10 08:32:42.012 (3) [pool-5-thread-7]: Updating advert budget for BNV9UP25_1000000024_736_BNV9UP25-4 2014-06-10 08:32:42.014 (3) [pool-5-thread-7]: Nominal monthly budget was unchanged for AdMax campaign ID: 5045 2014-06-10 08:32:42.018 (3) [pool-5-thread-7]: Terminating advert budget for BNV9UP25_1000000024_736_BNV9UP25-5 2014-06-10 08:32:42.019 (3) [pool-5-thread-7]: No active budget exists for AdMax campaign ID: 5046 2014-06-10 08:32:42.019 (3) [pool-5-thread-7]: Debug Level set to 3 2014-06-10 08:32:42.020 (3) [pool-5-thread-7]: Debug Level set to 3 2014-06-10 08:32:42.082 (3) [pool-5-thread-7]: Start processing DEPLOY request (BNV9UP25) for account BNV9UP25. 10 campaign(s). 2014-06-10 08:32:42.082 (3) [pool-5-thread-7]: Performing sync for account: BNV9UP25 ID#81702 2014-06-10 08:32:42.200 (3) [pool-5-thread-7]: BING Account Worker has 10 campaign(s) to update. 2014-06-10 08:32:42.200 (3) [pool-5-thread-7]: BING Account Worker has 0 campaign(s) to create. 2014-06-10 08:32:42.200 (3) [pool-5-thread-7]: BING Account Worker has 0 campaign(s) to retry and update. 2014-06-10 08:32:42.201 (3) [pool-5-thread-7]: CampaignWorker initialized for account: 81702 2014-06-10 08:32:42.201 (3) [pool-5-thread-7]: Updating BNV9UP25_1000000024_736_BNV9UP25-1_GT Status: Paused 2014-06-10 08:32:42.201 (3) [pool-5-thread-7]: Updating BNV9UP25_1000000024_736_BNV9UP25-1_GM Status: Paused 2014-06-10 08:32:42.201 (3) [pool-5-thread-7]: Updating BNV9UP25_1000000024_736_BNV9UP25-2_GT Status: Active 2014-06-10 08:32:42.201 (3) [pool-5-thread-7]: Updating BNV9UP25_1000000024_736_BNV9UP25-2_GM Status: Active 2014-06-10 08:32:42.201 (3) [pool-5-thread-7]: Updating BNV9UP25_1000000024_736_BNV9UP25-3_GT Status: Active 2014-06-10 08:32:42.201 (3) [pool-5-thread-7]: Updating BNV9UP25_1000000024_736_BNV9UP25-3_GM Status: Active 2014-06-10 08:32:42.201 (3) [pool-5-thread-7]: Updating BNV9UP25_1000000024_736_BNV9UP25-4_GT Status: Paused 2014-06-10 08:32:42.201 (3) [pool-5-thread-7]: Updating BNV9UP25_1000000024_736_BNV9UP25-4_GM Status: Paused 2014-06-10 08:32:42.201 (3) [pool-5-thread-7]: Updating BNV9UP25_1000000024_736_BNV9UP25-5_GT Status: Deleted 2014-06-10 08:32:42.201 (3) [pool-5-thread-7]: Updating BNV9UP25_1000000024_736_BNV9UP25-5_GM Status: Deleted 2014-06-10 08:32:42.201 (3) [pool-5-thread-7]: BingCampaignUpdateWorker started... 2014-06-10 08:32:42.201 (3) [pool-5-thread-7]: Clearing bce_textAdPendingChanges for campaigns: [1807, 1808, 1809, 1810, 1811, 1812, 1813, 1814, 1815, 1816] 2014-06-10 08:33:10.120 (3) [pool-1-thread-1]: =======================YELL_VM_JBOSS1--/queue/AdMaxDeployRequestQueue Processor======================= /queue/AdMaxDeployRequestQueue-Receptor:ACTIVE:4 /queue/AdMaxDeployRequestQueue-Responder:ACTIVE:4 =======================YELL_VM_JBOSS1--/queue/AdMaxDeployRequestQueue Processor======================= 2014-06-10 08:33:10.120 (3) [pool-1-thread-1]: =======================YELL_VM_JBOSS1--/queue/AdMaxUpdateRequestQueue Processor======================= /queue/AdMaxUpdateRequestQueue-Receptor:ACTIVE:0 /queue/AdMaxUpdateRequestQueue-Responder:ACTIVE:0 =======================YELL_VM_JBOSS1--/queue/AdMaxUpdateRequestQueue Processor======================= 2014-06-10 08:33:30.012 (3) [pool-1-thread-1]: =======================YELL_VM_JBOSS1--/queue/AdMaxDeployRequestQueue Processor======================= /queue/AdMaxDeployRequestQueue-Receptor:ACTIVE:7 /queue/AdMaxDeployRequestQueue-Responder:ACTIVE:6 =======================YELL_VM_JBOSS1--/queue/AdMaxDeployRequestQueue Processor======================= 2014-06-10 08:33:30.012 (3) [pool-1-thread-1]: =======================YELL_VM_JBOSS1--/queue/AdMaxUpdateRequestQueue Processor======================= /queue/AdMaxUpdateRequestQueue-Receptor:ACTIVE:0 /queue/AdMaxUpdateRequestQueue-Responder:ACTIVE:0 =======================YELL_VM_JBOSS1--/queue/AdMaxUpdateRequestQueue Processor======================= 2014-06-10 08:33:33.466 (1) [pool-5-thread-7]: Exception [Error while deleting entries at bce_textAdPendingChanges for campaigns: [1807, 1808, 1809, 1810, 1811, 1812, 1813, 1814, 1815, 1816] .This will be ignored]:java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction 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.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1169) at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:693) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1404) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1318) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1303) at com.thesearchagency.searchengines.bing.contenteditor.dao.ad.textad.TextAdDAO.clearTextAdPendingChanges(TextAdDAO.java:563) at com.thesearchagency.admaxlistener.worker.BingCampaignUpdateWorker.getChangeInfos(BingCampaignUpdateWorker.java:139) at com.thesearchagency.admaxlistener.worker.BingCampaignUpdateWorker.call(BingCampaignUpdateWorker.java:74) 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) 2014-06-10 08:33:33.467 (3) [pool-5-thread-7]: Clearing bce_keywordPendingChanges for campaigns: [1807, 1808, 1809, 1810, 1811, 1812, 1813, 1814, 1815, 1816] 2014-06-10 08:33:33.488 (3) [pool-5-thread-7]: Cleared 0 keywords from bce_keywordPendingChanges 2014-06-10 08:33:33.528 (3) [pool-5-thread-7]: BNV9UP25_1000000024_736_BNV9UP25-1_GT is already set to Paused in the database. 2014-06-10 08:33:33.528 (3) [pool-5-thread-7]: BNV9UP25_1000000024_736_BNV9UP25-1_GT target sync: 2014-06-10 08:33:33.528 (3) [pool-5-thread-7]: Proximity Target unchanged proximity_56.24106216430664,-0.19067199528217316 TEN (miles) 2014-06-10 08:33:33.529 (3) [pool-5-thread-7]: BNV9UP25_1000000024_736_BNV9UP25-1_GT has no updated targets. 2014-06-10 08:33:33.529 (3) [pool-5-thread-7]: BNV9UP25_1000000024_736_BNV9UP25-1_GM is already set to Paused in the database. 2014-06-10 08:33:33.529 (3) [pool-5-thread-7]: BNV9UP25_1000000024_736_BNV9UP25-1_GM target sync: 2014-06-10 08:33:33.529 (3) [pool-5-thread-7]: BNV9UP25_1000000024_736_BNV9UP25-1_GM has no updated targets. 2014-06-10 08:33:33.529 (3) [pool-5-thread-7]: BNV9UP25_1000000024_736_BNV9UP25-2_GT is already set to Active in the database. 2014-06-10 08:33:33.529 (3) [pool-5-thread-7]: BNV9UP25_1000000024_736_BNV9UP25-2_GT target sync: 2014-06-10 08:33:33.529 (3) [pool-5-thread-7]: Proximity Target unchanged proximity_56.24106216430664,-0.19067199528217316 TEN (miles) 2014-06-10 08:33:33.529 (3) [pool-5-thread-7]: BNV9UP25_1000000024_736_BNV9UP25-2_GT has no updated targets. 2014-06-10 08:33:33.529 (3) [pool-5-thread-7]: BNV9UP25_1000000024_736_BNV9UP25-2_GM is already set to Active in the database. 2014-06-10 08:33:33.529 (3) [pool-5-thread-7]: BNV9UP25_1000000024_736_BNV9UP25-2_GM target sync: 2014-06-10 08:33:33.529 (3) [pool-5-thread-7]: BNV9UP25_1000000024_736_BNV9UP25-2_GM has no updated targets. 2014-06-10 08:33:33.529 (3) [pool-5-thread-7]: BNV9UP25_1000000024_736_BNV9UP25-3_GT is already set to Active in the database. 2014-06-10 08:33:33.529 (3) [pool-5-thread-7]: BNV9UP25_1000000024_736_BNV9UP25-3_GT target sync: 2014-06-10 08:33:33.529 (3) [pool-5-thread-7]: Proximity Target unchanged proximity_56.24106216430664,-0.19067199528217316 TEN (miles) 2014-06-10 08:33:33.529 (3) [pool-5-thread-7]: BNV9UP25_1000000024_736_BNV9UP25-3_GT has no updated targets. 2014-06-10 08:33:33.530 (3) [pool-5-thread-7]: BNV9UP25_1000000024_736_BNV9UP25-3_GM is already set to Active in the database. 2014-06-10 08:33:33.530 (3) [pool-5-thread-7]: BNV9UP25_1000000024_736_BNV9UP25-3_GM target sync: 2014-06-10 08:33:33.530 (3) [pool-5-thread-7]: BNV9UP25_1000000024_736_BNV9UP25-3_GM has no updated targets. 2014-06-10 08:33:33.530 (3) [pool-5-thread-7]: BNV9UP25_1000000024_736_BNV9UP25-4_GT is already set to Paused in the database. 2014-06-10 08:33:33.530 (3) [pool-5-thread-7]: BNV9UP25_1000000024_736_BNV9UP25-4_GT target sync: 2014-06-10 08:33:33.530 (3) [pool-5-thread-7]: Proximity Target unchanged proximity_56.24106216430664,-0.19067199528217316 TEN (miles) 2014-06-10 08:33:33.530 (3) [pool-5-thread-7]: BNV9UP25_1000000024_736_BNV9UP25-4_GT has no updated targets. 2014-06-10 08:33:33.530 (3) [pool-5-thread-7]: BNV9UP25_1000000024_736_BNV9UP25-4_GM is already set to Paused in the database. 2014-06-10 08:33:33.530 (3) [pool-5-thread-7]: BNV9UP25_1000000024_736_BNV9UP25-4_GM target sync: 2014-06-10 08:33:33.530 (3) [pool-5-thread-7]: BNV9UP25_1000000024_736_BNV9UP25-4_GM has no updated targets. 2014-06-10 08:33:33.530 (3) [pool-5-thread-7]: BNV9UP25_1000000024_736_BNV9UP25-5_GT status change (Active->Deleted) 2014-06-10 08:33:33.530 (3) [pool-5-thread-7]: Campaign deleted, skipping target sync. 2014-06-10 08:33:33.530 (3) [pool-5-thread-7]: BNV9UP25_1000000024_736_BNV9UP25-5_GM status change (Active->Deleted) 2014-06-10 08:33:33.530 (3) [pool-5-thread-7]: Campaign deleted, skipping target sync. 2014-06-10 08:33:33.537 (3) [pool-5-thread-7]: ----------------Bing Content Editor starting 2014-06-10 08:33:33.593 (3) [P16T1]: CampaignChangeRequest (accountID 81702): Sending 2 update requests 2014-06-10 08:33:34.329 (2) [P16T1]: TrackingID: 00622219-cef7-49bb-ab38-4faedd36d70e, Batch Error at item 0, code[1120], Textual Error code[CampaignServiceInvalidCampaignStatus], msg[The campaign status is invalid for the current operation.], details[null] 2014-06-10 08:33:34.329 (2) [P16T1]: TrackingID: 00622219-cef7-49bb-ab38-4faedd36d70e, Batch Error at item 1, code[1120], Textual Error code[CampaignServiceInvalidCampaignStatus], msg[The campaign status is invalid for the current operation.], details[null] 2014-06-10 08:33:34.329 (1) [P16T1]: Unrecoverable MSN API error (Invalid client data. Check the SOAP fault details for more information) 2014-06-10 08:33:34.340 (3) [P16T1]: CampaignDAO(accountID 81702): Inserted 2 Errors: Updated 2 pending changes, cleared 0 existing errors. 2014-06-10 08:33:34.383 (2) [P16T1]: Bing Request Errors for accountID 81702(CampaignChangeRequest) id=1815, trackingID=00622219-cef7-49bb-ab38-4faedd36d70e: , code=1120: , errorCode=CampaignServiceInvalidCampaignStatus: , message=The campaign status is invalid for the current operation.: id=1816, trackingID=00622219-cef7-49bb-ab38-4faedd36d70e: , code=1120: , errorCode=CampaignServiceInvalidCampaignStatus: , message=The campaign status is invalid for the current operation.: 2014-06-10 08:33:34.450 (3) [pool-58-thread-1]: TextAdChangeRequest (accountID 81702): Sending 3 delete requests 2014-06-10 08:33:34.451 (3) [pool-58-thread-2]: TextAdChangeRequest (accountID 81702): Sending 3 delete requests 2014-06-10 08:33:34.893 (2) [pool-58-thread-2]: TrackingID: 5350f629-47f3-46b9-bef0-fcc86580be52, Operation Error code[1120], Textual Error code[CampaignServiceInvalidCampaignStatus], msg[The campaign status is invalid for the current operation.], details[null] 2014-06-10 08:33:34.894 (1) [pool-58-thread-2]: Unrecoverable MSN API error (Invalid client data. Check the SOAP fault details for more information) 2014-06-10 08:33:35.146 (2) [pool-58-thread-1]: TrackingID: 49c4d632-5128-4957-a702-cfb8618c4dc7, Operation Error code[1120], Textual Error code[CampaignServiceInvalidCampaignStatus], msg[The campaign status is invalid for the current operation.], details[null] 2014-06-10 08:33:35.147 (1) [pool-58-thread-1]: Unrecoverable MSN API error (Invalid client data. Check the SOAP fault details for more information) 2014-06-10 08:34:28.675 (2) [pool-58-thread-2]: Lock timeout detected, retrying. [Message:Lock wait timeout exceeded; try restarting transaction] 2014-06-10 08:34:28.675 (2) [pool-58-thread-2]: SQL->[batch] 2014-06-10 08:34:28.676 (2) [pool-58-thread-2]: ... re-trying batch transaction (attempt #1) 2014-06-10 08:34:28.677 (2) [pool-58-thread-2]: ... success. 2014-06-10 08:34:28.679 (3) [pool-58-thread-2]: TextAdDAO(accountID 81702): Inserted 0 Errors: Updated 0 pending changes, cleared 0 existing errors. 2014-06-10 08:34:28.679 (3) [pool-58-thread-2]: TextAdChangeRequest (accountID 81702): Errors recorded, no more changes to process 2014-06-10 08:34:28.679 (2) [pool-58-thread-2]: Bing Request Errors for accountID 81702(TextAdChangeRequest) id=-1, trackingID=5350f629-47f3-46b9-bef0-fcc86580be52: , code=1120: , errorCode=CampaignServiceInvalidCampaignStatus: , message=The campaign status is invalid for the current operation.: 2014-06-10 08:34:29.679 (2) [pool-58-thread-1]: Lock timeout detected, retrying. [Message:Lock wait timeout exceeded; try restarting transaction] 2014-06-10 08:34:29.679 (2) [pool-58-thread-1]: SQL->[batch] 2014-06-10 08:34:29.680 (2) [pool-58-thread-1]: ... re-trying batch transaction (attempt #1) 2014-06-10 08:34:29.680 (2) [pool-58-thread-1]: ... success. 2014-06-10 08:34:29.682 (3) [pool-58-thread-1]: TextAdDAO(accountID 81702): Inserted 0 Errors: Updated 0 pending changes, cleared 0 existing errors. 2014-06-10 08:34:29.682 (3) [pool-58-thread-1]: TextAdChangeRequest (accountID 81702): Errors recorded, no more changes to process 2014-06-10 08:34:29.682 (2) [pool-58-thread-1]: Bing Request Errors for accountID 81702(TextAdChangeRequest) id=-1, trackingID=49c4d632-5128-4957-a702-cfb8618c4dc7: , code=1120: , errorCode=CampaignServiceInvalidCampaignStatus: , message=The campaign status is invalid for the current operation.: 2014-06-10 08:34:29.943 (3) [pool-58-thread-3]: TextAdChangeRequest (accountID 81702): Sending 6 add requests 2014-06-10 08:34:29.944 (3) [pool-58-thread-4]: TextAdChangeRequest (accountID 81702): Sending 6 add requests 2014-06-10 08:34:30.699 (2) [pool-58-thread-3]: TrackingID: b8e844f4-3a99-4533-a34a-fe8e78a6a11c, Operation Error code[1120], Textual Error code[CampaignServiceInvalidCampaignStatus], msg[The campaign status is invalid for the current operation.], details[null] 2014-06-10 08:34:30.699 (1) [pool-58-thread-3]: Unrecoverable MSN API error (Invalid client data. Check the SOAP fault details for more information) 2014-06-10 08:34:30.702 (3) [pool-58-thread-3]: TextAdChangeRequest (accountID 81702): Errors recorded, no more changes to process 2014-06-10 08:34:30.702 (2) [pool-58-thread-3]: TextAdDAO: database is null 2014-06-10 08:34:30.703 (2) [pool-58-thread-3]: TextAdChangeRequest released connection to pool (legacy - theDAO does not have a pool to release the connection to) 2014-06-10 08:34:30.768 (2) [pool-58-thread-4]: TrackingID: 1c14bf6d-42ca-471d-859f-3e1055e9c133, Operation Error code[1120], Textual Error code[CampaignServiceInvalidCampaignStatus], msg[The campaign status is invalid for the current operation.], details[null] 2014-06-10 08:34:30.768 (1) [pool-58-thread-4]: Unrecoverable MSN API error (Invalid client data. Check the SOAP fault details for more information) 2014-06-10 08:34:30.771 (3) [pool-58-thread-4]: TextAdChangeRequest (accountID 81702): Errors recorded, no more changes to process 2014-06-10 08:34:30.771 (2) [pool-58-thread-4]: TextAdDAO: database is null 2014-06-10 08:34:30.772 (2) [pool-58-thread-4]: TextAdChangeRequest released connection to pool (legacy - theDAO does not have a pool to release the connection to) 2014-06-10 08:34:30.957 (3) [P16T1]: Clearing bce_textAdPendingChanges for campaigns: [1815, 1816] 2014-06-10 08:34:30.959 (3) [P16T1]: Cleared: 18 text ads from bce_textAdPendingChanges 2014-06-10 08:34:32.996 (3) [P16T1]: Clearing bce_keywordPendingChanges for campaigns: [1815, 1816] 2014-06-10 08:34:32.997 (3) [P16T1]: Cleared 0 keywords from bce_keywordPendingChanges 2014-06-10 08:34:32.997 (3) [P16T1]: ... SEUser 85361 finished 2014-06-10 08:34:32.997 (3) [pool-5-thread-7]: ------------Bing Content Editor done 2014-06-10 08:34:33.033 (2) [pool-5-thread-7]: Change errors for BNV9UP25_1000000024_736_BNV9UP25-5_GT, skipping status change. 2014-06-10 08:34:33.033 (2) [pool-5-thread-7]: Change errors for BNV9UP25_1000000024_736_BNV9UP25-5_GM, skipping status change. 2014-06-10 08:34:33.033 (3) [pool-5-thread-7]: Running content editor replace... 2014-06-10 08:34:33.042 (3) [pool-5-thread-7]: ----------------Bing Content Editor starting 2014-06-10 08:34:33.124 (3) [P17T1]: No deleted adgroups found 2014-06-10 08:34:33.128 (3) [P17T1]: Deletes Pending Change 0 adgroups and adding 0 adgroups. 2014-06-10 08:34:33.393 (3) [P17T1]: No deleted keywords found 2014-06-10 08:34:33.403 (3) [P17T1]: Deleting 0 keywords and adding 0 keywords and Updated 0. 2014-06-10 08:35:10.125 (3) [pool-1-thread-1]: =======================YELL_VM_JBOSS1--/queue/AdMaxDeployRequestQueue Processor======================= /queue/AdMaxDeployRequestQueue-Receptor:ACTIVE:4 /queue/AdMaxDeployRequestQueue-Responder:ACTIVE:4 =======================YELL_VM_JBOSS1--/queue/AdMaxDeployRequestQueue Processor======================= 2014-06-10 08:35:10.126 (3) [pool-1-thread-1]: =======================YELL_VM_JBOSS1--/queue/AdMaxUpdateRequestQueue Processor======================= /queue/AdMaxUpdateRequestQueue-Receptor:ACTIVE:0 /queue/AdMaxUpdateRequestQueue-Responder:ACTIVE:0 =======================YELL_VM_JBOSS1--/queue/AdMaxUpdateRequestQueue Processor======================= 2014-06-10 08:35:27.909 (2) [P17T1]: Lock timeout detected, retrying. [Message:Lock wait timeout exceeded; try restarting transaction] 2014-06-10 08:35:27.909 (2) [P17T1]: SQL->[create temporary table `content_editor_bing`.`tmp39` engine=innodb character set latin1 collate latin1_swedish_ci (select `content_editor_bing`.`bce_textAd`.`id` AS `id_bce`,`content_editor_bing`.`tmp37`.`id` AS `id_struct`,`content_editor_bing`.`bce_textAd`.`adGroupID` AS `adGroupID_bce`,`content_editor_bing`.`tmp37`.`adGroupID` AS `adGroupID_struct`,`content_editor_bing`.`bce_textAd`.`searchEngineIdentifier` AS `searchEngineIdentifier_bce`,`content_editor_bing`.`tmp37`.`searchEngineIdentifier` AS `searchEngineIdentifier_struct`,`content_editor_bing`.`bce_textAd`.`title` AS `title_bce`,`content_editor_bing`.`tmp37`.`title` AS `title_struct`,`content_editor_bing`.`bce_textAd`.`text` AS `text_bce`,`content_editor_bing`.`tmp37`.`text` AS `text_struct`,`content_editor_bing`.`bce_textAd`.`displayURL` AS `displayURL_bce`,`content_editor_bing`.`tmp37`.`displayURL` AS `displayURL_struct`,`content_editor_bing`.`bce_textAd`.`destinationURL` AS `destinationURL_bce`,`content_editor_bing`.`tmp37`.`destinationURL` AS `destinationURL_struct`,`content_editor_bing`.`bce_textAd`.`isDisapproved` AS `isDisapproved_bce`,`content_editor_bing`.`tmp37`.`isDisapproved` AS `isDisapproved_struct`,`content_editor_bing`.`bce_textAd`.`status` AS `status_bce`,`content_editor_bing`.`tmp37`.`status` AS `status_struct` from `content_editor_bing`.`bce_textAd` left join `content_editor_bing`.`tmp37` on (((`content_editor_bing`.`bce_textAd`.`adGroupID`=`content_editor_bing`.`tmp37`.`adGroupID`) and (`content_editor_bing`.`bce_textAd`.`title`=`content_editor_bing`.`tmp37`.`title`) and (`content_editor_bing`.`bce_textAd`.`displayURL`=SUBSTRING_INDEX(SUBSTRING_INDEX(`content_editor_bing`.`tmp37`.`displayURL`, 'http', -1),'//',-1)))) left join `content_editor_bing`.`bce_adGroup` on ((`content_editor_bing`.`bce_adGroup`.`id`=`content_editor_bing`.`bce_textAd`.`adGroupID`)) left join `content_editor_bing`.`bce_campaign` on ((`content_editor_bing`.`bce_campaign`.`id`=`content_editor_bing`.`bce_adGroup`.`campaignID`)) where ((`content_editor_bing`.`bce_textAd`.`status`!="Inactive") and (`content_editor_bing`.`bce_adGroup`.`status`!="Deleted") and (`content_editor_bing`.`bce_campaign`.`searchEngineUserID`=85361) and (`content_editor_bing`.`bce_campaign`.`id` in (1812,1814,1816,1810,1807,1813,1811,1815,1809,1808)))) union (select `content_editor_bing`.`bce_textAd`.`id` AS `id_bce`,`content_editor_bing`.`tmp38`.`id` AS `id_struct`,`content_editor_bing`.`bce_textAd`.`adGroupID` AS `adGroupID_bce`,`content_editor_bing`.`tmp38`.`adGroupID` AS `adGroupID_struct`,`content_editor_bing`.`bce_textAd`.`searchEngineIdentifier` AS `searchEngineIdentifier_bce`,`content_editor_bing`.`tmp38`.`searchEngineIdentifier` AS `searchEngineIdentifier_struct`,`content_editor_bing`.`bce_textAd`.`title` AS `title_bce`,`content_editor_bing`.`tmp38`.`title` AS `title_struct`,`content_editor_bing`.`bce_textAd`.`text` AS `text_bce`,`content_editor_bing`.`tmp38`.`text` AS `text_struct`,`content_editor_bing`.`bce_textAd`.`displayURL` AS `displayURL_bce`,`content_editor_bing`.`tmp38`.`displayURL` AS `displayURL_struct`,`content_editor_bing`.`bce_textAd`.`destinationURL` AS `destinationURL_bce`,`content_editor_bing`.`tmp38`.`destinationURL` AS `destinationURL_struct`,`content_editor_bing`.`bce_textAd`.`isDisapproved` AS `isDisapproved_bce`,`content_editor_bing`.`tmp38`.`isDisapproved` AS `isDisapproved_struct`,`content_editor_bing`.`bce_textAd`.`status` AS `status_bce`,`content_editor_bing`.`tmp38`.`status` AS `status_struct` from `content_editor_bing`.`tmp38` left join `content_editor_bing`.`bce_textAd` on (((`content_editor_bing`.`bce_textAd`.`adGroupID`=`content_editor_bing`.`tmp38`.`adGroupID`) and (`content_editor_bing`.`bce_textAd`.`title`=`content_editor_bing`.`tmp38`.`title`) and (`content_editor_bing`.`bce_textAd`.`displayURL`=SUBSTRING_INDEX(SUBSTRING_INDEX(`content_editor_bing`.`tmp38`.`displayURL`, 'http', -1),'//',-1)) and (`content_editor_bing`.`bce_textAd`.`status`=`content_editor_bing`.`tmp38`.`status`))) where ((`content_editor_bing`.`bce_textAd`.`title` is null) and (`content_editor_bing`.`tmp38`.`status`!="Inactive")))] 2014-06-10 08:35:27.910 (2) [P17T1]: ... re-trying transaction (attempt #1) 2014-06-10 08:35:30.017 (3) [pool-1-thread-1]: =======================YELL_VM_JBOSS1--/queue/AdMaxDeployRequestQueue Processor======================= /queue/AdMaxDeployRequestQueue-Receptor:ACTIVE:7 /queue/AdMaxDeployRequestQueue-Responder:ACTIVE:6 =======================YELL_VM_JBOSS1--/queue/AdMaxDeployRequestQueue Processor======================= 2014-06-10 08:35:30.018 (3) [pool-1-thread-1]: =======================YELL_VM_JBOSS1--/queue/AdMaxUpdateRequestQueue Processor======================= /queue/AdMaxUpdateRequestQueue-Receptor:ACTIVE:0 /queue/AdMaxUpdateRequestQueue-Responder:ACTIVE:0 =======================YELL_VM_JBOSS1--/queue/AdMaxUpdateRequestQueue Processor======================= 2014-06-10 08:35:33.054 (3) [pool-5-thread-7]: Waiting for tasks to be done 2014-06-10 08:36:21.123 (2) [P17T1]: Lock timeout detected, retrying. [Message:Lock wait timeout exceeded; try restarting transaction] 2014-06-10 08:36:21.124 (2) [P17T1]: SQL->[create temporary table `content_editor_bing`.`tmp39` engine=innodb character set latin1 collate latin1_swedish_ci (select `content_editor_bing`.`bce_textAd`.`id` AS `id_bce`,`content_editor_bing`.`tmp37`.`id` AS `id_struct`,`content_editor_bing`.`bce_textAd`.`adGroupID` AS `adGroupID_bce`,`content_editor_bing`.`tmp37`.`adGroupID` AS `adGroupID_struct`,`content_editor_bing`.`bce_textAd`.`searchEngineIdentifier` AS `searchEngineIdentifier_bce`,`content_editor_bing`.`tmp37`.`searchEngineIdentifier` AS `searchEngineIdentifier_struct`,`content_editor_bing`.`bce_textAd`.`title` AS `title_bce`,`content_editor_bing`.`tmp37`.`title` AS `title_struct`,`content_editor_bing`.`bce_textAd`.`text` AS `text_bce`,`content_editor_bing`.`tmp37`.`text` AS `text_struct`,`content_editor_bing`.`bce_textAd`.`displayURL` AS `displayURL_bce`,`content_editor_bing`.`tmp37`.`displayURL` AS `displayURL_struct`,`content_editor_bing`.`bce_textAd`.`destinationURL` AS `destinationURL_bce`,`content_editor_bing`.`tmp37`.`destinationURL` AS `destinationURL_struct`,`content_editor_bing`.`bce_textAd`.`isDisapproved` AS `isDisapproved_bce`,`content_editor_bing`.`tmp37`.`isDisapproved` AS `isDisapproved_struct`,`content_editor_bing`.`bce_textAd`.`status` AS `status_bce`,`content_editor_bing`.`tmp37`.`status` AS `status_struct` from `content_editor_bing`.`bce_textAd` left join `content_editor_bing`.`tmp37` on (((`content_editor_bing`.`bce_textAd`.`adGroupID`=`content_editor_bing`.`tmp37`.`adGroupID`) and (`content_editor_bing`.`bce_textAd`.`title`=`content_editor_bing`.`tmp37`.`title`) and (`content_editor_bing`.`bce_textAd`.`displayURL`=SUBSTRING_INDEX(SUBSTRING_INDEX(`content_editor_bing`.`tmp37`.`displayURL`, 'http', -1),'//',-1)))) left join `content_editor_bing`.`bce_adGroup` on ((`content_editor_bing`.`bce_adGroup`.`id`=`content_editor_bing`.`bce_textAd`.`adGroupID`)) left join `content_editor_bing`.`bce_campaign` on ((`content_editor_bing`.`bce_campaign`.`id`=`content_editor_bing`.`bce_adGroup`.`campaignID`)) where ((`content_editor_bing`.`bce_textAd`.`status`!="Inactive") and (`content_editor_bing`.`bce_adGroup`.`status`!="Deleted") and (`content_editor_bing`.`bce_campaign`.`searchEngineUserID`=85361) and (`content_editor_bing`.`bce_campaign`.`id` in (1812,1814,1816,1810,1807,1813,1811,1815,1809,1808)))) union (select `content_editor_bing`.`bce_textAd`.`id` AS `id_bce`,`content_editor_bing`.`tmp38`.`id` AS `id_struct`,`content_editor_bing`.`bce_textAd`.`adGroupID` AS `adGroupID_bce`,`content_editor_bing`.`tmp38`.`adGroupID` AS `adGroupID_struct`,`content_editor_bing`.`bce_textAd`.`searchEngineIdentifier` AS `searchEngineIdentifier_bce`,`content_editor_bing`.`tmp38`.`searchEngineIdentifier` AS `searchEngineIdentifier_struct`,`content_editor_bing`.`bce_textAd`.`title` AS `title_bce`,`content_editor_bing`.`tmp38`.`title` AS `title_struct`,`content_editor_bing`.`bce_textAd`.`text` AS `text_bce`,`content_editor_bing`.`tmp38`.`text` AS `text_struct`,`content_editor_bing`.`bce_textAd`.`displayURL` AS `displayURL_bce`,`content_editor_bing`.`tmp38`.`displayURL` AS `displayURL_struct`,`content_editor_bing`.`bce_textAd`.`destinationURL` AS `destinationURL_bce`,`content_editor_bing`.`tmp38`.`destinationURL` AS `destinationURL_struct`,`content_editor_bing`.`bce_textAd`.`isDisapproved` AS `isDisapproved_bce`,`content_editor_bing`.`tmp38`.`isDisapproved` AS `isDisapproved_struct`,`content_editor_bing`.`bce_textAd`.`status` AS `status_bce`,`content_editor_bing`.`tmp38`.`status` AS `status_struct` from `content_editor_bing`.`tmp38` left join `content_editor_bing`.`bce_textAd` on (((`content_editor_bing`.`bce_textAd`.`adGroupID`=`content_editor_bing`.`tmp38`.`adGroupID`) and (`content_editor_bing`.`bce_textAd`.`title`=`content_editor_bing`.`tmp38`.`title`) and (`content_editor_bing`.`bce_textAd`.`displayURL`=SUBSTRING_INDEX(SUBSTRING_INDEX(`content_editor_bing`.`tmp38`.`displayURL`, 'http', -1),'//',-1)) and (`content_editor_bing`.`bce_textAd`.`status`=`content_editor_bing`.`tmp38`.`status`))) where ((`content_editor_bing`.`bce_textAd`.`title` is null) and (`content_editor_bing`.`tmp38`.`status`!="Inactive")))] 2014-06-10 08:36:21.124 (2) [P17T1]: ... re-trying transaction (attempt #2) 2014-06-10 08:37:10.131 (3) [pool-1-thread-1]: =======================YELL_VM_JBOSS1--/queue/AdMaxDeployRequestQueue Processor======================= /queue/AdMaxDeployRequestQueue-Receptor:ACTIVE:4 /queue/AdMaxDeployRequestQueue-Responder:ACTIVE:4 =======================YELL_VM_JBOSS1--/queue/AdMaxDeployRequestQueue Processor======================= 2014-06-10 08:37:10.131 (3) [pool-1-thread-1]: =======================YELL_VM_JBOSS1--/queue/AdMaxUpdateRequestQueue Processor======================= /queue/AdMaxUpdateRequestQueue-Receptor:ACTIVE:0 /queue/AdMaxUpdateRequestQueue-Responder:ACTIVE:0 =======================YELL_VM_JBOSS1--/queue/AdMaxUpdateRequestQueue Processor======================= 2014-06-10 08:37:15.343 (2) [P17T1]: Lock timeout detected, retrying. [Message:Lock wait timeout exceeded; try restarting transaction] 2014-06-10 08:37:15.343 (2) [P17T1]: SQL->[create temporary table `content_editor_bing`.`tmp39` engine=innodb character set latin1 collate latin1_swedish_ci (select `content_editor_bing`.`bce_textAd`.`id` AS `id_bce`,`content_editor_bing`.`tmp37`.`id` AS `id_struct`,`content_editor_bing`.`bce_textAd`.`adGroupID` AS `adGroupID_bce`,`content_editor_bing`.`tmp37`.`adGroupID` AS `adGroupID_struct`,`content_editor_bing`.`bce_textAd`.`searchEngineIdentifier` AS `searchEngineIdentifier_bce`,`content_editor_bing`.`tmp37`.`searchEngineIdentifier` AS `searchEngineIdentifier_struct`,`content_editor_bing`.`bce_textAd`.`title` AS `title_bce`,`content_editor_bing`.`tmp37`.`title` AS `title_struct`,`content_editor_bing`.`bce_textAd`.`text` AS `text_bce`,`content_editor_bing`.`tmp37`.`text` AS `text_struct`,`content_editor_bing`.`bce_textAd`.`displayURL` AS `displayURL_bce`,`content_editor_bing`.`tmp37`.`displayURL` AS `displayURL_struct`,`content_editor_bing`.`bce_textAd`.`destinationURL` AS `destinationURL_bce`,`content_editor_bing`.`tmp37`.`destinationURL` AS `destinationURL_struct`,`content_editor_bing`.`bce_textAd`.`isDisapproved` AS `isDisapproved_bce`,`content_editor_bing`.`tmp37`.`isDisapproved` AS `isDisapproved_struct`,`content_editor_bing`.`bce_textAd`.`status` AS `status_bce`,`content_editor_bing`.`tmp37`.`status` AS `status_struct` from `content_editor_bing`.`bce_textAd` left join `content_editor_bing`.`tmp37` on (((`content_editor_bing`.`bce_textAd`.`adGroupID`=`content_editor_bing`.`tmp37`.`adGroupID`) and (`content_editor_bing`.`bce_textAd`.`title`=`content_editor_bing`.`tmp37`.`title`) and (`content_editor_bing`.`bce_textAd`.`displayURL`=SUBSTRING_INDEX(SUBSTRING_INDEX(`content_editor_bing`.`tmp37`.`displayURL`, 'http', -1),'//',-1)))) left join `content_editor_bing`.`bce_adGroup` on ((`content_editor_bing`.`bce_adGroup`.`id`=`content_editor_bing`.`bce_textAd`.`adGroupID`)) left join `content_editor_bing`.`bce_campaign` on ((`content_editor_bing`.`bce_campaign`.`id`=`content_editor_bing`.`bce_adGroup`.`campaignID`)) where ((`content_editor_bing`.`bce_textAd`.`status`!="Inactive") and (`content_editor_bing`.`bce_adGroup`.`status`!="Deleted") and (`content_editor_bing`.`bce_campaign`.`searchEngineUserID`=85361) and (`content_editor_bing`.`bce_campaign`.`id` in (1812,1814,1816,1810,1807,1813,1811,1815,1809,1808)))) union (select `content_editor_bing`.`bce_textAd`.`id` AS `id_bce`,`content_editor_bing`.`tmp38`.`id` AS `id_struct`,`content_editor_bing`.`bce_textAd`.`adGroupID` AS `adGroupID_bce`,`content_editor_bing`.`tmp38`.`adGroupID` AS `adGroupID_struct`,`content_editor_bing`.`bce_textAd`.`searchEngineIdentifier` AS `searchEngineIdentifier_bce`,`content_editor_bing`.`tmp38`.`searchEngineIdentifier` AS `searchEngineIdentifier_struct`,`content_editor_bing`.`bce_textAd`.`title` AS `title_bce`,`content_editor_bing`.`tmp38`.`title` AS `title_struct`,`content_editor_bing`.`bce_textAd`.`text` AS `text_bce`,`content_editor_bing`.`tmp38`.`text` AS `text_struct`,`content_editor_bing`.`bce_textAd`.`displayURL` AS `displayURL_bce`,`content_editor_bing`.`tmp38`.`displayURL` AS `displayURL_struct`,`content_editor_bing`.`bce_textAd`.`destinationURL` AS `destinationURL_bce`,`content_editor_bing`.`tmp38`.`destinationURL` AS `destinationURL_struct`,`content_editor_bing`.`bce_textAd`.`isDisapproved` AS `isDisapproved_bce`,`content_editor_bing`.`tmp38`.`isDisapproved` AS `isDisapproved_struct`,`content_editor_bing`.`bce_textAd`.`status` AS `status_bce`,`content_editor_bing`.`tmp38`.`status` AS `status_struct` from `content_editor_bing`.`tmp38` left join `content_editor_bing`.`bce_textAd` on (((`content_editor_bing`.`bce_textAd`.`adGroupID`=`content_editor_bing`.`tmp38`.`adGroupID`) and (`content_editor_bing`.`bce_textAd`.`title`=`content_editor_bing`.`tmp38`.`title`) and (`content_editor_bing`.`bce_textAd`.`displayURL`=SUBSTRING_INDEX(SUBSTRING_INDEX(`content_editor_bing`.`tmp38`.`displayURL`, 'http', -1),'//',-1)) and (`content_editor_bing`.`bce_textAd`.`status`=`content_editor_bing`.`tmp38`.`status`))) where ((`content_editor_bing`.`bce_textAd`.`title` is null) and (`content_editor_bing`.`tmp38`.`status`!="Inactive")))] 2014-06-10 08:37:15.343 (2) [P17T1]: ... re-trying transaction (attempt #3) 2014-06-10 08:37:30.023 (3) [pool-1-thread-1]: =======================YELL_VM_JBOSS1--/queue/AdMaxDeployRequestQueue Processor======================= /queue/AdMaxDeployRequestQueue-Receptor:ACTIVE:7 /queue/AdMaxDeployRequestQueue-Responder:ACTIVE:6 =======================YELL_VM_JBOSS1--/queue/AdMaxDeployRequestQueue Processor======================= 2014-06-10 08:37:30.023 (3) [pool-1-thread-1]: =======================YELL_VM_JBOSS1--/queue/AdMaxUpdateRequestQueue Processor======================= /queue/AdMaxUpdateRequestQueue-Receptor:ACTIVE:0 /queue/AdMaxUpdateRequestQueue-Responder:ACTIVE:0 =======================YELL_VM_JBOSS1--/queue/AdMaxUpdateRequestQueue Processor======================= 2014-06-10 08:38:09.561 (2) [P17T1]: Lock timeout detected, retrying. [Message:Lock wait timeout exceeded; try restarting transaction] 2014-06-10 08:38:09.561 (2) [P17T1]: SQL->[create temporary table `content_editor_bing`.`tmp39` engine=innodb character set latin1 collate latin1_swedish_ci (select `content_editor_bing`.`bce_textAd`.`id` AS `id_bce`,`content_editor_bing`.`tmp37`.`id` AS `id_struct`,`content_editor_bing`.`bce_textAd`.`adGroupID` AS `adGroupID_bce`,`content_editor_bing`.`tmp37`.`adGroupID` AS `adGroupID_struct`,`content_editor_bing`.`bce_textAd`.`searchEngineIdentifier` AS `searchEngineIdentifier_bce`,`content_editor_bing`.`tmp37`.`searchEngineIdentifier` AS `searchEngineIdentifier_struct`,`content_editor_bing`.`bce_textAd`.`title` AS `title_bce`,`content_editor_bing`.`tmp37`.`title` AS `title_struct`,`content_editor_bing`.`bce_textAd`.`text` AS `text_bce`,`content_editor_bing`.`tmp37`.`text` AS `text_struct`,`content_editor_bing`.`bce_textAd`.`displayURL` AS `displayURL_bce`,`content_editor_bing`.`tmp37`.`displayURL` AS `displayURL_struct`,`content_editor_bing`.`bce_textAd`.`destinationURL` AS `destinationURL_bce`,`content_editor_bing`.`tmp37`.`destinationURL` AS `destinationURL_struct`,`content_editor_bing`.`bce_textAd`.`isDisapproved` AS `isDisapproved_bce`,`content_editor_bing`.`tmp37`.`isDisapproved` AS `isDisapproved_struct`,`content_editor_bing`.`bce_textAd`.`status` AS `status_bce`,`content_editor_bing`.`tmp37`.`status` AS `status_struct` from `content_editor_bing`.`bce_textAd` left join `content_editor_bing`.`tmp37` on (((`content_editor_bing`.`bce_textAd`.`adGroupID`=`content_editor_bing`.`tmp37`.`adGroupID`) and (`content_editor_bing`.`bce_textAd`.`title`=`content_editor_bing`.`tmp37`.`title`) and (`content_editor_bing`.`bce_textAd`.`displayURL`=SUBSTRING_INDEX(SUBSTRING_INDEX(`content_editor_bing`.`tmp37`.`displayURL`, 'http', -1),'//',-1)))) left join `content_editor_bing`.`bce_adGroup` on ((`content_editor_bing`.`bce_adGroup`.`id`=`content_editor_bing`.`bce_textAd`.`adGroupID`)) left join `content_editor_bing`.`bce_campaign` on ((`content_editor_bing`.`bce_campaign`.`id`=`content_editor_bing`.`bce_adGroup`.`campaignID`)) where ((`content_editor_bing`.`bce_textAd`.`status`!="Inactive") and (`content_editor_bing`.`bce_adGroup`.`status`!="Deleted") and (`content_editor_bing`.`bce_campaign`.`searchEngineUserID`=85361) and (`content_editor_bing`.`bce_campaign`.`id` in (1812,1814,1816,1810,1807,1813,1811,1815,1809,1808)))) union (select `content_editor_bing`.`bce_textAd`.`id` AS `id_bce`,`content_editor_bing`.`tmp38`.`id` AS `id_struct`,`content_editor_bing`.`bce_textAd`.`adGroupID` AS `adGroupID_bce`,`content_editor_bing`.`tmp38`.`adGroupID` AS `adGroupID_struct`,`content_editor_bing`.`bce_textAd`.`searchEngineIdentifier` AS `searchEngineIdentifier_bce`,`content_editor_bing`.`tmp38`.`searchEngineIdentifier` AS `searchEngineIdentifier_struct`,`content_editor_bing`.`bce_textAd`.`title` AS `title_bce`,`content_editor_bing`.`tmp38`.`title` AS `title_struct`,`content_editor_bing`.`bce_textAd`.`text` AS `text_bce`,`content_editor_bing`.`tmp38`.`text` AS `text_struct`,`content_editor_bing`.`bce_textAd`.`displayURL` AS `displayURL_bce`,`content_editor_bing`.`tmp38`.`displayURL` AS `displayURL_struct`,`content_editor_bing`.`bce_textAd`.`destinationURL` AS `destinationURL_bce`,`content_editor_bing`.`tmp38`.`destinationURL` AS `destinationURL_struct`,`content_editor_bing`.`bce_textAd`.`isDisapproved` AS `isDisapproved_bce`,`content_editor_bing`.`tmp38`.`isDisapproved` AS `isDisapproved_struct`,`content_editor_bing`.`bce_textAd`.`status` AS `status_bce`,`content_editor_bing`.`tmp38`.`status` AS `status_struct` from `content_editor_bing`.`tmp38` left join `content_editor_bing`.`bce_textAd` on (((`content_editor_bing`.`bce_textAd`.`adGroupID`=`content_editor_bing`.`tmp38`.`adGroupID`) and (`content_editor_bing`.`bce_textAd`.`title`=`content_editor_bing`.`tmp38`.`title`) and (`content_editor_bing`.`bce_textAd`.`displayURL`=SUBSTRING_INDEX(SUBSTRING_INDEX(`content_editor_bing`.`tmp38`.`displayURL`, 'http', -1),'//',-1)) and (`content_editor_bing`.`bce_textAd`.`status`=`content_editor_bing`.`tmp38`.`status`))) where ((`content_editor_bing`.`bce_textAd`.`title` is null) and (`content_editor_bing`.`tmp38`.`status`!="Inactive")))] 2014-06-10 08:38:09.562 (2) [P17T1]: ... re-trying transaction (attempt #4) 2014-06-10 08:39:03.771 (2) [P17T1]: Lock timeout detected, retrying. [Message:Lock wait timeout exceeded; try restarting transaction] 2014-06-10 08:39:03.772 (2) [P17T1]: SQL->[create temporary table `content_editor_bing`.`tmp39` engine=innodb character set latin1 collate latin1_swedish_ci (select `content_editor_bing`.`bce_textAd`.`id` AS `id_bce`,`content_editor_bing`.`tmp37`.`id` AS `id_struct`,`content_editor_bing`.`bce_textAd`.`adGroupID` AS `adGroupID_bce`,`content_editor_bing`.`tmp37`.`adGroupID` AS `adGroupID_struct`,`content_editor_bing`.`bce_textAd`.`searchEngineIdentifier` AS `searchEngineIdentifier_bce`,`content_editor_bing`.`tmp37`.`searchEngineIdentifier` AS `searchEngineIdentifier_struct`,`content_editor_bing`.`bce_textAd`.`title` AS `title_bce`,`content_editor_bing`.`tmp37`.`title` AS `title_struct`,`content_editor_bing`.`bce_textAd`.`text` AS `text_bce`,`content_editor_bing`.`tmp37`.`text` AS `text_struct`,`content_editor_bing`.`bce_textAd`.`displayURL` AS `displayURL_bce`,`content_editor_bing`.`tmp37`.`displayURL` AS `displayURL_struct`,`content_editor_bing`.`bce_textAd`.`destinationURL` AS `destinationURL_bce`,`content_editor_bing`.`tmp37`.`destinationURL` AS `destinationURL_struct`,`content_editor_bing`.`bce_textAd`.`isDisapproved` AS `isDisapproved_bce`,`content_editor_bing`.`tmp37`.`isDisapproved` AS `isDisapproved_struct`,`content_editor_bing`.`bce_textAd`.`status` AS `status_bce`,`content_editor_bing`.`tmp37`.`status` AS `status_struct` from `content_editor_bing`.`bce_textAd` left join `content_editor_bing`.`tmp37` on (((`content_editor_bing`.`bce_textAd`.`adGroupID`=`content_editor_bing`.`tmp37`.`adGroupID`) and (`content_editor_bing`.`bce_textAd`.`title`=`content_editor_bing`.`tmp37`.`title`) and (`content_editor_bing`.`bce_textAd`.`displayURL`=SUBSTRING_INDEX(SUBSTRING_INDEX(`content_editor_bing`.`tmp37`.`displayURL`, 'http', -1),'//',-1)))) left join `content_editor_bing`.`bce_adGroup` on ((`content_editor_bing`.`bce_adGroup`.`id`=`content_editor_bing`.`bce_textAd`.`adGroupID`)) left join `content_editor_bing`.`bce_campaign` on ((`content_editor_bing`.`bce_campaign`.`id`=`content_editor_bing`.`bce_adGroup`.`campaignID`)) where ((`content_editor_bing`.`bce_textAd`.`status`!="Inactive") and (`content_editor_bing`.`bce_adGroup`.`status`!="Deleted") and (`content_editor_bing`.`bce_campaign`.`searchEngineUserID`=85361) and (`content_editor_bing`.`bce_campaign`.`id` in (1812,1814,1816,1810,1807,1813,1811,1815,1809,1808)))) union (select `content_editor_bing`.`bce_textAd`.`id` AS `id_bce`,`content_editor_bing`.`tmp38`.`id` AS `id_struct`,`content_editor_bing`.`bce_textAd`.`adGroupID` AS `adGroupID_bce`,`content_editor_bing`.`tmp38`.`adGroupID` AS `adGroupID_struct`,`content_editor_bing`.`bce_textAd`.`searchEngineIdentifier` AS `searchEngineIdentifier_bce`,`content_editor_bing`.`tmp38`.`searchEngineIdentifier` AS `searchEngineIdentifier_struct`,`content_editor_bing`.`bce_textAd`.`title` AS `title_bce`,`content_editor_bing`.`tmp38`.`title` AS `title_struct`,`content_editor_bing`.`bce_textAd`.`text` AS `text_bce`,`content_editor_bing`.`tmp38`.`text` AS `text_struct`,`content_editor_bing`.`bce_textAd`.`displayURL` AS `displayURL_bce`,`content_editor_bing`.`tmp38`.`displayURL` AS `displayURL_struct`,`content_editor_bing`.`bce_textAd`.`destinationURL` AS `destinationURL_bce`,`content_editor_bing`.`tmp38`.`destinationURL` AS `destinationURL_struct`,`content_editor_bing`.`bce_textAd`.`isDisapproved` AS `isDisapproved_bce`,`content_editor_bing`.`tmp38`.`isDisapproved` AS `isDisapproved_struct`,`content_editor_bing`.`bce_textAd`.`status` AS `status_bce`,`content_editor_bing`.`tmp38`.`status` AS `status_struct` from `content_editor_bing`.`tmp38` left join `content_editor_bing`.`bce_textAd` on (((`content_editor_bing`.`bce_textAd`.`adGroupID`=`content_editor_bing`.`tmp38`.`adGroupID`) and (`content_editor_bing`.`bce_textAd`.`title`=`content_editor_bing`.`tmp38`.`title`) and (`content_editor_bing`.`bce_textAd`.`displayURL`=SUBSTRING_INDEX(SUBSTRING_INDEX(`content_editor_bing`.`tmp38`.`displayURL`, 'http', -1),'//',-1)) and (`content_editor_bing`.`bce_textAd`.`status`=`content_editor_bing`.`tmp38`.`status`))) where ((`content_editor_bing`.`bce_textAd`.`title` is null) and (`content_editor_bing`.`tmp38`.`status`!="Inactive")))] 2014-06-10 08:39:03.772 (2) [P17T1]: ... re-trying transaction (attempt #5) 2014-06-10 08:39:10.136 (3) [pool-1-thread-1]: =======================YELL_VM_JBOSS1--/queue/AdMaxDeployRequestQueue Processor======================= /queue/AdMaxDeployRequestQueue-Receptor:ACTIVE:4 /queue/AdMaxDeployRequestQueue-Responder:ACTIVE:4 =======================YELL_VM_JBOSS1--/queue/AdMaxDeployRequestQueue Processor======================= 2014-06-10 08:39:10.136 (3) [pool-1-thread-1]: =======================YELL_VM_JBOSS1--/queue/AdMaxUpdateRequestQueue Processor======================= /queue/AdMaxUpdateRequestQueue-Receptor:ACTIVE:0 /queue/AdMaxUpdateRequestQueue-Responder:ACTIVE:0 =======================YELL_VM_JBOSS1--/queue/AdMaxUpdateRequestQueue Processor======================= 2014-06-10 08:39:30.032 (3) [pool-1-thread-1]: =======================YELL_VM_JBOSS1--/queue/AdMaxDeployRequestQueue Processor======================= /queue/AdMaxDeployRequestQueue-Receptor:ACTIVE:7 /queue/AdMaxDeployRequestQueue-Responder:ACTIVE:6 =======================YELL_VM_JBOSS1--/queue/AdMaxDeployRequestQueue Processor======================= 2014-06-10 08:39:30.032 (3) [pool-1-thread-1]: =======================YELL_VM_JBOSS1--/queue/AdMaxUpdateRequestQueue Processor======================= /queue/AdMaxUpdateRequestQueue-Receptor:ACTIVE:0 /queue/AdMaxUpdateRequestQueue-Responder:ACTIVE:0 =======================YELL_VM_JBOSS1--/queue/AdMaxUpdateRequestQueue Processor======================= 2014-06-10 08:39:54.985 (2) [P17T1]: Lock timeout retry limit exceeded, throwing exception 2014-06-10 08:39:54.988 (2) [P17T1]: Exception [SQL Exception running content editor, quitting]:java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction 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.Connection.execSQL(Connection.java:3099) at com.mysql.jdbc.Statement.execute(Statement.java:695) at com.carldunham.jst.db.Database.execute(Database.java:282) at com.carldunham.jst.db.CreateTable.screate(CreateTable.java:337) at com.carldunham.jst.db.CreateTable.screate(CreateTable.java:260) at com.carldunham.jst.db.CreateTable.screate(CreateTable.java:253) at com.thesearchagency.searchengines.bing.contenteditor.BingContentEditorHelper.replaceTextAds(BingContentEditorHelper.java:1664) at com.thesearchagency.searchengines.bing.contenteditor.BingContentEditorHelper.replace(BingContentEditorHelper.java:1480) at com.thesearchagency.searchengines.bing.contenteditor.BingContentEditor$SearchEngineUserWorker.handlePreRunActions(BingContentEditor.java:922) at com.thesearchagency.searchengines.bing.contenteditor.BingContentEditor$SearchEngineUserWorker.run(BingContentEditor.java:847) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) 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) 2014-06-10 08:39:54.988 (3) [P17T1]: ... SEUser 85361 finished 2014-06-10 08:40:13.107 (3) [pool-5-thread-7]: ------------Bing Content Editor done 2014-06-10 08:40:13.113 (3) [pool-5-thread-7]: Deleted: 0 unregistered textAds 2014-06-10 08:40:13.115 (3) [pool-5-thread-7]: Deleted: 0 unregistered keywords 2014-06-10 08:40:13.116 (3) [pool-5-thread-7]: Updating 0 TextAd display/destination URLs and 0 keyword destination URLs and 0 placement destination URLs in BCE Campaigns: [1807] 2014-06-10 08:40:13.122 (3) [pool-5-thread-7]: Deleted: 0 unregistered textAds 2014-06-10 08:40:13.124 (3) [pool-5-thread-7]: Deleted: 0 unregistered keywords 2014-06-10 08:40:13.126 (3) [pool-5-thread-7]: Updating 0 TextAd display/destination URLs and 0 keyword destination URLs and 0 placement destination URLs in BCE Campaigns: [1808] 2014-06-10 08:40:13.134 (2) [pool-5-thread-7]: updateTextAdDestinationURLs(): Number of pending deletes (0) != numPendingAds (3) 2014-06-10 08:40:13.135 (3) [pool-5-thread-7]: Deleted: 0 unregistered textAds 2014-06-10 08:40:13.137 (3) [pool-5-thread-7]: Deleted: 0 unregistered keywords 2014-06-10 08:40:13.166 (3) [pool-5-thread-7]: Updating 0 TextAd display/destination URLs and 0 keyword destination URLs and 0 placement destination URLs in BCE Campaigns: [1809] 2014-06-10 08:40:13.176 (2) [pool-5-thread-7]: updateTextAdDestinationURLs(): Number of pending deletes (0) != numPendingAds (3) 2014-06-10 08:40:13.178 (3) [pool-5-thread-7]: Deleted: 0 unregistered textAds 2014-06-10 08:40:13.180 (3) [pool-5-thread-7]: Deleted: 0 unregistered keywords 2014-06-10 08:40:13.181 (3) [pool-5-thread-7]: Updating 0 TextAd display/destination URLs and 0 keyword destination URLs and 0 placement destination URLs in BCE Campaigns: [1810] 2014-06-10 08:40:13.194 (2) [pool-5-thread-7]: updateTextAdDestinationURLs(): Number of pending deletes (0) != numPendingAds (3) 2014-06-10 08:40:13.195 (3) [pool-5-thread-7]: Deleted: 0 unregistered textAds 2014-06-10 08:40:13.197 (3) [pool-5-thread-7]: Deleted: 0 unregistered keywords 2014-06-10 08:40:13.198 (3) [pool-5-thread-7]: Updating 0 TextAd display/destination URLs and 0 keyword destination URLs and 0 placement destination URLs in BCE Campaigns: [1811] 2014-06-10 08:40:13.206 (2) [pool-5-thread-7]: updateTextAdDestinationURLs(): Number of pending deletes (0) != numPendingAds (3) 2014-06-10 08:40:13.207 (3) [pool-5-thread-7]: Deleted: 0 unregistered textAds 2014-06-10 08:40:13.209 (3) [pool-5-thread-7]: Deleted: 0 unregistered keywords 2014-06-10 08:40:13.210 (3) [pool-5-thread-7]: Updating 0 TextAd display/destination URLs and 0 keyword destination URLs and 0 placement destination URLs in BCE Campaigns: [1812] 2014-06-10 08:41:04.261 (2) [pool-5-thread-7]: SQLTransaction try # 1: non-deadlock exception, not retrying 2014-06-10 08:41:04.263 (2) [pool-5-thread-7]: Error: CampID: BNV9UP25-1_GT Info: Error during update request. 2014-06-10 08:41:04.263 (2) [pool-5-thread-7]: Error: CampID: BNV9UP25-1_GM Info: Error during update request. 2014-06-10 08:41:04.263 (2) [pool-5-thread-7]: Error: CampID: BNV9UP25-2_GT Info: Error during update request. 2014-06-10 08:41:04.263 (2) [pool-5-thread-7]: Error: CampID: BNV9UP25-2_GM Info: Error during update request. 2014-06-10 08:41:04.263 (2) [pool-5-thread-7]: Error: CampID: BNV9UP25-3_GT Info: Error during update request. 2014-06-10 08:41:04.263 (2) [pool-5-thread-7]: Error: CampID: BNV9UP25-3_GM Info: Error during update request. 2014-06-10 08:41:04.263 (2) [pool-5-thread-7]: Error: CampID: BNV9UP25-4_GT Info: Error during update request. 2014-06-10 08:41:04.263 (2) [pool-5-thread-7]: Error: CampID: BNV9UP25-4_GM Info: Error during update request. 2014-06-10 08:41:04.263 (2) [pool-5-thread-7]: Error: CampID: BNV9UP25-5_GT Info: Error during update request. 2014-06-10 08:41:04.264 (2) [pool-5-thread-7]: Error: CampID: BNV9UP25-5_GM Info: Error during update request. 2014-06-10 08:41:04.264 (1) [pool-5-thread-7]: Exception [BING Account Worker - Error during update request.]:java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction 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.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1169) at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:693) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1404) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1318) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1303) at com.thesearchagency.searchengines.bing.contenteditor.dao.ad.textad.TextAdDAO.deleteUnregisteredTextAds(TextAdDAO.java:337) at com.thesearchagency.searchengines.bing.contenteditor.dao.ad.textad.TextAdDAO.updateTextAdDestinationURLs(TextAdDAO.java:315) at com.thesearchagency.searchengines.bing.contenteditor.RequestCreator$CampaignURLUpdateTransaction.databaseCalls(RequestCreator.java:307) at com.carldunham.jst.db.SQLTransaction.execute(SQLTransaction.java:68) at com.thesearchagency.searchengines.bing.contenteditor.RequestCreator.updateAllDestinationURLs(RequestCreator.java:134) at com.thesearchagency.admaxlistener.worker.BingCampaignUpdateWorker.updateDestinationURLs(BingCampaignUpdateWorker.java:335) at com.thesearchagency.admaxlistener.worker.BingCampaignUpdateWorker.campaignSync(BingCampaignUpdateWorker.java:370) at com.thesearchagency.admaxlistener.worker.BingCampaignUpdateWorker.call(BingCampaignUpdateWorker.java:100) 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) 2014-06-10 08:41:04.264 (3) [pool-5-thread-7]: GOOGLE Account Worker has 0 campaign(s) to update. 2014-06-10 08:41:04.264 (3) [pool-5-thread-7]: GOOGLE Account Worker has 0 campaign(s) to create. 2014-06-10 08:41:04.264 (3) [pool-5-thread-7]: GOOGLE Account Worker has 0 campaign(s) to retry and update. 2014-06-10 08:41:04.279 (3) [pool-5-thread-7]: BNV9UP25-3_GM has no applicable BCE errors. 2014-06-10 08:41:04.287 (3) [pool-5-thread-7]: BNV9UP25-4_GM has no applicable BCE errors. 2014-06-10 08:41:04.296 (3) [pool-5-thread-7]: BING Account Worker - Ignoring 0 other operation errors for deleted campaign. 2014-06-10 08:41:04.296 (2) [pool-5-thread-7]: Error: CampID: BNV9UP25-5_GM Info: [[Bing API error, type=Campaign, code=1120, errorCode=CampaignServiceInvalidCampaignStatus, message=The campaign status is invalid for the current operation.] 2014-06-10 08:41:04.297 (2) [pool-5-thread-7]: BNV9UP25-5_GM has BCE errors. 2014-06-10 08:41:04.303 (3) [pool-5-thread-7]: BNV9UP25-2_GM has no applicable BCE errors. 2014-06-10 08:41:04.309 (3) [pool-5-thread-7]: BNV9UP25-1_GT has no applicable BCE errors. 2014-06-10 08:41:04.316 (3) [pool-5-thread-7]: BNV9UP25-4_GT has no applicable BCE errors. 2014-06-10 08:41:04.323 (3) [pool-5-thread-7]: BNV9UP25-3_GT has no applicable BCE errors. 2014-06-10 08:41:04.331 (3) [pool-5-thread-7]: BING Account Worker - Ignoring 0 other operation errors for deleted campaign. 2014-06-10 08:41:04.331 (2) [pool-5-thread-7]: Error: CampID: BNV9UP25-5_GT Info: [[Bing API error, type=Campaign, code=1120, errorCode=CampaignServiceInvalidCampaignStatus, message=The campaign status is invalid for the current operation.] 2014-06-10 08:41:04.331 (2) [pool-5-thread-7]: BNV9UP25-5_GT has BCE errors. 2014-06-10 08:41:04.337 (3) [pool-5-thread-7]: BNV9UP25-2_GT has no applicable BCE errors. 2014-06-10 08:41:04.343 (3) [pool-5-thread-7]: BNV9UP25-1_GM has no applicable BCE errors. 2014-06-10 08:41:04.378 (3) [pool-5-thread-7]: BING - BNV9UP25 has 0 campaigns for a SE Update accounts sync. 2014-06-10 08:41:04.379 (3) [pool-5-thread-7]: BING - BNV9UP25 has 0 campaigns for a SE Update groups-listings sync. 2014-06-10 08:41:04.379 (3) [pool-5-thread-7]: BNV9UP25 has 0 campaigns for a SE Update accounts sync. 2014-06-10 08:41:04.379 (3) [pool-5-thread-7]: BNV9UP25 has 0 campaigns for a SE Update groups-listings sync. 2014-06-10 08:41:04.379 (3) [pool-5-thread-7]: 0 Scheduled Job Items to save for BNV9UP25. 2014-06-10 08:41:04.379 (3) [pool-5-thread-7]: Finished sub-campaign processing for DEPLOY deploymentID (BNV9UP25). account BNV9UP25. 10 submitted, 0 ok. 2014-06-10 08:41:04.379 (3) [pool-5-thread-7]: Finished DEPLOY request for BNV9UP25_1000000024_736_BNV9UP25-1: FAILED 2014-06-10 08:41:04.379 (3) [pool-5-thread-7]: Finished DEPLOY request for BNV9UP25_1000000024_736_BNV9UP25-2: FAILED 2014-06-10 08:41:04.379 (3) [pool-5-thread-7]: Finished DEPLOY request for BNV9UP25_1000000024_736_BNV9UP25-3: FAILED 2014-06-10 08:41:04.379 (3) [pool-5-thread-7]: Finished DEPLOY request for BNV9UP25_1000000024_736_BNV9UP25-4: FAILED 2014-06-10 08:41:04.379 (3) [pool-5-thread-7]: Finished DEPLOY request for BNV9UP25_1000000024_736_BNV9UP25-5: FAILED 2014-06-10 08:41:04.379 (3) [pool-5-thread-7]: Finished DEPLOY request, deploymentID (BNV9UP25), account BNV9UP25