Uploaded image for project: 'AdMax'
  1. AdMax
  2. ADMAX-2749

Maven: Exception-java.lang.NumberFormatException and my sql waring while running seupdate-small.sh script

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Won't Fix
    • Affects Version/s: BM Maven
    • Fix Version/s: BM Maven
    • Component/s: None
    • Labels:
      None
    • Environment:

      Bid_Manager_-_Mavenized/30/tsa-build-bidmgr-2011-07-25-p30-r30056

      Description

      While running .seupdate-small script, it is throwing exception and showing warning also.

      ./seupdate-small.sh -d3 -a 17 -U 8 --accounts --groups --listings 2>&1 | tee /tmp/seupdate_small.log

      {detailed log is attached}

      .

      .

      .

      2011-07-20 23:07:12.760 (2) [P2T1]: Warning(s) detected in statement [SELECT RELEASE_LOCK('com.thesearchagency.searchengines.google.GoogleStructureSync.searchEngineUserID.8')] executed by user [spike]

      2011-07-20 23:07:12.765 (2) [P2T1]: SQL Warning: Some non-transactional changed tables couldn't be rolled back (code:1196)

      com.carldunham.jst.db.transaction.TransactionException: error in GoogleStructureSync transaction

      at com.thesearchagency.searchengines.google.GoogleStructureSync$LoadTransaction.databaseCalls(GoogleStructureSync.java:2411)

      at com.carldunham.jst.db.SQLTransaction.execute(SQLTransaction.java:68)

      at com.thesearchagency.searchengines.google.GoogleStructureSync.getSearchEngineAccountsWithDifferences(GoogleStructureSync.java:280)

      at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.getSearchEngineAccountsWithDifferences(GoogleAPISearchEngine.java:2216)

      at com.thesearchagency.searchengines.SearchEngineUpdater$SearchEngineSyncUserWorker.run(SearchEngineUpdater.java:3458)

      at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417)

      at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269)

      at java.util.concurrent.FutureTask.run(FutureTask.java:123)

      at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)

      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)

      at java.lang.Thread.run(Thread.java:595)

      Caused by: java.lang.NumberFormatException: null

      .

      .

      .

      2011-07-20 23:07:12.808 (1) [P2T1]: Exception [Failure in retieving out-of-sync SE accounts: ]:com.thesearchagency.searchengines.SearchEngineCommandException: java.lang.NumberFormatException: null

      at com.thesearchagency.searchengines.google.GoogleStructureSync.getSearchEngineAccountsWithDifferences(GoogleStructureSync.java:303)

      at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.getSearchEngineAccountsWithDifferences(GoogleAPISearchEngine.java:2216)

      at com.thesearchagency.searchengines.SearchEngineUpdater$SearchEngineSyncUserWorker.run(SearchEngineUpdater.java:3458)

      at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417)

      at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269)

      at java.util.concurrent.FutureTask.run(FutureTask.java:123)

      at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)

      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)

      at java.lang.Thread.run(Thread.java:595)

      Caused by: java.lang.NumberFormatException: null

      at java.lang.Integer.parseInt(Integer.java:415)

      at java.lang.Integer.<init>(Integer.java:620)

      at com.thesearchagency.searchengines.google.GoogleStructureSync.replicateKeywordTable(GoogleStructureSync.java:1340)

      at com.thesearchagency.searchengines.google.GoogleStructureSync.access$1900(GoogleStructureSync.java:68)

      at com.thesearchagency.searchengines.google.GoogleStructureSync$LoadTransaction.performTableReplication(GoogleStructureSync.java:2521)

      at com.thesearchagency.searchengines.google.GoogleStructureSync$LoadTransaction.performDifferenceChecks(GoogleStructureSync.java:2493)

      at com.thesearchagency.searchengines.google.GoogleStructureSync$LoadTransaction.databaseCallsImplementation(GoogleStructureSync.java:2434)

      at com.thesearchagency.searchengines.google.GoogleStructureSync$LoadTransaction.databaseCalls(GoogleStructureSync.java:2408)

      at com.carldunham.jst.db.SQLTransaction.execute(SQLTransaction.java:68)

      at com.thesearchagency.searchengines.google.GoogleStructureSync.getSearchEngineAccountsWithDifferences(GoogleStructureSync.java:280)

      ... 8 more

      2011-07-20 23:07:12.812 (3) [main]: ------------SearchEngineSyncUserWorker done

        Attachments

          Activity

            People

            • Assignee:
              jason.stedman Jason Stedman (Inactive)
              Reporter:
              atul.sanagar Atul Sanagar (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: