Details
-
Type: Bug
-
Status: Closed
-
Priority: Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: Third Party Data
-
Labels:None
-
Environment:
Bid Manager Build: tsa-build-bidmgr-2010-10-25-p53-r27768
Service build : svc-channelv2.0-p480-r27768.ear
Admax UI : AdMax-Extended-Unified-Datafeed-p9-r27765.tar
Description
Its observed that for Viking account with Facebook publisher feed, campaignID is always ZERO for one of the source "55+_2010 Summer_RB"
Test Data: (attached)
ConfigurationXML: Facebook_VikingRiver
PublisherFeed :299_177_20101022.csv
Log :Facebook_VikingRiver22.log
1.Upload a Facebook publisher for account-Viking River.
2.Login to staging-xml1 and run as 'root' user
sudo -i /opt/publishers-filepull.sh
3.cd /usr/local/tsa/bidmgr/
./load-publisher.sh -d3 -F -XN Facebook_VikingRiver.xml -XL /var/local/tsa/datafeedConfig/ 2>&1|tee /tmp/Facebook_VikingRiver22.log
4.Now check the values in table `sources`
mysql> SELECT * FROM sources WHERE accountID=299 AND distributionID=177 ORDER BY id DESC limit 4;
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
id | altKey | accountID | siteID | searchEngineAccountID | keywordID | distributionID | searchEngineIdentifier | searchEngineGroupIdentifier | searchEngineMatchType | searchEngineGroupID | isBiddable | campaignID | description | type | keyword | sourceURL | cost | maxCost | waypointID | landingURL | passParams | trackPerformance | searchEngineStatus | searchEngineStatusText | lastChecked |
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
558012521 | fb1845td16 | 299 | 0 | 0 | 0 | 177 | NULL | unknown | 0 | false | 551 | 55+_2010 Fall_RB | 1 | 55+_2010 fall_rb | NULL | 0 | NULL | true | ok | 0000-00-00 00:00:00 |
558012511 | fb1845td15 | 299 | 0 | 0 | 0 | 177 | NULL | unknown | 0 | false | 551 | 55+_2010 Fall_SmallShipMountain | 1 | 55+_2010 fall_smallshipmountain | NULL | 0 | NULL | true | ok | 0000-00-00 00:00:00 |
558012501 | fb1845td13 | 299 | 0 | 0 | 0 | 177 | NULL | unknown | 0 | false | 551 | 55+_2010 Summer_SmallShipMountain | 1 | 55+_2010 summer_smallshipmountain | NULL | 0 | NULL | true | ok | 0000-00-00 00:00:00 |
558012491 | fb1845td09 | 299 | 0 | 0 | 0 | 177 | NULL | unknown | 0 | false | 0 | 55+_2010 Summer_RB | 1 | 55+_2010 summer_rb | NULL | 0 | NULL | true | ok | 0000-00-00 00:00:00 |
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
Now see sources -"55+_2010 Summer_RB",campaignId=0.
I checked it with different publisher feeds but always its showing ZERO for sources "55+_2010 Summer_RB".
*Let me know if missed something here.