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
Description
When we run the migration script for a single seuserid then it deletes all the target id's associated with GT campaigns from gce_campaignTargetMap.
Before migration following are the entries in the gce_campaignTargetMap for GT campaigns targets.
mysql> select * from content_editor_google.gce_campaignTargetMap a,content_editor_google.gce_target b where a.campaignid in (1007662,1007664) and a.targetid = b.id;
----------------------------------------------------------------------------------------------------------
| campaignID | targetID | isExclude | hasBidModifier | id | targetType | code | description | criterionID |
----------------------------------------------------------------------------------------------------------
| 1007662 | 1 | false | false | 1 | network | GoogleSearch | Google Search | 0 |
| 1007662 | 2 | false | false | 2 | network | SearchNetwork | Search Partners | 0 |
| 1007662 | 3 | false | false | 3 | network | ContentNetwork | The content network | 0 |
| 1007662 | 13 | false | false | 13 | language | en | English | 1000 |
| 1007662 | 1004 | false | false | 1004 | city | Reading, ENG GB | 1007009 | |
| 1007662 | 2539 | false | true | 2539 | platform | HighEndMobile | HighEndMobile | 30001 |
| 1007662 | 2541 | false | false | 2541 | proximity | 52451456,-990659 | 0 | |
| 1007664 | 1 | false | false | 1 | network | GoogleSearch | Google Search | 0 |
| 1007664 | 2 | false | false | 2 | network | SearchNetwork | Search Partners | 0 |
| 1007664 | 3 | false | false | 3 | network | ContentNetwork | The content network | 0 |
| 1007664 | 13 | false | false | 13 | language | en | English | 1000 |
| 1007664 | 278 | false | false | 278 | city | Aberdeen, SCT GB | 1007293 | |
| 1007664 | 428 | false | false | 428 | city | Bucksburn, SCT GB | 1007308 | |
| 1007664 | 589 | false | false | 589 | city | Elgin, SCT GB | 1007327 | |
| 1007664 | 623 | false | false | 623 | city | Findhorn, SCT GB | 1007332 | |
| 1007664 | 633 | false | false | 633 | city | Forres, SCT GB | 1007334 | |
| 1007664 | 744 | false | false | 744 | city | Inverbervie, SCT GB | 1007344 | |
| 1007664 | 746 | false | false | 746 | city | Inverurie, SCT GB | 1007346 | |
| 1007664 | 785 | false | false | 785 | city | Kirkwall, SCT GB | 1007361 | |
| 1007664 | 787 | false | false | 787 | city | Kirriemuir, SCT GB | 1007362 | |
| 1007664 | 811 | false | false | 811 | city | Lerwick, SCT GB | 1007365 | |
| 1007664 | 896 | false | false | 896 | city | Montrose, SCT GB | 1007374 | |
| 1007664 | 984 | false | false | 984 | city | Portlethen, SCT GB | 1007385 | |
| 1007664 | 1052 | false | false | 1052 | city | Sandwick, SCT GB | 1007394 | |
| 1007664 | 1164 | false | false | 1164 | city | Tarfside, SCT GB | 1007401 | |
| 1007664 | 1196 | false | false | 1196 | city | Trinity, SCT GB | 1007402 | |
| 1007664 | 2539 | false | true | 2539 | platform | HighEndMobile | HighEndMobile | 30001 |
----------------------------------------------------------------------------------------------------------
27 rows in set (0.01 sec)
After Migration
mysql> select * from content_editor_google.gce_campaignTargetMap a,content_editor_google.gce_target b where a.campaignid in (1007662,1007664) and a.targetid = b.id;
Empty set (0.00 sec)
