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