Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Won't Fix
-
Affects Version/s: TSA Pixel Tracking V2
-
Fix Version/s: TSA Pixel Tracking V2
-
Component/s: TSA Tracking
-
Labels:None
-
Environment:
Staging-xml 01 :BidManagaer Build 57
192.168.30.190|199 : Recording build - 36
Description
table waypointLogLastPaidHit doesn't get updated for paidpixel log after running lastpaidhitsummarizer.sh script.
Steps followed:
1)Copy the scenario-lp-002.txt to staging-xml1 directory /usr/local/share/tsa/logs/spike-v2/working and rename it to -
mv scenario-lp-002.txt 2011-01-25-1000-35.tsv (attached)
2)Change the access time touch -d '2011-01-25 03:01' *.tsv
3)Run the ./v2pixel_playback.sh -d 3 -a 17 2>&1| tee /tmp/pixelplayback_lp002.log (attached)
4)./lastpaidhitsummarizer.sh -a 17 -d3 -T 2011-01-25
5)Check the tables
SELECT * FROM waypointLog
mysql> SELECT * FROM waypointLog where siteID=35;
mysql> SELECT * FROM waypointLog where siteID=35;
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| siteID | unixTimestamp | microseconds | rowNum | waypointID | userAgentID | cpc | distributionID | campaignID | keyword | sourceID | searchEngineListingID | isNewSession | sessionKey | visitorKey | visitorKeyHash | sessionKeyHash | refererURL | ultimateRefererURL | remoteAddr | params | sourceKey | creativeKey | baseUltimateRefererURL | internalURLPatternMatch | isOrganic | backRef | destination | tsaTime | recordedOutOfOrder | parentUnixTimestamp | parentMicroseconds | parentRowNum |
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| 35 | 1295949600 | 0 | 1 | 85 | 31 | 0 | 3 | 13 | quadrophenia | 561911951 | 0 | 1 | usid210f36b33d09645f0b3675d32451304712158805 | uvid84bb09dadfd81c599a30d6af2beeae7d53702 | 3824038039 | 3612092401 | http://www.test.com/index.php | 207.68.235.66 | go1234567_quadrophenia | go1234567 | 0 | 0 | NULL | NULL | 0 | 0 | NULL | NULL | NULL |
| 35 | 1295949605 | 0 | 2 | 85 | 31 | 0 | 86 | 14 | NULL | NULL | 0 | 1 | usid210f36b33d09645f0b3675d32451304712158805 | uvid84bb09dadfd81c599a30d6af2beeae7d53702 | 3824038039 | 3612092401 | http://www.test.com/index.php | http://www.google.com/ | 207.68.235.66 | go1234567 | http://www.google.com | 0 | 1 | NULL | NULL | 0 | 0 | NULL | NULL | NULL |
| 35 | 1295949607 | 0 | 3 | 85 | 31 | 0 | 3 | 13 | quadrophenia | 561911951 | 0 | 1 | usid210f36b33d09645f0b3675d32451304712158805 | uvid84bb09dadfd81c599a30d6af2beeae7d53702 | 3824038039 | 3612092401 | http://www.test.com/index.php | http://www.test.com/search.php | 207.68.235.66 | go1234567_quadrophenia | go1234567 | http://www.test.com | 0 | 0 | NULL | NULL | 0 | 0 | NULL | NULL | NULL |
| 35 | 1295953200 | 0 | 4 | 85 | 31 | 0 | 3 | 13 | quadrophenia | 561911951 | 0 | 1 | usid210f36b33d09645f0b3675d32451304712158805 | uvid84bb09dadfd81c599a30d6af2beeae7d53702 | 3824038039 | 3612092401 | http://www.test.com/index.php | http://www.google.com/ | 207.68.235.66 | go1234567_quadrophenia | go1234567 | http://www.google.com | 0 | 0 | NULL | NULL | 0 | 0 | NULL | NULL | NULL |
| 35 | 1295953205 | 0 | 5 | 85 | 31 | 0 | 3 | 13 | quadrophenia | 561911951 | 0 | 1 | usid210f36b33d09645f0b3675d32451304712158805 | uvid84bb09dadfd81c599a30d6af2beeae7d53702 | 3824038039 | 3612092401 | http://www.test.com/index.php | http://www.google.com/ | 207.68.235.66 | go1234567_quadrophenia | go1234567 | http://www.google.com | 0 | 0 | NULL | NULL | 0 | 0 | NULL | NULL | NULL |
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
5 rows in set (0.03 sec)
SELECT * FROM waypointLogLastPaidHit;
