Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Blocker
-
Resolution: Fixed
-
Affects Version/s: Point Radii Implementation
-
Fix Version/s: None
-
Component/s: Point Radii Migration
-
Labels:None
-
Environment:
Environment: YELL1
Script:
location-target-remover-0.0.1-SNAPSHOT.jar
Description
When we ran migration script to remove targets then city targets are removed from database(bce_target) but not from Bing Adcenter.
Script used:
java -jar location-target-remover-0.0.1-SNAPSHOT.jar -b 1 -s 84996 -h 4 -d 147
Ran for the following account and isRemoved column is 1
mysql> select * from bce_campaign_location_target_summary where campaignName like '%MGRT02%';
-----------------------------------------------------------------------------------------------------------------------------------------------------+
| searchEngineUserID | customerID | customerAccountID | campaignID | campaignSEID | campaignName | targetID | targetType | isRemoved | removedDate |
-----------------------------------------------------------------------------------------------------------------------------------------------------+
| 84996 | 8039396 | 2765575 | 1329 | 80965822 | MGRT02_1000000024_1137_MGRT02-1_GT | 3054 | city | 1 | 2013-12-18 10:08:26 |
| 84996 | 8039396 | 2765575 | 1329 | 80965822 | MGRT02_1000000024_1137_MGRT02-1_GT | 3275 | city | 1 | 2013-12-18 10:08:26 |
| 84996 | 8039396 | 2765575 | 1329 | 80965822 | MGRT02_1000000024_1137_MGRT02-1_GT | 3298 | city | 1 | 2013-12-18 10:08:26 |
| 84996 | 8039396 | 2765575 | 1329 | 80965822 | MGRT02_1000000024_1137_MGRT02-1_GT | 3509 | city | 1 | 2013-12-18 10:08:26 |
| 84996 | 8039396 | 2765575 | 1329 | 80965822 | MGRT02_1000000024_1137_MGRT02-1_GT | 3546 | city | 1 | 2013-12-18 10:08:26 |
| 84996 | 8039396 | 2765575 | 1329 | 80965822 | MGRT02_1000000024_1137_MGRT02-1_GT | 3558 | city | 1 | 2013-12-18 10:08:26 |
| 84996 | 8039396 | 2765575 | 1329 | 80965822 | MGRT02_1000000024_1137_MGRT02-1_GT | 3604 | city | 1 | 2013-12-18 10:08:26 |
| 84996 | 8039396 | 2765575 | 1329 | 80965822 | MGRT02_1000000024_1137_MGRT02-1_GT | 3704 | city | 1 | 2013-12-18 10:08:26 |
| 84996 | 8039396 | 2765575 | 1329 | 80965822 | MGRT02_1000000024_1137_MGRT02-1_GT | 3723 | city | 1 | 2013-12-18 10:08:26 |
| 84996 | 8039396 | 2765575 | 1329 | 80965822 | MGRT02_1000000024_1137_MGRT02-1_GT | 3733 | city | 1 | 2013-12-18 10:08:26 |
| 84996 | 8039396 | 2765575 | 1329 | 80965822 | MGRT02_1000000024_1137_MGRT02-1_GT | 3868 | city | 1 | 2013-12-18 10:08:26 |
| 84996 | 8039396 | 2765575 | 1329 | 80965822 | MGRT02_1000000024_1137_MGRT02-1_GT | 3888 | city | 1 | 2013-12-18 10:08:26 |
| 84996 | 8039396 | 2765575 | 1329 | 80965822 | MGRT02_1000000024_1137_MGRT02-1_GT | 3962 | city | 1 | 2013-12-18 10:08:26 |
| 84996 | 8039396 | 2765575 | 1329 | 80965822 | MGRT02_1000000024_1137_MGRT02-1_GT | 3981 | city | 1 | 2013-12-18 10:08:26 |
-----------------------------------------------------------------------------------------------------------------------------------------------------+
14 rows in set (0.00 sec)
Target removed from bce_target
mysql> select * from bce_target where id in (3054,3275,3298,3509,3546,3558,3604,3704,3723,3733,3868,3888,3962,3981);
Empty set (0.00 sec)
City targets are not removed from BING AdCenter. Please the screenshot attached.
Attached the full trace log of the migration.
