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