2019-07-11 12:07:55.417 (3) [Thread-9]: Request added to map for customerID 9b878d28-1172-4800-8711-a148dad10a9a 2019-07-11 12:07:55.417 (3) [Thread-9]: HighPriorityMessageHandler handling message ID ID:JBM-0c1a1a17-f440-462d-bfdc-d3d000513015 2019-07-11 12:07:55.417 (3) [Thread-9]: Request worker created for 9b878d28-1172-4800-8711-a148dad10a9a 2019-07-11 12:07:55.418 (3) [Thread-9]: Submitted executor job for 9b878d28-1172-4800-8711-a148dad10a9a 2019-07-11 12:07:55.422 (3) [Thread-9]: HighPriorityMessageHandler took message ID ID:JBM-0c1a1a17-f440-462d-bfdc-d3d000513015 out of queue 2019-07-11 12:07:55.443 (3) [pool-3-thread-56]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2019-07-11 12:07:55.451 (3) [pool-3-thread-56]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2019-07-11 12:07:55.468 (3) [pool-3-thread-56]: Nominal monthly budget was unchanged for AdMax campaign ID: 9010 2019-07-11 12:07:55.468 (3) [pool-3-thread-56]: Terminated budget for admaxCampaignID 9010 2019-07-11 12:07:55.468 (3) [pool-3-thread-56]: AdMaxNominalMonthlyBudgetsDAO.deleteFutureBudget deleting budget for AdMax campaign 9010 on start date 2019-07-12 2019-07-11 12:07:55.469 (3) [pool-3-thread-56]: Deleted tomorrow's budget for admaxCampaignID 9010 2019-07-11 12:07:55.480 (3) [pool-3-thread-56]: Nominal monthly budget was unchanged for AdMax campaign ID: 9009 2019-07-11 12:07:55.480 (3) [pool-3-thread-56]: Terminated budget for admaxCampaignID 9009 2019-07-11 12:07:55.480 (3) [pool-3-thread-56]: AdMaxNominalMonthlyBudgetsDAO.deleteFutureBudget deleting budget for AdMax campaign 9009 on start date 2019-07-12 2019-07-11 12:07:55.481 (3) [pool-3-thread-56]: Deleted tomorrow's budget for admaxCampaignID 9009 2019-07-11 12:07:55.482 (3) [pool-3-thread-56]: Reallocated budget for admaxCampaignID 9005 2019-07-11 12:07:55.493 (3) [pool-3-thread-56]: Nominal monthly budget was unchanged for AdMax campaign ID: 9007 2019-07-11 12:07:55.493 (3) [pool-3-thread-56]: Terminated budget for admaxCampaignID 9007 2019-07-11 12:07:55.493 (3) [pool-3-thread-56]: AdMaxNominalMonthlyBudgetsDAO.deleteFutureBudget deleting budget for AdMax campaign 9007 on start date 2019-07-12 2019-07-11 12:07:55.493 (3) [pool-3-thread-56]: Deleted tomorrow's budget for admaxCampaignID 9007 2019-07-11 12:07:55.495 (3) [pool-3-thread-56]: Reallocated budget for admaxCampaignID 9004 2019-07-11 12:07:55.495 (3) [pool-3-thread-56]: Updating deployment status to 'InProgress' for campaignID: 32698 2019-07-11 12:07:55.502 (3) [pool-3-thread-56]: Terminating advert budget for 32698 2019-07-11 12:07:55.503 (3) [pool-3-thread-56]: No active budget exists for AdMax campaign ID: 9010 2019-07-11 12:07:55.503 (3) [pool-3-thread-56]: Terminating advert slosh factor for 32698 2019-07-11 12:07:55.504 (3) [pool-3-thread-56]: No active slosh factor exists for AdMax campaign ID: 9010 2019-07-11 12:07:55.504 (3) [pool-3-thread-56]: Terminating advert slosh limit for 32698 2019-07-11 12:07:55.506 (3) [pool-3-thread-56]: No active slosh limit exists for AdMax campaign ID: 9010 2019-07-11 12:07:55.506 (3) [pool-3-thread-56]: Updating deployment status to 'InProgress' for campaignID: 32694 2019-07-11 12:07:55.512 (3) [pool-3-thread-56]: Terminating advert budget for 32694 2019-07-11 12:07:55.514 (3) [pool-3-thread-56]: No active budget exists for AdMax campaign ID: 9009 2019-07-11 12:07:55.514 (3) [pool-3-thread-56]: Terminating advert slosh factor for 32694 2019-07-11 12:07:55.516 (3) [pool-3-thread-56]: No active slosh factor exists for AdMax campaign ID: 9009 2019-07-11 12:07:55.516 (3) [pool-3-thread-56]: Terminating advert slosh limit for 32694 2019-07-11 12:07:55.517 (3) [pool-3-thread-56]: No active slosh limit exists for AdMax campaign ID: 9009 2019-07-11 12:07:55.517 (3) [pool-3-thread-56]: Updating deployment status to 'InProgress' for campaignID: 32692 2019-07-11 12:07:55.524 (3) [pool-3-thread-56]: Terminating advert budget for 32692 2019-07-11 12:07:55.526 (3) [pool-3-thread-56]: No active budget exists for AdMax campaign ID: 9007 2019-07-11 12:07:55.526 (3) [pool-3-thread-56]: Terminating advert slosh factor for 32692 2019-07-11 12:07:55.528 (3) [pool-3-thread-56]: No active slosh factor exists for AdMax campaign ID: 9007 2019-07-11 12:07:55.528 (3) [pool-3-thread-56]: Terminating advert slosh limit for 32692 2019-07-11 12:07:55.529 (3) [pool-3-thread-56]: No active slosh limit exists for AdMax campaign ID: 9007 2019-07-11 12:07:55.530 (3) [pool-3-thread-56]: Start processing UPDATE request (3fd81bc3-c200-410a-8263-d9618a74cc0e) for account 9b878d28-1172-4800-8711-a148dad10a9a. 8 campaign(s). 2019-07-11 12:07:55.530 (3) [pool-3-thread-56]: Performing update for account: 9b878d28-1172-4800-8711-a148dad10a9a ID#2651 2019-07-11 12:07:55.545 (3) [pool-3-thread-56]: 8 campaign(s) to update. 2019-07-11 12:07:55.545 (3) [pool-3-thread-56]: 0 campaign(s) to retry and update. 2019-07-11 12:07:55.545 (3) [pool-3-thread-56]: Update campaign status for accountID 2651 2019-07-11 12:07:55.546 (3) [pool-3-thread-56]: CampaignWorker initialized for account: 2651 2019-07-11 12:07:55.546 (3) [pool-3-thread-56]: Updating 9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32698_S1 Status: Deleted 2019-07-11 12:07:55.546 (3) [pool-3-thread-56]: Updating 9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32698_S2 Status: Deleted 2019-07-11 12:07:55.546 (3) [pool-3-thread-56]: Updating 9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32698_S3 Status: Deleted 2019-07-11 12:07:55.547 (3) [pool-3-thread-56]: Updating 9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32698_S4 Status: Deleted 2019-07-11 12:07:55.547 (3) [pool-3-thread-56]: Updating 9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32694_GM Status: Deleted 2019-07-11 12:07:55.547 (3) [pool-3-thread-56]: Updating 9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32694_GT Status: Deleted 2019-07-11 12:07:55.547 (3) [pool-3-thread-56]: Updating 9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32692_GM Status: Deleted 2019-07-11 12:07:55.547 (3) [pool-3-thread-56]: Updating 9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32692_GT Status: Deleted 2019-07-11 12:07:55.547 (3) [pool-3-thread-56]: CampaignUpdateWorker started... 2019-07-11 12:07:55,640 [pool-3-thread-56] DEBUG c.t.searchengines.bing.BingApiUtils - Getting Bing properties using distribution service 2019-07-11 12:07:55.640 (3) [pool-3-thread-56]: Retrieving credentials : client id : cc084b2e-db60-405f-9187-ef3ceae9e6b3 , client secret :klvmLO8xnxKTWXQ8345%;}: , refresh token : M..CW3nLJ1!D6sEtBycrOOmCk!sxbqUy3UV0aclac*!T!5TH6uIs6mVrAWc5UR7zJliKXI9dUHjMGNdE42rKCXg4Sy3QysBRYBOA57M8nr1mjafVruL3BZMXsUE4iZs55QLZUkI299f50A59TENGDKs7JFKI7OYG4U2PPiGuJPCA1rWcm9usMEJaFsHTsSpEjYqa1YoJ7708ye4Mz3CsQQbkRTWu97IMgxYes*yzJgISHbmw5EA9C7QMK5UTArfZaLtA5v2DL7RNCrVREQBopSIN*9t9F3TT!EQP71YZ2YOQ7PhkFqenoHlguaZj6*jHXwNDlEbZa5upIS*qZ0Lodv5bLFAnMhe*MuHaGcCGCbUbq8eazmEr3tU5nPH0JrNKD2Gqg$$ 2019-07-11 12:07:55,640 [pool-3-thread-56] INFO c.t.s.o.core.OAuthServiceComponent - [oauth] Return OAuth credential. Access token = EwAYA3hlBAAUWY3dyHAUGz/vjm4jCptmhWDDEPAAAcVlsenCAwHTgQrUABZDCddeP/r2LfzrlZsfq0HHoKiEIwOw0DAmAEgyZsxLNoxxtjgXuNjHNRGSQCTxdJmsxaz4NzewyRLx1BlywH1++qEPTboBSq+FG8zMo7dLyOIVdxKuQhfmJq61xnQhmLJ73YUOwTylhk91y4LMC4FLxgTvEAXqqpqizKAsxbU/4CUWD3npQ1p4HcTI8gtmTN5nRVmKKqoCJR+N42fByh0gardHY2QCX4EFQIJHHoiVrf8Pmv5i0EGKA0mn7qtOcjS/pmdVebw5oC74NilcXrY90tjK3EjMeNiH+i3Rxm7J2230dUxkWDzBH8p0pNmBdziDdgoDZgAACOOiaUU9hja16AEF/9oTTBLlH0OJ7XxZxEHIEefzRhUEy/NxiZLQTBY2cowBNo9i8c7icknVOU/DTGRAADhe18g96YwQDTmn+r7GR3beER8t2vpAEKBfQxxlKmBbiNb2VeoQrcQFCBr50nzap7kzk8/yrdgBa6vRwRC9NEhFSMjlzKsEA+POVAAWjeuKZbr65ItrwUWN8sB0Rt4lLowmEyNH0ioTqU+5vmVqCAWISQ9jC2XlUz98qD4q3pHivNAsT3YSVzVA7n4kpq0WRBvLWmFE4fDl0kfUVHGXA/iS7TQiPDBizI6oaCBsF4Vc55Lz9JqVFUPs/F0q7T82UX0ox0cl43/622yL3/LoUivc07UV9wqsJ4jgQt/xu3n+Orqkkw6AYbR456sXZllJ4sjFOBjzdwp1jznyer4u+EXfS+xjG6bc0ocv4EFi97se6NSR4mPqMnrDcwhOszffmiV5KfezeLhkuWNN0oLuuIAX4ok1XjwLqf7V5XPU71vhTsIeg9ZyXU3Kh5NseDm5dLiG+m//F1fcegDrKxNzSfHFWr6xmGxTkiq9pU3JiZLL1p+Ue10WMVsWqlfQnfacDCY2Q3jwa+3Zy0gqzejsC+UEHUuxzZQnLt0FWS74SEaOw1LAXenLukHsXeGBW0QHlV9/YNRsvTcC for bing (clientID=cc084b2e-db60-405f-9187-ef3ceae9e6b3) 2019-07-11 12:07:55.640 (3) [pool-3-thread-56]: [oauth] Returning access token from OAuth service: EwAYA3hlBAAUWY3dyHAUGz/vjm4jCptmhWDDEPAAAcVlsenCAwHTgQrUABZDCddeP/r2LfzrlZsfq0HHoKiEIwOw0DAmAEgyZsxLNoxxtjgXuNjHNRGSQCTxdJmsxaz4NzewyRLx1BlywH1++qEPTboBSq+FG8zMo7dLyOIVdxKuQhfmJq61xnQhmLJ73YUOwTylhk91y4LMC4FLxgTvEAXqqpqizKAsxbU/4CUWD3npQ1p4HcTI8gtmTN5nRVmKKqoCJR+N42fByh0gardHY2QCX4EFQIJHHoiVrf8Pmv5i0EGKA0mn7qtOcjS/pmdVebw5oC74NilcXrY90tjK3EjMeNiH+i3Rxm7J2230dUxkWDzBH8p0pNmBdziDdgoDZgAACOOiaUU9hja16AEF/9oTTBLlH0OJ7XxZxEHIEefzRhUEy/NxiZLQTBY2cowBNo9i8c7icknVOU/DTGRAADhe18g96YwQDTmn+r7GR3beER8t2vpAEKBfQxxlKmBbiNb2VeoQrcQFCBr50nzap7kzk8/yrdgBa6vRwRC9NEhFSMjlzKsEA+POVAAWjeuKZbr65ItrwUWN8sB0Rt4lLowmEyNH0ioTqU+5vmVqCAWISQ9jC2XlUz98qD4q3pHivNAsT3YSVzVA7n4kpq0WRBvLWmFE4fDl0kfUVHGXA/iS7TQiPDBizI6oaCBsF4Vc55Lz9JqVFUPs/F0q7T82UX0ox0cl43/622yL3/LoUivc07UV9wqsJ4jgQt/xu3n+Orqkkw6AYbR456sXZllJ4sjFOBjzdwp1jznyer4u+EXfS+xjG6bc0ocv4EFi97se6NSR4mPqMnrDcwhOszffmiV5KfezeLhkuWNN0oLuuIAX4ok1XjwLqf7V5XPU71vhTsIeg9ZyXU3Kh5NseDm5dLiG+m//F1fcegDrKxNzSfHFWr6xmGxTkiq9pU3JiZLL1p+Ue10WMVsWqlfQnfacDCY2Q3jwa+3Zy0gqzejsC+UEHUuxzZQnLt0FWS74SEaOw1LAXenLukHsXeGBW0QHlV9/YNRsvTcC 2019-07-11 12:07:55,728 [pool-3-thread-56] DEBUG c.t.s.facebook.FacebookApiUtils - Getting FB properties using distribution service 2019-07-11 12:07:55,729 [pool-3-thread-56] DEBUG c.t.s.f.FacebookAccountDeployer - Facebook currencyCode USD for accountID 2651 2019-07-11 12:07:55,730 [pool-3-thread-56] DEBUG c.t.s.f.FacebookAccountDeployer - Facebook timeZoneID America/New_York for accountID 2651 2019-07-11 12:07:55,730 [pool-3-thread-56] INFO c.t.s.f.FacebookAccountDeployer - FacebookAccountDeployer:getExistingCampaigns 2019-07-11 12:07:55,734 [pool-3-thread-56] INFO jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`id` IN (2691,2692,2693,2694) 2019-07-11 12:07:55,737 [pool-3-thread-56] INFO c.t.s.f.FacebookAccountDeployer - calculating carryover for seuserID 4104 2019-07-11 12:07:55,737 [pool-3-thread-56] INFO c.t.s.f.FacebookAccountDeployer - Fetching performance data for seuserID 4104 and campaign SEIdentifiers [b6b7ce94ad4d46e38f0418ea89b1812f, e4e9cb564b8647ed86676c947686366e, ace4acbdbb334a77897f4dcfd47992b3, 2e5b1f8bf81f4acda3633873845303e6] 2019-07-11 12:07:55,741 [pool-3-thread-56] INFO jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`tpId` = 'b6b7ce94ad4d46e38f0418ea89b1812f' 2019-07-11 12:08:00,742 [pool-3-thread-56] INFO c.t.s.c.t.i.s.CampaignServiceClient - Getting TP campaign [b6b7ce94ad4d46e38f0418ea89b1812f] details for account 7e085c22ac9e4529a20f3b4388ebc497 2019-07-11 12:08:00,744 [pool-3-thread-56] INFO o.a.c.i.LoggingOutInterceptor - Outbound Message --------------------------- ID: 822 Address: https://api.tigerpistol.com/v1/campaigns/b6b7ce94ad4d46e38f0418ea89b1812f Http-Method: GET Content-Type: application/json Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token A5CO5g2RJFRI4w5mWJ32bkCAwQ6mMWo9bHPUWqIC]} -------------------------------------- 2019-07-11 12:08:01,091 [pool-3-thread-56] INFO o.a.c.i.LoggingInInterceptor - Inbound Message ---------------------------- ID: 822 Response-Code: 200 Encoding: UTF-8 Content-Type: application/json; charset=utf-8 Headers: {api-supported-versions=[1.0], Content-Length=[692], content-type=[application/json; charset=utf-8], Date=[Thu, 11 Jul 2019 12:08:00 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]} Payload: {"variations":[{"index":0,"reviewError":null}],"leadEmailAddresses":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":"b6b7ce94ad4d46e38f0418ea89b1812f","customerId":"7e085c22ac9e4529a20f3b4388ebc497","name":"9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32698_S1","start":"2019-07-11T12:01:00+00:00","end":"2019-08-11T03:59:00+00:00","budget":3125.00,"objective":"website_clicks","status":"paused","publishPhase":"complete","errorMessage":""} -------------------------------------- 2019-07-11 12:08:01,093 [pool-3-thread-56] INFO jdbc.sqlonly - INSERT INTO `performance` (`campaignID`, `date`, `status`, `spend`, `clicks`, `impressions`, `budget`, `startDate`, `endDate`, `lastUpdated`) VALUES (2691,'2019-07-11','paused',0.0,0,0,3125,'07/11/2019 12:01:00.000','08/11/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-07-11 12:08:01,094 [pool-3-thread-56] 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` = 2691 and `performance`.`date` = '2019-07-11' 2019-07-11 12:08:01,095 [pool-3-thread-56] INFO jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`tpId` = 'e4e9cb564b8647ed86676c947686366e' 2019-07-11 12:08:06,096 [pool-3-thread-56] INFO c.t.s.c.t.i.s.CampaignServiceClient - Getting TP campaign [e4e9cb564b8647ed86676c947686366e] details for account 7e085c22ac9e4529a20f3b4388ebc497 2019-07-11 12:08:06,099 [pool-3-thread-56] INFO o.a.c.i.LoggingOutInterceptor - Outbound Message --------------------------- ID: 823 Address: https://api.tigerpistol.com/v1/campaigns/e4e9cb564b8647ed86676c947686366e Http-Method: GET Content-Type: application/json Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token A5CO5g2RJFRI4w5mWJ32bkCAwQ6mMWo9bHPUWqIC]} -------------------------------------- 2019-07-11 12:08:06,425 [pool-3-thread-56] INFO o.a.c.i.LoggingInInterceptor - Inbound Message ---------------------------- ID: 823 Response-Code: 200 Encoding: UTF-8 Content-Type: application/json; charset=utf-8 Headers: {api-supported-versions=[1.0], Content-Length=[692], content-type=[application/json; charset=utf-8], Date=[Thu, 11 Jul 2019 12:08:05 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]} Payload: {"variations":[{"index":0,"reviewError":null}],"leadEmailAddresses":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":"e4e9cb564b8647ed86676c947686366e","customerId":"7e085c22ac9e4529a20f3b4388ebc497","name":"9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32698_S2","start":"2019-07-11T12:01:00+00:00","end":"2019-08-11T03:59:00+00:00","budget":3125.00,"objective":"website_clicks","status":"paused","publishPhase":"complete","errorMessage":""} -------------------------------------- 2019-07-11 12:08:06,427 [pool-3-thread-56] INFO jdbc.sqlonly - INSERT INTO `performance` (`campaignID`, `date`, `status`, `spend`, `clicks`, `impressions`, `budget`, `startDate`, `endDate`, `lastUpdated`) VALUES (2692,'2019-07-11','paused',0.0,0,0,3125,'07/11/2019 12:01:00.000','08/11/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-07-11 12:08:06,428 [pool-3-thread-56] 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` = 2692 and `performance`.`date` = '2019-07-11' 2019-07-11 12:08:06,429 [pool-3-thread-56] INFO jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`tpId` = 'ace4acbdbb334a77897f4dcfd47992b3' 2019-07-11 12:08:11,430 [pool-3-thread-56] INFO c.t.s.c.t.i.s.CampaignServiceClient - Getting TP campaign [ace4acbdbb334a77897f4dcfd47992b3] details for account 7e085c22ac9e4529a20f3b4388ebc497 2019-07-11 12:08:11,432 [pool-3-thread-56] INFO o.a.c.i.LoggingOutInterceptor - Outbound Message --------------------------- ID: 824 Address: https://api.tigerpistol.com/v1/campaigns/ace4acbdbb334a77897f4dcfd47992b3 Http-Method: GET Content-Type: application/json Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token A5CO5g2RJFRI4w5mWJ32bkCAwQ6mMWo9bHPUWqIC]} -------------------------------------- 2019-07-11 12:08:11,912 [pool-3-thread-56] INFO o.a.c.i.LoggingInInterceptor - Inbound Message ---------------------------- ID: 824 Response-Code: 200 Encoding: UTF-8 Content-Type: application/json; charset=utf-8 Headers: {api-supported-versions=[1.0], Content-Length=[692], content-type=[application/json; charset=utf-8], Date=[Thu, 11 Jul 2019 12:08:11 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]} Payload: {"variations":[{"index":0,"reviewError":null}],"leadEmailAddresses":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":"ace4acbdbb334a77897f4dcfd47992b3","customerId":"7e085c22ac9e4529a20f3b4388ebc497","name":"9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32698_S3","start":"2019-07-11T12:01:00+00:00","end":"2019-08-11T03:59:00+00:00","budget":3125.00,"objective":"website_clicks","status":"paused","publishPhase":"complete","errorMessage":""} -------------------------------------- 2019-07-11 12:08:11,913 [pool-3-thread-56] INFO jdbc.sqlonly - INSERT INTO `performance` (`campaignID`, `date`, `status`, `spend`, `clicks`, `impressions`, `budget`, `startDate`, `endDate`, `lastUpdated`) VALUES (2693,'2019-07-11','paused',0.0,0,0,3125,'07/11/2019 12:01:00.000','08/11/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-07-11 12:08:11,914 [pool-3-thread-56] 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` = 2693 and `performance`.`date` = '2019-07-11' 2019-07-11 12:08:11,916 [pool-3-thread-56] INFO jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`tpId` = '2e5b1f8bf81f4acda3633873845303e6' 2019-07-11 12:08:16,917 [pool-3-thread-56] INFO c.t.s.c.t.i.s.CampaignServiceClient - Getting TP campaign [2e5b1f8bf81f4acda3633873845303e6] details for account 7e085c22ac9e4529a20f3b4388ebc497 2019-07-11 12:08:16,920 [pool-3-thread-56] INFO o.a.c.i.LoggingOutInterceptor - Outbound Message --------------------------- ID: 825 Address: https://api.tigerpistol.com/v1/campaigns/2e5b1f8bf81f4acda3633873845303e6 Http-Method: GET Content-Type: application/json Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token A5CO5g2RJFRI4w5mWJ32bkCAwQ6mMWo9bHPUWqIC]} -------------------------------------- 2019-07-11 12:08:17,242 [pool-3-thread-56] INFO o.a.c.i.LoggingInInterceptor - Inbound Message ---------------------------- ID: 825 Response-Code: 200 Encoding: UTF-8 Content-Type: application/json; charset=utf-8 Headers: {api-supported-versions=[1.0], Content-Length=[692], content-type=[application/json; charset=utf-8], Date=[Thu, 11 Jul 2019 12:08:16 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]} Payload: {"variations":[{"index":0,"reviewError":null}],"leadEmailAddresses":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":"2e5b1f8bf81f4acda3633873845303e6","customerId":"7e085c22ac9e4529a20f3b4388ebc497","name":"9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32698_S4","start":"2019-07-11T12:01:00+00:00","end":"2019-08-11T03:59:00+00:00","budget":3125.00,"objective":"website_clicks","status":"paused","publishPhase":"complete","errorMessage":""} -------------------------------------- 2019-07-11 12:08:17,244 [pool-3-thread-56] INFO jdbc.sqlonly - INSERT INTO `performance` (`campaignID`, `date`, `status`, `spend`, `clicks`, `impressions`, `budget`, `startDate`, `endDate`, `lastUpdated`) VALUES (2694,'2019-07-11','paused',0.0,0,0,3125,'07/11/2019 12:01:00.000','08/11/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-07-11 12:08:17,245 [pool-3-thread-56] 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` = 2694 and `performance`.`date` = '2019-07-11' 2019-07-11 12:08:17,248 [pool-3-thread-56] INFO c.t.s.f.FacebookAccountDeployer - Sucessfully fetched facebook campaign performance data for seuserID 4104, perf data ([TPCampaignPerformanceDTO [theID=8245, theCampaignID=2691, theDate=2019-07-11, theStatus=paused, theSpend=0.0, theClicks=0, theImpressions=0, theBudget=3125, theStartDate=2019-07-11T12:01:00.000Z, theEndDate=2019-08-11T03:59:00.000Z, theLastUpdated=2019-07-11T12:08:01.000Z], TPCampaignPerformanceDTO [theID=8246, theCampaignID=2692, theDate=2019-07-11, theStatus=paused, theSpend=0.0, theClicks=0, theImpressions=0, theBudget=3125, theStartDate=2019-07-11T12:01:00.000Z, theEndDate=2019-08-11T03:59:00.000Z, theLastUpdated=2019-07-11T12:08:06.000Z], TPCampaignPerformanceDTO [theID=8247, theCampaignID=2693, theDate=2019-07-11, theStatus=paused, theSpend=0.0, theClicks=0, theImpressions=0, theBudget=3125, theStartDate=2019-07-11T12:01:00.000Z, theEndDate=2019-08-11T03:59:00.000Z, theLastUpdated=2019-07-11T12:08:11.000Z], TPCampaignPerformanceDTO [theID=8249, theCampaignID=2694, theDate=2019-07-11, theStatus=paused, theSpend=0.0, theClicks=0, theImpressions=0, theBudget=3125, theStartDate=2019-07-11T12:01:00.000Z, theEndDate=2019-08-11T03:59:00.000Z, theLastUpdated=2019-07-11T12:08:17.000Z]]) 2019-07-11 12:08:17,248 [pool-3-thread-56] INFO c.t.s.f.FacebookAccountDeployer - =========== Processing carryover for campaignID 2691 [seuserID 4104] =========== 2019-07-11 12:08:17,248 [pool-3-thread-56] INFO c.t.s.f.FacebookAccountDeployer - actual_monthly_budget for campaignID 2691 : 31.25 USD 2019-07-11 12:08:17,248 [pool-3-thread-56] INFO c.t.s.f.FacebookAccountDeployer - actual_spend for campaignID 2691 : 0.0 USD 2019-07-11 12:08:17,248 [pool-3-thread-56] INFO c.t.s.f.FacebookAccountDeployer - campaign start date 2019-07-11T08:01:00.000-04:00 America/New_York, end date 2019-08-10T23:59:00.000-04:00 America/New_York, days 31.0, current date 2019-07-11T08:08:17.248-04:00 America/New_York for campaignID 2691 2019-07-11 12:08:17,248 [pool-3-thread-56] INFO c.t.s.f.FacebookAccountDeployer - campaignID 2691 active for 0 days (num_of_days_active) and 0 hours (num_of_hours_active) 2019-07-11 12:08:17,248 [pool-3-thread-56] INFO c.t.s.f.FacebookAccountDeployer - daily_budget [actual_monthly_budget / 31.0] for campaignID 2691 : 1.0080645 2019-07-11 12:08:17,248 [pool-3-thread-56] INFO c.t.s.f.FacebookAccountDeployer - hourly_budget [daily_budget / 24] for campaignID 2691 : 0.04200269 2019-07-11 12:08:17,249 [pool-3-thread-56] INFO c.t.s.f.FacebookAccountDeployer - expected_daily_spend [daily_budget * num_of_days_active] for campaignID 2691 : 0.0 2019-07-11 12:08:17,249 [pool-3-thread-56] INFO c.t.s.f.FacebookAccountDeployer - expected_hourly_spend [hourly_budget * num_of_hours_active] for campaignID 2691 : 0.0 2019-07-11 12:08:17,249 [pool-3-thread-56] INFO c.t.s.f.FacebookAccountDeployer - expected_spend [expected_daily_spend + expected_hourly_spend] for campaignID 2691 : 0.0 2019-07-11 12:08:17,249 [pool-3-thread-56] INFO c.t.s.f.FacebookAccountDeployer - dedicatedCarryover [expected_spend - actual_spend] for campaignID 2691 : 0.0 2019-07-11 12:08:17,249 [pool-3-thread-56] INFO c.t.s.f.FacebookAccountDeployer - =========== Processing carryover for campaignID 2692 [seuserID 4104] =========== 2019-07-11 12:08:17,249 [pool-3-thread-56] INFO c.t.s.f.FacebookAccountDeployer - actual_monthly_budget for campaignID 2692 : 31.25 USD 2019-07-11 12:08:17,249 [pool-3-thread-56] INFO c.t.s.f.FacebookAccountDeployer - actual_spend for campaignID 2692 : 0.0 USD 2019-07-11 12:08:17,249 [pool-3-thread-56] INFO c.t.s.f.FacebookAccountDeployer - campaign start date 2019-07-11T08:01:00.000-04:00 America/New_York, end date 2019-08-10T23:59:00.000-04:00 America/New_York, days 31.0, current date 2019-07-11T08:08:17.249-04:00 America/New_York for campaignID 2692 2019-07-11 12:08:17,249 [pool-3-thread-56] INFO c.t.s.f.FacebookAccountDeployer - campaignID 2692 active for 0 days (num_of_days_active) and 0 hours (num_of_hours_active) 2019-07-11 12:08:17,249 [pool-3-thread-56] INFO c.t.s.f.FacebookAccountDeployer - daily_budget [actual_monthly_budget / 31.0] for campaignID 2692 : 1.0080645 2019-07-11 12:08:17,249 [pool-3-thread-56] INFO c.t.s.f.FacebookAccountDeployer - hourly_budget [daily_budget / 24] for campaignID 2692 : 0.04200269 2019-07-11 12:08:17,250 [pool-3-thread-56] INFO c.t.s.f.FacebookAccountDeployer - expected_daily_spend [daily_budget * num_of_days_active] for campaignID 2692 : 0.0 2019-07-11 12:08:17,250 [pool-3-thread-56] INFO c.t.s.f.FacebookAccountDeployer - expected_hourly_spend [hourly_budget * num_of_hours_active] for campaignID 2692 : 0.0 2019-07-11 12:08:17,250 [pool-3-thread-56] INFO c.t.s.f.FacebookAccountDeployer - expected_spend [expected_daily_spend + expected_hourly_spend] for campaignID 2692 : 0.0 2019-07-11 12:08:17,250 [pool-3-thread-56] INFO c.t.s.f.FacebookAccountDeployer - dedicatedCarryover [expected_spend - actual_spend] for campaignID 2692 : 0.0 2019-07-11 12:08:17,250 [pool-3-thread-56] INFO c.t.s.f.FacebookAccountDeployer - =========== Processing carryover for campaignID 2693 [seuserID 4104] =========== 2019-07-11 12:08:17,250 [pool-3-thread-56] INFO c.t.s.f.FacebookAccountDeployer - actual_monthly_budget for campaignID 2693 : 31.25 USD 2019-07-11 12:08:17,251 [pool-3-thread-56] INFO c.t.s.f.FacebookAccountDeployer - actual_spend for campaignID 2693 : 0.0 USD 2019-07-11 12:08:17,251 [pool-3-thread-56] INFO c.t.s.f.FacebookAccountDeployer - campaign start date 2019-07-11T08:01:00.000-04:00 America/New_York, end date 2019-08-10T23:59:00.000-04:00 America/New_York, days 31.0, current date 2019-07-11T08:08:17.250-04:00 America/New_York for campaignID 2693 2019-07-11 12:08:17,251 [pool-3-thread-56] INFO c.t.s.f.FacebookAccountDeployer - campaignID 2693 active for 0 days (num_of_days_active) and 0 hours (num_of_hours_active) 2019-07-11 12:08:17,251 [pool-3-thread-56] INFO c.t.s.f.FacebookAccountDeployer - daily_budget [actual_monthly_budget / 31.0] for campaignID 2693 : 1.0080645 2019-07-11 12:08:17,251 [pool-3-thread-56] INFO c.t.s.f.FacebookAccountDeployer - hourly_budget [daily_budget / 24] for campaignID 2693 : 0.04200269 2019-07-11 12:08:17,251 [pool-3-thread-56] INFO c.t.s.f.FacebookAccountDeployer - expected_daily_spend [daily_budget * num_of_days_active] for campaignID 2693 : 0.0 2019-07-11 12:08:17,251 [pool-3-thread-56] INFO c.t.s.f.FacebookAccountDeployer - expected_hourly_spend [hourly_budget * num_of_hours_active] for campaignID 2693 : 0.0 2019-07-11 12:08:17,251 [pool-3-thread-56] INFO c.t.s.f.FacebookAccountDeployer - expected_spend [expected_daily_spend + expected_hourly_spend] for campaignID 2693 : 0.0 2019-07-11 12:08:17,251 [pool-3-thread-56] INFO c.t.s.f.FacebookAccountDeployer - dedicatedCarryover [expected_spend - actual_spend] for campaignID 2693 : 0.0 2019-07-11 12:08:17,251 [pool-3-thread-56] INFO c.t.s.f.FacebookAccountDeployer - =========== Processing carryover for campaignID 2694 [seuserID 4104] =========== 2019-07-11 12:08:17,251 [pool-3-thread-56] INFO c.t.s.f.FacebookAccountDeployer - actual_monthly_budget for campaignID 2694 : 31.25 USD 2019-07-11 12:08:17,251 [pool-3-thread-56] INFO c.t.s.f.FacebookAccountDeployer - actual_spend for campaignID 2694 : 0.0 USD 2019-07-11 12:08:17,251 [pool-3-thread-56] INFO c.t.s.f.FacebookAccountDeployer - campaign start date 2019-07-11T08:01:00.000-04:00 America/New_York, end date 2019-08-10T23:59:00.000-04:00 America/New_York, days 31.0, current date 2019-07-11T08:08:17.251-04:00 America/New_York for campaignID 2694 2019-07-11 12:08:17,251 [pool-3-thread-56] INFO c.t.s.f.FacebookAccountDeployer - campaignID 2694 active for 0 days (num_of_days_active) and 0 hours (num_of_hours_active) 2019-07-11 12:08:17,251 [pool-3-thread-56] INFO c.t.s.f.FacebookAccountDeployer - daily_budget [actual_monthly_budget / 31.0] for campaignID 2694 : 1.0080645 2019-07-11 12:08:17,251 [pool-3-thread-56] INFO c.t.s.f.FacebookAccountDeployer - hourly_budget [daily_budget / 24] for campaignID 2694 : 0.04200269 2019-07-11 12:08:17,251 [pool-3-thread-56] INFO c.t.s.f.FacebookAccountDeployer - expected_daily_spend [daily_budget * num_of_days_active] for campaignID 2694 : 0.0 2019-07-11 12:08:17,251 [pool-3-thread-56] INFO c.t.s.f.FacebookAccountDeployer - expected_hourly_spend [hourly_budget * num_of_hours_active] for campaignID 2694 : 0.0 2019-07-11 12:08:17,251 [pool-3-thread-56] INFO c.t.s.f.FacebookAccountDeployer - expected_spend [expected_daily_spend + expected_hourly_spend] for campaignID 2694 : 0.0 2019-07-11 12:08:17,251 [pool-3-thread-56] INFO c.t.s.f.FacebookAccountDeployer - dedicatedCarryover [expected_spend - actual_spend] for campaignID 2694 : 0.0 2019-07-11 12:08:17,254 [pool-3-thread-56] 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` = 4104 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-07-11 12:08:17,257 [pool-3-thread-56] INFO c.t.s.f.FacebookAccountDeployer - Found campaign carryover data for seuserID 4104, boosted carryover data ([TPCampaignCarryoverDTO [theID=9289, theCampaignID=2690, theDate=2019-07-11, theDedicatedCarryover=0.0, thePooledCarryover=0.0, theCarryoverType=boosted], TPCampaignCarryoverDTO [theID=9288, theCampaignID=2689, theDate=2019-07-11, theDedicatedCarryover=0.0, thePooledCarryover=0.0, theCarryoverType=boosted], TPCampaignCarryoverDTO [theID=9287, theCampaignID=2688, theDate=2019-07-11, theDedicatedCarryover=0.0, thePooledCarryover=0.0, theCarryoverType=boosted], TPCampaignCarryoverDTO [theID=9286, theCampaignID=2687, theDate=2019-07-11, theDedicatedCarryover=0.0, thePooledCarryover=0.0, theCarryoverType=boosted]]) 2019-07-11 12:08:17,259 [pool-3-thread-56] INFO jdbc.sqlonly - SELECT `id`, `searchEngineUserId`, `date`, `carryoverAdjustment`, `type` FROM `monthlyCarryoverAdjustments` WHERE `searchEngineUserId` = 4104 and `date` = '2019-07-11' and `type` = 'normal' 2019-07-11 12:08:17,261 [pool-3-thread-56] INFO c.t.s.f.FacebookAccountDeployer - Total boostedCarryover for seuserID 4104 and date 2019-07-11 is 0.0 2019-07-11 12:08:17,261 [pool-3-thread-56] INFO c.t.s.f.FacebookAccountDeployer - Total carryover Adjustment for seuserID 4104 and date 2019-07-11 is 0.0 2019-07-11 12:08:17,261 [pool-3-thread-56] INFO c.t.s.f.FacebookAccountDeployer - Total pooledCarryOver [(totalPooledCarryover + totalBoostedCarryover) - carryoverAdjustment] for seuserID 4104 and date 2019-07-11 is 0.0 2019-07-11 12:08:17,261 [pool-3-thread-56] INFO c.t.s.f.FacebookAccountDeployer - saving carryover TPCampaignCarryoverDTO [theID=null, theCampaignID=2691, theDate=2019-07-11, theDedicatedCarryover=0.0, thePooledCarryover=0.0, theCarryoverType=normal] for campaignID 2691 2019-07-11 12:08:17,264 [pool-3-thread-56] INFO jdbc.sqlonly - INSERT INTO `monthlyCarryovers` (`campaignID`, `date`, `dedicatedCarryover`, `pooledCarryover`, `type`) VALUES (2691,'2019-07-11',0.0,0.0,'normal') ON DUPLICATE KEY UPDATE `dedicatedCarryover`=VALUES(`dedicatedCarryover`), `pooledCarryover`=VALUES(`pooledCarryover`), `type`=VALUES(`type`) 2019-07-11 12:08:17,265 [pool-3-thread-56] INFO jdbc.sqlonly - SELECT `id`, `campaignID`, `date`, `dedicatedCarryover`, `pooledCarryover`, `type` FROM `monthlyCarryovers` WHERE `campaignID` = 2691 and `date` = '2019-07-11' and `type` = 'normal' 2019-07-11 12:08:17,267 [pool-3-thread-56] INFO c.t.s.f.FacebookAccountDeployer - saving carryover TPCampaignCarryoverDTO [theID=null, theCampaignID=2692, theDate=2019-07-11, theDedicatedCarryover=0.0, thePooledCarryover=0.0, theCarryoverType=normal] for campaignID 2692 2019-07-11 12:08:17,270 [pool-3-thread-56] INFO jdbc.sqlonly - INSERT INTO `monthlyCarryovers` (`campaignID`, `date`, `dedicatedCarryover`, `pooledCarryover`, `type`) VALUES (2692,'2019-07-11',0.0,0.0,'normal') ON DUPLICATE KEY UPDATE `dedicatedCarryover`=VALUES(`dedicatedCarryover`), `pooledCarryover`=VALUES(`pooledCarryover`), `type`=VALUES(`type`) 2019-07-11 12:08:17,271 [pool-3-thread-56] INFO jdbc.sqlonly - SELECT `id`, `campaignID`, `date`, `dedicatedCarryover`, `pooledCarryover`, `type` FROM `monthlyCarryovers` WHERE `campaignID` = 2692 and `date` = '2019-07-11' and `type` = 'normal' 2019-07-11 12:08:17,273 [pool-3-thread-56] INFO c.t.s.f.FacebookAccountDeployer - saving carryover TPCampaignCarryoverDTO [theID=null, theCampaignID=2693, theDate=2019-07-11, theDedicatedCarryover=0.0, thePooledCarryover=0.0, theCarryoverType=normal] for campaignID 2693 2019-07-11 12:08:17,275 [pool-3-thread-56] INFO jdbc.sqlonly - INSERT INTO `monthlyCarryovers` (`campaignID`, `date`, `dedicatedCarryover`, `pooledCarryover`, `type`) VALUES (2693,'2019-07-11',0.0,0.0,'normal') ON DUPLICATE KEY UPDATE `dedicatedCarryover`=VALUES(`dedicatedCarryover`), `pooledCarryover`=VALUES(`pooledCarryover`), `type`=VALUES(`type`) 2019-07-11 12:08:17,276 [pool-3-thread-56] INFO jdbc.sqlonly - SELECT `id`, `campaignID`, `date`, `dedicatedCarryover`, `pooledCarryover`, `type` FROM `monthlyCarryovers` WHERE `campaignID` = 2693 and `date` = '2019-07-11' and `type` = 'normal' 2019-07-11 12:08:17,278 [pool-3-thread-56] INFO c.t.s.f.FacebookAccountDeployer - saving carryover TPCampaignCarryoverDTO [theID=null, theCampaignID=2694, theDate=2019-07-11, theDedicatedCarryover=0.0, thePooledCarryover=0.0, theCarryoverType=normal] for campaignID 2694 2019-07-11 12:08:17,281 [pool-3-thread-56] INFO jdbc.sqlonly - INSERT INTO `monthlyCarryovers` (`campaignID`, `date`, `dedicatedCarryover`, `pooledCarryover`, `type`) VALUES (2694,'2019-07-11',0.0,0.0,'normal') ON DUPLICATE KEY UPDATE `dedicatedCarryover`=VALUES(`dedicatedCarryover`), `pooledCarryover`=VALUES(`pooledCarryover`), `type`=VALUES(`type`) 2019-07-11 12:08:17,282 [pool-3-thread-56] INFO jdbc.sqlonly - SELECT `id`, `campaignID`, `date`, `dedicatedCarryover`, `pooledCarryover`, `type` FROM `monthlyCarryovers` WHERE `campaignID` = 2694 and `date` = '2019-07-11' and `type` = 'normal' 2019-07-11 12:08:17,289 [pool-3-thread-56] INFO c.t.s.bing.BingAccountDeployer - BingAccountDeployer:getExistingCampaigns 2019-07-11 12:08:17,291 [pool-3-thread-56] INFO jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`id` IN (6304,6305) 2019-07-11 12:08:17.293 (3) [pool-3-thread-56]: 9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32694_GT status change (Paused->Deleted) 2019-07-11 12:08:17.293 (3) [pool-3-thread-56]: Campaign deleted, skipping target sync. 2019-07-11 12:08:17.293 (3) [pool-3-thread-56]: Campaign deleted, skipping call data sync 2019-07-11 12:08:17.293 (3) [pool-3-thread-56]: Campaign deleted, skipping location data sync 2019-07-11 12:08:17.293 (3) [pool-3-thread-56]: 9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32694_GM status change (Paused->Deleted) 2019-07-11 12:08:17.293 (3) [pool-3-thread-56]: Campaign deleted, skipping target sync. 2019-07-11 12:08:17.293 (3) [pool-3-thread-56]: Campaign deleted, skipping call data sync 2019-07-11 12:08:17.293 (3) [pool-3-thread-56]: Campaign deleted, skipping location data sync 2019-07-11 12:08:17.293 (3) [pool-3-thread-56]: 9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32698_S1 status change (Paused->Deleted) 2019-07-11 12:08:17.293 (3) [pool-3-thread-56]: Campaign deleted, skipping target sync. 2019-07-11 12:08:17.293 (3) [pool-3-thread-56]: Campaign deleted, skipping call data sync 2019-07-11 12:08:17.293 (3) [pool-3-thread-56]: Campaign deleted, skipping location data sync 2019-07-11 12:08:17.293 (3) [pool-3-thread-56]: 9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32698_S2 status change (Paused->Deleted) 2019-07-11 12:08:17.293 (3) [pool-3-thread-56]: Campaign deleted, skipping target sync. 2019-07-11 12:08:17.293 (3) [pool-3-thread-56]: Campaign deleted, skipping call data sync 2019-07-11 12:08:17.293 (3) [pool-3-thread-56]: Campaign deleted, skipping location data sync 2019-07-11 12:08:17.293 (3) [pool-3-thread-56]: 9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32698_S3 status change (Paused->Deleted) 2019-07-11 12:08:17.293 (3) [pool-3-thread-56]: Campaign deleted, skipping target sync. 2019-07-11 12:08:17.293 (3) [pool-3-thread-56]: Campaign deleted, skipping call data sync 2019-07-11 12:08:17.293 (3) [pool-3-thread-56]: Campaign deleted, skipping location data sync 2019-07-11 12:08:17.293 (3) [pool-3-thread-56]: 9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32698_S4 status change (Paused->Deleted) 2019-07-11 12:08:17.293 (3) [pool-3-thread-56]: Campaign deleted, skipping target sync. 2019-07-11 12:08:17.293 (3) [pool-3-thread-56]: Campaign deleted, skipping call data sync 2019-07-11 12:08:17.293 (3) [pool-3-thread-56]: Campaign deleted, skipping location data sync 2019-07-11 12:08:17.294 (3) [pool-3-thread-56]: 9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32692_GT status change (Paused->Deleted) 2019-07-11 12:08:17.294 (3) [pool-3-thread-56]: Campaign deleted, skipping target sync. 2019-07-11 12:08:17.294 (3) [pool-3-thread-56]: Campaign deleted, skipping call data sync 2019-07-11 12:08:17.294 (3) [pool-3-thread-56]: Campaign deleted, skipping location data sync 2019-07-11 12:08:17.294 (3) [pool-3-thread-56]: 9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32692_GM status change (Paused->Deleted) 2019-07-11 12:08:17.294 (3) [pool-3-thread-56]: Campaign deleted, skipping target sync. 2019-07-11 12:08:17.294 (3) [pool-3-thread-56]: Campaign deleted, skipping call data sync 2019-07-11 12:08:17.294 (3) [pool-3-thread-56]: Campaign deleted, skipping location data sync 2019-07-11 12:08:17.295 (3) [pool-459-thread-1]: Starting Facebook Update Campaign Worker.. 2019-07-11 12:08:17,295 [pool-459-thread-1] INFO c.t.s.f.FacebookAccountDeployer - FBAccountDeployer: updateCampaigns 2019-07-11 12:08:17.296 (3) [pool-459-thread-2]: Starting Google Update Campaign Worker.. 2019-07-11 12:08:17.296 (3) [pool-459-thread-3]: Starting Bing Update Campaign Worker.. 2019-07-11 12:08:17,296 [pool-459-thread-3] INFO c.t.s.bing.BingAccountDeployer - BingAccountDeployer: updateCampaigns 2019-07-11 12:08:17,298 [pool-459-thread-1] INFO jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`id` IN (2691,2692,2693,2694) 2019-07-11 12:08:17,299 [pool-459-thread-3] INFO jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`id` IN (6304,6305) 2019-07-11 12:08:17,308 [pool-459-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Delete request for 9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32698_S1 2019-07-11 12:08:17,308 [pool-459-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Delete request for 9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32698_S2 2019-07-11 12:08:17,308 [pool-459-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Delete request for 9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32698_S3 2019-07-11 12:08:17,308 [pool-459-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Delete request for 9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32698_S4 2019-07-11 12:08:17,308 [pool-459-thread-1] INFO c.t.s.f.FacebookAccountDeployer - accountID 2651: deleting 4 Facebook campaigns 2019-07-11 12:08:17.308 (3) [pool-459-thread-2]: Skipping feed sync 2019-07-11 12:08:17.308 (3) [pool-459-thread-2]: ----------------Google Content Editor starting 2019-07-11 12:08:17,310 [pool-459-thread-3] INFO c.t.s.bing.BingAccountDeployer - Delete request for 9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32692_GT 2019-07-11 12:08:17,310 [pool-459-thread-3] INFO c.t.s.bing.BingAccountDeployer - Delete request for 9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32692_GM 2019-07-11 12:08:17,310 [pool-459-thread-3] INFO c.t.s.bing.BingAccountDeployer - accountID 2651: deleting 2 campaigns 2019-07-11 12:08:17,311 [pool-459-thread-1] INFO c.t.s.c.t.i.s.CampaignServiceClient - Updating TP campaign [ace4acbdbb334a77897f4dcfd47992b3] status to [pause] for account 7e085c22ac9e4529a20f3b4388ebc497 2019-07-11 12:08:17,314 [pool-459-thread-1] INFO o.a.c.i.LoggingOutInterceptor - Outbound Message --------------------------- ID: 826 Address: https://api.tigerpistol.com/v1/campaigns/ace4acbdbb334a77897f4dcfd47992b3/pause Http-Method: POST Content-Type: application/json Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token A5CO5g2RJFRI4w5mWJ32bkCAwQ6mMWo9bHPUWqIC]} -------------------------------------- 2019-07-11 12:08:17,315 [pool-459-thread-3] INFO c.t.s.c.b.impl.BingAdsServiceFactory - USING SANDBOX ENVIRONMENT 2019-07-11 12:08:17,315 [pool-459-thread-3] DEBUG c.t.s.client.bing.impl.BingAdsClient - Created BingAdsClient for 275151922 2019-07-11 12:08:17,315 [pool-459-thread-3] INFO c.t.s.c.b.i.s.CampaignServiceClient - Deleting 2 Bing campaigns from account 275151922 2019-07-11 12:08:17.318 (3) [pool-459-thread-2]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2019-07-11 12:08:17.319 (3) [P134T1]: DistributionServiceRemoteClient created for 9b878d28-1172-4800-8711-a148dad10a9a_2_qa4amltest_Demo_test_10 2019-07-11 12:08:17,320 [pool-459-thread-3] INFO o.a.c.w.s.f.ReflectionServiceFactoryBean - Creating Service {https://bingads.microsoft.com/CampaignManagement/v12}CampaignManagementService from class com.microsoft.bingads.v12.campaignmanagement.ICampaignManagementService 2019-07-11 12:08:17,345 [pool-459-thread-3] INFO o.a.c.w.s.f.ReflectionServiceFactoryBean - Creating Service {https://bingads.microsoft.com/CampaignManagement/v12}CampaignManagementService from class com.microsoft.bingads.v12.campaignmanagement.ICampaignManagementService 2019-07-11 12:08:17,376 [pool-459-thread-3] INFO o.a.c.s.C.I.ICampaignManagementService - Outbound Message --------------------------- ID: 827 Address: https://campaign.api.sandbox.bingads.microsoft.com/Api/Advertiser/CampaignManagement/v12/CampaignManagementService.svc Encoding: UTF-8 Http-Method: POST Content-Type: text/xml Headers: {Accept=[*/*], SOAPAction=[DeleteCampaigns]} Payload: EwAYA3hlBAAUWY3dyHAUGz/vjm4jCptmhWDDEPAAAcVlsenCAwHTgQrUABZDCddeP/r2LfzrlZsfq0HHoKiEIwOw0DAmAEgyZsxLNoxxtjgXuNjHNRGSQCTxdJmsxaz4NzewyRLx1BlywH1++qEPTboBSq+FG8zMo7dLyOIVdxKuQhfmJq61xnQhmLJ73YUOwTylhk91y4LMC4FLxgTvEAXqqpqizKAsxbU/4CUWD3npQ1p4HcTI8gtmTN5nRVmKKqoCJR+N42fByh0gardHY2QCX4EFQIJHHoiVrf8Pmv5i0EGKA0mn7qtOcjS/pmdVebw5oC74NilcXrY90tjK3EjMeNiH+i3Rxm7J2230dUxkWDzBH8p0pNmBdziDdgoDZgAACOOiaUU9hja16AEF/9oTTBLlH0OJ7XxZxEHIEefzRhUEy/NxiZLQTBY2cowBNo9i8c7icknVOU/DTGRAADhe18g96YwQDTmn+r7GR3beER8t2vpAEKBfQxxlKmBbiNb2VeoQrcQFCBr50nzap7kzk8/yrdgBa6vRwRC9NEhFSMjlzKsEA+POVAAWjeuKZbr65ItrwUWN8sB0Rt4lLowmEyNH0ioTqU+5vmVqCAWISQ9jC2XlUz98qD4q3pHivNAsT3YSVzVA7n4kpq0WRBvLWmFE4fDl0kfUVHGXA/iS7TQiPDBizI6oaCBsF4Vc55Lz9JqVFUPs/F0q7T82UX0ox0cl43/622yL3/LoUivc07UV9wqsJ4jgQt/xu3n+Orqkkw6AYbR456sXZllJ4sjFOBjzdwp1jznyer4u+EXfS+xjG6bc0ocv4EFi97se6NSR4mPqMnrDcwhOszffmiV5KfezeLhkuWNN0oLuuIAX4ok1XjwLqf7V5XPU71vhTsIeg9ZyXU3Kh5NseDm5dLiG+m//F1fcegDrKxNzSfHFWr6xmGxTkiq9pU3JiZLL1p+Ue10WMVsWqlfQnfacDCY2Q3jwa+3Zy0gqzejsC+UEHUuxzZQnLt0FWS74SEaOw1LAXenLukHsXeGBW0QHlV9/YNRsvTcC275151922273185235BBD37VB98275151922977181435977181436 -------------------------------------- 2019-07-11 12:08:17.418 (3) [P134T1]: Creating API for reseller DistributionSettings b8a7d340-30e0-4369-97d0-8f901d238f86 2019-07-11 12:08:17.426 (3) [P134T1]: Retrieving credentials for search engine user id : 4103 || client id : 627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com , client secret :uO1pQj_ihl6Jy1fSA7FzCTFE , refresh token : 1/XElVvzhFJlFc7FcqtcZJbj1-erQxMLsEVlrN60XCc4JMrEt0pnthZ_A8mZru5Ei4 2019-07-11 12:08:17,426 [P134T1] INFO c.t.s.o.core.OAuthServiceComponent - [oauth] Return OAuth credential. Access token = ya29.Gl1CB-50UHSR6Ahn6Sj7-7tGHak4BRjuA-2MzHhMQ031cxCOnp9Qv08iNlGVHbrWGSVxBPDclX1r3UTqj_K1w1FY5NVaUBUNFr8KWXKBQVbaQowV7oec0Yy4TB_Dg3I for adwords (clientID=627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com) 2019-07-11 12:08:17.426 (3) [P134T1]: [oauth] Returning access token from OAuth service: ya29.Gl1CB-50UHSR6Ahn6Sj7-7tGHak4BRjuA-2MzHhMQ031cxCOnp9Qv08iNlGVHbrWGSVxBPDclX1r3UTqj_K1w1FY5NVaUBUNFr8KWXKBQVbaQowV7oec0Yy4TB_Dg3I 2019-07-11 12:08:17.426 (3) [P134T1]: Retrieving credentials for search engine user id : 4103 || client id : 627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com , client secret :uO1pQj_ihl6Jy1fSA7FzCTFE , refresh token : 1/XElVvzhFJlFc7FcqtcZJbj1-erQxMLsEVlrN60XCc4JMrEt0pnthZ_A8mZru5Ei4 2019-07-11 12:08:17,426 [P134T1] INFO c.t.s.o.core.OAuthServiceComponent - [oauth] Return OAuth credential. Access token = ya29.Gl1CB-50UHSR6Ahn6Sj7-7tGHak4BRjuA-2MzHhMQ031cxCOnp9Qv08iNlGVHbrWGSVxBPDclX1r3UTqj_K1w1FY5NVaUBUNFr8KWXKBQVbaQowV7oec0Yy4TB_Dg3I for adwords (clientID=627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com) 2019-07-11 12:08:17.426 (3) [P134T1]: [oauth] Returning access token from OAuth service: ya29.Gl1CB-50UHSR6Ahn6Sj7-7tGHak4BRjuA-2MzHhMQ031cxCOnp9Qv08iNlGVHbrWGSVxBPDclX1r3UTqj_K1w1FY5NVaUBUNFr8KWXKBQVbaQowV7oec0Yy4TB_Dg3I 2019-07-11 12:08:17.426 (3) [P134T1]: DistributionServiceRemoteClient created for GMB 2019-07-11 12:08:17.437 (3) [P134T1]: Retrieving GMB credentials for search engine user id : 4103 || client id : 627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com , client secret :uO1pQj_ihl6Jy1fSA7FzCTFE , refresh token : 1/fH9q5og0rO9LI5NBJqM4k_YTHb-0XSo2-Qv53oyo5a0 2019-07-11 12:08:17,437 [P134T1] INFO c.t.s.o.core.OAuthServiceComponent - [oauth] Return OAuth credential. Access token = ya29.Gl1CByXipMArCJHgW0p1Q2Ud30HGUk6EyVOPxFBDe94L-ETIA6JqQjmchR0PLiUVrr8z8RwDFnSN_CYfsZV5MhzYhK6O3hIXw5uBFj-wISGgkfilUupBlcQkRrjPZ08 for gmb (clientID=627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com) 2019-07-11 12:08:17.438 (3) [P134T1]: DistributionServiceRemoteClient created for 9b878d28-1172-4800-8711-a148dad10a9a_2_qa4amltest_Demo_test_10 2019-07-11 12:08:17.531 (3) [P134T1]: Creating API for reseller DistributionSettings b8a7d340-30e0-4369-97d0-8f901d238f86 2019-07-11 12:08:17.532 (3) [P134T1]: Retrieving credentials for search engine user id : 4103 || client id : 627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com , client secret :uO1pQj_ihl6Jy1fSA7FzCTFE , refresh token : 1/XElVvzhFJlFc7FcqtcZJbj1-erQxMLsEVlrN60XCc4JMrEt0pnthZ_A8mZru5Ei4 2019-07-11 12:08:17,532 [P134T1] INFO c.t.s.o.core.OAuthServiceComponent - [oauth] Return OAuth credential. Access token = ya29.Gl1CB-50UHSR6Ahn6Sj7-7tGHak4BRjuA-2MzHhMQ031cxCOnp9Qv08iNlGVHbrWGSVxBPDclX1r3UTqj_K1w1FY5NVaUBUNFr8KWXKBQVbaQowV7oec0Yy4TB_Dg3I for adwords (clientID=627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com) 2019-07-11 12:08:17.532 (3) [P134T1]: [oauth] Returning access token from OAuth service: ya29.Gl1CB-50UHSR6Ahn6Sj7-7tGHak4BRjuA-2MzHhMQ031cxCOnp9Qv08iNlGVHbrWGSVxBPDclX1r3UTqj_K1w1FY5NVaUBUNFr8KWXKBQVbaQowV7oec0Yy4TB_Dg3I 2019-07-11 12:08:17.532 (3) [P134T1]: Retrieving credentials for search engine user id : 4103 || client id : 627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com , client secret :uO1pQj_ihl6Jy1fSA7FzCTFE , refresh token : 1/XElVvzhFJlFc7FcqtcZJbj1-erQxMLsEVlrN60XCc4JMrEt0pnthZ_A8mZru5Ei4 2019-07-11 12:08:17,532 [P134T1] INFO c.t.s.o.core.OAuthServiceComponent - [oauth] Return OAuth credential. Access token = ya29.Gl1CB-50UHSR6Ahn6Sj7-7tGHak4BRjuA-2MzHhMQ031cxCOnp9Qv08iNlGVHbrWGSVxBPDclX1r3UTqj_K1w1FY5NVaUBUNFr8KWXKBQVbaQowV7oec0Yy4TB_Dg3I for adwords (clientID=627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com) 2019-07-11 12:08:17.532 (3) [P134T1]: [oauth] Returning access token from OAuth service: ya29.Gl1CB-50UHSR6Ahn6Sj7-7tGHak4BRjuA-2MzHhMQ031cxCOnp9Qv08iNlGVHbrWGSVxBPDclX1r3UTqj_K1w1FY5NVaUBUNFr8KWXKBQVbaQowV7oec0Yy4TB_Dg3I 2019-07-11 12:08:17.532 (3) [P134T1]: DistributionServiceRemoteClient created for GMB 2019-07-11 12:08:17.543 (3) [P134T1]: Retrieving GMB credentials for search engine user id : 4103 || client id : 627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com , client secret :uO1pQj_ihl6Jy1fSA7FzCTFE , refresh token : 1/fH9q5og0rO9LI5NBJqM4k_YTHb-0XSo2-Qv53oyo5a0 2019-07-11 12:08:17,543 [P134T1] INFO c.t.s.o.core.OAuthServiceComponent - [oauth] Return OAuth credential. Access token = ya29.Gl1CByXipMArCJHgW0p1Q2Ud30HGUk6EyVOPxFBDe94L-ETIA6JqQjmchR0PLiUVrr8z8RwDFnSN_CYfsZV5MhzYhK6O3hIXw5uBFj-wISGgkfilUupBlcQkRrjPZ08 for gmb (clientID=627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com) 2019-07-11 12:08:17.564 (3) [P134T1]: (handleCampaigns - original targets) Network target found: GoogleSearch 2019-07-11 12:08:17.564 (3) [P134T1]: (handleCampaigns - original targets) Network target found: SearchNetwork 2019-07-11 12:08:17.570 (3) [P134T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2019-07-11 12:08:17.571 (3) [P134T1]: (handleCampaigns - original targets) Network target found: GoogleSearch 2019-07-11 12:08:17.571 (3) [P134T1]: (handleCampaigns - original targets) Network target found: SearchNetwork 2019-07-11 12:08:17.572 (3) [P134T1]: CampaignChangeRequest (accountID 2651): Sending 2 update requests 2019-07-11 12:08:17,627 [pool-459-thread-1] INFO o.a.c.i.LoggingInInterceptor - Inbound Message ---------------------------- ID: 826 Response-Code: 200 Encoding: ISO-8859-1 Content-Type: Headers: {api-supported-versions=[1.0], Content-Length=[0], Date=[Thu, 11 Jul 2019 12:08:17 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]} -------------------------------------- 2019-07-11 12:08:17,628 [pool-459-thread-1] INFO c.t.s.c.t.i.s.CampaignServiceClient - Updating TP campaign [e4e9cb564b8647ed86676c947686366e] status to [pause] for account 7e085c22ac9e4529a20f3b4388ebc497 2019-07-11 12:08:17,630 [pool-459-thread-1] INFO o.a.c.i.LoggingOutInterceptor - Outbound Message --------------------------- ID: 828 Address: https://api.tigerpistol.com/v1/campaigns/e4e9cb564b8647ed86676c947686366e/pause Http-Method: POST Content-Type: application/json Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token A5CO5g2RJFRI4w5mWJ32bkCAwQ6mMWo9bHPUWqIC]} -------------------------------------- 2019-07-11 12:08:17,749 [pool-459-thread-3] INFO o.a.c.s.C.I.ICampaignManagementService - Inbound Message ---------------------------- ID: 827 Response-Code: 200 Encoding: UTF-8 Content-Type: text/xml; charset=utf-8 Headers: {Cache-Control=[private], Content-Length=[423], content-type=[text/xml; charset=utf-8], Date=[Thu, 11 Jul 2019 12:08:17 GMT], Server=[Microsoft-IIS/10.0], X-AspNet-Version=[4.0.30319], X-Powered-By=[ASP.NET]} Payload: a7963c8b-8eb5-4604-ad64-b772555b4357 -------------------------------------- 2019-07-11 12:08:17,750 [pool-459-thread-3] INFO c.t.s.c.b.i.s.CampaignServiceClient - Successfully deleted 2/2 Bing campaigns from account 275151922 2019-07-11 12:08:17,750 [pool-459-thread-3] INFO jdbc.sqlonly - DELETE FROM `errors` WHERE `campaignName` IN ('9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32692_GT','9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32692_GM') 2019-07-11 12:08:17,751 [pool-459-thread-3] INFO c.t.s.client.bing.dao.BingErrorDAO - Removed '0' Previous Errors 2019-07-11 12:08:17,751 [pool-459-thread-3] INFO jdbc.sqlonly - DELETE FROM `campaigns` WHERE `campaigns`.`id` = 6304 2019-07-11 12:08:17,752 [pool-459-thread-3] INFO jdbc.sqlonly - DELETE FROM `campaigns` WHERE `campaigns`.`id` = 6305 2019-07-11 12:08:17.755 (3) [pool-459-thread-3]: Completed Bing Update Campaign Worker.. 2019-07-11 12:08:17.838 (3) [Thread-9]: Heartbeat #20125 (1562846897834) received in 0.004s 2019-07-11 12:08:17,877 [P134T1] INFO c.g.a.a.a.l.c.A.requestInfoLogger - Request made: Service: CampaignService Method: mutate clientCustomerId: 5055342850 URL: https://adwords.google.com/api/adwords/cm/v201809/CampaignService Request ID: 00058d66a62cb2a00a56d951f00e948b ResponseTime(ms): 174 OperationsCount: 2 IsFault: false FaultMessage: null 2019-07-11 12:08:17,885 [P134T1] DEBUG c.g.a.a.a.l.c.A.soapXmlLogger - SOAP request: 5055342850 REDACTED AML QA4 (AwApi-Java, AdWords-Axis/4.1.0, Common-Java/4.1.0, Axis/1.4, Java/1.8.0_144, maven) false false SET 2061904764 REMOVED 20371230 SET 2061904767 REMOVED 20371230 2019-07-11 12:08:17,885 [P134T1] DEBUG c.g.a.a.a.l.c.A.soapXmlLogger - SOAP response: 00058d66a62cb2a00a56d951f00e948b CampaignService mutate 2 174 CampaignReturnValue 2061904764 9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32694_GT REMOVED NONE 20190711 20371230 2129745995 9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32694_GT Money 10000 STANDARD true ENABLED false CAMPAIGN_IS_NOT_ACTIVE CONVERSION_TRACKING_NOT_ENABLED OPTIMIZE GeoTargetTypeSetting DONT_CARE DONT_CARE SEARCH true false false false MANUAL_CPC ManualCpcBiddingScheme false BASE 2061904764 2061904767 9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32694_GM REMOVED NONE 20190711 20371230 2129745998 9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32694_GM Money 10000 STANDARD true ENABLED false CAMPAIGN_IS_NOT_ACTIVE CONVERSION_TRACKING_NOT_ENABLED OPTIMIZE GeoTargetTypeSetting DONT_CARE DONT_CARE SEARCH true false false false MANUAL_CPC ManualCpcBiddingScheme false BASE 2061904767 2019-07-11 12:08:17.888 (2) [P134T1]: Unexpected deleted status returned by api. should delete campaign 2019-07-11 12:08:17.890 (2) [P134T1]: Unexpected deleted status returned by api. should delete campaign 2019-07-11 12:08:17.892 (3) [P134T1]: CampaignDAO(accountID 2651) Request contained 0 adds, 2 updates, 0 deletes. 2019-07-11 12:08:17.892 (3) [P134T1]: CampaignDAO(accountID 2651) DB updates: 2 items updated, 2 pending changes deleted, 2 pending updates deleted, 0 errors cleared 2019-07-11 12:08:17.907 (3) [P134T1]: ... SEUser 4103 finished 2019-07-11 12:08:17.907 (3) [pool-459-thread-2]: ------------Google Content Editor done 2019-07-11 12:08:17.913 (3) [pool-459-thread-2]: Completed Google Update Campaign Worker.. 2019-07-11 12:08:17,947 [pool-459-thread-1] INFO o.a.c.i.LoggingInInterceptor - Inbound Message ---------------------------- ID: 828 Response-Code: 200 Encoding: ISO-8859-1 Content-Type: Headers: {api-supported-versions=[1.0], Content-Length=[0], Date=[Thu, 11 Jul 2019 12:08:17 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]} -------------------------------------- 2019-07-11 12:08:17,947 [pool-459-thread-1] INFO c.t.s.c.t.i.s.CampaignServiceClient - Updating TP campaign [b6b7ce94ad4d46e38f0418ea89b1812f] status to [pause] for account 7e085c22ac9e4529a20f3b4388ebc497 2019-07-11 12:08:17,950 [pool-459-thread-1] INFO o.a.c.i.LoggingOutInterceptor - Outbound Message --------------------------- ID: 829 Address: https://api.tigerpistol.com/v1/campaigns/b6b7ce94ad4d46e38f0418ea89b1812f/pause Http-Method: POST Content-Type: application/json Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token A5CO5g2RJFRI4w5mWJ32bkCAwQ6mMWo9bHPUWqIC]} -------------------------------------- 2019-07-11 12:08:18,259 [pool-459-thread-1] INFO o.a.c.i.LoggingInInterceptor - Inbound Message ---------------------------- ID: 829 Response-Code: 200 Encoding: ISO-8859-1 Content-Type: Headers: {api-supported-versions=[1.0], Content-Length=[0], Date=[Thu, 11 Jul 2019 12:08:17 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]} -------------------------------------- 2019-07-11 12:08:18,260 [pool-459-thread-1] INFO c.t.s.c.t.i.s.CampaignServiceClient - Updating TP campaign [2e5b1f8bf81f4acda3633873845303e6] status to [pause] for account 7e085c22ac9e4529a20f3b4388ebc497 2019-07-11 12:08:18,262 [pool-459-thread-1] INFO o.a.c.i.LoggingOutInterceptor - Outbound Message --------------------------- ID: 830 Address: https://api.tigerpistol.com/v1/campaigns/2e5b1f8bf81f4acda3633873845303e6/pause Http-Method: POST Content-Type: application/json Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token A5CO5g2RJFRI4w5mWJ32bkCAwQ6mMWo9bHPUWqIC]} -------------------------------------- 2019-07-11 12:08:18,562 [pool-459-thread-1] INFO o.a.c.i.LoggingInInterceptor - Inbound Message ---------------------------- ID: 830 Response-Code: 200 Encoding: ISO-8859-1 Content-Type: Headers: {api-supported-versions=[1.0], Content-Length=[0], Date=[Thu, 11 Jul 2019 12:08:18 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]} -------------------------------------- 2019-07-11 12:08:18,563 [pool-459-thread-1] INFO jdbc.sqlonly - DELETE FROM `errors` WHERE `elementName` IN ('9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32698_S1','9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32698_S2','9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32698_S3','9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32698_S4') 2019-07-11 12:08:18,564 [pool-459-thread-1] INFO c.t.s.client.tp.dao.TPErrorDAO - Removed '5' Previous Errors 2019-07-11 12:08:18,564 [pool-459-thread-1] INFO jdbc.sqlonly - UPDATE `campaigns` SET `campaigns`.`tpId` = 'b6b7ce94ad4d46e38f0418ea89b1812f', `campaigns`.`name` = '9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32698_S1', `campaigns`.`status` = 'Deleted', `campaigns`.`endDate` = '07/11/2019 12:08:17.308', `campaigns`.`lastUpdated` = NOW(), `campaigns`.`json` = '{"campaign":{"name":"9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32698_S1","status":"Deleted","id":"b6b7ce94ad4d46e38f0418ea89b1812f","customerId":"7e085c22ac9e4529a20f3b4388ebc497","objective":"website_clicks","budget":3125,"start":"2019-07-11T12:01:52.120Z","maxEnd":"2019-07-11T12:08:17.308Z","placement":["desktopfeed","mobilefeed","instagramstream"],"details":{"audiences":[{"ageFrom":18,"ageTo":65,"gender":"all","locationTypes":["home","recent"],"demographics":{"education_majors":["107792185915220","112870968727410"],"behaviors":["6002714895372"],"interests":["6002926108721"],"work_employers":["102662719805111"]},"locations":[{"type":"city","id":"2417653"}]}],"copies":[{"headline":"Find a Hotel","body":"Aliso Viejo Hotel. You''ll Have a Great Stay Here!","description":"Hotel Rooms Aliso Viejo","destinationUrl":"http://www.merchantsite.com/"}],"images":["https://aml-qa.s3.us-west-1.amazonaws.com/usa/10002/images/image-10002-5.jpg"],"cta":[{"type":"learn_more"}]}},"searchEngineUserId":4104}' WHERE `campaigns`.`id` = 2691 2019-07-11 12:08:18,566 [pool-459-thread-1] INFO jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`id` = 2691 2019-07-11 12:08:18,567 [pool-459-thread-1] INFO jdbc.sqlonly - UPDATE `campaigns` SET `campaigns`.`tpId` = 'e4e9cb564b8647ed86676c947686366e', `campaigns`.`name` = '9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32698_S2', `campaigns`.`status` = 'Deleted', `campaigns`.`endDate` = '07/11/2019 12:08:17.308', `campaigns`.`lastUpdated` = NOW(), `campaigns`.`json` = '{"campaign":{"name":"9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32698_S2","status":"Deleted","id":"e4e9cb564b8647ed86676c947686366e","customerId":"7e085c22ac9e4529a20f3b4388ebc497","objective":"website_clicks","budget":3125,"start":"2019-07-11T12:01:52.132Z","maxEnd":"2019-07-11T12:08:17.308Z","placement":["desktopfeed","mobilefeed","instagramstream"],"details":{"audiences":[{"ageFrom":18,"ageTo":65,"gender":"all","locationTypes":["home","recent"],"demographics":{"education_majors":["107792185915220","112870968727410"],"behaviors":["6002714895372"],"interests":["6002926108721"],"work_employers":["102662719805111"]},"locations":[{"type":"city","id":"2417653"}]}],"copies":[{"headline":"Find a Guest Room","body":"Aliso Viejo Hotel Rooms. Find Out Why Guests Love Us!","description":"Hotel Rooms Aliso Viejo","destinationUrl":"http://www.merchantsite.com/"}],"images":["https://aml-qa.s3.us-west-1.amazonaws.com/usa/10002/images/image-10002-4.jpg"],"cta":[{"type":"learn_more"}]}},"searchEngineUserId":4104}' WHERE `campaigns`.`id` = 2692 2019-07-11 12:08:18,568 [pool-459-thread-1] INFO jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`id` = 2692 2019-07-11 12:08:18,569 [pool-459-thread-1] INFO jdbc.sqlonly - UPDATE `campaigns` SET `campaigns`.`tpId` = 'ace4acbdbb334a77897f4dcfd47992b3', `campaigns`.`name` = '9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32698_S3', `campaigns`.`status` = 'Deleted', `campaigns`.`endDate` = '07/11/2019 12:08:17.308', `campaigns`.`lastUpdated` = NOW(), `campaigns`.`json` = '{"campaign":{"name":"9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32698_S3","status":"Deleted","id":"ace4acbdbb334a77897f4dcfd47992b3","customerId":"7e085c22ac9e4529a20f3b4388ebc497","objective":"website_clicks","budget":3125,"start":"2019-07-11T12:01:52.138Z","maxEnd":"2019-07-11T12:08:17.308Z","placement":["desktopfeed","mobilefeed","instagramstream"],"details":{"audiences":[{"ageFrom":18,"ageTo":65,"gender":"all","locationTypes":["home","recent"],"demographics":{"education_majors":["107792185915220","112870968727410"],"behaviors":["6002714895372"],"interests":["6002926108721"],"work_employers":["102662719805111"]},"locations":[{"type":"city","id":"2417653"}]}],"copies":[{"headline":"Hotel Rooms Aliso Viejo","body":"Aliso Viejo Hotel. You''ll Have a Great Stay Here!","description":"Find a Hotel","destinationUrl":"http://www.merchantsite.com/"}],"images":["https://aml-qa.s3.us-west-1.amazonaws.com/usa/10002/images/image-10002-3.jpg"],"cta":[{"type":"learn_more"}]}},"searchEngineUserId":4104}' WHERE `campaigns`.`id` = 2693 2019-07-11 12:08:18,569 [pool-459-thread-1] INFO jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`id` = 2693 2019-07-11 12:08:18,570 [pool-459-thread-1] INFO jdbc.sqlonly - UPDATE `campaigns` SET `campaigns`.`tpId` = '2e5b1f8bf81f4acda3633873845303e6', `campaigns`.`name` = '9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32698_S4', `campaigns`.`status` = 'Deleted', `campaigns`.`endDate` = '07/11/2019 12:08:17.308', `campaigns`.`lastUpdated` = NOW(), `campaigns`.`json` = '{"campaign":{"name":"9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32698_S4","status":"Deleted","id":"2e5b1f8bf81f4acda3633873845303e6","customerId":"7e085c22ac9e4529a20f3b4388ebc497","objective":"website_clicks","budget":3125,"start":"2019-07-11T12:01:52.144Z","maxEnd":"2019-07-11T12:08:17.308Z","placement":["desktopfeed","mobilefeed","instagramstream"],"details":{"audiences":[{"ageFrom":18,"ageTo":65,"gender":"all","locationTypes":["home","recent"],"demographics":{"education_majors":["107792185915220","112870968727410"],"behaviors":["6002714895372"],"interests":["6002926108721"],"work_employers":["102662719805111"]},"locations":[{"type":"city","id":"2417653"}]}],"copies":[{"headline":"Hotel Rooms Aliso Viejo","body":"Aliso Viejo Hotel Rooms. Find Out Why Guests Love Us!","description":"Find a Guest Room","destinationUrl":"http://www.merchantsite.com/"}],"images":["https://aml-qa.s3.us-west-1.amazonaws.com/usa/10002/images/image-10002-2.jpg"],"cta":[{"type":"learn_more"}]}},"searchEngineUserId":4104}' WHERE `campaigns`.`id` = 2694 2019-07-11 12:08:18,571 [pool-459-thread-1] INFO jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`id` = 2694 2019-07-11 12:08:18.573 (3) [pool-459-thread-1]: Completed Facebook Update Campaign Worker.. 2019-07-11 12:08:18.577 (3) [pool-3-thread-56]: 9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32692_GT status updated to Deleted 2019-07-11 12:08:18.578 (3) [pool-3-thread-56]: 9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32692_GM status updated to Deleted 2019-07-11 12:08:18.579 (3) [pool-3-thread-56]: 9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32694_GT status updated to Deleted 2019-07-11 12:08:18.581 (3) [pool-3-thread-56]: 9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32694_GM status updated to Deleted 2019-07-11 12:08:18.582 (3) [pool-3-thread-56]: 9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32698_S1 status updated to Deleted 2019-07-11 12:08:18.583 (3) [pool-3-thread-56]: 9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32698_S2 status updated to Deleted 2019-07-11 12:08:18.585 (3) [pool-3-thread-56]: 9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32698_S3 status updated to Deleted 2019-07-11 12:08:18.586 (3) [pool-3-thread-56]: 9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32698_S4 status updated to Deleted 2019-07-11 12:08:18.586 (3) [pool-3-thread-56]: Campaign structure sync not enabled for this request. 2019-07-11 12:08:18,588 [pool-3-thread-56] INFO jdbc.sqlonly - SELECT `errors`.`errorJson` FROM `campaigns` JOIN `errors` ON `errors`.`campaignName` = `campaigns`.`name` WHERE `campaigns`.`id` IN (6304) 2019-07-11 12:08:18.595 (3) [pool-3-thread-56]: Ignoring 0 other operation errors for deleted campaign. 2019-07-11 12:08:18.595 (3) [pool-3-thread-56]: 32692_GT has no applicable GCE errors. 2019-07-11 12:08:18,598 [pool-3-thread-56] INFO jdbc.sqlonly - SELECT `errors`.`errorJson` FROM `campaigns` JOIN `errors` ON `errors`.`campaignName` = `campaigns`.`name` WHERE `campaigns`.`id` IN (6305) 2019-07-11 12:08:18.600 (3) [pool-3-thread-56]: Ignoring 0 other operation errors for deleted campaign. 2019-07-11 12:08:18.600 (3) [pool-3-thread-56]: 32692_GM has no applicable GCE errors. 2019-07-11 12:08:18,603 [pool-3-thread-56] INFO jdbc.sqlonly - SELECT `errors`.`errorJson` FROM `campaigns` JOIN `errors` ON `errors`.`elementName` = `campaigns`.`name` WHERE `campaigns`.`id` IN (2691) 2019-07-11 12:08:18.605 (3) [pool-3-thread-56]: Ignoring 0 other operation errors for deleted campaign. 2019-07-11 12:08:18.605 (3) [pool-3-thread-56]: 32698_S1 has no applicable GCE errors. 2019-07-11 12:08:18,608 [pool-3-thread-56] INFO jdbc.sqlonly - SELECT `errors`.`errorJson` FROM `campaigns` JOIN `errors` ON `errors`.`elementName` = `campaigns`.`name` WHERE `campaigns`.`id` IN (2692) 2019-07-11 12:08:18.611 (3) [pool-3-thread-56]: Ignoring 0 other operation errors for deleted campaign. 2019-07-11 12:08:18.611 (3) [pool-3-thread-56]: 32698_S2 has no applicable GCE errors. 2019-07-11 12:08:18,614 [pool-3-thread-56] INFO jdbc.sqlonly - SELECT `errors`.`errorJson` FROM `campaigns` JOIN `errors` ON `errors`.`elementName` = `campaigns`.`name` WHERE `campaigns`.`id` IN (2693) 2019-07-11 12:08:18.616 (3) [pool-3-thread-56]: Ignoring 0 other operation errors for deleted campaign. 2019-07-11 12:08:18.616 (3) [pool-3-thread-56]: 32698_S3 has no applicable GCE errors. 2019-07-11 12:08:18,620 [pool-3-thread-56] INFO jdbc.sqlonly - SELECT `errors`.`errorJson` FROM `campaigns` JOIN `errors` ON `errors`.`elementName` = `campaigns`.`name` WHERE `campaigns`.`id` IN (2694) 2019-07-11 12:08:18.622 (3) [pool-3-thread-56]: Ignoring 0 other operation errors for deleted campaign. 2019-07-11 12:08:18.622 (3) [pool-3-thread-56]: 32698_S4 has no applicable GCE errors. 2019-07-11 12:08:18.640 (3) [pool-3-thread-56]: Ignoring 0 other operation errors for deleted campaign. 2019-07-11 12:08:18.640 (3) [pool-3-thread-56]: 32694_GT has no applicable GCE errors. 2019-07-11 12:08:18.644 (3) [pool-3-thread-56]: Ignoring 0 other operation errors for deleted campaign. 2019-07-11 12:08:18.644 (3) [pool-3-thread-56]: 32694_GM has no applicable GCE errors. 2019-07-11 12:08:18.646 (3) [pool-3-thread-56]: Finished UPDATE request for campaign 9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32698_S1: SUCCEEDED (merchant: 9b878d28-1172-4800-8711-a148dad10a9a) 2019-07-11 12:08:18.646 (3) [pool-3-thread-56]: Finished UPDATE request for campaign 9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32698_S2: SUCCEEDED (merchant: 9b878d28-1172-4800-8711-a148dad10a9a) 2019-07-11 12:08:18.647 (3) [pool-3-thread-56]: Finished UPDATE request for campaign 9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32698_S3: SUCCEEDED (merchant: 9b878d28-1172-4800-8711-a148dad10a9a) 2019-07-11 12:08:18.647 (3) [pool-3-thread-56]: Finished UPDATE request for campaign 9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32698_S4: SUCCEEDED (merchant: 9b878d28-1172-4800-8711-a148dad10a9a) 2019-07-11 12:08:18.648 (3) [pool-3-thread-56]: Finished UPDATE request for campaign 9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32694_GM: SUCCEEDED (merchant: 9b878d28-1172-4800-8711-a148dad10a9a) 2019-07-11 12:08:18.649 (3) [pool-3-thread-56]: Finished UPDATE request for campaign 9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32694_GT: SUCCEEDED (merchant: 9b878d28-1172-4800-8711-a148dad10a9a) 2019-07-11 12:08:18.649 (3) [pool-3-thread-56]: Finished UPDATE request for campaign 9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32692_GM: SUCCEEDED (merchant: 9b878d28-1172-4800-8711-a148dad10a9a) 2019-07-11 12:08:18.650 (3) [pool-3-thread-56]: Finished UPDATE request for campaign 9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32692_GT: SUCCEEDED (merchant: 9b878d28-1172-4800-8711-a148dad10a9a) 2019-07-11 12:08:18.650 (3) [pool-3-thread-56]: 9b878d28-1172-4800-8711-a148dad10a9a has 0 campaigns for a SE Update accounts sync. 2019-07-11 12:08:18.650 (3) [pool-3-thread-56]: 9b878d28-1172-4800-8711-a148dad10a9a has 0 campaigns for a SE Update groups-listings sync. 2019-07-11 12:08:18.650 (3) [pool-3-thread-56]: Finished sub-campaign processing for UPDATE deploymentID (3fd81bc3-c200-410a-8263-d9618a74cc0e). account 9b878d28-1172-4800-8711-a148dad10a9a. 8 submitted, 8 ok. 2019-07-11 12:08:18.650 (3) [pool-3-thread-56]: Updating deployment status to 'Success' for campaignID: 32698 2019-07-11 12:08:18.651 (3) [pool-3-thread-56]: Finished UPDATE request for 32698: SUCCEEDED (merchant: 9b878d28-1172-4800-8711-a148dad10a9a) 2019-07-11 12:08:18.651 (3) [pool-3-thread-56]: Updating deployment status to 'Success' for campaignID: 32694 2019-07-11 12:08:18.652 (3) [pool-3-thread-56]: Finished UPDATE request for 32694: SUCCEEDED (merchant: 9b878d28-1172-4800-8711-a148dad10a9a) 2019-07-11 12:08:18.652 (3) [pool-3-thread-56]: Updating deployment status to 'Success' for campaignID: 32692 2019-07-11 12:08:18.652 (3) [pool-3-thread-56]: Finished UPDATE request for 32692: SUCCEEDED (merchant: 9b878d28-1172-4800-8711-a148dad10a9a) 2019-07-11 12:08:18.652 (3) [pool-3-thread-56]: Finished UPDATE request, deploymentID (3fd81bc3-c200-410a-8263-d9618a74cc0e), account 9b878d28-1172-4800-8711-a148dad10a9a 2019-07-11 12:08:18.652 (3) [pool-3-thread-56]: Request removed from map for customerID 9b878d28-1172-4800-8711-a148dad10a9a 2019-07-11 12:08:18.918 (3) [AdMaxListener]: Sent message to response queue. 2019-07-11 12:08:20.730 (3) [Thread-9]: Request added to map for customerID 9b878d28-1172-4800-8711-a148dad10a9a 2019-07-11 12:08:20.730 (3) [Thread-9]: Request worker created for 9b878d28-1172-4800-8711-a148dad10a9a 2019-07-11 12:08:20.730 (3) [Thread-9]: Submitted executor job for 9b878d28-1172-4800-8711-a148dad10a9a 2019-07-11 12:08:20.752 (3) [pool-3-thread-56]: Updating account tables for 9b878d28-1172-4800-8711-a148dad10a9a 2019-07-11 12:08:20.759 (3) [pool-3-thread-56]: Committing Account settings for 2651 2019-07-11 12:08:20.762 (3) [pool-3-thread-56]: Updating deployment status to 'InProgress' for campaignID: 32705 2019-07-11 12:08:20.763 (3) [pool-3-thread-56]: 32705 has no parent. Creating... 2019-07-11 12:08:20.767 (3) [pool-3-thread-56]: Updating advert budget for 9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32705 2019-07-11 12:08:20.791 (3) [pool-3-thread-56]: Start processing DEPLOY request (3fd81bc3-c200-410a-8263-d9618a74cc0e) for account 9b878d28-1172-4800-8711-a148dad10a9a. 4 campaign(s). 2019-07-11 12:08:20.791 (3) [pool-3-thread-56]: Performing sync for account: 9b878d28-1172-4800-8711-a148dad10a9a ID#2651 2019-07-11 12:08:20.797 (3) [pool-3-thread-56]: 0 campaign(s) to update. 2019-07-11 12:08:20.797 (3) [pool-3-thread-56]: 4 campaign(s) to create. 2019-07-11 12:08:20.797 (3) [pool-3-thread-56]: 0 campaign(s) to retry and update. 2019-07-11 12:08:20.800 (3) [pool-3-thread-56]: 9b878d28-1172-4800-8711-a148dad10a9a has 4 new campaign(s) for Facebook. 2019-07-11 12:08:20.800 (3) [pool-3-thread-56]: 9b878d28-1172-4800-8711-a148dad10a9a has 1 available users with 10000 available campaign slots. 2019-07-11 12:08:20.800 (3) [pool-3-thread-56]: Assigned existing seUserID: 4104 to: 9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32705_S1 2019-07-11 12:08:20.800 (3) [pool-3-thread-56]: Assigned existing seUserID: 4104 to: 9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32705_S2 2019-07-11 12:08:20.800 (3) [pool-3-thread-56]: Assigned existing seUserID: 4104 to: 9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32705_S3 2019-07-11 12:08:20.800 (3) [pool-3-thread-56]: Assigned existing seUserID: 4104 to: 9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32705_S4 2019-07-11 12:08:20.800 (3) [pool-3-thread-56]: Assigned 4 campaigns to: 1 existing user(s). 2019-07-11 12:08:20.805 (3) [pool-3-thread-56]: Creating 4 new campaign(s). 2019-07-11 12:08:20.805 (3) [pool-3-thread-56]: CampaignWorker initialized for account: 2651 2019-07-11 12:08:20.805 (3) [pool-3-thread-56]: Creating 9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32705_S1 Status: Paused 2019-07-11 12:08:20.805 (3) [pool-3-thread-56]: Creating 9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32705_S2 Status: Paused 2019-07-11 12:08:20.805 (3) [pool-3-thread-56]: Creating 9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32705_S3 Status: Paused 2019-07-11 12:08:20.805 (3) [pool-3-thread-56]: Creating 9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32705_S4 Status: Paused 2019-07-11 12:08:20.805 (3) [pool-3-thread-56]: CampaignWorker started for account: 2651 2019-07-11 12:08:20,888 [pool-3-thread-56] DEBUG c.t.s.facebook.FacebookApiUtils - Getting FB properties using distribution service 2019-07-11 12:08:20.889 (3) [pool-463-thread-1]: Starting Facebook Create Campaign Worker.. 2019-07-11 12:08:20,889 [pool-463-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Creating Facebook campaign structure for accountID 2651 2019-07-11 12:08:20,889 [pool-463-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Facebook campaign startDate:2019-07-11T08:08:20.889-04:00 America/New_York 2019-07-11 12:08:20,889 [pool-463-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Facebook campaign endDate:2019-08-10T23:59:59.999-04:00 America/New_York 2019-07-11 12:08:20,889 [pool-463-thread-1] INFO c.t.s.f.FacebookAccountDeployer - finding carryover for seuserID 4104 2019-07-11 12:08:20,896 [pool-463-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` = 4104 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-07-11 12:08:20,901 [pool-463-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Found campaign carryover data for seuserID 4104, carryover data ([TPCampaignCarryoverDTO [theID=9305, theCampaignID=2694, theDate=2019-07-11, theDedicatedCarryover=0.0, thePooledCarryover=0.0, theCarryoverType=normal], TPCampaignCarryoverDTO [theID=9304, theCampaignID=2693, theDate=2019-07-11, theDedicatedCarryover=0.0, thePooledCarryover=0.0, theCarryoverType=normal], TPCampaignCarryoverDTO [theID=9303, theCampaignID=2692, theDate=2019-07-11, theDedicatedCarryover=0.0, thePooledCarryover=0.0, theCarryoverType=normal], TPCampaignCarryoverDTO [theID=9302, theCampaignID=2691, theDate=2019-07-11, theDedicatedCarryover=0.0, thePooledCarryover=0.0, theCarryoverType=normal]]) 2019-07-11 12:08:20,901 [pool-463-thread-1] INFO c.t.s.f.FacebookAccountDeployer - totalPooledCarryover for seuserID 4104 and date 2019-07-11 is 0.0 USD 2019-07-11 12:08:20,901 [pool-463-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Individual campaign carryover for seuserID 4104 and date 2019-07-11 is 0.0 USD 2019-07-11 12:08:20,901 [pool-463-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Facebook campaign nominal monthly budget : 3625 2019-07-11 12:08:20,901 [pool-463-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Facebook campaign carryover : 0.0 2019-07-11 12:08:20,901 [pool-463-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Facebook campaign actual monthly budget : 3625 2019-07-11 12:08:20,902 [pool-463-thread-1] INFO c.t.s.f.FacebookAccountStructureMapper - TPCampaignTargets [[TPLocation [theType=city, theId=2417653, theAddress=null, theLatitude=null, theLongitude=null, theRadius=null, theRadiusUnit=null]]] 2019-07-11 12:08:20,902 [pool-463-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Facebook campaign startDate:2019-07-11T08:08:20.902-04:00 America/New_York 2019-07-11 12:08:20,902 [pool-463-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Facebook campaign endDate:2019-08-10T23:59:59.999-04:00 America/New_York 2019-07-11 12:08:20,902 [pool-463-thread-1] INFO c.t.s.f.FacebookAccountDeployer - finding carryover for seuserID 4104 2019-07-11 12:08:20,905 [pool-463-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` = 4104 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-07-11 12:08:20,907 [pool-463-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Found campaign carryover data for seuserID 4104, carryover data ([TPCampaignCarryoverDTO [theID=9305, theCampaignID=2694, theDate=2019-07-11, theDedicatedCarryover=0.0, thePooledCarryover=0.0, theCarryoverType=normal], TPCampaignCarryoverDTO [theID=9304, theCampaignID=2693, theDate=2019-07-11, theDedicatedCarryover=0.0, thePooledCarryover=0.0, theCarryoverType=normal], TPCampaignCarryoverDTO [theID=9303, theCampaignID=2692, theDate=2019-07-11, theDedicatedCarryover=0.0, thePooledCarryover=0.0, theCarryoverType=normal], TPCampaignCarryoverDTO [theID=9302, theCampaignID=2691, theDate=2019-07-11, theDedicatedCarryover=0.0, thePooledCarryover=0.0, theCarryoverType=normal]]) 2019-07-11 12:08:20,907 [pool-463-thread-1] INFO c.t.s.f.FacebookAccountDeployer - totalPooledCarryover for seuserID 4104 and date 2019-07-11 is 0.0 USD 2019-07-11 12:08:20,907 [pool-463-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Individual campaign carryover for seuserID 4104 and date 2019-07-11 is 0.0 USD 2019-07-11 12:08:20,907 [pool-463-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Facebook campaign nominal monthly budget : 3625 2019-07-11 12:08:20,907 [pool-463-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Facebook campaign carryover : 0.0 2019-07-11 12:08:20,907 [pool-463-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Facebook campaign actual monthly budget : 3625 2019-07-11 12:08:20,909 [pool-463-thread-1] INFO c.t.s.f.FacebookAccountStructureMapper - TPCampaignTargets [[TPLocation [theType=city, theId=2417653, theAddress=null, theLatitude=null, theLongitude=null, theRadius=null, theRadiusUnit=null]]] 2019-07-11 12:08:20,909 [pool-463-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Facebook campaign startDate:2019-07-11T08:08:20.909-04:00 America/New_York 2019-07-11 12:08:20,909 [pool-463-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Facebook campaign endDate:2019-08-10T23:59:59.999-04:00 America/New_York 2019-07-11 12:08:20,909 [pool-463-thread-1] INFO c.t.s.f.FacebookAccountDeployer - finding carryover for seuserID 4104 2019-07-11 12:08:20,912 [pool-463-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` = 4104 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-07-11 12:08:20,914 [pool-463-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Found campaign carryover data for seuserID 4104, carryover data ([TPCampaignCarryoverDTO [theID=9305, theCampaignID=2694, theDate=2019-07-11, theDedicatedCarryover=0.0, thePooledCarryover=0.0, theCarryoverType=normal], TPCampaignCarryoverDTO [theID=9304, theCampaignID=2693, theDate=2019-07-11, theDedicatedCarryover=0.0, thePooledCarryover=0.0, theCarryoverType=normal], TPCampaignCarryoverDTO [theID=9303, theCampaignID=2692, theDate=2019-07-11, theDedicatedCarryover=0.0, thePooledCarryover=0.0, theCarryoverType=normal], TPCampaignCarryoverDTO [theID=9302, theCampaignID=2691, theDate=2019-07-11, theDedicatedCarryover=0.0, thePooledCarryover=0.0, theCarryoverType=normal]]) 2019-07-11 12:08:20,915 [pool-463-thread-1] INFO c.t.s.f.FacebookAccountDeployer - totalPooledCarryover for seuserID 4104 and date 2019-07-11 is 0.0 USD 2019-07-11 12:08:20,915 [pool-463-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Individual campaign carryover for seuserID 4104 and date 2019-07-11 is 0.0 USD 2019-07-11 12:08:20,915 [pool-463-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Facebook campaign nominal monthly budget : 3625 2019-07-11 12:08:20,915 [pool-463-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Facebook campaign carryover : 0.0 2019-07-11 12:08:20,915 [pool-463-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Facebook campaign actual monthly budget : 3625 2019-07-11 12:08:20,916 [pool-463-thread-1] INFO c.t.s.f.FacebookAccountStructureMapper - TPCampaignTargets [[TPLocation [theType=city, theId=2417653, theAddress=null, theLatitude=null, theLongitude=null, theRadius=null, theRadiusUnit=null]]] 2019-07-11 12:08:20,916 [pool-463-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Facebook campaign startDate:2019-07-11T08:08:20.916-04:00 America/New_York 2019-07-11 12:08:20,916 [pool-463-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Facebook campaign endDate:2019-08-10T23:59:59.999-04:00 America/New_York 2019-07-11 12:08:20,916 [pool-463-thread-1] INFO c.t.s.f.FacebookAccountDeployer - finding carryover for seuserID 4104 2019-07-11 12:08:20,919 [pool-463-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` = 4104 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-07-11 12:08:20,921 [pool-463-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Found campaign carryover data for seuserID 4104, carryover data ([TPCampaignCarryoverDTO [theID=9305, theCampaignID=2694, theDate=2019-07-11, theDedicatedCarryover=0.0, thePooledCarryover=0.0, theCarryoverType=normal], TPCampaignCarryoverDTO [theID=9304, theCampaignID=2693, theDate=2019-07-11, theDedicatedCarryover=0.0, thePooledCarryover=0.0, theCarryoverType=normal], TPCampaignCarryoverDTO [theID=9303, theCampaignID=2692, theDate=2019-07-11, theDedicatedCarryover=0.0, thePooledCarryover=0.0, theCarryoverType=normal], TPCampaignCarryoverDTO [theID=9302, theCampaignID=2691, theDate=2019-07-11, theDedicatedCarryover=0.0, thePooledCarryover=0.0, theCarryoverType=normal]]) 2019-07-11 12:08:20,921 [pool-463-thread-1] INFO c.t.s.f.FacebookAccountDeployer - totalPooledCarryover for seuserID 4104 and date 2019-07-11 is 0.0 USD 2019-07-11 12:08:20,921 [pool-463-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Individual campaign carryover for seuserID 4104 and date 2019-07-11 is 0.0 USD 2019-07-11 12:08:20,921 [pool-463-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Facebook campaign nominal monthly budget : 3625 2019-07-11 12:08:20,921 [pool-463-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Facebook campaign carryover : 0.0 2019-07-11 12:08:20,922 [pool-463-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Facebook campaign actual monthly budget : 3625 2019-07-11 12:08:20,923 [pool-463-thread-1] INFO c.t.s.f.FacebookAccountStructureMapper - TPCampaignTargets [[TPLocation [theType=city, theId=2417653, theAddress=null, theLatitude=null, theLongitude=null, theRadius=null, theRadiusUnit=null]]] 2019-07-11 12:08:20,927 [pool-463-thread-1] INFO c.t.s.c.t.i.s.CampaignServiceClient - Adding TP campaign [9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32705_S1] to account 7e085c22ac9e4529a20f3b4388ebc497 2019-07-11 12:08:20,933 [pool-463-thread-1] INFO o.a.c.i.LoggingOutInterceptor - Outbound Message --------------------------- ID: 831 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" : "9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32705_S1", "status" : "Active", "customerId" : "7e085c22ac9e4529a20f3b4388ebc497", "objective" : "website_clicks", "budget" : 3625, "start" : "2019-07-11T12:08:20.889Z", "maxEnd" : "2019-08-11T03:59:59.999Z", "placement" : [ "desktopfeed", "mobilefeed", "instagramstream" ], "details" : { "audiences" : [ { "ageFrom" : 18, "ageTo" : 65, "gender" : "all", "locationTypes" : [ "home", "recent" ], "demographics" : { "education_majors" : [ "107792185915220", "112870968727410" ], "behaviors" : [ "6002714895372" ], "interests" : [ "6002926108721" ], "work_employers" : [ "102662719805111" ] }, "locations" : [ { "type" : "city", "id" : "2417653" } ] } ], "copies" : [ { "headline" : "Find a Hotel", "body" : "Aliso Viejo Hotel. You'll Have a Great Stay Here!", "description" : "Hotel Rooms Aliso Viejo", "destinationUrl" : "http://www.merchantsite.com/" } ], "images" : [ "https://aml-qa.s3.us-west-1.amazonaws.com/usa/10002/images/image-10002-5.jpg" ], "cta" : [ { "type" : "learn_more" } ] } } -------------------------------------- 2019-07-11 12:08:23,405 [pool-463-thread-1] INFO o.a.c.i.LoggingInInterceptor - Inbound Message ---------------------------- ID: 831 Response-Code: 201 Encoding: UTF-8 Content-Type: application/json; charset=utf-8 Headers: {api-supported-versions=[1.0], Content-Length=[690], content-type=[application/json; charset=utf-8], Date=[Thu, 11 Jul 2019 12:08:23 GMT], Location=[https://api.tigerpistol.com/v1/campaigns/32b65fb2-2cb0-42f1-a261-2bb599a049c9], 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}],"leadEmailAddresses":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":"32b65fb22cb042f1a2612bb599a049c9","customerId":"7e085c22ac9e4529a20f3b4388ebc497","name":"9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32705_S1","start":"2019-07-11T12:08:00+00:00","end":"2019-08-11T03:59:00+00:00","budget":3625.00,"objective":"website_clicks","status":"live","publishPhase":"complete","errorMessage":""} -------------------------------------- 2019-07-11 12:08:23,406 [pool-463-thread-1] INFO c.t.s.c.t.i.s.CampaignServiceClient - Updating TP campaign [32b65fb22cb042f1a2612bb599a049c9] status to [resume] for account 7e085c22ac9e4529a20f3b4388ebc497 2019-07-11 12:08:23,408 [pool-463-thread-1] INFO o.a.c.i.LoggingOutInterceptor - Outbound Message --------------------------- ID: 832 Address: https://api.tigerpistol.com/v1/campaigns/32b65fb22cb042f1a2612bb599a049c9/resume Http-Method: POST Content-Type: application/json Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token A5CO5g2RJFRI4w5mWJ32bkCAwQ6mMWo9bHPUWqIC]} -------------------------------------- 2019-07-11 12:08:23,714 [pool-463-thread-1] INFO o.a.c.i.LoggingInInterceptor - Inbound Message ---------------------------- ID: 832 Response-Code: 200 Encoding: ISO-8859-1 Content-Type: Headers: {api-supported-versions=[1.0], Content-Length=[0], Date=[Thu, 11 Jul 2019 12:08:23 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]} -------------------------------------- 2019-07-11 12:08:23,714 [pool-463-thread-1] INFO c.t.s.c.t.i.s.CampaignServiceClient - Adding TP campaign [9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32705_S2] to account 7e085c22ac9e4529a20f3b4388ebc497 2019-07-11 12:08:23,719 [pool-463-thread-1] INFO o.a.c.i.LoggingOutInterceptor - Outbound Message --------------------------- ID: 833 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" : "9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32705_S2", "status" : "Active", "customerId" : "7e085c22ac9e4529a20f3b4388ebc497", "objective" : "website_clicks", "budget" : 3625, "start" : "2019-07-11T12:08:20.902Z", "maxEnd" : "2019-08-11T03:59:59.999Z", "placement" : [ "desktopfeed", "mobilefeed", "instagramstream" ], "details" : { "audiences" : [ { "ageFrom" : 18, "ageTo" : 65, "gender" : "all", "locationTypes" : [ "home", "recent" ], "demographics" : { "education_majors" : [ "107792185915220", "112870968727410" ], "behaviors" : [ "6002714895372" ], "interests" : [ "6002926108721" ], "work_employers" : [ "102662719805111" ] }, "locations" : [ { "type" : "city", "id" : "2417653" } ] } ], "copies" : [ { "headline" : "Find a Guest Room", "body" : "Aliso Viejo Hotel Rooms. Find Out Why Guests Love Us!", "description" : "Hotel Rooms Aliso Viejo", "destinationUrl" : "http://www.merchantsite.com/" } ], "images" : [ "https://aml-qa.s3.us-west-1.amazonaws.com/usa/10002/images/image-10002-4.jpg" ], "cta" : [ { "type" : "learn_more" } ] } } -------------------------------------- 2019-07-11 12:08:25,946 [pool-463-thread-1] INFO o.a.c.i.LoggingInInterceptor - Inbound Message ---------------------------- ID: 833 Response-Code: 201 Encoding: UTF-8 Content-Type: application/json; charset=utf-8 Headers: {api-supported-versions=[1.0], Content-Length=[690], content-type=[application/json; charset=utf-8], Date=[Thu, 11 Jul 2019 12:08:25 GMT], Location=[https://api.tigerpistol.com/v1/campaigns/75cf60f4-d136-44f4-a47c-b48ec86d0545], 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}],"leadEmailAddresses":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":"75cf60f4d13644f4a47cb48ec86d0545","customerId":"7e085c22ac9e4529a20f3b4388ebc497","name":"9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32705_S2","start":"2019-07-11T12:08:00+00:00","end":"2019-08-11T03:59:00+00:00","budget":3625.00,"objective":"website_clicks","status":"live","publishPhase":"complete","errorMessage":""} -------------------------------------- 2019-07-11 12:08:25,947 [pool-463-thread-1] INFO c.t.s.c.t.i.s.CampaignServiceClient - Updating TP campaign [75cf60f4d13644f4a47cb48ec86d0545] status to [resume] for account 7e085c22ac9e4529a20f3b4388ebc497 2019-07-11 12:08:25,949 [pool-463-thread-1] INFO o.a.c.i.LoggingOutInterceptor - Outbound Message --------------------------- ID: 834 Address: https://api.tigerpistol.com/v1/campaigns/75cf60f4d13644f4a47cb48ec86d0545/resume Http-Method: POST Content-Type: application/json Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token A5CO5g2RJFRI4w5mWJ32bkCAwQ6mMWo9bHPUWqIC]} -------------------------------------- 2019-07-11 12:08:26,296 [pool-463-thread-1] INFO o.a.c.i.LoggingInInterceptor - Inbound Message ---------------------------- ID: 834 Response-Code: 200 Encoding: ISO-8859-1 Content-Type: Headers: {api-supported-versions=[1.0], Content-Length=[0], Date=[Thu, 11 Jul 2019 12:08:25 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]} -------------------------------------- 2019-07-11 12:08:26,296 [pool-463-thread-1] INFO c.t.s.c.t.i.s.CampaignServiceClient - Adding TP campaign [9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32705_S3] to account 7e085c22ac9e4529a20f3b4388ebc497 2019-07-11 12:08:26,301 [pool-463-thread-1] INFO o.a.c.i.LoggingOutInterceptor - Outbound Message --------------------------- ID: 835 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" : "9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32705_S3", "status" : "Active", "customerId" : "7e085c22ac9e4529a20f3b4388ebc497", "objective" : "website_clicks", "budget" : 3625, "start" : "2019-07-11T12:08:20.909Z", "maxEnd" : "2019-08-11T03:59:59.999Z", "placement" : [ "desktopfeed", "mobilefeed", "instagramstream" ], "details" : { "audiences" : [ { "ageFrom" : 18, "ageTo" : 65, "gender" : "all", "locationTypes" : [ "home", "recent" ], "demographics" : { "education_majors" : [ "107792185915220", "112870968727410" ], "behaviors" : [ "6002714895372" ], "interests" : [ "6002926108721" ], "work_employers" : [ "102662719805111" ] }, "locations" : [ { "type" : "city", "id" : "2417653" } ] } ], "copies" : [ { "headline" : "Hotel Rooms Aliso Viejo", "body" : "Aliso Viejo Hotel. You'll Have a Great Stay Here!", "description" : "Find a Hotel", "destinationUrl" : "http://www.merchantsite.com/" } ], "images" : [ "https://aml-qa.s3.us-west-1.amazonaws.com/usa/10002/images/image-10002-3.jpg" ], "cta" : [ { "type" : "learn_more" } ] } } -------------------------------------- 2019-07-11 12:08:28,383 [pool-463-thread-1] INFO o.a.c.i.LoggingInInterceptor - Inbound Message ---------------------------- ID: 835 Response-Code: 201 Encoding: UTF-8 Content-Type: application/json; charset=utf-8 Headers: {api-supported-versions=[1.0], Content-Length=[690], content-type=[application/json; charset=utf-8], Date=[Thu, 11 Jul 2019 12:08:27 GMT], Location=[https://api.tigerpistol.com/v1/campaigns/16b1b635-671a-42fb-805d-bc7d1353f60a], 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}],"leadEmailAddresses":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":"16b1b635671a42fb805dbc7d1353f60a","customerId":"7e085c22ac9e4529a20f3b4388ebc497","name":"9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32705_S3","start":"2019-07-11T12:08:00+00:00","end":"2019-08-11T03:59:00+00:00","budget":3625.00,"objective":"website_clicks","status":"live","publishPhase":"complete","errorMessage":""} -------------------------------------- 2019-07-11 12:08:28,384 [pool-463-thread-1] INFO c.t.s.c.t.i.s.CampaignServiceClient - Updating TP campaign [16b1b635671a42fb805dbc7d1353f60a] status to [resume] for account 7e085c22ac9e4529a20f3b4388ebc497 2019-07-11 12:08:28,387 [pool-463-thread-1] INFO o.a.c.i.LoggingOutInterceptor - Outbound Message --------------------------- ID: 836 Address: https://api.tigerpistol.com/v1/campaigns/16b1b635671a42fb805dbc7d1353f60a/resume Http-Method: POST Content-Type: application/json Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token A5CO5g2RJFRI4w5mWJ32bkCAwQ6mMWo9bHPUWqIC]} -------------------------------------- 2019-07-11 12:08:28,693 [pool-463-thread-1] INFO o.a.c.i.LoggingInInterceptor - Inbound Message ---------------------------- ID: 836 Response-Code: 200 Encoding: ISO-8859-1 Content-Type: Headers: {api-supported-versions=[1.0], Content-Length=[0], Date=[Thu, 11 Jul 2019 12:08:28 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]} -------------------------------------- 2019-07-11 12:08:28,694 [pool-463-thread-1] INFO c.t.s.c.t.i.s.CampaignServiceClient - Adding TP campaign [9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32705_S4] to account 7e085c22ac9e4529a20f3b4388ebc497 2019-07-11 12:08:28,699 [pool-463-thread-1] INFO o.a.c.i.LoggingOutInterceptor - Outbound Message --------------------------- ID: 837 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" : "9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32705_S4", "status" : "Active", "customerId" : "7e085c22ac9e4529a20f3b4388ebc497", "objective" : "website_clicks", "budget" : 3625, "start" : "2019-07-11T12:08:20.916Z", "maxEnd" : "2019-08-11T03:59:59.999Z", "placement" : [ "desktopfeed", "mobilefeed", "instagramstream" ], "details" : { "audiences" : [ { "ageFrom" : 18, "ageTo" : 65, "gender" : "all", "locationTypes" : [ "home", "recent" ], "demographics" : { "education_majors" : [ "107792185915220", "112870968727410" ], "behaviors" : [ "6002714895372" ], "interests" : [ "6002926108721" ], "work_employers" : [ "102662719805111" ] }, "locations" : [ { "type" : "city", "id" : "2417653" } ] } ], "copies" : [ { "headline" : "Hotel Rooms Aliso Viejo", "body" : "Aliso Viejo Hotel Rooms. Find Out Why Guests Love Us!", "description" : "Find a Guest Room", "destinationUrl" : "http://www.merchantsite.com/" } ], "images" : [ "https://aml-qa.s3.us-west-1.amazonaws.com/usa/10002/images/image-10002-2.jpg" ], "cta" : [ { "type" : "learn_more" } ] } } -------------------------------------- 2019-07-11 12:08:30,529 [pool-463-thread-1] INFO o.a.c.i.LoggingInInterceptor - Inbound Message ---------------------------- ID: 837 Response-Code: 201 Encoding: UTF-8 Content-Type: application/json; charset=utf-8 Headers: {api-supported-versions=[1.0], Content-Length=[690], content-type=[application/json; charset=utf-8], Date=[Thu, 11 Jul 2019 12:08:29 GMT], Location=[https://api.tigerpistol.com/v1/campaigns/53eb8472-3f3b-41db-95ab-60f78ce090ae], 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}],"leadEmailAddresses":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":"53eb84723f3b41db95ab60f78ce090ae","customerId":"7e085c22ac9e4529a20f3b4388ebc497","name":"9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32705_S4","start":"2019-07-11T12:08:00+00:00","end":"2019-08-11T03:59:00+00:00","budget":3625.00,"objective":"website_clicks","status":"live","publishPhase":"complete","errorMessage":""} -------------------------------------- 2019-07-11 12:08:30,530 [pool-463-thread-1] INFO c.t.s.c.t.i.s.CampaignServiceClient - Updating TP campaign [53eb84723f3b41db95ab60f78ce090ae] status to [resume] for account 7e085c22ac9e4529a20f3b4388ebc497 2019-07-11 12:08:30,533 [pool-463-thread-1] INFO o.a.c.i.LoggingOutInterceptor - Outbound Message --------------------------- ID: 838 Address: https://api.tigerpistol.com/v1/campaigns/53eb84723f3b41db95ab60f78ce090ae/resume Http-Method: POST Content-Type: application/json Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token A5CO5g2RJFRI4w5mWJ32bkCAwQ6mMWo9bHPUWqIC]} -------------------------------------- 2019-07-11 12:08:30,843 [pool-463-thread-1] INFO o.a.c.i.LoggingInInterceptor - Inbound Message ---------------------------- ID: 838 Response-Code: 200 Encoding: ISO-8859-1 Content-Type: Headers: {api-supported-versions=[1.0], Content-Length=[0], Date=[Thu, 11 Jul 2019 12:08:30 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]} -------------------------------------- 2019-07-11 12:08:35,844 [pool-463-thread-1] INFO c.t.s.c.t.i.s.CampaignServiceClient - Getting TP campaign [32b65fb22cb042f1a2612bb599a049c9] details for account 7e085c22ac9e4529a20f3b4388ebc497 2019-07-11 12:08:35,846 [pool-463-thread-1] INFO o.a.c.i.LoggingOutInterceptor - Outbound Message --------------------------- ID: 839 Address: https://api.tigerpistol.com/v1/campaigns/32b65fb22cb042f1a2612bb599a049c9 Http-Method: GET Content-Type: application/json Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token A5CO5g2RJFRI4w5mWJ32bkCAwQ6mMWo9bHPUWqIC]} -------------------------------------- 2019-07-11 12:08:36,180 [pool-463-thread-1] INFO o.a.c.i.LoggingInInterceptor - Inbound Message ---------------------------- ID: 839 Response-Code: 200 Encoding: UTF-8 Content-Type: application/json; charset=utf-8 Headers: {api-supported-versions=[1.0], Content-Length=[740], content-type=[application/json; charset=utf-8], Date=[Thu, 11 Jul 2019 12:08:35 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]} Payload: {"variations":[{"index":0,"reviewError":null}],"leadEmailAddresses":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":"32b65fb22cb042f1a2612bb599a049c9","customerId":"7e085c22ac9e4529a20f3b4388ebc497","name":"9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32705_S1","start":"2019-07-11T12:08:00+00:00","end":"2019-08-11T03:59:00+00:00","budget":3625.00,"objective":"website_clicks","status":"error","publishPhase":"error","errorMessage":"Please add a valid payment method to your ad account."} -------------------------------------- 2019-07-11 12:08:41,182 [pool-463-thread-1] INFO c.t.s.c.t.i.s.CampaignServiceClient - Getting TP campaign [75cf60f4d13644f4a47cb48ec86d0545] details for account 7e085c22ac9e4529a20f3b4388ebc497 2019-07-11 12:08:41,184 [pool-463-thread-1] INFO o.a.c.i.LoggingOutInterceptor - Outbound Message --------------------------- ID: 840 Address: https://api.tigerpistol.com/v1/campaigns/75cf60f4d13644f4a47cb48ec86d0545 Http-Method: GET Content-Type: application/json Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token A5CO5g2RJFRI4w5mWJ32bkCAwQ6mMWo9bHPUWqIC]} -------------------------------------- 2019-07-11 12:08:41,530 [pool-463-thread-1] INFO o.a.c.i.LoggingInInterceptor - Inbound Message ---------------------------- ID: 840 Response-Code: 200 Encoding: UTF-8 Content-Type: application/json; charset=utf-8 Headers: {api-supported-versions=[1.0], Content-Length=[740], content-type=[application/json; charset=utf-8], Date=[Thu, 11 Jul 2019 12:08:40 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]} Payload: {"variations":[{"index":0,"reviewError":null}],"leadEmailAddresses":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":"75cf60f4d13644f4a47cb48ec86d0545","customerId":"7e085c22ac9e4529a20f3b4388ebc497","name":"9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32705_S2","start":"2019-07-11T12:08:00+00:00","end":"2019-08-11T03:59:00+00:00","budget":3625.00,"objective":"website_clicks","status":"error","publishPhase":"error","errorMessage":"Please add a valid payment method to your ad account."} -------------------------------------- 2019-07-11 12:08:46,532 [pool-463-thread-1] INFO c.t.s.c.t.i.s.CampaignServiceClient - Getting TP campaign [16b1b635671a42fb805dbc7d1353f60a] details for account 7e085c22ac9e4529a20f3b4388ebc497 2019-07-11 12:08:46,535 [pool-463-thread-1] INFO o.a.c.i.LoggingOutInterceptor - Outbound Message --------------------------- ID: 841 Address: https://api.tigerpistol.com/v1/campaigns/16b1b635671a42fb805dbc7d1353f60a Http-Method: GET Content-Type: application/json Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token A5CO5g2RJFRI4w5mWJ32bkCAwQ6mMWo9bHPUWqIC]} -------------------------------------- 2019-07-11 12:08:46,867 [pool-463-thread-1] INFO o.a.c.i.LoggingInInterceptor - Inbound Message ---------------------------- ID: 841 Response-Code: 200 Encoding: UTF-8 Content-Type: application/json; charset=utf-8 Headers: {api-supported-versions=[1.0], Content-Length=[740], content-type=[application/json; charset=utf-8], Date=[Thu, 11 Jul 2019 12:08:45 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]} Payload: {"variations":[{"index":0,"reviewError":null}],"leadEmailAddresses":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":"16b1b635671a42fb805dbc7d1353f60a","customerId":"7e085c22ac9e4529a20f3b4388ebc497","name":"9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32705_S3","start":"2019-07-11T12:08:00+00:00","end":"2019-08-11T03:59:00+00:00","budget":3625.00,"objective":"website_clicks","status":"error","publishPhase":"error","errorMessage":"Please add a valid payment method to your ad account."} -------------------------------------- 2019-07-11 12:08:47.839 (3) [Thread-9]: Heartbeat #20126 (1562846927834) received in 0.005s 2019-07-11 12:08:51,868 [pool-463-thread-1] INFO c.t.s.c.t.i.s.CampaignServiceClient - Getting TP campaign [53eb84723f3b41db95ab60f78ce090ae] details for account 7e085c22ac9e4529a20f3b4388ebc497 2019-07-11 12:08:51,871 [pool-463-thread-1] INFO o.a.c.i.LoggingOutInterceptor - Outbound Message --------------------------- ID: 842 Address: https://api.tigerpistol.com/v1/campaigns/53eb84723f3b41db95ab60f78ce090ae Http-Method: GET Content-Type: application/json Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token A5CO5g2RJFRI4w5mWJ32bkCAwQ6mMWo9bHPUWqIC]} -------------------------------------- 2019-07-11 12:08:52,183 [pool-463-thread-1] INFO o.a.c.i.LoggingInInterceptor - Inbound Message ---------------------------- ID: 842 Response-Code: 200 Encoding: UTF-8 Content-Type: application/json; charset=utf-8 Headers: {api-supported-versions=[1.0], Content-Length=[740], content-type=[application/json; charset=utf-8], Date=[Thu, 11 Jul 2019 12:08:51 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]} Payload: {"variations":[{"index":0,"reviewError":null}],"leadEmailAddresses":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":"53eb84723f3b41db95ab60f78ce090ae","customerId":"7e085c22ac9e4529a20f3b4388ebc497","name":"9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32705_S4","start":"2019-07-11T12:08:00+00:00","end":"2019-08-11T03:59:00+00:00","budget":3625.00,"objective":"website_clicks","status":"error","publishPhase":"error","errorMessage":"Please add a valid payment method to your ad account."} -------------------------------------- 2019-07-11 12:08:52,189 [pool-463-thread-1] INFO jdbc.sqlonly - DELETE FROM `errors` WHERE `elementName` IN ('9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32705_S1','9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32705_S2','9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32705_S3','9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32705_S4') 2019-07-11 12:08:52,189 [pool-463-thread-1] INFO c.t.s.client.tp.dao.TPErrorDAO - Removed '0' Previous Errors 2019-07-11 12:08:52,190 [pool-463-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 ('9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32705_S1','CAMPAIGN_STATUS','9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32705_S1',0,'status: error, publish Phase: error',NULL,NULL,'Please add a valid payment method to your ad account.',NULL,'32b65fb22cb042f1a2612bb599a049c9',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":"9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32705_S1","type":"CAMPAIGN_STATUS","key":"9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32705_S1","searchEngineId":"32b65fb22cb042f1a2612bb599a049c9","parentSearchEngineId":null}') 2: INSERT INTO `errors` (`elementName`, `itemType`, `itemKey`, `code`, `detail`, `errorCode`, `index`, `message`, `errorType`, `tpId`, `parentId`, `lastUpdated`, `errorJson`) VALUES ('9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32705_S2','CAMPAIGN_STATUS','9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32705_S2',0,'status: error, publish Phase: error',NULL,NULL,'Please add a valid payment method to your ad account.',NULL,'75cf60f4d13644f4a47cb48ec86d0545',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":"9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32705_S2","type":"CAMPAIGN_STATUS","key":"9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32705_S2","searchEngineId":"75cf60f4d13644f4a47cb48ec86d0545","parentSearchEngineId":null}') 3: INSERT INTO `errors` (`elementName`, `itemType`, `itemKey`, `code`, `detail`, `errorCode`, `index`, `message`, `errorType`, `tpId`, `parentId`, `lastUpdated`, `errorJson`) VALUES ('9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32705_S3','CAMPAIGN_STATUS','9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32705_S3',0,'status: error, publish Phase: error',NULL,NULL,'Please add a valid payment method to your ad account.',NULL,'16b1b635671a42fb805dbc7d1353f60a',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":"9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32705_S3","type":"CAMPAIGN_STATUS","key":"9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32705_S3","searchEngineId":"16b1b635671a42fb805dbc7d1353f60a","parentSearchEngineId":null}') 4: INSERT INTO `errors` (`elementName`, `itemType`, `itemKey`, `code`, `detail`, `errorCode`, `index`, `message`, `errorType`, `tpId`, `parentId`, `lastUpdated`, `errorJson`) VALUES ('9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32705_S4','CAMPAIGN_STATUS','9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32705_S4',0,'status: error, publish Phase: error',NULL,NULL,'Please add a valid payment method to your ad account.',NULL,'53eb84723f3b41db95ab60f78ce090ae',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":"9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32705_S4","type":"CAMPAIGN_STATUS","key":"9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32705_S4","searchEngineId":"53eb84723f3b41db95ab60f78ce090ae","parentSearchEngineId":null}') 2019-07-11 12:08:52,193 [pool-463-thread-1] INFO jdbc.sqlonly - INSERT INTO `campaigns` (`searchEngineUserId`, `tpId`, `name`, `status`, `startDate`, `endDate`, `lastUpdated`, `json`) VALUES (4104, '32b65fb22cb042f1a2612bb599a049c9', '9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32705_S1', 'Active', '07/11/2019 12:08:20.889', '08/11/2019 03:59:59.999', NOW(), '{"campaign":{"name":"9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32705_S1","status":"Active","id":"32b65fb22cb042f1a2612bb599a049c9","customerId":"7e085c22ac9e4529a20f3b4388ebc497","objective":"website_clicks","budget":3625,"start":"2019-07-11T12:08:20.889Z","maxEnd":"2019-08-11T03:59:59.999Z","placement":["desktopfeed","mobilefeed","instagramstream"],"details":{"audiences":[{"ageFrom":18,"ageTo":65,"gender":"all","locationTypes":["home","recent"],"demographics":{"education_majors":["107792185915220","112870968727410"],"behaviors":["6002714895372"],"interests":["6002926108721"],"work_employers":["102662719805111"]},"locations":[{"type":"city","id":"2417653"}]}],"copies":[{"headline":"Find a Hotel","body":"Aliso Viejo Hotel. You''ll Have a Great Stay Here!","description":"Hotel Rooms Aliso Viejo","destinationUrl":"http://www.merchantsite.com/"}],"images":["https://aml-qa.s3.us-west-1.amazonaws.com/usa/10002/images/image-10002-5.jpg"],"cta":[{"type":"learn_more"}]}},"searchEngineUserId":4104}') 2019-07-11 12:08:52,194 [pool-463-thread-1] INFO jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`tpId` = '32b65fb22cb042f1a2612bb599a049c9' 2019-07-11 12:08:52,197 [pool-463-thread-1] INFO jdbc.sqlonly - INSERT INTO `campaigns` (`searchEngineUserId`, `tpId`, `name`, `status`, `startDate`, `endDate`, `lastUpdated`, `json`) VALUES (4104, '75cf60f4d13644f4a47cb48ec86d0545', '9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32705_S2', 'Active', '07/11/2019 12:08:20.902', '08/11/2019 03:59:59.999', NOW(), '{"campaign":{"name":"9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32705_S2","status":"Active","id":"75cf60f4d13644f4a47cb48ec86d0545","customerId":"7e085c22ac9e4529a20f3b4388ebc497","objective":"website_clicks","budget":3625,"start":"2019-07-11T12:08:20.902Z","maxEnd":"2019-08-11T03:59:59.999Z","placement":["desktopfeed","mobilefeed","instagramstream"],"details":{"audiences":[{"ageFrom":18,"ageTo":65,"gender":"all","locationTypes":["home","recent"],"demographics":{"education_majors":["107792185915220","112870968727410"],"behaviors":["6002714895372"],"interests":["6002926108721"],"work_employers":["102662719805111"]},"locations":[{"type":"city","id":"2417653"}]}],"copies":[{"headline":"Find a Guest Room","body":"Aliso Viejo Hotel Rooms. Find Out Why Guests Love Us!","description":"Hotel Rooms Aliso Viejo","destinationUrl":"http://www.merchantsite.com/"}],"images":["https://aml-qa.s3.us-west-1.amazonaws.com/usa/10002/images/image-10002-4.jpg"],"cta":[{"type":"learn_more"}]}},"searchEngineUserId":4104}') 2019-07-11 12:08:52,198 [pool-463-thread-1] INFO jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`tpId` = '75cf60f4d13644f4a47cb48ec86d0545' 2019-07-11 12:08:52,199 [pool-463-thread-1] INFO jdbc.sqlonly - INSERT INTO `campaigns` (`searchEngineUserId`, `tpId`, `name`, `status`, `startDate`, `endDate`, `lastUpdated`, `json`) VALUES (4104, '16b1b635671a42fb805dbc7d1353f60a', '9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32705_S3', 'Active', '07/11/2019 12:08:20.909', '08/11/2019 03:59:59.999', NOW(), '{"campaign":{"name":"9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32705_S3","status":"Active","id":"16b1b635671a42fb805dbc7d1353f60a","customerId":"7e085c22ac9e4529a20f3b4388ebc497","objective":"website_clicks","budget":3625,"start":"2019-07-11T12:08:20.909Z","maxEnd":"2019-08-11T03:59:59.999Z","placement":["desktopfeed","mobilefeed","instagramstream"],"details":{"audiences":[{"ageFrom":18,"ageTo":65,"gender":"all","locationTypes":["home","recent"],"demographics":{"education_majors":["107792185915220","112870968727410"],"behaviors":["6002714895372"],"interests":["6002926108721"],"work_employers":["102662719805111"]},"locations":[{"type":"city","id":"2417653"}]}],"copies":[{"headline":"Hotel Rooms Aliso Viejo","body":"Aliso Viejo Hotel. You''ll Have a Great Stay Here!","description":"Find a Hotel","destinationUrl":"http://www.merchantsite.com/"}],"images":["https://aml-qa.s3.us-west-1.amazonaws.com/usa/10002/images/image-10002-3.jpg"],"cta":[{"type":"learn_more"}]}},"searchEngineUserId":4104}') 2019-07-11 12:08:52,200 [pool-463-thread-1] INFO jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`tpId` = '16b1b635671a42fb805dbc7d1353f60a' 2019-07-11 12:08:52,201 [pool-463-thread-1] INFO jdbc.sqlonly - INSERT INTO `campaigns` (`searchEngineUserId`, `tpId`, `name`, `status`, `startDate`, `endDate`, `lastUpdated`, `json`) VALUES (4104, '53eb84723f3b41db95ab60f78ce090ae', '9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32705_S4', 'Active', '07/11/2019 12:08:20.916', '08/11/2019 03:59:59.999', NOW(), '{"campaign":{"name":"9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32705_S4","status":"Active","id":"53eb84723f3b41db95ab60f78ce090ae","customerId":"7e085c22ac9e4529a20f3b4388ebc497","objective":"website_clicks","budget":3625,"start":"2019-07-11T12:08:20.916Z","maxEnd":"2019-08-11T03:59:59.999Z","placement":["desktopfeed","mobilefeed","instagramstream"],"details":{"audiences":[{"ageFrom":18,"ageTo":65,"gender":"all","locationTypes":["home","recent"],"demographics":{"education_majors":["107792185915220","112870968727410"],"behaviors":["6002714895372"],"interests":["6002926108721"],"work_employers":["102662719805111"]},"locations":[{"type":"city","id":"2417653"}]}],"copies":[{"headline":"Hotel Rooms Aliso Viejo","body":"Aliso Viejo Hotel Rooms. Find Out Why Guests Love Us!","description":"Find a Guest Room","destinationUrl":"http://www.merchantsite.com/"}],"images":["https://aml-qa.s3.us-west-1.amazonaws.com/usa/10002/images/image-10002-2.jpg"],"cta":[{"type":"learn_more"}]}},"searchEngineUserId":4104}') 2019-07-11 12:08:52,202 [pool-463-thread-1] INFO jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`tpId` = '53eb84723f3b41db95ab60f78ce090ae' 2019-07-11 12:08:52,204 [pool-463-thread-1] INFO c.t.s.f.FacebookAccountDeployer - finding carryover for seuserID 4104 2019-07-11 12:08:52,207 [pool-463-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` = 4104 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-07-11 12:08:52,211 [pool-463-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Found campaign carryover data for seuserID 4104, carryover data ([TPCampaignCarryoverDTO [theID=9305, theCampaignID=2694, theDate=2019-07-11, theDedicatedCarryover=0.0, thePooledCarryover=0.0, theCarryoverType=normal], TPCampaignCarryoverDTO [theID=9304, theCampaignID=2693, theDate=2019-07-11, theDedicatedCarryover=0.0, thePooledCarryover=0.0, theCarryoverType=normal], TPCampaignCarryoverDTO [theID=9303, theCampaignID=2692, theDate=2019-07-11, theDedicatedCarryover=0.0, thePooledCarryover=0.0, theCarryoverType=normal], TPCampaignCarryoverDTO [theID=9302, theCampaignID=2691, theDate=2019-07-11, theDedicatedCarryover=0.0, thePooledCarryover=0.0, theCarryoverType=normal]]) 2019-07-11 12:08:52,213 [pool-463-thread-1] INFO jdbc.sqlonly - INSERT INTO `monthlyCarryovers` (`campaignID`, `date`, `dedicatedCarryover`, `pooledCarryover`, `type`) VALUES (2694,'2019-07-11',0.0,0.0,'boosted') ON DUPLICATE KEY UPDATE `dedicatedCarryover`=VALUES(`dedicatedCarryover`), `pooledCarryover`=VALUES(`pooledCarryover`), `type`=VALUES(`type`) 2019-07-11 12:08:52,214 [pool-463-thread-1] INFO jdbc.sqlonly - SELECT `id`, `campaignID`, `date`, `dedicatedCarryover`, `pooledCarryover`, `type` FROM `monthlyCarryovers` WHERE `campaignID` = 2694 and `date` = '2019-07-11' and `type` = 'boosted' 2019-07-11 12:08:52,219 [pool-463-thread-1] INFO jdbc.sqlonly - INSERT INTO `monthlyCarryovers` (`campaignID`, `date`, `dedicatedCarryover`, `pooledCarryover`, `type`) VALUES (2693,'2019-07-11',0.0,0.0,'boosted') ON DUPLICATE KEY UPDATE `dedicatedCarryover`=VALUES(`dedicatedCarryover`), `pooledCarryover`=VALUES(`pooledCarryover`), `type`=VALUES(`type`) 2019-07-11 12:08:52,220 [pool-463-thread-1] INFO jdbc.sqlonly - SELECT `id`, `campaignID`, `date`, `dedicatedCarryover`, `pooledCarryover`, `type` FROM `monthlyCarryovers` WHERE `campaignID` = 2693 and `date` = '2019-07-11' and `type` = 'boosted' 2019-07-11 12:08:52,224 [pool-463-thread-1] INFO jdbc.sqlonly - INSERT INTO `monthlyCarryovers` (`campaignID`, `date`, `dedicatedCarryover`, `pooledCarryover`, `type`) VALUES (2692,'2019-07-11',0.0,0.0,'boosted') ON DUPLICATE KEY UPDATE `dedicatedCarryover`=VALUES(`dedicatedCarryover`), `pooledCarryover`=VALUES(`pooledCarryover`), `type`=VALUES(`type`) 2019-07-11 12:08:52,225 [pool-463-thread-1] INFO jdbc.sqlonly - SELECT `id`, `campaignID`, `date`, `dedicatedCarryover`, `pooledCarryover`, `type` FROM `monthlyCarryovers` WHERE `campaignID` = 2692 and `date` = '2019-07-11' and `type` = 'boosted' 2019-07-11 12:08:52,230 [pool-463-thread-1] INFO jdbc.sqlonly - INSERT INTO `monthlyCarryovers` (`campaignID`, `date`, `dedicatedCarryover`, `pooledCarryover`, `type`) VALUES (2691,'2019-07-11',0.0,0.0,'boosted') ON DUPLICATE KEY UPDATE `dedicatedCarryover`=VALUES(`dedicatedCarryover`), `pooledCarryover`=VALUES(`pooledCarryover`), `type`=VALUES(`type`) 2019-07-11 12:08:52,231 [pool-463-thread-1] INFO jdbc.sqlonly - SELECT `id`, `campaignID`, `date`, `dedicatedCarryover`, `pooledCarryover`, `type` FROM `monthlyCarryovers` WHERE `campaignID` = 2691 and `date` = '2019-07-11' and `type` = 'boosted' 2019-07-11 12:08:52,234 [pool-463-thread-1] INFO c.t.s.f.FacebookAccountDeployer - Created Facebook campaign structure for accountID 2651 2019-07-11 12:08:52.234 (3) [pool-463-thread-1]: Completed Facebook Create Campaign Worker.. 2019-07-11 12:08:52,259 [pool-3-thread-56] INFO jdbc.sqlonly - SELECT `errors`.`errorJson` FROM `campaigns` JOIN `errors` ON `errors`.`elementName` = `campaigns`.`name` WHERE `campaigns`.`id` IN (2695) 2019-07-11 12:08:52.261 (3) [pool-3-thread-56]: Ignoring: 1 CampaignStatus errors 2019-07-11 12:08:52.261 (3) [pool-3-thread-56]: 32705_S1 has no applicable GCE errors. 2019-07-11 12:08:52,264 [pool-3-thread-56] INFO jdbc.sqlonly - SELECT `errors`.`errorJson` FROM `campaigns` JOIN `errors` ON `errors`.`elementName` = `campaigns`.`name` WHERE `campaigns`.`id` IN (2696) 2019-07-11 12:08:52.267 (3) [pool-3-thread-56]: Ignoring: 1 CampaignStatus errors 2019-07-11 12:08:52.267 (3) [pool-3-thread-56]: 32705_S2 has no applicable GCE errors. 2019-07-11 12:08:52,270 [pool-3-thread-56] INFO jdbc.sqlonly - SELECT `errors`.`errorJson` FROM `campaigns` JOIN `errors` ON `errors`.`elementName` = `campaigns`.`name` WHERE `campaigns`.`id` IN (2697) 2019-07-11 12:08:52.272 (3) [pool-3-thread-56]: Ignoring: 1 CampaignStatus errors 2019-07-11 12:08:52.272 (3) [pool-3-thread-56]: 32705_S3 has no applicable GCE errors. 2019-07-11 12:08:52,276 [pool-3-thread-56] INFO jdbc.sqlonly - SELECT `errors`.`errorJson` FROM `campaigns` JOIN `errors` ON `errors`.`elementName` = `campaigns`.`name` WHERE `campaigns`.`id` IN (2698) 2019-07-11 12:08:52.278 (3) [pool-3-thread-56]: Ignoring: 1 CampaignStatus errors 2019-07-11 12:08:52.278 (3) [pool-3-thread-56]: 32705_S4 has no applicable GCE errors. 2019-07-11 12:08:52.280 (3) [pool-3-thread-56]: Finished DEPLOY request for campaign 9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32705_S1: SUCCEEDED (merchant: 9b878d28-1172-4800-8711-a148dad10a9a) 2019-07-11 12:08:52.280 (3) [pool-3-thread-56]: Finished DEPLOY request for campaign 9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32705_S2: SUCCEEDED (merchant: 9b878d28-1172-4800-8711-a148dad10a9a) 2019-07-11 12:08:52.281 (3) [pool-3-thread-56]: Finished DEPLOY request for campaign 9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32705_S3: SUCCEEDED (merchant: 9b878d28-1172-4800-8711-a148dad10a9a) 2019-07-11 12:08:52.282 (3) [pool-3-thread-56]: Finished DEPLOY request for campaign 9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32705_S4: SUCCEEDED (merchant: 9b878d28-1172-4800-8711-a148dad10a9a) 2019-07-11 12:08:52.282 (3) [pool-3-thread-56]: 9b878d28-1172-4800-8711-a148dad10a9a has 4 campaigns for a SE Update accounts sync. 2019-07-11 12:08:52.282 (3) [pool-3-thread-56]: 9b878d28-1172-4800-8711-a148dad10a9a has 4 campaigns for a SE Update groups-listings sync. 2019-07-11 12:08:57.282 (3) [pool-3-thread-56]: JobExecutor running job [2019-07-11_120852_a2651_AccountWorkerProcessResults_syncAccountsGroupsListings_s0j1MsOOri]: [/usr/local/tsa/bidmgr/seupdate.sh, , -d, 3, --inactive, --accountid, 2651, --accounts, --seaccount, 17324,17325,17326,17327, --groups, --listings] 2019-07-11 12:09:14.016 (3) [pool-3-thread-56]: JobExecutor finished running job [2019-07-11_120852_a2651_AccountWorkerProcessResults_syncAccountsGroupsListings_s0j1MsOOri], exit code=0 in 16.721s 2019-07-11 12:09:14.016 (3) [pool-3-thread-56]: JobExecutor finished 2019-07-11_120852_a2651_AccountWorkerProcessResults_syncAccountsGroupsListings_s0j1MsOOri. hasError=false, numTries=1 2019-07-11 12:09:14.016 (3) [pool-3-thread-56]: Finished sub-campaign processing for DEPLOY deploymentID (3fd81bc3-c200-410a-8263-d9618a74cc0e). account 9b878d28-1172-4800-8711-a148dad10a9a. 4 submitted, 4 ok. 2019-07-11 12:09:14.017 (3) [pool-3-thread-56]: Updating deployment status to 'Success' for campaignID: 32705 2019-07-11 12:09:14.018 (3) [pool-3-thread-56]: Finished DEPLOY request for 9b878d28-1172-4800-8711-a148dad10a9a_10002_12542_32705: SUCCEEDED (merchant: 9b878d28-1172-4800-8711-a148dad10a9a) 2019-07-11 12:09:14.018 (3) [pool-3-thread-56]: Finished DEPLOY request, deploymentID (3fd81bc3-c200-410a-8263-d9618a74cc0e), account 9b878d28-1172-4800-8711-a148dad10a9a 2019-07-11 12:09:14.018 (3) [pool-3-thread-56]: Request removed from map for customerID 9b878d28-1172-4800-8711-a148dad10a9a 2019-07-11 12:09:14.045 (3) [pool-3-thread-56]: Initial campaign deployment for customerID: 9b878d28-1172-4800-8711-a148dad10a9a