2018-08-07 07:14:20.860 (3) [Thread-9]: Heartbeat #3267 (1533626060857) received in 0.003s
2018-08-07 07:14:50.860 (3) [Thread-9]: Heartbeat #3268 (1533626090857) received in 0.003s
2018-08-07 07:15:20.860 (3) [Thread-9]: Heartbeat #3269 (1533626120857) received in 0.003s
2018-08-07 07:15:50.860 (3) [Thread-9]: Heartbeat #3270 (1533626150857) received in 0.003s
2018-08-07 07:16:17.248 (3) [Thread-9]: Request added to map for customerID 2790da9c-fe48-4f82-ac4f-bd1602a09ecd
2018-08-07 07:16:17.248 (3) [Thread-9]: HighPriorityMessageHandler handling message ID ID:JBM-39031257-ce59-4b0e-a4c1-955ef697d117
2018-08-07 07:16:17.248 (3) [Thread-9]: Request worker created for 2790da9c-fe48-4f82-ac4f-bd1602a09ecd
2018-08-07 07:16:17.248 (3) [Thread-9]: Submitted executor job for 2790da9c-fe48-4f82-ac4f-bd1602a09ecd
2018-08-07 07:16:17.252 (3) [Thread-9]: HighPriorityMessageHandler took message ID ID:JBM-39031257-ce59-4b0e-a4c1-955ef697d117 out of queue
2018-08-07 07:16:17.254 (3) [pool-3-thread-20]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2018-08-07 07:16:17.281 (3) [pool-3-thread-20]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2018-08-07 07:16:17.286 (3) [pool-3-thread-20]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2018-08-07 07:16:17.292 (3) [pool-3-thread-20]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2018-08-07 07:16:17.295 (3) [pool-3-thread-20]: Updating deployment status to 'InProgress' for campaignID: 23925
2018-08-07 07:16:17.305 (3) [pool-3-thread-20]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2018-08-07 07:16:17.309 (3) [pool-3-thread-20]: Pausing campaign 12563 because budget (0.0048387097 ==> 0.0) is less than the minimum allowed budget (0.05)
2018-08-07 07:16:17,309 [pool-3-thread-20] DEBUG c.t.common.SECampaignStatusManager - AdMax campaign budget status not found so using Paused
2018-08-07 07:16:17.314 (3) [pool-3-thread-20]: Pausing campaign 12562 because budget (0.0048387097 ==> 0.0) is less than the minimum allowed budget (0.05)
2018-08-07 07:16:17,314 [pool-3-thread-20] DEBUG c.t.common.SECampaignStatusManager - AdMax campaign budget status not found so using Paused
2018-08-07 07:16:17.314 (3) [pool-3-thread-20]: Updating deployment status to 'InProgress' for campaignID: 23926
2018-08-07 07:16:17.323 (3) [pool-3-thread-20]: Pausing campaign 12565 because budget (0.0048387097 ==> 0.0) is less than the minimum allowed budget (0.01)
2018-08-07 07:16:17,323 [pool-3-thread-20] DEBUG c.t.common.SECampaignStatusManager - AdMax campaign budget status not found so using Paused
2018-08-07 07:16:17.327 (3) [pool-3-thread-20]: Pausing campaign 12564 because budget (0.0048387097 ==> 0.0) is less than the minimum allowed budget (0.01)
2018-08-07 07:16:17,327 [pool-3-thread-20] DEBUG c.t.common.SECampaignStatusManager - AdMax campaign budget status not found so using Paused
2018-08-07 07:16:17.328 (3) [pool-3-thread-20]: Updating deployment status to 'InProgress' for campaignID: 23927
2018-08-07 07:16:17,336 [pool-3-thread-20] DEBUG c.t.common.SECampaignStatusManager - AdMax campaign budget status not found so using Active
2018-08-07 07:16:17,341 [pool-3-thread-20] DEBUG c.t.common.SECampaignStatusManager - AdMax campaign budget status not found so using Active
2018-08-07 07:16:17,345 [pool-3-thread-20] DEBUG c.t.common.SECampaignStatusManager - AdMax campaign budget status not found so using Active
2018-08-07 07:16:17,349 [pool-3-thread-20] DEBUG c.t.common.SECampaignStatusManager - AdMax campaign budget status not found so using Active
2018-08-07 07:16:17.350 (3) [pool-3-thread-20]: Start processing UPDATE request (ab9185f7-ce46-492f-9274-146867e822b4) for account 2790da9c-fe48-4f82-ac4f-bd1602a09ecd. 8 campaign(s).
2018-08-07 07:16:17.350 (3) [pool-3-thread-20]: Performing update for account: 2790da9c-fe48-4f82-ac4f-bd1602a09ecd ID#2396
2018-08-07 07:16:17.355 (3) [pool-3-thread-20]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2018-08-07 07:16:17.360 (3) [pool-3-thread-20]: Distribution Properties Cache: Loading new properties for 2790da9c-fe48-4f82-ac4f-bd1602a09ecd_CONTENT_EDITOR
2018-08-07 07:16:17.474 (3) [pool-3-thread-20]: 8 campaign(s) to update.
2018-08-07 07:16:17.474 (3) [pool-3-thread-20]: 0 campaign(s) to retry and update.
2018-08-07 07:16:17.474 (3) [pool-3-thread-20]: Update campaign status for accountID 2396
2018-08-07 07:16:17.475 (3) [pool-3-thread-20]: CampaignWorker initialized for account: 2396
2018-08-07 07:16:17.475 (3) [pool-3-thread-20]: Updating 2790da9c-fe48-4f82-ac4f-bd1602a09ecd_10002_12542_23925_GM Status: Paused
2018-08-07 07:16:17.475 (3) [pool-3-thread-20]: Updating 2790da9c-fe48-4f82-ac4f-bd1602a09ecd_10002_12542_23925_GT Status: Paused
2018-08-07 07:16:17.475 (3) [pool-3-thread-20]: Updating 2790da9c-fe48-4f82-ac4f-bd1602a09ecd_10002_12542_23926_GM Status: Paused
2018-08-07 07:16:17.475 (3) [pool-3-thread-20]: Updating 2790da9c-fe48-4f82-ac4f-bd1602a09ecd_10002_12542_23926_GT Status: Paused
2018-08-07 07:16:17.475 (3) [pool-3-thread-20]: Updating 2790da9c-fe48-4f82-ac4f-bd1602a09ecd_10002_12542_23927_S1 Status: Paused
2018-08-07 07:16:17.475 (3) [pool-3-thread-20]: Updating 2790da9c-fe48-4f82-ac4f-bd1602a09ecd_10002_12542_23927_S2 Status: Paused
2018-08-07 07:16:17.475 (3) [pool-3-thread-20]: Updating 2790da9c-fe48-4f82-ac4f-bd1602a09ecd_10002_12542_23927_S3 Status: Paused
2018-08-07 07:16:17.475 (3) [pool-3-thread-20]: Updating 2790da9c-fe48-4f82-ac4f-bd1602a09ecd_10002_12542_23927_S4 Status: Paused
2018-08-07 07:16:17.475 (3) [pool-3-thread-20]: CampaignUpdateWorker started...
2018-08-07 07:16:17,578 [pool-3-thread-20] DEBUG c.t.searchengines.bing.BingApiUtils - Getting Bing properties using distribution service
2018-08-07 07:16:17.578 (3) [pool-3-thread-20]: Distribution Properties Cache: Loading new properties for 2790da9c-fe48-4f82-ac4f-bd1602a09ecd_CONTENT_EDITOR
2018-08-07 07:16:17.683 (3) [pool-3-thread-20]: Retrieving credentials : client id : 869cad8e-f7c6-4854-b1bb-4f7955d142c3 , client secret :YZpgReOeKSmN3uEvwdvpumW , refresh token : MCU8qys*5ivRLB*Ufjm4SYPrFDstjeedAPUwtmhQMd6AejXJqnqtokFR!CI9*!AXxiuWu4*gJltaCOEEnHlFLRb3wH1*dHV7v0Vkb8iCR1qXtWCntG0JQLGUjRtSBbGLmc1OEyYGaL4GRNkyx4o3xSgFUxj9MI8ivtKerxZDvBUdhBCXpoZqEN96GBXQe2ldtXlHDaTVf1XXMM3cV6Nm061sQis2g6EdWRztSI*4VqjtBV8jRlC2CsD2BR8yQdvrk0L6ab0Rr*oKfE9f8rX35cJyjLQopv!FWoFXe6JPPmdGVsYVxmmX7mgT1!BtevrBmR3lqfkCbqGLar4ZfMBHu5!1e4zQUyCq328RT*LgOlX*7
2018-08-07 07:16:17,683 [pool-3-thread-20] INFO  c.t.s.o.core.OAuthServiceComponent - [oauth] Return OAuth credential. Access token = EwAQA3hlBAAUS26g+KHGWHId2M6BBkwqoP+OSdAAAZGa6Uw+r/8jzliSop8ZWDFZrTFfCaob2tsevbkXruZ8DSjLpRrdU3NgvrITMaxqZzMv9i+0K3aA3LkB822lSadg6+wpae8YKy6bfpIF/4N2SFgqSPli95oEUQTCAmJ2I+WokJzF5QmSwJT3LROGdj/Up3jzoFKpjFbkJOqSfoQmSsJLWRYX1zdBDbUcVMkce3w4+Q5hD6W6RC1dexcmx3WDV8ez6MlNF1+cYNYsWx/cwGXmG69PzAP0DvpNtcDpGBVIAxj4swzGSb6wYebb+YFGhTsvgWv6SHr5PphlYEJN+W+iW515faI1ngtS+5ww1PYEcNIDlPtDPKh6tIbbpxQDZgAACLoZSNmZwyyX4AGqBlcrbPZaWwLfloWmG6kG4vw+WKAYPc3ItR+kjER8YERDCHoZLWBRqRz8LcuzGxeX2CVcRx4cplCvYLVLC+Xc/F3Lxinm7NlHFQ49lXFFsJwX0PZNvVyrww8KmXclveikFZvX89uvbDB6Wjq6KcofqSpBF3/lMQo9FjZYrvOCYxr17cNOSodt2L/94tF4KBAwVH7nXBelbXiuPOwG4AogxI3GQuX08JcvjhZml/yORGO6XCN6YWKYwEmpd8ZYskIBA/yhm3mxvKdGDX+3nRMLE+DzJHEU7ynPnStUTtYrUE02gNnb9W+//jYU4p421vWSi8R0kxXngZxdL9LauuoGvgb1hccgLjn59HdA0Mi9vcQzg4IegQ1Zo4kHw+wdaAxXCajrM3VMR3ZCPe3++qRCXsRHRQiSKN6v/AETSKcufWsIwMeErnJtAKHFFKnkz//n23J9xvtJQBAlJNvBgFYpfM9Ua+hEkzVWd9MApdyREEm+lam32ikp/UheUJKhPbMuYoRL79epIcHcNEi4c8lP1FO2YYfHIMYjY0pUtF6ax/1BQjU29tXmV6LBl7vrX1g8NyLNL0oOV1ZqvP3EIcP72iuapIPUUiqmux6C+QDtkkwovEsjV45HbXVt4zBDtFcVAg== for bing (clientID=869cad8e-f7c6-4854-b1bb-4f7955d142c3)
2018-08-07 07:16:17.683 (3) [pool-3-thread-20]: [oauth] Returning access token from OAuth service: EwAQA3hlBAAUS26g+KHGWHId2M6BBkwqoP+OSdAAAZGa6Uw+r/8jzliSop8ZWDFZrTFfCaob2tsevbkXruZ8DSjLpRrdU3NgvrITMaxqZzMv9i+0K3aA3LkB822lSadg6+wpae8YKy6bfpIF/4N2SFgqSPli95oEUQTCAmJ2I+WokJzF5QmSwJT3LROGdj/Up3jzoFKpjFbkJOqSfoQmSsJLWRYX1zdBDbUcVMkce3w4+Q5hD6W6RC1dexcmx3WDV8ez6MlNF1+cYNYsWx/cwGXmG69PzAP0DvpNtcDpGBVIAxj4swzGSb6wYebb+YFGhTsvgWv6SHr5PphlYEJN+W+iW515faI1ngtS+5ww1PYEcNIDlPtDPKh6tIbbpxQDZgAACLoZSNmZwyyX4AGqBlcrbPZaWwLfloWmG6kG4vw+WKAYPc3ItR+kjER8YERDCHoZLWBRqRz8LcuzGxeX2CVcRx4cplCvYLVLC+Xc/F3Lxinm7NlHFQ49lXFFsJwX0PZNvVyrww8KmXclveikFZvX89uvbDB6Wjq6KcofqSpBF3/lMQo9FjZYrvOCYxr17cNOSodt2L/94tF4KBAwVH7nXBelbXiuPOwG4AogxI3GQuX08JcvjhZml/yORGO6XCN6YWKYwEmpd8ZYskIBA/yhm3mxvKdGDX+3nRMLE+DzJHEU7ynPnStUTtYrUE02gNnb9W+//jYU4p421vWSi8R0kxXngZxdL9LauuoGvgb1hccgLjn59HdA0Mi9vcQzg4IegQ1Zo4kHw+wdaAxXCajrM3VMR3ZCPe3++qRCXsRHRQiSKN6v/AETSKcufWsIwMeErnJtAKHFFKnkz//n23J9xvtJQBAlJNvBgFYpfM9Ua+hEkzVWd9MApdyREEm+lam32ikp/UheUJKhPbMuYoRL79epIcHcNEi4c8lP1FO2YYfHIMYjY0pUtF6ax/1BQjU29tXmV6LBl7vrX1g8NyLNL0oOV1ZqvP3EIcP72iuapIPUUiqmux6C+QDtkkwovEsjV45HbXVt4zBDtFcVAg==
2018-08-07 07:16:17,788 [pool-3-thread-20] DEBUG c.t.s.facebook.FacebookApiUtils - Getting FB properties using distribution service
2018-08-07 07:16:17.788 (3) [pool-3-thread-20]: Distribution Properties Cache: Loading new properties for 2790da9c-fe48-4f82-ac4f-bd1602a09ecd_CONTENT_EDITOR
2018-08-07 07:16:17,899 [pool-3-thread-20] INFO  c.t.s.bing.BingAccountDeployer - BingAccountDeployer:getExistingCampaigns
2018-08-07 07:16:17,901 [pool-3-thread-20] INFO  jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`id` IN (4780,4781)

2018-08-07 07:16:17,904 [pool-3-thread-20] INFO  c.t.s.f.FacebookAccountDeployer - FacebookAccountDeployer:getExistingCampaigns
2018-08-07 07:16:17,906 [pool-3-thread-20] INFO  jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`id` IN (1392,1393,1390,1391)

2018-08-07 07:16:17,908 [pool-3-thread-20] INFO  c.t.s.f.FacebookAccountDeployer - calculating carryover for seuserID 3587
2018-08-07 07:16:17,908 [pool-3-thread-20] INFO  c.t.s.f.FacebookAccountDeployer - Fetching performance data for seuserID 3587 and campaign SEIdentifiers [1c9487fa6fc7455c8c47afd0b064c904, 97fe7b12a2034131928414466a1e6f72, ab97f56605854745b1c577e7fc8ae07e, 7a6c5c25fb6a4b55abe021c13f6ac340]
2018-08-07 07:16:17.912 (3) [pool-3-thread-20]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2018-08-07 07:16:17,916 [pool-3-thread-20] INFO  jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`tpId` = '1c9487fa6fc7455c8c47afd0b064c904'

2018-08-07 07:16:20.860 (3) [Thread-9]: Heartbeat #3271 (1533626180857) received in 0.003s
2018-08-07 07:16:22,916 [pool-3-thread-20] INFO  c.t.s.c.t.i.s.CampaignServiceClient - Getting TP campaign [1c9487fa6fc7455c8c47afd0b064c904] details for account 0f0717eb460440a3a6d132c74585d478
2018-08-07 07:16:22,919 [pool-3-thread-20] INFO  o.a.c.i.LoggingOutInterceptor - Outbound Message
---------------------------
ID: 631
Address: https://api.tigerpistol.com/v1/campaigns/1c9487fa6fc7455c8c47afd0b064c904
Http-Method: GET
Content-Type: application/json
Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token IcHjX0XyED53f6ShTWlqq4xbRXkEoiloVA1IXqtU]}
--------------------------------------
2018-08-07 07:16:23,399 [pool-3-thread-20] INFO  o.a.c.i.LoggingInInterceptor - Inbound Message
----------------------------
ID: 631
Response-Code: 200
Encoding: UTF-8
Content-Type: application/json; charset=utf-8
Headers: {Content-Length=[714], content-type=[application/json; charset=utf-8], Date=[Tue, 07 Aug 2018 07:16:23 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]}
Payload: {"variations":[{"index":0,"reviewError":null}],"id":"1c9487fa6fc7455c8c47afd0b064c904","customerId":"0f0717eb460440a3a6d132c74585d478","start":"2018-08-07T05:22:00+00:00","end":"2018-09-07T03:59:00+00:00","budget":10000.0,"objective":"page_likes","displayMargin":1.0,"status":"error","publishPhase":"error","hasError":true,"errorMessage":"You must have a valid payment method associated with your ad account before you can create ads. Please add a payment method.","spend":0.0,"clicks":0,"cpc":null,"ctr":null,"impressions":0,"cpm":null,"leads":0,"cpl":null,"pageLikes":0,"postEngagements":0,"cppl":null,"cppe":null,"reach":0,"videoViews":0,"cpvv":null,"videoAveragePercentViewed":null,"offersSaved":0,"cpos":null}
--------------------------------------
2018-08-07 07:16:23,401 [pool-3-thread-20] INFO  jdbc.sqlonly - INSERT INTO `performance` (`campaignID`, `date`, `status`, `spend`, `clicks`, `impressions`,
`budget`, `startDate`, `endDate`, `lastUpdated`) VALUES (1390,'2018-08-07','error',0.0,0,0,10000,'08/07/2018
05:22:00.000','09/07/2018 03:59:00.000',NOW()) ON DUPLICATE KEY UPDATE `status`=VALUES(`status`),
`spend`=VALUES(`spend`), `clicks`=VALUES(`clicks`), `impressions`=VALUES(`impressions`), `budget`=VALUES(`budget`),
`lastUpdated`=VALUES(`lastUpdated`)

2018-08-07 07:16:23,402 [pool-3-thread-20] 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`
= 1390 and `performance`.`date` = '2018-08-07'

2018-08-07 07:16:23,402 [pool-3-thread-20] INFO  jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`tpId` = '97fe7b12a2034131928414466a1e6f72'

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

2018-08-07 07:16:28,743 [pool-3-thread-20] 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`
= 1391 and `performance`.`date` = '2018-08-07'

2018-08-07 07:16:28,744 [pool-3-thread-20] INFO  jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`tpId` = 'ab97f56605854745b1c577e7fc8ae07e'

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

2018-08-07 07:16:34,121 [pool-3-thread-20] 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`
= 1392 and `performance`.`date` = '2018-08-07'

2018-08-07 07:16:34,122 [pool-3-thread-20] INFO  jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`tpId` = '7a6c5c25fb6a4b55abe021c13f6ac340'

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

2018-08-07 07:16:39,506 [pool-3-thread-20] 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`
= 1393 and `performance`.`date` = '2018-08-07'

2018-08-07 07:16:39,508 [pool-3-thread-20] INFO  c.t.s.f.FacebookAccountDeployer - Sucessfully fetched facebook campaign performance data for seuserID 3587, perf data ([TPCampaignPerformanceDTO [theID=53, theCampaignID=1390, theDate=2018-08-07, theStatus=error, theSpend=0.0, theClicks=0, theImpressions=0, theBudget=10000, theStartDate=2018-08-07T05:22:00.000Z, theEndDate=2018-09-07T03:59:00.000Z, theLastUpdated=2018-08-07T07:16:23.000Z], TPCampaignPerformanceDTO [theID=54, theCampaignID=1391, theDate=2018-08-07, theStatus=error, theSpend=0.0, theClicks=0, theImpressions=0, theBudget=10000, theStartDate=2018-08-07T05:22:00.000Z, theEndDate=2018-09-07T03:59:00.000Z, theLastUpdated=2018-08-07T07:16:28.000Z], TPCampaignPerformanceDTO [theID=55, theCampaignID=1392, theDate=2018-08-07, theStatus=error, theSpend=0.0, theClicks=0, theImpressions=0, theBudget=10000, theStartDate=2018-08-07T05:22:00.000Z, theEndDate=2018-09-07T03:59:00.000Z, theLastUpdated=2018-08-07T07:16:34.000Z], TPCampaignPerformanceDTO [theID=56, theCampaignID=1393, theDate=2018-08-07, theStatus=error, theSpend=0.0, theClicks=0, theImpressions=0, theBudget=10000, theStartDate=2018-08-07T05:22:00.000Z, theEndDate=2018-09-07T03:59:00.000Z, theLastUpdated=2018-08-07T07:16:39.000Z]])
2018-08-07 07:16:39,508 [pool-3-thread-20] INFO  c.t.s.f.FacebookAccountDeployer - Processing carryover for campaignID 1390 [seuserID 3587]
2018-08-07 07:16:39,508 [pool-3-thread-20] INFO  c.t.s.f.FacebookAccountDeployer - actual_monthly_budget for campaignID 1390 : 100.0
2018-08-07 07:16:39,508 [pool-3-thread-20] INFO  c.t.s.f.FacebookAccountDeployer - actual_spend for campaignID 1390 : 0.0
2018-08-07 07:16:39,508 [pool-3-thread-20] INFO  c.t.s.f.FacebookAccountDeployer - campaign start date 2018-08-07T01:22:00.000-04:00 America/New_York, end date 2018-09-06T23:59:00.000-04:00 America/New_York, days 31.0, current date 2018-08-07T03:16:39.508-04:00 America/New_York for campaignID 1390
2018-08-07 07:16:39,508 [pool-3-thread-20] INFO  c.t.s.f.FacebookAccountDeployer - campaignID 1390 active for 0 days (num_of_days_active) and 1 hours (num_of_hours_active)
2018-08-07 07:16:39,508 [pool-3-thread-20] INFO  c.t.s.f.FacebookAccountDeployer - daily_budget [actual_monthly_budget / 31.0] for campaignID 1390 : 3.2258065
2018-08-07 07:16:39,508 [pool-3-thread-20] INFO  c.t.s.f.FacebookAccountDeployer - hourly_budget [daily_budget / 24] for campaignID 1390 : 0.13440861
2018-08-07 07:16:39,508 [pool-3-thread-20] INFO  c.t.s.f.FacebookAccountDeployer - expected_daily_spend [daily_budget * num_of_days_active] for campaignID 1390 : 0.0
2018-08-07 07:16:39,508 [pool-3-thread-20] INFO  c.t.s.f.FacebookAccountDeployer - expected_hourly_spend [hourly_budget * num_of_hours_active] for campaignID 1390 : 0.13440861
2018-08-07 07:16:39,508 [pool-3-thread-20] INFO  c.t.s.f.FacebookAccountDeployer - expected_spend [expected_daily_spend + expected_hourly_spend] for campaignID 1390 : 0.13440861
2018-08-07 07:16:39,508 [pool-3-thread-20] INFO  c.t.s.f.FacebookAccountDeployer - carryover [expected_spend - actual_spend] for campaignID 1390 : 0.13
2018-08-07 07:16:39,508 [pool-3-thread-20] INFO  c.t.s.f.FacebookAccountDeployer - saving carryover TPCampaignCarryoverDTO [theID=null, theCampaignID=1390, theDate=2018-08-07, theCarryover=0.13, theCarryoverType=normal] for campaignID 1390
2018-08-07 07:16:39,510 [pool-3-thread-20] INFO  jdbc.sqlonly - INSERT INTO `monthlyCarryovers` (`campaignID`, `date`, `carryover`, `type`) VALUES (1390,'2018-08-07',0.13,'normal')
ON DUPLICATE KEY UPDATE `carryover`=VALUES(`carryover`), `type`=VALUES(`type`)

2018-08-07 07:16:39,511 [pool-3-thread-20] INFO  jdbc.sqlonly - SELECT `id`, `campaignID`, `date`, `carryover`, `type` FROM `monthlyCarryovers` WHERE `campaignID`
= 1390 and `date` = '2018-08-07' and `type` = 'normal'

2018-08-07 07:16:39,512 [pool-3-thread-20] INFO  c.t.s.f.FacebookAccountDeployer - Processing carryover for campaignID 1391 [seuserID 3587]
2018-08-07 07:16:39,512 [pool-3-thread-20] INFO  c.t.s.f.FacebookAccountDeployer - actual_monthly_budget for campaignID 1391 : 100.0
2018-08-07 07:16:39,512 [pool-3-thread-20] INFO  c.t.s.f.FacebookAccountDeployer - actual_spend for campaignID 1391 : 0.0
2018-08-07 07:16:39,512 [pool-3-thread-20] INFO  c.t.s.f.FacebookAccountDeployer - campaign start date 2018-08-07T01:22:00.000-04:00 America/New_York, end date 2018-09-06T23:59:00.000-04:00 America/New_York, days 31.0, current date 2018-08-07T03:16:39.512-04:00 America/New_York for campaignID 1391
2018-08-07 07:16:39,512 [pool-3-thread-20] INFO  c.t.s.f.FacebookAccountDeployer - campaignID 1391 active for 0 days (num_of_days_active) and 1 hours (num_of_hours_active)
2018-08-07 07:16:39,512 [pool-3-thread-20] INFO  c.t.s.f.FacebookAccountDeployer - daily_budget [actual_monthly_budget / 31.0] for campaignID 1391 : 3.2258065
2018-08-07 07:16:39,512 [pool-3-thread-20] INFO  c.t.s.f.FacebookAccountDeployer - hourly_budget [daily_budget / 24] for campaignID 1391 : 0.13440861
2018-08-07 07:16:39,512 [pool-3-thread-20] INFO  c.t.s.f.FacebookAccountDeployer - expected_daily_spend [daily_budget * num_of_days_active] for campaignID 1391 : 0.0
2018-08-07 07:16:39,512 [pool-3-thread-20] INFO  c.t.s.f.FacebookAccountDeployer - expected_hourly_spend [hourly_budget * num_of_hours_active] for campaignID 1391 : 0.13440861
2018-08-07 07:16:39,512 [pool-3-thread-20] INFO  c.t.s.f.FacebookAccountDeployer - expected_spend [expected_daily_spend + expected_hourly_spend] for campaignID 1391 : 0.13440861
2018-08-07 07:16:39,512 [pool-3-thread-20] INFO  c.t.s.f.FacebookAccountDeployer - carryover [expected_spend - actual_spend] for campaignID 1391 : 0.13
2018-08-07 07:16:39,512 [pool-3-thread-20] INFO  c.t.s.f.FacebookAccountDeployer - saving carryover TPCampaignCarryoverDTO [theID=null, theCampaignID=1391, theDate=2018-08-07, theCarryover=0.13, theCarryoverType=normal] for campaignID 1391
2018-08-07 07:16:39,514 [pool-3-thread-20] INFO  jdbc.sqlonly - INSERT INTO `monthlyCarryovers` (`campaignID`, `date`, `carryover`, `type`) VALUES (1391,'2018-08-07',0.13,'normal')
ON DUPLICATE KEY UPDATE `carryover`=VALUES(`carryover`), `type`=VALUES(`type`)

2018-08-07 07:16:39,515 [pool-3-thread-20] INFO  jdbc.sqlonly - SELECT `id`, `campaignID`, `date`, `carryover`, `type` FROM `monthlyCarryovers` WHERE `campaignID`
= 1391 and `date` = '2018-08-07' and `type` = 'normal'

2018-08-07 07:16:39,516 [pool-3-thread-20] INFO  c.t.s.f.FacebookAccountDeployer - Processing carryover for campaignID 1392 [seuserID 3587]
2018-08-07 07:16:39,516 [pool-3-thread-20] INFO  c.t.s.f.FacebookAccountDeployer - actual_monthly_budget for campaignID 1392 : 100.0
2018-08-07 07:16:39,516 [pool-3-thread-20] INFO  c.t.s.f.FacebookAccountDeployer - actual_spend for campaignID 1392 : 0.0
2018-08-07 07:16:39,516 [pool-3-thread-20] INFO  c.t.s.f.FacebookAccountDeployer - campaign start date 2018-08-07T01:22:00.000-04:00 America/New_York, end date 2018-09-06T23:59:00.000-04:00 America/New_York, days 31.0, current date 2018-08-07T03:16:39.516-04:00 America/New_York for campaignID 1392
2018-08-07 07:16:39,516 [pool-3-thread-20] INFO  c.t.s.f.FacebookAccountDeployer - campaignID 1392 active for 0 days (num_of_days_active) and 1 hours (num_of_hours_active)
2018-08-07 07:16:39,516 [pool-3-thread-20] INFO  c.t.s.f.FacebookAccountDeployer - daily_budget [actual_monthly_budget / 31.0] for campaignID 1392 : 3.2258065
2018-08-07 07:16:39,516 [pool-3-thread-20] INFO  c.t.s.f.FacebookAccountDeployer - hourly_budget [daily_budget / 24] for campaignID 1392 : 0.13440861
2018-08-07 07:16:39,516 [pool-3-thread-20] INFO  c.t.s.f.FacebookAccountDeployer - expected_daily_spend [daily_budget * num_of_days_active] for campaignID 1392 : 0.0
2018-08-07 07:16:39,516 [pool-3-thread-20] INFO  c.t.s.f.FacebookAccountDeployer - expected_hourly_spend [hourly_budget * num_of_hours_active] for campaignID 1392 : 0.13440861
2018-08-07 07:16:39,516 [pool-3-thread-20] INFO  c.t.s.f.FacebookAccountDeployer - expected_spend [expected_daily_spend + expected_hourly_spend] for campaignID 1392 : 0.13440861
2018-08-07 07:16:39,516 [pool-3-thread-20] INFO  c.t.s.f.FacebookAccountDeployer - carryover [expected_spend - actual_spend] for campaignID 1392 : 0.13
2018-08-07 07:16:39,516 [pool-3-thread-20] INFO  c.t.s.f.FacebookAccountDeployer - saving carryover TPCampaignCarryoverDTO [theID=null, theCampaignID=1392, theDate=2018-08-07, theCarryover=0.13, theCarryoverType=normal] for campaignID 1392
2018-08-07 07:16:39,518 [pool-3-thread-20] INFO  jdbc.sqlonly - INSERT INTO `monthlyCarryovers` (`campaignID`, `date`, `carryover`, `type`) VALUES (1392,'2018-08-07',0.13,'normal')
ON DUPLICATE KEY UPDATE `carryover`=VALUES(`carryover`), `type`=VALUES(`type`)

2018-08-07 07:16:39,519 [pool-3-thread-20] INFO  jdbc.sqlonly - SELECT `id`, `campaignID`, `date`, `carryover`, `type` FROM `monthlyCarryovers` WHERE `campaignID`
= 1392 and `date` = '2018-08-07' and `type` = 'normal'

2018-08-07 07:16:39,520 [pool-3-thread-20] INFO  c.t.s.f.FacebookAccountDeployer - Processing carryover for campaignID 1393 [seuserID 3587]
2018-08-07 07:16:39,520 [pool-3-thread-20] INFO  c.t.s.f.FacebookAccountDeployer - actual_monthly_budget for campaignID 1393 : 100.0
2018-08-07 07:16:39,520 [pool-3-thread-20] INFO  c.t.s.f.FacebookAccountDeployer - actual_spend for campaignID 1393 : 0.0
2018-08-07 07:16:39,520 [pool-3-thread-20] INFO  c.t.s.f.FacebookAccountDeployer - campaign start date 2018-08-07T01:22:00.000-04:00 America/New_York, end date 2018-09-06T23:59:00.000-04:00 America/New_York, days 31.0, current date 2018-08-07T03:16:39.520-04:00 America/New_York for campaignID 1393
2018-08-07 07:16:39,520 [pool-3-thread-20] INFO  c.t.s.f.FacebookAccountDeployer - campaignID 1393 active for 0 days (num_of_days_active) and 1 hours (num_of_hours_active)
2018-08-07 07:16:39,520 [pool-3-thread-20] INFO  c.t.s.f.FacebookAccountDeployer - daily_budget [actual_monthly_budget / 31.0] for campaignID 1393 : 3.2258065
2018-08-07 07:16:39,520 [pool-3-thread-20] INFO  c.t.s.f.FacebookAccountDeployer - hourly_budget [daily_budget / 24] for campaignID 1393 : 0.13440861
2018-08-07 07:16:39,520 [pool-3-thread-20] INFO  c.t.s.f.FacebookAccountDeployer - expected_daily_spend [daily_budget * num_of_days_active] for campaignID 1393 : 0.0
2018-08-07 07:16:39,520 [pool-3-thread-20] INFO  c.t.s.f.FacebookAccountDeployer - expected_hourly_spend [hourly_budget * num_of_hours_active] for campaignID 1393 : 0.13440861
2018-08-07 07:16:39,520 [pool-3-thread-20] INFO  c.t.s.f.FacebookAccountDeployer - expected_spend [expected_daily_spend + expected_hourly_spend] for campaignID 1393 : 0.13440861
2018-08-07 07:16:39,521 [pool-3-thread-20] INFO  c.t.s.f.FacebookAccountDeployer - carryover [expected_spend - actual_spend] for campaignID 1393 : 0.13
2018-08-07 07:16:39,521 [pool-3-thread-20] INFO  c.t.s.f.FacebookAccountDeployer - saving carryover TPCampaignCarryoverDTO [theID=null, theCampaignID=1393, theDate=2018-08-07, theCarryover=0.13, theCarryoverType=normal] for campaignID 1393
2018-08-07 07:16:39,523 [pool-3-thread-20] INFO  jdbc.sqlonly - INSERT INTO `monthlyCarryovers` (`campaignID`, `date`, `carryover`, `type`) VALUES (1393,'2018-08-07',0.13,'normal')
ON DUPLICATE KEY UPDATE `carryover`=VALUES(`carryover`), `type`=VALUES(`type`)

2018-08-07 07:16:39,524 [pool-3-thread-20] INFO  jdbc.sqlonly - SELECT `id`, `campaignID`, `date`, `carryover`, `type` FROM `monthlyCarryovers` WHERE `campaignID`
= 1393 and `date` = '2018-08-07' and `type` = 'normal'

2018-08-07 07:16:39.530 (3) [pool-3-thread-20]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2018-08-07 07:16:39.535 (3) [pool-3-thread-20]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2018-08-07 07:16:39.539 (3) [pool-3-thread-20]: 2790da9c-fe48-4f82-ac4f-bd1602a09ecd_10002_12542_23926_GT is already set to Paused in the database.
2018-08-07 07:16:39.539 (3) [pool-3-thread-20]: 2790da9c-fe48-4f82-ac4f-bd1602a09ecd_10002_12542_23926_GM is already set to Paused in the database.
2018-08-07 07:16:39.539 (3) [pool-3-thread-20]: 2790da9c-fe48-4f82-ac4f-bd1602a09ecd_10002_12542_23927_S1 status change (Active->Paused)
2018-08-07 07:16:39.539 (3) [pool-3-thread-20]: 2790da9c-fe48-4f82-ac4f-bd1602a09ecd_10002_12542_23927_S2 status change (Active->Paused)
2018-08-07 07:16:39.539 (3) [pool-3-thread-20]: 2790da9c-fe48-4f82-ac4f-bd1602a09ecd_10002_12542_23927_S3 status change (Active->Paused)
2018-08-07 07:16:39.539 (3) [pool-3-thread-20]: 2790da9c-fe48-4f82-ac4f-bd1602a09ecd_10002_12542_23927_S4 status change (Active->Paused)
2018-08-07 07:16:39.539 (3) [pool-3-thread-20]: 2790da9c-fe48-4f82-ac4f-bd1602a09ecd_10002_12542_23925_GT is already set to Paused in the database.
2018-08-07 07:16:39.539 (3) [pool-3-thread-20]: 2790da9c-fe48-4f82-ac4f-bd1602a09ecd_10002_12542_23925_GM is already set to Paused in the database.
2018-08-07 07:16:39.540 (3) [pool-117-thread-1]: Starting Bing Update Campaign Worker..
2018-08-07 07:16:39.540 (3) [pool-117-thread-1]: Completed Bing Update Campaign Worker..
2018-08-07 07:16:39.540 (3) [pool-117-thread-2]: Starting Facebook Update Campaign Worker..
2018-08-07 07:16:39,540 [pool-117-thread-2] INFO  c.t.s.f.FacebookAccountDeployer - FBAccountDeployer: updateCampaigns
2018-08-07 07:16:39.540 (3) [pool-117-thread-3]: Starting Google Update Campaign Worker..
2018-08-07 07:16:39.540 (3) [pool-117-thread-3]: Skipping feed sync
2018-08-07 07:16:39.540 (3) [pool-117-thread-3]: ----------------Google Content Editor starting
2018-08-07 07:16:39,542 [pool-117-thread-2] INFO  jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`id` IN (1392,1393,1390,1391)

2018-08-07 07:16:39,544 [pool-117-thread-2] INFO  c.t.s.f.FacebookAccountDeployer - accountID 2396: diffing 4 Facebook campaigns
2018-08-07 07:16:39.545 (3) [pool-117-thread-3]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2018-08-07 07:16:39,547 [pool-117-thread-2] INFO  jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`id` IN (1390,1391,1392,1393)

2018-08-07 07:16:39,548 [pool-117-thread-2] INFO  c.t.s.c.t.i.s.CampaignServiceClient - Updating TP campaign [1c9487fa6fc7455c8c47afd0b064c904] status to [pause] for account 0f0717eb460440a3a6d132c74585d478
2018-08-07 07:16:39.550 (3) [P37T1]: DistributionServiceRemoteClient created for 2790da9c-fe48-4f82-ac4f-bd1602a09ecd_2_qa4amltest_FB_Budget_2
2018-08-07 07:16:39,551 [pool-117-thread-2] INFO  o.a.c.i.LoggingOutInterceptor - Outbound Message
---------------------------
ID: 635
Address: https://api.tigerpistol.com/v1/campaigns/1c9487fa6fc7455c8c47afd0b064c904/pause
Http-Method: POST
Content-Type: application/json
Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token IcHjX0XyED53f6ShTWlqq4xbRXkEoiloVA1IXqtU]}
--------------------------------------
2018-08-07 07:16:39.676 (3) [P37T1]: Creating API for reseller DistributionSettings b8a7d340-30e0-4369-97d0-8f901d238f86
2018-08-07 07:16:39.683 (3) [P37T1]: Retrieving credentials for search engine user id : 3588 || client id : 627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com , client secret :uO1pQj_ihl6Jy1fSA7FzCTFE , refresh token : 1/XElVvzhFJlFc7FcqtcZJbj1-erQxMLsEVlrN60XCc4JMrEt0pnthZ_A8mZru5Ei4
2018-08-07 07:16:39,683 [P37T1] INFO  c.t.s.o.core.OAuthServiceComponent - [oauth] Return OAuth credential. Access token = ya29.Gl3yBa8VgToDYPCTEgiunXTiHUMjk00y4JdrW4wS46wkOVgDoyKJzPD0f6ezs_0SyBwKHoYPnR5E8cnW0lx_bwyZ-K3qqf-TklTkuFxPkM8NLSwj0MSyfENHAALS5Ko for adwords (clientID=627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com)
2018-08-07 07:16:39.683 (3) [P37T1]: [oauth] Returning access token from OAuth service: ya29.Gl3yBa8VgToDYPCTEgiunXTiHUMjk00y4JdrW4wS46wkOVgDoyKJzPD0f6ezs_0SyBwKHoYPnR5E8cnW0lx_bwyZ-K3qqf-TklTkuFxPkM8NLSwj0MSyfENHAALS5Ko
2018-08-07 07:16:39.683 (3) [P37T1]: Retrieving credentials for search engine user id : 3588 || client id : 627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com , client secret :uO1pQj_ihl6Jy1fSA7FzCTFE , refresh token : 1/XElVvzhFJlFc7FcqtcZJbj1-erQxMLsEVlrN60XCc4JMrEt0pnthZ_A8mZru5Ei4
2018-08-07 07:16:39,683 [P37T1] INFO  c.t.s.o.core.OAuthServiceComponent - [oauth] Return OAuth credential. Access token = ya29.Gl3yBa8VgToDYPCTEgiunXTiHUMjk00y4JdrW4wS46wkOVgDoyKJzPD0f6ezs_0SyBwKHoYPnR5E8cnW0lx_bwyZ-K3qqf-TklTkuFxPkM8NLSwj0MSyfENHAALS5Ko for adwords (clientID=627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com)
2018-08-07 07:16:39.683 (3) [P37T1]: [oauth] Returning access token from OAuth service: ya29.Gl3yBa8VgToDYPCTEgiunXTiHUMjk00y4JdrW4wS46wkOVgDoyKJzPD0f6ezs_0SyBwKHoYPnR5E8cnW0lx_bwyZ-K3qqf-TklTkuFxPkM8NLSwj0MSyfENHAALS5Ko
2018-08-07 07:16:39.683 (3) [P37T1]: DistributionServiceRemoteClient created for GMB
2018-08-07 07:16:39.695 (3) [P37T1]: Retrieving GMB credentials for search engine user id : 3588 || client id : 627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com , client secret :uO1pQj_ihl6Jy1fSA7FzCTFE , refresh token : 1/fH9q5og0rO9LI5NBJqM4k_YTHb-0XSo2-Qv53oyo5a0
2018-08-07 07:16:39,695 [P37T1] INFO  c.t.s.o.core.OAuthServiceComponent - [oauth] Return OAuth credential. Access token = ya29.Gl3yBSzlvt_AWLDyLOlIRos2chUBc5MHPssSvoy8uOCHMoiSh9HLRgH6ODRc_wT_aPmFIrfsFOStAHSjicnXFBk-vs6rY5VHNciBp0ZLA13JZ9jutUVRaJy4t4kJf6Y for gmb (clientID=627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com)
2018-08-07 07:16:39.695 (3) [P37T1]: DistributionServiceRemoteClient created for 2790da9c-fe48-4f82-ac4f-bd1602a09ecd_2_qa4amltest_FB_Budget_2
2018-08-07 07:16:39.790 (3) [P37T1]: Creating API for reseller DistributionSettings b8a7d340-30e0-4369-97d0-8f901d238f86
2018-08-07 07:16:39.791 (3) [P37T1]: Retrieving credentials for search engine user id : 3588 || client id : 627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com , client secret :uO1pQj_ihl6Jy1fSA7FzCTFE , refresh token : 1/XElVvzhFJlFc7FcqtcZJbj1-erQxMLsEVlrN60XCc4JMrEt0pnthZ_A8mZru5Ei4
2018-08-07 07:16:39,791 [P37T1] INFO  c.t.s.o.core.OAuthServiceComponent - [oauth] Return OAuth credential. Access token = ya29.Gl3yBa8VgToDYPCTEgiunXTiHUMjk00y4JdrW4wS46wkOVgDoyKJzPD0f6ezs_0SyBwKHoYPnR5E8cnW0lx_bwyZ-K3qqf-TklTkuFxPkM8NLSwj0MSyfENHAALS5Ko for adwords (clientID=627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com)
2018-08-07 07:16:39.791 (3) [P37T1]: [oauth] Returning access token from OAuth service: ya29.Gl3yBa8VgToDYPCTEgiunXTiHUMjk00y4JdrW4wS46wkOVgDoyKJzPD0f6ezs_0SyBwKHoYPnR5E8cnW0lx_bwyZ-K3qqf-TklTkuFxPkM8NLSwj0MSyfENHAALS5Ko
2018-08-07 07:16:39.791 (3) [P37T1]: Retrieving credentials for search engine user id : 3588 || client id : 627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com , client secret :uO1pQj_ihl6Jy1fSA7FzCTFE , refresh token : 1/XElVvzhFJlFc7FcqtcZJbj1-erQxMLsEVlrN60XCc4JMrEt0pnthZ_A8mZru5Ei4
2018-08-07 07:16:39,791 [P37T1] INFO  c.t.s.o.core.OAuthServiceComponent - [oauth] Return OAuth credential. Access token = ya29.Gl3yBa8VgToDYPCTEgiunXTiHUMjk00y4JdrW4wS46wkOVgDoyKJzPD0f6ezs_0SyBwKHoYPnR5E8cnW0lx_bwyZ-K3qqf-TklTkuFxPkM8NLSwj0MSyfENHAALS5Ko for adwords (clientID=627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com)
2018-08-07 07:16:39.791 (3) [P37T1]: [oauth] Returning access token from OAuth service: ya29.Gl3yBa8VgToDYPCTEgiunXTiHUMjk00y4JdrW4wS46wkOVgDoyKJzPD0f6ezs_0SyBwKHoYPnR5E8cnW0lx_bwyZ-K3qqf-TklTkuFxPkM8NLSwj0MSyfENHAALS5Ko
2018-08-07 07:16:39.791 (3) [P37T1]: DistributionServiceRemoteClient created for GMB
2018-08-07 07:16:39.802 (3) [P37T1]: Retrieving GMB credentials for search engine user id : 3588 || client id : 627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com , client secret :uO1pQj_ihl6Jy1fSA7FzCTFE , refresh token : 1/fH9q5og0rO9LI5NBJqM4k_YTHb-0XSo2-Qv53oyo5a0
2018-08-07 07:16:39,802 [P37T1] INFO  c.t.s.o.core.OAuthServiceComponent - [oauth] Return OAuth credential. Access token = ya29.Gl3yBSzlvt_AWLDyLOlIRos2chUBc5MHPssSvoy8uOCHMoiSh9HLRgH6ODRc_wT_aPmFIrfsFOStAHSjicnXFBk-vs6rY5VHNciBp0ZLA13JZ9jutUVRaJy4t4kJf6Y for gmb (clientID=627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com)
2018-08-07 07:16:39.812 (2) [P37T1]: CampaignTargetDAO: database is null
2018-08-07 07:16:39.819 (3) [P37T1]: ... SEUser 3588 finished
2018-08-07 07:16:39.819 (3) [pool-117-thread-3]: ------------Google Content Editor done
2018-08-07 07:16:39.819 (3) [pool-117-thread-3]: Completed Google Update Campaign Worker..
2018-08-07 07:16:39,905 [pool-117-thread-2] INFO  o.a.c.i.LoggingInInterceptor - Inbound Message
----------------------------
ID: 635
Response-Code: 200
Encoding: ISO-8859-1
Content-Type:
Headers: {Content-Length=[0], Date=[Tue, 07 Aug 2018 07:16:39 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]}
--------------------------------------
2018-08-07 07:16:44,905 [pool-117-thread-2] INFO  c.t.s.c.t.i.s.CampaignServiceClient - Getting TP campaign [1c9487fa6fc7455c8c47afd0b064c904] details for account 0f0717eb460440a3a6d132c74585d478
2018-08-07 07:16:44,908 [pool-117-thread-2] INFO  o.a.c.i.LoggingOutInterceptor - Outbound Message
---------------------------
ID: 636
Address: https://api.tigerpistol.com/v1/campaigns/1c9487fa6fc7455c8c47afd0b064c904
Http-Method: GET
Content-Type: application/json
Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token IcHjX0XyED53f6ShTWlqq4xbRXkEoiloVA1IXqtU]}
--------------------------------------
2018-08-07 07:16:45,221 [pool-117-thread-2] INFO  o.a.c.i.LoggingInInterceptor - Inbound Message
----------------------------
ID: 636
Response-Code: 200
Encoding: UTF-8
Content-Type: application/json; charset=utf-8
Headers: {Content-Length=[595], content-type=[application/json; charset=utf-8], Date=[Tue, 07 Aug 2018 07:16:45 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]}
Payload: {"variations":[{"index":0,"reviewError":null}],"id":"1c9487fa6fc7455c8c47afd0b064c904","customerId":"0f0717eb460440a3a6d132c74585d478","start":"2018-08-07T05:22:00+00:00","end":"2018-09-07T03:59:00+00:00","budget":10000.0,"objective":"page_likes","displayMargin":1.0,"status":"paused","publishPhase":"complete","hasError":false,"errorMessage":"","spend":0.0,"clicks":0,"cpc":null,"ctr":null,"impressions":0,"cpm":null,"leads":0,"cpl":null,"pageLikes":0,"postEngagements":0,"cppl":null,"cppe":null,"reach":0,"videoViews":0,"cpvv":null,"videoAveragePercentViewed":null,"offersSaved":0,"cpos":null}
--------------------------------------
2018-08-07 07:16:45,222 [pool-117-thread-2] INFO  c.t.s.c.t.i.s.CampaignServiceClient - Updating TP campaign [97fe7b12a2034131928414466a1e6f72] status to [pause] for account 0f0717eb460440a3a6d132c74585d478
2018-08-07 07:16:45,224 [pool-117-thread-2] INFO  o.a.c.i.LoggingOutInterceptor - Outbound Message
---------------------------
ID: 637
Address: https://api.tigerpistol.com/v1/campaigns/97fe7b12a2034131928414466a1e6f72/pause
Http-Method: POST
Content-Type: application/json
Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token IcHjX0XyED53f6ShTWlqq4xbRXkEoiloVA1IXqtU]}
--------------------------------------
2018-08-07 07:16:45,550 [pool-117-thread-2] INFO  o.a.c.i.LoggingInInterceptor - Inbound Message
----------------------------
ID: 637
Response-Code: 200
Encoding: ISO-8859-1
Content-Type:
Headers: {Content-Length=[0], Date=[Tue, 07 Aug 2018 07:16:45 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]}
--------------------------------------
2018-08-07 07:16:50,551 [pool-117-thread-2] INFO  c.t.s.c.t.i.s.CampaignServiceClient - Getting TP campaign [97fe7b12a2034131928414466a1e6f72] details for account 0f0717eb460440a3a6d132c74585d478
2018-08-07 07:16:50,553 [pool-117-thread-2] INFO  o.a.c.i.LoggingOutInterceptor - Outbound Message
---------------------------
ID: 638
Address: https://api.tigerpistol.com/v1/campaigns/97fe7b12a2034131928414466a1e6f72
Http-Method: GET
Content-Type: application/json
Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token IcHjX0XyED53f6ShTWlqq4xbRXkEoiloVA1IXqtU]}
--------------------------------------
2018-08-07 07:16:50.860 (3) [Thread-9]: Heartbeat #3272 (1533626210857) received in 0.003s
2018-08-07 07:16:50,863 [pool-117-thread-2] INFO  o.a.c.i.LoggingInInterceptor - Inbound Message
----------------------------
ID: 638
Response-Code: 200
Encoding: UTF-8
Content-Type: application/json; charset=utf-8
Headers: {Content-Length=[595], content-type=[application/json; charset=utf-8], Date=[Tue, 07 Aug 2018 07:16:50 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]}
Payload: {"variations":[{"index":0,"reviewError":null}],"id":"97fe7b12a2034131928414466a1e6f72","customerId":"0f0717eb460440a3a6d132c74585d478","start":"2018-08-07T05:22:00+00:00","end":"2018-09-07T03:59:00+00:00","budget":10000.0,"objective":"page_likes","displayMargin":1.0,"status":"paused","publishPhase":"complete","hasError":false,"errorMessage":"","spend":0.0,"clicks":0,"cpc":null,"ctr":null,"impressions":0,"cpm":null,"leads":0,"cpl":null,"pageLikes":0,"postEngagements":0,"cppl":null,"cppe":null,"reach":0,"videoViews":0,"cpvv":null,"videoAveragePercentViewed":null,"offersSaved":0,"cpos":null}
--------------------------------------
2018-08-07 07:16:50,864 [pool-117-thread-2] INFO  c.t.s.c.t.i.s.CampaignServiceClient - Updating TP campaign [ab97f56605854745b1c577e7fc8ae07e] status to [pause] for account 0f0717eb460440a3a6d132c74585d478
2018-08-07 07:16:50,866 [pool-117-thread-2] INFO  o.a.c.i.LoggingOutInterceptor - Outbound Message
---------------------------
ID: 639
Address: https://api.tigerpistol.com/v1/campaigns/ab97f56605854745b1c577e7fc8ae07e/pause
Http-Method: POST
Content-Type: application/json
Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token IcHjX0XyED53f6ShTWlqq4xbRXkEoiloVA1IXqtU]}
--------------------------------------
2018-08-07 07:16:51,288 [pool-117-thread-2] INFO  o.a.c.i.LoggingInInterceptor - Inbound Message
----------------------------
ID: 639
Response-Code: 200
Encoding: ISO-8859-1
Content-Type:
Headers: {Content-Length=[0], Date=[Tue, 07 Aug 2018 07:16:50 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]}
--------------------------------------
2018-08-07 07:16:56,289 [pool-117-thread-2] INFO  c.t.s.c.t.i.s.CampaignServiceClient - Getting TP campaign [ab97f56605854745b1c577e7fc8ae07e] details for account 0f0717eb460440a3a6d132c74585d478
2018-08-07 07:16:56,292 [pool-117-thread-2] INFO  o.a.c.i.LoggingOutInterceptor - Outbound Message
---------------------------
ID: 640
Address: https://api.tigerpistol.com/v1/campaigns/ab97f56605854745b1c577e7fc8ae07e
Http-Method: GET
Content-Type: application/json
Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token IcHjX0XyED53f6ShTWlqq4xbRXkEoiloVA1IXqtU]}
--------------------------------------
2018-08-07 07:16:56,640 [pool-117-thread-2] INFO  o.a.c.i.LoggingInInterceptor - Inbound Message
----------------------------
ID: 640
Response-Code: 200
Encoding: UTF-8
Content-Type: application/json; charset=utf-8
Headers: {Content-Length=[595], content-type=[application/json; charset=utf-8], Date=[Tue, 07 Aug 2018 07:16:56 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]}
Payload: {"variations":[{"index":0,"reviewError":null}],"id":"ab97f56605854745b1c577e7fc8ae07e","customerId":"0f0717eb460440a3a6d132c74585d478","start":"2018-08-07T05:22:00+00:00","end":"2018-09-07T03:59:00+00:00","budget":10000.0,"objective":"page_likes","displayMargin":1.0,"status":"paused","publishPhase":"complete","hasError":false,"errorMessage":"","spend":0.0,"clicks":0,"cpc":null,"ctr":null,"impressions":0,"cpm":null,"leads":0,"cpl":null,"pageLikes":0,"postEngagements":0,"cppl":null,"cppe":null,"reach":0,"videoViews":0,"cpvv":null,"videoAveragePercentViewed":null,"offersSaved":0,"cpos":null}
--------------------------------------
2018-08-07 07:16:56,641 [pool-117-thread-2] INFO  c.t.s.c.t.i.s.CampaignServiceClient - Updating TP campaign [7a6c5c25fb6a4b55abe021c13f6ac340] status to [pause] for account 0f0717eb460440a3a6d132c74585d478
2018-08-07 07:16:56,643 [pool-117-thread-2] INFO  o.a.c.i.LoggingOutInterceptor - Outbound Message
---------------------------
ID: 641
Address: https://api.tigerpistol.com/v1/campaigns/7a6c5c25fb6a4b55abe021c13f6ac340/pause
Http-Method: POST
Content-Type: application/json
Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token IcHjX0XyED53f6ShTWlqq4xbRXkEoiloVA1IXqtU]}
--------------------------------------
2018-08-07 07:16:56,995 [pool-117-thread-2] INFO  o.a.c.i.LoggingInInterceptor - Inbound Message
----------------------------
ID: 641
Response-Code: 200
Encoding: ISO-8859-1
Content-Type:
Headers: {Content-Length=[0], Date=[Tue, 07 Aug 2018 07:16:56 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]}
--------------------------------------
2018-08-07 07:17:01,995 [pool-117-thread-2] INFO  c.t.s.c.t.i.s.CampaignServiceClient - Getting TP campaign [7a6c5c25fb6a4b55abe021c13f6ac340] details for account 0f0717eb460440a3a6d132c74585d478
2018-08-07 07:17:01,998 [pool-117-thread-2] INFO  o.a.c.i.LoggingOutInterceptor - Outbound Message
---------------------------
ID: 642
Address: https://api.tigerpistol.com/v1/campaigns/7a6c5c25fb6a4b55abe021c13f6ac340
Http-Method: GET
Content-Type: application/json
Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token IcHjX0XyED53f6ShTWlqq4xbRXkEoiloVA1IXqtU]}
--------------------------------------
2018-08-07 07:17:02,323 [pool-117-thread-2] INFO  o.a.c.i.LoggingInInterceptor - Inbound Message
----------------------------
ID: 642
Response-Code: 200
Encoding: UTF-8
Content-Type: application/json; charset=utf-8
Headers: {Content-Length=[595], content-type=[application/json; charset=utf-8], Date=[Tue, 07 Aug 2018 07:17:01 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]}
Payload: {"variations":[{"index":0,"reviewError":null}],"id":"7a6c5c25fb6a4b55abe021c13f6ac340","customerId":"0f0717eb460440a3a6d132c74585d478","start":"2018-08-07T05:22:00+00:00","end":"2018-09-07T03:59:00+00:00","budget":10000.0,"objective":"page_likes","displayMargin":1.0,"status":"paused","publishPhase":"complete","hasError":false,"errorMessage":"","spend":0.0,"clicks":0,"cpc":null,"ctr":null,"impressions":0,"cpm":null,"leads":0,"cpl":null,"pageLikes":0,"postEngagements":0,"cppl":null,"cppe":null,"reach":0,"videoViews":0,"cpvv":null,"videoAveragePercentViewed":null,"offersSaved":0,"cpos":null}
--------------------------------------
2018-08-07 07:17:02,325 [pool-117-thread-2] INFO  jdbc.sqlonly - UPDATE `campaigns` SET `campaigns`.`tpId` = '1c9487fa6fc7455c8c47afd0b064c904', `campaigns`.`name`
= '2790da9c-fe48-4f82-ac4f-bd1602a09ecd_10002_12542_23927_S1', `campaigns`.`status` = 'Paused',
`campaigns`.`endDate` = '09/07/2018 03:59:59.999', `campaigns`.`lastUpdated` = NOW(), `campaigns`.`json`
= '{"campaign":{"name":"2790da9c-fe48-4f82-ac4f-bd1602a09ecd_10002_12542_23927_S1","status":"Paused","id":"1c9487fa6fc7455c8c47afd0b064c904","customerId":"0f0717eb460440a3a6d132c74585d478","objective":"page_likes","budget":10000,"start":"2018-08-07T05:22:37.388Z","maxEnd":"2018-09-07T03:59:59.999Z","placement":["desktopfeed","mobilefeed","instagramfeed","rightcolumn"],"details":{"audiences":[{"ageFrom":18,"ageTo":65,"gender":"all","locationTypes":["home","recent"],"demographics":{"life_events":["6003053857372"],"behaviors":["6002714895372"],"family_statuses":["6002714398372"],"home_type":["23842646930010111"],"interests":["6002926108721"]},"locations":[{"type":"city","id":"2417653"}]}],"copies":[{"headline":"The
Hotel for You","body":"Aliso Viejo Hotel Rooms. We Get Service Right.","description":"Hotel
Room in 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":[]}},"searchEngineUserId":3587}'
WHERE `campaigns`.`id` = 1390

2018-08-07 07:17:02,326 [pool-117-thread-2] INFO  jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`id` = 1390

2018-08-07 07:17:02,327 [pool-117-thread-2] INFO  jdbc.sqlonly - UPDATE `campaigns` SET `campaigns`.`tpId` = '97fe7b12a2034131928414466a1e6f72', `campaigns`.`name`
= '2790da9c-fe48-4f82-ac4f-bd1602a09ecd_10002_12542_23927_S2', `campaigns`.`status` = 'Paused',
`campaigns`.`endDate` = '09/07/2018 03:59:59.999', `campaigns`.`lastUpdated` = NOW(), `campaigns`.`json`
= '{"campaign":{"name":"2790da9c-fe48-4f82-ac4f-bd1602a09ecd_10002_12542_23927_S2","status":"Paused","id":"97fe7b12a2034131928414466a1e6f72","customerId":"0f0717eb460440a3a6d132c74585d478","objective":"page_likes","budget":10000,"start":"2018-08-07T05:22:37.413Z","maxEnd":"2018-09-07T03:59:59.999Z","placement":["desktopfeed","mobilefeed","instagramfeed","rightcolumn"],"details":{"audiences":[{"ageFrom":18,"ageTo":65,"gender":"all","locationTypes":["home","recent"],"demographics":{"life_events":["6003053857372"],"behaviors":["6002714895372"],"family_statuses":["6002714398372"],"home_type":["23842646930010111"],"interests":["6002926108721"]},"locations":[{"type":"city","id":"2417653"}]}],"copies":[{"headline":"Hotel
in Aliso Viejo","body":"Aliso Viejo Guest Rooms. Find Out Why Guests Love Us!","description":"Convenient
Hotel","destinationUrl":"http://www.merchantsite.com/"}],"images":["https://aml-qa.s3.us-west-1.amazonaws.com/usa/10002/images/image-10002-4.jpg"],"cta":[]}},"searchEngineUserId":3587}'
WHERE `campaigns`.`id` = 1391

2018-08-07 07:17:02,327 [pool-117-thread-2] INFO  jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`id` = 1391

2018-08-07 07:17:02,328 [pool-117-thread-2] INFO  jdbc.sqlonly - UPDATE `campaigns` SET `campaigns`.`tpId` = 'ab97f56605854745b1c577e7fc8ae07e', `campaigns`.`name`
= '2790da9c-fe48-4f82-ac4f-bd1602a09ecd_10002_12542_23927_S3', `campaigns`.`status` = 'Paused',
`campaigns`.`endDate` = '09/07/2018 03:59:59.999', `campaigns`.`lastUpdated` = NOW(), `campaigns`.`json`
= '{"campaign":{"name":"2790da9c-fe48-4f82-ac4f-bd1602a09ecd_10002_12542_23927_S3","status":"Paused","id":"ab97f56605854745b1c577e7fc8ae07e","customerId":"0f0717eb460440a3a6d132c74585d478","objective":"page_likes","budget":10000,"start":"2018-08-07T05:22:37.422Z","maxEnd":"2018-09-07T03:59:59.999Z","placement":["desktopfeed","mobilefeed","instagramfeed","rightcolumn"],"details":{"audiences":[{"ageFrom":18,"ageTo":65,"gender":"all","locationTypes":["home","recent"],"demographics":{"life_events":["6003053857372"],"behaviors":["6002714895372"],"family_statuses":["6002714398372"],"home_type":["23842646930010111"],"interests":["6002926108721"]},"locations":[{"type":"city","id":"2417653"}]}],"copies":[{"headline":"Hotel
Room in Aliso Viejo","body":"Aliso Viejo Hotel Rooms. We Get Service Right.","description":"The
Hotel for You","destinationUrl":"http://www.merchantsite.com/"}],"images":["https://aml-qa.s3.us-west-1.amazonaws.com/usa/10002/images/image-10002-3.jpg"],"cta":[]}},"searchEngineUserId":3587}'
WHERE `campaigns`.`id` = 1392

2018-08-07 07:17:02,329 [pool-117-thread-2] INFO  jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`id` = 1392

2018-08-07 07:17:02,330 [pool-117-thread-2] INFO  jdbc.sqlonly - UPDATE `campaigns` SET `campaigns`.`tpId` = '7a6c5c25fb6a4b55abe021c13f6ac340', `campaigns`.`name`
= '2790da9c-fe48-4f82-ac4f-bd1602a09ecd_10002_12542_23927_S4', `campaigns`.`status` = 'Paused',
`campaigns`.`endDate` = '09/07/2018 03:59:59.999', `campaigns`.`lastUpdated` = NOW(), `campaigns`.`json`
= '{"campaign":{"name":"2790da9c-fe48-4f82-ac4f-bd1602a09ecd_10002_12542_23927_S4","status":"Paused","id":"7a6c5c25fb6a4b55abe021c13f6ac340","customerId":"0f0717eb460440a3a6d132c74585d478","objective":"page_likes","budget":10000,"start":"2018-08-07T05:22:37.430Z","maxEnd":"2018-09-07T03:59:59.999Z","placement":["desktopfeed","mobilefeed","instagramfeed","rightcolumn"],"details":{"audiences":[{"ageFrom":18,"ageTo":65,"gender":"all","locationTypes":["home","recent"],"demographics":{"life_events":["6003053857372"],"behaviors":["6002714895372"],"family_statuses":["6002714398372"],"home_type":["23842646930010111"],"interests":["6002926108721"]},"locations":[{"type":"city","id":"2417653"}]}],"copies":[{"headline":"Convenient
Hotel","body":"Aliso Viejo Guest Rooms. Find Out Why Guests Love Us!","description":"Hotel
in Aliso Viejo","destinationUrl":"http://www.merchantsite.com/"}],"images":["https://aml-qa.s3.us-west-1.amazonaws.com/usa/10002/images/image-10002-2.jpg"],"cta":[]}},"searchEngineUserId":3587}'
WHERE `campaigns`.`id` = 1393

2018-08-07 07:17:02,331 [pool-117-thread-2] INFO  jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`id` = 1393

2018-08-07 07:17:02.332 (3) [pool-117-thread-2]: Completed Facebook Update Campaign Worker..
2018-08-07 07:17:02.339 (3) [pool-3-thread-20]: SE Update account will run for 2790da9c-fe48-4f82-ac4f-bd1602a09ecd_10002_12542_23927_S1
2018-08-07 07:17:02.339 (3) [pool-3-thread-20]: SE Update account will run for 2790da9c-fe48-4f82-ac4f-bd1602a09ecd_10002_12542_23927_S2
2018-08-07 07:17:02.339 (3) [pool-3-thread-20]: SE Update account will run for 2790da9c-fe48-4f82-ac4f-bd1602a09ecd_10002_12542_23927_S3
2018-08-07 07:17:02.339 (3) [pool-3-thread-20]: SE Update account will run for 2790da9c-fe48-4f82-ac4f-bd1602a09ecd_10002_12542_23927_S4
2018-08-07 07:17:07.339 (3) [pool-3-thread-20]: JobExecutor running job [2018-08-07_071702_a2396_campaignUpdateWorkerSyncCampaignStatus_IfdkQ0bH0o]: [/usr/local/tsa/bidmgr/seupdate.sh, , -d, 3, --inactive, --accountid, 2396, --accounts]
2018-08-07 07:17:16.583 (3) [pool-3-thread-20]: JobExecutor finished running job [2018-08-07_071702_a2396_campaignUpdateWorkerSyncCampaignStatus_IfdkQ0bH0o], exit code=0 in 9.239s
2018-08-07 07:17:16.583 (3) [pool-3-thread-20]: JobExecutor finished 2018-08-07_071702_a2396_campaignUpdateWorkerSyncCampaignStatus_IfdkQ0bH0o. hasError=false, numTries=1
2018-08-07 07:17:16.583 (3) [pool-3-thread-20]: Campaign structure sync not enabled for this request.
2018-08-07 07:17:16,586 [pool-3-thread-20] INFO  jdbc.sqlonly - SELECT `errors`.`errorJson` FROM `campaigns` JOIN `errors` ON `errors`.`elementName` = `campaigns`.`name`
WHERE `campaigns`.`id` IN (1392)

2018-08-07 07:17:16.588 (3) [pool-3-thread-20]: Structure sync disabled, ignoring 1 structure operation errors.
2018-08-07 07:17:16.588 (3) [pool-3-thread-20]: 23927_S3 has no applicable GCE errors.
2018-08-07 07:17:16,590 [pool-3-thread-20] INFO  jdbc.sqlonly - SELECT `errors`.`errorJson` FROM `campaigns` JOIN `errors` ON `errors`.`elementName` = `campaigns`.`name`
WHERE `campaigns`.`id` IN (1393)

2018-08-07 07:17:16.592 (3) [pool-3-thread-20]: Structure sync disabled, ignoring 1 structure operation errors.
2018-08-07 07:17:16.592 (3) [pool-3-thread-20]: 23927_S4 has no applicable GCE errors.
2018-08-07 07:17:16,594 [pool-3-thread-20] INFO  jdbc.sqlonly - SELECT `errors`.`errorJson` FROM `campaigns` JOIN `errors` ON `errors`.`campaignName` = `campaigns`.`name`
WHERE `campaigns`.`id` IN (4780)

2018-08-07 07:17:16.595 (3) [pool-3-thread-20]: Structure sync disabled, ignoring 0 structure operation errors.
2018-08-07 07:17:16.595 (3) [pool-3-thread-20]: 23925_GT has no applicable GCE errors.
2018-08-07 07:17:16,597 [pool-3-thread-20] INFO  jdbc.sqlonly - SELECT `errors`.`errorJson` FROM `campaigns` JOIN `errors` ON `errors`.`campaignName` = `campaigns`.`name`
WHERE `campaigns`.`id` IN (4781)

2018-08-07 07:17:16.598 (3) [pool-3-thread-20]: Structure sync disabled, ignoring 0 structure operation errors.
2018-08-07 07:17:16.598 (3) [pool-3-thread-20]: 23925_GM has no applicable GCE errors.
2018-08-07 07:17:16.602 (3) [pool-3-thread-20]: Structure sync disabled, ignoring 0 structure operation errors.
2018-08-07 07:17:16.602 (3) [pool-3-thread-20]: 23926_GT has no applicable GCE errors.
2018-08-07 07:17:16,605 [pool-3-thread-20] INFO  jdbc.sqlonly - SELECT `errors`.`errorJson` FROM `campaigns` JOIN `errors` ON `errors`.`elementName` = `campaigns`.`name`
WHERE `campaigns`.`id` IN (1390)

2018-08-07 07:17:16.606 (3) [pool-3-thread-20]: Structure sync disabled, ignoring 1 structure operation errors.
2018-08-07 07:17:16.606 (3) [pool-3-thread-20]: 23927_S1 has no applicable GCE errors.
2018-08-07 07:17:16.610 (3) [pool-3-thread-20]: Structure sync disabled, ignoring 0 structure operation errors.
2018-08-07 07:17:16.610 (3) [pool-3-thread-20]: 23926_GM has no applicable GCE errors.
2018-08-07 07:17:16,613 [pool-3-thread-20] INFO  jdbc.sqlonly - SELECT `errors`.`errorJson` FROM `campaigns` JOIN `errors` ON `errors`.`elementName` = `campaigns`.`name`
WHERE `campaigns`.`id` IN (1391)

2018-08-07 07:17:16.615 (3) [pool-3-thread-20]: Structure sync disabled, ignoring 1 structure operation errors.
2018-08-07 07:17:16.615 (3) [pool-3-thread-20]: 23927_S2 has no applicable GCE errors.
2018-08-07 07:17:16.615 (3) [pool-3-thread-20]: Finished UPDATE request for campaign 2790da9c-fe48-4f82-ac4f-bd1602a09ecd_10002_12542_23925_GM: SUCCEEDED (merchant: 2790da9c-fe48-4f82-ac4f-bd1602a09ecd)
2018-08-07 07:17:16.616 (3) [pool-3-thread-20]: Finished UPDATE request for campaign 2790da9c-fe48-4f82-ac4f-bd1602a09ecd_10002_12542_23925_GT: SUCCEEDED (merchant: 2790da9c-fe48-4f82-ac4f-bd1602a09ecd)
2018-08-07 07:17:16.616 (3) [pool-3-thread-20]: Finished UPDATE request for campaign 2790da9c-fe48-4f82-ac4f-bd1602a09ecd_10002_12542_23926_GM: SUCCEEDED (merchant: 2790da9c-fe48-4f82-ac4f-bd1602a09ecd)
2018-08-07 07:17:16.617 (3) [pool-3-thread-20]: Finished UPDATE request for campaign 2790da9c-fe48-4f82-ac4f-bd1602a09ecd_10002_12542_23926_GT: SUCCEEDED (merchant: 2790da9c-fe48-4f82-ac4f-bd1602a09ecd)
2018-08-07 07:17:16.617 (3) [pool-3-thread-20]: Finished UPDATE request for campaign 2790da9c-fe48-4f82-ac4f-bd1602a09ecd_10002_12542_23927_S1: SUCCEEDED (merchant: 2790da9c-fe48-4f82-ac4f-bd1602a09ecd)
2018-08-07 07:17:16.618 (3) [pool-3-thread-20]: Finished UPDATE request for campaign 2790da9c-fe48-4f82-ac4f-bd1602a09ecd_10002_12542_23927_S2: SUCCEEDED (merchant: 2790da9c-fe48-4f82-ac4f-bd1602a09ecd)
2018-08-07 07:17:16.618 (3) [pool-3-thread-20]: Finished UPDATE request for campaign 2790da9c-fe48-4f82-ac4f-bd1602a09ecd_10002_12542_23927_S3: SUCCEEDED (merchant: 2790da9c-fe48-4f82-ac4f-bd1602a09ecd)
2018-08-07 07:17:16.618 (3) [pool-3-thread-20]: Finished UPDATE request for campaign 2790da9c-fe48-4f82-ac4f-bd1602a09ecd_10002_12542_23927_S4: SUCCEEDED (merchant: 2790da9c-fe48-4f82-ac4f-bd1602a09ecd)
2018-08-07 07:17:16.618 (3) [pool-3-thread-20]: 2790da9c-fe48-4f82-ac4f-bd1602a09ecd has 0 campaigns for a SE Update accounts sync.
2018-08-07 07:17:16.619 (3) [pool-3-thread-20]: 2790da9c-fe48-4f82-ac4f-bd1602a09ecd has 0 campaigns for a SE Update groups-listings sync.
2018-08-07 07:17:16.619 (3) [pool-3-thread-20]: Finished sub-campaign processing for UPDATE deploymentID (ab9185f7-ce46-492f-9274-146867e822b4). account 2790da9c-fe48-4f82-ac4f-bd1602a09ecd. 8 submitted, 8 ok.
2018-08-07 07:17:16.619 (3) [pool-3-thread-20]: Updating deployment status to 'Success' for campaignID: 23925
2018-08-07 07:17:16.620 (3) [pool-3-thread-20]: Finished UPDATE request for 23925: SUCCEEDED (merchant: 2790da9c-fe48-4f82-ac4f-bd1602a09ecd)
2018-08-07 07:17:16.620 (3) [pool-3-thread-20]: Updating deployment status to 'Success' for campaignID: 23926
2018-08-07 07:17:16.620 (3) [pool-3-thread-20]: Finished UPDATE request for 23926: SUCCEEDED (merchant: 2790da9c-fe48-4f82-ac4f-bd1602a09ecd)
2018-08-07 07:17:16.620 (3) [pool-3-thread-20]: Updating deployment status to 'Success' for campaignID: 23927
2018-08-07 07:17:16.620 (3) [pool-3-thread-20]: Finished UPDATE request for 23927: SUCCEEDED (merchant: 2790da9c-fe48-4f82-ac4f-bd1602a09ecd)
2018-08-07 07:17:16.620 (3) [pool-3-thread-20]: Finished UPDATE request, deploymentID (ab9185f7-ce46-492f-9274-146867e822b4), account 2790da9c-fe48-4f82-ac4f-bd1602a09ecd
2018-08-07 07:17:16.621 (3) [pool-3-thread-20]: Request removed from map for customerID 2790da9c-fe48-4f82-ac4f-bd1602a09ecd
2018-08-07 07:17:17.496 (3) [AdMaxListener]: Sent message to response queue.
2018-08-07 07:17:20.860 (3) [Thread-9]: Heartbeat #3273 (1533626240857) received in 0.003s
2018-08-07 07:17:50.860 (3) [Thread-9]: Heartbeat #3274 (1533626270857) received in 0.003s