Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 2.0.2
-
Component/s: Content Editor
-
Labels:None
-
Environment:
QA Environment
Service build : smb-ear-2.0.0-RC1-p4-t20130103-145001-CI.ear
Bid manager build : tsa-build-bidmgr-2013-01-03-p4-r3233d3855feb8f9d546b1da4f6c166182ae3b93a
UI build : r58fce39391a26f814a1d39162b212ada4edbffb7
-
Sprint:Sprint 2, Sprint 1 - 2.0.2
Description
Redeploying Orders after updating PointRadius fields (latitudeDegrees,longitudeDegrees and radiusMeters) results in "SearchEngineCommandException: [DistinctError"
Steps to reproduce:
1) Create an Order - 'TestLongandLat' for Merchant 'LatandLongTesting'
BA/BL - HeatPumps/New York
2) Login to Adwords and note down the Locations values.
Locations
Targeted locations:
150.0 km around (43.881248,-78.764448) (custom)
1.0 km around (40.689860,-74.045400) (custom)
1.0 km around (40.699760,-74.039256) (custom)
150.0 km around (41.612020,-78.764448) (custom)
150.0 km around (43.881248,-72.510208) (custom)
265.0 km around (42.746632,-76.768184) (custom)
265.0 km around (42.746632,-74.771896) (custom)
150.0 km around (41.612020,-72.510208) (custom)
3)Update the PointRadius fields for New York.
Original :
mysql> select * from mms_common.pointRadius where locationID=6;
---------------------------------------------------------
| id | locationID | latitudeDegrees | longitudeDegrees | radiusMeters |
---------------------------------------------------------
| 77 | 6 | 41.612020 | -78.764450 | 150000 |
| 78 | 6 | 43.881250 | -78.764450 | 150000 |
| 79 | 6 | 42.746630 | -76.768180 | 265000 |
| 80 | 6 | 42.746630 | -74.771900 | 265000 |
| 81 | 6 | 41.612020 | -72.510210 | 150000 |
| 82 | 6 | 43.881250 | -72.510210 | 150000 |
| 83 | 6 | 40.689860 | -74.045400 | 1000 |
| 84 | 6 | 40.699760 | -74.039250 | 1000 |
---------------------------------------------------------
8 rows in set (0.00 sec)
Updated:
pdate pointRadius set latitudeDegrees=45.612020 where id=77;
update pointRadius set longitudeDegrees=-88.764450 where id=77;
update pointRadius set radiusMeters=250000 where id=77;
mysql> select * from mms_common.pointRadius where locationID=6;
---------------------------------------------------------
| id | locationID | latitudeDegrees | longitudeDegrees | radiusMeters |
---------------------------------------------------------
| 77 | 6 | 45.612020 | -88.764450 | 250000 |
| 78 | 6 | 43.881250 | -78.764450 | 150000 |
| 79 | 6 | 42.746630 | -76.768180 | 265000 |
| 80 | 6 | 42.746630 | -74.771900 | 265000 |
| 81 | 6 | 41.612020 | -72.510210 | 150000 |
| 82 | 6 | 43.881250 | -72.510210 | 150000 |
| 83 | 6 | 40.689860 | -74.045400 | 1000 |
| 84 | 6 | 40.699760 | -74.039250 | 1000 |
---------------------------------------------------------
8 rows in set (0.00 sec)
4)Now create Order with different name 'TestLongandLat1' for Merchant 'LatandLongTesting' with same BA/BL i.e HeatPumps/New York
Actual result:
Listener Log shows the exception and updated values are not seen in adwords
Snippet of Listener Log:
{Detailed listener log attached}013-01-17 12:54:27.716 (4) [P28T1]: Exception [handling exception thrown by google...]:com.thesearchagency.searchengines.SearchEngineCommandException: [DistinctError.DUPLICATE_ELEMENT @ operations[1], DistinctError.DUPLICATE_ELEMENT @ operations[2], DistinctError.DUPLICATE_ELEMENT @ operations[3], DistinctError.DUPLICATE_ELEMENT @ operations[4], DistinctError.DUPLICATE_ELEMENT @ operations[5], DistinctError.DUPLICATE_ELEMENT @ operations[6], DistinctError.DUPLICATE_ELEMENT @ operations[7], DistinctError.DUPLICATE_ELEMENT @ operations[27], DistinctError.DUPLICATE_ELEMENT @ operations[28], DistinctError.DUPLICATE_ELEMENT @ operations[29], DistinctError.DUPLICATE_ELEMENT @ operations[30], DistinctError.DUPLICATE_ELEMENT @ operations[31], DistinctError.DUPLICATE_ELEMENT @ operations[32], DistinctError.DUPLICATE_ELEMENT @ operations[33]]
at com.thesearchagency.searchengines.google.GoogleAdWordsAPI.setCampaignTargets(GoogleAdWordsAPI.java:4035)
.
.
.
Caused by: [DistinctError.DUPLICATE_ELEMENT @ operations[1], DistinctError.DUPLICATE_ELEMENT @ operations[2], DistinctError.DUPLICATE_ELEMENT @ operations[3], DistinctError.DUPLICATE_ELEMENT @ operations[4], DistinctError.DUPLICATE_ELEMENT @ operations[5], DistinctError.DUPLICATE_ELEMENT @ operations[6], DistinctError.DUPLICATE_ELEMENT @ operations[7], DistinctError.DUPLICATE_ELEMENT @ operations[27], DistinctError.DUPLICATE_ELEMENT @ operations[28], DistinctError.DUPLICATE_ELEMENT @ operations[29], DistinctError.DUPLICATE_ELEMENT @ operations[30], DistinctError.DUPLICATE_ELEMENT @ operations[31], DistinctError.DUPLICATE_ELEMENT @ operations[32], DistinctError.DUPLICATE_ELEMENT @ operations[33]]
at sun.reflect.GeneratedConstructorAccessor45.newInstance(Unknown Source)
