Uploaded image for project: 'AdMaxLocal'
  1. AdMaxLocal
  2. AML-4121

googlesyncmanagerusernames.sh throwing java.lang.NullPointerException

    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 -------

      {datasource-user=spike, datasource-password=tar63t}

      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

        Attachments

          Activity

            People

            • Assignee:
              varshini.padmanabhan Varshini Padmanabhan (Inactive)
              Reporter:
              anil.kumar Anil Kumar Halmadgi
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: