2018-08-08 10:20:31.162 (3) [Thread-9]: Heartbeat #114 (1533723631158) received in 0.004s
2018-08-08 10:21:01.161 (3) [Thread-9]: Heartbeat #115 (1533723661158) received in 0.003s
2018-08-08 10:21:18.362 (3) [Thread-9]: Request added to map for customerID 7782a00d-dc22-4770-b0ec-0a3aea79fe57
2018-08-08 10:21:18.362 (3) [Thread-9]: HighPriorityMessageHandler handling message ID ID:JBM-94fa8d05-0305-4662-bf00-b7503a7575e3
2018-08-08 10:21:18.362 (3) [Thread-9]: Request worker created for 7782a00d-dc22-4770-b0ec-0a3aea79fe57
2018-08-08 10:21:18.363 (3) [Thread-9]: Submitted executor job for 7782a00d-dc22-4770-b0ec-0a3aea79fe57
2018-08-08 10:21:18.369 (3) [pool-3-thread-4]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2018-08-08 10:21:18.371 (3) [Thread-9]: HighPriorityMessageHandler took message ID ID:JBM-94fa8d05-0305-4662-bf00-b7503a7575e3 out of queue
2018-08-08 10:21:18.374 (3) [pool-3-thread-4]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2018-08-08 10:21:18.426 (3) [pool-3-thread-4]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2018-08-08 10:21:18.432 (3) [pool-3-thread-4]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2018-08-08 10:21:18.439 (3) [pool-3-thread-4]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2018-08-08 10:21:18.445 (3) [pool-3-thread-4]: Nominal monthly budget was unchanged for AdMax campaign ID: 6829
2018-08-08 10:21:18.445 (3) [pool-3-thread-4]: Terminated budget for admaxCampaignID 6829
2018-08-08 10:21:18.446 (3) [pool-3-thread-4]: AdMaxNominalMonthlyBudgetsDAO.deleteFutureBudget deleting budget for AdMax campaign 6829 on start date 2018-08-09
2018-08-08 10:21:18.446 (3) [pool-3-thread-4]: Deleted tomorrow's budget for admaxCampaignID 6829
2018-08-08 10:21:18.446 (3) [pool-3-thread-4]: Updating deployment status to 'InProgress' for campaignID: 24019
2018-08-08 10:21:18.451 (3) [pool-3-thread-4]: Terminating advert budget for 24019
2018-08-08 10:21:18.452 (3) [pool-3-thread-4]: No active budget exists for AdMax campaign ID: 6829
2018-08-08 10:21:18.457 (3) [pool-3-thread-4]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2018-08-08 10:21:18.457 (3) [pool-3-thread-4]: Start processing UPDATE request (cce7bda7-fd26-41e6-8694-8f697b4c7b41) for account 7782a00d-dc22-4770-b0ec-0a3aea79fe57. 4 campaign(s).
2018-08-08 10:21:18.457 (3) [pool-3-thread-4]: Performing update for account: 7782a00d-dc22-4770-b0ec-0a3aea79fe57 ID#2402
2018-08-08 10:21:18.462 (3) [pool-3-thread-4]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2018-08-08 10:21:18.468 (3) [pool-3-thread-4]: 4 campaign(s) to update.
2018-08-08 10:21:18.468 (3) [pool-3-thread-4]: 0 campaign(s) to retry and update.
2018-08-08 10:21:18.469 (3) [pool-3-thread-4]: Update campaign status for accountID 2402
2018-08-08 10:21:18.469 (3) [pool-3-thread-4]: CampaignWorker initialized for account: 2402
2018-08-08 10:21:18.469 (3) [pool-3-thread-4]: Updating 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24019_S1 Status: Deleted
2018-08-08 10:21:18.469 (3) [pool-3-thread-4]: Updating 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24019_S2 Status: Deleted
2018-08-08 10:21:18.469 (3) [pool-3-thread-4]: Updating 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24019_S3 Status: Deleted
2018-08-08 10:21:18.469 (3) [pool-3-thread-4]: Updating 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24019_S4 Status: Deleted
2018-08-08 10:21:18.469 (3) [pool-3-thread-4]: CampaignUpdateWorker started...
2018-08-08 10:21:18,576 [pool-3-thread-4] DEBUG c.t.s.facebook.FacebookApiUtils - Getting FB properties using distribution service
2018-08-08 10:21:18,576 [pool-3-thread-4] INFO  c.t.s.f.FacebookAccountDeployer - FacebookAccountDeployer:getExistingCampaigns
2018-08-08 10:21:18,579 [pool-3-thread-4] INFO  jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`id` IN (1440,1441,1438,1439)

2018-08-08 10:21:18,581 [pool-3-thread-4] INFO  c.t.s.f.FacebookAccountDeployer - calculating carryover for seuserID 3605
2018-08-08 10:21:18,581 [pool-3-thread-4] INFO  c.t.s.f.FacebookAccountDeployer - Fetching performance data for seuserID 3605 and campaign SEIdentifiers [0645d60bf5ad492a89e28a729af93540, b64dfd43fe5f41678c18a0e120813802, e71cb9746f8c422a9f8a8a3fdb5c861f, d3c16ea4ac9a4e9893b14c63b85d22e8]
2018-08-08 10:21:18.587 (3) [pool-3-thread-4]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2018-08-08 10:21:18,589 [pool-3-thread-4] INFO  jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`tpId` = '0645d60bf5ad492a89e28a729af93540'

2018-08-08 10:21:23,590 [pool-3-thread-4] INFO  c.t.s.c.t.i.s.CampaignServiceClient - Getting TP campaign [0645d60bf5ad492a89e28a729af93540] details for account af25490b19114ab5aa33ce437296a235
2018-08-08 10:21:23,594 [pool-3-thread-4] INFO  o.a.c.i.LoggingOutInterceptor - Outbound Message
---------------------------
ID: 233
Address: https://api.tigerpistol.com/v1/campaigns/0645d60bf5ad492a89e28a729af93540
Http-Method: GET
Content-Type: application/json
Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token IcHjX0XyED53f6ShTWlqq4xbRXkEoiloVA1IXqtU]}
--------------------------------------
2018-08-08 10:21:24,168 [pool-3-thread-4] INFO  o.a.c.i.LoggingInInterceptor - Inbound Message
----------------------------
ID: 233
Response-Code: 200
Encoding: UTF-8
Content-Type: application/json; charset=utf-8
Headers: {Content-Length=[718], content-type=[application/json; charset=utf-8], Date=[Wed, 08 Aug 2018 10:21:23 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]}
Payload: {"variations":[{"index":0,"reviewError":null}],"id":"0645d60bf5ad492a89e28a729af93540","customerId":"af25490b19114ab5aa33ce437296a235","start":"2018-08-08T09:30:00+00:00","end":"2018-09-08T03:59:00+00:00","budget":3104.00,"objective":"website_clicks","displayMargin":1.0,"status":"error","publishPhase":"error","hasError":true,"errorMessage":"You must have a valid payment method associated with your ad account before you can create ads. Please add a payment method.","spend":0.0,"clicks":0,"cpc":null,"ctr":null,"impressions":0,"cpm":null,"leads":0,"cpl":null,"pageLikes":0,"postEngagements":0,"cppl":null,"cppe":null,"reach":0,"videoViews":0,"cpvv":null,"videoAveragePercentViewed":null,"offersSaved":0,"cpos":null}
--------------------------------------
2018-08-08 10:21:24,170 [pool-3-thread-4] INFO  jdbc.sqlonly - INSERT INTO `performance` (`campaignID`, `date`, `status`, `spend`, `clicks`, `impressions`,
`budget`, `startDate`, `endDate`, `lastUpdated`) VALUES (1438,'2018-08-08','error',0.0,0,0,3104,'08/08/2018
09:30:00.000','09/08/2018 03:59:00.000',NOW()) ON DUPLICATE KEY UPDATE `status`=VALUES(`status`),
`spend`=VALUES(`spend`), `clicks`=VALUES(`clicks`), `impressions`=VALUES(`impressions`), `budget`=VALUES(`budget`),
`lastUpdated`=VALUES(`lastUpdated`)

2018-08-08 10:21:24,171 [pool-3-thread-4] INFO  jdbc.sqlonly - SELECT `performance`.`id`, `performance`.`campaignID`, `performance`.`date`, `performance`.`status`,
`performance`.`spend`, `performance`.`clicks`, `performance`.`impressions`, `performance`.`budget`,
`performance`.`startDate`, `performance`.`endDate`, `performance`.`lastUpdated` FROM `campaigns`
JOIN `performance` ON `performance`.`campaignID` = `campaigns`.`id` WHERE `campaigns`.`id`
= 1438 and `performance`.`date` = '2018-08-08'

2018-08-08 10:21:24,172 [pool-3-thread-4] INFO  jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`tpId` = 'b64dfd43fe5f41678c18a0e120813802'

2018-08-08 10:21:29,173 [pool-3-thread-4] INFO  c.t.s.c.t.i.s.CampaignServiceClient - Getting TP campaign [b64dfd43fe5f41678c18a0e120813802] details for account af25490b19114ab5aa33ce437296a235
2018-08-08 10:21:29,176 [pool-3-thread-4] INFO  o.a.c.i.LoggingOutInterceptor - Outbound Message
---------------------------
ID: 234
Address: https://api.tigerpistol.com/v1/campaigns/b64dfd43fe5f41678c18a0e120813802
Http-Method: GET
Content-Type: application/json
Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token IcHjX0XyED53f6ShTWlqq4xbRXkEoiloVA1IXqtU]}
--------------------------------------
2018-08-08 10:21:29,578 [pool-3-thread-4] INFO  o.a.c.i.LoggingInInterceptor - Inbound Message
----------------------------
ID: 234
Response-Code: 200
Encoding: UTF-8
Content-Type: application/json; charset=utf-8
Headers: {Content-Length=[718], content-type=[application/json; charset=utf-8], Date=[Wed, 08 Aug 2018 10:21:29 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]}
Payload: {"variations":[{"index":0,"reviewError":null}],"id":"b64dfd43fe5f41678c18a0e120813802","customerId":"af25490b19114ab5aa33ce437296a235","start":"2018-08-08T09:30:00+00:00","end":"2018-09-08T03:59:00+00:00","budget":3104.00,"objective":"website_clicks","displayMargin":1.0,"status":"error","publishPhase":"error","hasError":true,"errorMessage":"You must have a valid payment method associated with your ad account before you can create ads. Please add a payment method.","spend":0.0,"clicks":0,"cpc":null,"ctr":null,"impressions":0,"cpm":null,"leads":0,"cpl":null,"pageLikes":0,"postEngagements":0,"cppl":null,"cppe":null,"reach":0,"videoViews":0,"cpvv":null,"videoAveragePercentViewed":null,"offersSaved":0,"cpos":null}
--------------------------------------
2018-08-08 10:21:29,580 [pool-3-thread-4] INFO  jdbc.sqlonly - INSERT INTO `performance` (`campaignID`, `date`, `status`, `spend`, `clicks`, `impressions`,
`budget`, `startDate`, `endDate`, `lastUpdated`) VALUES (1439,'2018-08-08','error',0.0,0,0,3104,'08/08/2018
09:30:00.000','09/08/2018 03:59:00.000',NOW()) ON DUPLICATE KEY UPDATE `status`=VALUES(`status`),
`spend`=VALUES(`spend`), `clicks`=VALUES(`clicks`), `impressions`=VALUES(`impressions`), `budget`=VALUES(`budget`),
`lastUpdated`=VALUES(`lastUpdated`)

2018-08-08 10:21:29,581 [pool-3-thread-4] INFO  jdbc.sqlonly - SELECT `performance`.`id`, `performance`.`campaignID`, `performance`.`date`, `performance`.`status`,
`performance`.`spend`, `performance`.`clicks`, `performance`.`impressions`, `performance`.`budget`,
`performance`.`startDate`, `performance`.`endDate`, `performance`.`lastUpdated` FROM `campaigns`
JOIN `performance` ON `performance`.`campaignID` = `campaigns`.`id` WHERE `campaigns`.`id`
= 1439 and `performance`.`date` = '2018-08-08'

2018-08-08 10:21:29,588 [pool-3-thread-4] INFO  jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`tpId` = 'e71cb9746f8c422a9f8a8a3fdb5c861f'

2018-08-08 10:21:31.161 (3) [Thread-9]: Heartbeat #116 (1533723691158) received in 0.003s
2018-08-08 10:21:34,592 [pool-3-thread-4] INFO  c.t.s.c.t.i.s.CampaignServiceClient - Getting TP campaign [e71cb9746f8c422a9f8a8a3fdb5c861f] details for account af25490b19114ab5aa33ce437296a235
2018-08-08 10:21:34,595 [pool-3-thread-4] INFO  o.a.c.i.LoggingOutInterceptor - Outbound Message
---------------------------
ID: 235
Address: https://api.tigerpistol.com/v1/campaigns/e71cb9746f8c422a9f8a8a3fdb5c861f
Http-Method: GET
Content-Type: application/json
Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token IcHjX0XyED53f6ShTWlqq4xbRXkEoiloVA1IXqtU]}
--------------------------------------
2018-08-08 10:21:34,973 [pool-3-thread-4] INFO  o.a.c.i.LoggingInInterceptor - Inbound Message
----------------------------
ID: 235
Response-Code: 200
Encoding: UTF-8
Content-Type: application/json; charset=utf-8
Headers: {Content-Length=[718], content-type=[application/json; charset=utf-8], Date=[Wed, 08 Aug 2018 10:21:34 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]}
Payload: {"variations":[{"index":0,"reviewError":null}],"id":"e71cb9746f8c422a9f8a8a3fdb5c861f","customerId":"af25490b19114ab5aa33ce437296a235","start":"2018-08-08T09:30:00+00:00","end":"2018-09-08T03:59:00+00:00","budget":3104.00,"objective":"website_clicks","displayMargin":1.0,"status":"error","publishPhase":"error","hasError":true,"errorMessage":"You must have a valid payment method associated with your ad account before you can create ads. Please add a payment method.","spend":0.0,"clicks":0,"cpc":null,"ctr":null,"impressions":0,"cpm":null,"leads":0,"cpl":null,"pageLikes":0,"postEngagements":0,"cppl":null,"cppe":null,"reach":0,"videoViews":0,"cpvv":null,"videoAveragePercentViewed":null,"offersSaved":0,"cpos":null}
--------------------------------------
2018-08-08 10:21:34,975 [pool-3-thread-4] INFO  jdbc.sqlonly - INSERT INTO `performance` (`campaignID`, `date`, `status`, `spend`, `clicks`, `impressions`,
`budget`, `startDate`, `endDate`, `lastUpdated`) VALUES (1440,'2018-08-08','error',0.0,0,0,3104,'08/08/2018
09:30:00.000','09/08/2018 03:59:00.000',NOW()) ON DUPLICATE KEY UPDATE `status`=VALUES(`status`),
`spend`=VALUES(`spend`), `clicks`=VALUES(`clicks`), `impressions`=VALUES(`impressions`), `budget`=VALUES(`budget`),
`lastUpdated`=VALUES(`lastUpdated`)

2018-08-08 10:21:34,976 [pool-3-thread-4] INFO  jdbc.sqlonly - SELECT `performance`.`id`, `performance`.`campaignID`, `performance`.`date`, `performance`.`status`,
`performance`.`spend`, `performance`.`clicks`, `performance`.`impressions`, `performance`.`budget`,
`performance`.`startDate`, `performance`.`endDate`, `performance`.`lastUpdated` FROM `campaigns`
JOIN `performance` ON `performance`.`campaignID` = `campaigns`.`id` WHERE `campaigns`.`id`
= 1440 and `performance`.`date` = '2018-08-08'

2018-08-08 10:21:34,977 [pool-3-thread-4] INFO  jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`tpId` = 'd3c16ea4ac9a4e9893b14c63b85d22e8'

2018-08-08 10:21:39,978 [pool-3-thread-4] INFO  c.t.s.c.t.i.s.CampaignServiceClient - Getting TP campaign [d3c16ea4ac9a4e9893b14c63b85d22e8] details for account af25490b19114ab5aa33ce437296a235
2018-08-08 10:21:39,982 [pool-3-thread-4] INFO  o.a.c.i.LoggingOutInterceptor - Outbound Message
---------------------------
ID: 236
Address: https://api.tigerpistol.com/v1/campaigns/d3c16ea4ac9a4e9893b14c63b85d22e8
Http-Method: GET
Content-Type: application/json
Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token IcHjX0XyED53f6ShTWlqq4xbRXkEoiloVA1IXqtU]}
--------------------------------------
2018-08-08 10:21:40,318 [pool-3-thread-4] INFO  o.a.c.i.LoggingInInterceptor - Inbound Message
----------------------------
ID: 236
Response-Code: 200
Encoding: UTF-8
Content-Type: application/json; charset=utf-8
Headers: {Content-Length=[718], content-type=[application/json; charset=utf-8], Date=[Wed, 08 Aug 2018 10:21:40 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]}
Payload: {"variations":[{"index":0,"reviewError":null}],"id":"d3c16ea4ac9a4e9893b14c63b85d22e8","customerId":"af25490b19114ab5aa33ce437296a235","start":"2018-08-08T09:30:00+00:00","end":"2018-09-08T03:59:00+00:00","budget":3104.00,"objective":"website_clicks","displayMargin":1.0,"status":"error","publishPhase":"error","hasError":true,"errorMessage":"You must have a valid payment method associated with your ad account before you can create ads. Please add a payment method.","spend":0.0,"clicks":0,"cpc":null,"ctr":null,"impressions":0,"cpm":null,"leads":0,"cpl":null,"pageLikes":0,"postEngagements":0,"cppl":null,"cppe":null,"reach":0,"videoViews":0,"cpvv":null,"videoAveragePercentViewed":null,"offersSaved":0,"cpos":null}
--------------------------------------
2018-08-08 10:21:40,320 [pool-3-thread-4] INFO  jdbc.sqlonly - INSERT INTO `performance` (`campaignID`, `date`, `status`, `spend`, `clicks`, `impressions`,
`budget`, `startDate`, `endDate`, `lastUpdated`) VALUES (1441,'2018-08-08','error',0.0,0,0,3104,'08/08/2018
09:30:00.000','09/08/2018 03:59:00.000',NOW()) ON DUPLICATE KEY UPDATE `status`=VALUES(`status`),
`spend`=VALUES(`spend`), `clicks`=VALUES(`clicks`), `impressions`=VALUES(`impressions`), `budget`=VALUES(`budget`),
`lastUpdated`=VALUES(`lastUpdated`)

2018-08-08 10:21:40,321 [pool-3-thread-4] INFO  jdbc.sqlonly - SELECT `performance`.`id`, `performance`.`campaignID`, `performance`.`date`, `performance`.`status`,
`performance`.`spend`, `performance`.`clicks`, `performance`.`impressions`, `performance`.`budget`,
`performance`.`startDate`, `performance`.`endDate`, `performance`.`lastUpdated` FROM `campaigns`
JOIN `performance` ON `performance`.`campaignID` = `campaigns`.`id` WHERE `campaigns`.`id`
= 1441 and `performance`.`date` = '2018-08-08'

2018-08-08 10:21:40,323 [pool-3-thread-4] INFO  c.t.s.f.FacebookAccountDeployer - Sucessfully fetched facebook campaign performance data for seuserID 3605, perf data ([TPCampaignPerformanceDTO [theID=141, theCampaignID=1438, theDate=2018-08-08, theStatus=error, theSpend=0.0, theClicks=0, theImpressions=0, theBudget=3104, theStartDate=2018-08-08T09:30:00.000Z, theEndDate=2018-09-08T03:59:00.000Z, theLastUpdated=2018-08-08T10:21:24.000Z], TPCampaignPerformanceDTO [theID=142, theCampaignID=1439, theDate=2018-08-08, theStatus=error, theSpend=0.0, theClicks=0, theImpressions=0, theBudget=3104, theStartDate=2018-08-08T09:30:00.000Z, theEndDate=2018-09-08T03:59:00.000Z, theLastUpdated=2018-08-08T10:21:29.000Z], TPCampaignPerformanceDTO [theID=143, theCampaignID=1440, theDate=2018-08-08, theStatus=error, theSpend=0.0, theClicks=0, theImpressions=0, theBudget=3104, theStartDate=2018-08-08T09:30:00.000Z, theEndDate=2018-09-08T03:59:00.000Z, theLastUpdated=2018-08-08T10:21:34.000Z], TPCampaignPerformanceDTO [theID=144, theCampaignID=1441, theDate=2018-08-08, theStatus=error, theSpend=0.0, theClicks=0, theImpressions=0, theBudget=3104, theStartDate=2018-08-08T09:30:00.000Z, theEndDate=2018-09-08T03:59:00.000Z, theLastUpdated=2018-08-08T10:21:40.000Z]])
2018-08-08 10:21:40,324 [pool-3-thread-4] INFO  c.t.s.f.FacebookAccountDeployer - Processing carryover for campaignID 1438 [seuserID 3605]
2018-08-08 10:21:40,324 [pool-3-thread-4] INFO  c.t.s.f.FacebookAccountDeployer - actual_monthly_budget for campaignID 1438 : 31.04
2018-08-08 10:21:40,324 [pool-3-thread-4] INFO  c.t.s.f.FacebookAccountDeployer - actual_spend for campaignID 1438 : 0.0
2018-08-08 10:21:40,324 [pool-3-thread-4] INFO  c.t.s.f.FacebookAccountDeployer - campaign start date 2018-08-08T05:30:00.000-04:00 America/New_York, end date 2018-09-07T23:59:00.000-04:00 America/New_York, days 31.0, current date 2018-08-08T06:21:40.324-04:00 America/New_York for campaignID 1438
2018-08-08 10:21:40,324 [pool-3-thread-4] INFO  c.t.s.f.FacebookAccountDeployer - campaignID 1438 active for 0 days (num_of_days_active) and 0 hours (num_of_hours_active)
2018-08-08 10:21:40,324 [pool-3-thread-4] INFO  c.t.s.f.FacebookAccountDeployer - daily_budget [actual_monthly_budget / 31.0] for campaignID 1438 : 1.0012903
2018-08-08 10:21:40,324 [pool-3-thread-4] INFO  c.t.s.f.FacebookAccountDeployer - hourly_budget [daily_budget / 24] for campaignID 1438 : 0.04172043
2018-08-08 10:21:40,324 [pool-3-thread-4] INFO  c.t.s.f.FacebookAccountDeployer - expected_daily_spend [daily_budget * num_of_days_active] for campaignID 1438 : 0.0
2018-08-08 10:21:40,324 [pool-3-thread-4] INFO  c.t.s.f.FacebookAccountDeployer - expected_hourly_spend [hourly_budget * num_of_hours_active] for campaignID 1438 : 0.0
2018-08-08 10:21:40,324 [pool-3-thread-4] INFO  c.t.s.f.FacebookAccountDeployer - expected_spend [expected_daily_spend + expected_hourly_spend] for campaignID 1438 : 0.0
2018-08-08 10:21:40,324 [pool-3-thread-4] INFO  c.t.s.f.FacebookAccountDeployer - carryover [expected_spend - actual_spend] for campaignID 1438 : 0.0
2018-08-08 10:21:40,324 [pool-3-thread-4] INFO  c.t.s.f.FacebookAccountDeployer - saving carryover TPCampaignCarryoverDTO [theID=null, theCampaignID=1438, theDate=2018-08-08, theCarryover=0.0, theCarryoverType=normal] for campaignID 1438
2018-08-08 10:21:40,328 [pool-3-thread-4] INFO  jdbc.sqlonly - INSERT INTO `monthlyCarryovers` (`campaignID`, `date`, `carryover`, `type`) VALUES (1438,'2018-08-08',0.0,'normal')
ON DUPLICATE KEY UPDATE `carryover`=VALUES(`carryover`), `type`=VALUES(`type`)

2018-08-08 10:21:40,328 [pool-3-thread-4] INFO  jdbc.sqlonly - SELECT `id`, `campaignID`, `date`, `carryover`, `type` FROM `monthlyCarryovers` WHERE `campaignID`
= 1438 and `date` = '2018-08-08' and `type` = 'normal'

2018-08-08 10:21:40,330 [pool-3-thread-4] INFO  c.t.s.f.FacebookAccountDeployer - Processing carryover for campaignID 1439 [seuserID 3605]
2018-08-08 10:21:40,330 [pool-3-thread-4] INFO  c.t.s.f.FacebookAccountDeployer - actual_monthly_budget for campaignID 1439 : 31.04
2018-08-08 10:21:40,330 [pool-3-thread-4] INFO  c.t.s.f.FacebookAccountDeployer - actual_spend for campaignID 1439 : 0.0
2018-08-08 10:21:40,330 [pool-3-thread-4] INFO  c.t.s.f.FacebookAccountDeployer - campaign start date 2018-08-08T05:30:00.000-04:00 America/New_York, end date 2018-09-07T23:59:00.000-04:00 America/New_York, days 31.0, current date 2018-08-08T06:21:40.330-04:00 America/New_York for campaignID 1439
2018-08-08 10:21:40,330 [pool-3-thread-4] INFO  c.t.s.f.FacebookAccountDeployer - campaignID 1439 active for 0 days (num_of_days_active) and 0 hours (num_of_hours_active)
2018-08-08 10:21:40,330 [pool-3-thread-4] INFO  c.t.s.f.FacebookAccountDeployer - daily_budget [actual_monthly_budget / 31.0] for campaignID 1439 : 1.0012903
2018-08-08 10:21:40,330 [pool-3-thread-4] INFO  c.t.s.f.FacebookAccountDeployer - hourly_budget [daily_budget / 24] for campaignID 1439 : 0.04172043
2018-08-08 10:21:40,330 [pool-3-thread-4] INFO  c.t.s.f.FacebookAccountDeployer - expected_daily_spend [daily_budget * num_of_days_active] for campaignID 1439 : 0.0
2018-08-08 10:21:40,330 [pool-3-thread-4] INFO  c.t.s.f.FacebookAccountDeployer - expected_hourly_spend [hourly_budget * num_of_hours_active] for campaignID 1439 : 0.0
2018-08-08 10:21:40,330 [pool-3-thread-4] INFO  c.t.s.f.FacebookAccountDeployer - expected_spend [expected_daily_spend + expected_hourly_spend] for campaignID 1439 : 0.0
2018-08-08 10:21:40,330 [pool-3-thread-4] INFO  c.t.s.f.FacebookAccountDeployer - carryover [expected_spend - actual_spend] for campaignID 1439 : 0.0
2018-08-08 10:21:40,330 [pool-3-thread-4] INFO  c.t.s.f.FacebookAccountDeployer - saving carryover TPCampaignCarryoverDTO [theID=null, theCampaignID=1439, theDate=2018-08-08, theCarryover=0.0, theCarryoverType=normal] for campaignID 1439
2018-08-08 10:21:40,334 [pool-3-thread-4] INFO  jdbc.sqlonly - INSERT INTO `monthlyCarryovers` (`campaignID`, `date`, `carryover`, `type`) VALUES (1439,'2018-08-08',0.0,'normal')
ON DUPLICATE KEY UPDATE `carryover`=VALUES(`carryover`), `type`=VALUES(`type`)

2018-08-08 10:21:40,334 [pool-3-thread-4] INFO  jdbc.sqlonly - SELECT `id`, `campaignID`, `date`, `carryover`, `type` FROM `monthlyCarryovers` WHERE `campaignID`
= 1439 and `date` = '2018-08-08' and `type` = 'normal'

2018-08-08 10:21:40,336 [pool-3-thread-4] INFO  c.t.s.f.FacebookAccountDeployer - Processing carryover for campaignID 1440 [seuserID 3605]
2018-08-08 10:21:40,336 [pool-3-thread-4] INFO  c.t.s.f.FacebookAccountDeployer - actual_monthly_budget for campaignID 1440 : 31.04
2018-08-08 10:21:40,336 [pool-3-thread-4] INFO  c.t.s.f.FacebookAccountDeployer - actual_spend for campaignID 1440 : 0.0
2018-08-08 10:21:40,336 [pool-3-thread-4] INFO  c.t.s.f.FacebookAccountDeployer - campaign start date 2018-08-08T05:30:00.000-04:00 America/New_York, end date 2018-09-07T23:59:00.000-04:00 America/New_York, days 31.0, current date 2018-08-08T06:21:40.336-04:00 America/New_York for campaignID 1440
2018-08-08 10:21:40,336 [pool-3-thread-4] INFO  c.t.s.f.FacebookAccountDeployer - campaignID 1440 active for 0 days (num_of_days_active) and 0 hours (num_of_hours_active)
2018-08-08 10:21:40,336 [pool-3-thread-4] INFO  c.t.s.f.FacebookAccountDeployer - daily_budget [actual_monthly_budget / 31.0] for campaignID 1440 : 1.0012903
2018-08-08 10:21:40,336 [pool-3-thread-4] INFO  c.t.s.f.FacebookAccountDeployer - hourly_budget [daily_budget / 24] for campaignID 1440 : 0.04172043
2018-08-08 10:21:40,336 [pool-3-thread-4] INFO  c.t.s.f.FacebookAccountDeployer - expected_daily_spend [daily_budget * num_of_days_active] for campaignID 1440 : 0.0
2018-08-08 10:21:40,336 [pool-3-thread-4] INFO  c.t.s.f.FacebookAccountDeployer - expected_hourly_spend [hourly_budget * num_of_hours_active] for campaignID 1440 : 0.0
2018-08-08 10:21:40,336 [pool-3-thread-4] INFO  c.t.s.f.FacebookAccountDeployer - expected_spend [expected_daily_spend + expected_hourly_spend] for campaignID 1440 : 0.0
2018-08-08 10:21:40,336 [pool-3-thread-4] INFO  c.t.s.f.FacebookAccountDeployer - carryover [expected_spend - actual_spend] for campaignID 1440 : 0.0
2018-08-08 10:21:40,336 [pool-3-thread-4] INFO  c.t.s.f.FacebookAccountDeployer - saving carryover TPCampaignCarryoverDTO [theID=null, theCampaignID=1440, theDate=2018-08-08, theCarryover=0.0, theCarryoverType=normal] for campaignID 1440
2018-08-08 10:21:40,341 [pool-3-thread-4] INFO  jdbc.sqlonly - INSERT INTO `monthlyCarryovers` (`campaignID`, `date`, `carryover`, `type`) VALUES (1440,'2018-08-08',0.0,'normal')
ON DUPLICATE KEY UPDATE `carryover`=VALUES(`carryover`), `type`=VALUES(`type`)

2018-08-08 10:21:40,341 [pool-3-thread-4] INFO  jdbc.sqlonly - SELECT `id`, `campaignID`, `date`, `carryover`, `type` FROM `monthlyCarryovers` WHERE `campaignID`
= 1440 and `date` = '2018-08-08' and `type` = 'normal'

2018-08-08 10:21:40,343 [pool-3-thread-4] INFO  c.t.s.f.FacebookAccountDeployer - Processing carryover for campaignID 1441 [seuserID 3605]
2018-08-08 10:21:40,343 [pool-3-thread-4] INFO  c.t.s.f.FacebookAccountDeployer - actual_monthly_budget for campaignID 1441 : 31.04
2018-08-08 10:21:40,343 [pool-3-thread-4] INFO  c.t.s.f.FacebookAccountDeployer - actual_spend for campaignID 1441 : 0.0
2018-08-08 10:21:40,343 [pool-3-thread-4] INFO  c.t.s.f.FacebookAccountDeployer - campaign start date 2018-08-08T05:30:00.000-04:00 America/New_York, end date 2018-09-07T23:59:00.000-04:00 America/New_York, days 31.0, current date 2018-08-08T06:21:40.343-04:00 America/New_York for campaignID 1441
2018-08-08 10:21:40,343 [pool-3-thread-4] INFO  c.t.s.f.FacebookAccountDeployer - campaignID 1441 active for 0 days (num_of_days_active) and 0 hours (num_of_hours_active)
2018-08-08 10:21:40,343 [pool-3-thread-4] INFO  c.t.s.f.FacebookAccountDeployer - daily_budget [actual_monthly_budget / 31.0] for campaignID 1441 : 1.0012903
2018-08-08 10:21:40,343 [pool-3-thread-4] INFO  c.t.s.f.FacebookAccountDeployer - hourly_budget [daily_budget / 24] for campaignID 1441 : 0.04172043
2018-08-08 10:21:40,343 [pool-3-thread-4] INFO  c.t.s.f.FacebookAccountDeployer - expected_daily_spend [daily_budget * num_of_days_active] for campaignID 1441 : 0.0
2018-08-08 10:21:40,343 [pool-3-thread-4] INFO  c.t.s.f.FacebookAccountDeployer - expected_hourly_spend [hourly_budget * num_of_hours_active] for campaignID 1441 : 0.0
2018-08-08 10:21:40,343 [pool-3-thread-4] INFO  c.t.s.f.FacebookAccountDeployer - expected_spend [expected_daily_spend + expected_hourly_spend] for campaignID 1441 : 0.0
2018-08-08 10:21:40,343 [pool-3-thread-4] INFO  c.t.s.f.FacebookAccountDeployer - carryover [expected_spend - actual_spend] for campaignID 1441 : 0.0
2018-08-08 10:21:40,343 [pool-3-thread-4] INFO  c.t.s.f.FacebookAccountDeployer - saving carryover TPCampaignCarryoverDTO [theID=null, theCampaignID=1441, theDate=2018-08-08, theCarryover=0.0, theCarryoverType=normal] for campaignID 1441
2018-08-08 10:21:40,346 [pool-3-thread-4] INFO  jdbc.sqlonly - INSERT INTO `monthlyCarryovers` (`campaignID`, `date`, `carryover`, `type`) VALUES (1441,'2018-08-08',0.0,'normal')
ON DUPLICATE KEY UPDATE `carryover`=VALUES(`carryover`), `type`=VALUES(`type`)

2018-08-08 10:21:40,350 [pool-3-thread-4] INFO  jdbc.sqlonly - SELECT `id`, `campaignID`, `date`, `carryover`, `type` FROM `monthlyCarryovers` WHERE `campaignID`
= 1441 and `date` = '2018-08-08' and `type` = 'normal'

2018-08-08 10:21:40.351 (3) [pool-3-thread-4]: 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24019_S1 status change (Active->Deleted)
2018-08-08 10:21:40.351 (3) [pool-3-thread-4]: Campaign deleted, skipping target sync.
2018-08-08 10:21:40.351 (3) [pool-3-thread-4]: Campaign deleted, skipping call data sync
2018-08-08 10:21:40.351 (3) [pool-3-thread-4]: Campaign deleted, skipping location data sync
2018-08-08 10:21:40.351 (3) [pool-3-thread-4]: 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24019_S2 status change (Active->Deleted)
2018-08-08 10:21:40.351 (3) [pool-3-thread-4]: Campaign deleted, skipping target sync.
2018-08-08 10:21:40.351 (3) [pool-3-thread-4]: Campaign deleted, skipping call data sync
2018-08-08 10:21:40.351 (3) [pool-3-thread-4]: Campaign deleted, skipping location data sync
2018-08-08 10:21:40.351 (3) [pool-3-thread-4]: 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24019_S3 status change (Active->Deleted)
2018-08-08 10:21:40.351 (3) [pool-3-thread-4]: Campaign deleted, skipping target sync.
2018-08-08 10:21:40.351 (3) [pool-3-thread-4]: Campaign deleted, skipping call data sync
2018-08-08 10:21:40.351 (3) [pool-3-thread-4]: Campaign deleted, skipping location data sync
2018-08-08 10:21:40.351 (3) [pool-3-thread-4]: 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24019_S4 status change (Active->Deleted)
2018-08-08 10:21:40.351 (3) [pool-3-thread-4]: Campaign deleted, skipping target sync.
2018-08-08 10:21:40.351 (3) [pool-3-thread-4]: Campaign deleted, skipping call data sync
2018-08-08 10:21:40.351 (3) [pool-3-thread-4]: Campaign deleted, skipping location data sync
2018-08-08 10:21:40.352 (3) [pool-29-thread-1]: Starting Facebook Update Campaign Worker..
2018-08-08 10:21:40,353 [pool-29-thread-1] INFO  c.t.s.f.FacebookAccountDeployer - FBAccountDeployer: updateCampaigns
2018-08-08 10:21:40,355 [pool-29-thread-1] INFO  jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`id` IN (1440,1441,1438,1439)

2018-08-08 10:21:40,358 [pool-29-thread-1] INFO  c.t.s.f.FacebookAccountDeployer - Delete request for 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24019_S1
2018-08-08 10:21:40,358 [pool-29-thread-1] INFO  c.t.s.f.FacebookAccountDeployer - Delete request for 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24019_S2
2018-08-08 10:21:40,358 [pool-29-thread-1] INFO  c.t.s.f.FacebookAccountDeployer - Delete request for 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24019_S3
2018-08-08 10:21:40,358 [pool-29-thread-1] INFO  c.t.s.f.FacebookAccountDeployer - Delete request for 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24019_S4
2018-08-08 10:21:40,358 [pool-29-thread-1] INFO  c.t.s.f.FacebookAccountDeployer - accountID 2402: deleting 4 Facebook campaigns
2018-08-08 10:21:40,361 [pool-29-thread-1] INFO  c.t.s.c.t.i.s.CampaignServiceClient - Updating TP campaign [e71cb9746f8c422a9f8a8a3fdb5c861f] status to [pause] for account af25490b19114ab5aa33ce437296a235
2018-08-08 10:21:40,365 [pool-29-thread-1] INFO  o.a.c.i.LoggingOutInterceptor - Outbound Message
---------------------------
ID: 237
Address: https://api.tigerpistol.com/v1/campaigns/e71cb9746f8c422a9f8a8a3fdb5c861f/pause
Http-Method: POST
Content-Type: application/json
Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token IcHjX0XyED53f6ShTWlqq4xbRXkEoiloVA1IXqtU]}
--------------------------------------
2018-08-08 10:21:40,710 [pool-29-thread-1] INFO  o.a.c.i.LoggingInInterceptor - Inbound Message
----------------------------
ID: 237
Response-Code: 200
Encoding: ISO-8859-1
Content-Type:
Headers: {Content-Length=[0], Date=[Wed, 08 Aug 2018 10:21:40 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]}
--------------------------------------
2018-08-08 10:21:40,711 [pool-29-thread-1] INFO  c.t.s.c.t.i.s.CampaignServiceClient - Updating TP campaign [d3c16ea4ac9a4e9893b14c63b85d22e8] status to [pause] for account af25490b19114ab5aa33ce437296a235
2018-08-08 10:21:40,714 [pool-29-thread-1] INFO  o.a.c.i.LoggingOutInterceptor - Outbound Message
---------------------------
ID: 238
Address: https://api.tigerpistol.com/v1/campaigns/d3c16ea4ac9a4e9893b14c63b85d22e8/pause
Http-Method: POST
Content-Type: application/json
Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token IcHjX0XyED53f6ShTWlqq4xbRXkEoiloVA1IXqtU]}
--------------------------------------
2018-08-08 10:21:41,063 [pool-29-thread-1] INFO  o.a.c.i.LoggingInInterceptor - Inbound Message
----------------------------
ID: 238
Response-Code: 200
Encoding: ISO-8859-1
Content-Type:
Headers: {Content-Length=[0], Date=[Wed, 08 Aug 2018 10:21:40 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]}
--------------------------------------
2018-08-08 10:21:41,063 [pool-29-thread-1] INFO  c.t.s.c.t.i.s.CampaignServiceClient - Updating TP campaign [b64dfd43fe5f41678c18a0e120813802] status to [pause] for account af25490b19114ab5aa33ce437296a235
2018-08-08 10:21:41,066 [pool-29-thread-1] INFO  o.a.c.i.LoggingOutInterceptor - Outbound Message
---------------------------
ID: 239
Address: https://api.tigerpistol.com/v1/campaigns/b64dfd43fe5f41678c18a0e120813802/pause
Http-Method: POST
Content-Type: application/json
Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token IcHjX0XyED53f6ShTWlqq4xbRXkEoiloVA1IXqtU]}
--------------------------------------
2018-08-08 10:21:41,446 [pool-29-thread-1] INFO  o.a.c.i.LoggingInInterceptor - Inbound Message
----------------------------
ID: 239
Response-Code: 200
Encoding: ISO-8859-1
Content-Type:
Headers: {Content-Length=[0], Date=[Wed, 08 Aug 2018 10:21:41 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]}
--------------------------------------
2018-08-08 10:21:41,446 [pool-29-thread-1] INFO  c.t.s.c.t.i.s.CampaignServiceClient - Updating TP campaign [0645d60bf5ad492a89e28a729af93540] status to [pause] for account af25490b19114ab5aa33ce437296a235
2018-08-08 10:21:41,449 [pool-29-thread-1] INFO  o.a.c.i.LoggingOutInterceptor - Outbound Message
---------------------------
ID: 240
Address: https://api.tigerpistol.com/v1/campaigns/0645d60bf5ad492a89e28a729af93540/pause
Http-Method: POST
Content-Type: application/json
Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token IcHjX0XyED53f6ShTWlqq4xbRXkEoiloVA1IXqtU]}
--------------------------------------
2018-08-08 10:21:41,842 [pool-29-thread-1] INFO  o.a.c.i.LoggingInInterceptor - Inbound Message
----------------------------
ID: 240
Response-Code: 200
Encoding: ISO-8859-1
Content-Type:
Headers: {Content-Length=[0], Date=[Wed, 08 Aug 2018 10:21:41 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]}
--------------------------------------
2018-08-08 10:21:41,843 [pool-29-thread-1] INFO  jdbc.sqlonly - DELETE FROM `errors` WHERE `elementName` IN ('7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24019_S1','7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24019_S2','7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24019_S3','7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24019_S4')

2018-08-08 10:21:41,844 [pool-29-thread-1] INFO  c.t.s.client.tp.dao.TPErrorDAO - Removed '4' Previous Errors
2018-08-08 10:21:41,845 [pool-29-thread-1] INFO  jdbc.sqlonly - UPDATE `campaigns` SET `campaigns`.`tpId` = '0645d60bf5ad492a89e28a729af93540', `campaigns`.`name`
= '7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24019_S1', `campaigns`.`status` = 'Deleted',
`campaigns`.`endDate` = '08/08/2018 10:21:40.358', `campaigns`.`lastUpdated` = NOW(), `campaigns`.`json`
= '{"campaign":{"name":"7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24019_S1","status":"Deleted","id":"0645d60bf5ad492a89e28a729af93540","customerId":"af25490b19114ab5aa33ce437296a235","objective":"website_clicks","budget":3104,"start":"2018-08-08T09:30:54.365Z","maxEnd":"2018-08-08T10:21:40.358Z","placement":["desktopfeed","mobilefeed","instagramfeed","rightcolumn"],"details":{"audiences":[{"ageFrom":18,"ageTo":65,"gender":"all","locationTypes":["home","recent"],"demographics":{"life_events":["6003053857372"],"behaviors":["6002714895372"],"family_statuses":["6002714398372"],"home_type":["23842646930010111"],"interests":["6002926108721"]},"locations":[{"type":"city","id":"2533307"}]}],"copies":[{"headline":"Hotel
Rooms Milton VT","body":"Milton VT Guest Rooms. Great Service & Location.","description":"Find
a Hotel","destinationUrl":"http://www.merchantsite.com/"}],"images":["https://aml-qa.s3.us-west-1.amazonaws.com/usa/10002/images/image-10002-5.jpg"],"cta":[{"type":"learn_more"}]}},"searchEngineUserId":3605}'
WHERE `campaigns`.`id` = 1438

2018-08-08 10:21:41,846 [pool-29-thread-1] INFO  jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`id` = 1438

2018-08-08 10:21:41,847 [pool-29-thread-1] INFO  jdbc.sqlonly - UPDATE `campaigns` SET `campaigns`.`tpId` = 'b64dfd43fe5f41678c18a0e120813802', `campaigns`.`name`
= '7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24019_S2', `campaigns`.`status` = 'Deleted',
`campaigns`.`endDate` = '08/08/2018 10:21:40.358', `campaigns`.`lastUpdated` = NOW(), `campaigns`.`json`
= '{"campaign":{"name":"7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24019_S2","status":"Deleted","id":"b64dfd43fe5f41678c18a0e120813802","customerId":"af25490b19114ab5aa33ce437296a235","objective":"website_clicks","budget":3104,"start":"2018-08-08T09:30:54.393Z","maxEnd":"2018-08-08T10:21:40.358Z","placement":["desktopfeed","mobilefeed","instagramfeed","rightcolumn"],"details":{"audiences":[{"ageFrom":18,"ageTo":65,"gender":"all","locationTypes":["home","recent"],"demographics":{"life_events":["6003053857372"],"behaviors":["6002714895372"],"family_statuses":["6002714398372"],"home_type":["23842646930010111"],"interests":["6002926108721"]},"locations":[{"type":"city","id":"2533307"}]}],"copies":[{"headline":"Hotel
Deals","body":"Milton VT Guest Rooms. Find Out Why Guests Love Us!","description":"Hotel -
Milton VT","destinationUrl":"http://www.merchantsite.com/"}],"images":["https://aml-qa.s3.us-west-1.amazonaws.com/usa/10002/images/image-10002-4.jpg"],"cta":[{"type":"learn_more"}]}},"searchEngineUserId":3605}'
WHERE `campaigns`.`id` = 1439

2018-08-08 10:21:41,848 [pool-29-thread-1] INFO  jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`id` = 1439

2018-08-08 10:21:41,849 [pool-29-thread-1] INFO  jdbc.sqlonly - UPDATE `campaigns` SET `campaigns`.`tpId` = 'e71cb9746f8c422a9f8a8a3fdb5c861f', `campaigns`.`name`
= '7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24019_S3', `campaigns`.`status` = 'Deleted',
`campaigns`.`endDate` = '08/08/2018 10:21:40.358', `campaigns`.`lastUpdated` = NOW(), `campaigns`.`json`
= '{"campaign":{"name":"7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24019_S3","status":"Deleted","id":"e71cb9746f8c422a9f8a8a3fdb5c861f","customerId":"af25490b19114ab5aa33ce437296a235","objective":"website_clicks","budget":3104,"start":"2018-08-08T09:30:54.408Z","maxEnd":"2018-08-08T10:21:40.358Z","placement":["desktopfeed","mobilefeed","instagramfeed","rightcolumn"],"details":{"audiences":[{"ageFrom":18,"ageTo":65,"gender":"all","locationTypes":["home","recent"],"demographics":{"life_events":["6003053857372"],"behaviors":["6002714895372"],"family_statuses":["6002714398372"],"home_type":["23842646930010111"],"interests":["6002926108721"]},"locations":[{"type":"city","id":"2533307"}]}],"copies":[{"headline":"Find
a Hotel","body":"Milton VT Guest Rooms. Great Service & Location.","description":"Hotel Rooms
Milton VT","destinationUrl":"http://www.merchantsite.com/"}],"images":["https://aml-qa.s3.us-west-1.amazonaws.com/usa/10002/images/image-10002-3.jpg"],"cta":[{"type":"learn_more"}]}},"searchEngineUserId":3605}'
WHERE `campaigns`.`id` = 1440

2018-08-08 10:21:41,856 [pool-29-thread-1] INFO  jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`id` = 1440

2018-08-08 10:21:41,858 [pool-29-thread-1] INFO  jdbc.sqlonly - UPDATE `campaigns` SET `campaigns`.`tpId` = 'd3c16ea4ac9a4e9893b14c63b85d22e8', `campaigns`.`name`
= '7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24019_S4', `campaigns`.`status` = 'Deleted',
`campaigns`.`endDate` = '08/08/2018 10:21:40.358', `campaigns`.`lastUpdated` = NOW(), `campaigns`.`json`
= '{"campaign":{"name":"7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24019_S4","status":"Deleted","id":"d3c16ea4ac9a4e9893b14c63b85d22e8","customerId":"af25490b19114ab5aa33ce437296a235","objective":"website_clicks","budget":3104,"start":"2018-08-08T09:30:54.427Z","maxEnd":"2018-08-08T10:21:40.358Z","placement":["desktopfeed","mobilefeed","instagramfeed","rightcolumn"],"details":{"audiences":[{"ageFrom":18,"ageTo":65,"gender":"all","locationTypes":["home","recent"],"demographics":{"life_events":["6003053857372"],"behaviors":["6002714895372"],"family_statuses":["6002714398372"],"home_type":["23842646930010111"],"interests":["6002926108721"]},"locations":[{"type":"city","id":"2533307"}]}],"copies":[{"headline":"Hotel
- Milton VT","body":"Milton VT Guest Rooms. Find Out Why Guests Love Us!","description":"Hotel
Deals","destinationUrl":"http://www.merchantsite.com/"}],"images":["https://aml-qa.s3.us-west-1.amazonaws.com/usa/10002/images/image-10002-2.jpg"],"cta":[{"type":"learn_more"}]}},"searchEngineUserId":3605}'
WHERE `campaigns`.`id` = 1441

2018-08-08 10:21:41,859 [pool-29-thread-1] INFO  jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`id` = 1441

2018-08-08 10:21:41.860 (3) [pool-29-thread-1]: Completed Facebook Update Campaign Worker..
2018-08-08 10:21:41.863 (3) [pool-3-thread-4]: 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24019_S1 status updated to Deleted
2018-08-08 10:21:41.865 (3) [pool-3-thread-4]: 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24019_S2 status updated to Deleted
2018-08-08 10:21:41.866 (3) [pool-3-thread-4]: 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24019_S3 status updated to Deleted
2018-08-08 10:21:41.867 (3) [pool-3-thread-4]: 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24019_S4 status updated to Deleted
2018-08-08 10:21:41.867 (3) [pool-3-thread-4]: Campaign structure sync not enabled for this request.
2018-08-08 10:21:41,870 [pool-3-thread-4] INFO  jdbc.sqlonly - SELECT `errors`.`errorJson` FROM `campaigns` JOIN `errors` ON `errors`.`elementName` = `campaigns`.`name`
WHERE `campaigns`.`id` IN (1440)

2018-08-08 10:21:41.871 (3) [pool-3-thread-4]: Ignoring 0 other operation errors for deleted campaign.
2018-08-08 10:21:41.871 (3) [pool-3-thread-4]: 24019_S3 has no applicable GCE errors.
2018-08-08 10:21:41,874 [pool-3-thread-4] INFO  jdbc.sqlonly - SELECT `errors`.`errorJson` FROM `campaigns` JOIN `errors` ON `errors`.`elementName` = `campaigns`.`name`
WHERE `campaigns`.`id` IN (1441)

2018-08-08 10:21:41.875 (3) [pool-3-thread-4]: Ignoring 0 other operation errors for deleted campaign.
2018-08-08 10:21:41.875 (3) [pool-3-thread-4]: 24019_S4 has no applicable GCE errors.
2018-08-08 10:21:41,877 [pool-3-thread-4] INFO  jdbc.sqlonly - SELECT `errors`.`errorJson` FROM `campaigns` JOIN `errors` ON `errors`.`elementName` = `campaigns`.`name`
WHERE `campaigns`.`id` IN (1438)

2018-08-08 10:21:41.879 (3) [pool-3-thread-4]: Ignoring 0 other operation errors for deleted campaign.
2018-08-08 10:21:41.879 (3) [pool-3-thread-4]: 24019_S1 has no applicable GCE errors.
2018-08-08 10:21:41,881 [pool-3-thread-4] INFO  jdbc.sqlonly - SELECT `errors`.`errorJson` FROM `campaigns` JOIN `errors` ON `errors`.`elementName` = `campaigns`.`name`
WHERE `campaigns`.`id` IN (1439)

2018-08-08 10:21:41.883 (3) [pool-3-thread-4]: Ignoring 0 other operation errors for deleted campaign.
2018-08-08 10:21:41.883 (3) [pool-3-thread-4]: 24019_S2 has no applicable GCE errors.
2018-08-08 10:21:41.884 (3) [pool-3-thread-4]: Finished UPDATE request for campaign 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24019_S1: SUCCEEDED (merchant: 7782a00d-dc22-4770-b0ec-0a3aea79fe57)
2018-08-08 10:21:41.884 (3) [pool-3-thread-4]: Finished UPDATE request for campaign 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24019_S2: SUCCEEDED (merchant: 7782a00d-dc22-4770-b0ec-0a3aea79fe57)
2018-08-08 10:21:41.885 (3) [pool-3-thread-4]: Finished UPDATE request for campaign 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24019_S3: SUCCEEDED (merchant: 7782a00d-dc22-4770-b0ec-0a3aea79fe57)
2018-08-08 10:21:41.885 (3) [pool-3-thread-4]: Finished UPDATE request for campaign 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24019_S4: SUCCEEDED (merchant: 7782a00d-dc22-4770-b0ec-0a3aea79fe57)
2018-08-08 10:21:41.885 (3) [pool-3-thread-4]: 7782a00d-dc22-4770-b0ec-0a3aea79fe57 has 0 campaigns for a SE Update accounts sync.
2018-08-08 10:21:41.885 (3) [pool-3-thread-4]: 7782a00d-dc22-4770-b0ec-0a3aea79fe57 has 0 campaigns for a SE Update groups-listings sync.
2018-08-08 10:21:41.885 (3) [pool-3-thread-4]: Finished sub-campaign processing for UPDATE deploymentID (cce7bda7-fd26-41e6-8694-8f697b4c7b41). account 7782a00d-dc22-4770-b0ec-0a3aea79fe57. 4 submitted, 4 ok.
2018-08-08 10:21:41.886 (3) [pool-3-thread-4]: Updating deployment status to 'Success' for campaignID: 24019
2018-08-08 10:21:41.886 (3) [pool-3-thread-4]: Finished UPDATE request for 24019: SUCCEEDED (merchant: 7782a00d-dc22-4770-b0ec-0a3aea79fe57)
2018-08-08 10:21:41.886 (3) [pool-3-thread-4]: Finished UPDATE request, deploymentID (cce7bda7-fd26-41e6-8694-8f697b4c7b41), account 7782a00d-dc22-4770-b0ec-0a3aea79fe57
2018-08-08 10:21:41.886 (3) [pool-3-thread-4]: Request removed from map for customerID 7782a00d-dc22-4770-b0ec-0a3aea79fe57
2018-08-08 10:21:42.877 (3) [AdMaxListener]: Sent message to response queue.
2018-08-08 10:21:44.738 (3) [Thread-9]: Request added to map for customerID 7782a00d-dc22-4770-b0ec-0a3aea79fe57
2018-08-08 10:21:44.738 (3) [Thread-9]: Request worker created for 7782a00d-dc22-4770-b0ec-0a3aea79fe57
2018-08-08 10:21:44.738 (3) [Thread-9]: Submitted executor job for 7782a00d-dc22-4770-b0ec-0a3aea79fe57
2018-08-08 10:21:44.756 (3) [pool-3-thread-4]: Updating account tables for 7782a00d-dc22-4770-b0ec-0a3aea79fe57
2018-08-08 10:21:44.761 (3) [pool-3-thread-4]: Committing Account settings for 2402
2018-08-08 10:21:44.763 (3) [pool-3-thread-4]: Updating deployment status to 'InProgress' for campaignID: 24003
2018-08-08 10:21:44.765 (3) [pool-3-thread-4]: Updating advert budget for 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24003
2018-08-08 10:21:44.767 (3) [pool-3-thread-4]: Nominal monthly budget was unchanged for AdMax campaign ID: 6824
2018-08-08 10:21:44.768 (3) [pool-3-thread-4]: Nominal monthly budget was unchanged for AdMax campaign ID: 6824
2018-08-08 10:21:44.771 (3) [pool-3-thread-4]: Pausing campaign 12628 because budget (4.8387094E-4 ==> 0.0) is less than the minimum allowed budget (0.05)
2018-08-08 10:21:44,771 [pool-3-thread-4] DEBUG c.t.common.SECampaignStatusManager - AdMax campaign budget status not found so using Paused
2018-08-08 10:21:44.775 (3) [pool-3-thread-4]: Pausing campaign 12629 because budget (4.8387094E-4 ==> 0.0) is less than the minimum allowed budget (0.05)
2018-08-08 10:21:44,775 [pool-3-thread-4] DEBUG c.t.common.SECampaignStatusManager - AdMax campaign budget status not found so using Paused
2018-08-08 10:21:44.776 (3) [pool-3-thread-4]: Updating deployment status to 'InProgress' for campaignID: 24031
2018-08-08 10:21:44.777 (3) [pool-3-thread-4]: 24031 has no parent. Creating...
2018-08-08 10:21:44.779 (3) [pool-3-thread-4]: Updating advert budget for 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24031
2018-08-08 10:21:44.787 (3) [pool-3-thread-4]: Updating deployment status to 'InProgress' for campaignID: 24002
2018-08-08 10:21:44.789 (3) [pool-3-thread-4]: Updating advert budget for 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24002
2018-08-08 10:21:44.791 (3) [pool-3-thread-4]: Nominal monthly budget was unchanged for AdMax campaign ID: 6823
2018-08-08 10:21:44.792 (3) [pool-3-thread-4]: Nominal monthly budget was unchanged for AdMax campaign ID: 6823
2018-08-08 10:21:44.796 (3) [pool-3-thread-4]: Pausing campaign 12630 because budget (3.2258063E-4 ==> 0.0) is less than the minimum allowed budget (0.01)
2018-08-08 10:21:44,796 [pool-3-thread-4] DEBUG c.t.common.SECampaignStatusManager - AdMax campaign budget status not found so using Paused
2018-08-08 10:21:44.800 (3) [pool-3-thread-4]: Pausing campaign 12631 because budget (3.2258063E-4 ==> 0.0) is less than the minimum allowed budget (0.01)
2018-08-08 10:21:44,800 [pool-3-thread-4] DEBUG c.t.common.SECampaignStatusManager - AdMax campaign budget status not found so using Paused
2018-08-08 10:21:44.806 (3) [pool-3-thread-4]: Start processing DEPLOY request (cce7bda7-fd26-41e6-8694-8f697b4c7b41) for account 7782a00d-dc22-4770-b0ec-0a3aea79fe57. 8 campaign(s).
2018-08-08 10:21:44.806 (3) [pool-3-thread-4]: Performing sync for account: 7782a00d-dc22-4770-b0ec-0a3aea79fe57 ID#2402
2018-08-08 10:21:44.808 (3) [pool-3-thread-4]: Converted proximity target: latitude: 44.64668 longitude: -73.14753 radius: 24000
Converted lat: 44.64667892456055 lon: -73.14752960205078 radius unit: kilometers radius: 24.0
2018-08-08 10:21:44.814 (3) [pool-3-thread-4]: Converted proximity target: latitude: 44.64668 longitude: -73.14753 radius: 24000
Converted lat: 44646680 lon: -73147528 radius unit: meters radius: 24000
2018-08-08 10:21:44.815 (3) [pool-3-thread-4]: 4 campaign(s) to update.
2018-08-08 10:21:44.815 (3) [pool-3-thread-4]: 4 campaign(s) to create.
2018-08-08 10:21:44.815 (3) [pool-3-thread-4]: 0 campaign(s) to retry and update.
2018-08-08 10:21:44.815 (3) [pool-3-thread-4]: Update campaign status for accountID 2402
2018-08-08 10:21:44.816 (3) [pool-3-thread-4]: CampaignWorker initialized for account: 2402
2018-08-08 10:21:44.816 (3) [pool-3-thread-4]: Updating 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24003_GT Status: Paused
2018-08-08 10:21:44.816 (3) [pool-3-thread-4]: Updating 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24003_GM Status: Paused
2018-08-08 10:21:44.816 (3) [pool-3-thread-4]: Updating 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24002_GT Status: Paused
2018-08-08 10:21:44.816 (3) [pool-3-thread-4]: Updating 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24002_GM Status: Paused
2018-08-08 10:21:44.816 (3) [pool-3-thread-4]: CampaignUpdateWorker started...
2018-08-08 10:21:44,938 [pool-3-thread-4] DEBUG c.t.searchengines.bing.BingApiUtils - Getting Bing properties using distribution service
2018-08-08 10:21:44.938 (3) [pool-3-thread-4]: Retrieving credentials : client id : 869cad8e-f7c6-4854-b1bb-4f7955d142c3 , client secret :YZpgReOeKSmN3uEvwdvpumW , refresh token : MCU8qys*5ivRLB*Ufjm4SYPrFDstjeedAPUwtmhQMd6AejXJqnqtokFR!CI9*!AXxiuWu4*gJltaCOEEnHlFLRb3wH1*dHV7v0Vkb8iCR1qXtWCntG0JQLGUjRtSBbGLmc1OEyYGaL4GRNkyx4o3xSgFUxj9MI8ivtKerxZDvBUdhBCXpoZqEN96GBXQe2ldtXlHDaTVf1XXMM3cV6Nm061sQis2g6EdWRztSI*4VqjtBV8jRlC2CsD2BR8yQdvrk0L6ab0Rr*oKfE9f8rX35cJyjLQopv!FWoFXe6JPPmdGVsYVxmmX7mgT1!BtevrBmR3lqfkCbqGLar4ZfMBHu5!1e4zQUyCq328RT*LgOlX*7
2018-08-08 10:21:44,938 [pool-3-thread-4] INFO  c.t.s.o.core.OAuthServiceComponent - [oauth] Return OAuth credential. Access token = EwAQA3hlBAAUS26g+KHGWHId2M6BBkwqoP+OSdAAASw8rW+eWyiibD6nvjpUqFJfvckYeGLIuL+c9k9e9V22fZxLURtbEVAtjgbCtRe2v7BcFOOZakwTP+JrWimhTsZZZaBtL12Som25E072ke0KtIfgTPJTm3bhJmnZHUmfzNCNzZcPuaGvad1ZsH7kFis88+SlqnXXqNjDcjyVsjgQNx9DuIdb8taJnuLO3Ks6QQLEReWhorlx0BVl9jTzaHP5B6HqQRchnJ9zVujINCjrjnkpQAZoHyxYJ+AJheCbVssbNzUXgibsT2u7AgKRH9JQDCmK/BLVvo5EDIyteVoPQ3ZWRanLtUyvqtAWC+BbZ/6jpueBhEEzTMjP6a1NEVsDZgAACIkr+qINOyck4AFPjBOwNvur4BKzdq/VMW2vm1EWR8uf9GEeV89OpVTg+qIhg2xCWoU+QmFmqBwxgoT6B/KlK9SdlKZe09t5u9w5qwzwegZNTCo3vy+Ks2jeziYNQgsx7x3RbkRUv9jGQ9YFL6d53FtTjvLplhnwV4y2Zx73Pv4B1KdgTJFkmBBOeG2brfSj0v2CTFT7h0E9klaGDXcMUznTDSJQL5BndV3kPYE13nNjjy1sWqWP3UBTVrlR/cT5/ZTm8sxVEJ8zBXEIQxXgMioMkS6PGi3R4qLzfZM/t0CP1UI/ssSaPW6JrE9F3nlLjKXBfU+x8CNYVqWEI6XNLYE6tw/UyrzOzY35HBmrpLG00FrdxK69WVM1qWQ6+RHkhwb6Y9JkPu1xlVPbdSWARCPYuhS6w9cuIfoA9OYbQ1Ehgk+rHG+VVxoFEZyb+m4wJg5S2kbiQ07OIa9aKuoE36vdios3LfLawGleiPe6gy8wPlaBKgfoXbsg6XHyag3y39sDNca5+g15OEL6R+UDoM6AXBdcHsV+N9DTcGJCP6+6dZq0+0CYQGzQGDWcxu7J6M3zT4WMFPErt2AVxK0QBXl12AcdJdKWwJK9B2EY6P3Q9G7anpaAb4aYKOZ/ej2IUIs4JOQHGsRUNTIVAg== for bing (clientID=869cad8e-f7c6-4854-b1bb-4f7955d142c3)
2018-08-08 10:21:44.938 (3) [pool-3-thread-4]: [oauth] Returning access token from OAuth service: EwAQA3hlBAAUS26g+KHGWHId2M6BBkwqoP+OSdAAASw8rW+eWyiibD6nvjpUqFJfvckYeGLIuL+c9k9e9V22fZxLURtbEVAtjgbCtRe2v7BcFOOZakwTP+JrWimhTsZZZaBtL12Som25E072ke0KtIfgTPJTm3bhJmnZHUmfzNCNzZcPuaGvad1ZsH7kFis88+SlqnXXqNjDcjyVsjgQNx9DuIdb8taJnuLO3Ks6QQLEReWhorlx0BVl9jTzaHP5B6HqQRchnJ9zVujINCjrjnkpQAZoHyxYJ+AJheCbVssbNzUXgibsT2u7AgKRH9JQDCmK/BLVvo5EDIyteVoPQ3ZWRanLtUyvqtAWC+BbZ/6jpueBhEEzTMjP6a1NEVsDZgAACIkr+qINOyck4AFPjBOwNvur4BKzdq/VMW2vm1EWR8uf9GEeV89OpVTg+qIhg2xCWoU+QmFmqBwxgoT6B/KlK9SdlKZe09t5u9w5qwzwegZNTCo3vy+Ks2jeziYNQgsx7x3RbkRUv9jGQ9YFL6d53FtTjvLplhnwV4y2Zx73Pv4B1KdgTJFkmBBOeG2brfSj0v2CTFT7h0E9klaGDXcMUznTDSJQL5BndV3kPYE13nNjjy1sWqWP3UBTVrlR/cT5/ZTm8sxVEJ8zBXEIQxXgMioMkS6PGi3R4qLzfZM/t0CP1UI/ssSaPW6JrE9F3nlLjKXBfU+x8CNYVqWEI6XNLYE6tw/UyrzOzY35HBmrpLG00FrdxK69WVM1qWQ6+RHkhwb6Y9JkPu1xlVPbdSWARCPYuhS6w9cuIfoA9OYbQ1Ehgk+rHG+VVxoFEZyb+m4wJg5S2kbiQ07OIa9aKuoE36vdios3LfLawGleiPe6gy8wPlaBKgfoXbsg6XHyag3y39sDNca5+g15OEL6R+UDoM6AXBdcHsV+N9DTcGJCP6+6dZq0+0CYQGzQGDWcxu7J6M3zT4WMFPErt2AVxK0QBXl12AcdJdKWwJK9B2EY6P3Q9G7anpaAb4aYKOZ/ej2IUIs4JOQHGsRUNTIVAg==
2018-08-08 10:21:45,046 [pool-3-thread-4] DEBUG c.t.s.facebook.FacebookApiUtils - Getting FB properties using distribution service
2018-08-08 10:21:45.051 (3) [pool-3-thread-4]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2018-08-08 10:21:45,058 [pool-3-thread-4] INFO  c.t.s.f.FacebookAccountDeployer - FacebookAccountDeployer:getExistingCampaigns
2018-08-08 10:21:45,058 [pool-3-thread-4] INFO  c.t.s.bing.BingAccountDeployer - BingAccountDeployer:getExistingCampaigns
2018-08-08 10:21:45,059 [pool-3-thread-4] INFO  jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`id` IN (4796,4797)

2018-08-08 10:21:45.062 (3) [pool-3-thread-4]: 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24002_GT is already set to Paused in the database.
2018-08-08 10:21:45.062 (3) [pool-3-thread-4]: 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24002_GT has no updated searchNetworkTargeting.
2018-08-08 10:21:45.062 (3) [pool-3-thread-4]: 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24002_GT target sync starting...
2018-08-08 10:21:45.062 (3) [pool-3-thread-4]: Platform Target unchanged platform_HighEndMobile 2.0
2018-08-08 10:21:45.062 (3) [pool-3-thread-4]: Platform Target unchanged platform_Tablet 4.0
2018-08-08 10:21:45.062 (3) [pool-3-thread-4]: Platform Target unchanged platform_Desktop 3.0
2018-08-08 10:21:45.062 (3) [pool-3-thread-4]: Proximity Target unchanged proximity_44646680,-73147528 24000 (meters)
2018-08-08 10:21:45.062 (3) [pool-3-thread-4]: 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24002_GT has no updated targets.
2018-08-08 10:21:45.062 (3) [pool-3-thread-4]: 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24002_GM is already set to Paused in the database.
2018-08-08 10:21:45.062 (3) [pool-3-thread-4]: 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24002_GM has no updated searchNetworkTargeting.
2018-08-08 10:21:45.062 (3) [pool-3-thread-4]: 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24002_GM target sync starting...
2018-08-08 10:21:45.062 (3) [pool-3-thread-4]: Platform Target unchanged platform_HighEndMobile 2.0
2018-08-08 10:21:45.062 (3) [pool-3-thread-4]: Platform Target unchanged platform_Tablet 4.0
2018-08-08 10:21:45.062 (3) [pool-3-thread-4]: Platform Target unchanged platform_Desktop 3.0
2018-08-08 10:21:45.062 (3) [pool-3-thread-4]: 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24002_GM has no updated targets.
2018-08-08 10:21:45.062 (3) [pool-3-thread-4]: 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24003_GT is already set to Paused in the database.
2018-08-08 10:21:45.062 (3) [pool-3-thread-4]: 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24003_GT has no updated searchNetworkTargeting.
2018-08-08 10:21:45.062 (3) [pool-3-thread-4]: 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24003_GT target sync starting...
2018-08-08 10:21:45.062 (3) [pool-3-thread-4]: Ignoring new target language_en
2018-08-08 10:21:45.062 (3) [pool-3-thread-4]: Ignoring new target network_GoogleSearch
2018-08-08 10:21:45.062 (3) [pool-3-thread-4]: Ignoring new target network_SearchNetwork
2018-08-08 10:21:45.062 (3) [pool-3-thread-4]: Platform Target unchanged platform_HighEndMobile 200.0
2018-08-08 10:21:45.062 (3) [pool-3-thread-4]: Platform Target unchanged platform_Tablet 400.0
2018-08-08 10:21:45.062 (3) [pool-3-thread-4]: Platform Target unchanged platform_Desktop 300.0
2018-08-08 10:21:45.062 (3) [pool-3-thread-4]: Proximity Target unchanged proximity_44.64667892456055,-73.14752960205078 24.0 (kilometers)
2018-08-08 10:21:45.062 (3) [pool-3-thread-4]: 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24003_GT has no updated targets.
2018-08-08 10:21:45.062 (3) [pool-3-thread-4]: 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24003_GM is already set to Paused in the database.
2018-08-08 10:21:45.062 (3) [pool-3-thread-4]: 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24003_GM has no updated searchNetworkTargeting.
2018-08-08 10:21:45.063 (3) [pool-3-thread-4]: 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24003_GM target sync starting...
2018-08-08 10:21:45.063 (3) [pool-3-thread-4]: Ignoring new target language_en
2018-08-08 10:21:45.063 (3) [pool-3-thread-4]: Ignoring new target network_GoogleSearch
2018-08-08 10:21:45.063 (3) [pool-3-thread-4]: Ignoring new target network_SearchNetwork
2018-08-08 10:21:45.063 (3) [pool-3-thread-4]: Platform Target unchanged platform_HighEndMobile 200.0
2018-08-08 10:21:45.063 (3) [pool-3-thread-4]: Platform Target unchanged platform_Tablet 400.0
2018-08-08 10:21:45.063 (3) [pool-3-thread-4]: Platform Target unchanged platform_Desktop 300.0
2018-08-08 10:21:45.063 (3) [pool-3-thread-4]: 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24003_GM has no updated targets.
2018-08-08 10:21:45.064 (3) [pool-30-thread-1]: Starting Google Update Campaign Worker..
2018-08-08 10:21:45.067 (3) [pool-30-thread-2]: Starting Facebook Update Campaign Worker..
2018-08-08 10:21:45.067 (3) [pool-30-thread-2]: Completed Facebook Update Campaign Worker..
2018-08-08 10:21:45.067 (3) [pool-30-thread-1]: Begining the diff for sitelinks.
2018-08-08 10:21:45.069 (3) [pool-30-thread-3]: Starting Bing Update Campaign Worker..
2018-08-08 10:21:45.069 (3) [pool-30-thread-3]: Completed Bing Update Campaign Worker..
2018-08-08 10:21:45.069 (3) [pool-30-thread-1]: Site links to be added: 0
2018-08-08 10:21:45.069 (3) [pool-30-thread-1]: Site links to be removed: 0
2018-08-08 10:21:45.069 (3) [pool-30-thread-1]: Begining the diff for callouts.
2018-08-08 10:21:45.071 (3) [pool-30-thread-1]: Callouts to be added: 0
2018-08-08 10:21:45.071 (3) [pool-30-thread-1]: Callouts to be removed: 0
2018-08-08 10:21:45.074 (3) [pool-30-thread-1]: Begining the diff for sitelinks.
2018-08-08 10:21:45.076 (3) [pool-30-thread-1]: Site links to be added: 0
2018-08-08 10:21:45.076 (3) [pool-30-thread-1]: Site links to be removed: 0
2018-08-08 10:21:45.076 (3) [pool-30-thread-1]: Begining the diff for callouts.
2018-08-08 10:21:45.078 (3) [pool-30-thread-1]: Callouts to be added: 0
2018-08-08 10:21:45.078 (3) [pool-30-thread-1]: Callouts to be removed: 0
2018-08-08 10:21:45.080 (3) [pool-30-thread-1]: ----------------Google Content Editor starting
2018-08-08 10:21:45.085 (3) [pool-30-thread-1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2018-08-08 10:21:45.090 (3) [P9T1]: DistributionServiceRemoteClient created for 7782a00d-dc22-4770-b0ec-0a3aea79fe57_2_qa4amltest_FB_BM_01
2018-08-08 10:21:45.193 (3) [P9T1]: Creating API for reseller DistributionSettings b8a7d340-30e0-4369-97d0-8f901d238f86
2018-08-08 10:21:45.200 (3) [P9T1]: Retrieving credentials for search engine user id : 3606 || client id : 627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com , client secret :uO1pQj_ihl6Jy1fSA7FzCTFE , refresh token : 1/XElVvzhFJlFc7FcqtcZJbj1-erQxMLsEVlrN60XCc4JMrEt0pnthZ_A8mZru5Ei4
2018-08-08 10:21:45,200 [P9T1] INFO  c.t.s.o.core.OAuthServiceComponent - [oauth] Return OAuth credential. Access token = ya29.Gl3zBYr9QBwmMOD6WvNhLpbtWQyO49XTHJCpJDsmjqFOFb9bn397RotEN6JIqLrEQKe7Cfxb_BZux9Ak91sJKH2QCbpSxQ8NN-lUwxfbzh58rLWSlelQCAsx-Unr5PI for adwords (clientID=627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com)
2018-08-08 10:21:45.200 (3) [P9T1]: [oauth] Returning access token from OAuth service: ya29.Gl3zBYr9QBwmMOD6WvNhLpbtWQyO49XTHJCpJDsmjqFOFb9bn397RotEN6JIqLrEQKe7Cfxb_BZux9Ak91sJKH2QCbpSxQ8NN-lUwxfbzh58rLWSlelQCAsx-Unr5PI
2018-08-08 10:21:45.200 (3) [P9T1]: Retrieving credentials for search engine user id : 3606 || client id : 627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com , client secret :uO1pQj_ihl6Jy1fSA7FzCTFE , refresh token : 1/XElVvzhFJlFc7FcqtcZJbj1-erQxMLsEVlrN60XCc4JMrEt0pnthZ_A8mZru5Ei4
2018-08-08 10:21:45,201 [P9T1] INFO  c.t.s.o.core.OAuthServiceComponent - [oauth] Return OAuth credential. Access token = ya29.Gl3zBYr9QBwmMOD6WvNhLpbtWQyO49XTHJCpJDsmjqFOFb9bn397RotEN6JIqLrEQKe7Cfxb_BZux9Ak91sJKH2QCbpSxQ8NN-lUwxfbzh58rLWSlelQCAsx-Unr5PI for adwords (clientID=627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com)
2018-08-08 10:21:45.201 (3) [P9T1]: [oauth] Returning access token from OAuth service: ya29.Gl3zBYr9QBwmMOD6WvNhLpbtWQyO49XTHJCpJDsmjqFOFb9bn397RotEN6JIqLrEQKe7Cfxb_BZux9Ak91sJKH2QCbpSxQ8NN-lUwxfbzh58rLWSlelQCAsx-Unr5PI
2018-08-08 10:21:45.201 (3) [P9T1]: DistributionServiceRemoteClient created for GMB
2018-08-08 10:21:45.216 (3) [P9T1]: Retrieving GMB credentials for search engine user id : 3606 || client id : 627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com , client secret :uO1pQj_ihl6Jy1fSA7FzCTFE , refresh token : 1/fH9q5og0rO9LI5NBJqM4k_YTHb-0XSo2-Qv53oyo5a0
2018-08-08 10:21:45,216 [P9T1] INFO  c.t.s.o.core.OAuthServiceComponent - [oauth] Return OAuth credential. Access token = ya29.Gl3zBT9UPnSb8zwTZdDOaABAwsEn6CRsSh2UtDtma77Kp3dQ3dFh_BG1ZlWAqnhyvT3p0mdBO9i0JvL2CE-LiJYcSsyxW14StKmHMTwdYe4VjFNL8xviC8kmsXVq2mI for gmb (clientID=627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com)
2018-08-08 10:21:45.217 (3) [P9T1]: DistributionServiceRemoteClient created for 7782a00d-dc22-4770-b0ec-0a3aea79fe57_2_qa4amltest_FB_BM_01
2018-08-08 10:21:45.322 (3) [P9T1]: Creating API for reseller DistributionSettings b8a7d340-30e0-4369-97d0-8f901d238f86
2018-08-08 10:21:45.323 (3) [P9T1]: Retrieving credentials for search engine user id : 3606 || client id : 627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com , client secret :uO1pQj_ihl6Jy1fSA7FzCTFE , refresh token : 1/XElVvzhFJlFc7FcqtcZJbj1-erQxMLsEVlrN60XCc4JMrEt0pnthZ_A8mZru5Ei4
2018-08-08 10:21:45,323 [P9T1] INFO  c.t.s.o.core.OAuthServiceComponent - [oauth] Return OAuth credential. Access token = ya29.Gl3zBYr9QBwmMOD6WvNhLpbtWQyO49XTHJCpJDsmjqFOFb9bn397RotEN6JIqLrEQKe7Cfxb_BZux9Ak91sJKH2QCbpSxQ8NN-lUwxfbzh58rLWSlelQCAsx-Unr5PI for adwords (clientID=627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com)
2018-08-08 10:21:45.323 (3) [P9T1]: [oauth] Returning access token from OAuth service: ya29.Gl3zBYr9QBwmMOD6WvNhLpbtWQyO49XTHJCpJDsmjqFOFb9bn397RotEN6JIqLrEQKe7Cfxb_BZux9Ak91sJKH2QCbpSxQ8NN-lUwxfbzh58rLWSlelQCAsx-Unr5PI
2018-08-08 10:21:45.323 (3) [P9T1]: Retrieving credentials for search engine user id : 3606 || client id : 627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com , client secret :uO1pQj_ihl6Jy1fSA7FzCTFE , refresh token : 1/XElVvzhFJlFc7FcqtcZJbj1-erQxMLsEVlrN60XCc4JMrEt0pnthZ_A8mZru5Ei4
2018-08-08 10:21:45,323 [P9T1] INFO  c.t.s.o.core.OAuthServiceComponent - [oauth] Return OAuth credential. Access token = ya29.Gl3zBYr9QBwmMOD6WvNhLpbtWQyO49XTHJCpJDsmjqFOFb9bn397RotEN6JIqLrEQKe7Cfxb_BZux9Ak91sJKH2QCbpSxQ8NN-lUwxfbzh58rLWSlelQCAsx-Unr5PI for adwords (clientID=627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com)
2018-08-08 10:21:45.323 (3) [P9T1]: [oauth] Returning access token from OAuth service: ya29.Gl3zBYr9QBwmMOD6WvNhLpbtWQyO49XTHJCpJDsmjqFOFb9bn397RotEN6JIqLrEQKe7Cfxb_BZux9Ak91sJKH2QCbpSxQ8NN-lUwxfbzh58rLWSlelQCAsx-Unr5PI
2018-08-08 10:21:45.323 (3) [P9T1]: DistributionServiceRemoteClient created for GMB
2018-08-08 10:21:45.344 (3) [P9T1]: Retrieving GMB credentials for search engine user id : 3606 || client id : 627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com , client secret :uO1pQj_ihl6Jy1fSA7FzCTFE , refresh token : 1/fH9q5og0rO9LI5NBJqM4k_YTHb-0XSo2-Qv53oyo5a0
2018-08-08 10:21:45,344 [P9T1] INFO  c.t.s.o.core.OAuthServiceComponent - [oauth] Return OAuth credential. Access token = ya29.Gl3zBT9UPnSb8zwTZdDOaABAwsEn6CRsSh2UtDtma77Kp3dQ3dFh_BG1ZlWAqnhyvT3p0mdBO9i0JvL2CE-LiJYcSsyxW14StKmHMTwdYe4VjFNL8xviC8kmsXVq2mI for gmb (clientID=627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com)
2018-08-08 10:21:45.357 (2) [P9T1]: CampaignTargetDAO: database is null
2018-08-08 10:21:45.368 (3) [P9T1]: ... SEUser 3606 finished
2018-08-08 10:21:45.368 (3) [pool-30-thread-1]: ------------Google Content Editor done
2018-08-08 10:21:45.368 (3) [pool-30-thread-1]: Completed Google Update Campaign Worker..
2018-08-08 10:21:45.371 (3) [pool-3-thread-4]: Running content editor replace for accountID 2402
2018-08-08 10:21:45.372 (3) [pool-33-thread-1]: Starting Google Replace Campaigns Worker..
2018-08-08 10:21:45.372 (3) [pool-33-thread-1]: ----------------Google Content Editor starting
2018-08-08 10:21:45.377 (3) [pool-33-thread-3]: Starting Bing Replace Campaigns Worker..
2018-08-08 10:21:45,378 [pool-33-thread-3] INFO  c.t.s.bing.BingAccountDeployer - BingAccountDeployer::replaceCampaigns for accountID 2402
2018-08-08 10:21:45,379 [pool-33-thread-3] DEBUG c.t.s.bing.BingAccountDeployer - Bing currencyCode USD for accountID 2402
2018-08-08 10:21:45.380 (3) [pool-33-thread-1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2018-08-08 10:21:45,381 [pool-33-thread-3] INFO  jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`id` = 4796

2018-08-08 10:21:45.382 (3) [P10T1]: DistributionServiceRemoteClient created for 7782a00d-dc22-4770-b0ec-0a3aea79fe57_2_qa4amltest_FB_BM_01
2018-08-08 10:21:45.385 (2) [pool-33-thread-3]: BingAccountDeployer.getInitialBid - Budget (0.05) is less than min CPC (0.05), budget will be used as the initial bid
2018-08-08 10:21:45,385 [pool-33-thread-3] INFO  c.t.s.b.BingAccountStructureMapper - CampaignTarget [type=language, code=en, exclude=false, id=0, criterionId=null, bidModifier=null]
2018-08-08 10:21:45,386 [pool-33-thread-3] INFO  c.t.s.b.BingAccountStructureMapper - CampaignTarget [type=network, code=GoogleSearch, exclude=false, id=0, criterionId=null, bidModifier=null]
2018-08-08 10:21:45,386 [pool-33-thread-3] INFO  c.t.s.b.BingAccountStructureMapper - CampaignTarget [type=network, code=SearchNetwork, exclude=false, id=0, criterionId=null, bidModifier=null]
2018-08-08 10:21:45,386 [pool-33-thread-3] INFO  c.t.s.b.BingAccountStructureMapper - CampaignTarget [type=platform, code=HighEndMobile, exclude=false, id=0, criterionId=null, bidModifier=200.0]
2018-08-08 10:21:45,386 [pool-33-thread-3] INFO  c.t.s.b.BingAccountStructureMapper - CampaignTarget [type=platform, code=Tablet, exclude=false, id=0, criterionId=null, bidModifier=400.0]
2018-08-08 10:21:45,386 [pool-33-thread-3] INFO  c.t.s.b.BingAccountStructureMapper - CampaignTarget [type=platform, code=Desktop, exclude=false, id=0, criterionId=null, bidModifier=300.0]
2018-08-08 10:21:45,386 [pool-33-thread-3] INFO  c.t.s.b.BingAccountStructureMapper - CampaignTarget [type=proximity, code=44.64667892456055,-73.14752960205078, exclude=false, id=0, criterionId=null, bidModifier=null]
2018-08-08 10:21:45,386 [pool-33-thread-3] INFO  c.t.s.b.BingAccountStructureMapper - BingCampaignTarget [[BingCampaignTarget [theId=null, theCampaignId=0, theBingTarget=BingDeviceTarget [theCode=Smartphones], theBidMultiplier=200.0], BingCampaignTarget [theId=null, theCampaignId=0, theBingTarget=BingDeviceTarget [theCode=Tablets], theBidMultiplier=400.0], BingCampaignTarget [theId=null, theCampaignId=0, theBingTarget=BingDeviceTarget [theCode=Computers], theBidMultiplier=300.0], BingCampaignTarget [theId=null, theCampaignId=0, theBingTarget=BingRadiusTargetBid [BingTarget [theCode=44.64667892456055,-73.14752960205078, theType=RadiusCriterion], theLatitudeDegrees=44.64667892456055, theLongitudeDegrees=-73.14752960205078, theRadius=24, theBingRadiusUnit=Kilometers], theBidMultiplier=null]]]
2018-08-08 10:21:45,387 [pool-33-thread-3] INFO  jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`id` = 4797

2018-08-08 10:21:45.390 (2) [pool-33-thread-3]: BingAccountDeployer.getInitialBid - Budget (0.05) is less than min CPC (0.05), budget will be used as the initial bid
2018-08-08 10:21:45,390 [pool-33-thread-3] INFO  c.t.s.b.BingAccountStructureMapper - CampaignTarget [type=language, code=en, exclude=false, id=0, criterionId=null, bidModifier=null]
2018-08-08 10:21:45,390 [pool-33-thread-3] INFO  c.t.s.b.BingAccountStructureMapper - CampaignTarget [type=network, code=GoogleSearch, exclude=false, id=0, criterionId=null, bidModifier=null]
2018-08-08 10:21:45,390 [pool-33-thread-3] INFO  c.t.s.b.BingAccountStructureMapper - CampaignTarget [type=network, code=SearchNetwork, exclude=false, id=0, criterionId=null, bidModifier=null]
2018-08-08 10:21:45,390 [pool-33-thread-3] INFO  c.t.s.b.BingAccountStructureMapper - CampaignTarget [type=platform, code=HighEndMobile, exclude=false, id=0, criterionId=null, bidModifier=200.0]
2018-08-08 10:21:45,390 [pool-33-thread-3] INFO  c.t.s.b.BingAccountStructureMapper - CampaignTarget [type=platform, code=Tablet, exclude=false, id=0, criterionId=null, bidModifier=400.0]
2018-08-08 10:21:45,390 [pool-33-thread-3] INFO  c.t.s.b.BingAccountStructureMapper - CampaignTarget [type=platform, code=Desktop, exclude=false, id=0, criterionId=null, bidModifier=300.0]
2018-08-08 10:21:45,390 [pool-33-thread-3] INFO  c.t.s.b.BingAccountStructureMapper - CampaignTarget [type=state, code=Vermont|United States, exclude=false, id=0, criterionId=4131, bidModifier=null]
2018-08-08 10:21:45,390 [pool-33-thread-3] INFO  c.t.s.b.BingAccountStructureMapper - BingCampaignTarget [[BingCampaignTarget [theId=null, theCampaignId=0, theBingTarget=BingDeviceTarget [theCode=Smartphones], theBidMultiplier=200.0], BingCampaignTarget [theId=null, theCampaignId=0, theBingTarget=BingDeviceTarget [theCode=Tablets], theBidMultiplier=400.0], BingCampaignTarget [theId=null, theCampaignId=0, theBingTarget=BingDeviceTarget [theCode=Computers], theBidMultiplier=300.0], BingCampaignTarget [theId=null, theCampaignId=0, theBingTarget=BingLocationTarget [theLocationType=State, theLocationID=4131, theDisplayName=Vermont|United States], theBidMultiplier=null]]]
2018-08-08 10:21:45,392 [pool-33-thread-3] INFO  jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`id` IN (4796,4797)

2018-08-08 10:21:45,394 [pool-33-thread-3] INFO  c.t.s.c.b.impl.BingAdsServiceFactory - USING PRODUCTION ENVIRONMENT
2018-08-08 10:21:45,394 [pool-33-thread-3] DEBUG c.t.s.client.bing.impl.BingAdsClient - Created BingAdsClient for 150147359
2018-08-08 10:21:45,395 [pool-33-thread-3] INFO  jdbc.sqlonly - DELETE FROM `errors` WHERE `campaignName` IN ('7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24003_GT','7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24003_GM')

2018-08-08 10:21:45,396 [pool-33-thread-3] INFO  c.t.s.client.bing.dao.BingErrorDAO - Removed '0' Previous Errors
2018-08-08 10:21:45,397 [pool-33-thread-3] INFO  jdbc.sqlonly - DELETE FROM `errors` WHERE `campaignName` IN ('7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24003_GT','7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24003_GM')

2018-08-08 10:21:45,397 [pool-33-thread-3] INFO  c.t.s.client.bing.dao.BingErrorDAO - Removed '0' Previous Errors
2018-08-08 10:21:45,398 [pool-33-thread-3] INFO  jdbc.sqlonly - UPDATE `campaigns` SET `campaigns`.`bingId` = 349366014, `campaigns`.`name` = '7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24003_GT',
`campaigns`.`status` = 'Paused', `campaigns`.`lastUpdated` = NOW(), `campaigns`.`json` = '{"siteLinks":null,"calloutExtensions":null,"campaign":{"timeZone":"EasternTimeUSCanada","campaignType":["SearchAndContent"],"searchEngineId":349366014,"budgetPeriod":"DailyBudgetAccelerated","status":"Paused","budgetAmount":0.05,"name":"7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24003_GT"},"callExtensions":null,"locationExtensions":null,"campaignTargets":[{"bingTarget":{"BingLocationType":"BingDeviceTarget","deviceName":"Tablets","code":"Tablets","type":"DeviceCriterion"},"bidMultiplier":400.0,"campaignId":349366014,"id":8177656095718},{"bingTarget":{"BingLocationType":"BingRadiusTarget","latitudeDegrees":44.64667892456055,"longitudeDegrees":-73.14752960205078,"radius":24,"bingRadiusUnit":"Kilometers","code":"44.64667892456055,-73.14752960205078","type":"RadiusCriterion"},"bidMultiplier":null,"campaignId":349366014,"id":8177656095715},{"bingTarget":{"BingLocationType":"BingDeviceTarget","deviceName":"Smartphones","code":"Smartphones","type":"DeviceCriterion"},"bidMultiplier":200.0,"campaignId":349366014,"id":8177656095717},{"bingTarget":{"BingLocationType":"BingDeviceTarget","deviceName":"Computers","code":"Computers","type":"DeviceCriterion"},"bidMultiplier":300.0,"campaignId":349366014,"id":8177656095716}],"negativeKeywords":[{"text":"bed
and breakfast","matchType":"Phrase","id":14294282683866},{"text":"salary","matchType":"Phrase","id":14294282683867},{"text":"schools","matchType":"Phrase","id":14294282683868},{"text":"career","matchType":"Phrase","id":14294282683869},{"text":"hostel","matchType":"Phrase","id":14294282683870},{"text":"how
to","matchType":"Phrase","id":14294282683871},{"text":"job","matchType":"Phrase","id":14294282683872},{"text":"careers","matchType":"Phrase","id":14294282683873},{"text":"how
can","matchType":"Phrase","id":14294282683874},{"text":"degrees","matchType":"Phrase","id":14294282683875},{"text":"what
is","matchType":"Phrase","id":14294282683876},{"text":"jobs","matchType":"Phrase","id":14294282683877},{"text":"certifications","matchType":"Phrase","id":14294282683878},{"text":"motels","matchType":"Phrase","id":14294282683879},{"text":"campgrounds","matchType":"Phrase","id":14294282683880},{"text":"pay","matchType":"Phrase","id":14294282683881},{"text":"diploma","matchType":"Phrase","id":14294282683882},{"text":"wages","matchType":"Phrase","id":14294282683883},{"text":"what
can","matchType":"Phrase","id":14294282683884},{"text":"how do","matchType":"Phrase","id":14294282683885},{"text":"school","matchType":"Phrase","id":14294282683886},{"text":"b&b","matchType":"Phrase","id":14294282683887},{"text":"what
to","matchType":"Phrase","id":14294282683888},{"text":"course","matchType":"Phrase","id":14294282683889},{"text":"training","matchType":"Phrase","id":14294282683890},{"text":"certification","matchType":"Phrase","id":14294282683891},{"text":"degree","matchType":"Phrase","id":14294282683892},{"text":"home
rental","matchType":"Phrase","id":14294282683893},{"text":"courses","matchType":"Phrase","id":14294282683894},{"text":"what
do","matchType":"Phrase","id":14294282683895},{"text":"motel","matchType":"Phrase","id":14294282683896},{"text":"diplomas","matchType":"Phrase","id":14294282683897},{"text":"home
rentals","matchType":"Phrase","id":14294282683898},{"text":"hostels","matchType":"Phrase","id":14294282683899},{"text":"classes","matchType":"Phrase","id":14294282683900},{"text":"campground","matchType":"Phrase","id":14294282683901},{"text":"earnings","matchType":"Phrase","id":14294282683902},{"text":"bed
& breakfast","matchType":"Phrase","id":14294282683903},{"text":"b & b","matchType":"Phrase","id":14294282683904},{"text":"class","matchType":"Phrase","id":14294282683905},{"text":"camping","matchType":"Phrase","id":14294282683906},{"text":"management","matchType":"Phrase","id":14294282683907}],"adGroupStructures":[{"adGroup":{"adDistribution":["Search"],"pricingModel":"Cpc","contentMatchBid":0.0,"network":"OwnedAndOperatedAndSyndicatedSearch","searchBid":0.05000000074505806,"language":"English","id":1278732155895713,"status":"Active","name":"7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24003"},"positiveKeywords":[{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"hotel
room in my area","matchType":"Exact","id":79920841553023},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"hotels
closest to me","matchType":"Exact","id":79920841553024},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"guest
room closest to me","matchType":"Exact","id":79920841553025},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"hotel
rooms closest to me","matchType":"Exact","id":79920841553026},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"hotels
near me","matchType":"Exact","id":79920841553027},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"book
hotels","matchType":"Exact","id":79920841553028},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"guest
rooms in my area","matchType":"Exact","id":79920841553029},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"hotel
near me","matchType":"Exact","id":79920841553030},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"hotel
finder","matchType":"Exact","id":79920841553031},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"hotel","matchType":"Exact","id":79920841553032},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"hotel
search","matchType":"Exact","id":79920841553033},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"book
hotel rooms","matchType":"Exact","id":79920841553034},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"guest
rooms","matchType":"Exact","id":79920841553035},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"lodging","matchType":"Exact","id":79920841553036},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"hotel
room closest to me","matchType":"Exact","id":79920841553037},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"hotels
in best","matchType":"Exact","id":79920841553038},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"hotels
in my area","matchType":"Exact","id":79920841553039},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"book
guest rooms","matchType":"Exact","id":79920841553040},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"hotel
rooms in my area","matchType":"Exact","id":79920841553041},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"hotel
closest to me","matchType":"Exact","id":79920841553042},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"boook
a hotel","matchType":"Exact","id":79920841553043},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"guest
room in my area","matchType":"Exact","id":79920841553044},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"hotel
reservations","matchType":"Exact","id":79920841553045},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"guest
rooms closest to me","matchType":"Exact","id":79920841553046},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"hotel
rate","matchType":"Exact","id":79920841553047},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"hotel
in my area","matchType":"Exact","id":79920841553048},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"guest
rooms near me","matchType":"Exact","id":79920841553049},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"hotel
room near me","matchType":"Exact","id":79920841553050},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"hotel
rooms","matchType":"Exact","id":79920841553051},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"guest
room near me","matchType":"Exact","id":79920841553052},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"hotel
rooms near me","matchType":"Exact","id":79920841553053},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"hotels","matchType":"Exact","id":79920841553054},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"hotel
reservation","matchType":"Exact","id":79920841553055},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"hotel
rates","matchType":"Exact","id":79920841553056}],"ads":[{"text":"Milton VT Guest Rooms. Great
Service & Location.","displayUrl":"www.merchantsite.com/Hotel/Milton_VT","path1":"Hotel","path2":"Milton_VT","title1":"Find
a Hotel","title2":"Hotel Rooms Milton VT","adType":"ExpandedText","editorialStatus":null,"finalUrls":["http://www.merchantsite.com/"],"status":"Active","id":79920796235724},{"text":"Milton
VT Guest Rooms. Find Out Why Guests Love Us!","displayUrl":"www.merchantsite.com/Hotel/Milton_VT","path1":"Hotel","path2":"Milton_VT","title1":"Hotel
Deals","title2":"Hotel - Milton VT","adType":"ExpandedText","editorialStatus":null,"finalUrls":["http://www.merchantsite.com/"],"status":"Active","id":79920796235725},{"text":"Milton
VT Guest Rooms. Find Out Why Guests Love Us!","displayUrl":"www.merchantsite.com/Hotel/Milton_VT","path1":"Hotel","path2":"Milton_VT","title1":"{KeyWord:Hotel
- Milton VT}","title2":"Hotel Deals","adType":"ExpandedText","editorialStatus":null,"finalUrls":["http://www.merchantsite.com/"],"status":"Active","id":79920796235726},{"text":"Milton
VT Guest Rooms. Great Service & Location.","displayUrl":"www.merchantsite.com/Hotel/Milton_VT","path1":"Hotel","path2":"Milton_VT","title1":"{KeyWord:Hotel
Rooms Milton VT}","title2":"Find a Hotel","adType":"ExpandedText","editorialStatus":null,"finalUrls":["http://www.merchantsite.com/"],"status":"Active","id":79920796235727}]}],"campaignCallExtension":null,"campaignLocationExtension":null,"campaignSiteLinks":null,"campaignCalloutExtensions":null}'
WHERE `campaigns`.`id` = 4796

2018-08-08 10:21:45,399 [pool-33-thread-3] INFO  jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`id` = 4796

2018-08-08 10:21:45,400 [pool-33-thread-3] INFO  jdbc.sqlonly - UPDATE `campaigns` SET `campaigns`.`bingId` = 349366015, `campaigns`.`name` = '7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24003_GM',
`campaigns`.`status` = 'Paused', `campaigns`.`lastUpdated` = NOW(), `campaigns`.`json` = '{"siteLinks":null,"calloutExtensions":null,"campaign":{"timeZone":"EasternTimeUSCanada","campaignType":["SearchAndContent"],"searchEngineId":349366015,"budgetPeriod":"DailyBudgetAccelerated","status":"Paused","budgetAmount":0.05,"name":"7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24003_GM"},"callExtensions":null,"locationExtensions":null,"campaignTargets":[{"bingTarget":{"BingLocationType":"BingDeviceTarget","deviceName":"Tablets","code":"Tablets","type":"DeviceCriterion"},"bidMultiplier":400.0,"campaignId":349366015,"id":8177656095722},{"bingTarget":{"BingLocationType":"BingLocationTarget","displayName":"Vermont|United
States","locationType":"State","locationID":4131,"code":"4131","type":"LocationCriterion"},"bidMultiplier":null,"campaignId":349366015,"id":8177656095719},{"bingTarget":{"BingLocationType":"BingDeviceTarget","deviceName":"Smartphones","code":"Smartphones","type":"DeviceCriterion"},"bidMultiplier":200.0,"campaignId":349366015,"id":8177656095721},{"bingTarget":{"BingLocationType":"BingDeviceTarget","deviceName":"Computers","code":"Computers","type":"DeviceCriterion"},"bidMultiplier":300.0,"campaignId":349366015,"id":8177656095720}],"negativeKeywords":[{"text":"bed
and breakfast","matchType":"Phrase","id":14363002038713},{"text":"salary","matchType":"Phrase","id":14363002038714},{"text":"schools","matchType":"Phrase","id":14363002038715},{"text":"career","matchType":"Phrase","id":14363002038716},{"text":"hostel","matchType":"Phrase","id":14363002038717},{"text":"how
to","matchType":"Phrase","id":14363002038718},{"text":"job","matchType":"Phrase","id":14363002038719},{"text":"careers","matchType":"Phrase","id":14363002038720},{"text":"how
can","matchType":"Phrase","id":14363002038721},{"text":"degrees","matchType":"Phrase","id":14363002038722},{"text":"what
is","matchType":"Phrase","id":14363002038723},{"text":"jobs","matchType":"Phrase","id":14363002038724},{"text":"certifications","matchType":"Phrase","id":14363002038725},{"text":"motels","matchType":"Phrase","id":14363002038726},{"text":"campgrounds","matchType":"Phrase","id":14363002038727},{"text":"pay","matchType":"Phrase","id":14363002038728},{"text":"diploma","matchType":"Phrase","id":14363002038729},{"text":"wages","matchType":"Phrase","id":14363002038730},{"text":"what
can","matchType":"Phrase","id":14363002038731},{"text":"how do","matchType":"Phrase","id":14363002038732},{"text":"school","matchType":"Phrase","id":14363002038733},{"text":"b&b","matchType":"Phrase","id":14363002038734},{"text":"what
to","matchType":"Phrase","id":14363002038735},{"text":"course","matchType":"Phrase","id":14363002038736},{"text":"training","matchType":"Phrase","id":14363002038737},{"text":"certification","matchType":"Phrase","id":14363002038738},{"text":"degree","matchType":"Phrase","id":14363002038739},{"text":"home
rental","matchType":"Phrase","id":14363002038740},{"text":"courses","matchType":"Phrase","id":14363002038741},{"text":"what
do","matchType":"Phrase","id":14363002038742},{"text":"motel","matchType":"Phrase","id":14363002038743},{"text":"diplomas","matchType":"Phrase","id":14363002038744},{"text":"home
rentals","matchType":"Phrase","id":14363002038745},{"text":"hostels","matchType":"Phrase","id":14363002038746},{"text":"classes","matchType":"Phrase","id":14363002038747},{"text":"campground","matchType":"Phrase","id":14363002038748},{"text":"earnings","matchType":"Phrase","id":14363002038749},{"text":"bed
& breakfast","matchType":"Phrase","id":14363002038750},{"text":"b & b","matchType":"Phrase","id":14363002038751},{"text":"class","matchType":"Phrase","id":14363002038752},{"text":"camping","matchType":"Phrase","id":14363002038753},{"text":"management","matchType":"Phrase","id":14363002038754}],"adGroupStructures":[{"adGroup":{"adDistribution":["Search"],"pricingModel":"Cpc","contentMatchBid":0.0,"network":"OwnedAndOperatedAndSyndicatedSearch","searchBid":0.05000000074505806,"language":"English","id":1285329225523607,"status":"Active","name":"7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24003_Milton,
VT"},"positiveKeywords":[{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"+hotel
+finder +Milton +VT ","matchType":"Broad","id":80333158690340},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"+accommodation
+Milton +VT ","matchType":"Broad","id":80333158690341},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"+book
+hotels +Milton +VT ","matchType":"Broad","id":80333158690342},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"+hotels
+Milton +VT ","matchType":"Broad","id":80333158690343},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"+hotel
+Milton +VT ","matchType":"Broad","id":80333158690344},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"+hotel
+search +Milton +VT ","matchType":"Broad","id":80333158690345},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"+hotel
+reservations +Milton +VT ","matchType":"Broad","id":80333158690346},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"+guest
+rooms +Milton +VT ","matchType":"Broad","id":80333158690347},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"+lodging
+Milton +VT ","matchType":"Broad","id":80333158690348},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"+accommodations
+Milton +VT ","matchType":"Broad","id":80333158690349},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"+hotel
+reservation +Milton +VT ","matchType":"Broad","id":80333158690350},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"+hotel
+rooms +Milton +VT ","matchType":"Broad","id":80333158690351},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"+hotel
+rates +Milton +VT ","matchType":"Broad","id":80333158690352},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"+hotel
+rate +Milton +VT ","matchType":"Broad","id":80333158690353}],"ads":[{"text":"Milton VT Guest
Rooms. Great Service & Location.","displayUrl":"www.merchantsite.com/Hotel/Milton_VT","path1":"Hotel","path2":"Milton_VT","title1":"Find
a Hotel","title2":"Hotel Rooms Milton VT","adType":"ExpandedText","editorialStatus":null,"finalUrls":["http://www.merchantsite.com/"],"status":"Active","id":80333112946186},{"text":"Milton
VT Guest Rooms. Find Out Why Guests Love Us!","displayUrl":"www.merchantsite.com/Hotel/Milton_VT","path1":"Hotel","path2":"Milton_VT","title1":"Hotel
Deals","title2":"Hotel - Milton VT","adType":"ExpandedText","editorialStatus":null,"finalUrls":["http://www.merchantsite.com/"],"status":"Active","id":80333112946187},{"text":"Milton
VT Guest Rooms. Find Out Why Guests Love Us!","displayUrl":"www.merchantsite.com/Hotel/Milton_VT","path1":"Hotel","path2":"Milton_VT","title1":"{KeyWord:Hotel
- Milton VT}","title2":"Hotel Deals","adType":"ExpandedText","editorialStatus":null,"finalUrls":["http://www.merchantsite.com/"],"status":"Active","id":80333112946188},{"text":"Milton
VT Guest Rooms. Great Service & Location.","displayUrl":"www.merchantsite.com/Hotel/Milton_VT","path1":"Hotel","path2":"Milton_VT","title1":"{KeyWord:Hotel
Rooms Milton VT}","title2":"Find a Hotel","adType":"ExpandedText","editorialStatus":null,"finalUrls":["http://www.merchantsite.com/"],"status":"Active","id":80333112946189}]},{"adGroup":{"adDistribution":["Search"],"pricingModel":"Cpc","contentMatchBid":0.0,"network":"OwnedAndOperatedAndSyndicatedSearch","searchBid":0.05000000074505806,"language":"English","id":1286428737150088,"status":"Active","name":"7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24003_Milton
Vermont"},"positiveKeywords":[{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"+hotels
+Milton +Vermont ","matchType":"Broad","id":80401878158534},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"+hotel
+rate +Milton +Vermont ","matchType":"Broad","id":80401878158535},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"+hotel
+rates +Milton +Vermont ","matchType":"Broad","id":80401878158536},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"+hotel
+reservations +Milton +Vermont ","matchType":"Broad","id":80401878158537},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"+accommodation
+Milton +Vermont ","matchType":"Broad","id":80401878158538},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"+book
+hotels +Milton +Vermont ","matchType":"Broad","id":80401878158539},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"+lodging
+Milton +Vermont ","matchType":"Broad","id":80401878158540},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"+hotel
+Milton +Vermont ","matchType":"Broad","id":80401878158541},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"+hotel
+reservation +Milton +Vermont ","matchType":"Broad","id":80401878158542},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"+guest
+rooms +Milton +Vermont ","matchType":"Broad","id":80401878158543},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"+hotel
+finder +Milton +Vermont ","matchType":"Broad","id":80401878158544},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"+hotel
+rooms +Milton +Vermont ","matchType":"Broad","id":80401878158545},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"+hotel
+search +Milton +Vermont ","matchType":"Broad","id":80401878158546},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"+accommodations
+Milton +Vermont ","matchType":"Broad","id":80401878158547}],"ads":[{"text":"Milton VT Guest
Rooms. Great Service & Location.","displayUrl":"www.merchantsite.com/Hotel/Milton_VT","path1":"Hotel","path2":"Milton_VT","title1":"Find
a Hotel","title2":"Hotel Rooms Milton VT","adType":"ExpandedText","editorialStatus":null,"finalUrls":["http://www.merchantsite.com/"],"status":"Active","id":80401832946663},{"text":"Milton
VT Guest Rooms. Find Out Why Guests Love Us!","displayUrl":"www.merchantsite.com/Hotel/Milton_VT","path1":"Hotel","path2":"Milton_VT","title1":"Hotel
Deals","title2":"Hotel - Milton VT","adType":"ExpandedText","editorialStatus":null,"finalUrls":["http://www.merchantsite.com/"],"status":"Active","id":80401832946664},{"text":"Milton
VT Guest Rooms. Find Out Why Guests Love Us!","displayUrl":"www.merchantsite.com/Hotel/Milton_VT","path1":"Hotel","path2":"Milton_VT","title1":"{KeyWord:Hotel
- Milton VT}","title2":"Hotel Deals","adType":"ExpandedText","editorialStatus":null,"finalUrls":["http://www.merchantsite.com/"],"status":"Active","id":80401832946665},{"text":"Milton
VT Guest Rooms. Great Service & Location.","displayUrl":"www.merchantsite.com/Hotel/Milton_VT","path1":"Hotel","path2":"Milton_VT","title1":"{KeyWord:Hotel
Rooms Milton VT}","title2":"Find a Hotel","adType":"ExpandedText","editorialStatus":null,"finalUrls":["http://www.merchantsite.com/"],"status":"Active","id":80401832946666}]}],"campaignCallExtension":null,"campaignLocationExtension":null,"campaignSiteLinks":null,"campaignCalloutExtensions":null}'
WHERE `campaigns`.`id` = 4797

2018-08-08 10:21:45,402 [pool-33-thread-3] INFO  jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`id` = 4797

2018-08-08 10:21:45,405 [pool-33-thread-3] INFO  c.t.s.bing.BingAccountDeployer - Updated Bing campaign structure for accountID 2402
2018-08-08 10:21:45.405 (3) [pool-33-thread-3]: Completed Bing Replace Campaigns Worker..
2018-08-08 10:21:45.486 (3) [P10T1]: Creating API for reseller DistributionSettings b8a7d340-30e0-4369-97d0-8f901d238f86
2018-08-08 10:21:45.488 (3) [P10T1]: Retrieving credentials for search engine user id : 3606 || client id : 627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com , client secret :uO1pQj_ihl6Jy1fSA7FzCTFE , refresh token : 1/XElVvzhFJlFc7FcqtcZJbj1-erQxMLsEVlrN60XCc4JMrEt0pnthZ_A8mZru5Ei4
2018-08-08 10:21:45,488 [P10T1] INFO  c.t.s.o.core.OAuthServiceComponent - [oauth] Return OAuth credential. Access token = ya29.Gl3zBYr9QBwmMOD6WvNhLpbtWQyO49XTHJCpJDsmjqFOFb9bn397RotEN6JIqLrEQKe7Cfxb_BZux9Ak91sJKH2QCbpSxQ8NN-lUwxfbzh58rLWSlelQCAsx-Unr5PI for adwords (clientID=627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com)
2018-08-08 10:21:45.488 (3) [P10T1]: [oauth] Returning access token from OAuth service: ya29.Gl3zBYr9QBwmMOD6WvNhLpbtWQyO49XTHJCpJDsmjqFOFb9bn397RotEN6JIqLrEQKe7Cfxb_BZux9Ak91sJKH2QCbpSxQ8NN-lUwxfbzh58rLWSlelQCAsx-Unr5PI
2018-08-08 10:21:45.488 (3) [P10T1]: Retrieving credentials for search engine user id : 3606 || client id : 627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com , client secret :uO1pQj_ihl6Jy1fSA7FzCTFE , refresh token : 1/XElVvzhFJlFc7FcqtcZJbj1-erQxMLsEVlrN60XCc4JMrEt0pnthZ_A8mZru5Ei4
2018-08-08 10:21:45,488 [P10T1] INFO  c.t.s.o.core.OAuthServiceComponent - [oauth] Return OAuth credential. Access token = ya29.Gl3zBYr9QBwmMOD6WvNhLpbtWQyO49XTHJCpJDsmjqFOFb9bn397RotEN6JIqLrEQKe7Cfxb_BZux9Ak91sJKH2QCbpSxQ8NN-lUwxfbzh58rLWSlelQCAsx-Unr5PI for adwords (clientID=627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com)
2018-08-08 10:21:45.489 (3) [P10T1]: [oauth] Returning access token from OAuth service: ya29.Gl3zBYr9QBwmMOD6WvNhLpbtWQyO49XTHJCpJDsmjqFOFb9bn397RotEN6JIqLrEQKe7Cfxb_BZux9Ak91sJKH2QCbpSxQ8NN-lUwxfbzh58rLWSlelQCAsx-Unr5PI
2018-08-08 10:21:45.489 (3) [P10T1]: DistributionServiceRemoteClient created for GMB
2018-08-08 10:21:45.518 (3) [P10T1]: Retrieving GMB credentials for search engine user id : 3606 || client id : 627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com , client secret :uO1pQj_ihl6Jy1fSA7FzCTFE , refresh token : 1/fH9q5og0rO9LI5NBJqM4k_YTHb-0XSo2-Qv53oyo5a0
2018-08-08 10:21:45,518 [P10T1] INFO  c.t.s.o.core.OAuthServiceComponent - [oauth] Return OAuth credential. Access token = ya29.Gl3zBT9UPnSb8zwTZdDOaABAwsEn6CRsSh2UtDtma77Kp3dQ3dFh_BG1ZlWAqnhyvT3p0mdBO9i0JvL2CE-LiJYcSsyxW14StKmHMTwdYe4VjFNL8xviC8kmsXVq2mI for gmb (clientID=627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com)
2018-08-08 10:21:45.518 (3) [P10T1]: DistributionServiceRemoteClient created for 7782a00d-dc22-4770-b0ec-0a3aea79fe57_2_qa4amltest_FB_BM_01
2018-08-08 10:21:45.635 (3) [P10T1]: Creating API for reseller DistributionSettings b8a7d340-30e0-4369-97d0-8f901d238f86
2018-08-08 10:21:45.636 (3) [P10T1]: Retrieving credentials for search engine user id : 3606 || client id : 627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com , client secret :uO1pQj_ihl6Jy1fSA7FzCTFE , refresh token : 1/XElVvzhFJlFc7FcqtcZJbj1-erQxMLsEVlrN60XCc4JMrEt0pnthZ_A8mZru5Ei4
2018-08-08 10:21:45,636 [P10T1] INFO  c.t.s.o.core.OAuthServiceComponent - [oauth] Return OAuth credential. Access token = ya29.Gl3zBYr9QBwmMOD6WvNhLpbtWQyO49XTHJCpJDsmjqFOFb9bn397RotEN6JIqLrEQKe7Cfxb_BZux9Ak91sJKH2QCbpSxQ8NN-lUwxfbzh58rLWSlelQCAsx-Unr5PI for adwords (clientID=627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com)
2018-08-08 10:21:45.636 (3) [P10T1]: [oauth] Returning access token from OAuth service: ya29.Gl3zBYr9QBwmMOD6WvNhLpbtWQyO49XTHJCpJDsmjqFOFb9bn397RotEN6JIqLrEQKe7Cfxb_BZux9Ak91sJKH2QCbpSxQ8NN-lUwxfbzh58rLWSlelQCAsx-Unr5PI
2018-08-08 10:21:45.636 (3) [P10T1]: Retrieving credentials for search engine user id : 3606 || client id : 627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com , client secret :uO1pQj_ihl6Jy1fSA7FzCTFE , refresh token : 1/XElVvzhFJlFc7FcqtcZJbj1-erQxMLsEVlrN60XCc4JMrEt0pnthZ_A8mZru5Ei4
2018-08-08 10:21:45,636 [P10T1] INFO  c.t.s.o.core.OAuthServiceComponent - [oauth] Return OAuth credential. Access token = ya29.Gl3zBYr9QBwmMOD6WvNhLpbtWQyO49XTHJCpJDsmjqFOFb9bn397RotEN6JIqLrEQKe7Cfxb_BZux9Ak91sJKH2QCbpSxQ8NN-lUwxfbzh58rLWSlelQCAsx-Unr5PI for adwords (clientID=627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com)
2018-08-08 10:21:45.636 (3) [P10T1]: [oauth] Returning access token from OAuth service: ya29.Gl3zBYr9QBwmMOD6WvNhLpbtWQyO49XTHJCpJDsmjqFOFb9bn397RotEN6JIqLrEQKe7Cfxb_BZux9Ak91sJKH2QCbpSxQ8NN-lUwxfbzh58rLWSlelQCAsx-Unr5PI
2018-08-08 10:21:45.636 (3) [P10T1]: DistributionServiceRemoteClient created for GMB
2018-08-08 10:21:45.651 (3) [P10T1]: Retrieving GMB credentials for search engine user id : 3606 || client id : 627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com , client secret :uO1pQj_ihl6Jy1fSA7FzCTFE , refresh token : 1/fH9q5og0rO9LI5NBJqM4k_YTHb-0XSo2-Qv53oyo5a0
2018-08-08 10:21:45,651 [P10T1] INFO  c.t.s.o.core.OAuthServiceComponent - [oauth] Return OAuth credential. Access token = ya29.Gl3zBT9UPnSb8zwTZdDOaABAwsEn6CRsSh2UtDtma77Kp3dQ3dFh_BG1ZlWAqnhyvT3p0mdBO9i0JvL2CE-LiJYcSsyxW14StKmHMTwdYe4VjFNL8xviC8kmsXVq2mI for gmb (clientID=627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com)
2018-08-08 10:21:45.690 (3) [P10T1]: No deleted adgroups found
2018-08-08 10:21:45.692 (3) [P10T1]: Deletes Pending Change 0 adgroups and adding 0 adgroups.
2018-08-08 10:21:45.778 (3) [P10T1]: No deleted keywords found
2018-08-08 10:21:45.781 (3) [P10T1]: Deleting 0 keywords and adding 0 keywords and Updated 0.
2018-08-08 10:21:45.833 (3) [P10T1]: No deleted text ads found
2018-08-08 10:21:45.834 (3) [P10T1]: Deleting 0 text ads and adding 0 text ads.
2018-08-08 10:21:45.841 (3) [P10T1]: replace 0 changed campaigns for accountID 2402
2018-08-08 10:21:45.852 (2) [P10T1]: CampaignTargetDAO: database is null
2018-08-08 10:21:45.875 (3) [P10T1]: ... SEUser 3606 finished
2018-08-08 10:21:45.876 (3) [pool-33-thread-1]: ------------Google Content Editor done
2018-08-08 10:21:45.876 (3) [pool-33-thread-1]: Completed Google Replace Campaigns Worker..
2018-08-08 10:21:45.893 (3) [pool-3-thread-4]: Deleted: 0 unregistered keywords for accountID 2402
2018-08-08 10:21:45.893 (3) [pool-3-thread-4]: Updated 0 keyword destination URLs in GCE Campaigns: [4796, 4797]
2018-08-08 10:21:45.895 (3) [pool-3-thread-4]: 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24003_GT had an updated campaign structure. Scheduled SE groups and listings update.
2018-08-08 10:21:45.895 (3) [pool-3-thread-4]: 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24003_GM had an updated campaign structure. Scheduled SE groups and listings update.
2018-08-08 10:21:50.895 (3) [pool-3-thread-4]: JobExecutor running job [2018-08-08_102145_a2402_campaignUpdateWorkerCampaignSync_xG69smA2kN]: [/usr/local/tsa/bidmgr/seupdate.sh, , -d, 3, --inactive, --seaccount, 12628,12629, --groups, --listings]
2018-08-08 10:21:58.189 (3) [pool-3-thread-4]: JobExecutor finished running job [2018-08-08_102145_a2402_campaignUpdateWorkerCampaignSync_xG69smA2kN], exit code=0 in 7.282s
2018-08-08 10:21:58.189 (3) [pool-3-thread-4]: JobExecutor finished 2018-08-08_102145_a2402_campaignUpdateWorkerCampaignSync_xG69smA2kN. hasError=false, numTries=1
2018-08-08 10:21:58.192 (3) [pool-3-thread-4]: 7782a00d-dc22-4770-b0ec-0a3aea79fe57 has 4 new campaign(s) for Facebook.
2018-08-08 10:21:58.192 (3) [pool-3-thread-4]: 7782a00d-dc22-4770-b0ec-0a3aea79fe57 has 1 available users with 10000 available campaign slots.
2018-08-08 10:21:58.192 (3) [pool-3-thread-4]: Assigned existing seUserID: 3605 to: 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24031_S1
2018-08-08 10:21:58.192 (3) [pool-3-thread-4]: Assigned existing seUserID: 3605 to: 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24031_S2
2018-08-08 10:21:58.192 (3) [pool-3-thread-4]: Assigned existing seUserID: 3605 to: 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24031_S3
2018-08-08 10:21:58.192 (3) [pool-3-thread-4]: Assigned existing seUserID: 3605 to: 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24031_S4
2018-08-08 10:21:58.192 (3) [pool-3-thread-4]: Assigned 4 campaigns to: 1 existing user(s).
2018-08-08 10:21:58.196 (3) [pool-3-thread-4]: Creating 4 new campaign(s).
2018-08-08 10:21:58.196 (3) [pool-3-thread-4]: CampaignWorker initialized for account: 2402
2018-08-08 10:21:58.196 (3) [pool-3-thread-4]: Creating 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24031_S1 Status: Paused
2018-08-08 10:21:58.196 (3) [pool-3-thread-4]: Creating 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24031_S2 Status: Paused
2018-08-08 10:21:58.196 (3) [pool-3-thread-4]: Creating 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24031_S3 Status: Paused
2018-08-08 10:21:58.196 (3) [pool-3-thread-4]: Creating 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24031_S4 Status: Paused
2018-08-08 10:21:58.196 (3) [pool-3-thread-4]: CampaignWorker started for account: 2402
2018-08-08 10:21:58.196 (3) [pool-36-thread-1]: Starting Google Create Campaign Worker..
2018-08-08 10:21:58.196 (3) [pool-36-thread-1]: Completed Google Create Campaign Worker..
2018-08-08 10:21:58.196 (3) [pool-36-thread-2]: Starting Facebook Create Campaign Worker..
2018-08-08 10:21:58,196 [pool-36-thread-2] INFO  c.t.s.f.FacebookAccountDeployer - Creating Facebook campaign structure for accountID 2402
2018-08-08 10:21:58.196 (3) [pool-36-thread-3]: Starting Bing Create Campaign Worker..
2018-08-08 10:21:58.196 (3) [pool-36-thread-3]: Completed Bing Create Campaign Worker..
2018-08-08 10:21:58,196 [pool-36-thread-2] INFO  c.t.s.f.FacebookAccountDeployer - Facebook campaign startDate:2018-08-08T06:21:58.196-04:00 America/New_York
2018-08-08 10:21:58,196 [pool-36-thread-2] INFO  c.t.s.f.FacebookAccountDeployer - Facebook campaign endDate:2018-09-07T23:59:59.999-04:00 America/New_York
2018-08-08 10:21:58,197 [pool-36-thread-2] INFO  c.t.s.f.FacebookAccountDeployer - finding carryover for seuserID 3605 and date 2018-08-08
2018-08-08 10:21:58,199 [pool-36-thread-2] INFO  jdbc.sqlonly - SELECT `monthlyCarryovers`.`id`, `monthlyCarryovers`.`campaignID`, `monthlyCarryovers`.`date`,
`monthlyCarryovers`.`carryover`, `monthlyCarryovers`.`type` FROM `monthlyCarryovers` JOIN `campaigns`
on `monthlyCarryovers`.`campaignID`= `campaigns`.id WHERE `campaigns`.`searchEngineUserId`
= 3605 and `monthlyCarryovers`.`date` = '2018-08-08' and `monthlyCarryovers`.`type` = 'normal'

2018-08-08 10:21:58,201 [pool-36-thread-2] INFO  c.t.s.f.FacebookAccountDeployer - Found campaign carryover data for seuserID 3605 and date 2018-08-08 , carryover data ([TPCampaignCarryoverDTO [theID=181, theCampaignID=1438, theDate=2018-08-08, theCarryover=0.0, theCarryoverType=normal], TPCampaignCarryoverDTO [theID=182, theCampaignID=1439, theDate=2018-08-08, theCarryover=0.0, theCarryoverType=normal], TPCampaignCarryoverDTO [theID=183, theCampaignID=1440, theDate=2018-08-08, theCarryover=0.0, theCarryoverType=normal], TPCampaignCarryoverDTO [theID=184, theCampaignID=1441, theDate=2018-08-08, theCarryover=0.0, theCarryoverType=normal]])
2018-08-08 10:21:58,203 [pool-36-thread-2] INFO  jdbc.sqlonly - SELECT `id`, `searchEngineUserId`, `date`, `carryoverAdjustment`, `type` FROM `monthlyCarryoverAdjustments`
WHERE `searchEngineUserId` = 3605 and `date` = '2018-08-08' and `type` = 'normal' ORDER BY
`id` DESC

2018-08-08 10:21:58,205 [pool-36-thread-2] INFO  c.t.s.f.FacebookAccountDeployer - carryover Adjustment for seuserID 3605 and date 2018-08-08 is -1.0
2018-08-08 10:21:58,205 [pool-36-thread-2] INFO  c.t.s.f.FacebookAccountDeployer - Total carryover [carryover - carryoverAdjustment] for seuserID 3605 and date 2018-08-08 is 1.0
2018-08-08 10:21:58,205 [pool-36-thread-2] INFO  c.t.s.f.FacebookAccountDeployer - Individual campaign carryover for seuserID 3605 and date 2018-08-08 is 0.25 USD
2018-08-08 10:21:58,205 [pool-36-thread-2] INFO  c.t.s.f.FacebookAccountDeployer - Facebook campaign nominal monthly budget : 3100
2018-08-08 10:21:58,205 [pool-36-thread-2] INFO  c.t.s.f.FacebookAccountDeployer - Facebook campaign carryover : 25.0
2018-08-08 10:21:58,205 [pool-36-thread-2] INFO  c.t.s.f.FacebookAccountDeployer - Facebook campaign actual monthly budget : 3125
2018-08-08 10:21:58.210 (3) [pool-36-thread-2]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2018-08-08 10:21:58,211 [pool-36-thread-2] INFO  c.t.s.f.FacebookAccountStructureMapper - TPCampaignTargets [[TPLocation [theType=city, theId=2533307, theAddress=null, theLatitude=null, theLongitude=null, theRadius=null, theRadiusUnit=null]]]
2018-08-08 10:21:58,211 [pool-36-thread-2] INFO  c.t.s.f.FacebookAccountDeployer - Facebook campaign startDate:2018-08-08T06:21:58.211-04:00 America/New_York
2018-08-08 10:21:58,211 [pool-36-thread-2] INFO  c.t.s.f.FacebookAccountDeployer - Facebook campaign endDate:2018-09-07T23:59:59.999-04:00 America/New_York
2018-08-08 10:21:58,211 [pool-36-thread-2] INFO  c.t.s.f.FacebookAccountDeployer - finding carryover for seuserID 3605 and date 2018-08-08
2018-08-08 10:21:58,213 [pool-36-thread-2] INFO  jdbc.sqlonly - SELECT `monthlyCarryovers`.`id`, `monthlyCarryovers`.`campaignID`, `monthlyCarryovers`.`date`,
`monthlyCarryovers`.`carryover`, `monthlyCarryovers`.`type` FROM `monthlyCarryovers` JOIN `campaigns`
on `monthlyCarryovers`.`campaignID`= `campaigns`.id WHERE `campaigns`.`searchEngineUserId`
= 3605 and `monthlyCarryovers`.`date` = '2018-08-08' and `monthlyCarryovers`.`type` = 'normal'

2018-08-08 10:21:58,216 [pool-36-thread-2] INFO  c.t.s.f.FacebookAccountDeployer - Found campaign carryover data for seuserID 3605 and date 2018-08-08 , carryover data ([TPCampaignCarryoverDTO [theID=181, theCampaignID=1438, theDate=2018-08-08, theCarryover=0.0, theCarryoverType=normal], TPCampaignCarryoverDTO [theID=182, theCampaignID=1439, theDate=2018-08-08, theCarryover=0.0, theCarryoverType=normal], TPCampaignCarryoverDTO [theID=183, theCampaignID=1440, theDate=2018-08-08, theCarryover=0.0, theCarryoverType=normal], TPCampaignCarryoverDTO [theID=184, theCampaignID=1441, theDate=2018-08-08, theCarryover=0.0, theCarryoverType=normal]])
2018-08-08 10:21:58,218 [pool-36-thread-2] INFO  jdbc.sqlonly - SELECT `id`, `searchEngineUserId`, `date`, `carryoverAdjustment`, `type` FROM `monthlyCarryoverAdjustments`
WHERE `searchEngineUserId` = 3605 and `date` = '2018-08-08' and `type` = 'normal' ORDER BY
`id` DESC

2018-08-08 10:21:58,220 [pool-36-thread-2] INFO  c.t.s.f.FacebookAccountDeployer - carryover Adjustment for seuserID 3605 and date 2018-08-08 is -1.0
2018-08-08 10:21:58,220 [pool-36-thread-2] INFO  c.t.s.f.FacebookAccountDeployer - Total carryover [carryover - carryoverAdjustment] for seuserID 3605 and date 2018-08-08 is 1.0
2018-08-08 10:21:58,220 [pool-36-thread-2] INFO  c.t.s.f.FacebookAccountDeployer - Individual campaign carryover for seuserID 3605 and date 2018-08-08 is 0.25 USD
2018-08-08 10:21:58,220 [pool-36-thread-2] INFO  c.t.s.f.FacebookAccountDeployer - Facebook campaign nominal monthly budget : 3100
2018-08-08 10:21:58,220 [pool-36-thread-2] INFO  c.t.s.f.FacebookAccountDeployer - Facebook campaign carryover : 25.0
2018-08-08 10:21:58,220 [pool-36-thread-2] INFO  c.t.s.f.FacebookAccountDeployer - Facebook campaign actual monthly budget : 3125
2018-08-08 10:21:58,221 [pool-36-thread-2] INFO  c.t.s.f.FacebookAccountStructureMapper - TPCampaignTargets [[TPLocation [theType=city, theId=2533307, theAddress=null, theLatitude=null, theLongitude=null, theRadius=null, theRadiusUnit=null]]]
2018-08-08 10:21:58,221 [pool-36-thread-2] INFO  c.t.s.f.FacebookAccountDeployer - Facebook campaign startDate:2018-08-08T06:21:58.221-04:00 America/New_York
2018-08-08 10:21:58,221 [pool-36-thread-2] INFO  c.t.s.f.FacebookAccountDeployer - Facebook campaign endDate:2018-09-07T23:59:59.999-04:00 America/New_York
2018-08-08 10:21:58,221 [pool-36-thread-2] INFO  c.t.s.f.FacebookAccountDeployer - finding carryover for seuserID 3605 and date 2018-08-08
2018-08-08 10:21:58,223 [pool-36-thread-2] INFO  jdbc.sqlonly - SELECT `monthlyCarryovers`.`id`, `monthlyCarryovers`.`campaignID`, `monthlyCarryovers`.`date`,
`monthlyCarryovers`.`carryover`, `monthlyCarryovers`.`type` FROM `monthlyCarryovers` JOIN `campaigns`
on `monthlyCarryovers`.`campaignID`= `campaigns`.id WHERE `campaigns`.`searchEngineUserId`
= 3605 and `monthlyCarryovers`.`date` = '2018-08-08' and `monthlyCarryovers`.`type` = 'normal'

2018-08-08 10:21:58,225 [pool-36-thread-2] INFO  c.t.s.f.FacebookAccountDeployer - Found campaign carryover data for seuserID 3605 and date 2018-08-08 , carryover data ([TPCampaignCarryoverDTO [theID=181, theCampaignID=1438, theDate=2018-08-08, theCarryover=0.0, theCarryoverType=normal], TPCampaignCarryoverDTO [theID=182, theCampaignID=1439, theDate=2018-08-08, theCarryover=0.0, theCarryoverType=normal], TPCampaignCarryoverDTO [theID=183, theCampaignID=1440, theDate=2018-08-08, theCarryover=0.0, theCarryoverType=normal], TPCampaignCarryoverDTO [theID=184, theCampaignID=1441, theDate=2018-08-08, theCarryover=0.0, theCarryoverType=normal]])
2018-08-08 10:21:58,227 [pool-36-thread-2] INFO  jdbc.sqlonly - SELECT `id`, `searchEngineUserId`, `date`, `carryoverAdjustment`, `type` FROM `monthlyCarryoverAdjustments`
WHERE `searchEngineUserId` = 3605 and `date` = '2018-08-08' and `type` = 'normal' ORDER BY
`id` DESC

2018-08-08 10:21:58,228 [pool-36-thread-2] INFO  c.t.s.f.FacebookAccountDeployer - carryover Adjustment for seuserID 3605 and date 2018-08-08 is -1.0
2018-08-08 10:21:58,228 [pool-36-thread-2] INFO  c.t.s.f.FacebookAccountDeployer - Total carryover [carryover - carryoverAdjustment] for seuserID 3605 and date 2018-08-08 is 1.0
2018-08-08 10:21:58,228 [pool-36-thread-2] INFO  c.t.s.f.FacebookAccountDeployer - Individual campaign carryover for seuserID 3605 and date 2018-08-08 is 0.25 USD
2018-08-08 10:21:58,228 [pool-36-thread-2] INFO  c.t.s.f.FacebookAccountDeployer - Facebook campaign nominal monthly budget : 3100
2018-08-08 10:21:58,228 [pool-36-thread-2] INFO  c.t.s.f.FacebookAccountDeployer - Facebook campaign carryover : 25.0
2018-08-08 10:21:58,228 [pool-36-thread-2] INFO  c.t.s.f.FacebookAccountDeployer - Facebook campaign actual monthly budget : 3125
2018-08-08 10:21:58,229 [pool-36-thread-2] INFO  c.t.s.f.FacebookAccountStructureMapper - TPCampaignTargets [[TPLocation [theType=city, theId=2533307, theAddress=null, theLatitude=null, theLongitude=null, theRadius=null, theRadiusUnit=null]]]
2018-08-08 10:21:58,229 [pool-36-thread-2] INFO  c.t.s.f.FacebookAccountDeployer - Facebook campaign startDate:2018-08-08T06:21:58.229-04:00 America/New_York
2018-08-08 10:21:58,229 [pool-36-thread-2] INFO  c.t.s.f.FacebookAccountDeployer - Facebook campaign endDate:2018-09-07T23:59:59.999-04:00 America/New_York
2018-08-08 10:21:58,229 [pool-36-thread-2] INFO  c.t.s.f.FacebookAccountDeployer - finding carryover for seuserID 3605 and date 2018-08-08
2018-08-08 10:21:58,232 [pool-36-thread-2] INFO  jdbc.sqlonly - SELECT `monthlyCarryovers`.`id`, `monthlyCarryovers`.`campaignID`, `monthlyCarryovers`.`date`,
`monthlyCarryovers`.`carryover`, `monthlyCarryovers`.`type` FROM `monthlyCarryovers` JOIN `campaigns`
on `monthlyCarryovers`.`campaignID`= `campaigns`.id WHERE `campaigns`.`searchEngineUserId`
= 3605 and `monthlyCarryovers`.`date` = '2018-08-08' and `monthlyCarryovers`.`type` = 'normal'

2018-08-08 10:21:58,233 [pool-36-thread-2] INFO  c.t.s.f.FacebookAccountDeployer - Found campaign carryover data for seuserID 3605 and date 2018-08-08 , carryover data ([TPCampaignCarryoverDTO [theID=181, theCampaignID=1438, theDate=2018-08-08, theCarryover=0.0, theCarryoverType=normal], TPCampaignCarryoverDTO [theID=182, theCampaignID=1439, theDate=2018-08-08, theCarryover=0.0, theCarryoverType=normal], TPCampaignCarryoverDTO [theID=183, theCampaignID=1440, theDate=2018-08-08, theCarryover=0.0, theCarryoverType=normal], TPCampaignCarryoverDTO [theID=184, theCampaignID=1441, theDate=2018-08-08, theCarryover=0.0, theCarryoverType=normal]])
2018-08-08 10:21:58,235 [pool-36-thread-2] INFO  jdbc.sqlonly - SELECT `id`, `searchEngineUserId`, `date`, `carryoverAdjustment`, `type` FROM `monthlyCarryoverAdjustments`
WHERE `searchEngineUserId` = 3605 and `date` = '2018-08-08' and `type` = 'normal' ORDER BY
`id` DESC

2018-08-08 10:21:58,237 [pool-36-thread-2] INFO  c.t.s.f.FacebookAccountDeployer - carryover Adjustment for seuserID 3605 and date 2018-08-08 is -1.0
2018-08-08 10:21:58,237 [pool-36-thread-2] INFO  c.t.s.f.FacebookAccountDeployer - Total carryover [carryover - carryoverAdjustment] for seuserID 3605 and date 2018-08-08 is 1.0
2018-08-08 10:21:58,237 [pool-36-thread-2] INFO  c.t.s.f.FacebookAccountDeployer - Individual campaign carryover for seuserID 3605 and date 2018-08-08 is 0.25 USD
2018-08-08 10:21:58,237 [pool-36-thread-2] INFO  c.t.s.f.FacebookAccountDeployer - Facebook campaign nominal monthly budget : 3100
2018-08-08 10:21:58,237 [pool-36-thread-2] INFO  c.t.s.f.FacebookAccountDeployer - Facebook campaign carryover : 25.0
2018-08-08 10:21:58,237 [pool-36-thread-2] INFO  c.t.s.f.FacebookAccountDeployer - Facebook campaign actual monthly budget : 3125
2018-08-08 10:21:58,238 [pool-36-thread-2] INFO  c.t.s.f.FacebookAccountStructureMapper - TPCampaignTargets [[TPLocation [theType=city, theId=2533307, theAddress=null, theLatitude=null, theLongitude=null, theRadius=null, theRadiusUnit=null]]]
2018-08-08 10:21:58,240 [pool-36-thread-2] INFO  c.t.s.c.t.i.s.CampaignServiceClient - Adding TP campaign [7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24031_S1] to account af25490b19114ab5aa33ce437296a235
2018-08-08 10:21:58,247 [pool-36-thread-2] INFO  o.a.c.i.LoggingOutInterceptor - Outbound Message
---------------------------
ID: 241
Address: https://api.tigerpistol.com/v1/campaigns/
Http-Method: POST
Content-Type: application/json
Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token IcHjX0XyED53f6ShTWlqq4xbRXkEoiloVA1IXqtU]}
Payload: {
  "name" : "7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24031_S1",
  "status" : "Active",
  "customerId" : "af25490b19114ab5aa33ce437296a235",
  "objective" : "website_clicks",
  "budget" : 3125,
  "start" : "2018-08-08T10:21:58.196Z",
  "maxEnd" : "2018-09-08T03:59:59.999Z",
  "placement" : [ "desktopfeed", "mobilefeed", "instagramfeed", "rightcolumn" ],
  "details" : {
    "audiences" : [ {
      "ageFrom" : 18,
      "ageTo" : 65,
      "gender" : "all",
      "locationTypes" : [ "home", "recent" ],
      "demographics" : {
        "life_events" : [ "6003053857372" ],
        "behaviors" : [ "6002714895372" ],
        "family_statuses" : [ "6002714398372" ],
        "home_type" : [ "23842646930010111" ],
        "interests" : [ "6002926108721" ]
      },
      "locations" : [ {
        "type" : "city",
        "id" : "2533307"
      } ]
    } ],
    "copies" : [ {
      "headline" : "Hotel Rooms Milton VT",
      "body" : "Milton VT Guest Rooms. Great Service & Location.",
      "description" : "Find a Hotel",
      "destinationUrl" : "http://www.merchantsite.com/"
    } ],
    "images" : [ "https://aml-qa.s3.us-west-1.amazonaws.com/usa/10002/images/image-10002-5.jpg" ],
    "cta" : [ {
      "type" : "learn_more"
    } ]
  }
}
--------------------------------------
2018-08-08 10:21:59,973 [pool-36-thread-2] INFO  o.a.c.i.LoggingInInterceptor - Inbound Message
----------------------------
ID: 241
Response-Code: 201
Encoding: UTF-8
Content-Type: application/json; charset=utf-8
Headers: {Content-Length=[597], content-type=[application/json; charset=utf-8], Date=[Wed, 08 Aug 2018 10:21:59 GMT], Location=[https://api.tigerpistol.com/v1/campaigns/ca8392a6-6b09-4cd6-bc20-1a5ad0128d77], Request-Context=[appId=cid-v1:690c908b-aa2b-45a7-9444-c522c4d33ca3], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]}
Payload: {"variations":[{"index":0,"reviewError":null}],"id":"ca8392a66b094cd6bc201a5ad0128d77","customerId":"af25490b19114ab5aa33ce437296a235","start":"2018-08-08T10:21:00+00:00","end":"2018-09-08T03:59:00+00:00","budget":3125.00,"objective":"website_clicks","displayMargin":1.0,"status":"live","publishPhase":"complete","hasError":false,"errorMessage":"","spend":0.0,"clicks":0,"cpc":null,"ctr":null,"impressions":0,"cpm":null,"leads":0,"cpl":null,"pageLikes":0,"postEngagements":0,"cppl":null,"cppe":null,"reach":0,"videoViews":0,"cpvv":null,"videoAveragePercentViewed":null,"offersSaved":0,"cpos":null}
--------------------------------------
2018-08-08 10:21:59,975 [pool-36-thread-2] INFO  c.t.s.c.t.i.s.CampaignServiceClient - Updating TP campaign [ca8392a66b094cd6bc201a5ad0128d77] status to [resume] for account af25490b19114ab5aa33ce437296a235
2018-08-08 10:21:59,978 [pool-36-thread-2] INFO  o.a.c.i.LoggingOutInterceptor - Outbound Message
---------------------------
ID: 242
Address: https://api.tigerpistol.com/v1/campaigns/ca8392a66b094cd6bc201a5ad0128d77/resume
Http-Method: POST
Content-Type: application/json
Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token IcHjX0XyED53f6ShTWlqq4xbRXkEoiloVA1IXqtU]}
--------------------------------------
2018-08-08 10:22:00,308 [pool-36-thread-2] INFO  o.a.c.i.LoggingInInterceptor - Inbound Message
----------------------------
ID: 242
Response-Code: 200
Encoding: ISO-8859-1
Content-Type:
Headers: {Content-Length=[0], Date=[Wed, 08 Aug 2018 10:21:59 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]}
--------------------------------------
2018-08-08 10:22:00,309 [pool-36-thread-2] INFO  c.t.s.c.t.i.s.CampaignServiceClient - Adding TP campaign [7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24031_S2] to account af25490b19114ab5aa33ce437296a235
2018-08-08 10:22:00,315 [pool-36-thread-2] INFO  o.a.c.i.LoggingOutInterceptor - Outbound Message
---------------------------
ID: 243
Address: https://api.tigerpistol.com/v1/campaigns/
Http-Method: POST
Content-Type: application/json
Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token IcHjX0XyED53f6ShTWlqq4xbRXkEoiloVA1IXqtU]}
Payload: {
  "name" : "7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24031_S2",
  "status" : "Active",
  "customerId" : "af25490b19114ab5aa33ce437296a235",
  "objective" : "website_clicks",
  "budget" : 3125,
  "start" : "2018-08-08T10:21:58.211Z",
  "maxEnd" : "2018-09-08T03:59:59.999Z",
  "placement" : [ "desktopfeed", "mobilefeed", "instagramfeed", "rightcolumn" ],
  "details" : {
    "audiences" : [ {
      "ageFrom" : 18,
      "ageTo" : 65,
      "gender" : "all",
      "locationTypes" : [ "home", "recent" ],
      "demographics" : {
        "life_events" : [ "6003053857372" ],
        "behaviors" : [ "6002714895372" ],
        "family_statuses" : [ "6002714398372" ],
        "home_type" : [ "23842646930010111" ],
        "interests" : [ "6002926108721" ]
      },
      "locations" : [ {
        "type" : "city",
        "id" : "2533307"
      } ]
    } ],
    "copies" : [ {
      "headline" : "Hotel Deals",
      "body" : "Milton VT Guest Rooms. Find Out Why Guests Love Us!",
      "description" : "Hotel - Milton VT",
      "destinationUrl" : "http://www.merchantsite.com/"
    } ],
    "images" : [ "https://aml-qa.s3.us-west-1.amazonaws.com/usa/10002/images/image-10002-4.jpg" ],
    "cta" : [ {
      "type" : "learn_more"
    } ]
  }
}
--------------------------------------
2018-08-08 10:22:01.161 (3) [Thread-9]: Heartbeat #117 (1533723721158) received in 0.003s
2018-08-08 10:22:01,775 [pool-36-thread-2] INFO  o.a.c.i.LoggingInInterceptor - Inbound Message
----------------------------
ID: 243
Response-Code: 201
Encoding: UTF-8
Content-Type: application/json; charset=utf-8
Headers: {Content-Length=[597], content-type=[application/json; charset=utf-8], Date=[Wed, 08 Aug 2018 10:22:01 GMT], Location=[https://api.tigerpistol.com/v1/campaigns/9ed165a8-0d72-4a31-9aed-2fccaaf5ba91], Request-Context=[appId=cid-v1:690c908b-aa2b-45a7-9444-c522c4d33ca3], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]}
Payload: {"variations":[{"index":0,"reviewError":null}],"id":"9ed165a80d724a319aed2fccaaf5ba91","customerId":"af25490b19114ab5aa33ce437296a235","start":"2018-08-08T10:21:00+00:00","end":"2018-09-08T03:59:00+00:00","budget":3125.00,"objective":"website_clicks","displayMargin":1.0,"status":"live","publishPhase":"complete","hasError":false,"errorMessage":"","spend":0.0,"clicks":0,"cpc":null,"ctr":null,"impressions":0,"cpm":null,"leads":0,"cpl":null,"pageLikes":0,"postEngagements":0,"cppl":null,"cppe":null,"reach":0,"videoViews":0,"cpvv":null,"videoAveragePercentViewed":null,"offersSaved":0,"cpos":null}
--------------------------------------
2018-08-08 10:22:01,776 [pool-36-thread-2] INFO  c.t.s.c.t.i.s.CampaignServiceClient - Updating TP campaign [9ed165a80d724a319aed2fccaaf5ba91] status to [resume] for account af25490b19114ab5aa33ce437296a235
2018-08-08 10:22:01,779 [pool-36-thread-2] INFO  o.a.c.i.LoggingOutInterceptor - Outbound Message
---------------------------
ID: 244
Address: https://api.tigerpistol.com/v1/campaigns/9ed165a80d724a319aed2fccaaf5ba91/resume
Http-Method: POST
Content-Type: application/json
Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token IcHjX0XyED53f6ShTWlqq4xbRXkEoiloVA1IXqtU]}
--------------------------------------
2018-08-08 10:22:02,115 [pool-36-thread-2] INFO  o.a.c.i.LoggingInInterceptor - Inbound Message
----------------------------
ID: 244
Response-Code: 200
Encoding: ISO-8859-1
Content-Type:
Headers: {Content-Length=[0], Date=[Wed, 08 Aug 2018 10:22:01 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]}
--------------------------------------
2018-08-08 10:22:02,115 [pool-36-thread-2] INFO  c.t.s.c.t.i.s.CampaignServiceClient - Adding TP campaign [7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24031_S3] to account af25490b19114ab5aa33ce437296a235
2018-08-08 10:22:02,122 [pool-36-thread-2] INFO  o.a.c.i.LoggingOutInterceptor - Outbound Message
---------------------------
ID: 245
Address: https://api.tigerpistol.com/v1/campaigns/
Http-Method: POST
Content-Type: application/json
Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token IcHjX0XyED53f6ShTWlqq4xbRXkEoiloVA1IXqtU]}
Payload: {
  "name" : "7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24031_S3",
  "status" : "Active",
  "customerId" : "af25490b19114ab5aa33ce437296a235",
  "objective" : "website_clicks",
  "budget" : 3125,
  "start" : "2018-08-08T10:21:58.221Z",
  "maxEnd" : "2018-09-08T03:59:59.999Z",
  "placement" : [ "desktopfeed", "mobilefeed", "instagramfeed", "rightcolumn" ],
  "details" : {
    "audiences" : [ {
      "ageFrom" : 18,
      "ageTo" : 65,
      "gender" : "all",
      "locationTypes" : [ "home", "recent" ],
      "demographics" : {
        "life_events" : [ "6003053857372" ],
        "behaviors" : [ "6002714895372" ],
        "family_statuses" : [ "6002714398372" ],
        "home_type" : [ "23842646930010111" ],
        "interests" : [ "6002926108721" ]
      },
      "locations" : [ {
        "type" : "city",
        "id" : "2533307"
      } ]
    } ],
    "copies" : [ {
      "headline" : "Find a Hotel",
      "body" : "Milton VT Guest Rooms. Great Service & Location.",
      "description" : "Hotel Rooms Milton VT",
      "destinationUrl" : "http://www.merchantsite.com/"
    } ],
    "images" : [ "https://aml-qa.s3.us-west-1.amazonaws.com/usa/10002/images/image-10002-3.jpg" ],
    "cta" : [ {
      "type" : "learn_more"
    } ]
  }
}
--------------------------------------
2018-08-08 10:22:03,545 [pool-36-thread-2] INFO  o.a.c.i.LoggingInInterceptor - Inbound Message
----------------------------
ID: 245
Response-Code: 201
Encoding: UTF-8
Content-Type: application/json; charset=utf-8
Headers: {Content-Length=[597], content-type=[application/json; charset=utf-8], Date=[Wed, 08 Aug 2018 10:22:02 GMT], Location=[https://api.tigerpistol.com/v1/campaigns/99ad48b5-f003-45ef-86c8-376732479f6c], Request-Context=[appId=cid-v1:690c908b-aa2b-45a7-9444-c522c4d33ca3], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]}
Payload: {"variations":[{"index":0,"reviewError":null}],"id":"99ad48b5f00345ef86c8376732479f6c","customerId":"af25490b19114ab5aa33ce437296a235","start":"2018-08-08T10:21:00+00:00","end":"2018-09-08T03:59:00+00:00","budget":3125.00,"objective":"website_clicks","displayMargin":1.0,"status":"live","publishPhase":"complete","hasError":false,"errorMessage":"","spend":0.0,"clicks":0,"cpc":null,"ctr":null,"impressions":0,"cpm":null,"leads":0,"cpl":null,"pageLikes":0,"postEngagements":0,"cppl":null,"cppe":null,"reach":0,"videoViews":0,"cpvv":null,"videoAveragePercentViewed":null,"offersSaved":0,"cpos":null}
--------------------------------------
2018-08-08 10:22:03,547 [pool-36-thread-2] INFO  c.t.s.c.t.i.s.CampaignServiceClient - Updating TP campaign [99ad48b5f00345ef86c8376732479f6c] status to [resume] for account af25490b19114ab5aa33ce437296a235
2018-08-08 10:22:03,550 [pool-36-thread-2] INFO  o.a.c.i.LoggingOutInterceptor - Outbound Message
---------------------------
ID: 246
Address: https://api.tigerpistol.com/v1/campaigns/99ad48b5f00345ef86c8376732479f6c/resume
Http-Method: POST
Content-Type: application/json
Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token IcHjX0XyED53f6ShTWlqq4xbRXkEoiloVA1IXqtU]}
--------------------------------------
2018-08-08 10:22:03,882 [pool-36-thread-2] INFO  o.a.c.i.LoggingInInterceptor - Inbound Message
----------------------------
ID: 246
Response-Code: 200
Encoding: ISO-8859-1
Content-Type:
Headers: {Content-Length=[0], Date=[Wed, 08 Aug 2018 10:22:02 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]}
--------------------------------------
2018-08-08 10:22:03,882 [pool-36-thread-2] INFO  c.t.s.c.t.i.s.CampaignServiceClient - Adding TP campaign [7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24031_S4] to account af25490b19114ab5aa33ce437296a235
2018-08-08 10:22:03,888 [pool-36-thread-2] INFO  o.a.c.i.LoggingOutInterceptor - Outbound Message
---------------------------
ID: 247
Address: https://api.tigerpistol.com/v1/campaigns/
Http-Method: POST
Content-Type: application/json
Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token IcHjX0XyED53f6ShTWlqq4xbRXkEoiloVA1IXqtU]}
Payload: {
  "name" : "7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24031_S4",
  "status" : "Active",
  "customerId" : "af25490b19114ab5aa33ce437296a235",
  "objective" : "website_clicks",
  "budget" : 3125,
  "start" : "2018-08-08T10:21:58.229Z",
  "maxEnd" : "2018-09-08T03:59:59.999Z",
  "placement" : [ "desktopfeed", "mobilefeed", "instagramfeed", "rightcolumn" ],
  "details" : {
    "audiences" : [ {
      "ageFrom" : 18,
      "ageTo" : 65,
      "gender" : "all",
      "locationTypes" : [ "home", "recent" ],
      "demographics" : {
        "life_events" : [ "6003053857372" ],
        "behaviors" : [ "6002714895372" ],
        "family_statuses" : [ "6002714398372" ],
        "home_type" : [ "23842646930010111" ],
        "interests" : [ "6002926108721" ]
      },
      "locations" : [ {
        "type" : "city",
        "id" : "2533307"
      } ]
    } ],
    "copies" : [ {
      "headline" : "Hotel - Milton VT",
      "body" : "Milton VT Guest Rooms. Find Out Why Guests Love Us!",
      "description" : "Hotel Deals",
      "destinationUrl" : "http://www.merchantsite.com/"
    } ],
    "images" : [ "https://aml-qa.s3.us-west-1.amazonaws.com/usa/10002/images/image-10002-2.jpg" ],
    "cta" : [ {
      "type" : "learn_more"
    } ]
  }
}
--------------------------------------
2018-08-08 10:22:05,544 [pool-36-thread-2] INFO  o.a.c.i.LoggingInInterceptor - Inbound Message
----------------------------
ID: 247
Response-Code: 201
Encoding: UTF-8
Content-Type: application/json; charset=utf-8
Headers: {Content-Length=[597], content-type=[application/json; charset=utf-8], Date=[Wed, 08 Aug 2018 10:22:05 GMT], Location=[https://api.tigerpistol.com/v1/campaigns/bc0f8c58-e048-43af-aae6-afa1911c1517], Request-Context=[appId=cid-v1:690c908b-aa2b-45a7-9444-c522c4d33ca3], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]}
Payload: {"variations":[{"index":0,"reviewError":null}],"id":"bc0f8c58e04843afaae6afa1911c1517","customerId":"af25490b19114ab5aa33ce437296a235","start":"2018-08-08T10:21:00+00:00","end":"2018-09-08T03:59:00+00:00","budget":3125.00,"objective":"website_clicks","displayMargin":1.0,"status":"live","publishPhase":"complete","hasError":false,"errorMessage":"","spend":0.0,"clicks":0,"cpc":null,"ctr":null,"impressions":0,"cpm":null,"leads":0,"cpl":null,"pageLikes":0,"postEngagements":0,"cppl":null,"cppe":null,"reach":0,"videoViews":0,"cpvv":null,"videoAveragePercentViewed":null,"offersSaved":0,"cpos":null}
--------------------------------------
2018-08-08 10:22:05,546 [pool-36-thread-2] INFO  c.t.s.c.t.i.s.CampaignServiceClient - Updating TP campaign [bc0f8c58e04843afaae6afa1911c1517] status to [resume] for account af25490b19114ab5aa33ce437296a235
2018-08-08 10:22:05,548 [pool-36-thread-2] INFO  o.a.c.i.LoggingOutInterceptor - Outbound Message
---------------------------
ID: 248
Address: https://api.tigerpistol.com/v1/campaigns/bc0f8c58e04843afaae6afa1911c1517/resume
Http-Method: POST
Content-Type: application/json
Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token IcHjX0XyED53f6ShTWlqq4xbRXkEoiloVA1IXqtU]}
--------------------------------------
2018-08-08 10:22:05,883 [pool-36-thread-2] INFO  o.a.c.i.LoggingInInterceptor - Inbound Message
----------------------------
ID: 248
Response-Code: 200
Encoding: ISO-8859-1
Content-Type:
Headers: {Content-Length=[0], Date=[Wed, 08 Aug 2018 10:22:05 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]}
--------------------------------------
2018-08-08 10:22:10,883 [pool-36-thread-2] INFO  c.t.s.c.t.i.s.CampaignServiceClient - Getting TP campaign [ca8392a66b094cd6bc201a5ad0128d77] details for account af25490b19114ab5aa33ce437296a235
2018-08-08 10:22:10,887 [pool-36-thread-2] INFO  o.a.c.i.LoggingOutInterceptor - Outbound Message
---------------------------
ID: 249
Address: https://api.tigerpistol.com/v1/campaigns/ca8392a66b094cd6bc201a5ad0128d77
Http-Method: GET
Content-Type: application/json
Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token IcHjX0XyED53f6ShTWlqq4xbRXkEoiloVA1IXqtU]}
--------------------------------------
2018-08-08 10:22:11,231 [pool-36-thread-2] INFO  o.a.c.i.LoggingInInterceptor - Inbound Message
----------------------------
ID: 249
Response-Code: 200
Encoding: UTF-8
Content-Type: application/json; charset=utf-8
Headers: {Content-Length=[718], content-type=[application/json; charset=utf-8], Date=[Wed, 08 Aug 2018 10:22:10 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]}
Payload: {"variations":[{"index":0,"reviewError":null}],"id":"ca8392a66b094cd6bc201a5ad0128d77","customerId":"af25490b19114ab5aa33ce437296a235","start":"2018-08-08T10:21:00+00:00","end":"2018-09-08T03:59:00+00:00","budget":3125.00,"objective":"website_clicks","displayMargin":1.0,"status":"error","publishPhase":"error","hasError":true,"errorMessage":"You must have a valid payment method associated with your ad account before you can create ads. Please add a payment method.","spend":0.0,"clicks":0,"cpc":null,"ctr":null,"impressions":0,"cpm":null,"leads":0,"cpl":null,"pageLikes":0,"postEngagements":0,"cppl":null,"cppe":null,"reach":0,"videoViews":0,"cpvv":null,"videoAveragePercentViewed":null,"offersSaved":0,"cpos":null}
--------------------------------------
2018-08-08 10:22:16,232 [pool-36-thread-2] INFO  c.t.s.c.t.i.s.CampaignServiceClient - Getting TP campaign [9ed165a80d724a319aed2fccaaf5ba91] details for account af25490b19114ab5aa33ce437296a235
2018-08-08 10:22:16,236 [pool-36-thread-2] INFO  o.a.c.i.LoggingOutInterceptor - Outbound Message
---------------------------
ID: 250
Address: https://api.tigerpistol.com/v1/campaigns/9ed165a80d724a319aed2fccaaf5ba91
Http-Method: GET
Content-Type: application/json
Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token IcHjX0XyED53f6ShTWlqq4xbRXkEoiloVA1IXqtU]}
--------------------------------------
2018-08-08 10:22:16,578 [pool-36-thread-2] INFO  o.a.c.i.LoggingInInterceptor - Inbound Message
----------------------------
ID: 250
Response-Code: 200
Encoding: UTF-8
Content-Type: application/json; charset=utf-8
Headers: {Content-Length=[718], content-type=[application/json; charset=utf-8], Date=[Wed, 08 Aug 2018 10:22:16 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]}
Payload: {"variations":[{"index":0,"reviewError":null}],"id":"9ed165a80d724a319aed2fccaaf5ba91","customerId":"af25490b19114ab5aa33ce437296a235","start":"2018-08-08T10:21:00+00:00","end":"2018-09-08T03:59:00+00:00","budget":3125.00,"objective":"website_clicks","displayMargin":1.0,"status":"error","publishPhase":"error","hasError":true,"errorMessage":"You must have a valid payment method associated with your ad account before you can create ads. Please add a payment method.","spend":0.0,"clicks":0,"cpc":null,"ctr":null,"impressions":0,"cpm":null,"leads":0,"cpl":null,"pageLikes":0,"postEngagements":0,"cppl":null,"cppe":null,"reach":0,"videoViews":0,"cpvv":null,"videoAveragePercentViewed":null,"offersSaved":0,"cpos":null}
--------------------------------------
2018-08-08 10:22:21,580 [pool-36-thread-2] INFO  c.t.s.c.t.i.s.CampaignServiceClient - Getting TP campaign [99ad48b5f00345ef86c8376732479f6c] details for account af25490b19114ab5aa33ce437296a235
2018-08-08 10:22:21,583 [pool-36-thread-2] INFO  o.a.c.i.LoggingOutInterceptor - Outbound Message
---------------------------
ID: 251
Address: https://api.tigerpistol.com/v1/campaigns/99ad48b5f00345ef86c8376732479f6c
Http-Method: GET
Content-Type: application/json
Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token IcHjX0XyED53f6ShTWlqq4xbRXkEoiloVA1IXqtU]}
--------------------------------------
2018-08-08 10:22:22,027 [pool-36-thread-2] INFO  o.a.c.i.LoggingInInterceptor - Inbound Message
----------------------------
ID: 251
Response-Code: 200
Encoding: UTF-8
Content-Type: application/json; charset=utf-8
Headers: {Content-Length=[718], content-type=[application/json; charset=utf-8], Date=[Wed, 08 Aug 2018 10:22:21 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]}
Payload: {"variations":[{"index":0,"reviewError":null}],"id":"99ad48b5f00345ef86c8376732479f6c","customerId":"af25490b19114ab5aa33ce437296a235","start":"2018-08-08T10:21:00+00:00","end":"2018-09-08T03:59:00+00:00","budget":3125.00,"objective":"website_clicks","displayMargin":1.0,"status":"error","publishPhase":"error","hasError":true,"errorMessage":"You must have a valid payment method associated with your ad account before you can create ads. Please add a payment method.","spend":0.0,"clicks":0,"cpc":null,"ctr":null,"impressions":0,"cpm":null,"leads":0,"cpl":null,"pageLikes":0,"postEngagements":0,"cppl":null,"cppe":null,"reach":0,"videoViews":0,"cpvv":null,"videoAveragePercentViewed":null,"offersSaved":0,"cpos":null}
--------------------------------------
2018-08-08 10:22:27,028 [pool-36-thread-2] INFO  c.t.s.c.t.i.s.CampaignServiceClient - Getting TP campaign [bc0f8c58e04843afaae6afa1911c1517] details for account af25490b19114ab5aa33ce437296a235
2018-08-08 10:22:27,032 [pool-36-thread-2] INFO  o.a.c.i.LoggingOutInterceptor - Outbound Message
---------------------------
ID: 252
Address: https://api.tigerpistol.com/v1/campaigns/bc0f8c58e04843afaae6afa1911c1517
Http-Method: GET
Content-Type: application/json
Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token IcHjX0XyED53f6ShTWlqq4xbRXkEoiloVA1IXqtU]}
--------------------------------------
2018-08-08 10:22:27,371 [pool-36-thread-2] INFO  o.a.c.i.LoggingInInterceptor - Inbound Message
----------------------------
ID: 252
Response-Code: 200
Encoding: UTF-8
Content-Type: application/json; charset=utf-8
Headers: {Content-Length=[718], content-type=[application/json; charset=utf-8], Date=[Wed, 08 Aug 2018 10:22:27 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]}
Payload: {"variations":[{"index":0,"reviewError":null}],"id":"bc0f8c58e04843afaae6afa1911c1517","customerId":"af25490b19114ab5aa33ce437296a235","start":"2018-08-08T10:21:00+00:00","end":"2018-09-08T03:59:00+00:00","budget":3125.00,"objective":"website_clicks","displayMargin":1.0,"status":"error","publishPhase":"error","hasError":true,"errorMessage":"You must have a valid payment method associated with your ad account before you can create ads. Please add a payment method.","spend":0.0,"clicks":0,"cpc":null,"ctr":null,"impressions":0,"cpm":null,"leads":0,"cpl":null,"pageLikes":0,"postEngagements":0,"cppl":null,"cppe":null,"reach":0,"videoViews":0,"cpvv":null,"videoAveragePercentViewed":null,"offersSaved":0,"cpos":null}
--------------------------------------
2018-08-08 10:22:27,373 [pool-36-thread-2] INFO  jdbc.sqlonly - DELETE FROM `errors` WHERE `elementName` IN ('7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24031_S1','7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24031_S2','7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24031_S3','7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24031_S4')

2018-08-08 10:22:27,374 [pool-36-thread-2] INFO  c.t.s.client.tp.dao.TPErrorDAO - Removed '0' Previous Errors
2018-08-08 10:22:27,375 [pool-36-thread-2] INFO  jdbc.sqlonly - batching 4 statements: 1: INSERT INTO `errors` (`elementName`, `itemType`, `itemKey`, `code`,
`detail`, `errorCode`, `index`, `message`, `errorType`, `tpId`, `parentId`, `lastUpdated`,
`errorJson`) VALUES ('7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24031_S1','CAMPAIGN_STATUS','7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24031_S1',0,'status:
error, publish Phase: error',NULL,NULL,'You must have a valid payment method associated with
your ad account before you can create ads. Please add a payment method.',NULL,'ca8392a66b094cd6bc201a5ad0128d77',NULL,NOW(),'{"code":0,"message":"You
must have a valid payment method associated with your ad account before you can create ads.
Please add a payment method.","detail":"status: error, publish Phase: error","errorCode":null,"errorType":null,"index":null,"elementName":"7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24031_S1","type":"CAMPAIGN_STATUS","key":"7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24031_S1","searchEngineId":"ca8392a66b094cd6bc201a5ad0128d77","parentSearchEngineId":null}')
2: INSERT INTO `errors` (`elementName`, `itemType`, `itemKey`, `code`, `detail`, `errorCode`,
`index`, `message`, `errorType`, `tpId`, `parentId`, `lastUpdated`, `errorJson`) VALUES ('7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24031_S2','CAMPAIGN_STATUS','7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24031_S2',0,'status:
error, publish Phase: error',NULL,NULL,'You must have a valid payment method associated with
your ad account before you can create ads. Please add a payment method.',NULL,'9ed165a80d724a319aed2fccaaf5ba91',NULL,NOW(),'{"code":0,"message":"You
must have a valid payment method associated with your ad account before you can create ads.
Please add a payment method.","detail":"status: error, publish Phase: error","errorCode":null,"errorType":null,"index":null,"elementName":"7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24031_S2","type":"CAMPAIGN_STATUS","key":"7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24031_S2","searchEngineId":"9ed165a80d724a319aed2fccaaf5ba91","parentSearchEngineId":null}')
3: INSERT INTO `errors` (`elementName`, `itemType`, `itemKey`, `code`, `detail`, `errorCode`,
`index`, `message`, `errorType`, `tpId`, `parentId`, `lastUpdated`, `errorJson`) VALUES ('7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24031_S3','CAMPAIGN_STATUS','7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24031_S3',0,'status:
error, publish Phase: error',NULL,NULL,'You must have a valid payment method associated with
your ad account before you can create ads. Please add a payment method.',NULL,'99ad48b5f00345ef86c8376732479f6c',NULL,NOW(),'{"code":0,"message":"You
must have a valid payment method associated with your ad account before you can create ads.
Please add a payment method.","detail":"status: error, publish Phase: error","errorCode":null,"errorType":null,"index":null,"elementName":"7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24031_S3","type":"CAMPAIGN_STATUS","key":"7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24031_S3","searchEngineId":"99ad48b5f00345ef86c8376732479f6c","parentSearchEngineId":null}')
4: INSERT INTO `errors` (`elementName`, `itemType`, `itemKey`, `code`, `detail`, `errorCode`,
`index`, `message`, `errorType`, `tpId`, `parentId`, `lastUpdated`, `errorJson`) VALUES ('7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24031_S4','CAMPAIGN_STATUS','7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24031_S4',0,'status:
error, publish Phase: error',NULL,NULL,'You must have a valid payment method associated with
your ad account before you can create ads. Please add a payment method.',NULL,'bc0f8c58e04843afaae6afa1911c1517',NULL,NOW(),'{"code":0,"message":"You
must have a valid payment method associated with your ad account before you can create ads.
Please add a payment method.","detail":"status: error, publish Phase: error","errorCode":null,"errorType":null,"index":null,"elementName":"7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24031_S4","type":"CAMPAIGN_STATUS","key":"7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24031_S4","searchEngineId":"bc0f8c58e04843afaae6afa1911c1517","parentSearchEngineId":null}')

2018-08-08 10:22:27,379 [pool-36-thread-2] INFO  jdbc.sqlonly - INSERT INTO `campaigns` (`searchEngineUserId`, `tpId`, `name`, `status`, `startDate`, `endDate`,
`lastUpdated`, `json`) VALUES (3605, 'ca8392a66b094cd6bc201a5ad0128d77', '7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24031_S1',
'Active', '08/08/2018 10:21:58.196', '09/08/2018 03:59:59.999', NOW(), '{"campaign":{"name":"7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24031_S1","status":"Active","id":"ca8392a66b094cd6bc201a5ad0128d77","customerId":"af25490b19114ab5aa33ce437296a235","objective":"website_clicks","budget":3125,"start":"2018-08-08T10:21:58.196Z","maxEnd":"2018-09-08T03:59:59.999Z","placement":["desktopfeed","mobilefeed","instagramfeed","rightcolumn"],"details":{"audiences":[{"ageFrom":18,"ageTo":65,"gender":"all","locationTypes":["home","recent"],"demographics":{"life_events":["6003053857372"],"behaviors":["6002714895372"],"family_statuses":["6002714398372"],"home_type":["23842646930010111"],"interests":["6002926108721"]},"locations":[{"type":"city","id":"2533307"}]}],"copies":[{"headline":"Hotel
Rooms Milton VT","body":"Milton VT Guest Rooms. Great Service & Location.","description":"Find
a Hotel","destinationUrl":"http://www.merchantsite.com/"}],"images":["https://aml-qa.s3.us-west-1.amazonaws.com/usa/10002/images/image-10002-5.jpg"],"cta":[{"type":"learn_more"}]}},"searchEngineUserId":3605}')

2018-08-08 10:22:27,380 [pool-36-thread-2] INFO  jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`tpId` = 'ca8392a66b094cd6bc201a5ad0128d77'

2018-08-08 10:22:27,381 [pool-36-thread-2] INFO  jdbc.sqlonly - INSERT INTO `campaigns` (`searchEngineUserId`, `tpId`, `name`, `status`, `startDate`, `endDate`,
`lastUpdated`, `json`) VALUES (3605, '9ed165a80d724a319aed2fccaaf5ba91', '7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24031_S2',
'Active', '08/08/2018 10:21:58.211', '09/08/2018 03:59:59.999', NOW(), '{"campaign":{"name":"7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24031_S2","status":"Active","id":"9ed165a80d724a319aed2fccaaf5ba91","customerId":"af25490b19114ab5aa33ce437296a235","objective":"website_clicks","budget":3125,"start":"2018-08-08T10:21:58.211Z","maxEnd":"2018-09-08T03:59:59.999Z","placement":["desktopfeed","mobilefeed","instagramfeed","rightcolumn"],"details":{"audiences":[{"ageFrom":18,"ageTo":65,"gender":"all","locationTypes":["home","recent"],"demographics":{"life_events":["6003053857372"],"behaviors":["6002714895372"],"family_statuses":["6002714398372"],"home_type":["23842646930010111"],"interests":["6002926108721"]},"locations":[{"type":"city","id":"2533307"}]}],"copies":[{"headline":"Hotel
Deals","body":"Milton VT Guest Rooms. Find Out Why Guests Love Us!","description":"Hotel -
Milton VT","destinationUrl":"http://www.merchantsite.com/"}],"images":["https://aml-qa.s3.us-west-1.amazonaws.com/usa/10002/images/image-10002-4.jpg"],"cta":[{"type":"learn_more"}]}},"searchEngineUserId":3605}')

2018-08-08 10:22:27,382 [pool-36-thread-2] INFO  jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`tpId` = '9ed165a80d724a319aed2fccaaf5ba91'

2018-08-08 10:22:27,383 [pool-36-thread-2] INFO  jdbc.sqlonly - INSERT INTO `campaigns` (`searchEngineUserId`, `tpId`, `name`, `status`, `startDate`, `endDate`,
`lastUpdated`, `json`) VALUES (3605, '99ad48b5f00345ef86c8376732479f6c', '7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24031_S3',
'Active', '08/08/2018 10:21:58.221', '09/08/2018 03:59:59.999', NOW(), '{"campaign":{"name":"7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24031_S3","status":"Active","id":"99ad48b5f00345ef86c8376732479f6c","customerId":"af25490b19114ab5aa33ce437296a235","objective":"website_clicks","budget":3125,"start":"2018-08-08T10:21:58.221Z","maxEnd":"2018-09-08T03:59:59.999Z","placement":["desktopfeed","mobilefeed","instagramfeed","rightcolumn"],"details":{"audiences":[{"ageFrom":18,"ageTo":65,"gender":"all","locationTypes":["home","recent"],"demographics":{"life_events":["6003053857372"],"behaviors":["6002714895372"],"family_statuses":["6002714398372"],"home_type":["23842646930010111"],"interests":["6002926108721"]},"locations":[{"type":"city","id":"2533307"}]}],"copies":[{"headline":"Find
a Hotel","body":"Milton VT Guest Rooms. Great Service & Location.","description":"Hotel Rooms
Milton VT","destinationUrl":"http://www.merchantsite.com/"}],"images":["https://aml-qa.s3.us-west-1.amazonaws.com/usa/10002/images/image-10002-3.jpg"],"cta":[{"type":"learn_more"}]}},"searchEngineUserId":3605}')

2018-08-08 10:22:27,383 [pool-36-thread-2] INFO  jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`tpId` = '99ad48b5f00345ef86c8376732479f6c'

2018-08-08 10:22:27,384 [pool-36-thread-2] INFO  jdbc.sqlonly - INSERT INTO `campaigns` (`searchEngineUserId`, `tpId`, `name`, `status`, `startDate`, `endDate`,
`lastUpdated`, `json`) VALUES (3605, 'bc0f8c58e04843afaae6afa1911c1517', '7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24031_S4',
'Active', '08/08/2018 10:21:58.229', '09/08/2018 03:59:59.999', NOW(), '{"campaign":{"name":"7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24031_S4","status":"Active","id":"bc0f8c58e04843afaae6afa1911c1517","customerId":"af25490b19114ab5aa33ce437296a235","objective":"website_clicks","budget":3125,"start":"2018-08-08T10:21:58.229Z","maxEnd":"2018-09-08T03:59:59.999Z","placement":["desktopfeed","mobilefeed","instagramfeed","rightcolumn"],"details":{"audiences":[{"ageFrom":18,"ageTo":65,"gender":"all","locationTypes":["home","recent"],"demographics":{"life_events":["6003053857372"],"behaviors":["6002714895372"],"family_statuses":["6002714398372"],"home_type":["23842646930010111"],"interests":["6002926108721"]},"locations":[{"type":"city","id":"2533307"}]}],"copies":[{"headline":"Hotel
- Milton VT","body":"Milton VT Guest Rooms. Find Out Why Guests Love Us!","description":"Hotel
Deals","destinationUrl":"http://www.merchantsite.com/"}],"images":["https://aml-qa.s3.us-west-1.amazonaws.com/usa/10002/images/image-10002-2.jpg"],"cta":[{"type":"learn_more"}]}},"searchEngineUserId":3605}')

2018-08-08 10:22:27,385 [pool-36-thread-2] INFO  jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`tpId` = 'bc0f8c58e04843afaae6afa1911c1517'

2018-08-08 10:22:27,387 [pool-36-thread-2] INFO  c.t.s.f.FacebookAccountDeployer - finding carryover for seuserID 3605 and date 2018-08-08
2018-08-08 10:22:27,389 [pool-36-thread-2] INFO  jdbc.sqlonly - SELECT `monthlyCarryovers`.`id`, `monthlyCarryovers`.`campaignID`, `monthlyCarryovers`.`date`,
`monthlyCarryovers`.`carryover`, `monthlyCarryovers`.`type` FROM `monthlyCarryovers` JOIN `campaigns`
on `monthlyCarryovers`.`campaignID`= `campaigns`.id WHERE `campaigns`.`searchEngineUserId`
= 3605 and `monthlyCarryovers`.`date` = '2018-08-08' and `monthlyCarryovers`.`type` = 'normal'

2018-08-08 10:22:27,391 [pool-36-thread-2] INFO  c.t.s.f.FacebookAccountDeployer - Found campaign carryover data for seuserID 3605 and date 2018-08-08 , carryover data ([TPCampaignCarryoverDTO [theID=181, theCampaignID=1438, theDate=2018-08-08, theCarryover=0.0, theCarryoverType=normal], TPCampaignCarryoverDTO [theID=182, theCampaignID=1439, theDate=2018-08-08, theCarryover=0.0, theCarryoverType=normal], TPCampaignCarryoverDTO [theID=183, theCampaignID=1440, theDate=2018-08-08, theCarryover=0.0, theCarryoverType=normal], TPCampaignCarryoverDTO [theID=184, theCampaignID=1441, theDate=2018-08-08, theCarryover=0.0, theCarryoverType=normal]])
2018-08-08 10:22:27,395 [pool-36-thread-2] INFO  jdbc.sqlonly - INSERT INTO `monthlyCarryovers` (`campaignID`, `date`, `carryover`, `type`) VALUES (1438,'2018-08-08',0.0,'boosted')
ON DUPLICATE KEY UPDATE `carryover`=VALUES(`carryover`), `type`=VALUES(`type`)

2018-08-08 10:22:27,396 [pool-36-thread-2] INFO  jdbc.sqlonly - SELECT `id`, `campaignID`, `date`, `carryover`, `type` FROM `monthlyCarryovers` WHERE `campaignID`
= 1438 and `date` = '2018-08-08' and `type` = 'boosted'

2018-08-08 10:22:27,399 [pool-36-thread-2] INFO  jdbc.sqlonly - INSERT INTO `monthlyCarryovers` (`campaignID`, `date`, `carryover`, `type`) VALUES (1439,'2018-08-08',0.0,'boosted')
ON DUPLICATE KEY UPDATE `carryover`=VALUES(`carryover`), `type`=VALUES(`type`)

2018-08-08 10:22:27,400 [pool-36-thread-2] INFO  jdbc.sqlonly - SELECT `id`, `campaignID`, `date`, `carryover`, `type` FROM `monthlyCarryovers` WHERE `campaignID`
= 1439 and `date` = '2018-08-08' and `type` = 'boosted'

2018-08-08 10:22:27,404 [pool-36-thread-2] INFO  jdbc.sqlonly - INSERT INTO `monthlyCarryovers` (`campaignID`, `date`, `carryover`, `type`) VALUES (1440,'2018-08-08',0.0,'boosted')
ON DUPLICATE KEY UPDATE `carryover`=VALUES(`carryover`), `type`=VALUES(`type`)

2018-08-08 10:22:27,404 [pool-36-thread-2] INFO  jdbc.sqlonly - SELECT `id`, `campaignID`, `date`, `carryover`, `type` FROM `monthlyCarryovers` WHERE `campaignID`
= 1440 and `date` = '2018-08-08' and `type` = 'boosted'

2018-08-08 10:22:27,408 [pool-36-thread-2] INFO  jdbc.sqlonly - INSERT INTO `monthlyCarryovers` (`campaignID`, `date`, `carryover`, `type`) VALUES (1441,'2018-08-08',0.0,'boosted')
ON DUPLICATE KEY UPDATE `carryover`=VALUES(`carryover`), `type`=VALUES(`type`)

2018-08-08 10:22:27,409 [pool-36-thread-2] INFO  jdbc.sqlonly - SELECT `id`, `campaignID`, `date`, `carryover`, `type` FROM `monthlyCarryovers` WHERE `campaignID`
= 1441 and `date` = '2018-08-08' and `type` = 'boosted'

2018-08-08 10:22:27,414 [pool-36-thread-2] INFO  jdbc.sqlonly - SELECT `id`, `searchEngineUserId`, `date`, `carryoverAdjustment`, `type` FROM `monthlyCarryoverAdjustments`
WHERE `searchEngineUserId` = 3605 and `date` = '2018-08-08' and `type` = 'normal' ORDER BY
`id` DESC

2018-08-08 10:22:27,420 [pool-36-thread-2] INFO  jdbc.sqlonly - UPDATE `monthlyCarryoverAdjustments` set `type` = 'boosted' WHERE `id` = 3

2018-08-08 10:22:27,421 [pool-36-thread-2] INFO  jdbc.sqlonly - SELECT `id`, `searchEngineUserId`, `date`, `carryoverAdjustment`, `type` FROM `monthlyCarryoverAdjustments`
WHERE `id` = 3

2018-08-08 10:22:27,422 [pool-36-thread-2] INFO  c.t.s.f.FacebookAccountDeployer - Created Facebook campaign structure for accountID 2402
2018-08-08 10:22:27.422 (3) [pool-36-thread-2]: Completed Facebook Create Campaign Worker..
2018-08-08 10:22:27.430 (3) [pool-3-thread-4]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2018-08-08 10:22:27.455 (3) [pool-3-thread-4]: 24002_GM has no applicable GCE errors.
2018-08-08 10:22:27,457 [pool-3-thread-4] INFO  jdbc.sqlonly - SELECT `errors`.`errorJson` FROM `campaigns` JOIN `errors` ON `errors`.`elementName` = `campaigns`.`name`
WHERE `campaigns`.`id` IN (1446)

2018-08-08 10:22:27.459 (3) [pool-3-thread-4]: Ignoring: 1 CampaignStatus errors
2018-08-08 10:22:27.459 (3) [pool-3-thread-4]: 24031_S1 has no applicable GCE errors.
2018-08-08 10:22:27,462 [pool-3-thread-4] INFO  jdbc.sqlonly - SELECT `errors`.`errorJson` FROM `campaigns` JOIN `errors` ON `errors`.`elementName` = `campaigns`.`name`
WHERE `campaigns`.`id` IN (1447)

2018-08-08 10:22:27.465 (3) [pool-3-thread-4]: Ignoring: 1 CampaignStatus errors
2018-08-08 10:22:27.465 (3) [pool-3-thread-4]: 24031_S2 has no applicable GCE errors.
2018-08-08 10:22:27,468 [pool-3-thread-4] INFO  jdbc.sqlonly - SELECT `errors`.`errorJson` FROM `campaigns` JOIN `errors` ON `errors`.`elementName` = `campaigns`.`name`
WHERE `campaigns`.`id` IN (1448)

2018-08-08 10:22:27.469 (3) [pool-3-thread-4]: Ignoring: 1 CampaignStatus errors
2018-08-08 10:22:27.469 (3) [pool-3-thread-4]: 24031_S3 has no applicable GCE errors.
2018-08-08 10:22:27,472 [pool-3-thread-4] INFO  jdbc.sqlonly - SELECT `errors`.`errorJson` FROM `campaigns` JOIN `errors` ON `errors`.`elementName` = `campaigns`.`name`
WHERE `campaigns`.`id` IN (1449)

2018-08-08 10:22:27.476 (3) [pool-3-thread-4]: Ignoring: 1 CampaignStatus errors
2018-08-08 10:22:27.476 (3) [pool-3-thread-4]: 24031_S4 has no applicable GCE errors.
2018-08-08 10:22:27,479 [pool-3-thread-4] INFO  jdbc.sqlonly - SELECT `errors`.`errorJson` FROM `campaigns` JOIN `errors` ON `errors`.`campaignName` = `campaigns`.`name`
WHERE `campaigns`.`id` IN (4796)

2018-08-08 10:22:27.480 (3) [pool-3-thread-4]: 24003_GT has no applicable GCE errors.
2018-08-08 10:22:27,482 [pool-3-thread-4] INFO  jdbc.sqlonly - SELECT `errors`.`errorJson` FROM `campaigns` JOIN `errors` ON `errors`.`campaignName` = `campaigns`.`name`
WHERE `campaigns`.`id` IN (4797)

2018-08-08 10:22:27.483 (3) [pool-3-thread-4]: 24003_GM has no applicable GCE errors.
2018-08-08 10:22:27.487 (3) [pool-3-thread-4]: 24002_GT has no applicable GCE errors.
2018-08-08 10:22:27.489 (3) [pool-3-thread-4]: Finished DEPLOY request for campaign 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24003_GT: SUCCEEDED (merchant: 7782a00d-dc22-4770-b0ec-0a3aea79fe57)
2018-08-08 10:22:27.489 (3) [pool-3-thread-4]: Finished DEPLOY request for campaign 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24003_GM: SUCCEEDED (merchant: 7782a00d-dc22-4770-b0ec-0a3aea79fe57)
2018-08-08 10:22:27.490 (3) [pool-3-thread-4]: Finished DEPLOY request for campaign 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24031_S1: SUCCEEDED (merchant: 7782a00d-dc22-4770-b0ec-0a3aea79fe57)
2018-08-08 10:22:27.490 (3) [pool-3-thread-4]: Finished DEPLOY request for campaign 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24031_S2: SUCCEEDED (merchant: 7782a00d-dc22-4770-b0ec-0a3aea79fe57)
2018-08-08 10:22:27.491 (3) [pool-3-thread-4]: Finished DEPLOY request for campaign 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24031_S3: SUCCEEDED (merchant: 7782a00d-dc22-4770-b0ec-0a3aea79fe57)
2018-08-08 10:22:27.491 (3) [pool-3-thread-4]: Finished DEPLOY request for campaign 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24031_S4: SUCCEEDED (merchant: 7782a00d-dc22-4770-b0ec-0a3aea79fe57)
2018-08-08 10:22:27.491 (3) [pool-3-thread-4]: Finished DEPLOY request for campaign 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24002_GT: SUCCEEDED (merchant: 7782a00d-dc22-4770-b0ec-0a3aea79fe57)
2018-08-08 10:22:27.492 (3) [pool-3-thread-4]: Finished DEPLOY request for campaign 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24002_GM: SUCCEEDED (merchant: 7782a00d-dc22-4770-b0ec-0a3aea79fe57)
2018-08-08 10:22:27.492 (3) [pool-3-thread-4]: 7782a00d-dc22-4770-b0ec-0a3aea79fe57 has 4 campaigns for a SE Update accounts sync.
2018-08-08 10:22:27.492 (3) [pool-3-thread-4]: 7782a00d-dc22-4770-b0ec-0a3aea79fe57 has 4 campaigns for a SE Update groups-listings sync.
2018-08-08 10:22:31.161 (3) [Thread-9]: Heartbeat #118 (1533723751158) received in 0.003s
2018-08-08 10:22:31.284 (3) [Thread-9]: Request already exists in map for customerID 7782a00d-dc22-4770-b0ec-0a3aea79fe57
2018-08-08 10:22:31.284 (3) [Thread-9]: Request worker created for 7782a00d-dc22-4770-b0ec-0a3aea79fe57
2018-08-08 10:22:31.285 (3) [Thread-9]: Submitted executor job for 7782a00d-dc22-4770-b0ec-0a3aea79fe57
2018-08-08 10:22:32.492 (3) [pool-3-thread-4]: JobExecutor running job [2018-08-08_102227_a2402_AccountWorkerProcessResults_syncAccountsGroupsListings_nl6mNOtloO]: [/usr/local/tsa/bidmgr/seupdate.sh, , -d, 3, --inactive, --accountid, 2402, --accounts, --seaccount, 12662,12663,12664,12665, --groups, --listings]
2018-08-08 10:22:49.908 (3) [pool-3-thread-4]: JobExecutor finished running job [2018-08-08_102227_a2402_AccountWorkerProcessResults_syncAccountsGroupsListings_nl6mNOtloO], exit code=0 in 17.411s
2018-08-08 10:22:49.908 (3) [pool-3-thread-4]: JobExecutor finished 2018-08-08_102227_a2402_AccountWorkerProcessResults_syncAccountsGroupsListings_nl6mNOtloO. hasError=false, numTries=1
2018-08-08 10:22:49.908 (3) [pool-3-thread-4]: Finished sub-campaign processing for DEPLOY deploymentID (cce7bda7-fd26-41e6-8694-8f697b4c7b41). account 7782a00d-dc22-4770-b0ec-0a3aea79fe57. 8 submitted, 8 ok.
2018-08-08 10:22:49.908 (3) [pool-3-thread-4]: Updating deployment status to 'Success' for campaignID: 24003
2018-08-08 10:22:49.909 (3) [pool-3-thread-4]: Finished DEPLOY request for 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24003: SUCCEEDED (merchant: 7782a00d-dc22-4770-b0ec-0a3aea79fe57)
2018-08-08 10:22:49.909 (3) [pool-3-thread-4]: Updating deployment status to 'Success' for campaignID: 24031
2018-08-08 10:22:49.910 (3) [pool-3-thread-4]: Finished DEPLOY request for 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24031: SUCCEEDED (merchant: 7782a00d-dc22-4770-b0ec-0a3aea79fe57)
2018-08-08 10:22:49.910 (3) [pool-3-thread-4]: Updating deployment status to 'Success' for campaignID: 24002
2018-08-08 10:22:49.910 (3) [pool-3-thread-4]: Finished DEPLOY request for 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24002: SUCCEEDED (merchant: 7782a00d-dc22-4770-b0ec-0a3aea79fe57)
2018-08-08 10:22:49.910 (3) [pool-3-thread-4]: Finished DEPLOY request, deploymentID (cce7bda7-fd26-41e6-8694-8f697b4c7b41), account 7782a00d-dc22-4770-b0ec-0a3aea79fe57
2018-08-08 10:22:49.910 (3) [pool-3-thread-4]: Request removed from map for customerID 7782a00d-dc22-4770-b0ec-0a3aea79fe57
2018-08-08 10:22:49.928 (3) [pool-3-thread-5]: Updating account tables for 7782a00d-dc22-4770-b0ec-0a3aea79fe57
2018-08-08 10:22:49.934 (3) [pool-3-thread-5]: Committing Account settings for 2402
2018-08-08 10:22:49.942 (3) [pool-3-thread-5]: Updating deployment status to 'InProgress' for campaignID: 24002
2018-08-08 10:22:49.952 (3) [pool-3-thread-5]: Pausing campaign 12630 because budget (3.2258063E-4 ==> 0.0) is less than the minimum allowed budget (0.01)
2018-08-08 10:22:49,952 [pool-3-thread-5] DEBUG c.t.common.SECampaignStatusManager - AdMax campaign budget status not found so using Paused
2018-08-08 10:22:49.959 (3) [AdMaxListener]: Sent message to response queue.
2018-08-08 10:22:49.980 (3) [pool-3-thread-5]: Pausing campaign 12631 because budget (3.2258063E-4 ==> 0.0) is less than the minimum allowed budget (0.01)
2018-08-08 10:22:49,980 [pool-3-thread-5] DEBUG c.t.common.SECampaignStatusManager - AdMax campaign budget status not found so using Paused
2018-08-08 10:22:49.981 (3) [pool-3-thread-5]: Updating deployment status to 'InProgress' for campaignID: 24003
2018-08-08 10:22:50.016 (3) [pool-3-thread-5]: Pausing campaign 12628 because budget (4.8387094E-4 ==> 0.0) is less than the minimum allowed budget (0.05)
2018-08-08 10:22:50,016 [pool-3-thread-5] DEBUG c.t.common.SECampaignStatusManager - AdMax campaign budget status not found so using Paused
2018-08-08 10:22:50.023 (3) [pool-3-thread-5]: Pausing campaign 12629 because budget (4.8387094E-4 ==> 0.0) is less than the minimum allowed budget (0.05)
2018-08-08 10:22:50,023 [pool-3-thread-5] DEBUG c.t.common.SECampaignStatusManager - AdMax campaign budget status not found so using Paused
2018-08-08 10:22:50.042 (3) [pool-3-thread-5]: Start processing DEPLOY request (ATMPFovd1QoMzFIEfLaR) for account 7782a00d-dc22-4770-b0ec-0a3aea79fe57. 4 campaign(s).
2018-08-08 10:22:50.042 (3) [pool-3-thread-5]: Performing sync for account: 7782a00d-dc22-4770-b0ec-0a3aea79fe57 ID#2402
2018-08-08 10:22:50.044 (3) [pool-3-thread-5]: Converted proximity target: latitude: 44.64668 longitude: -73.14753 radius: 24000
Converted lat: 44646680 lon: -73147528 radius unit: meters radius: 24000
2018-08-08 10:22:50.050 (3) [pool-3-thread-5]: Converted proximity target: latitude: 44.64668 longitude: -73.14753 radius: 24000
Converted lat: 44.64667892456055 lon: -73.14752960205078 radius unit: kilometers radius: 24.0
2018-08-08 10:22:50.051 (3) [pool-3-thread-5]: 4 campaign(s) to update.
2018-08-08 10:22:50.051 (3) [pool-3-thread-5]: 0 campaign(s) to create.
2018-08-08 10:22:50.051 (3) [pool-3-thread-5]: 0 campaign(s) to retry and update.
2018-08-08 10:22:50.051 (3) [pool-3-thread-5]: Update campaign status for accountID 2402
2018-08-08 10:22:50.052 (3) [pool-3-thread-5]: CampaignWorker initialized for account: 2402
2018-08-08 10:22:50.052 (3) [pool-3-thread-5]: Updating 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24002_GT Status: Paused
2018-08-08 10:22:50.052 (3) [pool-3-thread-5]: Updating 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24002_GM Status: Paused
2018-08-08 10:22:50.052 (3) [pool-3-thread-5]: Updating 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24003_GT Status: Paused
2018-08-08 10:22:50.052 (3) [pool-3-thread-5]: Updating 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24003_GM Status: Paused
2018-08-08 10:22:50.052 (3) [pool-3-thread-5]: CampaignUpdateWorker started...
2018-08-08 10:22:50,157 [pool-3-thread-5] DEBUG c.t.searchengines.bing.BingApiUtils - Getting Bing properties using distribution service
2018-08-08 10:22:50.157 (3) [pool-3-thread-5]: Retrieving credentials : client id : 869cad8e-f7c6-4854-b1bb-4f7955d142c3 , client secret :YZpgReOeKSmN3uEvwdvpumW , refresh token : MCU8qys*5ivRLB*Ufjm4SYPrFDstjeedAPUwtmhQMd6AejXJqnqtokFR!CI9*!AXxiuWu4*gJltaCOEEnHlFLRb3wH1*dHV7v0Vkb8iCR1qXtWCntG0JQLGUjRtSBbGLmc1OEyYGaL4GRNkyx4o3xSgFUxj9MI8ivtKerxZDvBUdhBCXpoZqEN96GBXQe2ldtXlHDaTVf1XXMM3cV6Nm061sQis2g6EdWRztSI*4VqjtBV8jRlC2CsD2BR8yQdvrk0L6ab0Rr*oKfE9f8rX35cJyjLQopv!FWoFXe6JPPmdGVsYVxmmX7mgT1!BtevrBmR3lqfkCbqGLar4ZfMBHu5!1e4zQUyCq328RT*LgOlX*7
2018-08-08 10:22:50,157 [pool-3-thread-5] INFO  c.t.s.o.core.OAuthServiceComponent - [oauth] Return OAuth credential. Access token = EwAQA3hlBAAUS26g+KHGWHId2M6BBkwqoP+OSdAAASw8rW+eWyiibD6nvjpUqFJfvckYeGLIuL+c9k9e9V22fZxLURtbEVAtjgbCtRe2v7BcFOOZakwTP+JrWimhTsZZZaBtL12Som25E072ke0KtIfgTPJTm3bhJmnZHUmfzNCNzZcPuaGvad1ZsH7kFis88+SlqnXXqNjDcjyVsjgQNx9DuIdb8taJnuLO3Ks6QQLEReWhorlx0BVl9jTzaHP5B6HqQRchnJ9zVujINCjrjnkpQAZoHyxYJ+AJheCbVssbNzUXgibsT2u7AgKRH9JQDCmK/BLVvo5EDIyteVoPQ3ZWRanLtUyvqtAWC+BbZ/6jpueBhEEzTMjP6a1NEVsDZgAACIkr+qINOyck4AFPjBOwNvur4BKzdq/VMW2vm1EWR8uf9GEeV89OpVTg+qIhg2xCWoU+QmFmqBwxgoT6B/KlK9SdlKZe09t5u9w5qwzwegZNTCo3vy+Ks2jeziYNQgsx7x3RbkRUv9jGQ9YFL6d53FtTjvLplhnwV4y2Zx73Pv4B1KdgTJFkmBBOeG2brfSj0v2CTFT7h0E9klaGDXcMUznTDSJQL5BndV3kPYE13nNjjy1sWqWP3UBTVrlR/cT5/ZTm8sxVEJ8zBXEIQxXgMioMkS6PGi3R4qLzfZM/t0CP1UI/ssSaPW6JrE9F3nlLjKXBfU+x8CNYVqWEI6XNLYE6tw/UyrzOzY35HBmrpLG00FrdxK69WVM1qWQ6+RHkhwb6Y9JkPu1xlVPbdSWARCPYuhS6w9cuIfoA9OYbQ1Ehgk+rHG+VVxoFEZyb+m4wJg5S2kbiQ07OIa9aKuoE36vdios3LfLawGleiPe6gy8wPlaBKgfoXbsg6XHyag3y39sDNca5+g15OEL6R+UDoM6AXBdcHsV+N9DTcGJCP6+6dZq0+0CYQGzQGDWcxu7J6M3zT4WMFPErt2AVxK0QBXl12AcdJdKWwJK9B2EY6P3Q9G7anpaAb4aYKOZ/ej2IUIs4JOQHGsRUNTIVAg== for bing (clientID=869cad8e-f7c6-4854-b1bb-4f7955d142c3)
2018-08-08 10:22:50.157 (3) [pool-3-thread-5]: [oauth] Returning access token from OAuth service: EwAQA3hlBAAUS26g+KHGWHId2M6BBkwqoP+OSdAAASw8rW+eWyiibD6nvjpUqFJfvckYeGLIuL+c9k9e9V22fZxLURtbEVAtjgbCtRe2v7BcFOOZakwTP+JrWimhTsZZZaBtL12Som25E072ke0KtIfgTPJTm3bhJmnZHUmfzNCNzZcPuaGvad1ZsH7kFis88+SlqnXXqNjDcjyVsjgQNx9DuIdb8taJnuLO3Ks6QQLEReWhorlx0BVl9jTzaHP5B6HqQRchnJ9zVujINCjrjnkpQAZoHyxYJ+AJheCbVssbNzUXgibsT2u7AgKRH9JQDCmK/BLVvo5EDIyteVoPQ3ZWRanLtUyvqtAWC+BbZ/6jpueBhEEzTMjP6a1NEVsDZgAACIkr+qINOyck4AFPjBOwNvur4BKzdq/VMW2vm1EWR8uf9GEeV89OpVTg+qIhg2xCWoU+QmFmqBwxgoT6B/KlK9SdlKZe09t5u9w5qwzwegZNTCo3vy+Ks2jeziYNQgsx7x3RbkRUv9jGQ9YFL6d53FtTjvLplhnwV4y2Zx73Pv4B1KdgTJFkmBBOeG2brfSj0v2CTFT7h0E9klaGDXcMUznTDSJQL5BndV3kPYE13nNjjy1sWqWP3UBTVrlR/cT5/ZTm8sxVEJ8zBXEIQxXgMioMkS6PGi3R4qLzfZM/t0CP1UI/ssSaPW6JrE9F3nlLjKXBfU+x8CNYVqWEI6XNLYE6tw/UyrzOzY35HBmrpLG00FrdxK69WVM1qWQ6+RHkhwb6Y9JkPu1xlVPbdSWARCPYuhS6w9cuIfoA9OYbQ1Ehgk+rHG+VVxoFEZyb+m4wJg5S2kbiQ07OIa9aKuoE36vdios3LfLawGleiPe6gy8wPlaBKgfoXbsg6XHyag3y39sDNca5+g15OEL6R+UDoM6AXBdcHsV+N9DTcGJCP6+6dZq0+0CYQGzQGDWcxu7J6M3zT4WMFPErt2AVxK0QBXl12AcdJdKWwJK9B2EY6P3Q9G7anpaAb4aYKOZ/ej2IUIs4JOQHGsRUNTIVAg==
2018-08-08 10:22:50,162 [pool-3-thread-5] INFO  c.t.s.bing.BingAccountDeployer - BingAccountDeployer:getExistingCampaigns
2018-08-08 10:22:50,165 [pool-3-thread-5] INFO  jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`id` IN (4796,4797)

2018-08-08 10:22:50.168 (3) [pool-3-thread-5]: 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24002_GT is already set to Paused in the database.
2018-08-08 10:22:50.168 (3) [pool-3-thread-5]: 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24002_GT has no updated searchNetworkTargeting.
2018-08-08 10:22:50.168 (3) [pool-3-thread-5]: 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24002_GT target sync starting...
2018-08-08 10:22:50.168 (3) [pool-3-thread-5]: Platform Target unchanged platform_HighEndMobile 2.0
2018-08-08 10:22:50.168 (3) [pool-3-thread-5]: Platform Target unchanged platform_Tablet 4.0
2018-08-08 10:22:50.168 (3) [pool-3-thread-5]: Platform Target unchanged platform_Desktop 3.0
2018-08-08 10:22:50.168 (3) [pool-3-thread-5]: Proximity Target unchanged proximity_44646680,-73147528 24000 (meters)
2018-08-08 10:22:50.168 (3) [pool-3-thread-5]: 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24002_GT has no updated targets.
2018-08-08 10:22:50.168 (3) [pool-3-thread-5]: 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24002_GM is already set to Paused in the database.
2018-08-08 10:22:50.168 (3) [pool-3-thread-5]: 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24002_GM has no updated searchNetworkTargeting.
2018-08-08 10:22:50.168 (3) [pool-3-thread-5]: 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24002_GM target sync starting...
2018-08-08 10:22:50.168 (3) [pool-3-thread-5]: Platform Target unchanged platform_HighEndMobile 2.0
2018-08-08 10:22:50.168 (3) [pool-3-thread-5]: Platform Target unchanged platform_Tablet 4.0
2018-08-08 10:22:50.168 (3) [pool-3-thread-5]: Platform Target unchanged platform_Desktop 3.0
2018-08-08 10:22:50.168 (3) [pool-3-thread-5]: 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24002_GM has no updated targets.
2018-08-08 10:22:50.168 (3) [pool-3-thread-5]: 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24003_GT is already set to Paused in the database.
2018-08-08 10:22:50.168 (3) [pool-3-thread-5]: 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24003_GT has no updated searchNetworkTargeting.
2018-08-08 10:22:50.168 (3) [pool-3-thread-5]: 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24003_GT target sync starting...
2018-08-08 10:22:50.168 (3) [pool-3-thread-5]: Ignoring new target language_en
2018-08-08 10:22:50.168 (3) [pool-3-thread-5]: Ignoring new target network_GoogleSearch
2018-08-08 10:22:50.168 (3) [pool-3-thread-5]: Ignoring new target network_SearchNetwork
2018-08-08 10:22:50.168 (3) [pool-3-thread-5]: Platform Target unchanged platform_HighEndMobile 200.0
2018-08-08 10:22:50.168 (3) [pool-3-thread-5]: Platform Target unchanged platform_Tablet 400.0
2018-08-08 10:22:50.168 (3) [pool-3-thread-5]: Platform Target unchanged platform_Desktop 300.0
2018-08-08 10:22:50.168 (3) [pool-3-thread-5]: Proximity Target unchanged proximity_44.64667892456055,-73.14752960205078 24.0 (kilometers)
2018-08-08 10:22:50.168 (3) [pool-3-thread-5]: 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24003_GT has no updated targets.
2018-08-08 10:22:50.168 (3) [pool-3-thread-5]: 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24003_GM is already set to Paused in the database.
2018-08-08 10:22:50.168 (3) [pool-3-thread-5]: 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24003_GM has no updated searchNetworkTargeting.
2018-08-08 10:22:50.168 (3) [pool-3-thread-5]: 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24003_GM target sync starting...
2018-08-08 10:22:50.168 (3) [pool-3-thread-5]: Ignoring new target language_en
2018-08-08 10:22:50.168 (3) [pool-3-thread-5]: Ignoring new target network_GoogleSearch
2018-08-08 10:22:50.168 (3) [pool-3-thread-5]: Ignoring new target network_SearchNetwork
2018-08-08 10:22:50.168 (3) [pool-3-thread-5]: Platform Target unchanged platform_HighEndMobile 200.0
2018-08-08 10:22:50.168 (3) [pool-3-thread-5]: Platform Target unchanged platform_Tablet 400.0
2018-08-08 10:22:50.168 (3) [pool-3-thread-5]: Platform Target unchanged platform_Desktop 300.0
2018-08-08 10:22:50.168 (3) [pool-3-thread-5]: 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24003_GM has no updated targets.
2018-08-08 10:22:50.171 (3) [pool-37-thread-1]: Starting Google Update Campaign Worker..
2018-08-08 10:22:50.171 (3) [pool-37-thread-1]: Skipping feed sync
2018-08-08 10:22:50.171 (3) [pool-37-thread-1]: ----------------Google Content Editor starting
2018-08-08 10:22:50.173 (3) [pool-37-thread-2]: Starting Bing Update Campaign Worker..
2018-08-08 10:22:50.173 (3) [pool-37-thread-2]: Completed Bing Update Campaign Worker..
2018-08-08 10:22:50.176 (3) [pool-37-thread-1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2018-08-08 10:22:50.180 (3) [P11T1]: DistributionServiceRemoteClient created for 7782a00d-dc22-4770-b0ec-0a3aea79fe57_2_qa4amltest_FB_BM_01
2018-08-08 10:22:50.283 (3) [P11T1]: Creating API for reseller DistributionSettings b8a7d340-30e0-4369-97d0-8f901d238f86
2018-08-08 10:22:50.285 (3) [P11T1]: Retrieving credentials for search engine user id : 3606 || client id : 627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com , client secret :uO1pQj_ihl6Jy1fSA7FzCTFE , refresh token : 1/XElVvzhFJlFc7FcqtcZJbj1-erQxMLsEVlrN60XCc4JMrEt0pnthZ_A8mZru5Ei4
2018-08-08 10:22:50,285 [P11T1] INFO  c.t.s.o.core.OAuthServiceComponent - [oauth] Return OAuth credential. Access token = ya29.Gl3zBYr9QBwmMOD6WvNhLpbtWQyO49XTHJCpJDsmjqFOFb9bn397RotEN6JIqLrEQKe7Cfxb_BZux9Ak91sJKH2QCbpSxQ8NN-lUwxfbzh58rLWSlelQCAsx-Unr5PI for adwords (clientID=627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com)
2018-08-08 10:22:50.285 (3) [P11T1]: [oauth] Returning access token from OAuth service: ya29.Gl3zBYr9QBwmMOD6WvNhLpbtWQyO49XTHJCpJDsmjqFOFb9bn397RotEN6JIqLrEQKe7Cfxb_BZux9Ak91sJKH2QCbpSxQ8NN-lUwxfbzh58rLWSlelQCAsx-Unr5PI
2018-08-08 10:22:50.286 (3) [P11T1]: Retrieving credentials for search engine user id : 3606 || client id : 627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com , client secret :uO1pQj_ihl6Jy1fSA7FzCTFE , refresh token : 1/XElVvzhFJlFc7FcqtcZJbj1-erQxMLsEVlrN60XCc4JMrEt0pnthZ_A8mZru5Ei4
2018-08-08 10:22:50,286 [P11T1] INFO  c.t.s.o.core.OAuthServiceComponent - [oauth] Return OAuth credential. Access token = ya29.Gl3zBYr9QBwmMOD6WvNhLpbtWQyO49XTHJCpJDsmjqFOFb9bn397RotEN6JIqLrEQKe7Cfxb_BZux9Ak91sJKH2QCbpSxQ8NN-lUwxfbzh58rLWSlelQCAsx-Unr5PI for adwords (clientID=627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com)
2018-08-08 10:22:50.286 (3) [P11T1]: [oauth] Returning access token from OAuth service: ya29.Gl3zBYr9QBwmMOD6WvNhLpbtWQyO49XTHJCpJDsmjqFOFb9bn397RotEN6JIqLrEQKe7Cfxb_BZux9Ak91sJKH2QCbpSxQ8NN-lUwxfbzh58rLWSlelQCAsx-Unr5PI
2018-08-08 10:22:50.286 (3) [P11T1]: DistributionServiceRemoteClient created for GMB
2018-08-08 10:22:50.301 (3) [P11T1]: Retrieving GMB credentials for search engine user id : 3606 || client id : 627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com , client secret :uO1pQj_ihl6Jy1fSA7FzCTFE , refresh token : 1/fH9q5og0rO9LI5NBJqM4k_YTHb-0XSo2-Qv53oyo5a0
2018-08-08 10:22:50,301 [P11T1] INFO  c.t.s.o.core.OAuthServiceComponent - [oauth] Return OAuth credential. Access token = ya29.Gl3zBT9UPnSb8zwTZdDOaABAwsEn6CRsSh2UtDtma77Kp3dQ3dFh_BG1ZlWAqnhyvT3p0mdBO9i0JvL2CE-LiJYcSsyxW14StKmHMTwdYe4VjFNL8xviC8kmsXVq2mI for gmb (clientID=627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com)
2018-08-08 10:22:50.301 (3) [P11T1]: DistributionServiceRemoteClient created for 7782a00d-dc22-4770-b0ec-0a3aea79fe57_2_qa4amltest_FB_BM_01
2018-08-08 10:22:50.400 (3) [P11T1]: Creating API for reseller DistributionSettings b8a7d340-30e0-4369-97d0-8f901d238f86
2018-08-08 10:22:50.401 (3) [P11T1]: Retrieving credentials for search engine user id : 3606 || client id : 627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com , client secret :uO1pQj_ihl6Jy1fSA7FzCTFE , refresh token : 1/XElVvzhFJlFc7FcqtcZJbj1-erQxMLsEVlrN60XCc4JMrEt0pnthZ_A8mZru5Ei4
2018-08-08 10:22:50,401 [P11T1] INFO  c.t.s.o.core.OAuthServiceComponent - [oauth] Return OAuth credential. Access token = ya29.Gl3zBYr9QBwmMOD6WvNhLpbtWQyO49XTHJCpJDsmjqFOFb9bn397RotEN6JIqLrEQKe7Cfxb_BZux9Ak91sJKH2QCbpSxQ8NN-lUwxfbzh58rLWSlelQCAsx-Unr5PI for adwords (clientID=627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com)
2018-08-08 10:22:50.402 (3) [P11T1]: [oauth] Returning access token from OAuth service: ya29.Gl3zBYr9QBwmMOD6WvNhLpbtWQyO49XTHJCpJDsmjqFOFb9bn397RotEN6JIqLrEQKe7Cfxb_BZux9Ak91sJKH2QCbpSxQ8NN-lUwxfbzh58rLWSlelQCAsx-Unr5PI
2018-08-08 10:22:50.402 (3) [P11T1]: Retrieving credentials for search engine user id : 3606 || client id : 627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com , client secret :uO1pQj_ihl6Jy1fSA7FzCTFE , refresh token : 1/XElVvzhFJlFc7FcqtcZJbj1-erQxMLsEVlrN60XCc4JMrEt0pnthZ_A8mZru5Ei4
2018-08-08 10:22:50,402 [P11T1] INFO  c.t.s.o.core.OAuthServiceComponent - [oauth] Return OAuth credential. Access token = ya29.Gl3zBYr9QBwmMOD6WvNhLpbtWQyO49XTHJCpJDsmjqFOFb9bn397RotEN6JIqLrEQKe7Cfxb_BZux9Ak91sJKH2QCbpSxQ8NN-lUwxfbzh58rLWSlelQCAsx-Unr5PI for adwords (clientID=627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com)
2018-08-08 10:22:50.402 (3) [P11T1]: [oauth] Returning access token from OAuth service: ya29.Gl3zBYr9QBwmMOD6WvNhLpbtWQyO49XTHJCpJDsmjqFOFb9bn397RotEN6JIqLrEQKe7Cfxb_BZux9Ak91sJKH2QCbpSxQ8NN-lUwxfbzh58rLWSlelQCAsx-Unr5PI
2018-08-08 10:22:50.402 (3) [P11T1]: DistributionServiceRemoteClient created for GMB
2018-08-08 10:22:50.418 (3) [P11T1]: Retrieving GMB credentials for search engine user id : 3606 || client id : 627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com , client secret :uO1pQj_ihl6Jy1fSA7FzCTFE , refresh token : 1/fH9q5og0rO9LI5NBJqM4k_YTHb-0XSo2-Qv53oyo5a0
2018-08-08 10:22:50,418 [P11T1] INFO  c.t.s.o.core.OAuthServiceComponent - [oauth] Return OAuth credential. Access token = ya29.Gl3zBT9UPnSb8zwTZdDOaABAwsEn6CRsSh2UtDtma77Kp3dQ3dFh_BG1ZlWAqnhyvT3p0mdBO9i0JvL2CE-LiJYcSsyxW14StKmHMTwdYe4VjFNL8xviC8kmsXVq2mI for gmb (clientID=627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com)
2018-08-08 10:22:50.428 (2) [P11T1]: CampaignTargetDAO: database is null
2018-08-08 10:22:50.435 (3) [P11T1]: ... SEUser 3606 finished
2018-08-08 10:22:50.436 (3) [pool-37-thread-1]: ------------Google Content Editor done
2018-08-08 10:22:50.436 (3) [pool-37-thread-1]: Completed Google Update Campaign Worker..
2018-08-08 10:22:50.437 (3) [pool-3-thread-5]: Running content editor replace for accountID 2402
2018-08-08 10:22:50.437 (3) [pool-40-thread-1]: Starting Google Replace Keywords Worker..
2018-08-08 10:22:50.437 (3) [pool-40-thread-2]: Starting Bing Replace Keywords Worker..
2018-08-08 10:22:50,437 [pool-40-thread-2] INFO  c.t.s.bing.BingAccountDeployer - BingAccountDeployer: replaceKeywords
2018-08-08 10:22:50.438 (3) [pool-40-thread-1]: ----------------Google Content Editor starting
2018-08-08 10:22:50,439 [pool-40-thread-2] INFO  jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`id` IN (4796,4797)

2018-08-08 10:22:50,442 [pool-40-thread-2] INFO  c.t.s.bing.BingAccountDeployer - accountID 2402: diffing 2 campaigns
2018-08-08 10:22:50.444 (3) [pool-40-thread-1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2018-08-08 10:22:50.445 (3) [P12T1]: DistributionServiceRemoteClient created for 7782a00d-dc22-4770-b0ec-0a3aea79fe57_2_qa4amltest_FB_BM_01
2018-08-08 10:22:50,445 [pool-40-thread-2] INFO  jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`id` IN (4796,4797)

2018-08-08 10:22:50,447 [pool-40-thread-2] INFO  c.t.s.c.b.impl.BingAdsServiceFactory - USING PRODUCTION ENVIRONMENT
2018-08-08 10:22:50,447 [pool-40-thread-2] DEBUG c.t.s.client.bing.impl.BingAdsClient - Created BingAdsClient for 150147359
2018-08-08 10:22:50,449 [pool-40-thread-2] INFO  jdbc.sqlonly - DELETE FROM `errors` WHERE `campaignName` IN ('7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24003_GT','7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24003_GM')
AND `itemType` IN ('AD_GROUP_KEYWORDS','AD_GROUP_KEYWORDS_CREATE_REQUEST','AD_GROUP_KEYWORDS_DELETE_REQUEST','CAMPAIGN_NEGATIVE_KEYWORDS','CAMPAIGN_NEGATIVE_KEYWORDS_CREATE_REQUEST','CAMPAIGN_NEGATIVE_KEYWORDS_DELETE_REQUEST')

2018-08-08 10:22:50,449 [pool-40-thread-2] INFO  c.t.s.client.bing.dao.BingErrorDAO - Removed '0' Previous Keyword Errors
2018-08-08 10:22:50,450 [pool-40-thread-2] INFO  jdbc.sqlonly - DELETE FROM `errors` WHERE `campaignName` IN ('7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24003_GT','7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24003_GM')
AND `itemType` IN ('AD_GROUP_KEYWORDS','AD_GROUP_KEYWORDS_CREATE_REQUEST','AD_GROUP_KEYWORDS_DELETE_REQUEST','CAMPAIGN_NEGATIVE_KEYWORDS','CAMPAIGN_NEGATIVE_KEYWORDS_CREATE_REQUEST','CAMPAIGN_NEGATIVE_KEYWORDS_DELETE_REQUEST')

2018-08-08 10:22:50,450 [pool-40-thread-2] INFO  c.t.s.client.bing.dao.BingErrorDAO - Removed '0' Previous Keyword Errors
2018-08-08 10:22:50,451 [pool-40-thread-2] INFO  jdbc.sqlonly - UPDATE `campaigns` SET `campaigns`.`bingId` = 349366014, `campaigns`.`name` = '7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24003_GT',
`campaigns`.`status` = 'Paused', `campaigns`.`lastUpdated` = NOW(), `campaigns`.`json` = '{"siteLinks":null,"calloutExtensions":null,"campaign":{"timeZone":"EasternTimeUSCanada","campaignType":["SearchAndContent"],"searchEngineId":349366014,"budgetPeriod":"DailyBudgetAccelerated","status":"Paused","budgetAmount":0.05,"name":"7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24003_GT"},"callExtensions":null,"locationExtensions":null,"campaignTargets":[{"bingTarget":{"BingLocationType":"BingDeviceTarget","deviceName":"Tablets","code":"Tablets","type":"DeviceCriterion"},"bidMultiplier":400.0,"campaignId":349366014,"id":8177656095718},{"bingTarget":{"BingLocationType":"BingRadiusTarget","latitudeDegrees":44.64667892456055,"longitudeDegrees":-73.14752960205078,"radius":24,"bingRadiusUnit":"Kilometers","code":"44.64667892456055,-73.14752960205078","type":"RadiusCriterion"},"bidMultiplier":null,"campaignId":349366014,"id":8177656095715},{"bingTarget":{"BingLocationType":"BingDeviceTarget","deviceName":"Smartphones","code":"Smartphones","type":"DeviceCriterion"},"bidMultiplier":200.0,"campaignId":349366014,"id":8177656095717},{"bingTarget":{"BingLocationType":"BingDeviceTarget","deviceName":"Computers","code":"Computers","type":"DeviceCriterion"},"bidMultiplier":300.0,"campaignId":349366014,"id":8177656095716}],"negativeKeywords":[{"text":"bed
and breakfast","matchType":"Phrase","id":14294282683866},{"text":"salary","matchType":"Phrase","id":14294282683867},{"text":"schools","matchType":"Phrase","id":14294282683868},{"text":"career","matchType":"Phrase","id":14294282683869},{"text":"hostel","matchType":"Phrase","id":14294282683870},{"text":"how
to","matchType":"Phrase","id":14294282683871},{"text":"job","matchType":"Phrase","id":14294282683872},{"text":"careers","matchType":"Phrase","id":14294282683873},{"text":"how
can","matchType":"Phrase","id":14294282683874},{"text":"degrees","matchType":"Phrase","id":14294282683875},{"text":"what
is","matchType":"Phrase","id":14294282683876},{"text":"jobs","matchType":"Phrase","id":14294282683877},{"text":"certifications","matchType":"Phrase","id":14294282683878},{"text":"motels","matchType":"Phrase","id":14294282683879},{"text":"campgrounds","matchType":"Phrase","id":14294282683880},{"text":"pay","matchType":"Phrase","id":14294282683881},{"text":"diploma","matchType":"Phrase","id":14294282683882},{"text":"wages","matchType":"Phrase","id":14294282683883},{"text":"what
can","matchType":"Phrase","id":14294282683884},{"text":"how do","matchType":"Phrase","id":14294282683885},{"text":"school","matchType":"Phrase","id":14294282683886},{"text":"b&b","matchType":"Phrase","id":14294282683887},{"text":"what
to","matchType":"Phrase","id":14294282683888},{"text":"course","matchType":"Phrase","id":14294282683889},{"text":"training","matchType":"Phrase","id":14294282683890},{"text":"certification","matchType":"Phrase","id":14294282683891},{"text":"degree","matchType":"Phrase","id":14294282683892},{"text":"home
rental","matchType":"Phrase","id":14294282683893},{"text":"courses","matchType":"Phrase","id":14294282683894},{"text":"what
do","matchType":"Phrase","id":14294282683895},{"text":"motel","matchType":"Phrase","id":14294282683896},{"text":"diplomas","matchType":"Phrase","id":14294282683897},{"text":"home
rentals","matchType":"Phrase","id":14294282683898},{"text":"hostels","matchType":"Phrase","id":14294282683899},{"text":"classes","matchType":"Phrase","id":14294282683900},{"text":"campground","matchType":"Phrase","id":14294282683901},{"text":"earnings","matchType":"Phrase","id":14294282683902},{"text":"bed
& breakfast","matchType":"Phrase","id":14294282683903},{"text":"b & b","matchType":"Phrase","id":14294282683904},{"text":"class","matchType":"Phrase","id":14294282683905},{"text":"camping","matchType":"Phrase","id":14294282683906},{"text":"management","matchType":"Phrase","id":14294282683907}],"adGroupStructures":[{"adGroup":{"adDistribution":["Search"],"pricingModel":"Cpc","contentMatchBid":0.0,"network":"OwnedAndOperatedAndSyndicatedSearch","searchBid":0.05000000074505806,"language":"English","id":1278732155895713,"status":"Active","name":"7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24003"},"positiveKeywords":[{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"hotel
room in my area","matchType":"Exact","id":79920841553023},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"hotels
closest to me","matchType":"Exact","id":79920841553024},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"guest
room closest to me","matchType":"Exact","id":79920841553025},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"hotel
rooms closest to me","matchType":"Exact","id":79920841553026},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"hotels
near me","matchType":"Exact","id":79920841553027},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"book
hotels","matchType":"Exact","id":79920841553028},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"guest
rooms in my area","matchType":"Exact","id":79920841553029},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"hotel
near me","matchType":"Exact","id":79920841553030},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"hotel
finder","matchType":"Exact","id":79920841553031},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"hotel","matchType":"Exact","id":79920841553032},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"hotel
search","matchType":"Exact","id":79920841553033},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"book
hotel rooms","matchType":"Exact","id":79920841553034},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"guest
rooms","matchType":"Exact","id":79920841553035},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"lodging","matchType":"Exact","id":79920841553036},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"hotel
room closest to me","matchType":"Exact","id":79920841553037},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"hotels
in best","matchType":"Exact","id":79920841553038},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"hotels
in my area","matchType":"Exact","id":79920841553039},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"book
guest rooms","matchType":"Exact","id":79920841553040},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"hotel
rooms in my area","matchType":"Exact","id":79920841553041},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"hotel
closest to me","matchType":"Exact","id":79920841553042},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"boook
a hotel","matchType":"Exact","id":79920841553043},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"guest
room in my area","matchType":"Exact","id":79920841553044},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"hotel
reservations","matchType":"Exact","id":79920841553045},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"guest
rooms closest to me","matchType":"Exact","id":79920841553046},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"hotel
rate","matchType":"Exact","id":79920841553047},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"hotel
in my area","matchType":"Exact","id":79920841553048},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"guest
rooms near me","matchType":"Exact","id":79920841553049},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"hotel
room near me","matchType":"Exact","id":79920841553050},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"hotel
rooms","matchType":"Exact","id":79920841553051},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"guest
room near me","matchType":"Exact","id":79920841553052},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"hotel
rooms near me","matchType":"Exact","id":79920841553053},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"hotels","matchType":"Exact","id":79920841553054},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"hotel
reservation","matchType":"Exact","id":79920841553055},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"hotel
rates","matchType":"Exact","id":79920841553056}],"ads":[{"text":"Milton VT Guest Rooms. Great
Service & Location.","displayUrl":"www.merchantsite.com/Hotel/Milton_VT","path1":"Hotel","path2":"Milton_VT","title1":"Find
a Hotel","title2":"Hotel Rooms Milton VT","adType":"ExpandedText","editorialStatus":null,"finalUrls":["http://www.merchantsite.com/"],"status":"Active","id":79920796235724},{"text":"Milton
VT Guest Rooms. Find Out Why Guests Love Us!","displayUrl":"www.merchantsite.com/Hotel/Milton_VT","path1":"Hotel","path2":"Milton_VT","title1":"Hotel
Deals","title2":"Hotel - Milton VT","adType":"ExpandedText","editorialStatus":null,"finalUrls":["http://www.merchantsite.com/"],"status":"Active","id":79920796235725},{"text":"Milton
VT Guest Rooms. Find Out Why Guests Love Us!","displayUrl":"www.merchantsite.com/Hotel/Milton_VT","path1":"Hotel","path2":"Milton_VT","title1":"{KeyWord:Hotel
- Milton VT}","title2":"Hotel Deals","adType":"ExpandedText","editorialStatus":null,"finalUrls":["http://www.merchantsite.com/"],"status":"Active","id":79920796235726},{"text":"Milton
VT Guest Rooms. Great Service & Location.","displayUrl":"www.merchantsite.com/Hotel/Milton_VT","path1":"Hotel","path2":"Milton_VT","title1":"{KeyWord:Hotel
Rooms Milton VT}","title2":"Find a Hotel","adType":"ExpandedText","editorialStatus":null,"finalUrls":["http://www.merchantsite.com/"],"status":"Active","id":79920796235727}]}],"campaignCallExtension":null,"campaignLocationExtension":null,"campaignSiteLinks":null,"campaignCalloutExtensions":null}'
WHERE `campaigns`.`id` = 4796

2018-08-08 10:22:50,452 [pool-40-thread-2] INFO  jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`id` = 4796

2018-08-08 10:22:50,453 [pool-40-thread-2] INFO  jdbc.sqlonly - UPDATE `campaigns` SET `campaigns`.`bingId` = 349366015, `campaigns`.`name` = '7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24003_GM',
`campaigns`.`status` = 'Paused', `campaigns`.`lastUpdated` = NOW(), `campaigns`.`json` = '{"siteLinks":null,"calloutExtensions":null,"campaign":{"timeZone":"EasternTimeUSCanada","campaignType":["SearchAndContent"],"searchEngineId":349366015,"budgetPeriod":"DailyBudgetAccelerated","status":"Paused","budgetAmount":0.05,"name":"7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24003_GM"},"callExtensions":null,"locationExtensions":null,"campaignTargets":[{"bingTarget":{"BingLocationType":"BingDeviceTarget","deviceName":"Tablets","code":"Tablets","type":"DeviceCriterion"},"bidMultiplier":400.0,"campaignId":349366015,"id":8177656095722},{"bingTarget":{"BingLocationType":"BingLocationTarget","displayName":"Vermont|United
States","locationType":"State","locationID":4131,"code":"4131","type":"LocationCriterion"},"bidMultiplier":null,"campaignId":349366015,"id":8177656095719},{"bingTarget":{"BingLocationType":"BingDeviceTarget","deviceName":"Smartphones","code":"Smartphones","type":"DeviceCriterion"},"bidMultiplier":200.0,"campaignId":349366015,"id":8177656095721},{"bingTarget":{"BingLocationType":"BingDeviceTarget","deviceName":"Computers","code":"Computers","type":"DeviceCriterion"},"bidMultiplier":300.0,"campaignId":349366015,"id":8177656095720}],"negativeKeywords":[{"text":"bed
and breakfast","matchType":"Phrase","id":14363002038713},{"text":"salary","matchType":"Phrase","id":14363002038714},{"text":"schools","matchType":"Phrase","id":14363002038715},{"text":"career","matchType":"Phrase","id":14363002038716},{"text":"hostel","matchType":"Phrase","id":14363002038717},{"text":"how
to","matchType":"Phrase","id":14363002038718},{"text":"job","matchType":"Phrase","id":14363002038719},{"text":"careers","matchType":"Phrase","id":14363002038720},{"text":"how
can","matchType":"Phrase","id":14363002038721},{"text":"degrees","matchType":"Phrase","id":14363002038722},{"text":"what
is","matchType":"Phrase","id":14363002038723},{"text":"jobs","matchType":"Phrase","id":14363002038724},{"text":"certifications","matchType":"Phrase","id":14363002038725},{"text":"motels","matchType":"Phrase","id":14363002038726},{"text":"campgrounds","matchType":"Phrase","id":14363002038727},{"text":"pay","matchType":"Phrase","id":14363002038728},{"text":"diploma","matchType":"Phrase","id":14363002038729},{"text":"wages","matchType":"Phrase","id":14363002038730},{"text":"what
can","matchType":"Phrase","id":14363002038731},{"text":"how do","matchType":"Phrase","id":14363002038732},{"text":"school","matchType":"Phrase","id":14363002038733},{"text":"b&b","matchType":"Phrase","id":14363002038734},{"text":"what
to","matchType":"Phrase","id":14363002038735},{"text":"course","matchType":"Phrase","id":14363002038736},{"text":"training","matchType":"Phrase","id":14363002038737},{"text":"certification","matchType":"Phrase","id":14363002038738},{"text":"degree","matchType":"Phrase","id":14363002038739},{"text":"home
rental","matchType":"Phrase","id":14363002038740},{"text":"courses","matchType":"Phrase","id":14363002038741},{"text":"what
do","matchType":"Phrase","id":14363002038742},{"text":"motel","matchType":"Phrase","id":14363002038743},{"text":"diplomas","matchType":"Phrase","id":14363002038744},{"text":"home
rentals","matchType":"Phrase","id":14363002038745},{"text":"hostels","matchType":"Phrase","id":14363002038746},{"text":"classes","matchType":"Phrase","id":14363002038747},{"text":"campground","matchType":"Phrase","id":14363002038748},{"text":"earnings","matchType":"Phrase","id":14363002038749},{"text":"bed
& breakfast","matchType":"Phrase","id":14363002038750},{"text":"b & b","matchType":"Phrase","id":14363002038751},{"text":"class","matchType":"Phrase","id":14363002038752},{"text":"camping","matchType":"Phrase","id":14363002038753},{"text":"management","matchType":"Phrase","id":14363002038754}],"adGroupStructures":[{"adGroup":{"adDistribution":["Search"],"pricingModel":"Cpc","contentMatchBid":0.0,"network":"OwnedAndOperatedAndSyndicatedSearch","searchBid":0.05000000074505806,"language":"English","id":1285329225523607,"status":"Active","name":"7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24003_Milton,
VT"},"positiveKeywords":[{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"+hotel
+finder +Milton +VT ","matchType":"Broad","id":80333158690340},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"+accommodation
+Milton +VT ","matchType":"Broad","id":80333158690341},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"+book
+hotels +Milton +VT ","matchType":"Broad","id":80333158690342},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"+hotels
+Milton +VT ","matchType":"Broad","id":80333158690343},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"+hotel
+Milton +VT ","matchType":"Broad","id":80333158690344},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"+hotel
+search +Milton +VT ","matchType":"Broad","id":80333158690345},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"+hotel
+reservations +Milton +VT ","matchType":"Broad","id":80333158690346},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"+guest
+rooms +Milton +VT ","matchType":"Broad","id":80333158690347},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"+lodging
+Milton +VT ","matchType":"Broad","id":80333158690348},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"+accommodations
+Milton +VT ","matchType":"Broad","id":80333158690349},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"+hotel
+reservation +Milton +VT ","matchType":"Broad","id":80333158690350},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"+hotel
+rooms +Milton +VT ","matchType":"Broad","id":80333158690351},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"+hotel
+rates +Milton +VT ","matchType":"Broad","id":80333158690352},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"+hotel
+rate +Milton +VT ","matchType":"Broad","id":80333158690353}],"ads":[{"text":"Milton VT Guest
Rooms. Great Service & Location.","displayUrl":"www.merchantsite.com/Hotel/Milton_VT","path1":"Hotel","path2":"Milton_VT","title1":"Find
a Hotel","title2":"Hotel Rooms Milton VT","adType":"ExpandedText","editorialStatus":null,"finalUrls":["http://www.merchantsite.com/"],"status":"Active","id":80333112946186},{"text":"Milton
VT Guest Rooms. Find Out Why Guests Love Us!","displayUrl":"www.merchantsite.com/Hotel/Milton_VT","path1":"Hotel","path2":"Milton_VT","title1":"Hotel
Deals","title2":"Hotel - Milton VT","adType":"ExpandedText","editorialStatus":null,"finalUrls":["http://www.merchantsite.com/"],"status":"Active","id":80333112946187},{"text":"Milton
VT Guest Rooms. Find Out Why Guests Love Us!","displayUrl":"www.merchantsite.com/Hotel/Milton_VT","path1":"Hotel","path2":"Milton_VT","title1":"{KeyWord:Hotel
- Milton VT}","title2":"Hotel Deals","adType":"ExpandedText","editorialStatus":null,"finalUrls":["http://www.merchantsite.com/"],"status":"Active","id":80333112946188},{"text":"Milton
VT Guest Rooms. Great Service & Location.","displayUrl":"www.merchantsite.com/Hotel/Milton_VT","path1":"Hotel","path2":"Milton_VT","title1":"{KeyWord:Hotel
Rooms Milton VT}","title2":"Find a Hotel","adType":"ExpandedText","editorialStatus":null,"finalUrls":["http://www.merchantsite.com/"],"status":"Active","id":80333112946189}]},{"adGroup":{"adDistribution":["Search"],"pricingModel":"Cpc","contentMatchBid":0.0,"network":"OwnedAndOperatedAndSyndicatedSearch","searchBid":0.05000000074505806,"language":"English","id":1286428737150088,"status":"Active","name":"7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24003_Milton
Vermont"},"positiveKeywords":[{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"+hotels
+Milton +Vermont ","matchType":"Broad","id":80401878158534},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"+hotel
+rate +Milton +Vermont ","matchType":"Broad","id":80401878158535},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"+hotel
+rates +Milton +Vermont ","matchType":"Broad","id":80401878158536},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"+hotel
+reservations +Milton +Vermont ","matchType":"Broad","id":80401878158537},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"+accommodation
+Milton +Vermont ","matchType":"Broad","id":80401878158538},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"+book
+hotels +Milton +Vermont ","matchType":"Broad","id":80401878158539},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"+lodging
+Milton +Vermont ","matchType":"Broad","id":80401878158540},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"+hotel
+Milton +Vermont ","matchType":"Broad","id":80401878158541},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"+hotel
+reservation +Milton +Vermont ","matchType":"Broad","id":80401878158542},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"+guest
+rooms +Milton +Vermont ","matchType":"Broad","id":80401878158543},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"+hotel
+finder +Milton +Vermont ","matchType":"Broad","id":80401878158544},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"+hotel
+rooms +Milton +Vermont ","matchType":"Broad","id":80401878158545},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"+hotel
+search +Milton +Vermont ","matchType":"Broad","id":80401878158546},{"editorialStatus":null,"finalUrls":null,"status":"Active","text":"+accommodations
+Milton +Vermont ","matchType":"Broad","id":80401878158547}],"ads":[{"text":"Milton VT Guest
Rooms. Great Service & Location.","displayUrl":"www.merchantsite.com/Hotel/Milton_VT","path1":"Hotel","path2":"Milton_VT","title1":"Find
a Hotel","title2":"Hotel Rooms Milton VT","adType":"ExpandedText","editorialStatus":null,"finalUrls":["http://www.merchantsite.com/"],"status":"Active","id":80401832946663},{"text":"Milton
VT Guest Rooms. Find Out Why Guests Love Us!","displayUrl":"www.merchantsite.com/Hotel/Milton_VT","path1":"Hotel","path2":"Milton_VT","title1":"Hotel
Deals","title2":"Hotel - Milton VT","adType":"ExpandedText","editorialStatus":null,"finalUrls":["http://www.merchantsite.com/"],"status":"Active","id":80401832946664},{"text":"Milton
VT Guest Rooms. Find Out Why Guests Love Us!","displayUrl":"www.merchantsite.com/Hotel/Milton_VT","path1":"Hotel","path2":"Milton_VT","title1":"{KeyWord:Hotel
- Milton VT}","title2":"Hotel Deals","adType":"ExpandedText","editorialStatus":null,"finalUrls":["http://www.merchantsite.com/"],"status":"Active","id":80401832946665},{"text":"Milton
VT Guest Rooms. Great Service & Location.","displayUrl":"www.merchantsite.com/Hotel/Milton_VT","path1":"Hotel","path2":"Milton_VT","title1":"{KeyWord:Hotel
Rooms Milton VT}","title2":"Find a Hotel","adType":"ExpandedText","editorialStatus":null,"finalUrls":["http://www.merchantsite.com/"],"status":"Active","id":80401832946666}]}],"campaignCallExtension":null,"campaignLocationExtension":null,"campaignSiteLinks":null,"campaignCalloutExtensions":null}'
WHERE `campaigns`.`id` = 4797

2018-08-08 10:22:50,455 [pool-40-thread-2] INFO  jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`id` = 4797

2018-08-08 10:22:50.457 (3) [pool-40-thread-2]: Completed Bing Replace Keywords Worker..
2018-08-08 10:22:50.546 (3) [P12T1]: Creating API for reseller DistributionSettings b8a7d340-30e0-4369-97d0-8f901d238f86
2018-08-08 10:22:50.549 (3) [P12T1]: Retrieving credentials for search engine user id : 3606 || client id : 627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com , client secret :uO1pQj_ihl6Jy1fSA7FzCTFE , refresh token : 1/XElVvzhFJlFc7FcqtcZJbj1-erQxMLsEVlrN60XCc4JMrEt0pnthZ_A8mZru5Ei4
2018-08-08 10:22:50,549 [P12T1] INFO  c.t.s.o.core.OAuthServiceComponent - [oauth] Return OAuth credential. Access token = ya29.Gl3zBYr9QBwmMOD6WvNhLpbtWQyO49XTHJCpJDsmjqFOFb9bn397RotEN6JIqLrEQKe7Cfxb_BZux9Ak91sJKH2QCbpSxQ8NN-lUwxfbzh58rLWSlelQCAsx-Unr5PI for adwords (clientID=627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com)
2018-08-08 10:22:50.549 (3) [P12T1]: [oauth] Returning access token from OAuth service: ya29.Gl3zBYr9QBwmMOD6WvNhLpbtWQyO49XTHJCpJDsmjqFOFb9bn397RotEN6JIqLrEQKe7Cfxb_BZux9Ak91sJKH2QCbpSxQ8NN-lUwxfbzh58rLWSlelQCAsx-Unr5PI
2018-08-08 10:22:50.549 (3) [P12T1]: Retrieving credentials for search engine user id : 3606 || client id : 627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com , client secret :uO1pQj_ihl6Jy1fSA7FzCTFE , refresh token : 1/XElVvzhFJlFc7FcqtcZJbj1-erQxMLsEVlrN60XCc4JMrEt0pnthZ_A8mZru5Ei4
2018-08-08 10:22:50,549 [P12T1] INFO  c.t.s.o.core.OAuthServiceComponent - [oauth] Return OAuth credential. Access token = ya29.Gl3zBYr9QBwmMOD6WvNhLpbtWQyO49XTHJCpJDsmjqFOFb9bn397RotEN6JIqLrEQKe7Cfxb_BZux9Ak91sJKH2QCbpSxQ8NN-lUwxfbzh58rLWSlelQCAsx-Unr5PI for adwords (clientID=627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com)
2018-08-08 10:22:50.549 (3) [P12T1]: [oauth] Returning access token from OAuth service: ya29.Gl3zBYr9QBwmMOD6WvNhLpbtWQyO49XTHJCpJDsmjqFOFb9bn397RotEN6JIqLrEQKe7Cfxb_BZux9Ak91sJKH2QCbpSxQ8NN-lUwxfbzh58rLWSlelQCAsx-Unr5PI
2018-08-08 10:22:50.549 (3) [P12T1]: DistributionServiceRemoteClient created for GMB
2018-08-08 10:22:50.566 (3) [P12T1]: Retrieving GMB credentials for search engine user id : 3606 || client id : 627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com , client secret :uO1pQj_ihl6Jy1fSA7FzCTFE , refresh token : 1/fH9q5og0rO9LI5NBJqM4k_YTHb-0XSo2-Qv53oyo5a0
2018-08-08 10:22:50,566 [P12T1] INFO  c.t.s.o.core.OAuthServiceComponent - [oauth] Return OAuth credential. Access token = ya29.Gl3zBT9UPnSb8zwTZdDOaABAwsEn6CRsSh2UtDtma77Kp3dQ3dFh_BG1ZlWAqnhyvT3p0mdBO9i0JvL2CE-LiJYcSsyxW14StKmHMTwdYe4VjFNL8xviC8kmsXVq2mI for gmb (clientID=627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com)
2018-08-08 10:22:50.566 (3) [P12T1]: DistributionServiceRemoteClient created for 7782a00d-dc22-4770-b0ec-0a3aea79fe57_2_qa4amltest_FB_BM_01
2018-08-08 10:22:50.669 (3) [P12T1]: Creating API for reseller DistributionSettings b8a7d340-30e0-4369-97d0-8f901d238f86
2018-08-08 10:22:50.670 (3) [P12T1]: Retrieving credentials for search engine user id : 3606 || client id : 627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com , client secret :uO1pQj_ihl6Jy1fSA7FzCTFE , refresh token : 1/XElVvzhFJlFc7FcqtcZJbj1-erQxMLsEVlrN60XCc4JMrEt0pnthZ_A8mZru5Ei4
2018-08-08 10:22:50,670 [P12T1] INFO  c.t.s.o.core.OAuthServiceComponent - [oauth] Return OAuth credential. Access token = ya29.Gl3zBYr9QBwmMOD6WvNhLpbtWQyO49XTHJCpJDsmjqFOFb9bn397RotEN6JIqLrEQKe7Cfxb_BZux9Ak91sJKH2QCbpSxQ8NN-lUwxfbzh58rLWSlelQCAsx-Unr5PI for adwords (clientID=627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com)
2018-08-08 10:22:50.670 (3) [P12T1]: [oauth] Returning access token from OAuth service: ya29.Gl3zBYr9QBwmMOD6WvNhLpbtWQyO49XTHJCpJDsmjqFOFb9bn397RotEN6JIqLrEQKe7Cfxb_BZux9Ak91sJKH2QCbpSxQ8NN-lUwxfbzh58rLWSlelQCAsx-Unr5PI
2018-08-08 10:22:50.670 (3) [P12T1]: Retrieving credentials for search engine user id : 3606 || client id : 627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com , client secret :uO1pQj_ihl6Jy1fSA7FzCTFE , refresh token : 1/XElVvzhFJlFc7FcqtcZJbj1-erQxMLsEVlrN60XCc4JMrEt0pnthZ_A8mZru5Ei4
2018-08-08 10:22:50,671 [P12T1] INFO  c.t.s.o.core.OAuthServiceComponent - [oauth] Return OAuth credential. Access token = ya29.Gl3zBYr9QBwmMOD6WvNhLpbtWQyO49XTHJCpJDsmjqFOFb9bn397RotEN6JIqLrEQKe7Cfxb_BZux9Ak91sJKH2QCbpSxQ8NN-lUwxfbzh58rLWSlelQCAsx-Unr5PI for adwords (clientID=627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com)
2018-08-08 10:22:50.671 (3) [P12T1]: [oauth] Returning access token from OAuth service: ya29.Gl3zBYr9QBwmMOD6WvNhLpbtWQyO49XTHJCpJDsmjqFOFb9bn397RotEN6JIqLrEQKe7Cfxb_BZux9Ak91sJKH2QCbpSxQ8NN-lUwxfbzh58rLWSlelQCAsx-Unr5PI
2018-08-08 10:22:50.671 (3) [P12T1]: DistributionServiceRemoteClient created for GMB
2018-08-08 10:22:50.689 (3) [P12T1]: Retrieving GMB credentials for search engine user id : 3606 || client id : 627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com , client secret :uO1pQj_ihl6Jy1fSA7FzCTFE , refresh token : 1/fH9q5og0rO9LI5NBJqM4k_YTHb-0XSo2-Qv53oyo5a0
2018-08-08 10:22:50,689 [P12T1] INFO  c.t.s.o.core.OAuthServiceComponent - [oauth] Return OAuth credential. Access token = ya29.Gl3zBT9UPnSb8zwTZdDOaABAwsEn6CRsSh2UtDtma77Kp3dQ3dFh_BG1ZlWAqnhyvT3p0mdBO9i0JvL2CE-LiJYcSsyxW14StKmHMTwdYe4VjFNL8xviC8kmsXVq2mI for gmb (clientID=627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com)
2018-08-08 10:22:50.733 (3) [P12T1]: No deleted adgroups found
2018-08-08 10:22:50.735 (3) [P12T1]: Deletes Pending Change 0 adgroups and adding 0 adgroups.
2018-08-08 10:22:50.818 (3) [P12T1]: No deleted keywords found
2018-08-08 10:22:50.820 (3) [P12T1]: Deleting 0 keywords and adding 0 keywords and Updated 0.
2018-08-08 10:22:50.828 (3) [P12T1]: replace 0 changed campaigns for accountID 2402
2018-08-08 10:22:50.853 (2) [P12T1]: CampaignTargetDAO: database is null
2018-08-08 10:22:50.873 (3) [P12T1]: ... SEUser 3606 finished
2018-08-08 10:22:50.873 (3) [pool-40-thread-1]: ------------Google Content Editor done
2018-08-08 10:22:50.873 (3) [pool-40-thread-1]: Completed Google Replace Keywords Worker..
2018-08-08 10:22:50.877 (3) [pool-3-thread-5]: 24002_GM has no applicable GCE errors.
2018-08-08 10:22:50,879 [pool-3-thread-5] INFO  jdbc.sqlonly - SELECT `errors`.`errorJson` FROM `campaigns` JOIN `errors` ON `errors`.`campaignName` = `campaigns`.`name`
WHERE `campaigns`.`id` IN (4796)

2018-08-08 10:22:50.881 (3) [pool-3-thread-5]: 24003_GT has no applicable GCE errors.
2018-08-08 10:22:50,883 [pool-3-thread-5] INFO  jdbc.sqlonly - SELECT `errors`.`errorJson` FROM `campaigns` JOIN `errors` ON `errors`.`campaignName` = `campaigns`.`name`
WHERE `campaigns`.`id` IN (4797)

2018-08-08 10:22:50.884 (3) [pool-3-thread-5]: 24003_GM has no applicable GCE errors.
2018-08-08 10:22:50.888 (3) [pool-3-thread-5]: 24002_GT has no applicable GCE errors.
2018-08-08 10:22:50.889 (3) [pool-3-thread-5]: Finished DEPLOY request for campaign 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24002_GT: SUCCEEDED (merchant: 7782a00d-dc22-4770-b0ec-0a3aea79fe57)
2018-08-08 10:22:50.890 (3) [pool-3-thread-5]: Finished DEPLOY request for campaign 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24002_GM: SUCCEEDED (merchant: 7782a00d-dc22-4770-b0ec-0a3aea79fe57)
2018-08-08 10:22:50.890 (3) [pool-3-thread-5]: Finished DEPLOY request for campaign 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24003_GT: SUCCEEDED (merchant: 7782a00d-dc22-4770-b0ec-0a3aea79fe57)
2018-08-08 10:22:50.890 (3) [pool-3-thread-5]: Finished DEPLOY request for campaign 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24003_GM: SUCCEEDED (merchant: 7782a00d-dc22-4770-b0ec-0a3aea79fe57)
2018-08-08 10:22:50.890 (3) [pool-3-thread-5]: 7782a00d-dc22-4770-b0ec-0a3aea79fe57 has 0 campaigns for a SE Update accounts sync.
2018-08-08 10:22:50.891 (3) [pool-3-thread-5]: 7782a00d-dc22-4770-b0ec-0a3aea79fe57 has 0 campaigns for a SE Update groups-listings sync.
2018-08-08 10:22:50.891 (3) [pool-3-thread-5]: Finished sub-campaign processing for DEPLOY deploymentID (ATMPFovd1QoMzFIEfLaR). account 7782a00d-dc22-4770-b0ec-0a3aea79fe57. 4 submitted, 4 ok.
2018-08-08 10:22:50.891 (3) [pool-3-thread-5]: Updating deployment status to 'Success' for campaignID: 24002
2018-08-08 10:22:50.891 (3) [pool-3-thread-5]: Finished DEPLOY request for 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24002: SUCCEEDED (merchant: 7782a00d-dc22-4770-b0ec-0a3aea79fe57)
2018-08-08 10:22:50.891 (3) [pool-3-thread-5]: Updating deployment status to 'Success' for campaignID: 24003
2018-08-08 10:22:50.892 (3) [pool-3-thread-5]: Finished DEPLOY request for 7782a00d-dc22-4770-b0ec-0a3aea79fe57_10002_10961_24003: SUCCEEDED (merchant: 7782a00d-dc22-4770-b0ec-0a3aea79fe57)
2018-08-08 10:22:50.892 (3) [pool-3-thread-5]: Finished DEPLOY request, deploymentID (ATMPFovd1QoMzFIEfLaR), account 7782a00d-dc22-4770-b0ec-0a3aea79fe57
2018-08-08 10:22:50.892 (3) [pool-3-thread-5]: Request removed from map for customerID 7782a00d-dc22-4770-b0ec-0a3aea79fe57