2019-05-29 14:01:37.367 (3) [Thread-9]: Request added to map for customerID 8866c0e9-7441-4c3c-be96-7adf01a42df7 2019-05-29 14:01:37.367 (3) [Thread-9]: HighPriorityMessageHandler handling message ID ID:JBM-6d3f42c4-e6c4-4dd6-8d7e-5a4b359bedd6 2019-05-29 14:01:37.367 (3) [Thread-9]: Request worker created for 8866c0e9-7441-4c3c-be96-7adf01a42df7 2019-05-29 14:01:37.367 (3) [Thread-9]: Submitted executor job for 8866c0e9-7441-4c3c-be96-7adf01a42df7 2019-05-29 14:01:37.369 (3) [Thread-9]: HighPriorityMessageHandler took message ID ID:JBM-6d3f42c4-e6c4-4dd6-8d7e-5a4b359bedd6 out of queue 2019-05-29 14:01:37.392 (3) [pool-3-thread-10]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2019-05-29 14:01:37.399 (3) [pool-3-thread-10]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2019-05-29 14:01:37.410 (3) [pool-3-thread-10]: Nominal monthly budget was unchanged for AdMax campaign ID: 2928 2019-05-29 14:01:37.410 (3) [pool-3-thread-10]: Terminated budget for admaxCampaignID 2928 2019-05-29 14:01:37.410 (3) [pool-3-thread-10]: AdMaxNominalMonthlyBudgetsDAO.deleteFutureBudget deleting budget for AdMax campaign 2928 on start date 2019-05-30 2019-05-29 14:01:37.410 (3) [pool-3-thread-10]: Deleted tomorrow's budget for admaxCampaignID 2928 2019-05-29 14:01:37.410 (3) [pool-3-thread-10]: Updating deployment status to 'InProgress' for campaignID: 10859 2019-05-29 14:01:37.414 (3) [pool-3-thread-10]: Terminating advert budget for 10859 2019-05-29 14:01:37.415 (3) [pool-3-thread-10]: No active budget exists for AdMax campaign ID: 2928 2019-05-29 14:01:37.415 (3) [pool-3-thread-10]: Terminating advert slosh factor for 10859 2019-05-29 14:01:37.416 (3) [pool-3-thread-10]: No active slosh factor exists for AdMax campaign ID: 2928 2019-05-29 14:01:37.416 (3) [pool-3-thread-10]: Terminating advert slosh limit for 10859 2019-05-29 14:01:37.417 (3) [pool-3-thread-10]: No active slosh limit exists for AdMax campaign ID: 2928 2019-05-29 14:01:37.422 (3) [pool-3-thread-10]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2019-05-29 14:01:37.423 (3) [pool-3-thread-10]: Start processing UPDATE request (7a820b40-933a-4714-9d33-8f6a8371f35e) for account 8866c0e9-7441-4c3c-be96-7adf01a42df7. 4 campaign(s). 2019-05-29 14:01:37.423 (3) [pool-3-thread-10]: Performing update for account: 8866c0e9-7441-4c3c-be96-7adf01a42df7 ID#794 2019-05-29 14:01:37.427 (3) [pool-3-thread-10]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2019-05-29 14:01:37.433 (3) [pool-3-thread-10]: 4 campaign(s) to update. 2019-05-29 14:01:37.433 (3) [pool-3-thread-10]: 0 campaign(s) to retry and update. 2019-05-29 14:01:37.433 (3) [pool-3-thread-10]: Update campaign status for accountID 794 2019-05-29 14:01:37.434 (3) [pool-3-thread-10]: CampaignWorker initialized for account: 794 2019-05-29 14:01:37.434 (3) [pool-3-thread-10]: Updating 8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10859_S1 Status: Deleted 2019-05-29 14:01:37.434 (3) [pool-3-thread-10]: Updating 8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10859_S2 Status: Deleted 2019-05-29 14:01:37.434 (3) [pool-3-thread-10]: Updating 8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10859_S3 Status: Deleted 2019-05-29 14:01:37.434 (3) [pool-3-thread-10]: Updating 8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10859_S4 Status: Deleted 2019-05-29 14:01:37.434 (3) [pool-3-thread-10]: CampaignUpdateWorker started... 2019-05-29 14:01:37,522 [pool-3-thread-10] DEBUG c.t.s.facebook.FacebookApiUtils - Getting FB properties using distribution service 2019-05-29 14:01:37,525 [pool-3-thread-10] DEBUG c.t.s.f.FacebookAccountDeployer - Facebook currencyCode USD for accountID 794 2019-05-29 14:01:37,526 [pool-3-thread-10] DEBUG c.t.s.f.FacebookAccountDeployer - Facebook timeZoneID America/New_York for accountID 794 2019-05-29 14:01:37,526 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - FacebookAccountDeployer:getExistingCampaigns 2019-05-29 14:01:37,529 [pool-3-thread-10] INFO jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`id` IN (1024,1025,1022,1023) 2019-05-29 14:01:37,531 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - calculating carryover for seuserID 1603 2019-05-29 14:01:37,531 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - Fetching performance data for seuserID 1603 and campaign SEIdentifiers [c41d3ee822fd47c0988b5b9b985b9e91, 791a86f0accd4b4586987ec5df1bc0dd, b337c97524d34d10aec4ce615eb3f54e, 19a63c8c85474c868ec2c09a612300af] 2019-05-29 14:01:37,534 [pool-3-thread-10] INFO jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`tpId` = 'c41d3ee822fd47c0988b5b9b985b9e91' 2019-05-29 14:01:42,535 [pool-3-thread-10] INFO c.t.s.c.t.i.s.CampaignServiceClient - Getting TP campaign [c41d3ee822fd47c0988b5b9b985b9e91] details for account 45bd0b8dd9bd43638d837334d7e7d9fb 2019-05-29 14:01:42,538 [pool-3-thread-10] INFO o.a.c.i.LoggingOutInterceptor - Outbound Message --------------------------- ID: 209 Address: https://api.tigerpistol.com/v1/campaigns/c41d3ee822fd47c0988b5b9b985b9e91 Http-Method: GET Content-Type: application/json Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token A5CO5g2RJFRI4w5mWJ32bkCAwQ6mMWo9bHPUWqIC]} -------------------------------------- 2019-05-29 14:01:42,869 [pool-3-thread-10] INFO o.a.c.i.LoggingInInterceptor - Inbound Message ---------------------------- ID: 209 Response-Code: 200 Encoding: UTF-8 Content-Type: application/json; charset=utf-8 Headers: {api-supported-versions=[1.0], Content-Length=[713], content-type=[application/json; charset=utf-8], Date=[Wed, 29 May 2019 14:01:42 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]} Payload: {"variations":[{"index":0,"reviewError":null}],"displayMargin":1.0,"hasError":true,"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,"id":"c41d3ee822fd47c0988b5b9b985b9e91","customerId":"45bd0b8dd9bd43638d837334d7e7d9fb","name":"8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10859_S1","start":"2019-05-29T13:56:00+00:00","end":"2019-06-29T03:59:00+00:00","budget":3138.00,"objective":"website_clicks","status":"error","publishPhase":"error","errorMessage":"Please add a valid payment method to your ad account."} -------------------------------------- 2019-05-29 14:01:42,871 [pool-3-thread-10] INFO jdbc.sqlonly - INSERT INTO `performance` (`campaignID`, `date`, `status`, `spend`, `clicks`, `impressions`, `budget`, `startDate`, `endDate`, `lastUpdated`) VALUES (1022,'2019-05-29','error',0.0,0,0,3138,'05/29/2019 13:56:00.000','06/29/2019 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`) 2019-05-29 14:01:42,871 [pool-3-thread-10] 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` = 1022 and `performance`.`date` = '2019-05-29' 2019-05-29 14:01:42,872 [pool-3-thread-10] INFO jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`tpId` = '791a86f0accd4b4586987ec5df1bc0dd' 2019-05-29 14:01:47,873 [pool-3-thread-10] INFO c.t.s.c.t.i.s.CampaignServiceClient - Getting TP campaign [791a86f0accd4b4586987ec5df1bc0dd] details for account 45bd0b8dd9bd43638d837334d7e7d9fb 2019-05-29 14:01:47,877 [pool-3-thread-10] INFO o.a.c.i.LoggingOutInterceptor - Outbound Message --------------------------- ID: 210 Address: https://api.tigerpistol.com/v1/campaigns/791a86f0accd4b4586987ec5df1bc0dd Http-Method: GET Content-Type: application/json Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token A5CO5g2RJFRI4w5mWJ32bkCAwQ6mMWo9bHPUWqIC]} -------------------------------------- 2019-05-29 14:01:48,192 [pool-3-thread-10] INFO o.a.c.i.LoggingInInterceptor - Inbound Message ---------------------------- ID: 210 Response-Code: 200 Encoding: UTF-8 Content-Type: application/json; charset=utf-8 Headers: {api-supported-versions=[1.0], Content-Length=[713], content-type=[application/json; charset=utf-8], Date=[Wed, 29 May 2019 14:01:48 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]} Payload: {"variations":[{"index":0,"reviewError":null}],"displayMargin":1.0,"hasError":true,"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,"id":"791a86f0accd4b4586987ec5df1bc0dd","customerId":"45bd0b8dd9bd43638d837334d7e7d9fb","name":"8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10859_S2","start":"2019-05-29T13:56:00+00:00","end":"2019-06-29T03:59:00+00:00","budget":3138.00,"objective":"website_clicks","status":"error","publishPhase":"error","errorMessage":"Please add a valid payment method to your ad account."} -------------------------------------- 2019-05-29 14:01:48,194 [pool-3-thread-10] INFO jdbc.sqlonly - INSERT INTO `performance` (`campaignID`, `date`, `status`, `spend`, `clicks`, `impressions`, `budget`, `startDate`, `endDate`, `lastUpdated`) VALUES (1023,'2019-05-29','error',0.0,0,0,3138,'05/29/2019 13:56:00.000','06/29/2019 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`) 2019-05-29 14:01:48,195 [pool-3-thread-10] 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` = 1023 and `performance`.`date` = '2019-05-29' 2019-05-29 14:01:48,196 [pool-3-thread-10] INFO jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`tpId` = 'b337c97524d34d10aec4ce615eb3f54e' 2019-05-29 14:01:53,197 [pool-3-thread-10] INFO c.t.s.c.t.i.s.CampaignServiceClient - Getting TP campaign [b337c97524d34d10aec4ce615eb3f54e] details for account 45bd0b8dd9bd43638d837334d7e7d9fb 2019-05-29 14:01:53,200 [pool-3-thread-10] INFO o.a.c.i.LoggingOutInterceptor - Outbound Message --------------------------- ID: 211 Address: https://api.tigerpistol.com/v1/campaigns/b337c97524d34d10aec4ce615eb3f54e Http-Method: GET Content-Type: application/json Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token A5CO5g2RJFRI4w5mWJ32bkCAwQ6mMWo9bHPUWqIC]} -------------------------------------- 2019-05-29 14:01:53,507 [pool-3-thread-10] INFO o.a.c.i.LoggingInInterceptor - Inbound Message ---------------------------- ID: 211 Response-Code: 200 Encoding: UTF-8 Content-Type: application/json; charset=utf-8 Headers: {api-supported-versions=[1.0], Content-Length=[713], content-type=[application/json; charset=utf-8], Date=[Wed, 29 May 2019 14:01:53 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]} Payload: {"variations":[{"index":0,"reviewError":null}],"displayMargin":1.0,"hasError":true,"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,"id":"b337c97524d34d10aec4ce615eb3f54e","customerId":"45bd0b8dd9bd43638d837334d7e7d9fb","name":"8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10859_S3","start":"2019-05-29T13:56:00+00:00","end":"2019-06-29T03:59:00+00:00","budget":3138.00,"objective":"website_clicks","status":"error","publishPhase":"error","errorMessage":"Please add a valid payment method to your ad account."} -------------------------------------- 2019-05-29 14:01:53,508 [pool-3-thread-10] INFO jdbc.sqlonly - INSERT INTO `performance` (`campaignID`, `date`, `status`, `spend`, `clicks`, `impressions`, `budget`, `startDate`, `endDate`, `lastUpdated`) VALUES (1024,'2019-05-29','error',0.0,0,0,3138,'05/29/2019 13:56:00.000','06/29/2019 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`) 2019-05-29 14:01:53,509 [pool-3-thread-10] 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` = 1024 and `performance`.`date` = '2019-05-29' 2019-05-29 14:01:53,510 [pool-3-thread-10] INFO jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`tpId` = '19a63c8c85474c868ec2c09a612300af' 2019-05-29 14:01:58,511 [pool-3-thread-10] INFO c.t.s.c.t.i.s.CampaignServiceClient - Getting TP campaign [19a63c8c85474c868ec2c09a612300af] details for account 45bd0b8dd9bd43638d837334d7e7d9fb 2019-05-29 14:01:58,515 [pool-3-thread-10] INFO o.a.c.i.LoggingOutInterceptor - Outbound Message --------------------------- ID: 212 Address: https://api.tigerpistol.com/v1/campaigns/19a63c8c85474c868ec2c09a612300af Http-Method: GET Content-Type: application/json Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token A5CO5g2RJFRI4w5mWJ32bkCAwQ6mMWo9bHPUWqIC]} -------------------------------------- 2019-05-29 14:01:58,828 [pool-3-thread-10] INFO o.a.c.i.LoggingInInterceptor - Inbound Message ---------------------------- ID: 212 Response-Code: 200 Encoding: UTF-8 Content-Type: application/json; charset=utf-8 Headers: {api-supported-versions=[1.0], Content-Length=[713], content-type=[application/json; charset=utf-8], Date=[Wed, 29 May 2019 14:01:58 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]} Payload: {"variations":[{"index":0,"reviewError":null}],"displayMargin":1.0,"hasError":true,"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,"id":"19a63c8c85474c868ec2c09a612300af","customerId":"45bd0b8dd9bd43638d837334d7e7d9fb","name":"8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10859_S4","start":"2019-05-29T13:56:00+00:00","end":"2019-06-29T03:59:00+00:00","budget":3138.00,"objective":"website_clicks","status":"error","publishPhase":"error","errorMessage":"Please add a valid payment method to your ad account."} -------------------------------------- 2019-05-29 14:01:58,829 [pool-3-thread-10] INFO jdbc.sqlonly - INSERT INTO `performance` (`campaignID`, `date`, `status`, `spend`, `clicks`, `impressions`, `budget`, `startDate`, `endDate`, `lastUpdated`) VALUES (1025,'2019-05-29','error',0.0,0,0,3138,'05/29/2019 13:56:00.000','06/29/2019 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`) 2019-05-29 14:01:58,830 [pool-3-thread-10] 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` = 1025 and `performance`.`date` = '2019-05-29' 2019-05-29 14:01:58,832 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - Sucessfully fetched facebook campaign performance data for seuserID 1603, perf data ([TPCampaignPerformanceDTO [theID=1982, theCampaignID=1022, theDate=2019-05-29, theStatus=error, theSpend=0.0, theClicks=0, theImpressions=0, theBudget=3138, theStartDate=2019-05-29T13:56:00.000Z, theEndDate=2019-06-29T03:59:00.000Z, theLastUpdated=2019-05-29T14:01:42.000Z], TPCampaignPerformanceDTO [theID=1983, theCampaignID=1023, theDate=2019-05-29, theStatus=error, theSpend=0.0, theClicks=0, theImpressions=0, theBudget=3138, theStartDate=2019-05-29T13:56:00.000Z, theEndDate=2019-06-29T03:59:00.000Z, theLastUpdated=2019-05-29T14:01:48.000Z], TPCampaignPerformanceDTO [theID=1984, theCampaignID=1024, theDate=2019-05-29, theStatus=error, theSpend=0.0, theClicks=0, theImpressions=0, theBudget=3138, theStartDate=2019-05-29T13:56:00.000Z, theEndDate=2019-06-29T03:59:00.000Z, theLastUpdated=2019-05-29T14:01:53.000Z], TPCampaignPerformanceDTO [theID=1985, theCampaignID=1025, theDate=2019-05-29, theStatus=error, theSpend=0.0, theClicks=0, theImpressions=0, theBudget=3138, theStartDate=2019-05-29T13:56:00.000Z, theEndDate=2019-06-29T03:59:00.000Z, theLastUpdated=2019-05-29T14:01:58.000Z]]) 2019-05-29 14:01:58,832 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - =========== Processing carryover for campaignID 1022 [seuserID 1603] =========== 2019-05-29 14:01:58,832 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - actual_monthly_budget for campaignID 1022 : 31.38 USD 2019-05-29 14:01:58,832 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - actual_spend for campaignID 1022 : 0.0 USD 2019-05-29 14:01:58,832 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - campaign start date 2019-05-29T09:56:00.000-04:00 America/New_York, end date 2019-06-28T23:59:00.000-04:00 America/New_York, days 31.0, current date 2019-05-29T10:01:58.832-04:00 America/New_York for campaignID 1022 2019-05-29 14:01:58,832 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - campaignID 1022 active for 0 days (num_of_days_active) and 0 hours (num_of_hours_active) 2019-05-29 14:01:58,832 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - daily_budget [actual_monthly_budget / 31.0] for campaignID 1022 : 1.012258 2019-05-29 14:01:58,832 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - hourly_budget [daily_budget / 24] for campaignID 1022 : 0.04217742 2019-05-29 14:01:58,832 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - expected_daily_spend [daily_budget * num_of_days_active] for campaignID 1022 : 0.0 2019-05-29 14:01:58,832 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - expected_hourly_spend [hourly_budget * num_of_hours_active] for campaignID 1022 : 0.0 2019-05-29 14:01:58,832 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - expected_spend [expected_daily_spend + expected_hourly_spend] for campaignID 1022 : 0.0 2019-05-29 14:01:58,832 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - dedicatedCarryover [expected_spend - actual_spend] for campaignID 1022 : 0.0 2019-05-29 14:01:58,832 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - =========== Processing carryover for campaignID 1023 [seuserID 1603] =========== 2019-05-29 14:01:58,833 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - actual_monthly_budget for campaignID 1023 : 31.38 USD 2019-05-29 14:01:58,833 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - actual_spend for campaignID 1023 : 0.0 USD 2019-05-29 14:01:58,833 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - campaign start date 2019-05-29T09:56:00.000-04:00 America/New_York, end date 2019-06-28T23:59:00.000-04:00 America/New_York, days 31.0, current date 2019-05-29T10:01:58.833-04:00 America/New_York for campaignID 1023 2019-05-29 14:01:58,833 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - campaignID 1023 active for 0 days (num_of_days_active) and 0 hours (num_of_hours_active) 2019-05-29 14:01:58,833 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - daily_budget [actual_monthly_budget / 31.0] for campaignID 1023 : 1.012258 2019-05-29 14:01:58,833 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - hourly_budget [daily_budget / 24] for campaignID 1023 : 0.04217742 2019-05-29 14:01:58,833 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - expected_daily_spend [daily_budget * num_of_days_active] for campaignID 1023 : 0.0 2019-05-29 14:01:58,833 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - expected_hourly_spend [hourly_budget * num_of_hours_active] for campaignID 1023 : 0.0 2019-05-29 14:01:58,833 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - expected_spend [expected_daily_spend + expected_hourly_spend] for campaignID 1023 : 0.0 2019-05-29 14:01:58,833 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - dedicatedCarryover [expected_spend - actual_spend] for campaignID 1023 : 0.0 2019-05-29 14:01:58,833 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - =========== Processing carryover for campaignID 1024 [seuserID 1603] =========== 2019-05-29 14:01:58,833 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - actual_monthly_budget for campaignID 1024 : 31.38 USD 2019-05-29 14:01:58,833 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - actual_spend for campaignID 1024 : 0.0 USD 2019-05-29 14:01:58,833 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - campaign start date 2019-05-29T09:56:00.000-04:00 America/New_York, end date 2019-06-28T23:59:00.000-04:00 America/New_York, days 31.0, current date 2019-05-29T10:01:58.833-04:00 America/New_York for campaignID 1024 2019-05-29 14:01:58,833 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - campaignID 1024 active for 0 days (num_of_days_active) and 0 hours (num_of_hours_active) 2019-05-29 14:01:58,833 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - daily_budget [actual_monthly_budget / 31.0] for campaignID 1024 : 1.012258 2019-05-29 14:01:58,833 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - hourly_budget [daily_budget / 24] for campaignID 1024 : 0.04217742 2019-05-29 14:01:58,833 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - expected_daily_spend [daily_budget * num_of_days_active] for campaignID 1024 : 0.0 2019-05-29 14:01:58,833 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - expected_hourly_spend [hourly_budget * num_of_hours_active] for campaignID 1024 : 0.0 2019-05-29 14:01:58,833 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - expected_spend [expected_daily_spend + expected_hourly_spend] for campaignID 1024 : 0.0 2019-05-29 14:01:58,833 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - dedicatedCarryover [expected_spend - actual_spend] for campaignID 1024 : 0.0 2019-05-29 14:01:58,833 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - =========== Processing carryover for campaignID 1025 [seuserID 1603] =========== 2019-05-29 14:01:58,833 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - actual_monthly_budget for campaignID 1025 : 31.38 USD 2019-05-29 14:01:58,833 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - actual_spend for campaignID 1025 : 0.0 USD 2019-05-29 14:01:58,833 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - campaign start date 2019-05-29T09:56:00.000-04:00 America/New_York, end date 2019-06-28T23:59:00.000-04:00 America/New_York, days 31.0, current date 2019-05-29T10:01:58.833-04:00 America/New_York for campaignID 1025 2019-05-29 14:01:58,833 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - campaignID 1025 active for 0 days (num_of_days_active) and 0 hours (num_of_hours_active) 2019-05-29 14:01:58,833 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - daily_budget [actual_monthly_budget / 31.0] for campaignID 1025 : 1.012258 2019-05-29 14:01:58,833 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - hourly_budget [daily_budget / 24] for campaignID 1025 : 0.04217742 2019-05-29 14:01:58,833 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - expected_daily_spend [daily_budget * num_of_days_active] for campaignID 1025 : 0.0 2019-05-29 14:01:58,833 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - expected_hourly_spend [hourly_budget * num_of_hours_active] for campaignID 1025 : 0.0 2019-05-29 14:01:58,833 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - expected_spend [expected_daily_spend + expected_hourly_spend] for campaignID 1025 : 0.0 2019-05-29 14:01:58,833 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - dedicatedCarryover [expected_spend - actual_spend] for campaignID 1025 : 0.0 2019-05-29 14:01:58,835 [pool-3-thread-10] INFO jdbc.sqlonly - SELECT mc.`id`, mc.`campaignID`, mc.`date`, mc.`dedicatedCarryover`, mc.`pooledCarryover`, mc.`type` FROM `monthlyCarryovers` mc JOIN `campaigns` c ON mc.`campaignID` = c.`id` WHERE c.`searchEngineUserId` = 1603 AND mc.`type` = 'boosted' AND mc.`date` = (SELECT MAX(DATE) FROM monthlyCarryovers mc1 WHERE mc1.`campaignID` = mc.`campaignID` and c.`searchEngineUserId` = c.`searchEngineUserId` AND mc1.`type` = 'boosted') ORDER BY c.`id` DESC LIMIT 4 2019-05-29 14:01:58,837 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - Found campaign carryover data for seuserID 1603, boosted carryover data ([TPCampaignCarryoverDTO [theID=2354, theCampaignID=1021, theDate=2019-05-29, theDedicatedCarryover=0.0, thePooledCarryover=0.13, theCarryoverType=boosted], TPCampaignCarryoverDTO [theID=2353, theCampaignID=1020, theDate=2019-05-29, theDedicatedCarryover=0.0, thePooledCarryover=0.13, theCarryoverType=boosted], TPCampaignCarryoverDTO [theID=2352, theCampaignID=1019, theDate=2019-05-29, theDedicatedCarryover=0.0, thePooledCarryover=0.13, theCarryoverType=boosted], TPCampaignCarryoverDTO [theID=2351, theCampaignID=1018, theDate=2019-05-29, theDedicatedCarryover=0.0, thePooledCarryover=0.13, theCarryoverType=boosted]]) 2019-05-29 14:01:58,839 [pool-3-thread-10] INFO jdbc.sqlonly - SELECT `id`, `searchEngineUserId`, `date`, `carryoverAdjustment`, `type` FROM `monthlyCarryoverAdjustments` WHERE `searchEngineUserId` = 1603 and `date` = '2019-05-29' and `type` = 'normal' 2019-05-29 14:01:58,842 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - Total boostedCarryover for seuserID 1603 and date 2019-05-29 is 0.52 2019-05-29 14:01:58,842 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - Total carryover Adjustment for seuserID 1603 and date 2019-05-29 is 0.0 2019-05-29 14:01:58,842 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - Total pooledCarryOver [(totalPooledCarryover + totalBoostedCarryover) - carryoverAdjustment] for seuserID 1603 and date 2019-05-29 is 0.52 2019-05-29 14:01:58,842 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - saving carryover TPCampaignCarryoverDTO [theID=null, theCampaignID=1022, theDate=2019-05-29, theDedicatedCarryover=0.0, thePooledCarryover=0.13, theCarryoverType=normal] for campaignID 1022 2019-05-29 14:01:58,844 [pool-3-thread-10] INFO jdbc.sqlonly - INSERT INTO `monthlyCarryovers` (`campaignID`, `date`, `dedicatedCarryover`, `pooledCarryover`, `type`) VALUES (1022,'2019-05-29',0.0,0.13,'normal') ON DUPLICATE KEY UPDATE `dedicatedCarryover`=VALUES(`dedicatedCarryover`), `pooledCarryover`=VALUES(`pooledCarryover`), `type`=VALUES(`type`) 2019-05-29 14:01:58,845 [pool-3-thread-10] INFO jdbc.sqlonly - SELECT `id`, `campaignID`, `date`, `dedicatedCarryover`, `pooledCarryover`, `type` FROM `monthlyCarryovers` WHERE `campaignID` = 1022 and `date` = '2019-05-29' and `type` = 'normal' 2019-05-29 14:01:58,846 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - saving carryover TPCampaignCarryoverDTO [theID=null, theCampaignID=1023, theDate=2019-05-29, theDedicatedCarryover=0.0, thePooledCarryover=0.13, theCarryoverType=normal] for campaignID 1023 2019-05-29 14:01:58,848 [pool-3-thread-10] INFO jdbc.sqlonly - INSERT INTO `monthlyCarryovers` (`campaignID`, `date`, `dedicatedCarryover`, `pooledCarryover`, `type`) VALUES (1023,'2019-05-29',0.0,0.13,'normal') ON DUPLICATE KEY UPDATE `dedicatedCarryover`=VALUES(`dedicatedCarryover`), `pooledCarryover`=VALUES(`pooledCarryover`), `type`=VALUES(`type`) 2019-05-29 14:01:58,849 [pool-3-thread-10] INFO jdbc.sqlonly - SELECT `id`, `campaignID`, `date`, `dedicatedCarryover`, `pooledCarryover`, `type` FROM `monthlyCarryovers` WHERE `campaignID` = 1023 and `date` = '2019-05-29' and `type` = 'normal' 2019-05-29 14:01:58,851 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - saving carryover TPCampaignCarryoverDTO [theID=null, theCampaignID=1024, theDate=2019-05-29, theDedicatedCarryover=0.0, thePooledCarryover=0.13, theCarryoverType=normal] for campaignID 1024 2019-05-29 14:01:58,853 [pool-3-thread-10] INFO jdbc.sqlonly - INSERT INTO `monthlyCarryovers` (`campaignID`, `date`, `dedicatedCarryover`, `pooledCarryover`, `type`) VALUES (1024,'2019-05-29',0.0,0.13,'normal') ON DUPLICATE KEY UPDATE `dedicatedCarryover`=VALUES(`dedicatedCarryover`), `pooledCarryover`=VALUES(`pooledCarryover`), `type`=VALUES(`type`) 2019-05-29 14:01:58,853 [pool-3-thread-10] INFO jdbc.sqlonly - SELECT `id`, `campaignID`, `date`, `dedicatedCarryover`, `pooledCarryover`, `type` FROM `monthlyCarryovers` WHERE `campaignID` = 1024 and `date` = '2019-05-29' and `type` = 'normal' 2019-05-29 14:01:58,855 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - saving carryover TPCampaignCarryoverDTO [theID=null, theCampaignID=1025, theDate=2019-05-29, theDedicatedCarryover=0.0, thePooledCarryover=0.13, theCarryoverType=normal] for campaignID 1025 2019-05-29 14:01:58,857 [pool-3-thread-10] INFO jdbc.sqlonly - INSERT INTO `monthlyCarryovers` (`campaignID`, `date`, `dedicatedCarryover`, `pooledCarryover`, `type`) VALUES (1025,'2019-05-29',0.0,0.13,'normal') ON DUPLICATE KEY UPDATE `dedicatedCarryover`=VALUES(`dedicatedCarryover`), `pooledCarryover`=VALUES(`pooledCarryover`), `type`=VALUES(`type`) 2019-05-29 14:01:58,857 [pool-3-thread-10] INFO jdbc.sqlonly - SELECT `id`, `campaignID`, `date`, `dedicatedCarryover`, `pooledCarryover`, `type` FROM `monthlyCarryovers` WHERE `campaignID` = 1025 and `date` = '2019-05-29' and `type` = 'normal' 2019-05-29 14:01:58.859 (3) [pool-3-thread-10]: 8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10859_S1 status change (Active->Deleted) 2019-05-29 14:01:58.859 (3) [pool-3-thread-10]: Campaign deleted, skipping target sync. 2019-05-29 14:01:58.859 (3) [pool-3-thread-10]: Campaign deleted, skipping call data sync 2019-05-29 14:01:58.859 (3) [pool-3-thread-10]: Campaign deleted, skipping location data sync 2019-05-29 14:01:58.859 (3) [pool-3-thread-10]: 8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10859_S2 status change (Active->Deleted) 2019-05-29 14:01:58.859 (3) [pool-3-thread-10]: Campaign deleted, skipping target sync. 2019-05-29 14:01:58.859 (3) [pool-3-thread-10]: Campaign deleted, skipping call data sync 2019-05-29 14:01:58.859 (3) [pool-3-thread-10]: Campaign deleted, skipping location data sync 2019-05-29 14:01:58.859 (3) [pool-3-thread-10]: 8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10859_S3 status change (Active->Deleted) 2019-05-29 14:01:58.859 (3) [pool-3-thread-10]: Campaign deleted, skipping target sync. 2019-05-29 14:01:58.859 (3) [pool-3-thread-10]: Campaign deleted, skipping call data sync 2019-05-29 14:01:58.859 (3) [pool-3-thread-10]: Campaign deleted, skipping location data sync 2019-05-29 14:01:58.859 (3) [pool-3-thread-10]: 8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10859_S4 status change (Active->Deleted) 2019-05-29 14:01:58.859 (3) [pool-3-thread-10]: Campaign deleted, skipping target sync. 2019-05-29 14:01:58.859 (3) [pool-3-thread-10]: Campaign deleted, skipping call data sync 2019-05-29 14:01:58.859 (3) [pool-3-thread-10]: Campaign deleted, skipping location data sync 2019-05-29 14:01:58.860 (3) [pool-31-thread-1]: Starting Facebook Update Campaign Worker.. 2019-05-29 14:01:58,860 [pool-31-thread-1] INFO c.t.s.f.FacebookAccountDeployer - FBAccountDeployer: updateCampaigns 2019-05-29 14:01:58,862 [pool-31-thread-1] INFO jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`id` IN (1024,1025,1022,1023) 2019-05-29 14:01:58,864 [pool-31-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Delete request for 8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10859_S1 2019-05-29 14:01:58,864 [pool-31-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Delete request for 8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10859_S2 2019-05-29 14:01:58,864 [pool-31-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Delete request for 8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10859_S3 2019-05-29 14:01:58,864 [pool-31-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Delete request for 8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10859_S4 2019-05-29 14:01:58,864 [pool-31-thread-1] INFO c.t.s.f.FacebookAccountDeployer - accountID 794: deleting 4 Facebook campaigns 2019-05-29 14:01:58,867 [pool-31-thread-1] INFO c.t.s.c.t.i.s.CampaignServiceClient - Updating TP campaign [c41d3ee822fd47c0988b5b9b985b9e91] status to [pause] for account 45bd0b8dd9bd43638d837334d7e7d9fb 2019-05-29 14:01:58,872 [pool-31-thread-1] INFO o.a.c.i.LoggingOutInterceptor - Outbound Message --------------------------- ID: 213 Address: https://api.tigerpistol.com/v1/campaigns/c41d3ee822fd47c0988b5b9b985b9e91/pause Http-Method: POST Content-Type: application/json Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token A5CO5g2RJFRI4w5mWJ32bkCAwQ6mMWo9bHPUWqIC]} -------------------------------------- 2019-05-29 14:01:59,217 [pool-31-thread-1] INFO o.a.c.i.LoggingInInterceptor - Inbound Message ---------------------------- ID: 213 Response-Code: 200 Encoding: ISO-8859-1 Content-Type: Headers: {api-supported-versions=[1.0], Content-Length=[0], Date=[Wed, 29 May 2019 14:01:58 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]} -------------------------------------- 2019-05-29 14:01:59,217 [pool-31-thread-1] INFO c.t.s.c.t.i.s.CampaignServiceClient - Updating TP campaign [19a63c8c85474c868ec2c09a612300af] status to [pause] for account 45bd0b8dd9bd43638d837334d7e7d9fb 2019-05-29 14:01:59,220 [pool-31-thread-1] INFO o.a.c.i.LoggingOutInterceptor - Outbound Message --------------------------- ID: 214 Address: https://api.tigerpistol.com/v1/campaigns/19a63c8c85474c868ec2c09a612300af/pause Http-Method: POST Content-Type: application/json Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token A5CO5g2RJFRI4w5mWJ32bkCAwQ6mMWo9bHPUWqIC]} -------------------------------------- 2019-05-29 14:01:59,690 [pool-31-thread-1] INFO o.a.c.i.LoggingInInterceptor - Inbound Message ---------------------------- ID: 214 Response-Code: 200 Encoding: ISO-8859-1 Content-Type: Headers: {api-supported-versions=[1.0], Content-Length=[0], Date=[Wed, 29 May 2019 14:01:58 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]} -------------------------------------- 2019-05-29 14:01:59,691 [pool-31-thread-1] INFO c.t.s.c.t.i.s.CampaignServiceClient - Updating TP campaign [b337c97524d34d10aec4ce615eb3f54e] status to [pause] for account 45bd0b8dd9bd43638d837334d7e7d9fb 2019-05-29 14:01:59,694 [pool-31-thread-1] INFO o.a.c.i.LoggingOutInterceptor - Outbound Message --------------------------- ID: 215 Address: https://api.tigerpistol.com/v1/campaigns/b337c97524d34d10aec4ce615eb3f54e/pause Http-Method: POST Content-Type: application/json Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token A5CO5g2RJFRI4w5mWJ32bkCAwQ6mMWo9bHPUWqIC]} -------------------------------------- 2019-05-29 14:02:00,057 [pool-31-thread-1] INFO o.a.c.i.LoggingInInterceptor - Inbound Message ---------------------------- ID: 215 Response-Code: 200 Encoding: ISO-8859-1 Content-Type: Headers: {api-supported-versions=[1.0], Content-Length=[0], Date=[Wed, 29 May 2019 14:01:59 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]} -------------------------------------- 2019-05-29 14:02:00,057 [pool-31-thread-1] INFO c.t.s.c.t.i.s.CampaignServiceClient - Updating TP campaign [791a86f0accd4b4586987ec5df1bc0dd] status to [pause] for account 45bd0b8dd9bd43638d837334d7e7d9fb 2019-05-29 14:02:00,060 [pool-31-thread-1] INFO o.a.c.i.LoggingOutInterceptor - Outbound Message --------------------------- ID: 216 Address: https://api.tigerpistol.com/v1/campaigns/791a86f0accd4b4586987ec5df1bc0dd/pause Http-Method: POST Content-Type: application/json Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token A5CO5g2RJFRI4w5mWJ32bkCAwQ6mMWo9bHPUWqIC]} -------------------------------------- 2019-05-29 14:02:00,388 [pool-31-thread-1] INFO o.a.c.i.LoggingInInterceptor - Inbound Message ---------------------------- ID: 216 Response-Code: 200 Encoding: ISO-8859-1 Content-Type: Headers: {api-supported-versions=[1.0], Content-Length=[0], Date=[Wed, 29 May 2019 14:01:59 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]} -------------------------------------- 2019-05-29 14:02:00,390 [pool-31-thread-1] INFO jdbc.sqlonly - DELETE FROM `errors` WHERE `elementName` IN ('8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10859_S1','8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10859_S2','8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10859_S3','8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10859_S4') 2019-05-29 14:02:00,390 [pool-31-thread-1] INFO c.t.s.client.tp.dao.TPErrorDAO - Removed '4' Previous Errors 2019-05-29 14:02:00,391 [pool-31-thread-1] INFO jdbc.sqlonly - UPDATE `campaigns` SET `campaigns`.`tpId` = 'c41d3ee822fd47c0988b5b9b985b9e91', `campaigns`.`name` = '8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10859_S1', `campaigns`.`status` = 'Deleted', `campaigns`.`endDate` = '05/29/2019 14:01:58.864', `campaigns`.`lastUpdated` = NOW(), `campaigns`.`json` = '{"campaign":{"name":"8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10859_S1","status":"Deleted","id":"c41d3ee822fd47c0988b5b9b985b9e91","customerId":"45bd0b8dd9bd43638d837334d7e7d9fb","objective":"website_clicks","budget":3138,"start":"2019-05-29T13:56:08.752Z","maxEnd":"2019-05-29T14:01:58.864Z","placement":["desktopfeed","mobilefeed","instagramstream","rightcolumn"],"details":{"audiences":[{"ageFrom":18,"ageTo":65,"gender":"females","locationTypes":["home","recent"],"demographics":{"behaviors":["6002714895372"],"interests":["6002926108721"]},"locations":[{"type":"city","id":"2427305"}]}],"copies":[{"headline":"Hotel Room in Baker FL","body":"Baker FL - Top Resort. You''ll Have a Great Stay Here!","description":"Find a Vacation Resort","destinationUrl":"http://www.merchantsite.com"}],"images":["https://s3-us-west-1.amazonaws.com/aml-qa/merchants/8866c0e9-7441-4c3c-be96-7adf01a42df7/images/81f619ad-c986-4241-a70a-3f17113513724216542154981918683.png"],"cta":[{"type":"apply_now"}]}},"searchEngineUserId":1603}' WHERE `campaigns`.`id` = 1022 2019-05-29 14:02:00,392 [pool-31-thread-1] INFO jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`id` = 1022 2019-05-29 14:02:00,393 [pool-31-thread-1] INFO jdbc.sqlonly - UPDATE `campaigns` SET `campaigns`.`tpId` = '791a86f0accd4b4586987ec5df1bc0dd', `campaigns`.`name` = '8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10859_S2', `campaigns`.`status` = 'Deleted', `campaigns`.`endDate` = '05/29/2019 14:01:58.864', `campaigns`.`lastUpdated` = NOW(), `campaigns`.`json` = '{"campaign":{"name":"8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10859_S2","status":"Deleted","id":"791a86f0accd4b4586987ec5df1bc0dd","customerId":"45bd0b8dd9bd43638d837334d7e7d9fb","objective":"website_clicks","budget":3138,"start":"2019-05-29T13:56:08.765Z","maxEnd":"2019-05-29T14:01:58.864Z","placement":["desktopfeed","mobilefeed","instagramstream","rightcolumn"],"details":{"audiences":[{"ageFrom":18,"ageTo":65,"gender":"females","locationTypes":["home","recent"],"demographics":{"behaviors":["6002714895372"],"interests":["6002926108721"]},"locations":[{"type":"city","id":"2427305"}]}],"copies":[{"headline":"Find a Vacation Resort","body":"Baker FL - Top Resort. You''ll Have a Great Stay Here!","description":"Hotel Room in Baker FL","destinationUrl":"http://www.merchantsite.com"}],"images":["https://s3-us-west-1.amazonaws.com/aml-qa/merchants/8866c0e9-7441-4c3c-be96-7adf01a42df7/images/81f619ad-c986-4241-a70a-3f17113513724216542154981918683.png"],"cta":[{"type":"apply_now"}]}},"searchEngineUserId":1603}' WHERE `campaigns`.`id` = 1023 2019-05-29 14:02:00,393 [pool-31-thread-1] INFO jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`id` = 1023 2019-05-29 14:02:00,394 [pool-31-thread-1] INFO jdbc.sqlonly - UPDATE `campaigns` SET `campaigns`.`tpId` = 'b337c97524d34d10aec4ce615eb3f54e', `campaigns`.`name` = '8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10859_S3', `campaigns`.`status` = 'Deleted', `campaigns`.`endDate` = '05/29/2019 14:01:58.864', `campaigns`.`lastUpdated` = NOW(), `campaigns`.`json` = '{"campaign":{"name":"8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10859_S3","status":"Deleted","id":"b337c97524d34d10aec4ce615eb3f54e","customerId":"45bd0b8dd9bd43638d837334d7e7d9fb","objective":"website_clicks","budget":3138,"start":"2019-05-29T13:56:08.770Z","maxEnd":"2019-05-29T14:01:58.864Z","placement":["desktopfeed","mobilefeed","instagramstream","rightcolumn"],"details":{"audiences":[{"ageFrom":18,"ageTo":65,"gender":"females","locationTypes":["home","recent"],"demographics":{"behaviors":["6002714895372"],"interests":["6002926108721"]},"locations":[{"type":"city","id":"2427305"}]}],"copies":[{"headline":"Find a Vacation Resort","body":"Baker FL Spa Resort. Personable, Professional Service.","description":"Hotel Room in Baker FL","destinationUrl":"http://www.merchantsite.com"}],"images":["https://s3-us-west-1.amazonaws.com/aml-qa/merchants/8866c0e9-7441-4c3c-be96-7adf01a42df7/images/81f619ad-c986-4241-a70a-3f17113513724216542154981918683.png"],"cta":[{"type":"apply_now"}]}},"searchEngineUserId":1603}' WHERE `campaigns`.`id` = 1024 2019-05-29 14:02:00,395 [pool-31-thread-1] INFO jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`id` = 1024 2019-05-29 14:02:00,396 [pool-31-thread-1] INFO jdbc.sqlonly - UPDATE `campaigns` SET `campaigns`.`tpId` = '19a63c8c85474c868ec2c09a612300af', `campaigns`.`name` = '8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10859_S4', `campaigns`.`status` = 'Deleted', `campaigns`.`endDate` = '05/29/2019 14:01:58.864', `campaigns`.`lastUpdated` = NOW(), `campaigns`.`json` = '{"campaign":{"name":"8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10859_S4","status":"Deleted","id":"19a63c8c85474c868ec2c09a612300af","customerId":"45bd0b8dd9bd43638d837334d7e7d9fb","objective":"website_clicks","budget":3138,"start":"2019-05-29T13:56:08.775Z","maxEnd":"2019-05-29T14:01:58.864Z","placement":["desktopfeed","mobilefeed","instagramstream","rightcolumn"],"details":{"audiences":[{"ageFrom":18,"ageTo":65,"gender":"females","locationTypes":["home","recent"],"demographics":{"behaviors":["6002714895372"],"interests":["6002926108721"]},"locations":[{"type":"city","id":"2427305"}]}],"copies":[{"headline":"Hotel Room in Baker FL","body":"Baker FL Spa Resort. Personable, Professional Service.","description":"Find a Vacation Resort","destinationUrl":"http://www.merchantsite.com"}],"images":["https://s3-us-west-1.amazonaws.com/aml-qa/merchants/8866c0e9-7441-4c3c-be96-7adf01a42df7/images/81f619ad-c986-4241-a70a-3f17113513724216542154981918683.png"],"cta":[{"type":"apply_now"}]}},"searchEngineUserId":1603}' WHERE `campaigns`.`id` = 1025 2019-05-29 14:02:00,396 [pool-31-thread-1] INFO jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`id` = 1025 2019-05-29 14:02:00.398 (3) [pool-31-thread-1]: Completed Facebook Update Campaign Worker.. 2019-05-29 14:02:00.400 (3) [pool-3-thread-10]: 8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10859_S1 status updated to Deleted 2019-05-29 14:02:00.402 (3) [pool-3-thread-10]: 8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10859_S2 status updated to Deleted 2019-05-29 14:02:00.403 (3) [pool-3-thread-10]: 8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10859_S3 status updated to Deleted 2019-05-29 14:02:00.404 (3) [pool-3-thread-10]: 8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10859_S4 status updated to Deleted 2019-05-29 14:02:00.404 (3) [pool-3-thread-10]: Campaign structure sync not enabled for this request. 2019-05-29 14:02:00,406 [pool-3-thread-10] INFO jdbc.sqlonly - SELECT `errors`.`errorJson` FROM `campaigns` JOIN `errors` ON `errors`.`elementName` = `campaigns`.`name` WHERE `campaigns`.`id` IN (1024) 2019-05-29 14:02:00.408 (3) [pool-3-thread-10]: Ignoring 0 other operation errors for deleted campaign. 2019-05-29 14:02:00.408 (3) [pool-3-thread-10]: 10859_S3 has no applicable GCE errors. 2019-05-29 14:02:00,414 [pool-3-thread-10] INFO jdbc.sqlonly - SELECT `errors`.`errorJson` FROM `campaigns` JOIN `errors` ON `errors`.`elementName` = `campaigns`.`name` WHERE `campaigns`.`id` IN (1025) 2019-05-29 14:02:00.416 (3) [pool-3-thread-10]: Ignoring 0 other operation errors for deleted campaign. 2019-05-29 14:02:00.416 (3) [pool-3-thread-10]: 10859_S4 has no applicable GCE errors. 2019-05-29 14:02:00,419 [pool-3-thread-10] INFO jdbc.sqlonly - SELECT `errors`.`errorJson` FROM `campaigns` JOIN `errors` ON `errors`.`elementName` = `campaigns`.`name` WHERE `campaigns`.`id` IN (1022) 2019-05-29 14:02:00.420 (3) [pool-3-thread-10]: Ignoring 0 other operation errors for deleted campaign. 2019-05-29 14:02:00.420 (3) [pool-3-thread-10]: 10859_S1 has no applicable GCE errors. 2019-05-29 14:02:00,423 [pool-3-thread-10] INFO jdbc.sqlonly - SELECT `errors`.`errorJson` FROM `campaigns` JOIN `errors` ON `errors`.`elementName` = `campaigns`.`name` WHERE `campaigns`.`id` IN (1023) 2019-05-29 14:02:00.425 (3) [pool-3-thread-10]: Ignoring 0 other operation errors for deleted campaign. 2019-05-29 14:02:00.425 (3) [pool-3-thread-10]: 10859_S2 has no applicable GCE errors. 2019-05-29 14:02:00.426 (3) [pool-3-thread-10]: Finished UPDATE request for campaign 8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10859_S1: SUCCEEDED (merchant: 8866c0e9-7441-4c3c-be96-7adf01a42df7) 2019-05-29 14:02:00.426 (3) [pool-3-thread-10]: Finished UPDATE request for campaign 8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10859_S2: SUCCEEDED (merchant: 8866c0e9-7441-4c3c-be96-7adf01a42df7) 2019-05-29 14:02:00.427 (3) [pool-3-thread-10]: Finished UPDATE request for campaign 8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10859_S3: SUCCEEDED (merchant: 8866c0e9-7441-4c3c-be96-7adf01a42df7) 2019-05-29 14:02:00.427 (3) [pool-3-thread-10]: Finished UPDATE request for campaign 8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10859_S4: SUCCEEDED (merchant: 8866c0e9-7441-4c3c-be96-7adf01a42df7) 2019-05-29 14:02:00.427 (3) [pool-3-thread-10]: 8866c0e9-7441-4c3c-be96-7adf01a42df7 has 0 campaigns for a SE Update accounts sync. 2019-05-29 14:02:00.427 (3) [pool-3-thread-10]: 8866c0e9-7441-4c3c-be96-7adf01a42df7 has 0 campaigns for a SE Update groups-listings sync. 2019-05-29 14:02:00.427 (3) [pool-3-thread-10]: Finished sub-campaign processing for UPDATE deploymentID (7a820b40-933a-4714-9d33-8f6a8371f35e). account 8866c0e9-7441-4c3c-be96-7adf01a42df7. 4 submitted, 4 ok. 2019-05-29 14:02:00.428 (3) [pool-3-thread-10]: Updating deployment status to 'Success' for campaignID: 10859 2019-05-29 14:02:00.428 (3) [pool-3-thread-10]: Finished UPDATE request for 10859: SUCCEEDED (merchant: 8866c0e9-7441-4c3c-be96-7adf01a42df7) 2019-05-29 14:02:00.428 (3) [pool-3-thread-10]: Finished UPDATE request, deploymentID (7a820b40-933a-4714-9d33-8f6a8371f35e), account 8866c0e9-7441-4c3c-be96-7adf01a42df7 2019-05-29 14:02:00.428 (3) [pool-3-thread-10]: Request removed from map for customerID 8866c0e9-7441-4c3c-be96-7adf01a42df7 2019-05-29 14:02:00.664 (3) [AdMaxListener]: Sent message to response queue. 2019-05-29 14:02:02.622 (3) [Thread-9]: Request added to map for customerID 8866c0e9-7441-4c3c-be96-7adf01a42df7 2019-05-29 14:02:02.622 (3) [Thread-9]: Request worker created for 8866c0e9-7441-4c3c-be96-7adf01a42df7 2019-05-29 14:02:02.622 (3) [Thread-9]: Submitted executor job for 8866c0e9-7441-4c3c-be96-7adf01a42df7 2019-05-29 14:02:02.645 (3) [pool-3-thread-10]: Updating account tables for 8866c0e9-7441-4c3c-be96-7adf01a42df7 2019-05-29 14:02:02.651 (3) [pool-3-thread-10]: Committing Account settings for 794 2019-05-29 14:02:02.653 (3) [pool-3-thread-10]: Updating deployment status to 'InProgress' for campaignID: 10861 2019-05-29 14:02:02.654 (3) [pool-3-thread-10]: 10861 has no parent. Creating... 2019-05-29 14:02:02.657 (3) [pool-3-thread-10]: Updating advert budget for 8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861 2019-05-29 14:02:02.676 (3) [pool-3-thread-10]: Start processing DEPLOY request (7a820b40-933a-4714-9d33-8f6a8371f35e) for account 8866c0e9-7441-4c3c-be96-7adf01a42df7. 4 campaign(s). 2019-05-29 14:02:02.676 (3) [pool-3-thread-10]: Performing sync for account: 8866c0e9-7441-4c3c-be96-7adf01a42df7 ID#794 2019-05-29 14:02:02.680 (3) [pool-3-thread-10]: 0 campaign(s) to update. 2019-05-29 14:02:02.680 (3) [pool-3-thread-10]: 4 campaign(s) to create. 2019-05-29 14:02:02.680 (3) [pool-3-thread-10]: 0 campaign(s) to retry and update. 2019-05-29 14:02:02.683 (3) [pool-3-thread-10]: 8866c0e9-7441-4c3c-be96-7adf01a42df7 has 4 new campaign(s) for Facebook. 2019-05-29 14:02:02.683 (3) [pool-3-thread-10]: 8866c0e9-7441-4c3c-be96-7adf01a42df7 has 1 available users with 10000 available campaign slots. 2019-05-29 14:02:02.683 (3) [pool-3-thread-10]: Assigned existing seUserID: 1603 to: 8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S1 2019-05-29 14:02:02.683 (3) [pool-3-thread-10]: Assigned existing seUserID: 1603 to: 8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S2 2019-05-29 14:02:02.683 (3) [pool-3-thread-10]: Assigned existing seUserID: 1603 to: 8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S3 2019-05-29 14:02:02.683 (3) [pool-3-thread-10]: Assigned existing seUserID: 1603 to: 8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S4 2019-05-29 14:02:02.683 (3) [pool-3-thread-10]: Assigned 4 campaigns to: 1 existing user(s). 2019-05-29 14:02:02.687 (3) [pool-3-thread-10]: Creating 4 new campaign(s). 2019-05-29 14:02:02.687 (3) [pool-3-thread-10]: CampaignWorker initialized for account: 794 2019-05-29 14:02:02.687 (3) [pool-3-thread-10]: Creating 8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S1 Status: Paused 2019-05-29 14:02:02.687 (3) [pool-3-thread-10]: Creating 8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S2 Status: Paused 2019-05-29 14:02:02.687 (3) [pool-3-thread-10]: Creating 8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S3 Status: Paused 2019-05-29 14:02:02.687 (3) [pool-3-thread-10]: Creating 8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S4 Status: Paused 2019-05-29 14:02:02.687 (3) [pool-3-thread-10]: CampaignWorker started for account: 794 2019-05-29 14:02:02,792 [pool-3-thread-10] DEBUG c.t.s.facebook.FacebookApiUtils - Getting FB properties using distribution service 2019-05-29 14:02:02.792 (3) [pool-32-thread-1]: Starting Facebook Create Campaign Worker.. 2019-05-29 14:02:02,792 [pool-32-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Creating Facebook campaign structure for accountID 794 2019-05-29 14:02:02,793 [pool-32-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Facebook campaign startDate:2019-05-29T10:02:02.793-04:00 America/New_York 2019-05-29 14:02:02,793 [pool-32-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Facebook campaign endDate:2019-06-28T23:59:59.999-04:00 America/New_York 2019-05-29 14:02:02,793 [pool-32-thread-1] INFO c.t.s.f.FacebookAccountDeployer - finding carryover for seuserID 1603 2019-05-29 14:02:02,795 [pool-32-thread-1] INFO jdbc.sqlonly - SELECT mc.`id`, mc.`campaignID`, mc.`date`, mc.`dedicatedCarryover`, mc.`pooledCarryover`, mc.`type` FROM `monthlyCarryovers` mc JOIN `campaigns` c ON mc.`campaignID`= c.`id` WHERE c.`searchEngineUserId` = 1603 AND mc.`type` = 'normal' AND mc.`date` = (SELECT MAX(DATE) FROM monthlyCarryovers mc1 WHERE mc1.`campaignID` = mc.`campaignID` and c.`searchEngineUserId` = c.`searchEngineUserId` AND mc1.`type` = 'normal') ORDER BY c.`id` DESC LIMIT 4 2019-05-29 14:02:02,797 [pool-32-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Found campaign carryover data for seuserID 1603, carryover data ([TPCampaignCarryoverDTO [theID=2374, theCampaignID=1025, theDate=2019-05-29, theDedicatedCarryover=0.0, thePooledCarryover=0.13, theCarryoverType=normal], TPCampaignCarryoverDTO [theID=2373, theCampaignID=1024, theDate=2019-05-29, theDedicatedCarryover=0.0, thePooledCarryover=0.13, theCarryoverType=normal], TPCampaignCarryoverDTO [theID=2372, theCampaignID=1023, theDate=2019-05-29, theDedicatedCarryover=0.0, thePooledCarryover=0.13, theCarryoverType=normal], TPCampaignCarryoverDTO [theID=2371, theCampaignID=1022, theDate=2019-05-29, theDedicatedCarryover=0.0, thePooledCarryover=0.13, theCarryoverType=normal]]) 2019-05-29 14:02:02,797 [pool-32-thread-1] INFO c.t.s.f.FacebookAccountDeployer - totalPooledCarryover for seuserID 1603 and date 2019-05-29 is 0.52 USD 2019-05-29 14:02:02,797 [pool-32-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Individual campaign carryover for seuserID 1603 and date 2019-05-29 is 0.13 USD 2019-05-29 14:02:02,797 [pool-32-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Facebook campaign nominal monthly budget : 3125 2019-05-29 14:02:02,797 [pool-32-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Facebook campaign carryover : 13.0 2019-05-29 14:02:02,797 [pool-32-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Facebook campaign actual monthly budget : 3138 2019-05-29 14:02:02.803 (3) [pool-32-thread-1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2019-05-29 14:02:02,804 [pool-32-thread-1] INFO c.t.s.f.FacebookAccountStructureMapper - TPCampaignTargets [[TPLocation [theType=city, theId=2427305, theAddress=null, theLatitude=null, theLongitude=null, theRadius=null, theRadiusUnit=null]]] 2019-05-29 14:02:02,805 [pool-32-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Facebook campaign startDate:2019-05-29T10:02:02.805-04:00 America/New_York 2019-05-29 14:02:02,805 [pool-32-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Facebook campaign endDate:2019-06-28T23:59:59.999-04:00 America/New_York 2019-05-29 14:02:02,805 [pool-32-thread-1] INFO c.t.s.f.FacebookAccountDeployer - finding carryover for seuserID 1603 2019-05-29 14:02:02,807 [pool-32-thread-1] INFO jdbc.sqlonly - SELECT mc.`id`, mc.`campaignID`, mc.`date`, mc.`dedicatedCarryover`, mc.`pooledCarryover`, mc.`type` FROM `monthlyCarryovers` mc JOIN `campaigns` c ON mc.`campaignID`= c.`id` WHERE c.`searchEngineUserId` = 1603 AND mc.`type` = 'normal' AND mc.`date` = (SELECT MAX(DATE) FROM monthlyCarryovers mc1 WHERE mc1.`campaignID` = mc.`campaignID` and c.`searchEngineUserId` = c.`searchEngineUserId` AND mc1.`type` = 'normal') ORDER BY c.`id` DESC LIMIT 4 2019-05-29 14:02:02,809 [pool-32-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Found campaign carryover data for seuserID 1603, carryover data ([TPCampaignCarryoverDTO [theID=2374, theCampaignID=1025, theDate=2019-05-29, theDedicatedCarryover=0.0, thePooledCarryover=0.13, theCarryoverType=normal], TPCampaignCarryoverDTO [theID=2373, theCampaignID=1024, theDate=2019-05-29, theDedicatedCarryover=0.0, thePooledCarryover=0.13, theCarryoverType=normal], TPCampaignCarryoverDTO [theID=2372, theCampaignID=1023, theDate=2019-05-29, theDedicatedCarryover=0.0, thePooledCarryover=0.13, theCarryoverType=normal], TPCampaignCarryoverDTO [theID=2371, theCampaignID=1022, theDate=2019-05-29, theDedicatedCarryover=0.0, thePooledCarryover=0.13, theCarryoverType=normal]]) 2019-05-29 14:02:02,809 [pool-32-thread-1] INFO c.t.s.f.FacebookAccountDeployer - totalPooledCarryover for seuserID 1603 and date 2019-05-29 is 0.52 USD 2019-05-29 14:02:02,809 [pool-32-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Individual campaign carryover for seuserID 1603 and date 2019-05-29 is 0.13 USD 2019-05-29 14:02:02,809 [pool-32-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Facebook campaign nominal monthly budget : 3125 2019-05-29 14:02:02,809 [pool-32-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Facebook campaign carryover : 13.0 2019-05-29 14:02:02,809 [pool-32-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Facebook campaign actual monthly budget : 3138 2019-05-29 14:02:02,810 [pool-32-thread-1] INFO c.t.s.f.FacebookAccountStructureMapper - TPCampaignTargets [[TPLocation [theType=city, theId=2427305, theAddress=null, theLatitude=null, theLongitude=null, theRadius=null, theRadiusUnit=null]]] 2019-05-29 14:02:02,810 [pool-32-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Facebook campaign startDate:2019-05-29T10:02:02.810-04:00 America/New_York 2019-05-29 14:02:02,810 [pool-32-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Facebook campaign endDate:2019-06-28T23:59:59.999-04:00 America/New_York 2019-05-29 14:02:02,811 [pool-32-thread-1] INFO c.t.s.f.FacebookAccountDeployer - finding carryover for seuserID 1603 2019-05-29 14:02:02,813 [pool-32-thread-1] INFO jdbc.sqlonly - SELECT mc.`id`, mc.`campaignID`, mc.`date`, mc.`dedicatedCarryover`, mc.`pooledCarryover`, mc.`type` FROM `monthlyCarryovers` mc JOIN `campaigns` c ON mc.`campaignID`= c.`id` WHERE c.`searchEngineUserId` = 1603 AND mc.`type` = 'normal' AND mc.`date` = (SELECT MAX(DATE) FROM monthlyCarryovers mc1 WHERE mc1.`campaignID` = mc.`campaignID` and c.`searchEngineUserId` = c.`searchEngineUserId` AND mc1.`type` = 'normal') ORDER BY c.`id` DESC LIMIT 4 2019-05-29 14:02:02,818 [pool-32-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Found campaign carryover data for seuserID 1603, carryover data ([TPCampaignCarryoverDTO [theID=2374, theCampaignID=1025, theDate=2019-05-29, theDedicatedCarryover=0.0, thePooledCarryover=0.13, theCarryoverType=normal], TPCampaignCarryoverDTO [theID=2373, theCampaignID=1024, theDate=2019-05-29, theDedicatedCarryover=0.0, thePooledCarryover=0.13, theCarryoverType=normal], TPCampaignCarryoverDTO [theID=2372, theCampaignID=1023, theDate=2019-05-29, theDedicatedCarryover=0.0, thePooledCarryover=0.13, theCarryoverType=normal], TPCampaignCarryoverDTO [theID=2371, theCampaignID=1022, theDate=2019-05-29, theDedicatedCarryover=0.0, thePooledCarryover=0.13, theCarryoverType=normal]]) 2019-05-29 14:02:02,818 [pool-32-thread-1] INFO c.t.s.f.FacebookAccountDeployer - totalPooledCarryover for seuserID 1603 and date 2019-05-29 is 0.52 USD 2019-05-29 14:02:02,818 [pool-32-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Individual campaign carryover for seuserID 1603 and date 2019-05-29 is 0.13 USD 2019-05-29 14:02:02,818 [pool-32-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Facebook campaign nominal monthly budget : 3125 2019-05-29 14:02:02,818 [pool-32-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Facebook campaign carryover : 13.0 2019-05-29 14:02:02,818 [pool-32-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Facebook campaign actual monthly budget : 3138 2019-05-29 14:02:02,820 [pool-32-thread-1] INFO c.t.s.f.FacebookAccountStructureMapper - TPCampaignTargets [[TPLocation [theType=city, theId=2427305, theAddress=null, theLatitude=null, theLongitude=null, theRadius=null, theRadiusUnit=null]]] 2019-05-29 14:02:02,820 [pool-32-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Facebook campaign startDate:2019-05-29T10:02:02.820-04:00 America/New_York 2019-05-29 14:02:02,820 [pool-32-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Facebook campaign endDate:2019-06-28T23:59:59.999-04:00 America/New_York 2019-05-29 14:02:02,820 [pool-32-thread-1] INFO c.t.s.f.FacebookAccountDeployer - finding carryover for seuserID 1603 2019-05-29 14:02:02,825 [pool-32-thread-1] INFO jdbc.sqlonly - SELECT mc.`id`, mc.`campaignID`, mc.`date`, mc.`dedicatedCarryover`, mc.`pooledCarryover`, mc.`type` FROM `monthlyCarryovers` mc JOIN `campaigns` c ON mc.`campaignID`= c.`id` WHERE c.`searchEngineUserId` = 1603 AND mc.`type` = 'normal' AND mc.`date` = (SELECT MAX(DATE) FROM monthlyCarryovers mc1 WHERE mc1.`campaignID` = mc.`campaignID` and c.`searchEngineUserId` = c.`searchEngineUserId` AND mc1.`type` = 'normal') ORDER BY c.`id` DESC LIMIT 4 2019-05-29 14:02:02,827 [pool-32-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Found campaign carryover data for seuserID 1603, carryover data ([TPCampaignCarryoverDTO [theID=2374, theCampaignID=1025, theDate=2019-05-29, theDedicatedCarryover=0.0, thePooledCarryover=0.13, theCarryoverType=normal], TPCampaignCarryoverDTO [theID=2373, theCampaignID=1024, theDate=2019-05-29, theDedicatedCarryover=0.0, thePooledCarryover=0.13, theCarryoverType=normal], TPCampaignCarryoverDTO [theID=2372, theCampaignID=1023, theDate=2019-05-29, theDedicatedCarryover=0.0, thePooledCarryover=0.13, theCarryoverType=normal], TPCampaignCarryoverDTO [theID=2371, theCampaignID=1022, theDate=2019-05-29, theDedicatedCarryover=0.0, thePooledCarryover=0.13, theCarryoverType=normal]]) 2019-05-29 14:02:02,827 [pool-32-thread-1] INFO c.t.s.f.FacebookAccountDeployer - totalPooledCarryover for seuserID 1603 and date 2019-05-29 is 0.52 USD 2019-05-29 14:02:02,827 [pool-32-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Individual campaign carryover for seuserID 1603 and date 2019-05-29 is 0.13 USD 2019-05-29 14:02:02,827 [pool-32-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Facebook campaign nominal monthly budget : 3125 2019-05-29 14:02:02,827 [pool-32-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Facebook campaign carryover : 13.0 2019-05-29 14:02:02,827 [pool-32-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Facebook campaign actual monthly budget : 3138 2019-05-29 14:02:02,829 [pool-32-thread-1] INFO c.t.s.f.FacebookAccountStructureMapper - TPCampaignTargets [[TPLocation [theType=city, theId=2427305, theAddress=null, theLatitude=null, theLongitude=null, theRadius=null, theRadiusUnit=null]]] 2019-05-29 14:02:02,833 [pool-32-thread-1] INFO c.t.s.c.t.i.s.CampaignServiceClient - Adding TP campaign [8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S1] to account 45bd0b8dd9bd43638d837334d7e7d9fb 2019-05-29 14:02:02,840 [pool-32-thread-1] INFO o.a.c.i.LoggingOutInterceptor - Outbound Message --------------------------- ID: 217 Address: https://api.tigerpistol.com/v1/campaigns/ Http-Method: POST Content-Type: application/json Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token A5CO5g2RJFRI4w5mWJ32bkCAwQ6mMWo9bHPUWqIC]} Payload: { "name" : "8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S1", "status" : "Active", "customerId" : "45bd0b8dd9bd43638d837334d7e7d9fb", "objective" : "website_clicks", "budget" : 3138, "start" : "2019-05-29T14:02:02.793Z", "maxEnd" : "2019-06-29T03:59:59.999Z", "placement" : [ "desktopfeed", "mobilefeed", "instagramstream", "rightcolumn" ], "details" : { "audiences" : [ { "ageFrom" : 18, "ageTo" : 65, "gender" : "females", "locationTypes" : [ "home", "recent" ], "demographics" : { "behaviors" : [ "6002714895372" ], "interests" : [ "6002926108721" ] }, "locations" : [ { "type" : "city", "id" : "2427305" } ] } ], "copies" : [ { "headline" : "Hotel Room in Baker FL", "body" : "Baker FL - Top Resort. You'll Have a Great Stay Here!", "description" : "Find a Vacation Resort", "destinationUrl" : "http://www.merchantsite.com" } ], "images" : [ "https://s3-us-west-1.amazonaws.com/aml-qa/merchants/8866c0e9-7441-4c3c-be96-7adf01a42df7/images/81f619ad-c986-4241-a70a-3f17113513724216542154981918683.png" ], "cta" : [ { "type" : "apply_now" } ] } } -------------------------------------- 2019-05-29 14:02:05,286 [pool-32-thread-1] INFO o.a.c.i.LoggingInInterceptor - Inbound Message ---------------------------- ID: 217 Response-Code: 201 Encoding: UTF-8 Content-Type: application/json; charset=utf-8 Headers: {api-supported-versions=[1.0], Content-Length=[663], content-type=[application/json; charset=utf-8], Date=[Wed, 29 May 2019 14:02:05 GMT], Location=[https://api.tigerpistol.com/v1/campaigns/0987e04f-4bdd-425d-a974-011b45cbb076], 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}],"displayMargin":1.0,"hasError":false,"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,"id":"0987e04f4bdd425da974011b45cbb076","customerId":"45bd0b8dd9bd43638d837334d7e7d9fb","name":"8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S1","start":"2019-05-29T14:02:00+00:00","end":"2019-06-29T03:59:00+00:00","budget":3138.00,"objective":"website_clicks","status":"live","publishPhase":"complete","errorMessage":""} -------------------------------------- 2019-05-29 14:02:05,287 [pool-32-thread-1] INFO c.t.s.c.t.i.s.CampaignServiceClient - Updating TP campaign [0987e04f4bdd425da974011b45cbb076] status to [resume] for account 45bd0b8dd9bd43638d837334d7e7d9fb 2019-05-29 14:02:05,302 [pool-32-thread-1] INFO o.a.c.i.LoggingOutInterceptor - Outbound Message --------------------------- ID: 218 Address: https://api.tigerpistol.com/v1/campaigns/0987e04f4bdd425da974011b45cbb076/resume Http-Method: POST Content-Type: application/json Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token A5CO5g2RJFRI4w5mWJ32bkCAwQ6mMWo9bHPUWqIC]} -------------------------------------- 2019-05-29 14:02:05,593 [pool-32-thread-1] INFO o.a.c.i.LoggingInInterceptor - Inbound Message ---------------------------- ID: 218 Response-Code: 200 Encoding: ISO-8859-1 Content-Type: Headers: {api-supported-versions=[1.0], Content-Length=[0], Date=[Wed, 29 May 2019 14:02:05 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]} -------------------------------------- 2019-05-29 14:02:05,593 [pool-32-thread-1] INFO c.t.s.c.t.i.s.CampaignServiceClient - Adding TP campaign [8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S2] to account 45bd0b8dd9bd43638d837334d7e7d9fb 2019-05-29 14:02:05,600 [pool-32-thread-1] INFO o.a.c.i.LoggingOutInterceptor - Outbound Message --------------------------- ID: 219 Address: https://api.tigerpistol.com/v1/campaigns/ Http-Method: POST Content-Type: application/json Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token A5CO5g2RJFRI4w5mWJ32bkCAwQ6mMWo9bHPUWqIC]} Payload: { "name" : "8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S2", "status" : "Active", "customerId" : "45bd0b8dd9bd43638d837334d7e7d9fb", "objective" : "website_clicks", "budget" : 3138, "start" : "2019-05-29T14:02:02.805Z", "maxEnd" : "2019-06-29T03:59:59.999Z", "placement" : [ "desktopfeed", "mobilefeed", "instagramstream", "rightcolumn" ], "details" : { "audiences" : [ { "ageFrom" : 18, "ageTo" : 65, "gender" : "females", "locationTypes" : [ "home", "recent" ], "demographics" : { "behaviors" : [ "6002714895372" ], "interests" : [ "6002926108721" ] }, "locations" : [ { "type" : "city", "id" : "2427305" } ] } ], "copies" : [ { "headline" : "Find a Vacation Resort", "body" : "Baker FL - Top Resort. You'll Have a Great Stay Here!", "description" : "Hotel Room in Baker FL", "destinationUrl" : "http://www.merchantsite.com" } ], "images" : [ "https://s3-us-west-1.amazonaws.com/aml-qa/merchants/8866c0e9-7441-4c3c-be96-7adf01a42df7/images/81f619ad-c986-4241-a70a-3f17113513724216542154981918683.png" ], "cta" : [ { "type" : "apply_now" } ] } } -------------------------------------- 2019-05-29 14:02:07,947 [pool-32-thread-1] INFO o.a.c.i.LoggingInInterceptor - Inbound Message ---------------------------- ID: 219 Response-Code: 201 Encoding: UTF-8 Content-Type: application/json; charset=utf-8 Headers: {api-supported-versions=[1.0], Content-Length=[663], content-type=[application/json; charset=utf-8], Date=[Wed, 29 May 2019 14:02:07 GMT], Location=[https://api.tigerpistol.com/v1/campaigns/95c171ba-95d2-4c17-b61c-f6ba7d285eb4], 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}],"displayMargin":1.0,"hasError":false,"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,"id":"95c171ba95d24c17b61cf6ba7d285eb4","customerId":"45bd0b8dd9bd43638d837334d7e7d9fb","name":"8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S2","start":"2019-05-29T14:02:00+00:00","end":"2019-06-29T03:59:00+00:00","budget":3138.00,"objective":"website_clicks","status":"live","publishPhase":"complete","errorMessage":""} -------------------------------------- 2019-05-29 14:02:07,948 [pool-32-thread-1] INFO c.t.s.c.t.i.s.CampaignServiceClient - Updating TP campaign [95c171ba95d24c17b61cf6ba7d285eb4] status to [resume] for account 45bd0b8dd9bd43638d837334d7e7d9fb 2019-05-29 14:02:07,951 [pool-32-thread-1] INFO o.a.c.i.LoggingOutInterceptor - Outbound Message --------------------------- ID: 220 Address: https://api.tigerpistol.com/v1/campaigns/95c171ba95d24c17b61cf6ba7d285eb4/resume Http-Method: POST Content-Type: application/json Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token A5CO5g2RJFRI4w5mWJ32bkCAwQ6mMWo9bHPUWqIC]} -------------------------------------- 2019-05-29 14:02:08,242 [pool-32-thread-1] INFO o.a.c.i.LoggingInInterceptor - Inbound Message ---------------------------- ID: 220 Response-Code: 200 Encoding: ISO-8859-1 Content-Type: Headers: {api-supported-versions=[1.0], Content-Length=[0], Date=[Wed, 29 May 2019 14:02:08 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]} -------------------------------------- 2019-05-29 14:02:08,243 [pool-32-thread-1] INFO c.t.s.c.t.i.s.CampaignServiceClient - Adding TP campaign [8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S3] to account 45bd0b8dd9bd43638d837334d7e7d9fb 2019-05-29 14:02:08,248 [pool-32-thread-1] INFO o.a.c.i.LoggingOutInterceptor - Outbound Message --------------------------- ID: 221 Address: https://api.tigerpistol.com/v1/campaigns/ Http-Method: POST Content-Type: application/json Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token A5CO5g2RJFRI4w5mWJ32bkCAwQ6mMWo9bHPUWqIC]} Payload: { "name" : "8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S3", "status" : "Active", "customerId" : "45bd0b8dd9bd43638d837334d7e7d9fb", "objective" : "website_clicks", "budget" : 3138, "start" : "2019-05-29T14:02:02.810Z", "maxEnd" : "2019-06-29T03:59:59.999Z", "placement" : [ "desktopfeed", "mobilefeed", "instagramstream", "rightcolumn" ], "details" : { "audiences" : [ { "ageFrom" : 18, "ageTo" : 65, "gender" : "females", "locationTypes" : [ "home", "recent" ], "demographics" : { "behaviors" : [ "6002714895372" ], "interests" : [ "6002926108721" ] }, "locations" : [ { "type" : "city", "id" : "2427305" } ] } ], "copies" : [ { "headline" : "Find a Vacation Resort", "body" : "Baker FL Spa Resort. Personable, Professional Service.", "description" : "Hotel Room in Baker FL", "destinationUrl" : "http://www.merchantsite.com" } ], "images" : [ "https://s3-us-west-1.amazonaws.com/aml-qa/merchants/8866c0e9-7441-4c3c-be96-7adf01a42df7/images/81f619ad-c986-4241-a70a-3f17113513724216542154981918683.png" ], "cta" : [ { "type" : "apply_now" } ] } } -------------------------------------- 2019-05-29 14:02:08.459 (3) [Thread-9]: Heartbeat #822 (1559138528456) received in 0.003s 2019-05-29 14:02:11,187 [pool-32-thread-1] INFO o.a.c.i.LoggingInInterceptor - Inbound Message ---------------------------- ID: 221 Response-Code: 201 Encoding: UTF-8 Content-Type: application/json; charset=utf-8 Headers: {api-supported-versions=[1.0], Content-Length=[663], content-type=[application/json; charset=utf-8], Date=[Wed, 29 May 2019 14:02:10 GMT], Location=[https://api.tigerpistol.com/v1/campaigns/8aff4227-8666-4463-b4f2-a241aebcb036], 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}],"displayMargin":1.0,"hasError":false,"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,"id":"8aff422786664463b4f2a241aebcb036","customerId":"45bd0b8dd9bd43638d837334d7e7d9fb","name":"8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S3","start":"2019-05-29T14:02:00+00:00","end":"2019-06-29T03:59:00+00:00","budget":3138.00,"objective":"website_clicks","status":"live","publishPhase":"complete","errorMessage":""} -------------------------------------- 2019-05-29 14:02:11,189 [pool-32-thread-1] INFO c.t.s.c.t.i.s.CampaignServiceClient - Updating TP campaign [8aff422786664463b4f2a241aebcb036] status to [resume] for account 45bd0b8dd9bd43638d837334d7e7d9fb 2019-05-29 14:02:11,192 [pool-32-thread-1] INFO o.a.c.i.LoggingOutInterceptor - Outbound Message --------------------------- ID: 222 Address: https://api.tigerpistol.com/v1/campaigns/8aff422786664463b4f2a241aebcb036/resume Http-Method: POST Content-Type: application/json Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token A5CO5g2RJFRI4w5mWJ32bkCAwQ6mMWo9bHPUWqIC]} -------------------------------------- 2019-05-29 14:02:11,483 [pool-32-thread-1] INFO o.a.c.i.LoggingInInterceptor - Inbound Message ---------------------------- ID: 222 Response-Code: 200 Encoding: ISO-8859-1 Content-Type: Headers: {api-supported-versions=[1.0], Content-Length=[0], Date=[Wed, 29 May 2019 14:02:11 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]} -------------------------------------- 2019-05-29 14:02:11,483 [pool-32-thread-1] INFO c.t.s.c.t.i.s.CampaignServiceClient - Adding TP campaign [8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S4] to account 45bd0b8dd9bd43638d837334d7e7d9fb 2019-05-29 14:02:11,489 [pool-32-thread-1] INFO o.a.c.i.LoggingOutInterceptor - Outbound Message --------------------------- ID: 223 Address: https://api.tigerpistol.com/v1/campaigns/ Http-Method: POST Content-Type: application/json Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token A5CO5g2RJFRI4w5mWJ32bkCAwQ6mMWo9bHPUWqIC]} Payload: { "name" : "8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S4", "status" : "Active", "customerId" : "45bd0b8dd9bd43638d837334d7e7d9fb", "objective" : "website_clicks", "budget" : 3138, "start" : "2019-05-29T14:02:02.820Z", "maxEnd" : "2019-06-29T03:59:59.999Z", "placement" : [ "desktopfeed", "mobilefeed", "instagramstream", "rightcolumn" ], "details" : { "audiences" : [ { "ageFrom" : 18, "ageTo" : 65, "gender" : "females", "locationTypes" : [ "home", "recent" ], "demographics" : { "behaviors" : [ "6002714895372" ], "interests" : [ "6002926108721" ] }, "locations" : [ { "type" : "city", "id" : "2427305" } ] } ], "copies" : [ { "headline" : "Hotel Room in Baker FL", "body" : "Baker FL Spa Resort. Personable, Professional Service.", "description" : "Find a Vacation Resort", "destinationUrl" : "http://www.merchantsite.com" } ], "images" : [ "https://s3-us-west-1.amazonaws.com/aml-qa/merchants/8866c0e9-7441-4c3c-be96-7adf01a42df7/images/81f619ad-c986-4241-a70a-3f17113513724216542154981918683.png" ], "cta" : [ { "type" : "apply_now" } ] } } -------------------------------------- 2019-05-29 14:02:13,467 [pool-32-thread-1] INFO o.a.c.i.LoggingInInterceptor - Inbound Message ---------------------------- ID: 223 Response-Code: 201 Encoding: UTF-8 Content-Type: application/json; charset=utf-8 Headers: {api-supported-versions=[1.0], Content-Length=[663], content-type=[application/json; charset=utf-8], Date=[Wed, 29 May 2019 14:02:13 GMT], Location=[https://api.tigerpistol.com/v1/campaigns/30de3760-b315-4c8c-978d-bb5a44797161], 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}],"displayMargin":1.0,"hasError":false,"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,"id":"30de3760b3154c8c978dbb5a44797161","customerId":"45bd0b8dd9bd43638d837334d7e7d9fb","name":"8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S4","start":"2019-05-29T14:02:00+00:00","end":"2019-06-29T03:59:00+00:00","budget":3138.00,"objective":"website_clicks","status":"live","publishPhase":"complete","errorMessage":""} -------------------------------------- 2019-05-29 14:02:13,468 [pool-32-thread-1] INFO c.t.s.c.t.i.s.CampaignServiceClient - Updating TP campaign [30de3760b3154c8c978dbb5a44797161] status to [resume] for account 45bd0b8dd9bd43638d837334d7e7d9fb 2019-05-29 14:02:13,471 [pool-32-thread-1] INFO o.a.c.i.LoggingOutInterceptor - Outbound Message --------------------------- ID: 224 Address: https://api.tigerpistol.com/v1/campaigns/30de3760b3154c8c978dbb5a44797161/resume Http-Method: POST Content-Type: application/json Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token A5CO5g2RJFRI4w5mWJ32bkCAwQ6mMWo9bHPUWqIC]} -------------------------------------- 2019-05-29 14:02:13,785 [pool-32-thread-1] INFO o.a.c.i.LoggingInInterceptor - Inbound Message ---------------------------- ID: 224 Response-Code: 200 Encoding: ISO-8859-1 Content-Type: Headers: {api-supported-versions=[1.0], Content-Length=[0], Date=[Wed, 29 May 2019 14:02:13 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]} -------------------------------------- 2019-05-29 14:02:18,785 [pool-32-thread-1] INFO c.t.s.c.t.i.s.CampaignServiceClient - Getting TP campaign [0987e04f4bdd425da974011b45cbb076] details for account 45bd0b8dd9bd43638d837334d7e7d9fb 2019-05-29 14:02:18,789 [pool-32-thread-1] INFO o.a.c.i.LoggingOutInterceptor - Outbound Message --------------------------- ID: 225 Address: https://api.tigerpistol.com/v1/campaigns/0987e04f4bdd425da974011b45cbb076 Http-Method: GET Content-Type: application/json Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token A5CO5g2RJFRI4w5mWJ32bkCAwQ6mMWo9bHPUWqIC]} -------------------------------------- 2019-05-29 14:02:19,081 [pool-32-thread-1] INFO o.a.c.i.LoggingInInterceptor - Inbound Message ---------------------------- ID: 225 Response-Code: 200 Encoding: UTF-8 Content-Type: application/json; charset=utf-8 Headers: {api-supported-versions=[1.0], Content-Length=[713], content-type=[application/json; charset=utf-8], Date=[Wed, 29 May 2019 14:02:18 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]} Payload: {"variations":[{"index":0,"reviewError":null}],"displayMargin":1.0,"hasError":true,"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,"id":"0987e04f4bdd425da974011b45cbb076","customerId":"45bd0b8dd9bd43638d837334d7e7d9fb","name":"8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S1","start":"2019-05-29T14:02:00+00:00","end":"2019-06-29T03:59:00+00:00","budget":3138.00,"objective":"website_clicks","status":"error","publishPhase":"error","errorMessage":"Please add a valid payment method to your ad account."} -------------------------------------- 2019-05-29 14:02:24,083 [pool-32-thread-1] INFO c.t.s.c.t.i.s.CampaignServiceClient - Getting TP campaign [95c171ba95d24c17b61cf6ba7d285eb4] details for account 45bd0b8dd9bd43638d837334d7e7d9fb 2019-05-29 14:02:24,086 [pool-32-thread-1] INFO o.a.c.i.LoggingOutInterceptor - Outbound Message --------------------------- ID: 226 Address: https://api.tigerpistol.com/v1/campaigns/95c171ba95d24c17b61cf6ba7d285eb4 Http-Method: GET Content-Type: application/json Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token A5CO5g2RJFRI4w5mWJ32bkCAwQ6mMWo9bHPUWqIC]} -------------------------------------- 2019-05-29 14:02:24,380 [pool-32-thread-1] INFO o.a.c.i.LoggingInInterceptor - Inbound Message ---------------------------- ID: 226 Response-Code: 200 Encoding: UTF-8 Content-Type: application/json; charset=utf-8 Headers: {api-supported-versions=[1.0], Content-Length=[713], content-type=[application/json; charset=utf-8], Date=[Wed, 29 May 2019 14:02:24 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]} Payload: {"variations":[{"index":0,"reviewError":null}],"displayMargin":1.0,"hasError":true,"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,"id":"95c171ba95d24c17b61cf6ba7d285eb4","customerId":"45bd0b8dd9bd43638d837334d7e7d9fb","name":"8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S2","start":"2019-05-29T14:02:00+00:00","end":"2019-06-29T03:59:00+00:00","budget":3138.00,"objective":"website_clicks","status":"error","publishPhase":"error","errorMessage":"Please add a valid payment method to your ad account."} -------------------------------------- 2019-05-29 14:02:29,382 [pool-32-thread-1] INFO c.t.s.c.t.i.s.CampaignServiceClient - Getting TP campaign [8aff422786664463b4f2a241aebcb036] details for account 45bd0b8dd9bd43638d837334d7e7d9fb 2019-05-29 14:02:29,385 [pool-32-thread-1] INFO o.a.c.i.LoggingOutInterceptor - Outbound Message --------------------------- ID: 227 Address: https://api.tigerpistol.com/v1/campaigns/8aff422786664463b4f2a241aebcb036 Http-Method: GET Content-Type: application/json Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token A5CO5g2RJFRI4w5mWJ32bkCAwQ6mMWo9bHPUWqIC]} -------------------------------------- 2019-05-29 14:02:29,700 [pool-32-thread-1] INFO o.a.c.i.LoggingInInterceptor - Inbound Message ---------------------------- ID: 227 Response-Code: 200 Encoding: UTF-8 Content-Type: application/json; charset=utf-8 Headers: {api-supported-versions=[1.0], Content-Length=[713], content-type=[application/json; charset=utf-8], Date=[Wed, 29 May 2019 14:02:29 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]} Payload: {"variations":[{"index":0,"reviewError":null}],"displayMargin":1.0,"hasError":true,"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,"id":"8aff422786664463b4f2a241aebcb036","customerId":"45bd0b8dd9bd43638d837334d7e7d9fb","name":"8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S3","start":"2019-05-29T14:02:00+00:00","end":"2019-06-29T03:59:00+00:00","budget":3138.00,"objective":"website_clicks","status":"error","publishPhase":"error","errorMessage":"Please add a valid payment method to your ad account."} -------------------------------------- 2019-05-29 14:02:34,702 [pool-32-thread-1] INFO c.t.s.c.t.i.s.CampaignServiceClient - Getting TP campaign [30de3760b3154c8c978dbb5a44797161] details for account 45bd0b8dd9bd43638d837334d7e7d9fb 2019-05-29 14:02:34,705 [pool-32-thread-1] INFO o.a.c.i.LoggingOutInterceptor - Outbound Message --------------------------- ID: 228 Address: https://api.tigerpistol.com/v1/campaigns/30de3760b3154c8c978dbb5a44797161 Http-Method: GET Content-Type: application/json Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token A5CO5g2RJFRI4w5mWJ32bkCAwQ6mMWo9bHPUWqIC]} -------------------------------------- 2019-05-29 14:02:34,999 [pool-32-thread-1] INFO o.a.c.i.LoggingInInterceptor - Inbound Message ---------------------------- ID: 228 Response-Code: 200 Encoding: UTF-8 Content-Type: application/json; charset=utf-8 Headers: {api-supported-versions=[1.0], Content-Length=[713], content-type=[application/json; charset=utf-8], Date=[Wed, 29 May 2019 14:02:34 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]} Payload: {"variations":[{"index":0,"reviewError":null}],"displayMargin":1.0,"hasError":true,"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,"id":"30de3760b3154c8c978dbb5a44797161","customerId":"45bd0b8dd9bd43638d837334d7e7d9fb","name":"8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S4","start":"2019-05-29T14:02:00+00:00","end":"2019-06-29T03:59:00+00:00","budget":3138.00,"objective":"website_clicks","status":"error","publishPhase":"error","errorMessage":"Please add a valid payment method to your ad account."} -------------------------------------- 2019-05-29 14:02:35,001 [pool-32-thread-1] INFO jdbc.sqlonly - DELETE FROM `errors` WHERE `elementName` IN ('8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S1','8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S2','8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S3','8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S4') 2019-05-29 14:02:35,001 [pool-32-thread-1] INFO c.t.s.client.tp.dao.TPErrorDAO - Removed '0' Previous Errors 2019-05-29 14:02:35,002 [pool-32-thread-1] INFO jdbc.sqlonly - batching 4 statements: 1: INSERT INTO `errors` (`elementName`, `itemType`, `itemKey`, `code`, `detail`, `errorCode`, `index`, `message`, `errorType`, `tpId`, `parentId`, `lastUpdated`, `errorJson`) VALUES ('8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S1','CAMPAIGN_STATUS','8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S1',0,'status: error, publish Phase: error',NULL,NULL,'Please add a valid payment method to your ad account.',NULL,'0987e04f4bdd425da974011b45cbb076',NULL,NOW(),'{"code":0,"message":"Please add a valid payment method to your ad account.","detail":"status: error, publish Phase: error","errorCode":null,"errorType":null,"index":null,"elementName":"8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S1","type":"CAMPAIGN_STATUS","key":"8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S1","searchEngineId":"0987e04f4bdd425da974011b45cbb076","parentSearchEngineId":null}') 2: INSERT INTO `errors` (`elementName`, `itemType`, `itemKey`, `code`, `detail`, `errorCode`, `index`, `message`, `errorType`, `tpId`, `parentId`, `lastUpdated`, `errorJson`) VALUES ('8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S2','CAMPAIGN_STATUS','8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S2',0,'status: error, publish Phase: error',NULL,NULL,'Please add a valid payment method to your ad account.',NULL,'95c171ba95d24c17b61cf6ba7d285eb4',NULL,NOW(),'{"code":0,"message":"Please add a valid payment method to your ad account.","detail":"status: error, publish Phase: error","errorCode":null,"errorType":null,"index":null,"elementName":"8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S2","type":"CAMPAIGN_STATUS","key":"8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S2","searchEngineId":"95c171ba95d24c17b61cf6ba7d285eb4","parentSearchEngineId":null}') 3: INSERT INTO `errors` (`elementName`, `itemType`, `itemKey`, `code`, `detail`, `errorCode`, `index`, `message`, `errorType`, `tpId`, `parentId`, `lastUpdated`, `errorJson`) VALUES ('8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S3','CAMPAIGN_STATUS','8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S3',0,'status: error, publish Phase: error',NULL,NULL,'Please add a valid payment method to your ad account.',NULL,'8aff422786664463b4f2a241aebcb036',NULL,NOW(),'{"code":0,"message":"Please add a valid payment method to your ad account.","detail":"status: error, publish Phase: error","errorCode":null,"errorType":null,"index":null,"elementName":"8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S3","type":"CAMPAIGN_STATUS","key":"8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S3","searchEngineId":"8aff422786664463b4f2a241aebcb036","parentSearchEngineId":null}') 4: INSERT INTO `errors` (`elementName`, `itemType`, `itemKey`, `code`, `detail`, `errorCode`, `index`, `message`, `errorType`, `tpId`, `parentId`, `lastUpdated`, `errorJson`) VALUES ('8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S4','CAMPAIGN_STATUS','8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S4',0,'status: error, publish Phase: error',NULL,NULL,'Please add a valid payment method to your ad account.',NULL,'30de3760b3154c8c978dbb5a44797161',NULL,NOW(),'{"code":0,"message":"Please add a valid payment method to your ad account.","detail":"status: error, publish Phase: error","errorCode":null,"errorType":null,"index":null,"elementName":"8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S4","type":"CAMPAIGN_STATUS","key":"8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S4","searchEngineId":"30de3760b3154c8c978dbb5a44797161","parentSearchEngineId":null}') 2019-05-29 14:02:35,006 [pool-32-thread-1] INFO jdbc.sqlonly - INSERT INTO `campaigns` (`searchEngineUserId`, `tpId`, `name`, `status`, `startDate`, `endDate`, `lastUpdated`, `json`) VALUES (1603, '0987e04f4bdd425da974011b45cbb076', '8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S1', 'Active', '05/29/2019 14:02:02.793', '06/29/2019 03:59:59.999', NOW(), '{"campaign":{"name":"8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S1","status":"Active","id":"0987e04f4bdd425da974011b45cbb076","customerId":"45bd0b8dd9bd43638d837334d7e7d9fb","objective":"website_clicks","budget":3138,"start":"2019-05-29T14:02:02.793Z","maxEnd":"2019-06-29T03:59:59.999Z","placement":["desktopfeed","mobilefeed","instagramstream","rightcolumn"],"details":{"audiences":[{"ageFrom":18,"ageTo":65,"gender":"females","locationTypes":["home","recent"],"demographics":{"behaviors":["6002714895372"],"interests":["6002926108721"]},"locations":[{"type":"city","id":"2427305"}]}],"copies":[{"headline":"Hotel Room in Baker FL","body":"Baker FL - Top Resort. You''ll Have a Great Stay Here!","description":"Find a Vacation Resort","destinationUrl":"http://www.merchantsite.com"}],"images":["https://s3-us-west-1.amazonaws.com/aml-qa/merchants/8866c0e9-7441-4c3c-be96-7adf01a42df7/images/81f619ad-c986-4241-a70a-3f17113513724216542154981918683.png"],"cta":[{"type":"apply_now"}]}},"searchEngineUserId":1603}') 2019-05-29 14:02:35,006 [pool-32-thread-1] INFO jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`tpId` = '0987e04f4bdd425da974011b45cbb076' 2019-05-29 14:02:35,007 [pool-32-thread-1] INFO jdbc.sqlonly - INSERT INTO `campaigns` (`searchEngineUserId`, `tpId`, `name`, `status`, `startDate`, `endDate`, `lastUpdated`, `json`) VALUES (1603, '95c171ba95d24c17b61cf6ba7d285eb4', '8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S2', 'Active', '05/29/2019 14:02:02.805', '06/29/2019 03:59:59.999', NOW(), '{"campaign":{"name":"8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S2","status":"Active","id":"95c171ba95d24c17b61cf6ba7d285eb4","customerId":"45bd0b8dd9bd43638d837334d7e7d9fb","objective":"website_clicks","budget":3138,"start":"2019-05-29T14:02:02.805Z","maxEnd":"2019-06-29T03:59:59.999Z","placement":["desktopfeed","mobilefeed","instagramstream","rightcolumn"],"details":{"audiences":[{"ageFrom":18,"ageTo":65,"gender":"females","locationTypes":["home","recent"],"demographics":{"behaviors":["6002714895372"],"interests":["6002926108721"]},"locations":[{"type":"city","id":"2427305"}]}],"copies":[{"headline":"Find a Vacation Resort","body":"Baker FL - Top Resort. You''ll Have a Great Stay Here!","description":"Hotel Room in Baker FL","destinationUrl":"http://www.merchantsite.com"}],"images":["https://s3-us-west-1.amazonaws.com/aml-qa/merchants/8866c0e9-7441-4c3c-be96-7adf01a42df7/images/81f619ad-c986-4241-a70a-3f17113513724216542154981918683.png"],"cta":[{"type":"apply_now"}]}},"searchEngineUserId":1603}') 2019-05-29 14:02:35,009 [pool-32-thread-1] INFO jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`tpId` = '95c171ba95d24c17b61cf6ba7d285eb4' 2019-05-29 14:02:35,010 [pool-32-thread-1] INFO jdbc.sqlonly - INSERT INTO `campaigns` (`searchEngineUserId`, `tpId`, `name`, `status`, `startDate`, `endDate`, `lastUpdated`, `json`) VALUES (1603, '8aff422786664463b4f2a241aebcb036', '8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S3', 'Active', '05/29/2019 14:02:02.810', '06/29/2019 03:59:59.999', NOW(), '{"campaign":{"name":"8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S3","status":"Active","id":"8aff422786664463b4f2a241aebcb036","customerId":"45bd0b8dd9bd43638d837334d7e7d9fb","objective":"website_clicks","budget":3138,"start":"2019-05-29T14:02:02.810Z","maxEnd":"2019-06-29T03:59:59.999Z","placement":["desktopfeed","mobilefeed","instagramstream","rightcolumn"],"details":{"audiences":[{"ageFrom":18,"ageTo":65,"gender":"females","locationTypes":["home","recent"],"demographics":{"behaviors":["6002714895372"],"interests":["6002926108721"]},"locations":[{"type":"city","id":"2427305"}]}],"copies":[{"headline":"Find a Vacation Resort","body":"Baker FL Spa Resort. Personable, Professional Service.","description":"Hotel Room in Baker FL","destinationUrl":"http://www.merchantsite.com"}],"images":["https://s3-us-west-1.amazonaws.com/aml-qa/merchants/8866c0e9-7441-4c3c-be96-7adf01a42df7/images/81f619ad-c986-4241-a70a-3f17113513724216542154981918683.png"],"cta":[{"type":"apply_now"}]}},"searchEngineUserId":1603}') 2019-05-29 14:02:35,011 [pool-32-thread-1] INFO jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`tpId` = '8aff422786664463b4f2a241aebcb036' 2019-05-29 14:02:35,012 [pool-32-thread-1] INFO jdbc.sqlonly - INSERT INTO `campaigns` (`searchEngineUserId`, `tpId`, `name`, `status`, `startDate`, `endDate`, `lastUpdated`, `json`) VALUES (1603, '30de3760b3154c8c978dbb5a44797161', '8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S4', 'Active', '05/29/2019 14:02:02.820', '06/29/2019 03:59:59.999', NOW(), '{"campaign":{"name":"8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S4","status":"Active","id":"30de3760b3154c8c978dbb5a44797161","customerId":"45bd0b8dd9bd43638d837334d7e7d9fb","objective":"website_clicks","budget":3138,"start":"2019-05-29T14:02:02.820Z","maxEnd":"2019-06-29T03:59:59.999Z","placement":["desktopfeed","mobilefeed","instagramstream","rightcolumn"],"details":{"audiences":[{"ageFrom":18,"ageTo":65,"gender":"females","locationTypes":["home","recent"],"demographics":{"behaviors":["6002714895372"],"interests":["6002926108721"]},"locations":[{"type":"city","id":"2427305"}]}],"copies":[{"headline":"Hotel Room in Baker FL","body":"Baker FL Spa Resort. Personable, Professional Service.","description":"Find a Vacation Resort","destinationUrl":"http://www.merchantsite.com"}],"images":["https://s3-us-west-1.amazonaws.com/aml-qa/merchants/8866c0e9-7441-4c3c-be96-7adf01a42df7/images/81f619ad-c986-4241-a70a-3f17113513724216542154981918683.png"],"cta":[{"type":"apply_now"}]}},"searchEngineUserId":1603}') 2019-05-29 14:02:35,013 [pool-32-thread-1] INFO jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`tpId` = '30de3760b3154c8c978dbb5a44797161' 2019-05-29 14:02:35,017 [pool-32-thread-1] INFO c.t.s.f.FacebookAccountDeployer - finding carryover for seuserID 1603 2019-05-29 14:02:35,019 [pool-32-thread-1] INFO jdbc.sqlonly - SELECT mc.`id`, mc.`campaignID`, mc.`date`, mc.`dedicatedCarryover`, mc.`pooledCarryover`, mc.`type` FROM `monthlyCarryovers` mc JOIN `campaigns` c ON mc.`campaignID`= c.`id` WHERE c.`searchEngineUserId` = 1603 AND mc.`type` = 'normal' AND mc.`date` = (SELECT MAX(DATE) FROM monthlyCarryovers mc1 WHERE mc1.`campaignID` = mc.`campaignID` and c.`searchEngineUserId` = c.`searchEngineUserId` AND mc1.`type` = 'normal') ORDER BY c.`id` DESC LIMIT 4 2019-05-29 14:02:35,021 [pool-32-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Found campaign carryover data for seuserID 1603, carryover data ([TPCampaignCarryoverDTO [theID=2374, theCampaignID=1025, theDate=2019-05-29, theDedicatedCarryover=0.0, thePooledCarryover=0.13, theCarryoverType=normal], TPCampaignCarryoverDTO [theID=2373, theCampaignID=1024, theDate=2019-05-29, theDedicatedCarryover=0.0, thePooledCarryover=0.13, theCarryoverType=normal], TPCampaignCarryoverDTO [theID=2372, theCampaignID=1023, theDate=2019-05-29, theDedicatedCarryover=0.0, thePooledCarryover=0.13, theCarryoverType=normal], TPCampaignCarryoverDTO [theID=2371, theCampaignID=1022, theDate=2019-05-29, theDedicatedCarryover=0.0, thePooledCarryover=0.13, theCarryoverType=normal]]) 2019-05-29 14:02:35,023 [pool-32-thread-1] INFO jdbc.sqlonly - INSERT INTO `monthlyCarryovers` (`campaignID`, `date`, `dedicatedCarryover`, `pooledCarryover`, `type`) VALUES (1025,'2019-05-29',0.0,0.13,'boosted') ON DUPLICATE KEY UPDATE `dedicatedCarryover`=VALUES(`dedicatedCarryover`), `pooledCarryover`=VALUES(`pooledCarryover`), `type`=VALUES(`type`) 2019-05-29 14:02:35,023 [pool-32-thread-1] INFO jdbc.sqlonly - SELECT `id`, `campaignID`, `date`, `dedicatedCarryover`, `pooledCarryover`, `type` FROM `monthlyCarryovers` WHERE `campaignID` = 1025 and `date` = '2019-05-29' and `type` = 'boosted' 2019-05-29 14:02:35,027 [pool-32-thread-1] INFO jdbc.sqlonly - INSERT INTO `monthlyCarryovers` (`campaignID`, `date`, `dedicatedCarryover`, `pooledCarryover`, `type`) VALUES (1024,'2019-05-29',0.0,0.13,'boosted') ON DUPLICATE KEY UPDATE `dedicatedCarryover`=VALUES(`dedicatedCarryover`), `pooledCarryover`=VALUES(`pooledCarryover`), `type`=VALUES(`type`) 2019-05-29 14:02:35,027 [pool-32-thread-1] INFO jdbc.sqlonly - SELECT `id`, `campaignID`, `date`, `dedicatedCarryover`, `pooledCarryover`, `type` FROM `monthlyCarryovers` WHERE `campaignID` = 1024 and `date` = '2019-05-29' and `type` = 'boosted' 2019-05-29 14:02:35,031 [pool-32-thread-1] INFO jdbc.sqlonly - INSERT INTO `monthlyCarryovers` (`campaignID`, `date`, `dedicatedCarryover`, `pooledCarryover`, `type`) VALUES (1023,'2019-05-29',0.0,0.13,'boosted') ON DUPLICATE KEY UPDATE `dedicatedCarryover`=VALUES(`dedicatedCarryover`), `pooledCarryover`=VALUES(`pooledCarryover`), `type`=VALUES(`type`) 2019-05-29 14:02:35,031 [pool-32-thread-1] INFO jdbc.sqlonly - SELECT `id`, `campaignID`, `date`, `dedicatedCarryover`, `pooledCarryover`, `type` FROM `monthlyCarryovers` WHERE `campaignID` = 1023 and `date` = '2019-05-29' and `type` = 'boosted' 2019-05-29 14:02:35,036 [pool-32-thread-1] INFO jdbc.sqlonly - INSERT INTO `monthlyCarryovers` (`campaignID`, `date`, `dedicatedCarryover`, `pooledCarryover`, `type`) VALUES (1022,'2019-05-29',0.0,0.13,'boosted') ON DUPLICATE KEY UPDATE `dedicatedCarryover`=VALUES(`dedicatedCarryover`), `pooledCarryover`=VALUES(`pooledCarryover`), `type`=VALUES(`type`) 2019-05-29 14:02:35,038 [pool-32-thread-1] INFO jdbc.sqlonly - SELECT `id`, `campaignID`, `date`, `dedicatedCarryover`, `pooledCarryover`, `type` FROM `monthlyCarryovers` WHERE `campaignID` = 1022 and `date` = '2019-05-29' and `type` = 'boosted' 2019-05-29 14:02:35,039 [pool-32-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Created Facebook campaign structure for accountID 794 2019-05-29 14:02:35.039 (3) [pool-32-thread-1]: Completed Facebook Create Campaign Worker.. 2019-05-29 14:02:35.046 (3) [pool-3-thread-10]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2019-05-29 14:02:35,063 [pool-3-thread-10] INFO jdbc.sqlonly - SELECT `errors`.`errorJson` FROM `campaigns` JOIN `errors` ON `errors`.`elementName` = `campaigns`.`name` WHERE `campaigns`.`id` IN (1026) 2019-05-29 14:02:35.065 (3) [pool-3-thread-10]: Ignoring: 1 CampaignStatus errors 2019-05-29 14:02:35.065 (3) [pool-3-thread-10]: 10861_S1 has no applicable GCE errors. 2019-05-29 14:02:35,067 [pool-3-thread-10] INFO jdbc.sqlonly - SELECT `errors`.`errorJson` FROM `campaigns` JOIN `errors` ON `errors`.`elementName` = `campaigns`.`name` WHERE `campaigns`.`id` IN (1027) 2019-05-29 14:02:35.069 (3) [pool-3-thread-10]: Ignoring: 1 CampaignStatus errors 2019-05-29 14:02:35.069 (3) [pool-3-thread-10]: 10861_S2 has no applicable GCE errors. 2019-05-29 14:02:35,071 [pool-3-thread-10] INFO jdbc.sqlonly - SELECT `errors`.`errorJson` FROM `campaigns` JOIN `errors` ON `errors`.`elementName` = `campaigns`.`name` WHERE `campaigns`.`id` IN (1028) 2019-05-29 14:02:35.073 (3) [pool-3-thread-10]: Ignoring: 1 CampaignStatus errors 2019-05-29 14:02:35.073 (3) [pool-3-thread-10]: 10861_S3 has no applicable GCE errors. 2019-05-29 14:02:35,075 [pool-3-thread-10] INFO jdbc.sqlonly - SELECT `errors`.`errorJson` FROM `campaigns` JOIN `errors` ON `errors`.`elementName` = `campaigns`.`name` WHERE `campaigns`.`id` IN (1029) 2019-05-29 14:02:35.077 (3) [pool-3-thread-10]: Ignoring: 1 CampaignStatus errors 2019-05-29 14:02:35.077 (3) [pool-3-thread-10]: 10861_S4 has no applicable GCE errors. 2019-05-29 14:02:35.078 (3) [pool-3-thread-10]: Finished DEPLOY request for campaign 8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S1: SUCCEEDED (merchant: 8866c0e9-7441-4c3c-be96-7adf01a42df7) 2019-05-29 14:02:35.078 (3) [pool-3-thread-10]: Finished DEPLOY request for campaign 8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S2: SUCCEEDED (merchant: 8866c0e9-7441-4c3c-be96-7adf01a42df7) 2019-05-29 14:02:35.079 (3) [pool-3-thread-10]: Finished DEPLOY request for campaign 8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S3: SUCCEEDED (merchant: 8866c0e9-7441-4c3c-be96-7adf01a42df7) 2019-05-29 14:02:35.079 (3) [pool-3-thread-10]: Finished DEPLOY request for campaign 8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S4: SUCCEEDED (merchant: 8866c0e9-7441-4c3c-be96-7adf01a42df7) 2019-05-29 14:02:35.079 (3) [pool-3-thread-10]: 8866c0e9-7441-4c3c-be96-7adf01a42df7 has 4 campaigns for a SE Update accounts sync. 2019-05-29 14:02:35.079 (3) [pool-3-thread-10]: 8866c0e9-7441-4c3c-be96-7adf01a42df7 has 4 campaigns for a SE Update groups-listings sync. 2019-05-29 14:02:40.080 (3) [pool-3-thread-10]: JobExecutor running job [2019-05-29_140235_a794_AccountWorkerProcessResults_syncAccountsGroupsListings_GZCD1VD47Q]: [/usr/local/tsa/bidmgr/seupdate.sh, , -d, 3, --inactive, --accountid, 794, --accounts, --seaccount, 6069,6070,6071,6072, --groups, --listings] 2019-05-29 14:02:43.895 (3) [pool-3-thread-10]: JobExecutor finished running job [2019-05-29_140235_a794_AccountWorkerProcessResults_syncAccountsGroupsListings_GZCD1VD47Q], exit code=0 in 3.814s 2019-05-29 14:02:43.895 (3) [pool-3-thread-10]: JobExecutor finished 2019-05-29_140235_a794_AccountWorkerProcessResults_syncAccountsGroupsListings_GZCD1VD47Q. hasError=false, numTries=1 2019-05-29 14:02:43.895 (3) [pool-3-thread-10]: Finished sub-campaign processing for DEPLOY deploymentID (7a820b40-933a-4714-9d33-8f6a8371f35e). account 8866c0e9-7441-4c3c-be96-7adf01a42df7. 4 submitted, 4 ok. 2019-05-29 14:02:43.896 (3) [pool-3-thread-10]: Updating deployment status to 'Success' for campaignID: 10861 2019-05-29 14:02:43.896 (3) [pool-3-thread-10]: Finished DEPLOY request for 8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861: SUCCEEDED (merchant: 8866c0e9-7441-4c3c-be96-7adf01a42df7) 2019-05-29 14:02:43.897 (3) [pool-3-thread-10]: Finished DEPLOY request, deploymentID (7a820b40-933a-4714-9d33-8f6a8371f35e), account 8866c0e9-7441-4c3c-be96-7adf01a42df7 2019-05-29 14:02:43.897 (3) [pool-3-thread-10]: Request removed from map for customerID 8866c0e9-7441-4c3c-be96-7adf01a42df7 2019-05-29 14:02:43.921 (3) [pool-3-thread-10]: Initial campaign deployment for customerID: 8866c0e9-7441-4c3c-be96-7adf01a42df7 2019-05-29 14:02:44.675 (3) [AdMaxListener]: Sent message to response queue. 2019-05-29 14:03:08.459 (3) [Thread-9]: Heartbeat #823 (1559138588456) received in 0.003s 2019-05-29 14:03:32.034 (3) [Thread-9]: Request added to map for customerID 8866c0e9-7441-4c3c-be96-7adf01a42df7 2019-05-29 14:03:32.034 (3) [Thread-9]: HighPriorityMessageHandler handling message ID ID:JBM-08bbaa9c-8406-4a49-b6b0-b86ed29a99c6 2019-05-29 14:03:32.034 (3) [Thread-9]: Request worker created for 8866c0e9-7441-4c3c-be96-7adf01a42df7 2019-05-29 14:03:32.034 (3) [Thread-9]: Submitted executor job for 8866c0e9-7441-4c3c-be96-7adf01a42df7 2019-05-29 14:03:32.036 (3) [Thread-9]: HighPriorityMessageHandler took message ID ID:JBM-08bbaa9c-8406-4a49-b6b0-b86ed29a99c6 out of queue 2019-05-29 14:03:32.055 (3) [pool-3-thread-10]: Updating deployment status to 'InProgress' for campaignID: 10861 2019-05-29 14:03:32,061 [pool-3-thread-10] DEBUG c.t.common.SECampaignStatusManager - AdMax campaign budget status not found so using Active 2019-05-29 14:03:32,065 [pool-3-thread-10] DEBUG c.t.common.SECampaignStatusManager - AdMax campaign budget status not found so using Active 2019-05-29 14:03:32,070 [pool-3-thread-10] DEBUG c.t.common.SECampaignStatusManager - AdMax campaign budget status not found so using Active 2019-05-29 14:03:32,074 [pool-3-thread-10] DEBUG c.t.common.SECampaignStatusManager - AdMax campaign budget status not found so using Active 2019-05-29 14:03:32.075 (3) [pool-3-thread-10]: Start processing UPDATE request (7a820b40-933a-4714-9d33-8f6a8371f35e) for account 8866c0e9-7441-4c3c-be96-7adf01a42df7. 4 campaign(s). 2019-05-29 14:03:32.075 (3) [pool-3-thread-10]: Performing update for account: 8866c0e9-7441-4c3c-be96-7adf01a42df7 ID#794 2019-05-29 14:03:32.081 (3) [pool-3-thread-10]: 4 campaign(s) to update. 2019-05-29 14:03:32.082 (3) [pool-3-thread-10]: 0 campaign(s) to retry and update. 2019-05-29 14:03:32.082 (3) [pool-3-thread-10]: Update campaign status for accountID 794 2019-05-29 14:03:32.083 (3) [pool-3-thread-10]: CampaignWorker initialized for account: 794 2019-05-29 14:03:32.083 (3) [pool-3-thread-10]: Updating 8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S1 Status: Active 2019-05-29 14:03:32.083 (3) [pool-3-thread-10]: Updating 8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S2 Status: Active 2019-05-29 14:03:32.083 (3) [pool-3-thread-10]: Updating 8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S3 Status: Active 2019-05-29 14:03:32.083 (3) [pool-3-thread-10]: Updating 8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S4 Status: Active 2019-05-29 14:03:32.083 (3) [pool-3-thread-10]: CampaignUpdateWorker started... 2019-05-29 14:03:32,160 [pool-3-thread-10] DEBUG c.t.s.facebook.FacebookApiUtils - Getting FB properties using distribution service 2019-05-29 14:03:32,161 [pool-3-thread-10] DEBUG c.t.s.f.FacebookAccountDeployer - Facebook currencyCode USD for accountID 794 2019-05-29 14:03:32,162 [pool-3-thread-10] DEBUG c.t.s.f.FacebookAccountDeployer - Facebook timeZoneID America/New_York for accountID 794 2019-05-29 14:03:32,162 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - FacebookAccountDeployer:getExistingCampaigns 2019-05-29 14:03:32,164 [pool-3-thread-10] INFO jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`id` IN (1026,1027,1028,1029) 2019-05-29 14:03:32,166 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - calculating carryover for seuserID 1603 2019-05-29 14:03:32,167 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - Fetching performance data for seuserID 1603 and campaign SEIdentifiers [0987e04f4bdd425da974011b45cbb076, 95c171ba95d24c17b61cf6ba7d285eb4, 8aff422786664463b4f2a241aebcb036, 30de3760b3154c8c978dbb5a44797161] 2019-05-29 14:03:32,170 [pool-3-thread-10] INFO jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`tpId` = '0987e04f4bdd425da974011b45cbb076' 2019-05-29 14:03:37,171 [pool-3-thread-10] INFO c.t.s.c.t.i.s.CampaignServiceClient - Getting TP campaign [0987e04f4bdd425da974011b45cbb076] details for account 45bd0b8dd9bd43638d837334d7e7d9fb 2019-05-29 14:03:37,174 [pool-3-thread-10] INFO o.a.c.i.LoggingOutInterceptor - Outbound Message --------------------------- ID: 229 Address: https://api.tigerpistol.com/v1/campaigns/0987e04f4bdd425da974011b45cbb076 Http-Method: GET Content-Type: application/json Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token A5CO5g2RJFRI4w5mWJ32bkCAwQ6mMWo9bHPUWqIC]} -------------------------------------- 2019-05-29 14:03:37,581 [pool-3-thread-10] INFO o.a.c.i.LoggingInInterceptor - Inbound Message ---------------------------- ID: 229 Response-Code: 200 Encoding: UTF-8 Content-Type: application/json; charset=utf-8 Headers: {api-supported-versions=[1.0], Content-Length=[713], content-type=[application/json; charset=utf-8], Date=[Wed, 29 May 2019 14:03:37 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]} Payload: {"variations":[{"index":0,"reviewError":null}],"displayMargin":1.0,"hasError":true,"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,"id":"0987e04f4bdd425da974011b45cbb076","customerId":"45bd0b8dd9bd43638d837334d7e7d9fb","name":"8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S1","start":"2019-05-29T14:02:00+00:00","end":"2019-06-29T03:59:00+00:00","budget":3138.00,"objective":"website_clicks","status":"error","publishPhase":"error","errorMessage":"Please add a valid payment method to your ad account."} -------------------------------------- 2019-05-29 14:03:37,582 [pool-3-thread-10] INFO jdbc.sqlonly - INSERT INTO `performance` (`campaignID`, `date`, `status`, `spend`, `clicks`, `impressions`, `budget`, `startDate`, `endDate`, `lastUpdated`) VALUES (1026,'2019-05-29','error',0.0,0,0,3138,'05/29/2019 14:02:00.000','06/29/2019 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`) 2019-05-29 14:03:37,583 [pool-3-thread-10] 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` = 1026 and `performance`.`date` = '2019-05-29' 2019-05-29 14:03:37,584 [pool-3-thread-10] INFO jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`tpId` = '95c171ba95d24c17b61cf6ba7d285eb4' 2019-05-29 14:03:42,585 [pool-3-thread-10] INFO c.t.s.c.t.i.s.CampaignServiceClient - Getting TP campaign [95c171ba95d24c17b61cf6ba7d285eb4] details for account 45bd0b8dd9bd43638d837334d7e7d9fb 2019-05-29 14:03:42,589 [pool-3-thread-10] INFO o.a.c.i.LoggingOutInterceptor - Outbound Message --------------------------- ID: 230 Address: https://api.tigerpistol.com/v1/campaigns/95c171ba95d24c17b61cf6ba7d285eb4 Http-Method: GET Content-Type: application/json Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token A5CO5g2RJFRI4w5mWJ32bkCAwQ6mMWo9bHPUWqIC]} -------------------------------------- 2019-05-29 14:03:42,935 [pool-3-thread-10] INFO o.a.c.i.LoggingInInterceptor - Inbound Message ---------------------------- ID: 230 Response-Code: 200 Encoding: UTF-8 Content-Type: application/json; charset=utf-8 Headers: {api-supported-versions=[1.0], Content-Length=[713], content-type=[application/json; charset=utf-8], Date=[Wed, 29 May 2019 14:03:42 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]} Payload: {"variations":[{"index":0,"reviewError":null}],"displayMargin":1.0,"hasError":true,"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,"id":"95c171ba95d24c17b61cf6ba7d285eb4","customerId":"45bd0b8dd9bd43638d837334d7e7d9fb","name":"8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S2","start":"2019-05-29T14:02:00+00:00","end":"2019-06-29T03:59:00+00:00","budget":3138.00,"objective":"website_clicks","status":"error","publishPhase":"error","errorMessage":"Please add a valid payment method to your ad account."} -------------------------------------- 2019-05-29 14:03:42,937 [pool-3-thread-10] INFO jdbc.sqlonly - INSERT INTO `performance` (`campaignID`, `date`, `status`, `spend`, `clicks`, `impressions`, `budget`, `startDate`, `endDate`, `lastUpdated`) VALUES (1027,'2019-05-29','error',0.0,0,0,3138,'05/29/2019 14:02:00.000','06/29/2019 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`) 2019-05-29 14:03:42,938 [pool-3-thread-10] 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` = 1027 and `performance`.`date` = '2019-05-29' 2019-05-29 14:03:42,939 [pool-3-thread-10] INFO jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`tpId` = '8aff422786664463b4f2a241aebcb036' 2019-05-29 14:03:47,940 [pool-3-thread-10] INFO c.t.s.c.t.i.s.CampaignServiceClient - Getting TP campaign [8aff422786664463b4f2a241aebcb036] details for account 45bd0b8dd9bd43638d837334d7e7d9fb 2019-05-29 14:03:47,943 [pool-3-thread-10] INFO o.a.c.i.LoggingOutInterceptor - Outbound Message --------------------------- ID: 231 Address: https://api.tigerpistol.com/v1/campaigns/8aff422786664463b4f2a241aebcb036 Http-Method: GET Content-Type: application/json Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token A5CO5g2RJFRI4w5mWJ32bkCAwQ6mMWo9bHPUWqIC]} -------------------------------------- 2019-05-29 14:03:48,260 [pool-3-thread-10] INFO o.a.c.i.LoggingInInterceptor - Inbound Message ---------------------------- ID: 231 Response-Code: 200 Encoding: UTF-8 Content-Type: application/json; charset=utf-8 Headers: {api-supported-versions=[1.0], Content-Length=[713], content-type=[application/json; charset=utf-8], Date=[Wed, 29 May 2019 14:03:48 GMT], 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}],"displayMargin":1.0,"hasError":true,"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,"id":"8aff422786664463b4f2a241aebcb036","customerId":"45bd0b8dd9bd43638d837334d7e7d9fb","name":"8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S3","start":"2019-05-29T14:02:00+00:00","end":"2019-06-29T03:59:00+00:00","budget":3138.00,"objective":"website_clicks","status":"error","publishPhase":"error","errorMessage":"Please add a valid payment method to your ad account."} -------------------------------------- 2019-05-29 14:03:48,262 [pool-3-thread-10] INFO jdbc.sqlonly - INSERT INTO `performance` (`campaignID`, `date`, `status`, `spend`, `clicks`, `impressions`, `budget`, `startDate`, `endDate`, `lastUpdated`) VALUES (1028,'2019-05-29','error',0.0,0,0,3138,'05/29/2019 14:02:00.000','06/29/2019 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`) 2019-05-29 14:03:48,263 [pool-3-thread-10] 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` = 1028 and `performance`.`date` = '2019-05-29' 2019-05-29 14:03:48,264 [pool-3-thread-10] INFO jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`tpId` = '30de3760b3154c8c978dbb5a44797161' 2019-05-29 14:03:53,264 [pool-3-thread-10] INFO c.t.s.c.t.i.s.CampaignServiceClient - Getting TP campaign [30de3760b3154c8c978dbb5a44797161] details for account 45bd0b8dd9bd43638d837334d7e7d9fb 2019-05-29 14:03:53,268 [pool-3-thread-10] INFO o.a.c.i.LoggingOutInterceptor - Outbound Message --------------------------- ID: 232 Address: https://api.tigerpistol.com/v1/campaigns/30de3760b3154c8c978dbb5a44797161 Http-Method: GET Content-Type: application/json Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token A5CO5g2RJFRI4w5mWJ32bkCAwQ6mMWo9bHPUWqIC]} -------------------------------------- 2019-05-29 14:03:53,589 [pool-3-thread-10] INFO o.a.c.i.LoggingInInterceptor - Inbound Message ---------------------------- ID: 232 Response-Code: 200 Encoding: UTF-8 Content-Type: application/json; charset=utf-8 Headers: {api-supported-versions=[1.0], Content-Length=[713], content-type=[application/json; charset=utf-8], Date=[Wed, 29 May 2019 14:03:52 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]} Payload: {"variations":[{"index":0,"reviewError":null}],"displayMargin":1.0,"hasError":true,"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,"id":"30de3760b3154c8c978dbb5a44797161","customerId":"45bd0b8dd9bd43638d837334d7e7d9fb","name":"8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S4","start":"2019-05-29T14:02:00+00:00","end":"2019-06-29T03:59:00+00:00","budget":3138.00,"objective":"website_clicks","status":"error","publishPhase":"error","errorMessage":"Please add a valid payment method to your ad account."} -------------------------------------- 2019-05-29 14:03:53,591 [pool-3-thread-10] INFO jdbc.sqlonly - INSERT INTO `performance` (`campaignID`, `date`, `status`, `spend`, `clicks`, `impressions`, `budget`, `startDate`, `endDate`, `lastUpdated`) VALUES (1029,'2019-05-29','error',0.0,0,0,3138,'05/29/2019 14:02:00.000','06/29/2019 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`) 2019-05-29 14:03:53,592 [pool-3-thread-10] 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` = 1029 and `performance`.`date` = '2019-05-29' 2019-05-29 14:03:53,594 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - Sucessfully fetched facebook campaign performance data for seuserID 1603, perf data ([TPCampaignPerformanceDTO [theID=1998, theCampaignID=1026, theDate=2019-05-29, theStatus=error, theSpend=0.0, theClicks=0, theImpressions=0, theBudget=3138, theStartDate=2019-05-29T14:02:00.000Z, theEndDate=2019-06-29T03:59:00.000Z, theLastUpdated=2019-05-29T14:03:37.000Z], TPCampaignPerformanceDTO [theID=1999, theCampaignID=1027, theDate=2019-05-29, theStatus=error, theSpend=0.0, theClicks=0, theImpressions=0, theBudget=3138, theStartDate=2019-05-29T14:02:00.000Z, theEndDate=2019-06-29T03:59:00.000Z, theLastUpdated=2019-05-29T14:03:42.000Z], TPCampaignPerformanceDTO [theID=2000, theCampaignID=1028, theDate=2019-05-29, theStatus=error, theSpend=0.0, theClicks=0, theImpressions=0, theBudget=3138, theStartDate=2019-05-29T14:02:00.000Z, theEndDate=2019-06-29T03:59:00.000Z, theLastUpdated=2019-05-29T14:03:48.000Z], TPCampaignPerformanceDTO [theID=2001, theCampaignID=1029, theDate=2019-05-29, theStatus=error, theSpend=0.0, theClicks=0, theImpressions=0, theBudget=3138, theStartDate=2019-05-29T14:02:00.000Z, theEndDate=2019-06-29T03:59:00.000Z, theLastUpdated=2019-05-29T14:03:53.000Z]]) 2019-05-29 14:03:53,594 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - =========== Processing carryover for campaignID 1026 [seuserID 1603] =========== 2019-05-29 14:03:53,594 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - actual_monthly_budget for campaignID 1026 : 31.38 USD 2019-05-29 14:03:53,594 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - actual_spend for campaignID 1026 : 0.0 USD 2019-05-29 14:03:53,594 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - campaign start date 2019-05-29T10:02:00.000-04:00 America/New_York, end date 2019-06-28T23:59:00.000-04:00 America/New_York, days 31.0, current date 2019-05-29T10:03:53.594-04:00 America/New_York for campaignID 1026 2019-05-29 14:03:53,594 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - campaignID 1026 active for 0 days (num_of_days_active) and 0 hours (num_of_hours_active) 2019-05-29 14:03:53,594 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - daily_budget [actual_monthly_budget / 31.0] for campaignID 1026 : 1.012258 2019-05-29 14:03:53,594 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - hourly_budget [daily_budget / 24] for campaignID 1026 : 0.04217742 2019-05-29 14:03:53,594 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - expected_daily_spend [daily_budget * num_of_days_active] for campaignID 1026 : 0.0 2019-05-29 14:03:53,594 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - expected_hourly_spend [hourly_budget * num_of_hours_active] for campaignID 1026 : 0.0 2019-05-29 14:03:53,594 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - expected_spend [expected_daily_spend + expected_hourly_spend] for campaignID 1026 : 0.0 2019-05-29 14:03:53,594 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - dedicatedCarryover [expected_spend - actual_spend] for campaignID 1026 : 0.0 2019-05-29 14:03:53,594 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - =========== Processing carryover for campaignID 1027 [seuserID 1603] =========== 2019-05-29 14:03:53,594 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - actual_monthly_budget for campaignID 1027 : 31.38 USD 2019-05-29 14:03:53,594 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - actual_spend for campaignID 1027 : 0.0 USD 2019-05-29 14:03:53,594 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - campaign start date 2019-05-29T10:02:00.000-04:00 America/New_York, end date 2019-06-28T23:59:00.000-04:00 America/New_York, days 31.0, current date 2019-05-29T10:03:53.594-04:00 America/New_York for campaignID 1027 2019-05-29 14:03:53,595 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - campaignID 1027 active for 0 days (num_of_days_active) and 0 hours (num_of_hours_active) 2019-05-29 14:03:53,595 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - daily_budget [actual_monthly_budget / 31.0] for campaignID 1027 : 1.012258 2019-05-29 14:03:53,595 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - hourly_budget [daily_budget / 24] for campaignID 1027 : 0.04217742 2019-05-29 14:03:53,595 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - expected_daily_spend [daily_budget * num_of_days_active] for campaignID 1027 : 0.0 2019-05-29 14:03:53,595 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - expected_hourly_spend [hourly_budget * num_of_hours_active] for campaignID 1027 : 0.0 2019-05-29 14:03:53,595 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - expected_spend [expected_daily_spend + expected_hourly_spend] for campaignID 1027 : 0.0 2019-05-29 14:03:53,595 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - dedicatedCarryover [expected_spend - actual_spend] for campaignID 1027 : 0.0 2019-05-29 14:03:53,595 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - =========== Processing carryover for campaignID 1028 [seuserID 1603] =========== 2019-05-29 14:03:53,595 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - actual_monthly_budget for campaignID 1028 : 31.38 USD 2019-05-29 14:03:53,595 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - actual_spend for campaignID 1028 : 0.0 USD 2019-05-29 14:03:53,595 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - campaign start date 2019-05-29T10:02:00.000-04:00 America/New_York, end date 2019-06-28T23:59:00.000-04:00 America/New_York, days 31.0, current date 2019-05-29T10:03:53.595-04:00 America/New_York for campaignID 1028 2019-05-29 14:03:53,595 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - campaignID 1028 active for 0 days (num_of_days_active) and 0 hours (num_of_hours_active) 2019-05-29 14:03:53,595 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - daily_budget [actual_monthly_budget / 31.0] for campaignID 1028 : 1.012258 2019-05-29 14:03:53,595 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - hourly_budget [daily_budget / 24] for campaignID 1028 : 0.04217742 2019-05-29 14:03:53,595 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - expected_daily_spend [daily_budget * num_of_days_active] for campaignID 1028 : 0.0 2019-05-29 14:03:53,595 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - expected_hourly_spend [hourly_budget * num_of_hours_active] for campaignID 1028 : 0.0 2019-05-29 14:03:53,595 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - expected_spend [expected_daily_spend + expected_hourly_spend] for campaignID 1028 : 0.0 2019-05-29 14:03:53,595 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - dedicatedCarryover [expected_spend - actual_spend] for campaignID 1028 : 0.0 2019-05-29 14:03:53,595 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - =========== Processing carryover for campaignID 1029 [seuserID 1603] =========== 2019-05-29 14:03:53,595 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - actual_monthly_budget for campaignID 1029 : 31.38 USD 2019-05-29 14:03:53,595 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - actual_spend for campaignID 1029 : 0.0 USD 2019-05-29 14:03:53,595 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - campaign start date 2019-05-29T10:02:00.000-04:00 America/New_York, end date 2019-06-28T23:59:00.000-04:00 America/New_York, days 31.0, current date 2019-05-29T10:03:53.595-04:00 America/New_York for campaignID 1029 2019-05-29 14:03:53,595 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - campaignID 1029 active for 0 days (num_of_days_active) and 0 hours (num_of_hours_active) 2019-05-29 14:03:53,595 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - daily_budget [actual_monthly_budget / 31.0] for campaignID 1029 : 1.012258 2019-05-29 14:03:53,595 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - hourly_budget [daily_budget / 24] for campaignID 1029 : 0.04217742 2019-05-29 14:03:53,595 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - expected_daily_spend [daily_budget * num_of_days_active] for campaignID 1029 : 0.0 2019-05-29 14:03:53,595 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - expected_hourly_spend [hourly_budget * num_of_hours_active] for campaignID 1029 : 0.0 2019-05-29 14:03:53,595 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - expected_spend [expected_daily_spend + expected_hourly_spend] for campaignID 1029 : 0.0 2019-05-29 14:03:53,595 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - dedicatedCarryover [expected_spend - actual_spend] for campaignID 1029 : 0.0 2019-05-29 14:03:53,597 [pool-3-thread-10] INFO jdbc.sqlonly - SELECT mc.`id`, mc.`campaignID`, mc.`date`, mc.`dedicatedCarryover`, mc.`pooledCarryover`, mc.`type` FROM `monthlyCarryovers` mc JOIN `campaigns` c ON mc.`campaignID` = c.`id` WHERE c.`searchEngineUserId` = 1603 AND mc.`type` = 'boosted' AND mc.`date` = (SELECT MAX(DATE) FROM monthlyCarryovers mc1 WHERE mc1.`campaignID` = mc.`campaignID` and c.`searchEngineUserId` = c.`searchEngineUserId` AND mc1.`type` = 'boosted') ORDER BY c.`id` DESC LIMIT 4 2019-05-29 14:03:53,599 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - Found campaign carryover data for seuserID 1603, boosted carryover data ([TPCampaignCarryoverDTO [theID=2374, theCampaignID=1025, theDate=2019-05-29, theDedicatedCarryover=0.0, thePooledCarryover=0.13, theCarryoverType=boosted], TPCampaignCarryoverDTO [theID=2373, theCampaignID=1024, theDate=2019-05-29, theDedicatedCarryover=0.0, thePooledCarryover=0.13, theCarryoverType=boosted], TPCampaignCarryoverDTO [theID=2372, theCampaignID=1023, theDate=2019-05-29, theDedicatedCarryover=0.0, thePooledCarryover=0.13, theCarryoverType=boosted], TPCampaignCarryoverDTO [theID=2371, theCampaignID=1022, theDate=2019-05-29, theDedicatedCarryover=0.0, thePooledCarryover=0.13, theCarryoverType=boosted]]) 2019-05-29 14:03:53,601 [pool-3-thread-10] INFO jdbc.sqlonly - SELECT `id`, `searchEngineUserId`, `date`, `carryoverAdjustment`, `type` FROM `monthlyCarryoverAdjustments` WHERE `searchEngineUserId` = 1603 and `date` = '2019-05-29' and `type` = 'normal' 2019-05-29 14:03:53,602 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - Total boostedCarryover for seuserID 1603 and date 2019-05-29 is 0.52 2019-05-29 14:03:53,602 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - Total carryover Adjustment for seuserID 1603 and date 2019-05-29 is 0.0 2019-05-29 14:03:53,602 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - Total pooledCarryOver [(totalPooledCarryover + totalBoostedCarryover) - carryoverAdjustment] for seuserID 1603 and date 2019-05-29 is 0.52 2019-05-29 14:03:53,602 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - saving carryover TPCampaignCarryoverDTO [theID=null, theCampaignID=1026, theDate=2019-05-29, theDedicatedCarryover=0.0, thePooledCarryover=0.13, theCarryoverType=normal] for campaignID 1026 2019-05-29 14:03:53,604 [pool-3-thread-10] INFO jdbc.sqlonly - INSERT INTO `monthlyCarryovers` (`campaignID`, `date`, `dedicatedCarryover`, `pooledCarryover`, `type`) VALUES (1026,'2019-05-29',0.0,0.13,'normal') ON DUPLICATE KEY UPDATE `dedicatedCarryover`=VALUES(`dedicatedCarryover`), `pooledCarryover`=VALUES(`pooledCarryover`), `type`=VALUES(`type`) 2019-05-29 14:03:53,605 [pool-3-thread-10] INFO jdbc.sqlonly - SELECT `id`, `campaignID`, `date`, `dedicatedCarryover`, `pooledCarryover`, `type` FROM `monthlyCarryovers` WHERE `campaignID` = 1026 and `date` = '2019-05-29' and `type` = 'normal' 2019-05-29 14:03:53,606 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - saving carryover TPCampaignCarryoverDTO [theID=null, theCampaignID=1027, theDate=2019-05-29, theDedicatedCarryover=0.0, thePooledCarryover=0.13, theCarryoverType=normal] for campaignID 1027 2019-05-29 14:03:53,608 [pool-3-thread-10] INFO jdbc.sqlonly - INSERT INTO `monthlyCarryovers` (`campaignID`, `date`, `dedicatedCarryover`, `pooledCarryover`, `type`) VALUES (1027,'2019-05-29',0.0,0.13,'normal') ON DUPLICATE KEY UPDATE `dedicatedCarryover`=VALUES(`dedicatedCarryover`), `pooledCarryover`=VALUES(`pooledCarryover`), `type`=VALUES(`type`) 2019-05-29 14:03:53,609 [pool-3-thread-10] INFO jdbc.sqlonly - SELECT `id`, `campaignID`, `date`, `dedicatedCarryover`, `pooledCarryover`, `type` FROM `monthlyCarryovers` WHERE `campaignID` = 1027 and `date` = '2019-05-29' and `type` = 'normal' 2019-05-29 14:03:53,610 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - saving carryover TPCampaignCarryoverDTO [theID=null, theCampaignID=1028, theDate=2019-05-29, theDedicatedCarryover=0.0, thePooledCarryover=0.13, theCarryoverType=normal] for campaignID 1028 2019-05-29 14:03:53,612 [pool-3-thread-10] INFO jdbc.sqlonly - INSERT INTO `monthlyCarryovers` (`campaignID`, `date`, `dedicatedCarryover`, `pooledCarryover`, `type`) VALUES (1028,'2019-05-29',0.0,0.13,'normal') ON DUPLICATE KEY UPDATE `dedicatedCarryover`=VALUES(`dedicatedCarryover`), `pooledCarryover`=VALUES(`pooledCarryover`), `type`=VALUES(`type`) 2019-05-29 14:03:53,613 [pool-3-thread-10] INFO jdbc.sqlonly - SELECT `id`, `campaignID`, `date`, `dedicatedCarryover`, `pooledCarryover`, `type` FROM `monthlyCarryovers` WHERE `campaignID` = 1028 and `date` = '2019-05-29' and `type` = 'normal' 2019-05-29 14:03:53,615 [pool-3-thread-10] INFO c.t.s.f.FacebookAccountDeployer - saving carryover TPCampaignCarryoverDTO [theID=null, theCampaignID=1029, theDate=2019-05-29, theDedicatedCarryover=0.0, thePooledCarryover=0.13, theCarryoverType=normal] for campaignID 1029 2019-05-29 14:03:53,616 [pool-3-thread-10] INFO jdbc.sqlonly - INSERT INTO `monthlyCarryovers` (`campaignID`, `date`, `dedicatedCarryover`, `pooledCarryover`, `type`) VALUES (1029,'2019-05-29',0.0,0.13,'normal') ON DUPLICATE KEY UPDATE `dedicatedCarryover`=VALUES(`dedicatedCarryover`), `pooledCarryover`=VALUES(`pooledCarryover`), `type`=VALUES(`type`) 2019-05-29 14:03:53,617 [pool-3-thread-10] INFO jdbc.sqlonly - SELECT `id`, `campaignID`, `date`, `dedicatedCarryover`, `pooledCarryover`, `type` FROM `monthlyCarryovers` WHERE `campaignID` = 1029 and `date` = '2019-05-29' and `type` = 'normal' 2019-05-29 14:03:53.619 (3) [pool-3-thread-10]: 8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S1 is already set to Active in the database. 2019-05-29 14:03:53.619 (3) [pool-3-thread-10]: 8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S2 is already set to Active in the database. 2019-05-29 14:03:53.619 (3) [pool-3-thread-10]: 8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S3 is already set to Active in the database. 2019-05-29 14:03:53.619 (3) [pool-3-thread-10]: 8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S4 is already set to Active in the database. 2019-05-29 14:03:53.619 (3) [pool-33-thread-1]: Starting Facebook Update Campaign Worker.. 2019-05-29 14:03:53.619 (3) [pool-33-thread-1]: Completed Facebook Update Campaign Worker.. 2019-05-29 14:03:53.621 (3) [pool-3-thread-10]: Campaign structure sync not enabled for this request. 2019-05-29 14:03:53,623 [pool-3-thread-10] INFO jdbc.sqlonly - SELECT `errors`.`errorJson` FROM `campaigns` JOIN `errors` ON `errors`.`elementName` = `campaigns`.`name` WHERE `campaigns`.`id` IN (1026) 2019-05-29 14:03:53.625 (3) [pool-3-thread-10]: Structure sync disabled, ignoring 1 structure operation errors. 2019-05-29 14:03:53.625 (3) [pool-3-thread-10]: 10861_S1 has no applicable GCE errors. 2019-05-29 14:03:53,647 [pool-3-thread-10] INFO jdbc.sqlonly - SELECT `errors`.`errorJson` FROM `campaigns` JOIN `errors` ON `errors`.`elementName` = `campaigns`.`name` WHERE `campaigns`.`id` IN (1027) 2019-05-29 14:03:53.653 (3) [pool-3-thread-10]: Structure sync disabled, ignoring 1 structure operation errors. 2019-05-29 14:03:53.653 (3) [pool-3-thread-10]: 10861_S2 has no applicable GCE errors. 2019-05-29 14:03:53,656 [pool-3-thread-10] INFO jdbc.sqlonly - SELECT `errors`.`errorJson` FROM `campaigns` JOIN `errors` ON `errors`.`elementName` = `campaigns`.`name` WHERE `campaigns`.`id` IN (1028) 2019-05-29 14:03:53.658 (3) [pool-3-thread-10]: Structure sync disabled, ignoring 1 structure operation errors. 2019-05-29 14:03:53.658 (3) [pool-3-thread-10]: 10861_S3 has no applicable GCE errors. 2019-05-29 14:03:53,660 [pool-3-thread-10] INFO jdbc.sqlonly - SELECT `errors`.`errorJson` FROM `campaigns` JOIN `errors` ON `errors`.`elementName` = `campaigns`.`name` WHERE `campaigns`.`id` IN (1029) 2019-05-29 14:03:53.662 (3) [pool-3-thread-10]: Structure sync disabled, ignoring 1 structure operation errors. 2019-05-29 14:03:53.662 (3) [pool-3-thread-10]: 10861_S4 has no applicable GCE errors. 2019-05-29 14:03:53.663 (3) [pool-3-thread-10]: Finished UPDATE request for campaign 8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S1: SUCCEEDED (merchant: 8866c0e9-7441-4c3c-be96-7adf01a42df7) 2019-05-29 14:03:53.663 (3) [pool-3-thread-10]: Finished UPDATE request for campaign 8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S2: SUCCEEDED (merchant: 8866c0e9-7441-4c3c-be96-7adf01a42df7) 2019-05-29 14:03:53.664 (3) [pool-3-thread-10]: Finished UPDATE request for campaign 8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S3: SUCCEEDED (merchant: 8866c0e9-7441-4c3c-be96-7adf01a42df7) 2019-05-29 14:03:53.664 (3) [pool-3-thread-10]: Finished UPDATE request for campaign 8866c0e9-7441-4c3c-be96-7adf01a42df7_10001_4189_10861_S4: SUCCEEDED (merchant: 8866c0e9-7441-4c3c-be96-7adf01a42df7) 2019-05-29 14:03:53.664 (3) [pool-3-thread-10]: 8866c0e9-7441-4c3c-be96-7adf01a42df7 has 0 campaigns for a SE Update accounts sync. 2019-05-29 14:03:53.664 (3) [pool-3-thread-10]: 8866c0e9-7441-4c3c-be96-7adf01a42df7 has 0 campaigns for a SE Update groups-listings sync. 2019-05-29 14:03:53.664 (3) [pool-3-thread-10]: Finished sub-campaign processing for UPDATE deploymentID (7a820b40-933a-4714-9d33-8f6a8371f35e). account 8866c0e9-7441-4c3c-be96-7adf01a42df7. 4 submitted, 4 ok. 2019-05-29 14:03:53.665 (3) [pool-3-thread-10]: Updating deployment status to 'Success' for campaignID: 10861 2019-05-29 14:03:53.665 (3) [pool-3-thread-10]: Finished UPDATE request for 10861: SUCCEEDED (merchant: 8866c0e9-7441-4c3c-be96-7adf01a42df7) 2019-05-29 14:03:53.665 (3) [pool-3-thread-10]: Finished UPDATE request, deploymentID (7a820b40-933a-4714-9d33-8f6a8371f35e), account 8866c0e9-7441-4c3c-be96-7adf01a42df7 2019-05-29 14:03:53.665 (3) [pool-3-thread-10]: Request removed from map for customerID 8866c0e9-7441-4c3c-be96-7adf01a42df7 2019-05-29 14:03:53.689 (3) [AdMaxListener]: Sent message to response queue. 2019-05-29 14:04:08.460 (3) [Thread-9]: Heartbeat #824 (1559138648456) received in 0.003s 2019-05-29 14:05:08.460 (3) [Thread-9]: Heartbeat #825 (1559138708456) received in 0.004s