2014-03-05 12:19:51.161 (3) [Thread-9]: Request added to map for customerID c9a009ac-480a-4539-86f5-9e0820e68919 2014-03-05 12:19:51.162 (3) [Thread-9]: Request worker created for c9a009ac-480a-4539-86f5-9e0820e68919 2014-03-05 12:19:51.162 (3) [Thread-9]: Submitted executor job for c9a009ac-480a-4539-86f5-9e0820e68919 2014-03-05 12:19:51.239 (3) [pool-3-thread-8]: c9a009ac-480a-4539-86f5-9e0820e68919 is a new account. 2014-03-05 12:19:51.239 (3) [pool-3-thread-8]: Creating new tsa account: c9a009ac-480a-4539-86f5-9e0820e68919 2014-03-05 12:19:51.966 (3) [pool-3-thread-8]: c9a009ac-480a-4539-86f5-9e0820e68919 has been assigned accountID 370 2014-03-05 12:19:52.132 (3) [pool-3-thread-8]: Updating deployment status to 'InProgress' for campaignID: 1646 2014-03-05 12:19:52.133 (3) [pool-3-thread-8]: 1646 has no parent. Creating... 2014-03-05 12:19:52.138 (3) [pool-3-thread-8]: Updating advert budget for c9a009ac-480a-4539-86f5-9e0820e68919_10268_57_1646 2014-03-05 12:19:52.187 (3) [pool-3-thread-8]: Start processing DEPLOY request (b06b1d9c-17a8-436f-9d2d-10018ed2ecc5) for account c9a009ac-480a-4539-86f5-9e0820e68919. 2 campaign(s). 2014-03-05 12:19:52.187 (3) [pool-3-thread-8]: Performing sync for account: c9a009ac-480a-4539-86f5-9e0820e68919 ID#370 2014-03-05 12:19:52.200 (3) [pool-3-thread-8]: 0 campaign(s) to update. 2014-03-05 12:19:52.200 (3) [pool-3-thread-8]: 2 campaign(s) to create. 2014-03-05 12:19:52.200 (3) [pool-3-thread-8]: 0 campaign(s) to retry and update. 2014-03-05 12:19:52.202 (3) [pool-3-thread-8]: c9a009ac-480a-4539-86f5-9e0820e68919 has 2 new campaign(s). 2014-03-05 12:19:52.203 (3) [pool-3-thread-8]: c9a009ac-480a-4539-86f5-9e0820e68919 requires 1 new users. 2014-03-05 12:19:52.219 (3) [pool-3-thread-8]: Created 1 SE user row(s). 2014-03-05 12:19:52.219 (3) [pool-3-thread-8]: Calling GCE to create 1 SE users. 2014-03-05 12:19:52.238 (3) [pool-3-thread-8]: ----------------Google Content Editor starting 2014-03-05 12:19:52.245 (3) [P22T1]: Creating Google accounts for accountID 370 2014-03-05 12:19:52.442 (3) [P22T1]: Inserted/Updated 2 row(s) in `sesystem`.`googleAuthToken` 2014-03-05 12:19:52.775 (3) [P22T1]: Returning 3987265483 2014-03-05 12:19:52.775 (3) [P22T1]: GoogleAccountChangeRequest (accountID 370): Sending 1 add requests 2014-03-05 12:19:52.792 (3) [P22T1]: Creating account in 3987265483 2014-03-05 12:19:55.222 (3) [Thread-9]: Heartbeat #446 (1394021995088) received in 0.134s 2014-03-05 12:20:25.094 (3) [Thread-9]: Heartbeat #447 (1394022025088) received in 0.006s 2014-03-05 12:20:25.846 (3) [P22T1]: GoogleAccountDAO(accountID 370) Request contained 1 adds, 0 updates, 0 deletes. 2014-03-05 12:20:25.846 (3) [P22T1]: GoogleAccountDAO(accountID 370) DB updates: 1 items updated, 1 pending changes deleted, 0 pending updates deleted, 0 errors cleared 2014-03-05 12:20:25.846 (3) [P22T1]: GCE: TSA Account [370]: Creating budget for client #5750677104 2014-03-05 12:20:25.847 (3) [P22T1]: aCurrencyValue(9000000.0) : aCurrencyCode(USD) 2014-03-05 12:20:28.744 (3) [P22T1]: Successfully placed Budget for CustomerID: 5750677104, Budget Details [status: UNDER_REVIEW, budgetOrder ID:123625265, startDateTime:20140305 212025 Asia/Seoul, endDateTime:20361231 235959 Asia/Seoul, budget Amount:9000000000000 2014-03-05 12:20:28.766 (3) [pool-3-thread-8]: ------------Google Content Editor done 2014-03-05 12:20:28.767 (3) [pool-3-thread-8]: Returning 3987265483 2014-03-05 12:20:28.767 (3) [pool-3-thread-8]: enabling se user 368 Identifier:5750677104 2014-03-05 12:20:28.770 (3) [pool-3-thread-8]: Assigned new seUserID: 368 to c9a009ac-480a-4539-86f5-9e0820e68919_10268_57_1646_GT 2014-03-05 12:20:28.770 (3) [pool-3-thread-8]: Assigned new seUserID: 368 to c9a009ac-480a-4539-86f5-9e0820e68919_10268_57_1646_GM 2014-03-05 12:20:28.770 (3) [pool-3-thread-8]: Assigned 2 campaigns to 1 new user(s). 2014-03-05 12:20:28.773 (3) [pool-3-thread-8]: Creating 2 new campaign(s). 2014-03-05 12:20:28.773 (3) [pool-3-thread-8]: CampaignWorker initialized for account: 370 2014-03-05 12:20:28.773 (3) [pool-3-thread-8]: Creating c9a009ac-480a-4539-86f5-9e0820e68919_10268_57_1646_GT Status: Paused 2014-03-05 12:20:28.773 (3) [pool-3-thread-8]: Creating c9a009ac-480a-4539-86f5-9e0820e68919_10268_57_1646_GM Status: Paused 2014-03-05 12:20:28.773 (3) [pool-3-thread-8]: CampaignWorker started for account: 370 2014-03-05 12:20:28.988 (3) [pool-3-thread-8]: Created GoogleAccountStructure. Added 2 campaigns, 2 adGroups, 150 keyword, 8 ads, 0 placements 2014-03-05 12:20:28.989 (3) [pool-3-thread-8]: ----------------Google Content Editor starting 2014-03-05 12:20:29.068 (3) [P23T1]: Inserted/Updated 2 row(s) in `sesystem`.`googleAuthToken` 2014-03-05 12:20:29.110 (3) [P23T1]: Inserted/Updated 2 row(s) in `sesystem`.`googleAuthToken` 2014-03-05 12:20:29.154 (3) [P23T1]: (handleCampaigns - original targets) Network target found: GoogleSearch 2014-03-05 12:20:29.154 (3) [P23T1]: (handleCampaigns - original targets) Network target found: SearchNetwork 2014-03-05 12:20:29.163 (3) [P23T1]: (handleCampaigns - original targets) Network target found: GoogleSearch 2014-03-05 12:20:29.163 (3) [P23T1]: (handleCampaigns - original targets) Network target found: SearchNetwork 2014-03-05 12:20:29.164 (3) [P23T1]: CampaignChangeRequest (accountID 370): Sending 2 add requests 2014-03-05 12:20:29.179 (3) [P23T1]: aCurrencyValue(0.016) : aCurrencyCode(USD) 2014-03-05 12:20:29.179 (3) [P23T1]: aCurrencyValue(50.0) : aCurrencyCode(USD) 2014-03-05 12:20:29.179 (3) [P23T1]: aCurrencyValue(0.016) : aCurrencyCode(USD) 2014-03-05 12:20:29.180 (3) [P23T1]: aCurrencyValue(50.0) : aCurrencyCode(USD) 2014-03-05 12:20:29.696 (3) [P23T1]: Budget was successfully added: 182870945 2014-03-05 12:20:30.679 (3) [P23T1]: Budget was successfully added: 182871065 2014-03-05 12:20:31.016 (3) [P23T1]: CampaignDAO(accountID 370) Request contained 2 adds, 0 updates, 0 deletes. 2014-03-05 12:20:31.016 (3) [P23T1]: CampaignDAO(accountID 370) DB updates: 2 items updated, 2 pending changes deleted, 0 pending updates deleted, 0 errors cleared 2014-03-05 12:20:31.041 (3) [P23T1]: CampaignTargetChangeRequest (accountID 370): Sending 2 add requests 2014-03-05 12:20:31.042 (2) [P23T1]: Network target found: GoogleSearch with ID 99 2014-03-05 12:20:31.042 (2) [P23T1]: Network target found: SearchNetwork with ID 100 2014-03-05 12:20:31.042 (2) [P23T1]: Network target found: GoogleSearch with ID 99 2014-03-05 12:20:31.042 (2) [P23T1]: Network target found: SearchNetwork with ID 100 2014-03-05 12:20:31.474 (3) [P23T1]: CampaignTargetDAO(accountID 370) Request contained 2 adds, 0 updates, 0 deletes. 2014-03-05 12:20:31.474 (3) [P23T1]: CampaignTargetDAO(accountID 370) DB updates: 2 items updated, 2 pending changes deleted, 0 pending updates deleted, 0 errors cleared 2014-03-05 12:20:31.476 (1) [P23T1]: aColumnList - column list must be null, string, or collection 2014-03-05 12:20:31.477 (1) [P23T1]: aColumnList - column list must be null, string, or collection 2014-03-05 12:20:31.546 (3) [P23T1]: AdGroupChangeRequest (accountID 370): Sending 1 add requests 2014-03-05 12:20:31.873 (3) [P23T1]: AdGroupDAO(accountID 370) Request contained 1 adds, 0 updates, 0 deletes. 2014-03-05 12:20:31.874 (3) [P23T1]: AdGroupDAO(accountID 370) DB updates: 1 items updated, 1 pending changes deleted, 0 pending updates deleted, 0 errors cleared 2014-03-05 12:20:31.874 (3) [P23T1]: AdGroupChangeRequest (accountID 370): Sending 1 add requests 2014-03-05 12:20:32.181 (3) [P23T1]: AdGroupDAO(accountID 370) Request contained 1 adds, 0 updates, 0 deletes. 2014-03-05 12:20:32.181 (3) [P23T1]: AdGroupDAO(accountID 370) DB updates: 1 items updated, 1 pending changes deleted, 0 pending updates deleted, 0 errors cleared 2014-03-05 12:20:32.194 (3) [pool-59-thread-1]: TextAdChangeRequest (accountID 370): Sending 4 add requests 2014-03-05 12:20:32.211 (3) [pool-59-thread-2]: TextAdChangeRequest (accountID 370): Sending 4 add requests 2014-03-05 12:20:32.830 (3) [pool-59-thread-2]: TextAdDAO(accountID 370) Request contained 4 adds, 0 updates, 0 deletes. 2014-03-05 12:20:32.830 (3) [pool-59-thread-2]: TextAdDAO(accountID 370) DB updates: 4 items updated, 4 pending changes deleted, 0 pending updates deleted, 0 errors cleared 2014-03-05 12:20:32.843 (3) [pool-59-thread-1]: TextAdDAO(accountID 370) Request contained 4 adds, 0 updates, 0 deletes. 2014-03-05 12:20:32.843 (3) [pool-59-thread-1]: TextAdDAO(accountID 370) DB updates: 4 items updated, 4 pending changes deleted, 0 pending updates deleted, 0 errors cleared 2014-03-05 12:20:48.747 (3) [pool-60-thread-1]: KeywordChangeRequest (accountID 370): Sending 93 add requests 2014-03-05 12:20:48.749 (3) [pool-60-thread-2]: KeywordChangeRequest (accountID 370): Sending 57 add requests 2014-03-05 12:20:49.499 (3) [pool-60-thread-2]: KeywordDAO(accountID 370) Request contained 54 adds, 0 updates, 0 deletes. 2014-03-05 12:20:49.499 (3) [pool-60-thread-2]: KeywordDAO(accountID 370) DB updates: 54 items updated, 54 pending changes deleted, 0 pending updates deleted, 0 errors cleared 2014-03-05 12:20:49.504 (3) [pool-60-thread-2]: KeywordDAO(accountID 370): Inserted 3 Errors: Updated 3 pending changes, cleared 0 existing errors. 2014-03-05 12:20:49.504 (2) [pool-60-thread-2]: Google Request Errors for accountID 370(KeywordChangeRequest) Keyword: Bombs,test in California Type: Exact Status: Active id=145437, code=0: CriterionError(reason: KEYWORD_HAS_INVALID_CHARS)(isExemptable: false), trigger=Bombs,test in California, field=operations[4].operand.criterion.text Keyword: Bombs,test California Type: Exact Status: Active id=145436, code=0: CriterionError(reason: KEYWORD_HAS_INVALID_CHARS)(isExemptable: false), trigger=Bombs,test California, field=operations[31].operand.criterion.text Keyword: California Bombs,test Type: Exact Status: Active id=145438, code=0: CriterionError(reason: KEYWORD_HAS_INVALID_CHARS)(isExemptable: false), trigger=California Bombs,test, field=operations[37].operand.criterion.text 2014-03-05 12:20:50.184 (3) [pool-60-thread-1]: KeywordDAO(accountID 370) Request contained 92 adds, 0 updates, 0 deletes. 2014-03-05 12:20:50.185 (3) [pool-60-thread-1]: KeywordDAO(accountID 370) DB updates: 92 items updated, 92 pending changes deleted, 0 pending updates deleted, 0 errors cleared 2014-03-05 12:20:50.189 (3) [pool-60-thread-1]: KeywordDAO(accountID 370): Inserted 1 Errors: Updated 1 pending changes, cleared 0 existing errors. 2014-03-05 12:20:50.189 (2) [pool-60-thread-1]: Google Request Errors for accountID 370(KeywordChangeRequest) Keyword: Bombs,test Type: Exact Status: Active id=145377, code=0: CriterionError(reason: KEYWORD_HAS_INVALID_CHARS)(isExemptable: false), trigger=Bombs,test, field=operations[32].operand.criterion.text 2014-03-05 12:20:50.623 (3) [P23T1]: ... SEUser 368 finished 2014-03-05 12:20:50.623 (3) [pool-3-thread-8]: ------------Google Content Editor done 2014-03-05 12:20:50.679 (3) [pool-3-thread-8]: Ignoring 1 TextAd or keyword errors. 2014-03-05 12:20:50.679 (3) [pool-3-thread-8]: 1646_GT has no applicable GCE errors. 2014-03-05 12:20:50.688 (3) [pool-3-thread-8]: Ignoring 3 TextAd or keyword errors. 2014-03-05 12:20:50.688 (3) [pool-3-thread-8]: 1646_GM has no applicable GCE errors. 2014-03-05 12:20:50.690 (3) [pool-3-thread-8]: Finished DEPLOY request for campaign c9a009ac-480a-4539-86f5-9e0820e68919_10268_57_1646_GT: SUCCEEDED 2014-03-05 12:20:50.692 (3) [pool-3-thread-8]: Finished DEPLOY request for campaign c9a009ac-480a-4539-86f5-9e0820e68919_10268_57_1646_GM: SUCCEEDED 2014-03-05 12:20:50.692 (3) [pool-3-thread-8]: c9a009ac-480a-4539-86f5-9e0820e68919 has 2 campaigns for a SE Update accounts sync. 2014-03-05 12:20:50.692 (3) [pool-3-thread-8]: c9a009ac-480a-4539-86f5-9e0820e68919 has 2 campaigns for a SE Update groups-listings sync. 2014-03-05 12:20:55.096 (3) [Thread-9]: Heartbeat #448 (1394022055088) received in 0.008s 2014-03-05 12:20:55.693 (3) [pool-3-thread-8]: JobExecutor running job [2014-03-05_122050_a370_AccountWorkerProcessResults_syncAccountsGroupsListings_nH4CuwezHt]: /usr/local/tsa/bidmgr/seupdate.sh -d 3 --inactive --accountid 370 --accounts --seaccount 1147,1148 --groups --listings 2014-03-05 12:21:09.447 (3) [pool-3-thread-8]: JobExecutor finished running job [2014-03-05_122050_a370_AccountWorkerProcessResults_syncAccountsGroupsListings_nH4CuwezHt], exit code=0 in 13.650s 2014-03-05 12:21:09.461 (3) [pool-3-thread-8]: JobExecutor finished 2014-03-05_122050_a370_AccountWorkerProcessResults_syncAccountsGroupsListings_nH4CuwezHt. hasError=false, numTries=1 2014-03-05 12:21:09.461 (3) [pool-3-thread-8]: Finished sub-campaign processing for DEPLOY deploymentID (b06b1d9c-17a8-436f-9d2d-10018ed2ecc5). account c9a009ac-480a-4539-86f5-9e0820e68919. 2 submitted, 2 ok. 2014-03-05 12:21:09.462 (3) [pool-3-thread-8]: Updating deployment status to 'Success' for campaignID: 1646 2014-03-05 12:21:09.463 (3) [pool-3-thread-8]: Finished DEPLOY request for c9a009ac-480a-4539-86f5-9e0820e68919_10268_57_1646: SUCCEEDED 2014-03-05 12:21:09.463 (3) [pool-3-thread-8]: Finished DEPLOY request, deploymentID (b06b1d9c-17a8-436f-9d2d-10018ed2ecc5), account c9a009ac-480a-4539-86f5-9e0820e68919 2014-03-05 12:21:09.463 (3) [pool-3-thread-8]: Request removed from map for customerID c9a009ac-480a-4539-86f5-9e0820e68919 2014-03-05 12:21:10.089 (3) [pool-3-thread-8]: Initial campaign deployment for customerID: c9a009ac-480a-4539-86f5-9e0820e68919 2014-03-05 12:21:10.227 (3) [AdMaxListener]: Sent message to response queue. 2014-03-05 12:21:25.097 (3) [Thread-9]: Heartbeat #449 (1394022085088) received in 0.009s 2014-03-05 12:21:55.094 (3) [Thread-9]: Heartbeat #450 (1394022115088) received in 0.006s 2014-03-05 12:22:02.146 (3) [Thread-9]: Request added to map for customerID c9a009ac-480a-4539-86f5-9e0820e68919 2014-03-05 12:22:02.146 (3) [Thread-9]: HighPriorityMessageHandler handling message ID ID:JBM-b25a7f12-42cf-4b37-9b2b-1669dcc56597 2014-03-05 12:22:02.146 (3) [Thread-9]: Request worker created for c9a009ac-480a-4539-86f5-9e0820e68919 2014-03-05 12:22:02.155 (3) [Thread-9]: Submitted executor job for c9a009ac-480a-4539-86f5-9e0820e68919 2014-03-05 12:22:02.161 (3) [Thread-9]: HighPriorityMessageHandler took message ID ID:JBM-b25a7f12-42cf-4b37-9b2b-1669dcc56597 out of queue 2014-03-05 12:22:02.225 (3) [pool-3-thread-8]: Updating deployment status to 'InProgress' for campaignID: 1646 2014-03-05 12:22:02.229 (3) [pool-3-thread-8]: Start processing UPDATE request (b06b1d9c-17a8-436f-9d2d-10018ed2ecc5) for account c9a009ac-480a-4539-86f5-9e0820e68919. 2 campaign(s). 2014-03-05 12:22:02.229 (3) [pool-3-thread-8]: Performing update for account: c9a009ac-480a-4539-86f5-9e0820e68919 ID#370 2014-03-05 12:22:02.244 (3) [pool-3-thread-8]: 2 campaign(s) to update. 2014-03-05 12:22:02.245 (3) [pool-3-thread-8]: 0 campaign(s) to retry and update. 2014-03-05 12:22:02.250 (3) [pool-3-thread-8]: CampaignWorker initialized for account: 370 2014-03-05 12:22:02.250 (3) [pool-3-thread-8]: Updating c9a009ac-480a-4539-86f5-9e0820e68919_10268_57_1646_GM Status: Active 2014-03-05 12:22:02.250 (3) [pool-3-thread-8]: Updating c9a009ac-480a-4539-86f5-9e0820e68919_10268_57_1646_GT Status: Active 2014-03-05 12:22:02.252 (3) [pool-3-thread-8]: CampaignUpdateWorker started... 2014-03-05 12:22:02.272 (3) [pool-3-thread-8]: c9a009ac-480a-4539-86f5-9e0820e68919_10268_57_1646_GT status change (Paused->Active) 2014-03-05 12:22:02.272 (3) [pool-3-thread-8]: No budget update required 2014-03-05 12:22:02.272 (3) [pool-3-thread-8]: c9a009ac-480a-4539-86f5-9e0820e68919_10268_57_1646_GM status change (Paused->Active) 2014-03-05 12:22:02.272 (3) [pool-3-thread-8]: No budget update required 2014-03-05 12:22:02.277 (3) [pool-3-thread-8]: ----------------Google Content Editor starting 2014-03-05 12:22:02.347 (3) [P24T1]: Inserted/Updated 2 row(s) in `sesystem`.`googleAuthToken` 2014-03-05 12:22:02.384 (3) [P24T1]: Inserted/Updated 2 row(s) in `sesystem`.`googleAuthToken` 2014-03-05 12:22:02.414 (3) [P24T1]: (handleCampaigns - original targets) Network target found: GoogleSearch 2014-03-05 12:22:02.414 (3) [P24T1]: (handleCampaigns - original targets) Network target found: SearchNetwork 2014-03-05 12:22:02.416 (3) [P24T1]: (handleCampaigns - original targets) Network target found: GoogleSearch 2014-03-05 12:22:02.416 (3) [P24T1]: (handleCampaigns - original targets) Network target found: SearchNetwork 2014-03-05 12:22:02.417 (3) [P24T1]: CampaignChangeRequest (accountID 370): Sending 2 update requests 2014-03-05 12:22:02.742 (3) [P24T1]: CampaignDAO(accountID 370) Request contained 0 adds, 2 updates, 0 deletes. 2014-03-05 12:22:02.742 (3) [P24T1]: CampaignDAO(accountID 370) DB updates: 2 items updated, 2 pending changes deleted, 2 pending updates deleted, 0 errors cleared 2014-03-05 12:22:02.766 (3) [P24T1]: ... SEUser 368 finished 2014-03-05 12:22:02.766 (3) [pool-3-thread-8]: ------------Google Content Editor done 2014-03-05 12:22:02.789 (3) [pool-3-thread-8]: c9a009ac-480a-4539-86f5-9e0820e68919_10268_57_1646_GT status updated to Active 2014-03-05 12:22:02.791 (3) [pool-3-thread-8]: c9a009ac-480a-4539-86f5-9e0820e68919_10268_57_1646_GM status updated to Active 2014-03-05 12:22:02.792 (3) [pool-3-thread-8]: Campaign structure sync not enabled for this request. 2014-03-05 12:22:02.796 (3) [pool-3-thread-8]: Structure sync disabled, ignoring 1 structure operation errors. 2014-03-05 12:22:02.797 (3) [pool-3-thread-8]: 1646_GT has no applicable GCE errors. 2014-03-05 12:22:02.802 (3) [pool-3-thread-8]: Structure sync disabled, ignoring 3 structure operation errors. 2014-03-05 12:22:02.802 (3) [pool-3-thread-8]: 1646_GM has no applicable GCE errors. 2014-03-05 12:22:02.803 (3) [pool-3-thread-8]: Finished UPDATE request for campaign c9a009ac-480a-4539-86f5-9e0820e68919_10268_57_1646_GM: SUCCEEDED 2014-03-05 12:22:02.804 (3) [pool-3-thread-8]: Finished UPDATE request for campaign c9a009ac-480a-4539-86f5-9e0820e68919_10268_57_1646_GT: SUCCEEDED 2014-03-05 12:22:02.804 (3) [pool-3-thread-8]: c9a009ac-480a-4539-86f5-9e0820e68919 has 0 campaigns for a SE Update accounts sync. 2014-03-05 12:22:02.804 (3) [pool-3-thread-8]: c9a009ac-480a-4539-86f5-9e0820e68919 has 0 campaigns for a SE Update groups-listings sync. 2014-03-05 12:22:02.804 (3) [pool-3-thread-8]: Finished sub-campaign processing for UPDATE deploymentID (b06b1d9c-17a8-436f-9d2d-10018ed2ecc5). account c9a009ac-480a-4539-86f5-9e0820e68919. 2 submitted, 2 ok. 2014-03-05 12:22:02.805 (3) [pool-3-thread-8]: Updating deployment status to 'Success' for campaignID: 1646 2014-03-05 12:22:02.806 (3) [pool-3-thread-8]: Finished UPDATE request for 1646: SUCCEEDED 2014-03-05 12:22:02.806 (3) [pool-3-thread-8]: Finished UPDATE request, deploymentID (b06b1d9c-17a8-436f-9d2d-10018ed2ecc5), account c9a009ac-480a-4539-86f5-9e0820e68919 2014-03-05 12:22:02.806 (3) [pool-3-thread-8]: Request removed from map for customerID c9a009ac-480a-4539-86f5-9e0820e68919 2014-03-05 12:22:03.246 (3) [AdMaxListener]: Sent message to response queue. 2014-03-05 12:22:25.093 (3) [Thread-9]: Heartbeat #451 (1394022145088) received in 0.005s 2014-03-05 12:22:55.094 (3) [Thread-9]: Heartbeat #452 (1394022175088) received in 0.006s 2014-03-05 12:23:25.096 (3) [Thread-9]: Heartbeat #453 (1394022205088) received in 0.008s 2014-03-05 12:23:34.754 (3) [Thread-9]: Request added to map for customerID c9a009ac-480a-4539-86f5-9e0820e68919 2014-03-05 12:23:34.755 (3) [Thread-9]: Request worker created for c9a009ac-480a-4539-86f5-9e0820e68919 2014-03-05 12:23:34.755 (3) [Thread-9]: Submitted executor job for c9a009ac-480a-4539-86f5-9e0820e68919 2014-03-05 12:23:34.816 (3) [pool-3-thread-9]: Updating account tables for c9a009ac-480a-4539-86f5-9e0820e68919 2014-03-05 12:23:34.829 (3) [pool-3-thread-9]: Committing Account settings for 370 2014-03-05 12:23:34.831 (3) [pool-3-thread-9]: Updating deployment status to 'InProgress' for campaignID: 1646 2014-03-05 12:23:34.833 (3) [pool-3-thread-9]: Updating advert budget for c9a009ac-480a-4539-86f5-9e0820e68919_10268_57_1646 2014-03-05 12:23:34.836 (3) [pool-3-thread-9]: Nominal monthly budget was unchanged for AdMax campaign ID: 522 2014-03-05 12:23:34.849 (3) [pool-3-thread-9]: Start processing DEPLOY request (fdedbc91-4d24-4774-85e9-68788be06f6e) for account c9a009ac-480a-4539-86f5-9e0820e68919. 2 campaign(s). 2014-03-05 12:23:34.849 (3) [pool-3-thread-9]: Performing sync for account: c9a009ac-480a-4539-86f5-9e0820e68919 ID#370 2014-03-05 12:23:34.864 (3) [pool-3-thread-9]: 2 campaign(s) to update. 2014-03-05 12:23:34.864 (3) [pool-3-thread-9]: 0 campaign(s) to create. 2014-03-05 12:23:34.864 (3) [pool-3-thread-9]: 0 campaign(s) to retry and update. 2014-03-05 12:23:34.866 (3) [pool-3-thread-9]: CampaignWorker initialized for account: 370 2014-03-05 12:23:34.866 (3) [pool-3-thread-9]: Updating c9a009ac-480a-4539-86f5-9e0820e68919_10268_57_1646_GT Status: Active 2014-03-05 12:23:34.866 (3) [pool-3-thread-9]: Updating c9a009ac-480a-4539-86f5-9e0820e68919_10268_57_1646_GM Status: Active 2014-03-05 12:23:34.867 (3) [pool-3-thread-9]: CampaignUpdateWorker started... 2014-03-05 12:23:34.883 (3) [pool-3-thread-9]: c9a009ac-480a-4539-86f5-9e0820e68919_10268_57_1646_GT is already set to Active in the database. 2014-03-05 12:23:34.883 (3) [pool-3-thread-9]: No budget update required 2014-03-05 12:23:34.883 (3) [pool-3-thread-9]: No update necessary: optimizer settings are the same. 2014-03-05 12:23:34.883 (3) [pool-3-thread-9]: No budget optimizer update required. 2014-03-05 12:23:34.883 (3) [pool-3-thread-9]: c9a009ac-480a-4539-86f5-9e0820e68919_10268_57_1646_GT target sync: 2014-03-05 12:23:34.884 (3) [pool-3-thread-9]: Proximity Target unchanged proximity_32918580,-118483672 26000 (meters) 2014-03-05 12:23:34.884 (3) [pool-3-thread-9]: Proximity Target unchanged proximity_33206428,-119389000 6000 (meters) 2014-03-05 12:23:34.884 (3) [pool-3-thread-9]: Proximity Target unchanged proximity_33206428,-119601784 6000 (meters) 2014-03-05 12:23:34.884 (3) [pool-3-thread-9]: Proximity Target unchanged proximity_33249378,-119463696 10000 (meters) 2014-03-05 12:23:34.884 (3) [pool-3-thread-9]: Proximity Target unchanged proximity_33249378,-119532736 10000 (meters) 2014-03-05 12:23:34.885 (3) [pool-3-thread-9]: Proximity Target unchanged proximity_33292320,-119389000 6000 (meters) 2014-03-05 12:23:34.885 (3) [pool-3-thread-9]: Proximity Target unchanged proximity_33292320,-119601784 6000 (meters) 2014-03-05 12:23:34.885 (3) [pool-3-thread-9]: Proximity Target unchanged proximity_33319142,-118285632 9000 (meters) 2014-03-05 12:23:34.885 (3) [pool-3-thread-9]: Proximity Target unchanged proximity_33319142,-118614808 9000 (meters) 2014-03-05 12:23:34.885 (3) [pool-3-thread-9]: Proximity Target unchanged proximity_33390202,-118401232 17000 (meters) 2014-03-05 12:23:34.885 (3) [pool-3-thread-9]: Proximity Target unchanged proximity_33390202,-118508016 17000 (meters) 2014-03-05 12:23:34.885 (3) [pool-3-thread-9]: Proximity Target unchanged proximity_33461262,-118285632 9000 (meters) 2014-03-05 12:23:34.886 (3) [pool-3-thread-9]: Proximity Target unchanged proximity_33461262,-118614808 9000 (meters) 2014-03-05 12:23:34.886 (3) [pool-3-thread-9]: Proximity Target unchanged proximity_33475570,-119040840 10000 (meters) 2014-03-05 12:23:34.886 (3) [pool-3-thread-9]: Proximity Target unchanged proximity_33713920,-116718912 264000 (meters) 2014-03-05 12:23:34.886 (3) [pool-3-thread-9]: Proximity Target unchanged proximity_33713920,-121894312 264000 (meters) 2014-03-05 12:23:34.886 (3) [pool-3-thread-9]: Proximity Target unchanged proximity_33921328,-119359912 12000 (meters) 2014-03-05 12:23:34.886 (3) [pool-3-thread-9]: Proximity Target unchanged proximity_33921328,-120501696 12000 (meters) 2014-03-05 12:23:34.886 (3) [pool-3-thread-9]: Proximity Target unchanged proximity_34001068,-119534832 19000 (meters) 2014-03-05 12:23:34.887 (3) [pool-3-thread-9]: Proximity Target unchanged proximity_34001068,-119695968 19000 (meters) 2014-03-05 12:23:34.887 (3) [pool-3-thread-9]: Proximity Target unchanged proximity_34001068,-119857120 19000 (meters) 2014-03-05 12:23:34.887 (3) [pool-3-thread-9]: Proximity Target unchanged proximity_34001068,-120018256 19000 (meters) 2014-03-05 12:23:34.887 (3) [pool-3-thread-9]: Proximity Target unchanged proximity_34001068,-120179400 19000 (meters) 2014-03-05 12:23:34.887 (3) [pool-3-thread-9]: Proximity Target unchanged proximity_34001068,-120340552 19000 (meters) 2014-03-05 12:23:34.887 (3) [pool-3-thread-9]: Proximity Target unchanged proximity_34080820,-119359912 12000 (meters) 2014-03-05 12:23:34.887 (3) [pool-3-thread-9]: Proximity Target unchanged proximity_34080820,-120501696 12000 (meters) 2014-03-05 12:23:34.888 (3) [pool-3-thread-9]: Proximity Target unchanged proximity_36084092,-119306608 476000 (meters) 2014-03-05 12:23:34.888 (3) [pool-3-thread-9]: Proximity Target unchanged proximity_37731440,-123054768 15000 (meters) 2014-03-05 12:23:34.888 (3) [pool-3-thread-9]: Proximity Target unchanged proximity_38454260,-119306608 476000 (meters) 2014-03-05 12:23:34.888 (3) [pool-3-thread-9]: Proximity Target unchanged proximity_40824428,-116718912 264000 (meters) 2014-03-05 12:23:34.888 (3) [pool-3-thread-9]: Proximity Target unchanged proximity_40824428,-121894312 264000 (meters) 2014-03-05 12:23:34.888 (3) [pool-3-thread-9]: c9a009ac-480a-4539-86f5-9e0820e68919_10268_57_1646_GT has no updated targets. 2014-03-05 12:23:34.888 (3) [pool-3-thread-9]: c9a009ac-480a-4539-86f5-9e0820e68919_10268_57_1646_GT No site links in message. Skipping site link sync. 2014-03-05 12:23:34.888 (3) [pool-3-thread-9]: c9a009ac-480a-4539-86f5-9e0820e68919_10268_57_1646_GM is already set to Active in the database. 2014-03-05 12:23:34.888 (3) [pool-3-thread-9]: No budget update required 2014-03-05 12:23:34.889 (3) [pool-3-thread-9]: No update necessary: optimizer settings are the same. 2014-03-05 12:23:34.889 (3) [pool-3-thread-9]: No budget optimizer update required. 2014-03-05 12:23:34.889 (3) [pool-3-thread-9]: c9a009ac-480a-4539-86f5-9e0820e68919_10268_57_1646_GM target sync: 2014-03-05 12:23:34.889 (3) [pool-3-thread-9]: c9a009ac-480a-4539-86f5-9e0820e68919_10268_57_1646_GM has no updated targets. 2014-03-05 12:23:34.889 (3) [pool-3-thread-9]: c9a009ac-480a-4539-86f5-9e0820e68919_10268_57_1646_GM No site links in message. Skipping site link sync. 2014-03-05 12:23:34.892 (3) [pool-3-thread-9]: ----------------Google Content Editor starting 2014-03-05 12:23:34.988 (3) [P25T1]: Inserted/Updated 2 row(s) in `sesystem`.`googleAuthToken` 2014-03-05 12:23:35.025 (3) [P25T1]: Inserted/Updated 2 row(s) in `sesystem`.`googleAuthToken` 2014-03-05 12:23:35.056 (2) [P25T1]: CampaignTargetDAO: database is null 2014-03-05 12:23:35.077 (3) [P25T1]: ... SEUser 368 finished 2014-03-05 12:23:35.077 (3) [pool-3-thread-9]: ------------Google Content Editor done 2014-03-05 12:23:35.084 (3) [pool-3-thread-9]: Running content editor replace for accountID 370 2014-03-05 12:23:35.085 (3) [pool-3-thread-9]: ----------------Google Content Editor starting 2014-03-05 12:23:35.127 (3) [P26T1]: Inserted/Updated 2 row(s) in `sesystem`.`googleAuthToken` 2014-03-05 12:23:35.169 (3) [P26T1]: Inserted/Updated 2 row(s) in `sesystem`.`googleAuthToken` 2014-03-05 12:23:35.199 (3) [P26T1]: No deleted adgroups found 2014-03-05 12:23:35.202 (3) [P26T1]: Deletes Pending Change 0 adgroups and adding 0 adgroups. 2014-03-05 12:23:35.323 (3) [P26T1]: No deleted keywords found 2014-03-05 12:23:35.329 (3) [P26T1]: Deleting 0 keywords and adding 0 keywords and Updated 0. 2014-03-05 12:23:35.336 (2) [P26T1]: Exception [SQL Exception running content editor, quitting]:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') and gce_keywordPendingChange.type in ('update', 'delete') and gce_keyword.sear' at line 1 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.Util.getInstance(Util.java:386) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2815) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2458) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2375) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2359) at com.thesearchagency.searchengines.google.contenteditor.dao.criterion.keyword.KeywordDAO.deleteUnregisteredKeywords(KeywordDAO.java:430) at com.thesearchagency.searchengines.google.contenteditor.GoogleContentEditorHelper.replaceKeywords(GoogleContentEditorHelper.java:683) at com.thesearchagency.searchengines.google.contenteditor.GoogleContentEditorHelper.replace(GoogleContentEditorHelper.java:292) at com.thesearchagency.searchengines.google.contenteditor.GoogleContentEditor$SearchEngineUserWorker.handlePreRunActions(GoogleContentEditor.java:1068) at com.thesearchagency.searchengines.google.contenteditor.GoogleContentEditor$SearchEngineUserWorker.run(GoogleContentEditor.java:976) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) 2014-03-05 12:23:35.337 (3) [P26T1]: ... SEUser 368 finished 2014-03-05 12:23:35.337 (3) [pool-3-thread-9]: ------------Google Content Editor done 2014-03-05 12:23:35.353 (3) [pool-3-thread-9]: Ignoring 1 TextAd or keyword errors. 2014-03-05 12:23:35.353 (3) [pool-3-thread-9]: 1646_GT has no applicable GCE errors. 2014-03-05 12:23:35.361 (3) [pool-3-thread-9]: Ignoring 3 TextAd or keyword errors. 2014-03-05 12:23:35.361 (3) [pool-3-thread-9]: 1646_GM has no applicable GCE errors. 2014-03-05 12:23:35.363 (3) [pool-3-thread-9]: Finished DEPLOY request for campaign c9a009ac-480a-4539-86f5-9e0820e68919_10268_57_1646_GT: SUCCEEDED 2014-03-05 12:23:35.364 (3) [pool-3-thread-9]: Finished DEPLOY request for campaign c9a009ac-480a-4539-86f5-9e0820e68919_10268_57_1646_GM: SUCCEEDED 2014-03-05 12:23:35.364 (3) [pool-3-thread-9]: c9a009ac-480a-4539-86f5-9e0820e68919 has 0 campaigns for a SE Update accounts sync. 2014-03-05 12:23:35.364 (3) [pool-3-thread-9]: c9a009ac-480a-4539-86f5-9e0820e68919 has 0 campaigns for a SE Update groups-listings sync. 2014-03-05 12:23:35.364 (3) [pool-3-thread-9]: Finished sub-campaign processing for DEPLOY deploymentID (fdedbc91-4d24-4774-85e9-68788be06f6e). account c9a009ac-480a-4539-86f5-9e0820e68919. 2 submitted, 2 ok. 2014-03-05 12:23:35.365 (3) [pool-3-thread-9]: Updating deployment status to 'Success' for campaignID: 1646 2014-03-05 12:23:35.366 (3) [pool-3-thread-9]: Finished DEPLOY request for c9a009ac-480a-4539-86f5-9e0820e68919_10268_57_1646: SUCCEEDED 2014-03-05 12:23:35.367 (3) [pool-3-thread-9]: Finished DEPLOY request, deploymentID (fdedbc91-4d24-4774-85e9-68788be06f6e), account c9a009ac-480a-4539-86f5-9e0820e68919 2014-03-05 12:23:35.367 (3) [pool-3-thread-9]: Request removed from map for customerID c9a009ac-480a-4539-86f5-9e0820e68919 2014-03-05 12:23:36.291 (3) [AdMaxListener]: Sent message to response queue. 2014-03-05 12:23:55.095 (3) [Thread-9]: Heartbeat #454 (1394022235088) received in 0.007s 2014-03-05 12:24:01.984 (3) [Thread-9]: Request added to map for customerID c9a009ac-480a-4539-86f5-9e0820e68919 2014-03-05 12:24:01.984 (3) [Thread-9]: HighPriorityMessageHandler handling message ID ID:JBM-bc42dccf-c8b5-436a-8f81-6bdfe7b41f2f 2014-03-05 12:24:01.985 (3) [Thread-9]: Request worker created for c9a009ac-480a-4539-86f5-9e0820e68919 2014-03-05 12:24:01.985 (3) [Thread-9]: Submitted executor job for c9a009ac-480a-4539-86f5-9e0820e68919 2014-03-05 12:24:01.995 (3) [Thread-9]: HighPriorityMessageHandler took message ID ID:JBM-bc42dccf-c8b5-436a-8f81-6bdfe7b41f2f out of queue 2014-03-05 12:24:02.024 (3) [pool-3-thread-9]: Updating deployment status to 'InProgress' for campaignID: 1646 2014-03-05 12:24:02.027 (3) [pool-3-thread-9]: Start processing UPDATE request (fdedbc91-4d24-4774-85e9-68788be06f6e) for account c9a009ac-480a-4539-86f5-9e0820e68919. 2 campaign(s). 2014-03-05 12:24:02.028 (3) [pool-3-thread-9]: Performing update for account: c9a009ac-480a-4539-86f5-9e0820e68919 ID#370 2014-03-05 12:24:02.033 (3) [pool-3-thread-9]: 2 campaign(s) to update. 2014-03-05 12:24:02.033 (3) [pool-3-thread-9]: 0 campaign(s) to retry and update. 2014-03-05 12:24:02.035 (3) [pool-3-thread-9]: CampaignWorker initialized for account: 370 2014-03-05 12:24:02.035 (3) [pool-3-thread-9]: Updating c9a009ac-480a-4539-86f5-9e0820e68919_10268_57_1646_GM Status: Active 2014-03-05 12:24:02.035 (3) [pool-3-thread-9]: Updating c9a009ac-480a-4539-86f5-9e0820e68919_10268_57_1646_GT Status: Active 2014-03-05 12:24:02.035 (3) [pool-3-thread-9]: CampaignUpdateWorker started... 2014-03-05 12:24:02.059 (3) [pool-3-thread-9]: c9a009ac-480a-4539-86f5-9e0820e68919_10268_57_1646_GT is already set to Active in the database. 2014-03-05 12:24:02.059 (3) [pool-3-thread-9]: No budget update required 2014-03-05 12:24:02.059 (3) [pool-3-thread-9]: c9a009ac-480a-4539-86f5-9e0820e68919_10268_57_1646_GM is already set to Active in the database. 2014-03-05 12:24:02.059 (3) [pool-3-thread-9]: No budget update required 2014-03-05 12:24:02.059 (3) [pool-3-thread-9]: ----------------Google Content Editor starting 2014-03-05 12:24:02.117 (3) [P27T1]: Inserted/Updated 2 row(s) in `sesystem`.`googleAuthToken` 2014-03-05 12:24:02.168 (3) [P27T1]: Inserted/Updated 2 row(s) in `sesystem`.`googleAuthToken` 2014-03-05 12:24:02.191 (2) [P27T1]: CampaignTargetDAO: database is null 2014-03-05 12:24:02.207 (3) [P27T1]: ... SEUser 368 finished 2014-03-05 12:24:02.208 (3) [pool-3-thread-9]: ------------Google Content Editor done 2014-03-05 12:24:02.209 (3) [pool-3-thread-9]: Campaign structure sync not enabled for this request. 2014-03-05 12:24:02.214 (3) [pool-3-thread-9]: Structure sync disabled, ignoring 1 structure operation errors. 2014-03-05 12:24:02.214 (3) [pool-3-thread-9]: 1646_GT has no applicable GCE errors. 2014-03-05 12:24:02.221 (3) [pool-3-thread-9]: Structure sync disabled, ignoring 3 structure operation errors. 2014-03-05 12:24:02.221 (3) [pool-3-thread-9]: 1646_GM has no applicable GCE errors. 2014-03-05 12:24:02.222 (3) [pool-3-thread-9]: Finished UPDATE request for campaign c9a009ac-480a-4539-86f5-9e0820e68919_10268_57_1646_GM: SUCCEEDED 2014-03-05 12:24:02.223 (3) [pool-3-thread-9]: Finished UPDATE request for campaign c9a009ac-480a-4539-86f5-9e0820e68919_10268_57_1646_GT: SUCCEEDED 2014-03-05 12:24:02.223 (3) [pool-3-thread-9]: c9a009ac-480a-4539-86f5-9e0820e68919 has 0 campaigns for a SE Update accounts sync. 2014-03-05 12:24:02.224 (3) [pool-3-thread-9]: c9a009ac-480a-4539-86f5-9e0820e68919 has 0 campaigns for a SE Update groups-listings sync. 2014-03-05 12:24:02.224 (3) [pool-3-thread-9]: Finished sub-campaign processing for UPDATE deploymentID (fdedbc91-4d24-4774-85e9-68788be06f6e). account c9a009ac-480a-4539-86f5-9e0820e68919. 2 submitted, 2 ok. 2014-03-05 12:24:02.224 (3) [pool-3-thread-9]: Updating deployment status to 'Success' for campaignID: 1646 2014-03-05 12:24:02.225 (3) [pool-3-thread-9]: Finished UPDATE request for 1646: SUCCEEDED 2014-03-05 12:24:02.226 (3) [pool-3-thread-9]: Finished UPDATE request, deploymentID (fdedbc91-4d24-4774-85e9-68788be06f6e), account c9a009ac-480a-4539-86f5-9e0820e68919 2014-03-05 12:24:02.226 (3) [pool-3-thread-9]: Request removed from map for customerID c9a009ac-480a-4539-86f5-9e0820e68919 2014-03-05 12:24:02.304 (3) [AdMaxListener]: Sent message to response queue. 2014-03-05 12:24:25.093 (3) [Thread-9]: Heartbeat #455 (1394022265088) received in 0.005s 2014-03-05 12:24:55.096 (3) [Thread-9]: Heartbeat #456 (1394022295088) received in 0.008s 2014-03-05 12:25:25.093 (3) [Thread-9]: Heartbeat #457 (1394022325088) received in 0.005s 2014-03-05 12:25:55.094 (3) [Thread-9]: Heartbeat #458 (1394022355088) received in 0.005s 2014-03-05 12:26:25.094 (3) [Thread-9]: Heartbeat #459 (1394022385088) received in 0.006s 2014-03-05 12:26:55.093 (3) [Thread-9]: Heartbeat #460 (1394022415088) received in 0.005s 2014-03-05 12:26:55.126 (3) [pool-4-thread-1]: No new jobs to execute for type: [1,2] 2014-03-05 12:26:57.091 (3) [pool-4-thread-2]: No new jobs to execute for type: [4] 2014-03-05 12:26:59.090 (3) [pool-4-thread-1]: No new jobs to execute for type: [6] 2014-03-05 12:27:25.096 (3) [Thread-9]: Heartbeat #461 (1394022445088) received in 0.008s 2014-03-05 12:27:55.093 (3) [Thread-9]: Heartbeat #462 (1394022475088) received in 0.005s 2014-03-05 12:28:25.097 (3) [Thread-9]: Heartbeat #463 (1394022505088) received in 0.008s ^C