Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: unspecified
-
Fix Version/s: None
-
Component/s: Third Party Data
-
Labels:None
-
Environment:
Staging-xml1:tsa-build-bidmgr-2010-10-11-p32-r27598
Staging-jboss5:svc-channelv2.0-p425-r27598.ear
Cleint-st:AdMax-Extended-Unified-Datafeed-p4-r27481
Description
Data from Data feed is not inserted properly to table- sources.
1) ./load-generic.sh -d5 -F -XN Facebook.xml -XL /var/local/tsa/datafeedConfig/
2)mysql -u spike -ptar63t -h 192.168.30.12
SELECT * FROM sources WHERE accountID=17 AND distributionID=177 Limit 3;
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 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 |
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 557987221 | fb05110017 | 17 | 0 | 0 | 0 | 177 | NULL | unknown | 0 | false | 0 | Unknown Tag "fb05110017" | 0 | fb05110017 | NULL | 0 | NULL | true | unknown | 0000-00-00 00:00:00 |
| 557987231 | fb05110018 | 17 | 0 | 0 | 0 | 177 | NULL | unknown | 0 | false | 0 | Unknown Tag "fb05110018" | 0 | fb05110018 | NULL | 0 | NULL | true | unknown | 0000-00-00 00:00:00 |
| 557987321 | fb05110019 | 17 | 0 | 0 | 0 | 177 | NULL | unknown | 0 | false | 0 | Unknown Tag "fb05110019" | 0 | fb05110019 | NULL | 0 | NULL | true | unknown | 0000-00-00 00:00:00 |
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
3 rows in set (0.01 sec)
Verify the CampaignID column, its "blank" and description is also not proper :"Unknown Tag "fb05110019" "
