Creating new Bing account [unknown_environment_]_[uknown_reseller]_1a42c6d6-e6fc-4fc7-813f-4490444121d7_1 2015-11-17 14:10:57.384 (3) [pool-3-thread-1]: Start processing UPDATE request (688bda1d-938e-42b7-976c-a14d70b5a38e) for account 1a42c6d6-e6fc-4fc7-813f-4490444121d7. 4 campaign(s). 2015-11-17 14:10:57.384 (4) [pool-3-thread-1]: Locked account: 1a42c6d6-e6fc-4fc7-813f-4490444121d7 2015-11-17 14:10:57.781 (4) [pool-3-thread-1]: Setting reqequest distribution to [Bing] for 17087_GM 2015-11-17 14:10:57.957 (4) [pool-3-thread-1]: Setting reqequest distribution to [Bing] for 17087_GT 2015-11-17 14:10:58.135 (4) [pool-3-thread-1]: Setting reqequest distribution to [Google] for 17088_GM 2015-11-17 14:10:58.315 (4) [pool-3-thread-1]: Setting reqequest distribution to [Google] for 17088_GT 2015-11-17 14:11:07,004 [pool-3-thread-1] INFO jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`id` IN (16280,16281) 2015-11-17 14:11:07.234 (2) [pool-3-thread-1]: Error: CampID: 17087_GM Info: Error during update request. 2015-11-17 14:11:07.234 (2) [pool-3-thread-1]: Error: CampID: 17087_GT Info: Error during update request. 2015-11-17 14:11:07.234 (2) [pool-3-thread-1]: Error: CampID: 17088_GM Info: Error during update request. 2015-11-17 14:11:07.234 (2) [pool-3-thread-1]: Error: CampID: 17088_GT Info: Error during update request. 2015-11-17 14:11:07.234 (1) [pool-3-thread-1]: Exception [Error during update request.]:java.lang.IllegalStateException: Could not find existing Google campaign for 32babedb-9273-4b8a-9ed8-3482ffc0405c_93144_3010 44_496_GM in [[1a42c6d6-e6fc-4fc7-813f-4490444121d7_93018_57_17087_GM, 1a42c6d6-e6fc-4fc7-813f-4490444121d7_93018_57_17088_GM, 1a42c6d6-e6fc-4fc7-813f-4490444121d7_93018_57_17087_GT, 1a42c6d6-e6fc-4fc7-813f-44904 44121d7_93018_57_17088_GT]] at com.thesearchagency.admaxlistener.worker.CampaignUpdateWorker.getCampaignChangeInfos(CampaignUpdateWorker.java:165) at com.thesearchagency.admaxlistener.worker.CampaignUpdateWorker.call(CampaignUpdateWorker.java:90) at com.thesearchagency.admaxlistener.worker.AccountWorker.updateCampaigns(AccountWorker.java:531) at com.thesearchagency.admaxlistener.worker.AccountWorker.deploySync(AccountWorker.java:397) at com.thesearchagency.admaxlistener.worker.AccountWorker.call(AccountWorker.java:155) at com.thesearchagency.admaxlistener.worker.RequestWorker.call(RequestWorker.java:446) at com.thesearchagency.admaxlistener.worker.RequestWorker.call(RequestWorker.java:96) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) select `content_editor_google`.`gce_campaign`.*,`content_editor_google`.`gce_campaignPendingChange`.*,`content_editor_google`.`gce_campaignTargetMap`.*,`content_editor_google`.`gce_target`.`code`,`content_editor_google`.`gce_target`.`targetType`,`content_editor_google`.`gce_target`.`criterionID`,`content_editor_google`.`gce_campaignProximityTargetMap`.`criterionID`,`content_editor_google`.`gce_campaignProximityTargetMap`.`latitudeInMicroDegrees`,`content_editor_google`.`gce_campaignProximityTargetMap`.`longitudeInMicroDegrees`,`content_editor_google`.`gce_campaignProximityTargetMap`.`radius`,`content_editor_google`.`gce_campaignProximityTargetMap`.`radiusUnits`,`content_editor_google`.`gce_campaign`.`id` AS `gce_campaign_campaignID`,`gce_campaignPendingUpdate`.`name` AS `nameChange`,`gce_campaignPendingUpdate`.`budgetAmount` AS `budgetAmountChange`,`gce_campaignPendingUpdate`.`budgetPeriod` AS `budgetPeriodChange`,`gce_campaignPendingUpdate`.`contentTargeting` AS `contentTargetingChange`,`gce_campaignPendingUpdate`.`endDay` AS `endDayChange`,`gce_campaignPendingUpdate`.`status` AS `statusChange` from `content_editor_google`.`gce_campaign` left join `gce_campaignPendingChange` on ((`content_editor_google`.`gce_campaignPendingChange`.`campaignID`=`content_editor_google`.`gce_campaign`.`id`)) left join `gce_campaignPendingUpdate` on ((`gce_campaignPendingUpdate`.`campaignID`=`gce_campaign`.`id`)) left join `gce_campaignTargetMap` on ((`content_editor_google`.`gce_campaignTargetMap`.`campaignID`=`content_editor_google`.`gce_campaign`.`id`)) left join `gce_target` on ((`content_editor_google`.`gce_campaignTargetMap`.`targetID`=`content_editor_google`.`gce_target`.`id`)) left join `content_editor_google`.`gce_campaignProximityTargetMap` on (((((`content_editor_google`.`gce_campaignProximityTargetMap`.`campaignID`=`content_editor_google`.`gce_campaignTargetMap`.`campaignID`)) and ((`content_editor_google`.`gce_campaignProximityTargetMap`.`targetID`=`content_editor_google`.`gce_campaignTargetMap`.`targetID`))))) where ((`gce_campaign`.`id` in (465,464))); seUserID searchEngineIdentifier name 85 | 179950760 | 32babedb-9273-4b8a-9ed8-3482ffc0405c_93144_301044_496_GM select * from `tsacommon`.`accounts` where (`id`=1125) limit 1 2015-11-17 13:58:25.611 (4) [pool-3-thread-1]: Query executed in 0.115s, 1 row(s) affected 2015-11-17 13:58:25.612 (3) [pool-3-thread-1]: Assigned new seUserID: 1228 to 1a42c6d6-e6fc-4fc7-813f-4490444121d7_93018_57_17088_GT 2015-11-17 13:58:25.613 (3) [pool-3-thread-1]: Assigned new seUserID: 1228 to 1a42c6d6-e6fc-4fc7-813f-4490444121d7_93018_57_17088_GM 2015-11-17 13:58:25.613 (3) [pool-3-thread-1]: Assigned 2 campaigns to 1 new user(s). 2015-11-17 13:58:25.613 (3) [pool-3-thread-1]: Assigned new seUserID: 1229 to 1a42c6d6-e6fc-4fc7-813f-4490444121d7_93018_57_17087_GT 2015-11-17 13:58:25.613 (3) [pool-3-thread-1]: Assigned new seUserID: 1229 to 1a42c6d6-e6fc-4fc7-813f-4490444121d7_93018_57_17087_GM 2015-11-17 13:58:25.613 (3) [pool-3-thread-1]: Assigned 2 campaigns to 1 new user(s). select * from content_editor_google.gce_campaign where id in (16280,16281); select * from bing.campaigns where id in (464,465)\G select advertID, distribution from mms_common.campaigns where advertId in (17088,17087); +----------+--------------+ | advertID | distribution | +----------+--------------+ | 17087 | Google | | 17088 | Bing | +----------+--------------+ select id, distributionID, description from tsacommon.searchEngineUsers where id in (1228,1229); +------+----------------+----------------------------------------+ | id | distributionID | description | +------+----------------+----------------------------------------+ | 1228 | 147 | 1a42c6d6-e6fc-4fc7-813f-4490444121d7_1 | | 1229 | 3 | 1a42c6d6-e6fc-4fc7-813f-4490444121d7_2 | +------+----------------+----------------------------------------+ select id, searchEngineUserID, distributionID, description from tsacommon.searchEngineAccounts where description in ('1a42c6d6-e6fc-4fc7-813f-4490444121d7_93018_57_17087_GT','1a42c6d6-e6fc-4fc7-813f-4490444121d7_93018_57_17087_GM','1a42c6d6-e6fc-4fc7-813f-4490444121d7_93018_57_17088_GM','1a42c6d6-e6fc-4fc7-813f-4490444121d7_93018_57_17088_GT'); +-------+--------------------+----------------+--------------------------------------------------------+ | id | searchEngineUserID | distributionID | description | +-------+--------------------+----------------+--------------------------------------------------------+ | 16200 | 1228 | 3 | 1a42c6d6-e6fc-4fc7-813f-4490444121d7_93018_57_17088_GT | | 16201 | 1228 | 3 | 1a42c6d6-e6fc-4fc7-813f-4490444121d7_93018_57_17088_GM | | 16202 | 1229 | 147 | 1a42c6d6-e6fc-4fc7-813f-4490444121d7_93018_57_17087_GT | | 16203 | 1229 | 147 | 1a42c6d6-e6fc-4fc7-813f-4490444121d7_93018_57_17087_GM | +-------+--------------------+----------------+--------------------------------------------------------+ select id, name, status from bing.campaigns where id in (464,465); +-----+--------------------------------------------------------+--------+ | id | name | status | +-----+--------------------------------------------------------+--------+ | 464 | 1a42c6d6-e6fc-4fc7-813f-4490444121d7_93018_57_17088_GT | Paused | | 465 | 1a42c6d6-e6fc-4fc7-813f-4490444121d7_93018_57_17088_GM | Paused | +-----+--------------------------------------------------------+--------+ select id, searchEngineUseriD, name, status from content_editor_google.gce_campaign where id in (16280,16281); +-------+--------------------+--------------------------------------------------------+--------+ | id | searchEngineUseriD | name | status | +-------+--------------------+--------------------------------------------------------+--------+ | 16280 | 1229 | 1a42c6d6-e6fc-4fc7-813f-4490444121d7_93018_57_17087_GT | Paused | | 16281 | 1229 | 1a42c6d6-e6fc-4fc7-813f-4490444121d7_93018_57_17087_GM | Paused | +-------+--------------------+--------------------------------------------------------+--------+