Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Blocker
-
Resolution: Fixed
-
Affects Version/s: 2.0.2
-
Fix Version/s: 2.0.2
-
Component/s: None
-
Labels:None
-
Environment:
QA Environment
· SAPI - OMS-2.0.2-Prod - Build 23
· UI 2.0.2 - Build 34
· Core - Trunk Build 772
· BidMgr/Listener - Trunk Build 797
· Updated Groovy scripts (onboard.groovy) as on 21st Feb
-
Sprint:Sprint 3 - 2.0.2
Description
Redeploying of Order using "redeploy-order.groovy", having status Error, doesn't change the status in Reseller UI/Adwords UI.
Steps:
1.Select any BA.
select * from mms_common.businessAreas where id=10009;
---------------------------------
| id | description | status |
---------------------------------
| 10009 | Forensic Accountants | active |
---------------------------------
1 row in set (0.00 sec)
2.Now update the keyword so that it become invalid.
mysql> select * from biz_function_location.keywordLists where businessFunctionID=10009;
--------------------------------------------------------------+
| id | businessFunctionID | dateCreated | dateUpdated |
--------------------------------------------------------------+
| 2642 | 10009 | 2012-11-08 16:58:29 | 2013-02-19 20:00:16 |
--------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> select * from keywords where keywordListID=2642;
-------------------------------------------------------------------------------------------------------------
| id | keywordListID | keyword | matchType | isGeoMod | isGeoTarget | isMobile | isNegative | subGroupID |
-------------------------------------------------------------------------------------------------------------
| 198649 | 2642 | +account +forensics | broad | 0 | 1 | 1 | 0 | 0 |
| 198648 | 2642 | +accounting +forensics | broad | 0 | 1 | 1 | 0 | 0 |
| 198643 | 2642 | +certified +forensic +accountant | broad | 0 | 1 | 1 | 0 | 0 |
.
.
| 198640 | 2642 | financial fraud detection | exact | 1 | 1 | 1 | 0 | 0 |
| 198635 | 2642 | find a forensic accountant | exact | 1 | 1 | 1 | 0 | 0 |
Update the keyword with "comma" in between.
mysql> update keywords set keyword='financial, fraud detection' where id=198640;
3.Create new merchant - “TestingErrorRedeployment” and then create quote with above BA which has invalid keyword and save it.
4.Deploy this quote and observe the status of the order -
The status of order is “Error” – which is expected. The campaigns page displays – “The most recent order incurred an error. Account updates cannot be deployed until the error with the previous order is resolved. Changes may be saved as a Quote.”
5.Now clear the errors by removing comma of the keyword.
mysql> update keywords set keyword='financial fraud detection' where id=198640;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
6.Redeploy this order by using groovy script.
[root@aq-qa-tomcat1 groovy]# groovy redeploy-order.groovy -ah http://aq-qa-tomcat1:8080/sapi/rest/ --merchantUUID e3229750-8190-4a9e-b5a8-8e8eddcad7f3 -ra reseller1 -u reseller1@thesearchagency.com -preseller1
.
.
.
DEBUG - Transfer-Encoding : chunked
DEBUG - Response data: -----
DEBUG - X2CU34D5NWDJUZPN3GCWIGFVNI7DX5N7E2AKA77NRRAI6QXMCI6VVFVHQVFSOVWRE46B6VK7ZDMPKZW5IQXD4IAXGGQZNMQRVAFIMAX54ACSVQYO5I662OMA2W7FSP22NHDKJOLZKUZZTXYFUO5T7EB5CYUGYBURR3A42SCY73QK7QMJXBWUNK7HZ44R4DS5TBM7X5S3I5DUGTEIMLQNLRZQTM======
DEBUG - --------------------
DEBUG - Redeploying most recent order for merchant 'e3229750-8190-4a9e-b5a8-8e8eddcad7f3'
Observations :
Even though listener log shows that account gets deployed successfully, status of campaign in UI and ad words remains as it is - ERROR.
PFA Listener Log : AML_Redeploy_Order_Error_ListenerLog.txt
