Uploaded image for project: 'AdMaxLocal'
  1. AdMaxLocal
  2. AML-1217

AML : Redeploying of Order, having status Error, with "redeploy-order.groovy" doesn't change the status in Reseller UI/Adwords UI.

    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.”

      {PFA Listener Log :AML_Deploy_Error_Listener_Log }

      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

      Also see https://adwords.google.com/cm/CampaignMgmt?__u=1793375532&__c=8145916290&syncServiceIdentity=true#r.ONLINE&app=cm

        Attachments

          Activity

            People

            • Assignee:
              stacie.waleyko Stacie Waleyko (Inactive)
              Reporter:
              atul.sanagar Atul Sanagar (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: