Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Critical
-
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-12-02-p81-r28114.tar
Service build : svc-channelv2.0-p561-r28114.ear
Admax UI:AdMax-Extended-Unified-Datafeed-p10-r27798.tar
Description
After running the ./load-all-publisher.sh script, distributions are not displaying on UI as status "active" is in lowercase in table:accountDistributionMap.
Steps to reproduce:
1)tvvm-staging-xml1:/var/local/tsa/publisherfeedConfig# ls -lrt
total 24
rw-rr- 1 mtolety users 5651 Nov 23 13:20 csc_facebook.xml.bak
rw-rr- 1 tsaapp tsaapp 2454 Dec 2 04:44 Kontera_latest.xml.bak
rw-rr- 1 tsaapp tsaapp 2265 Dec 2 04:44 CSC_VibrantMedia-new.xml
rw-rr- 1 tsaapp tsaapp 5335 Dec 2 04:44 CSC_Facebook.xml
2)Delete the entry for Facebook and VibrantMedia from the table accountDistributionMap.
3)Run ./load-all-publishers.sh
./load-all-publishers.sh -d3 2>&1 | tee /tmp/test2.out
4)Now check tsacommon.accountDistributionMap
mysql> SELECT * FROM accountDistributionMap WHERE distributionID IN (SELECT id FROM distribution WHERE distributionID IN (177,197)ORDER BY accountID);
-------------------------------------------------------+
| accountID | distributionID | status | configFile |
-------------------------------------------------------+
| 17 | 177 | active | CSC_Facebook.xml |
| 17 | 197 | active | CSC_VibrantMedia-new.xml |
| 289 | 177 | ACTIVE | x |
| 299 | 177 | ACTIVE | x |
-------------------------------------------------------+
4 rows in set (0.01 sec)
5)Login to Admax and view "Manage Third Part Data", Distributions are not displaying.(Find the snapshot :Extended_UDF_Distribution_not_Displaying.gif attached)
6)Now Update the status from active to "ACTIVE" and view the "Manage Third Part Data" page. (Snapshot attached)
