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

Datachecker_discrepancy_Resolver:Exception [Error in running Staging Application]:java.lang.Exception: Invalid DistributionID:147

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Data Checker
    • Labels:
      None
    • Environment:

      Staging

      Description

      While running ./generate-discrepancies.sh -d3 --accountid 289 --distribution 147 -E 2010-05-18 -T 2010-05-18 -resolve we are getting the exception

      Invalid DistributionID:147.

      Step to reproduce :

      1)cd /var/local/builds/tsa-build-bidmgr-2010-05-19-p2-r26054$ ./generate-discrepancies.sh -d3 --accountid 289 --distribution 147 -E 2010-05-18 -T 2010-05-18

      2010-05-20 06:21:00.926 (3) [main]: Debug Level set to 3

      log4j:WARN No appenders could be found for logger (org.apache.axis.i18n.ProjectResourceBundle).

      log4j:WARN Please initialize the log4j system properly.

      2010-05-20 06:21:12.710 (3) [main]: getAbsolutePath() returned /tmp/abtl25338.csv

      2010-05-20 06:21:12.723 (3) [main]: Connected to URL "http://tvvm-staging-svc2:8080//reports/1/report_195604.csv"

      2010-05-20 06:21:12.765 (3) [main]: getAbsolutePath() returned /tmp/abtl25338.csv

      2010-05-20 06:21:13.077 (3) [main]: DatabasePool with a limit of 80 created

      2010-05-20 06:21:13.122 (3) [main]: getAbsolutePath() returned /tmp/abtl25338.csv

      2010-05-20 06:21:13.303 (3) [main]: Writing file to /var/local/tsa/datachecker/2010-05-20-tsa-DiscrepancyReport-D147.csv

      2010-05-20 06:21:13.310 (3) [main]: ... done

      2010-05-20 06:21:13.310 (3) [main]: Report generated successfully at following location /var/local/tsa/datachecker/2010-05-20-tsa-DiscrepancyReport-D147.csv

      2) cat /var/local/tsa/datachecker/2010-05-20-tsa-DiscrepancyReport-D147.csv

      "Date","Account/Campaign","SE Imps","SE Clicks","SE Cost","SE Conv","Status","SEAcctID","SEUserID","inMCC","AcctID","TSA Account","TSA SE Imps","TSA SE Clicks","TSA SE Cost","TSA SE Conv","Imps Difference","Clicks Difference","Cost Difference","Conv Difference","Campaign Last Synchronized"

      "2010-05-18","Content - Brand","1111","55","3.55","0","enabled","15800","689","","289","LegalZoom","1111.0","1.0","3.55","0","0.0","54.0","0.0","0.0","2010-04-07 00:08:08"

      "2010-05-18","Estate Planning","337","5","120.0","0","enabled","13975","689","","289","LegalZoom","337.0","5.0","9.65","0","0.0","0.0","110.35","0.0","2009-12-10 10:32:37"

      "2010-05-18","NDA","555","4","2.25","0","enabled","32752","689","","289","LegalZoom","379.0","4.0","2.25","0","176.0","0.0","0.0","0.0","2009-12-10 10:22:43"

      "2010-05-18","Small Claims","1173","32","27.21","10","enabled","13974","689","","289","LegalZoom","1173.0","32.0","27.21","0","0.0","0.0","0.0","10.0","2009-12-10 10:21:23"

      3)./generate-discrepancies.sh -d3 --accountid 289 --distribution 147 -E 2010-05-18 -T 2010-05-18 -resolve

      2010-05-20 06:22:11.145 (3) [main]: Debug Level set to 3

      log4j:WARN No appenders could be found for logger (org.apache.axis.i18n.ProjectResourceBundle).

      log4j:WARN Please initialize the log4j system properly.

      2010-05-20 06:22:21.480 (3) [main]: getAbsolutePath() returned /tmp/abtl59291.csv

      2010-05-20 06:22:21.488 (3) [main]: Connected to URL "http://tvvm-staging-svc2:8080//reports/1/report_195605.csv"

      2010-05-20 06:22:21.823 (3) [main]: getAbsolutePath() returned /tmp/abtl59291.csv

      2010-05-20 06:22:22.105 (3) [main]: DatabasePool with a limit of 80 created

      2010-05-20 06:22:22.152 (3) [main]: getAbsolutePath() returned /tmp/abtl59291.csv

      2010-05-20 06:22:22.179 (3) [main]: Writing file to /var/local/tsa/datachecker/2010-05-20-tsa-DiscrepancyReport-D147.csv

      2010-05-20 06:22:22.295 (3) [main]: ... done

      2010-05-20 06:22:22.296 (3) [main]: Report generated successfully at following location /var/local/tsa/datachecker/2010-05-20-tsa-DiscrepancyReport-D147.csv

      2010-05-20 06:22:22.296 (3) [main]: START: First Rerun

      2010-05-20 06:22:22.306 (3) [main]: Getting distinct Discrepancies accounts

      2010-05-20 06:22:22.451 (3) [main]: DatabasePool with a limit of 80 created

      2010-05-20 06:22:22.483 (3) [main]: DatabasePool with a limit of 80 created

      2010-05-20 06:22:22.539 (3) [main]: =============== Starting Data Checker Discrepancy Resolver ================

      2010-05-20 06:22:22.540 (3) [main]: ----------------Data Checker Discrepancy Resolver starting

      2010-05-20 06:22:22.582 (3) [P1T1]: Getting distinct Discrepancies accounts

      2010-05-20 06:22:22.583 (3) [P1T1]: DatabasePool with a limit of 80 created

      2010-05-20 06:22:22.650 (3) [P1T1]: Running Data Checker Discrepancies Resolver for Account ID::289

      2010-05-20 06:22:22.650 (3) [P1T1]: DatabasePool with a limit of 80 created

      2010-05-20 06:22:22.726 (3) [P1T1]: Getting distinct Discrepancies dates

      2010-05-20 06:22:22.727 (3) [P1T1]: DatabasePool with a limit of 80 created

      2010-05-20 06:22:22.807 (3) [P1T1]: Getting distinct Discrepancies accounts

      2010-05-20 06:22:22.807 (3) [P1T1]: DatabasePool with a limit of 80 created

      2010-05-20 06:22:22.842 (3) [P1T1]: Rerun Staging for Resolving Discrepancies for date:2010-05-18

      2010-05-20 06:22:22.843 (1) [P1T1]: Exception [Error in running Staging Application]:java.lang.Exception: Invalid DistributionID:147

      at com.thesearchagency.searchengines.datachecker.DataCheckerDiscrepancyResolver.runStaging(DataCheckerDiscrepancyResolver.java:127)

      at com.thesearchagency.searchengines.datachecker.DataCheckerDiscrepancyResolver.access$1000(DataCheckerDiscrepancyResolver.java:30)

      at com.thesearchagency.searchengines.datachecker.DataCheckerDiscrepancyResolver$DistributionWorker.run(DataCheckerDiscrepancyResolver.java:470)

      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)

      2010-05-20 06:22:22.843 (1) [P1T1]: Exit: Error While Running Staging Application for Rerun 1

      2010-05-20 06:22:22.844 (3) [main]: ------------Data Checker Discrepancy Resolver done

      2010-05-20 06:22:22.844 (3) [main]: =============== Completed Data Checker Discrepancy Resolver ================

        Attachments

          Activity

            People

            • Assignee:
              rupesh.kumar Rupesh Kumar Vijay (Inactive)
              Reporter:
              atul.sanagar Atul Sanagar (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: