Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: Daily Data Availability Phase 2
-
Fix Version/s: Daily Data Availability Phase 2
-
Component/s: Data Checker
-
Labels:None
-
Environment:
TimeZone Build 147 and Pretimezone build 17
Account:690
Description
Sedatacheck inserts data differently from PretimeZone Build.
Prerequisite : mysql> delete from googleDailyCheck where campaignid=13505522;
Query OK, 440 rows affected (3.74 sec)
mysql> select * from googleDailyCheck where campaignid=13505522 order by date desc limit 5;
Empty set (3.92 sec)
TIMEZONE BUILD
1).tsaapp@tvvm-staging-xml1:/usr/local/tsa/Bid_Manager_-_Trunk_Mavenized/147/tsa-build-bidmgr-2011-12-09-p147-r31056$./sedatacheck.sh -d4 -T2011-12-08 -U2038 -E 2011-12-10 --daily --force 2>&1| tee /tmp/sedatacheck_Build147.log ====Attached====
mysql> select * from googleDailyCheck where campaignid=13505522 order by date desc limit 5;
------------------------------------------------------------------------------------------------+
| date | acctname | campaignid | campaign | imps | clicks | cost | conv |
------------------------------------------------------------------------------------------------+
| 2011-12-08 | 13505522 | Electronics (TVs, GPS, etc.) | Search | USA | 1506858 | 9050 | 6984610000 | 0 |
| 2011-12-07 | 13505522 | Electronics (TVs, GPS, etc.) | Search | USA | 1856762 | 12797 | 8357820000 | 0 |
------------------------------------------------------------------------------------------------+
2 rows in set (3.65 sec)
PRETIMEZONE BUILD
mysql> delete from googleDailyCheck where campaignid=13505522;
Query OK, 2 rows affected (3.52 sec)
/usr/local/tsa/Bid_Manager_-_Pre_timezone_merge/17/tsa-build-bidmgr-2011-11-07-p17-r30849$./sedatacheck.sh -d3 -T2011-12-08 -U2038 -E 2011-12-10 --daily --force 2>&1| tee /tmp/sedatacheck_1.log ===attached===
mysql> delete from googleDailyCheck where campaignid=13505522;
Query OK, 2 rows affected (3.52 sec)
mysql> select * from googleDailyCheck where campaignid=13505522 order by date desc limit 5;
------------------------------------------------------------------------------------------------+
| date | acctname | campaignid | campaign | imps | clicks | cost | conv |
------------------------------------------------------------------------------------------------+
| 2011-12-09 | 13505522 | Electronics (TVs, GPS, etc.) | Search | USA | 646659 | 4287 | 1900260000 | 0 |
| 2011-12-08 | 13505522 | Electronics (TVs, GPS, etc.) | Search | USA | 1506858 | 9050 | 6984610000 | 0 |
------------------------------------------------------------------------------------------------+
2 rows in set (4.29 sec)
