Details
-
Type:
Bug
-
Status: Open
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: 1.5.0
-
Fix Version/s: All Time Backlog
-
Component/s: Other / Misc.
-
Labels:None
-
Environment:
QA Environment
tsa-build-bidmgr-2013-01-30-p11-rf86b4c83227093f3032d0e0a61a0f05e2e788f30
-
Sprint:High Priority
Description
It is observed that QuotaUsage for adwords services is not getting logged/updated in table "sesytems.quotaUsage" for Google V201209 upgrade.
1. Deployed the old build which have GoogleV201206 changes
(tsa-build-bidmgr-2012-12-13-p14-ra39ef05c9c20e259ba474e1a95e814eafbef509c)
2. Updated property in "admaxjmslistener.properties" and pointed it to old jar.
3.Restarted the listener.
sudo /etc/init.d/tsa-admax-jmslistener.sh restart
4.Create an account (SGS/ADS) and observe table "sesytems.quotaUsage"
mysql> select operation, sum(quotaUsed) from quotaUsage join searchEngineResources on resourceID=id where date between '2013-02-08' and '2013-02-08' group by resourceID;
--------------------------------------+
| operation | sum(quotaUsed) |
--------------------------------------+
| GetAllAdWordsCampaigns | 15 |
| GetAllAdGroups | 90 |
| GetAllCriteria | 2142 |
| GetClientAccounts | 0 |
| AddCampaignList | 9 |
| AddAdGroupList | 9 |
| GetAllAds | 183 |
| AddAdList | 1441 |
| AddCriterionList | 8595 |
| UpdateCampaignList | 127 |
| createClientAccount | 0 |
| addBudget | 3 |
| checkAds | 9 |
| checkCriteria | 36 |
| GetTargetLists | 0 |
| SetCampaignTargets | 45 |
| addAdExtensions | 9 |
--------------------------------------+
17 rows in set (0.01 sec)
Now,
5.Deploy new build which have GoogleV201209 Upgrade -
tsa-build-bidmgr-2013-01-30-p11-rf86b4c83227093f3032d0e0a61a0f05e2e788f30
6.Updated the "admaxjmslistener.properties" and pointed it to new jars.
7.Restart the listener
8.Create new account by SGS/ADS and observe the values in table "sesytems.quotaUsage"
mysql> select operation, sum(quotaUsed) from quotaUsage join searchEngineResources on resourceID=id where date between '2013-02-08' and '2013-02-08' group by resourceID;
--------------------------------------+
| operation | sum(quotaUsed) |
--------------------------------------+
| GetAllAdWordsCampaigns | 15 |
| GetAllAdGroups | 90 |
| GetAllCriteria | 2142 |
| GetClientAccounts | 0 |
| AddCampaignList | 9 |
| AddAdGroupList | 9 |
| GetAllAds | 183 |
| AddAdList | 1441 |
| AddCriterionList | 8595 |
| UpdateCampaignList | 127 |
| createClientAccount | 0 |
| addBudget | 3 |
| checkAds | 9 |
| checkCriteria | 36 |
| GetTargetLists | 0 |
| SetCampaignTargets | 45 |
| addAdExtensions | 9 |
--------------------------------------+
17 rows in set (0.01 sec)
