Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: Wickford
    • Fix Version/s: Wickford
    • Component/s: None
    • Labels:
      None
    • Environment:

      QA2:
      • BigMgr – WICKFORD-RELEASE p1
      • Core – WICKFORD_RELEASE p1
      • Reseller UI - 72
      • Merchant UI - 72
      • Sapi - 242
      • Templates - 22
      • Data Util Jar – 36

    • Sprint:
      Wickford - Sprint 7

      Description

      In this case, the merchant has one active AML campaign, they add another, delete the original, and then add the original back and delete the 2nd one.

      Steps:
      1. Created a new merchant and order with one BA/BL, and deployed it and checked it in Google
      -campaign name: a3488064-bc97-4135-b3f2-3200a6f06090_50104_200001_1822_GT

      2. Added another BA/BL to the order, deployed it and checked it in Google
      -campaign name: a3488064-bc97-4135-b3f2-3200a6f06090_50382_200001_1824_GT

      3. Deleted the original BA/BL from step 1, redeployed it and checked in Google.
      -Campaign now deleted: a3488064-bc97-4135-b3f2-3200a6f06090_50104_200001_1822_GT

      4. Added the original BA/BL back to the order
      -New campaign created: a3488064-bc97-4135-b3f2-3200a6f06090_50104_200001_1829_GT

      5. Deleted the dummy campaign from the 2nd step – got error in AML UI and Google shows campaign as paused.
      -You can see in the screenshot, that the correct campaigns are deleted, and the new campaign is paused, waiting to become active.

      Result: The campaigns are paused in Google, and AML UI shows Error for the order. I was expecting the campaigns to active in the Google, and deployed in the UI.

      Tomcat log: (from 1st attempt)

      2013-09-05 19:02:08,985-293031118 [OrderScheduler_Worker-3] WARN com.thesearchagency.sapi.services.order.OrderStatusUpdateJob [] - Could not acquire lock. Will not attempt to update deployed orders in this pass.

      Tomcat log: (2nd attempt)

      --------------------------------------
      2013-09-06 18:21:43,265-30859016 [OrderScheduler_Worker-1] INFO com.thesearchagency.sapi.services.order.OrderStatusUpdateJob [] - Beginning update for 1 orders.
      2013-09-06 18:21:43,267-30859018 [OrderScheduler_Worker-1] INFO com.thesearchagency.sapi.services.order.OrderService [] - Attempting to update order status for order fd34efa6-6f38-4ce6-91df-b76c5bd1a378
      2013-09-06 18:21:47,928-30863679 [OrderScheduler_Worker-1] WARN com.thesearchagency.sapi.services.order.DeploymentServiceHelper [] - Failed to set the campaign state to PAUSED for 1845
      2013-09-06 18:21:48,233-30863984 [OrderScheduler_Worker-1] ERROR com.thesearchagency.saas.core.services.user.UserServiceComponent [] - Error fetching user
      com.thesearchagency.database.storage.StorageManagerException: package com.thesearchagency.database.storage.INVALID_KEY_EXCEPTION

      Listener log: (shows deployment success)

      2013-09-05 18:53:47.804 (3) [pool-3-thread-39]: Finished DEPLOY request for campaign a3488064-bc97-4135-b3f2-3200a6f06090_50104_200001_1829_GT: SUCCEEDED
      2013-09-05 18:53:47.806 (3) [pool-3-thread-39]: Finished DEPLOY request for campaign a3488064-bc97-4135-b3f2-3200a6f06090_50104_200001_1829_GM: SUCCEEDED
      2013-09-05 18:53:47.807 (3) [pool-3-thread-39]: Finished DEPLOY request for campaign a3488064-bc97-4135-b3f2-3200a6f06090_50104_200001_1829_MO: SUCCEEDED
      2013-09-05 18:53:47.808 (3) [pool-3-thread-39]: Finished DEPLOY request for campaign a3488064-bc97-4135-b3f2-3200a6f06090_50382_200001_1824_GT: SUCCEEDED
      2013-09-05 18:53:47.810 (3) [pool-3-thread-39]: Finished DEPLOY request for campaign a3488064-bc97-4135-b3f2-3200a6f06090_50382_200001_1824_GM: SUCCEEDED
      2013-09-05 18:53:47.811 (3) [pool-3-thread-39]: Finished DEPLOY request for campaign a3488064-bc97-4135-b3f2-3200a6f06090_50382_200001_1824_MO: SUCCEEDED
      2013-09-05 18:53:47.811 (3) [pool-3-thread-39]: a3488064-bc97-4135-b3f2-3200a6f06090 has 0 campaigns for a SE Update accounts sync.
      2013-09-05 18:53:47.811 (3) [pool-3-thread-39]: a3488064-bc97-4135-b3f2-3200a6f06090 has 0 campaigns for a SE Update groups-listings sync.
      2013-09-05 18:53:47.812 (3) [pool-3-thread-39]: Finished sub-campaign processing for DEPLOY deploymentID (2ddb7dd3-0817-4d22-bc5b-67bbf9ddda5a). account a3488064-bc97-4135-b3f2-3200a6f06090. 6 submitted, 6 ok.
      2013-09-05 18:53:47.817 (3) [pool-3-thread-39]: Finished DEPLOY request for a3488064-bc97-4135-b3f2-3200a6f06090_50104_200001_1829: SUCCEEDED
      2013-09-05 18:53:47.819 (3) [pool-3-thread-39]: Finished DEPLOY request for a3488064-bc97-4135-b3f2-3200a6f06090_50382_200001_1824: SUCCEEDED
      2013-09-05 18:53:47.819 (3) [pool-3-thread-39]: Finished DEPLOY request, deploymentID (2ddb7dd3-0817-4d22-bc5b-67bbf9ddda5a), account a3488064-bc97-4135-b3f2-3200a6f06090
      2013-09-05 18:53:47.819 (3) [pool-3-thread-39]: Request removed from map for customerID a3488064-bc97-4135-b3f2-3200a6f06090
      2013-09-05 18:53:47.819 (4) [pool-3-thread-39]: spike: SQL->[SELECT RELEASE_LOCK('com.thesearchagency.admaxlistener.dao.TSACommonDAO.a3488064-bc97-4135-b3f2-3200a6f06090')]
      2013-09-05 18:53:47.821 (4) [pool-3-thread-39]: Released account lock: a3488064-bc97-4135-b3f2-3200a6f06090
      2013-09-05 18:56:52.194 (3) [Thread-9]: Request added to map for customerID a3488064-bc97-4135-b3f2-3200a6f06090
      2013-09-05 18:56:52.194 (3) [Thread-9]: Request worker created for a3488064-bc97-4135-b3f2-3200a6f06090
      2013-09-05 18:56:52.195 (3) [Thread-9]: Submitted executor job for a3488064-bc97-4135-b3f2-3200a6f06090
      2013-09-05 18:56:52.274 (4) [pool-3-thread-40]: spike: SQL->[SELECT GET_LOCK('com.thesearchagency.admaxlistener.dao.TSACommonDAO.a3488064-bc97-4135-b3f2-3200a6f06090', 7200)]
      2013-09-05 18:56:52.277 (4) [pool-3-thread-40]: spike: SQL->[select * from `tsacommon`.`accounts` where ((`description`="a3488064-bc97-4135-b3f2-3200a6f06090")) limit 1]
      2013-09-05 18:56:52.491 (3) [pool-3-thread-40]: Start processing UPDATE request (2ddb7dd3-0817-4d22-bc5b-67bbf9ddda5a) for account a3488064-bc97-4135-b3f2-3200a6f06090. 6 campaign(s).
      2013-09-05 18:56:52.492 (4) [pool-3-thread-40]: Locked account: a3488064-bc97-4135-b3f2-3200a6f06090
      2013-09-05 18:56:52.492 (3) [pool-3-thread-40]: Performing update for account: a3488064-bc97-4135-b3f2-3200a6f06090 ID#351
      2013-09-05 18:56:52.593 (3) [pool-3-thread-40]: Updating a3488064-bc97-4135-b3f2-3200a6f06090_50382_200001_1824_GM Status: Deleted
      2013-09-05 18:56:52.593 (3) [pool-3-thread-40]: Updating a3488064-bc97-4135-b3f2-3200a6f06090_50382_200001_1824_GT Status: Deleted
      2013-09-05 18:56:52.594 (3) [pool-3-thread-40]: Updating a3488064-bc97-4135-b3f2-3200a6f06090_50382_200001_1824_MO Status: Deleted
      2013-09-05 18:56:52.594 (3) [pool-3-thread-40]: Updating a3488064-bc97-4135-b3f2-3200a6f06090_50104_200001_1829_GM Status: Paused
      2013-09-05 18:56:52.594 (3) [pool-3-thread-40]: Updating a3488064-bc97-4135-b3f2-3200a6f06090_50104_200001_1829_GT Status: Paused
      2013-09-05 18:56:52.594 (3) [pool-3-thread-40]: Updating a3488064-bc97-4135-b3f2-3200a6f06090_50104_200001_1829_MO Status: Paused
      2013-09-05 18:56:52.832 (3) [pool-3-thread-40]: a3488064-bc97-4135-b3f2-3200a6f06090_50382_200001_1824_GT status change (Active->Deleted)
      2013-09-05 18:56:52.834 (3) [pool-3-thread-40]: a3488064-bc97-4135-b3f2-3200a6f06090_50382_200001_1824_GM status change (Active->Deleted)
      2013-09-05 18:56:52.836 (3) [pool-3-thread-40]: a3488064-bc97-4135-b3f2-3200a6f06090_50382_200001_1824_MO status change (Active->Deleted)
      2013-09-05 18:56:52.839 (3) [pool-3-thread-40]: a3488064-bc97-4135-b3f2-3200a6f06090_50104_200001_1829_GT status change (Active->Paused)
      2013-09-05 18:56:52.839 (3) [pool-3-thread-40]: a3488064-bc97-4135-b3f2-3200a6f06090_50104_200001_1829_GM status change (Active->Paused)
      2013-09-05 18:56:52.840 (3) [pool-3-thread-40]: a3488064-bc97-4135-b3f2-3200a6f06090_50104_200001_1829_MO status change (Active->Paused)
      2013-09-05 18:56:54.127 (4) [P107T1]: ...updated campaignName[a3488064-bc97-4135-b3f2-3200a6f06090_50382_200001_1824_GT] campaignID[133494127]
      2013-09-05 18:56:54.128 (4) [P107T1]: ...updated campaignName[a3488064-bc97-4135-b3f2-3200a6f06090_50382_200001_1824_GM] campaignID[133494247]
      2013-09-05 18:56:54.128 (4) [P107T1]: ...updated campaignName[a3488064-bc97-4135-b3f2-3200a6f06090_50382_200001_1824_MO] campaignID[133494367]
      2013-09-05 18:56:54.129 (4) [P107T1]: ...updated campaignName[a3488064-bc97-4135-b3f2-3200a6f06090_50104_200001_1829_GT] campaignID[133497607]
      2013-09-05 18:56:54.129 (4) [P107T1]: ...updated campaignName[a3488064-bc97-4135-b3f2-3200a6f06090_50104_200001_1829_GM] campaignID[133497727]
      2013-09-05 18:56:54.129 (4) [P107T1]: ...updated campaignName[a3488064-bc97-4135-b3f2-3200a6f06090_50104_200001_1829_MO] campaignID[133497847]
      2013-09-05 18:56:54.678 (3) [pool-3-thread-40]: a3488064-bc97-4135-b3f2-3200a6f06090_50382_200001_1824_GT status updated to Deleted
      2013-09-05 18:56:54.686 (3) [pool-3-thread-40]: a3488064-bc97-4135-b3f2-3200a6f06090_50382_200001_1824_GM status updated to Deleted
      2013-09-05 18:56:54.696 (3) [pool-3-thread-40]: a3488064-bc97-4135-b3f2-3200a6f06090_50382_200001_1824_MO status updated to Deleted
      2013-09-05 18:56:54.707 (3) [pool-3-thread-40]: a3488064-bc97-4135-b3f2-3200a6f06090_50104_200001_1829_GT status updated to Paused
      2013-09-05 18:56:54.717 (3) [pool-3-thread-40]: a3488064-bc97-4135-b3f2-3200a6f06090_50104_200001_1829_GM status updated to Paused
      2013-09-05 18:56:54.727 (3) [pool-3-thread-40]: a3488064-bc97-4135-b3f2-3200a6f06090_50104_200001_1829_MO status updated to Paused
      2013-09-05 18:56:54.881 (3) [pool-3-thread-40]: Finished UPDATE request for campaign a3488064-bc97-4135-b3f2-3200a6f06090_50382_200001_1824_GM: SUCCEEDED
      2013-09-05 18:56:54.883 (3) [pool-3-thread-40]: Finished UPDATE request for campaign a3488064-bc97-4135-b3f2-3200a6f06090_50382_200001_1824_GT: SUCCEEDED
      2013-09-05 18:56:54.885 (3) [pool-3-thread-40]: Finished UPDATE request for campaign a3488064-bc97-4135-b3f2-3200a6f06090_50382_200001_1824_MO: SUCCEEDED
      2013-09-05 18:56:54.886 (3) [pool-3-thread-40]: Finished UPDATE request for campaign a3488064-bc97-4135-b3f2-3200a6f06090_50104_200001_1829_GM: SUCCEEDED
      2013-09-05 18:56:54.888 (3) [pool-3-thread-40]: Finished UPDATE request for campaign a3488064-bc97-4135-b3f2-3200a6f06090_50104_200001_1829_GT: SUCCEEDED
      2013-09-05 18:56:54.890 (3) [pool-3-thread-40]: Finished UPDATE request for campaign a3488064-bc97-4135-b3f2-3200a6f06090_50104_200001_1829_MO: SUCCEEDED
      2013-09-05 18:56:54.890 (3) [pool-3-thread-40]: a3488064-bc97-4135-b3f2-3200a6f06090 has 0 campaigns for a SE Update accounts sync.
      2013-09-05 18:56:54.890 (3) [pool-3-thread-40]: a3488064-bc97-4135-b3f2-3200a6f06090 has 0 campaigns for a SE Update groups-listings sync.
      2013-09-05 18:56:54.890 (3) [pool-3-thread-40]: Finished sub-campaign processing for UPDATE deploymentID (2ddb7dd3-0817-4d22-bc5b-67bbf9ddda5a). account a3488064-bc97-4135-b3f2-3200a6f06090. 6 submitted, 6 ok.
      2013-09-05 18:56:54.902 (3) [pool-3-thread-40]: Finished UPDATE request, deploymentID (2ddb7dd3-0817-4d22-bc5b-67bbf9ddda5a), account a3488064-bc97-4135-b3f2-3200a6f06090
      2013-09-05 18:56:54.902 (3) [pool-3-thread-40]: Request removed from map for customerID a3488064-bc97-4135-b3f2-3200a6f06090
      2013-09-05 18:56:54.903 (4) [pool-3-thread-40]: spike: SQL->[SELECT RELEASE_LOCK('com.thesearchagency.admaxlistener.dao.TSACommonDAO.a3488064-bc97-4135-b3f2-3200a6f06090')]
      2013-09-05 18:56:54.905 (4) [pool-3-thread-40]: Released account lock: a3488064-bc97-4135-b3f2-3200a6f06090

        Attachments

          Activity

            People

            • Assignee:
              sanjaykumar.biswal Sanjay Kumar Biswal
              Reporter:
              jelliott Jen Clarke (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: