[TSAApp@aml-qa4-core1 bidmgr]$ ./whsumm.sh -d3 -a2378 --highgran -T2018-05-22 Java HotSpot(TM) 64-Bit Server VM warning: Using incremental CMS is deprecated and will likely be removed in a future release ------- Loaded DatabaseAccounts properties from file:/usr/local/tsa/bidmgr-distribution-2.9.22-BETA1-dev-t20180618-1439/libs/deployment-bidmgr-shaded-jar-2.9.22-BETA1.jar!/core-jdb-datasource.properties ------- {datasource-user=spike, datasource-password=tar63t} 2018-06-27 07:55:11.990 (3) [main]: Debug Level set to 3 2018-06-27 07:55:11.991 (3) [main]: Licensing environment detected, loading configuration. 2018-06-27 07:55:11.991 (3) [main]: Loaded property: distribution-service-url=http://aml-qa4-front1:8080/distribution 2018-06-27 07:55:11.991 (3) [main]: Loaded property: distribution-service-username=readwrite 2018-06-27 07:55:11.992 (3) [main]: Loaded property: distribution-service-password=readwrite 2018-06-27 07:55:11.992 (3) [main]: Loaded property: sapi-auth-url=http://aml-qa4-front1:8080/sapi/rest/security/tokens 2018-06-27 07:55:11.992 (3) [main]: Loaded property: sapi-merchant-service-url=http://aml-qa4-front1:8080/sapi/rest/merchants 2018-06-27 07:55:11.992 (3) [main]: Loaded property: sapi-reseller-service-url=http://aml-qa4-front1:8080/sapi/rest/resellers 2018-06-27 07:55:11.992 (3) [main]: Loaded property: sapi-username=admin+tsa@thesearchagency.com 2018-06-27 07:55:11.992 (3) [main]: Loaded property: sapi-password=admin 2018-06-27 07:55:11.992 (3) [main]: Loaded property: sapi-realm=thesearchagency 2018-06-27 07:55:11.992 (3) [main]: Loaded property: tsa.google.mcc.developerToken=ojCnjZaM6RD1h0yt_DOJZg 2018-06-27 07:55:11.992 (3) [main]: Loaded property: tsa.google.mcc.isReseller=true 2018-06-27 07:55:11.993 (3) [main]: Loaded property: tsa.google.mcc.userAgent=AdMaxLocal AdWords Software TSA QA 2018-06-27 07:55:11.993 (3) [main]: Loaded property: tsa.timezone=UTC 2018-06-27 07:55:11.994 (3) [main]: Debug Level set to 3 2018-06-27 07:55:12.001 (2) [main]: No filter given, assuming search engine & client data 2018-06-27 07:55:12.076 (3) [main]: =============== Starting Warehouse Summarizer ================ 2018-06-27 07:55:12.076 (3) [main]: ----------------Warehouse Summarizer starting 2018-06-27 07:55:12.308 (3) [main]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2018-06-27 07:55:12.333 (3) [main]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2018-06-27 07:55:12.374 (3) [P1T1]: DatabasePool with a limit of 80 created 2018-06-27 07:55:12.388 (3) [P1T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2018-06-27 07:55:12.402 (3) [P1T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2018-06-27 07:55:12.406 (3) [P1T1]: DatabasePool with a limit of 80 created 2018-06-27 07:55:12.414 (3) [P1T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2018-06-27 07:55:12.422 (3) [P1T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2018-06-27 07:55:12.426 (3) [P1T1]: DatabasePool with a limit of 80 created 2018-06-27 07:55:12.434 (3) [P1T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2018-06-27 07:55:12.438 (3) [P1T1]: Syncing searchEngineListings... 2018-06-27 07:55:12.490 (3) [P1T1]: Syncing 1 rows in accountChannelMap... 2018-06-27 07:55:12.490 (3) [P1T1]: Syncing 0 to 10000 of 1 2018-06-27 07:55:12.496 (3) [P1T1]: Syncing 5 rows in campaigns... 2018-06-27 07:55:12.498 (3) [P1T1]: Syncing 0 to 10000 of 5 2018-06-27 07:55:12.507 (3) [P1T1]: Syncing 0 rows in products... 2018-06-27 07:55:12.510 (3) [P1T1]: Syncing 0 rows in searchEngineConversionTypeProductMap... 2018-06-27 07:55:12.511 (3) [P1T1]: Syncing 24 rows in searchEngineGroups... 2018-06-27 07:55:12.515 (3) [P1T1]: Syncing 0 to 10000 of 24 2018-06-27 07:55:12.538 (3) [P1T1]: Starting daily for Account #2378 7be2581a-0cca-448c-91d2-f7be1ee6cab3 for Tue May 22 00:00:00 UTC 2018 2018-06-27 07:55:12.544 (3) [P1T1]: Starting Account #2378 7be2581a-0cca-448c-91d2-f7be1ee6cab3 daily group aggregates for Tue May 22 00:00:00 UTC 2018 to = '05/22/2018 00:00:00.000' AND `start_date` < '05/23/2018 00:00:00.000' 2018-06-27 07:55:14,700 [main] INFO c.t.p.m.dao.MerchantPerformanceDAO - clearDailyPerformanceData ran, affected 7 rows 2018-06-27 07:55:14,702 [main] INFO jdbc.sqlonly - INSERT INTO `merchant_performance`(`merchant_uuid`, `start_date`,`distributionID`, `imps`, `clicks`, `cost`) SELECT a.description AS `merchant_uuid`, w.startTime as start_date, w.distributionID as distributionID, SUM(w.seImpressions) AS `imps`, SUM(w.seClicks) AS `clicks`, SUM(w.seAdCost) AS `cost` FROM `warehouse_1`.`whDailyGroupPerf` w JOIN `tsacommon`.`accounts` AS a ON w.accountID = a.id WHERE w.startTime >= '05/22/2018 00:00:00.000' AND w.startTime < '05/23/2018 00:00:00.000' GROUP BY w.startTime, a.description, w.distributionID ON DUPLICATE KEY UPDATE `imps` = values(`imps`), `clicks` = values(`clicks`), `cost` = values(`cost`) 2018-06-27 07:55:14,703 [main] INFO c.t.p.m.dao.MerchantPerformanceDAO - addDailyPerformanceData ran, affected 0 rows 2018-06-27 07:55:14,709 [main] INFO jdbc.sqlonly - UPDATE `merchant_performance` SET `adwords_leads` = 0 WHERE `start_date` >= '05/22/2018 00:00:00.000' AND `start_date` < '05/23/2018 00:00:00.000' 2018-06-27 07:55:14,717 [main] INFO c.t.p.m.dao.MerchantPerformanceDAO - clearDailyAdwordsData ran, affected 7 rows 2018-06-27 07:55:14,718 [main] INFO jdbc.sqlonly - INSERT INTO `merchant_performance`(`merchant_uuid`, `start_date`, `distributionID`, `adwords_leads`) SELECT a.description AS `merchant_uuid`, w.startTime as start_date, 3, SUM(w.seConversions) AS `adwords_leads` FROM `warehouse_1`.`whDailyGroupConv` w JOIN `tsacommon`.`accounts` AS a ON w.accountID = a.id WHERE w.startTime >= '05/22/2018 00:00:00.000' AND w.startTime < '05/23/2018 00:00:00.000' AND w.scope = 'cart' GROUP BY w.startTime, a.description ON DUPLICATE KEY UPDATE `adwords_leads` = values(`adwords_leads`) 2018-06-27 07:55:14,718 [main] INFO c.t.p.m.dao.MerchantPerformanceDAO - addDailyAdwordsData ran, affected 0 rows 2018-06-27 07:55:14.720 (3) [main]: =============== Completed Warehouse Summarizer ================ 2018-06-27 07:55:14,724 [Thread-3] INFO o.s.c.s.ClassPathXmlApplicationContext - Closing org.springframework.context.support.ClassPathXmlApplicationContext@5579bb86: startup date [Wed Jun 27 07:55:12 UTC 2018]; root of context hierarchy