Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: unspecified
-
Fix Version/s: None
-
Component/s: Data Checker
-
Labels:None
-
Environment:
Operating System: Windows XP
Platform: PC
-
Bugzilla Id:3678
Description
------------------------------------------------------------------------
Project: DataChecker_Discrepancy_Resolver
Component Used: ./generate-discrepancies.sh and resolver
Build: /var/local/builds/tsa-build-bidmgr-2010-03-26-p21-r25381
--------------------------------------------------------------------------
1.Execute ./generate-discrepancies.sh -d3 -account 289 -distribution 164 -E
2009-01-01 -T 2009-01-01
2.cd /var/local/tsa/datachecker
cat 2010-03-29-tsa-DiscrepancyReport-D35.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"
"2009-01-01","LegalZoom2","3900","40","31.0","0","enabled","26609","2552","MCC","289","LegalZoom","0.0","0.0","0.0","0","3900.0","40.0","31.0","0.0","2009-06-18
06:22:51"
"2009-01-01","LLC","12984","81","36.9444","0","enabled","26615","2552","MCC","289","LegalZoom","0.0","0.0","0.0","0","12984.0","81.0","36.94","0.0","2009-06-17
07:46:29"
There are only 2 discrepancies...
3.Now execute script with flag "-resolve"
./generate-discrepancies.sh -d3 -account 289 -distribution 164 -E 2009-01-01 -T
2009-01-01 -resolve
Actual result:
Its taking too much to resolve discrepancy for one day having just 2 discrepanies..
3 hours passed passed still its running...
Actual result:
We feel its taking too much to resolve the discrepancy ,can't we optimize the
queries?
