[TSAApp@aq-qa2-core1 bidmgr]$ ./get-kw-approval-status.sh -d3 -U1547 -e Java HotSpot(TM) 64-Bit Server VM warning: Using incremental CMS is deprecated and will likely be removed in a future release 2018-11-05 14:29:33.834 (3) [main]: Debug Level set to 3 ------- Loaded DatabaseAccounts properties from file:/usr/local/tsa/bidmgr-distribution-2.9.24-BETA2-dev-t20181030-1654/libs/deployment-bidmgr-shaded-jar-2.9.24-BETA2.jar!/core-jdb-datasource.properties ------- {datasource-user=spike, datasource-password=tar63t} 2018-11-05 14:29:33.850 (3) [main]: Debug Level set to 3 2018-11-05 14:29:33.942 (3) [main]: DatabasePool with a limit of 80 created 2018-11-05 14:29:34.192 (3) [main]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2018-11-05 14:29:34.195 (3) [main]: =============== Starting Get Keyword Approval Status ================ 2018-11-05 14:29:34.195 (3) [main]: ---------------- Distribution Dispatcher for Get Keyword Approval Status starting 2018-11-05 14:29:34.229 (3) [main]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2018-11-05 14:29:34.240 (3) [P1T1]: Starting Distribution 3 2018-11-05 14:29:34.240 (3) [P1T1]: ----------------GetKWApprovalStatus - Distribution Worker starting 2018-11-05 14:29:34.243 (3) [P1T2]: Starting Distribution 5 2018-11-05 14:29:34.244 (3) [P1T2]: ----------------GetKWApprovalStatus - Distribution Worker starting 2018-11-05 14:29:34.251 (3) [P1T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2018-11-05 14:29:34.255 (3) [P1T3]: Starting Distribution 35 2018-11-05 14:29:34.255 (3) [P1T3]: ----------------GetKWApprovalStatus - Distribution Worker starting 2018-11-05 14:29:34.268 (3) [P2T1]: === Starting user #1547, 58f2b08e-e8e5-4346-b5c8-d845715da03d_1_orange_Cashew_003 === 2018-11-05 14:29:34.274 (3) [P1T2]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2018-11-05 14:29:34.305 (3) [P1T2]: ------------GetKWApprovalStatus - Distribution Worker done 2018-11-05 14:29:34.305 (3) [P1T2]: --------------- Printing Disapproved Keywords 2018-11-05 14:29:34.305 (3) [P1T2]: Completed Distribution 5 2018-11-05 14:29:34.307 (3) [P1T3]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2018-11-05 14:29:34.308 (3) [P1T3]: ------------GetKWApprovalStatus - Distribution Worker done 2018-11-05 14:29:34.308 (3) [P1T3]: --------------- Printing Disapproved Keywords 2018-11-05 14:29:34.308 (3) [P1T3]: Completed Distribution 35 2018-11-05 14:29:34.340 (3) [P2T1]: LicensingFileRefresher: modification detected on 1527139307000 for licensing.properties 2018-11-05 14:29:34.340 (3) [P2T1]: Licensing environment detected, loading configuration. 2018-11-05 14:29:34.341 (3) [P2T1]: Loaded property: distribution-service-url=http://aq-qa2-front1:8080/distribution 2018-11-05 14:29:34.341 (3) [P2T1]: Loaded property: distribution-service-username=readwrite 2018-11-05 14:29:34.341 (3) [P2T1]: Loaded property: distribution-service-password=readwrite 2018-11-05 14:29:34.341 (3) [P2T1]: Loaded property: sapi-auth-url=http://aq-qa2-front1:8080/sapi/rest/security/tokens 2018-11-05 14:29:34.341 (3) [P2T1]: Loaded property: sapi-merchant-service-url=http://aq-qa2-front1:8080/sapi/rest/merchants 2018-11-05 14:29:34.341 (3) [P2T1]: Loaded property: sapi-reseller-service-url=http://aq-qa2-front1:8080/sapi/rest/resellers 2018-11-05 14:29:34.341 (3) [P2T1]: Loaded property: sapi-username=admin+tsa@thesearchagency.com 2018-11-05 14:29:34.342 (3) [P2T1]: Loaded property: sapi-password=admin 2018-11-05 14:29:34.342 (3) [P2T1]: Loaded property: sapi-realm=thesearchagency 2018-11-05 14:29:34.342 (3) [P2T1]: Loaded property: tsa.google.mcc.developerToken=ojCnjZaM6RD1h0yt_DOJZg 2018-11-05 14:29:34.342 (3) [P2T1]: Loaded property: tsa.google.mcc.isReseller=true 2018-11-05 14:29:34.342 (3) [P2T1]: Loaded property: tsa.timezone=UTC 2018-11-05 14:29:34.344 (3) [P2T1]: DistributionServiceRemoteClient created for 58f2b08e-e8e5-4346-b5c8-d845715da03d_1_orange_Cashew_003 2018-11-05 14:29:34,582 [main] INFO o.s.c.s.ClassPathXmlApplicationContext - Refreshing org.springframework.context.support.ClassPathXmlApplicationContext@587c290d: startup date [Mon Nov 05 14:29:34 UTC 2018]; root of context hierarchy 2018-11-05 14:29:34,618 [main] INFO o.s.b.f.xml.XmlBeanDefinitionReader - Loading XML bean definitions from class path resource [bing-main-spring-config.xml] 2018-11-05 14:29:34,831 [main] INFO o.s.b.f.xml.XmlBeanDefinitionReader - Loading XML bean definitions from URL [jar:file:/usr/local/tsa/bidmgr-distribution-2.9.24-BETA2-dev-t20181030-1654/libs/deployment-bidmgr-shaded-jar-2.9.24-BETA2.jar!/bing/bing-get-campaign-list-configuration.xml] 2018-11-05 14:29:34,857 [main] INFO o.s.b.f.xml.XmlBeanDefinitionReader - Loading XML bean definitions from URL [jar:file:/usr/local/tsa/bidmgr-distribution-2.9.24-BETA2-dev-t20181030-1654/libs/deployment-bidmgr-shaded-jar-2.9.24-BETA2.jar!/bing/bing-client-factory-configuration.xml] 2018-11-05 14:29:34,865 [main] INFO o.s.b.f.xml.XmlBeanDefinitionReader - Loading XML bean definitions from URL [jar:file:/usr/local/tsa/bidmgr-distribution-2.9.24-BETA2-dev-t20181030-1654/libs/deployment-bidmgr-shaded-jar-2.9.24-BETA2.jar!/bing/bing-service-component-configuration.xml] 2018-11-05 14:29:35,002 [main] INFO o.s.b.f.xml.XmlBeanDefinitionReader - Loading XML bean definitions from URL [jar:file:/usr/local/tsa/bidmgr-distribution-2.9.24-BETA2-dev-t20181030-1654/libs/deployment-bidmgr-shaded-jar-2.9.24-BETA2.jar!/dao/bing-campaign-structure-dao-configuration.xml] 2018-11-05 14:29:35,076 [main] INFO o.s.b.f.xml.XmlBeanDefinitionReader - Loading XML bean definitions from URL [jar:file:/usr/local/tsa/bidmgr-distribution-2.9.24-BETA2-dev-t20181030-1654/libs/deployment-bidmgr-shaded-jar-2.9.24-BETA2.jar!/dao/bing-error-dao-configuration.xml] 2018-11-05 14:29:35,128 [main] INFO o.s.b.f.xml.XmlBeanDefinitionReader - Loading XML bean definitions from URL [jar:file:/usr/local/tsa/bidmgr-distribution-2.9.24-BETA2-dev-t20181030-1654/libs/deployment-bidmgr-shaded-jar-2.9.24-BETA2.jar!/bing/bing-datasource-configuration.xml] 2018-11-05 14:29:35,254 [main] INFO o.s.b.f.xml.XmlBeanDefinitionReader - Loading XML bean definitions from class path resource [yjp-main-spring-config.xml] 2018-11-05 14:29:35,379 [main] INFO o.s.b.f.xml.XmlBeanDefinitionReader - Loading XML bean definitions from URL [jar:file:/usr/local/tsa/bidmgr-distribution-2.9.24-BETA2-dev-t20181030-1654/libs/deployment-bidmgr-shaded-jar-2.9.24-BETA2.jar!/yjp/yjp-client-factory-configuration.xml] 2018-11-05 14:29:35,385 [main] INFO o.s.b.f.xml.XmlBeanDefinitionReader - Loading XML bean definitions from URL [jar:file:/usr/local/tsa/bidmgr-distribution-2.9.24-BETA2-dev-t20181030-1654/libs/deployment-bidmgr-shaded-jar-2.9.24-BETA2.jar!/yjp/yjp-service-component-configuration.xml] 2018-11-05 14:29:35,397 [main] INFO o.s.b.f.xml.XmlBeanDefinitionReader - Loading XML bean definitions from URL [jar:file:/usr/local/tsa/bidmgr-distribution-2.9.24-BETA2-dev-t20181030-1654/libs/deployment-bidmgr-shaded-jar-2.9.24-BETA2.jar!/dao/yahoo-campaign-structure-dao-configuration.xml] 2018-11-05 14:29:35,430 [main] INFO o.s.b.f.xml.XmlBeanDefinitionReader - Loading XML bean definitions from URL [jar:file:/usr/local/tsa/bidmgr-distribution-2.9.24-BETA2-dev-t20181030-1654/libs/deployment-bidmgr-shaded-jar-2.9.24-BETA2.jar!/dao/yahoo-error-dao-configuration.xml] 2018-11-05 14:29:35,456 [main] INFO o.s.b.f.xml.XmlBeanDefinitionReader - Loading XML bean definitions from URL [jar:file:/usr/local/tsa/bidmgr-distribution-2.9.24-BETA2-dev-t20181030-1654/libs/deployment-bidmgr-shaded-jar-2.9.24-BETA2.jar!/dao/yahoo-upgraded-url-migration-dao-configuration.xml] 2018-11-05 14:29:35,470 [main] INFO o.s.b.f.xml.XmlBeanDefinitionReader - Loading XML bean definitions from URL [jar:file:/usr/local/tsa/bidmgr-distribution-2.9.24-BETA2-dev-t20181030-1654/libs/deployment-bidmgr-shaded-jar-2.9.24-BETA2.jar!/yjp/yjp-get-campaign-list-configuration.xml] 2018-11-05 14:29:35,476 [main] INFO o.s.b.f.xml.XmlBeanDefinitionReader - Loading XML bean definitions from URL [jar:file:/usr/local/tsa/bidmgr-distribution-2.9.24-BETA2-dev-t20181030-1654/libs/deployment-bidmgr-shaded-jar-2.9.24-BETA2.jar!/yjp/yjp-datasource-configuration.xml] 2018-11-05 14:29:35,584 [main] INFO o.s.b.f.xml.XmlBeanDefinitionReader - Loading XML bean definitions from class path resource [tp-main-spring-config.xml] 2018-11-05 14:29:35,652 [main] INFO o.s.b.f.xml.XmlBeanDefinitionReader - Loading XML bean definitions from URL [jar:file:/usr/local/tsa/bidmgr-distribution-2.9.24-BETA2-dev-t20181030-1654/libs/deployment-bidmgr-shaded-jar-2.9.24-BETA2.jar!/tp/tp-datasource-configuration.xml] 2018-11-05 14:29:35,685 [main] INFO o.s.b.f.xml.XmlBeanDefinitionReader - Loading XML bean definitions from URL [jar:file:/usr/local/tsa/bidmgr-distribution-2.9.24-BETA2-dev-t20181030-1654/libs/deployment-bidmgr-shaded-jar-2.9.24-BETA2.jar!/tp/tp-client-factory-configuration.xml] 2018-11-05 14:29:35,691 [main] INFO o.s.b.f.xml.XmlBeanDefinitionReader - Loading XML bean definitions from URL [jar:file:/usr/local/tsa/bidmgr-distribution-2.9.24-BETA2-dev-t20181030-1654/libs/deployment-bidmgr-shaded-jar-2.9.24-BETA2.jar!/tp/tp-get-campaign-list-configuration.xml] 2018-11-05 14:29:35,702 [main] INFO o.s.b.f.xml.XmlBeanDefinitionReader - Loading XML bean definitions from URL [jar:file:/usr/local/tsa/bidmgr-distribution-2.9.24-BETA2-dev-t20181030-1654/libs/deployment-bidmgr-shaded-jar-2.9.24-BETA2.jar!/tp/tp-service-component-configuration.xml] 2018-11-05 14:29:35,711 [main] INFO o.s.b.f.xml.XmlBeanDefinitionReader - Loading XML bean definitions from URL [jar:file:/usr/local/tsa/bidmgr-distribution-2.9.24-BETA2-dev-t20181030-1654/libs/deployment-bidmgr-shaded-jar-2.9.24-BETA2.jar!/dao/tp-campaign-structure-dao-configuration.xml] 2018-11-05 14:29:35,723 [main] INFO o.s.b.f.xml.XmlBeanDefinitionReader - Loading XML bean definitions from URL [jar:file:/usr/local/tsa/bidmgr-distribution-2.9.24-BETA2-dev-t20181030-1654/libs/deployment-bidmgr-shaded-jar-2.9.24-BETA2.jar!/dao/tp-account-structure-dao-configuration.xml] 2018-11-05 14:29:35,747 [main] INFO o.s.b.f.xml.XmlBeanDefinitionReader - Loading XML bean definitions from URL [jar:file:/usr/local/tsa/bidmgr-distribution-2.9.24-BETA2-dev-t20181030-1654/libs/deployment-bidmgr-shaded-jar-2.9.24-BETA2.jar!/dao/tp-error-dao-configuration.xml] 2018-11-05 14:29:35,774 [main] INFO o.s.b.f.xml.XmlBeanDefinitionReader - Loading XML bean definitions from URL [jar:file:/usr/local/tsa/bidmgr-distribution-2.9.24-BETA2-dev-t20181030-1654/libs/deployment-bidmgr-shaded-jar-2.9.24-BETA2.jar!/dao/tp-performance-dao-configuration.xml] 2018-11-05 14:29:35,790 [main] INFO o.s.b.f.xml.XmlBeanDefinitionReader - Loading XML bean definitions from URL [jar:file:/usr/local/tsa/bidmgr-distribution-2.9.24-BETA2-dev-t20181030-1654/libs/deployment-bidmgr-shaded-jar-2.9.24-BETA2.jar!/dao/tp-carryover-dao-configuration.xml] 2018-11-05 14:29:35,834 [main] INFO o.s.b.f.xml.XmlBeanDefinitionReader - Loading XML bean definitions from URL [jar:file:/usr/local/tsa/bidmgr-distribution-2.9.24-BETA2-dev-t20181030-1654/libs/deployment-bidmgr-shaded-jar-2.9.24-BETA2.jar!/dao/tp-carryoverAdjustment-dao-configuration.xml] 2018-11-05 14:29:35.903 (3) [P2T1]: [oauth] Creating new OAuthService component 2018-11-05 14:29:35,925 [main] INFO o.s.b.f.xml.XmlBeanDefinitionReader - Loading XML bean definitions from class path resource [merchant-main-spring-config.xml] 2018-11-05 14:29:35,930 [main] INFO o.s.b.f.xml.XmlBeanDefinitionReader - Loading XML bean definitions from URL [jar:file:/usr/local/tsa/bidmgr-distribution-2.9.24-BETA2-dev-t20181030-1654/libs/deployment-bidmgr-shaded-jar-2.9.24-BETA2.jar!/merchant/datasource-configuration.xml] 2018-11-05 14:29:35,960 [main] INFO o.s.b.f.xml.XmlBeanDefinitionReader - Loading XML bean definitions from URL [jar:file:/usr/local/tsa/bidmgr-distribution-2.9.24-BETA2-dev-t20181030-1654/libs/deployment-bidmgr-shaded-jar-2.9.24-BETA2.jar!/merchant/summarizer-configuration.xml] 2018-11-05 14:29:35,968 [main] INFO o.s.b.f.xml.XmlBeanDefinitionReader - Loading XML bean definitions from URL [jar:file:/usr/local/tsa/bidmgr-distribution-2.9.24-BETA2-dev-t20181030-1654/libs/deployment-bidmgr-shaded-jar-2.9.24-BETA2.jar!/dao/merchant-performance-dao-configuration.xml] 2018-11-05 14:29:35,990 [main] INFO o.s.b.f.xml.XmlBeanDefinitionReader - Loading XML bean definitions from URL [jar:file:/usr/local/tsa/bidmgr-distribution-2.9.24-BETA2-dev-t20181030-1654/libs/deployment-bidmgr-shaded-jar-2.9.24-BETA2.jar!/merchant/merchant-info-configuration.xml] 2018-11-05 14:29:35,997 [main] INFO o.s.b.f.xml.XmlBeanDefinitionReader - Loading XML bean definitions from URL [jar:file:/usr/local/tsa/bidmgr-distribution-2.9.24-BETA2-dev-t20181030-1654/libs/deployment-bidmgr-shaded-jar-2.9.24-BETA2.jar!/dao/merchant-info-dao-configuration.xml] 2018-11-05 14:29:36,063 [main] INFO o.s.b.f.xml.XmlBeanDefinitionReader - Loading XML bean definitions from class path resource [imps-share-metrics-main-spring-config.xml] 2018-11-05 14:29:36,069 [main] INFO o.s.b.f.xml.XmlBeanDefinitionReader - Loading XML bean definitions from URL [jar:file:/usr/local/tsa/bidmgr-distribution-2.9.24-BETA2-dev-t20181030-1654/libs/deployment-bidmgr-shaded-jar-2.9.24-BETA2.jar!/performance/performance-datasource-configuration.xml] 2018-11-05 14:29:36,082 [main] INFO o.s.b.f.xml.XmlBeanDefinitionReader - Loading XML bean definitions from URL [jar:file:/usr/local/tsa/bidmgr-distribution-2.9.24-BETA2-dev-t20181030-1654/libs/deployment-bidmgr-shaded-jar-2.9.24-BETA2.jar!/performance/imps-share-metrics-configuration.xml] 2018-11-05 14:29:36,090 [main] INFO o.s.b.f.xml.XmlBeanDefinitionReader - Loading XML bean definitions from URL [jar:file:/usr/local/tsa/bidmgr-distribution-2.9.24-BETA2-dev-t20181030-1654/libs/deployment-bidmgr-shaded-jar-2.9.24-BETA2.jar!/dao/imps-share-metrics-dao-configuration.xml] 2018-11-05 14:29:36,208 [P2T1] INFO c.t.s.o.core.OAuthServiceComponent - [oauth] Creating new OAuthServiceComponent 2018-11-05 14:29:36.239 (3) [P2T1]: Creating API for reseller DistributionSettings dc34c5ac-4e4e-41dc-9830-9b55dabe0e48 2018-11-05 14:29:36,366 [main] INFO o.s.b.f.c.PropertyPlaceholderConfigurer - Loading properties file from class path resource [bing/bing-datasource.properties] 2018-11-05 14:29:36,367 [main] INFO o.s.b.f.c.PropertyPlaceholderConfigurer - Loading properties file from class path resource [bing/bing-datasource-overrides.properties] 2018-11-05 14:29:36,367 [main] WARN o.s.b.f.c.PropertyPlaceholderConfigurer - Could not load properties from class path resource [bing/bing-datasource-overrides.properties]: class path resource [bing/bing-datasource-overrides.properties] cannot be opened because it does not exist 2018-11-05 14:29:36,371 [main] INFO o.s.b.f.c.PropertyPlaceholderConfigurer - Loading properties file from class path resource [yjp/yjp-datasource.properties] 2018-11-05 14:29:36,372 [main] INFO o.s.b.f.c.PropertyPlaceholderConfigurer - Loading properties file from class path resource [yjp/yjp-datasource-overrides.properties] 2018-11-05 14:29:36,372 [main] WARN o.s.b.f.c.PropertyPlaceholderConfigurer - Could not load properties from class path resource [yjp/yjp-datasource-overrides.properties]: class path resource [yjp/yjp-datasource-overrides.properties] cannot be opened because it does not exist 2018-11-05 14:29:36,373 [main] INFO o.s.b.f.c.PropertyPlaceholderConfigurer - Loading properties file from class path resource [tp/tp-datasource.properties] 2018-11-05 14:29:36,383 [main] INFO o.s.b.f.c.PropertyPlaceholderConfigurer - Loading properties file from class path resource [tp/tp-datasource-overrides.properties] 2018-11-05 14:29:36,383 [main] WARN o.s.b.f.c.PropertyPlaceholderConfigurer - Could not load properties from class path resource [tp/tp-datasource-overrides.properties]: class path resource [tp/tp-datasource-overrides.properties] cannot be opened because it does not exist 2018-11-05 14:29:36,384 [main] INFO o.s.b.f.c.PropertyPlaceholderConfigurer - Loading properties file from class path resource [merchant/datasource.properties] 2018-11-05 14:29:36,385 [main] INFO o.s.b.f.c.PropertyPlaceholderConfigurer - Loading properties file from class path resource [merchant/datasource-overrides.properties] 2018-11-05 14:29:36,385 [main] WARN o.s.b.f.c.PropertyPlaceholderConfigurer - Could not load properties from class path resource [merchant/datasource-overrides.properties]: class path resource [merchant/datasource-overrides.properties] cannot be opened because it does not exist 2018-11-05 14:29:36,386 [main] INFO o.s.b.f.c.PropertyPlaceholderConfigurer - Loading properties file from class path resource [performance/performance-datasource.properties] 2018-11-05 14:29:36,387 [main] INFO o.s.b.f.c.PropertyPlaceholderConfigurer - Loading properties file from class path resource [performance/performance-datasource-overrides.properties] 2018-11-05 14:29:36,387 [main] WARN o.s.b.f.c.PropertyPlaceholderConfigurer - Could not load properties from class path resource [performance/performance-datasource-overrides.properties]: class path resource [performance/performance-datasource-overrides.properties] cannot be opened because it does not exist 2018-11-05 14:29:36.393 (3) [P2T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2018-11-05 14:29:36.448 (3) [P2T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2018-11-05 14:29:36.475 (3) [P2T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2018-11-05 14:29:36.475 (3) [P2T1]: Created shared sesystem connection rw 2018-11-05 14:29:36.511 (3) [P2T1]: Retrieving credentials for search engine user id : 1547 || client id : 627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com , client secret :uO1pQj_ihl6Jy1fSA7FzCTFE , refresh token : 1/XElVvzhFJlFc7FcqtcZJbj1-erQxMLsEVlrN60XCc4JMrEt0pnthZ_A8mZru5Ei4 2018-11-05 14:29:36,520 [P2T1] INFO c.t.s.o.core.OAuthServiceComponent - [oauth] Getting new access token for google 2018-11-05 14:29:36.927 (3) [P1T2]: Starting Distribution 147 2018-11-05 14:29:36.927 (3) [P1T2]: ----------------GetKWApprovalStatus - Distribution Worker starting 2018-11-05 14:29:36.988 (3) [main]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2018-11-05 14:29:36.993 (3) [P1T3]: Starting Distribution 164 2018-11-05 14:29:36.993 (3) [P1T3]: ----------------GetKWApprovalStatus - Distribution Worker starting 2018-11-05 14:29:37.006 (3) [P1T2]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2018-11-05 14:29:37.013 (3) [P1T2]: ------------GetKWApprovalStatus - Distribution Worker done 2018-11-05 14:29:37.014 (3) [P1T2]: --------------- Printing Disapproved Keywords 2018-11-05 14:29:37.014 (3) [P1T2]: Completed Distribution 147 2018-11-05 14:29:37.014 (3) [P1T2]: Starting Distribution 177 2018-11-05 14:29:37.014 (3) [P1T2]: ----------------GetKWApprovalStatus - Distribution Worker starting 2018-11-05 14:29:37,019 [P2T1] DEBUG c.g.a.a.c.l.u.l.A.ads_api_lib - Could not load optional configuration: ConfigurationInfo{location=ads.properties, isOptional=true} 2018-11-05 14:29:37.067 (3) [P1T3]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2018-11-05 14:29:37.074 (3) [P1T3]: ------------GetKWApprovalStatus - Distribution Worker done 2018-11-05 14:29:37.075 (3) [P1T3]: --------------- Printing Disapproved Keywords 2018-11-05 14:29:37.075 (3) [P1T3]: Completed Distribution 164 2018-11-05 14:29:37.075 (3) [P1T3]: Starting Distribution 178 2018-11-05 14:29:37.075 (3) [P1T3]: ----------------GetKWApprovalStatus - Distribution Worker starting 2018-11-05 14:29:37,084 [P2T1] DEBUG c.g.a.a.c.l.u.l.A.ads_api_lib - Could not load optional configuration: ConfigurationInfo{location=ads.properties, isOptional=true} 2018-11-05 14:29:37.098 (3) [P1T2]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2018-11-05 14:29:37.105 (3) [P1T2]: ------------GetKWApprovalStatus - Distribution Worker done 2018-11-05 14:29:37.105 (3) [P1T2]: --------------- Printing Disapproved Keywords 2018-11-05 14:29:37.106 (3) [P1T2]: Completed Distribution 177 2018-11-05 14:29:37.137 (3) [P1T3]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2018-11-05 14:29:37.140 (3) [P1T3]: ------------GetKWApprovalStatus - Distribution Worker done 2018-11-05 14:29:37.140 (3) [P1T3]: --------------- Printing Disapproved Keywords 2018-11-05 14:29:37.140 (3) [P1T3]: Completed Distribution 178 2018-11-05 14:29:37,447 [P2T1] INFO c.t.s.o.core.OAuthServiceComponent - [oauth] Return OAuth credential. Access token = ya29.Gl1LBmdlfDSc1A8V8gno3Jya_XuVSAMGh2dNxGxqTIAywiw4a0fYEHINRffBvqCKBskSTFn-zf2TsKO-HzXthSaCMV56PUlwPx3h3HKHZQHXwiM03rFHp8zH3jsspWM for adwords (clientID=627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com) 2018-11-05 14:29:37.448 (3) [P2T1]: [oauth] Returning access token from OAuth service: ya29.Gl1LBmdlfDSc1A8V8gno3Jya_XuVSAMGh2dNxGxqTIAywiw4a0fYEHINRffBvqCKBskSTFn-zf2TsKO-HzXthSaCMV56PUlwPx3h3HKHZQHXwiM03rFHp8zH3jsspWM 2018-11-05 14:29:37.455 (3) [P2T1]: Retrieving credentials for search engine user id : 1547 || client id : 627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com , client secret :uO1pQj_ihl6Jy1fSA7FzCTFE , refresh token : 1/XElVvzhFJlFc7FcqtcZJbj1-erQxMLsEVlrN60XCc4JMrEt0pnthZ_A8mZru5Ei4 2018-11-05 14:29:37,456 [P2T1] INFO c.t.s.o.core.OAuthServiceComponent - [oauth] Return OAuth credential. Access token = ya29.Gl1LBmdlfDSc1A8V8gno3Jya_XuVSAMGh2dNxGxqTIAywiw4a0fYEHINRffBvqCKBskSTFn-zf2TsKO-HzXthSaCMV56PUlwPx3h3HKHZQHXwiM03rFHp8zH3jsspWM for adwords (clientID=627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com) 2018-11-05 14:29:37.456 (3) [P2T1]: [oauth] Returning access token from OAuth service: ya29.Gl1LBmdlfDSc1A8V8gno3Jya_XuVSAMGh2dNxGxqTIAywiw4a0fYEHINRffBvqCKBskSTFn-zf2TsKO-HzXthSaCMV56PUlwPx3h3HKHZQHXwiM03rFHp8zH3jsspWM 2018-11-05 14:29:37.458 (3) [P2T1]: DistributionServiceRemoteClient created for GMB 2018-11-05 14:29:37.494 (3) [P2T1]: Distribution Properties Cache: Loading new properties for ccafd2f4-4863-4c01-9d68-e295a788db83_GMB 2018-11-05 14:29:37,546 [P2T1] INFO o.a.c.h.auth.AuthChallengeProcessor - digest authentication scheme selected 2018-11-05 14:29:37.561 (3) [P2T1]: Retrieving GMB credentials for search engine user id : 1547 || client id : 627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com , client secret :uO1pQj_ihl6Jy1fSA7FzCTFE , refresh token : 1/fH9q5og0rO9LI5NBJqM4k_YTHb-0XSo2-Qv53oyo5a0 2018-11-05 14:29:37,561 [P2T1] INFO c.t.s.o.core.OAuthServiceComponent - [oauth] Getting new access token for google 2018-11-05 14:29:37,614 [P2T1] INFO c.t.s.o.core.OAuthServiceComponent - [oauth] Return OAuth credential. Access token = ya29.Gl1LBn5RFRWHFd-acEdAhN3hNnwJYdKrUO5lzwQ3fwuyNtiRyLX8aQOhhT6IiddabbijJmnbaM1bSFvIthEsjCpt2623_tQVTSOc3dQWIU9dRTiV4RxpJtFGu9wFMS4 for gmb (clientID=627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com) 2018-11-05 14:29:37,860 [P2T1] DEBUG c.g.a.a.c.l.u.l.A.ads_api_lib - Could not load optional configuration: ConfigurationInfo{location=ads.properties, isOptional=true} 2018-11-05 14:29:38,720 [P2T1] WARN c.g.a.a.a.l.c.A.requestInfoLogger - Request made: Service: AdGroupCriterionService Method: get clientCustomerId: 2750457017 URL: https://adwords.google.com/api/adwords/cm/v201809/AdGroupCriterionService Request ID: 000579ebb70609d90a3749453107fae9 ResponseTime(ms): 169 OperationsCount: 1 IsFault: true FaultMessage: ApiException{applicationExceptionType=ApiException, errors=[SelectorError{apiErrorType=SelectorError, errorString=SelectorError.INVALID_FIELD_NAME, fieldPath=serviceSelector, fieldPathElements=[FieldPathElement{field=serviceSelector}], reason=INVALID_FIELD_NAME, trigger=DestinationUrl}]} 2018-11-05 14:29:38,822 [P2T1] INFO c.g.a.a.a.l.c.A.soapXmlLogger - SOAP request: 2750457017 REDACTED AML-QA2 (AwApi-Java, AdWords-Axis/4.1.0, Common-Java/4.1.0, Axis/1.4, Java/1.8.0_144, maven) false true ApprovalStatus CriteriaType CriterionUse DestinationUrl FirstPageCpc Id CpcBid CpmBid PlacementUrl Status AdGroupId IN 61251173003 61251173403 61251173443 CriteriaType EQUALS KEYWORD CriterionUse EQUALS BIDDABLE Status IN ENABLED PAUSED ApprovalStatus IN DISAPPROVED PENDING_REVIEW UNDER_REVIEW 2018-11-05 14:29:38,822 [P2T1] INFO c.g.a.a.a.l.c.A.soapXmlLogger - SOAP response: 000579ebb70609d90a3749453107fae9 AdGroupCriterionService get 1 169 soap:Client [SelectorError.INVALID_FIELD_NAME @ serviceSelector; trigger:'DestinationUrl'] [SelectorError.INVALID_FIELD_NAME @ serviceSelector; trigger:'DestinationUrl'] ApiException serviceSelector serviceSelector DestinationUrl SelectorError.INVALID_FIELD_NAME SelectorError INVALID_FIELD_NAME 2018-11-05 14:29:38.822 (2) [P2T1]: 1 Errors found 2018-11-05 14:29:38.822 (2) [P2T1]: - com.google.api.ads.adwords.axis.v201809.cm.SelectorError: SelectorError.INVALID_FIELD_NAME: Error Type=SelectorError field=serviceSelector, trigger=DestinationUrl 2018-11-05 14:29:38.824 (2) [P2T1]: com.google.api.ads.adwords.axis.v201809.cm.SelectorError: ApiError: fieldpath=serviceSelector, trigger=DestinationUrl apierrortype=SelectorError, reason=SelectorError.INVALID_FIELD_NAME 2018-11-05 14:29:38.824 (3) [P2T1]: Not retrying Google error. message1=[SelectorError.INVALID_FIELD_NAME @ serviceSelector; trigger:'DestinationUrl'] 2018-11-05 14:29:38.824 (3) [P2T1]: Caught other/unrecoverable API Exception: "com.google.api.ads.adwords.axis.v201809.cm.ApiException" 2018-11-05 14:29:38.838 (1) [P2T1]: Exception [Error getting keyword approval status values for search engine user 1547]:com.thesearchagency.searchengines.SearchEngineCommandException: ApiException{applicationExceptionType=ApiException, errors=[SelectorError{apiErrorType=SelectorError, errorString=SelectorError.INVALID_FIELD_NAME, fieldPath=serviceSelector, fieldPathElements=[FieldPathElement{field=serviceSelector}], reason=INVALID_FIELD_NAME, trigger=DestinationUrl}]} at com.thesearchagency.searchengines.google.GoogleAdWordsAPI.getKeywords(GoogleAdWordsAPI.java:2091) at com.thesearchagency.searchengines.google.GoogleAdWordsAPI.getKeywords(GoogleAdWordsAPI.java:1957) at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.getDisapprovedKeywords(GoogleAPISearchEngine.java:811) at com.thesearchagency.searchengines.GetKWApprovalStatus$DistributionWorker$SearchEngineUserWorker.call(GetKWApprovalStatus.java:336) at com.thesearchagency.searchengines.GetKWApprovalStatus$DistributionWorker$SearchEngineUserWorker.call(GetKWApprovalStatus.java:286) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: ApiException{applicationExceptionType=ApiException, errors=[SelectorError{apiErrorType=SelectorError, errorString=SelectorError.INVALID_FIELD_NAME, fieldPath=serviceSelector, fieldPathElements=[FieldPathElement{field=serviceSelector}], reason=INVALID_FIELD_NAME, trigger=DestinationUrl}]} at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at java.lang.Class.newInstance(Class.java:442) at org.apache.axis.encoding.ser.BeanDeserializer.(BeanDeserializer.java:104) at org.apache.axis.encoding.ser.BeanDeserializer.(BeanDeserializer.java:90) at com.google.api.ads.adwords.axis.v201809.cm.ApiException.getDeserializer(ApiException.java:165) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.axis.encoding.ser.BaseDeserializerFactory.getSpecialized(BaseDeserializerFactory.java:154) at org.apache.axis.encoding.ser.BaseDeserializerFactory.getDeserializerAs(BaseDeserializerFactory.java:84) at org.apache.axis.encoding.DeserializationContext.getDeserializer(DeserializationContext.java:464) at org.apache.axis.encoding.DeserializationContext.getDeserializerForType(DeserializationContext.java:547) at org.apache.axis.message.SOAPFaultDetailsBuilder.onStartChild(SOAPFaultDetailsBuilder.java:157) at org.apache.axis.encoding.DeserializationContext.startElement(DeserializationContext.java:1035) at org.apache.xerces.parsers.AbstractSAXParser.startElement(Unknown Source) at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanStartElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source) at org.apache.xerces.jaxp.SAXParserImpl.parse(Unknown Source) at org.apache.axis.encoding.DeserializationContext.parse(DeserializationContext.java:227) at org.apache.axis.SOAPPart.getAsSOAPEnvelope(SOAPPart.java:696) at org.apache.axis.Message.getSOAPEnvelope(Message.java:435) at org.apache.axis.handlers.soap.MustUnderstandChecker.invoke(MustUnderstandChecker.java:62) at org.apache.axis.client.AxisClient.invoke(AxisClient.java:206) at org.apache.axis.client.Call.invokeEngine(Call.java:2784) at org.apache.axis.client.Call.invoke(Call.java:2767) at org.apache.axis.client.Call.invoke(Call.java:2443) at org.apache.axis.client.Call.invoke(Call.java:2366) at org.apache.axis.client.Call.invoke(Call.java:1812) at com.google.api.ads.adwords.axis.v201809.cm.AdGroupCriterionServiceSoapBindingStub.get(AdGroupCriterionServiceSoapBindingStub.java:1688) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.google.api.ads.common.lib.soap.SoapClientHandler.invoke(SoapClientHandler.java:100) at com.google.api.ads.common.lib.soap.axis.AxisHandler.invokeSoapCall(AxisHandler.java:234) at com.google.api.ads.common.lib.soap.SoapServiceClient.callSoapClient(SoapServiceClient.java:63) at com.google.api.ads.common.lib.soap.SoapServiceClient.invoke(SoapServiceClient.java:93) at com.sun.proxy.$Proxy38.get(Unknown Source) at com.thesearchagency.searchengines.google.GoogleAdWordsAPI.getKeywords(GoogleAdWordsAPI.java:2045) ... 8 more 2018-11-05 14:29:38.839 (2) [P2T1]: KeywordDAO: database is null 2018-11-05 14:29:38.839 (3) [P2T1]: === Completed user #1547, 58f2b08e-e8e5-4346-b5c8-d845715da03d_1_orange_Cashew_003 === 2018-11-05 14:29:38.839 (3) [P1T1]: ------------GetKWApprovalStatus - Distribution Worker done 2018-11-05 14:29:38.839 (3) [P1T1]: --------------- Printing Disapproved Keywords 2018-11-05 14:29:38.839 (3) [P1T1]: Completed Distribution 3 2018-11-05 14:29:38.842 (3) [main]: ------------ Distribution Dispatcher for Get Keyword Approval Status done 2018-11-05 14:29:38.842 (3) [main]: =============== Completed Get Keyword Approval Status ================ 2018-11-05 14:29:38.843 (3) [main]: Get Keyword Approval Status: 4.647s 2018-11-05 14:29:38.843 (3) [main]: by key: 2018-11-05 14:29:38.843 (3) [main]: db: 0.106s 2018-11-05 14:29:38.843 (3) [main]: by thread: 2018-11-05 14:29:38.844 (3) [main]: P1T3: 0.009s 2018-11-05 14:29:38.844 (3) [main]: main: 0.039s 2018-11-05 14:29:38.844 (3) [main]: P2T1: 0.040s 2018-11-05 14:29:38.844 (3) [main]: P1T2: 0.013s 2018-11-05 14:29:38.844 (3) [main]: P1T1: 0.005s 2018-11-05 14:29:38.844 (3) [main]: other: 4.541s 2018-11-05 14:29:38,845 [Thread-3] INFO o.s.c.s.ClassPathXmlApplicationContext - Closing org.springframework.context.support.ClassPathXmlApplicationContext@587c290d: startup date [Mon Nov 05 14:29:34 UTC 2018]; root of context hierarchy