Details
-
Type: Bug
-
Status: Closed
-
Priority: Major
-
Resolution: Fixed
-
Affects Version/s: Mercury
-
Fix Version/s: Mercury
-
Component/s: None
-
Labels:None
-
Environment:
AML25 Production server
-
Sprint:Sprint 24
Description
We have added cron for googlesyncmanagerusernames.sh on execution it throwing java.lang.NullPointerException.
Following is the log after running script.
[TSAApp@aml25-core1 bidmgr]$ ./googlesyncmanagerusernames.sh -d5 -e 7575033602
------- Loaded DatabaseAccounts properties from file:/usr/local/tsa/bidmgr-distribution-2.9.1-BETA1-dev-t20160420-1401/libs/deployment-bidmgr-shaded-jar-2.9.1-BETA1.jar!/core-jdb-datasource.properties -------
2016-04-28 07:48:42.539 (3) [main]: Debug Level set to 5
2016-04-28 07:48:42.637 (4) [main]: registered MBean [thesearchagency.db.util:type=MultiplexDatabasePool56e8eb03-ba38-46ba-ae07-3ffbf1ab5fbb] for class com.thesearchagency.db.util.MultiplexDatabasePool
2016-04-28 07:48:42.646 (5) [main]: ProfilerRec.start("Google Sync Manager Usernames",false) in Thread [main]
2016-04-28 07:48:42.647 (3) [main]: =============== Starting Google Sync Manager Usernames ================
2016-04-28 07:48:42.659 (3) [P1T1]: === Starting Client ID: 7575033602 ===
2016-04-28 07:48:42.660 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup...
2016-04-28 07:48:42.665 (4) [P1T1]: registered MBean [com.carldunham.jst.pooling:type=ObjectPoola9af7ecb-b9db-40c7-9690-be6d2e87473a] for class com.carldunham.jst.pooling.ObjectPool
2016-04-28 07:48:42.665 (3) [P1T1]: DatabasePool with a limit of 5 created
2016-04-28 07:48:42.666 (4) [P1T1]: registered MBean [com.carldunham.jst.db:type=DatabasePool81da78f5-2492-4867-a864-dc927258a190] for class com.carldunham.jst.db.DatabasePool
2016-04-28 07:48:42.668 (4) [ConnectionCloser]: Starting DatabasePool ConnectionCloserThread
2016-04-28 07:48:43.060 (3) [P1T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2016-04-28 07:48:43.060 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true]
2016-04-28 07:48:43.060 (4) [P1T1]: Created new Object
2016-04-28 07:48:43.061 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2016-04-28 07:48:43.061 (4) [P1T1]: spike: SQL->[select @@version]
2016-04-28 07:48:43.067 (5) [P1T1]: recordAsSubs("db", 6, "P1T1")
2016-04-28 07:48:43.067 (5) [P1T1]: addSub("db")
2016-04-28 07:48:43.068 (5) [P1T1]: ProfilerRec.end("db", true): ret=6
2016-04-28 07:48:43.069 (4) [P1T1]: time=0.0060
2016-04-28 07:48:43.070 (4) [P1T1]: Query executed in 0.006s
2016-04-28 07:48:43.070 (4) [P1T1]: test query succeeded, returned "5.5.34"
2016-04-28 07:48:43.075 (3) [P1T1]: LicensingFileRefresher: modification detected on 1461220297000 for licensing.properties
2016-04-28 07:48:43.075 (3) [P1T1]: Licensing environment detected, loading configuration.
2016-04-28 07:48:43.076 (3) [P1T1]: Loaded property: distribution-service-url=http://aml25-front1:8081/distribution
2016-04-28 07:48:43.077 (3) [P1T1]: Loaded property: distribution-service-username=readwrite
2016-04-28 07:48:43.077 (3) [P1T1]: Loaded property: distribution-service-password=yE4hATrecHA7
2016-04-28 07:48:43.077 (3) [P1T1]: Loaded property: sapi-auth-url=http://aml25-front1:8080/sapi/rest/security/tokens
2016-04-28 07:48:43.077 (3) [P1T1]: Loaded property: sapi-merchant-service-url=http://aml25-front1:8080/sapi/rest/merchants
2016-04-28 07:48:43.077 (3) [P1T1]: Loaded property: sapi-reseller-service-url=http://aml25-front1:8080/sapi/rest/resellers
2016-04-28 07:48:43.077 (3) [P1T1]: Loaded property: sapi-username=admin+tsa@thesearchagency.com
2016-04-28 07:48:43.077 (3) [P1T1]: Loaded property: sapi-password=admin
2016-04-28 07:48:43.078 (3) [P1T1]: Loaded property: sapi-realm=thesearchagency
2016-04-28 07:48:43.078 (3) [P1T1]: Loaded property: tsa.google.mcc.developerToken=ojCnjZaM6RD1h0yt_DOJZg
2016-04-28 07:48:43.078 (3) [P1T1]: Loaded property: tsa.google.mcc.isReseller=true
2016-04-28 07:48:43.078 (3) [P1T1]: Loaded property: tsa.timezone=UTC
2016-04-28 07:48:43.138 (1) [P1T1]: Exception [Caught exception creating DistributionServiceRemoteClient]:java.lang.NullPointerException
at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.createAPI(GoogleAPISearchEngine.java:239)
at com.thesearchagency.searchengines.google.GoogleSyncManagerUsernames$SearchEngineUserWorker.call(GoogleSyncManagerUsernames.java:246)
at com.thesearchagency.searchengines.google.GoogleSyncManagerUsernames$SearchEngineUserWorker.call(GoogleSyncManagerUsernames.java:227)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
2016-04-28 07:48:43.153 (1) [P1T1]: Exception [using GoogleAdWordsAPI]:javax.xml.rpc.ServiceException: java.lang.NullPointerException
at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.createAPI(GoogleAPISearchEngine.java:244)
at com.thesearchagency.searchengines.google.GoogleSyncManagerUsernames$SearchEngineUserWorker.call(GoogleSyncManagerUsernames.java:246)
at com.thesearchagency.searchengines.google.GoogleSyncManagerUsernames$SearchEngineUserWorker.call(GoogleSyncManagerUsernames.java:227)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
Caused by: java.lang.NullPointerException
at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.createAPI(GoogleAPISearchEngine.java:239)
... 7 more
2016-04-28 07:48:43.156 (3) [P1T1]: DefaultPropertyFileMonitor: modification detected on 1415157693000 for com.thesearchagency.AlertUtils.properties
2016-04-28 07:48:43.156 (4) [P1T1]: DefaultPropertyFileMonitor: Setting system property com.thesearchagency.AlertUtils.command = /usr/local/tsa/send_alarm.sh
2016-04-28 07:48:43.157 (4) [P1T1]: DefaultPropertyFileMonitor: Setting system property com.thesearchagency.AlertUtils.teamName = TSAOPS
2016-04-28 07:48:43.157 (2) [P1T1]: sendAlert: executing command: [/usr/local/tsa/send_alarm.sh, WARNING, TSAOPS, AdMax Application [GoogleSyncManagerUsernames]: Service - Error syncing manager IDs: java.lang.NullPointerException]
2016-04-28 07:48:43.197 (4) [P1T1]: Returning Object to Pool
2016-04-28 07:48:43.197 (3) [P1T1]: === Completed Client ID: 7575033602 ===
2016-04-28 07:48:43.198 (3) [main]: =============== Completed Google Sync Manager Usernames ================
2016-04-28 07:48:43.198 (5) [main]: ProfilerRec.end("Google Sync Manager Usernames", false): ret=552
2016-04-28 07:48:43.198 (4) [main]: time=0.552
2016-04-28 07:48:43.198 (3) [main]: Google Sync Manager Usernames: 0.552s
2016-04-28 07:48:43.198 (3) [main]: by key:
2016-04-28 07:48:43.199 (4) [main]: time=0.0060
2016-04-28 07:48:43.199 (3) [main]: db: 0.006s
2016-04-28 07:48:43.199 (4) [main]: time=0.546
2016-04-28 07:48:43.199 (3) [main]: other: 0.546s