[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