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

empty reports get NullPointerException

    Details

    • Type: Bug
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: Google v201101
    • Fix Version/s: None
    • Component/s: Google
    • Labels:
      None
    • Environment:

      bidmgr trunk build 485,486

      xml-06 log file: /tmp/2011-07-19/sepull3.sh_04.log

      Description

      Can be reproduced with

      googlemcc.sh --force -d3 --skip-event -e tsa_training@thesearchagency.com --date 2011-07-18

      2011-07-19 04:50:27.256 (3) [pool-1-thread-1]: === Starting TSA MCC account ===

      2011-07-19 04:50:27.260 (3) [pool-1-thread-1]: DatabasePool with a limit of 3 created

      2011-07-19 04:50:27.370 (2) [pool-1-thread-1]: Warning(s) detected in statement [select distinct accountID from `vActiveSearchEngineAccounts` where ((`vActiv

      eSearchEngineAccounts`.`managerUsernames` like "%tsa_training@thesearchagency.com%"))] executed by user [spike]

      2011-07-19 04:50:27.379 (2) [pool-1-thread-1]: SQL Note: View `tsacommon`.`vActiveSearchEngineAccounts` has no creation context (code:1599)

      2011-07-19 04:50:27.379 (3) [pool-1-thread-1]: ... distinct accountIDs retrieved for email[tsa_training@thesearchagency.com]

      2011-07-19 04:50:27.380 (3) [pool-1-thread-1]: Using filename: /var/local/tsa/sedata/google/tsa-mcc-report-2011-07-18-Utsa_training@thesearchagency.com.xml.g

      z

      2011-07-19 04:50:27.380 (3) [pool-1-thread-1]: Passed null searchEngineUser, connecting user TSA master username/password

      2011-07-19 04:50:27.580 (3) [pool-1-thread-1]: Downloading MCC report...

      2011-07-19 04:50:27.584 (3) [pool-1-thread-1]: Scheduling report attempt 1: name=tsamccreport_2011-07-18_tsa_training@thesearchagency.com_36 with id=null

      2011-07-19 04:50:27.635 (3) [pool-1-thread-1]: validating report job...

      2011-07-19 04:50:28.979 (3) [pool-1-thread-1]: ...success

      2011-07-19 04:50:30.802 (3) [pool-1-thread-1]: Scheduled report. Report Job ID = 2356579620

      2011-07-19 04:52:42.288 (3) [pool-1-thread-1]: Downloading report attempt 1: name=/var/local/tsa/sedata/google/tsa-mcc-report-2011-07-18-Utsa_training@thesea

      rchagency.com.xml.gz with id=2356579620 from url https://adwords.google.com/api/adwords/ReportDownload?t=AAAAAIx2jSQAAAExQj2nxQEAAAAA_-vhwXpkqHEdtDpq1ql6iL

      XBr0gfq4I5

      2011-07-19 04:52:42.460 (3) [pool-1-thread-1]: Connected to URL "https://adwords.google.com/api/adwords/ReportDownload?t=AAAAAIx2jSQAAAExQj2nxQEAAAAA_-vhwXpk

      qHEdtDpq1ql6iLXBr0gfq4I5"

      2011-07-19 04:52:42.939 (3) [pool-1-thread-1]: MCC report download (Mon Jul 18 00:00:00 PDT 2011, "/var/local/tsa/sedata/google/tsa-mcc-report-2011-07-18-Uts

      a_training@thesearchagency.com.xml.gz") -> success:true

      2011-07-19 04:52:42.939 (3) [pool-1-thread-1]: Parsing MCC report into staging database...

      2011-07-19 04:52:43.168 (3) [pool-1-thread-1]: DatabasePool with a limit of 3 created

      2011-07-19 04:52:43.391 (3) [pool-1-thread-1]: Finding column names...

      2011-07-19 04:52:43.394 (3) [pool-1-thread-1]: Writing temp infile...

      2011-07-19 04:52:43.395 (2) [pool-1-thread-1]: XML file does not contain any performance data. Skipping delete & load.

      2011-07-19 04:52:43.396 (3) [pool-1-thread-1]: ...done

      2011-07-19 04:52:43.396 (2) [pool-1-thread-1]: Exception [Unrecoverable error response from google downloading report]:java.lang.NullPointerException

      at com.thesearchagency.searchengines.google.GoogleMCCReport$SearchEngineUserWorker.run(GoogleMCCReport.java:523)

      at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

      at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)

      at java.util.concurrent.FutureTask.run(Unknown Source)

      at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)

      at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

      at java.lang.Thread.run(Unknown Source)

      2011-07-19 04:52:43.397 (3) [pool-1-thread-1]: === Completed TSA MCC account ===

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              therouxj Jeff Theroux
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated: