Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Blocker
-
Resolution: Fixed
-
Affects Version/s: 1.3.0
-
Fix Version/s: 1.3.0
-
Component/s: Other / Misc.
-
Labels:None
Description
Radius Boosting jobs throws exception - Exception [Error during update request.]:com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry '211-1453' for key 'PRIMARY'
Steps:
1)SGS/ADS soap requests are deployed for customerid- radiusboostqa3 === Soap requests are attached===
2)Login to Brand UI and create Brand Campaign.
SELECT description FROM clients.externalCampaignParent where description like '%radiusboostqa3%';
radiusboostqa3-1_BRAND
3)INSERT INTO mms_common.pointRadiusModifiers (advertID,multiplier,incrementer) values ('radiusboostqa3-1',2.0,0);
INSERT INTO mms_common.pointRadiusModifiers (advertID,multiplier,incrementer) values ('radiusboostqa3-1_BRAND',2.0,0);
mysql> SELECT * FROM clients.externalCampaign ec join clients.externalCampaignParent ecp on ec.externalCampaignParentID=ecp.id where ec.id like 'radiusboostqa3%' and ecp.status != 'Deleted';
---------------------------------------------------------------------------------------------------------------------------------------------------------------+
| id | externalCampaignParentID | gceCampaignID | searchEngineAccountID | accountID | enabled | id | description | accountID | admaxCampaignID | status | typeID |
---------------------------------------------------------------------------------------------------------------------------------------------------------------+
| radiusboostqa3-1_BRAND | 117 | 211 | 405949 | 5970 | 1 | 117 | radiusboostqa3-1_BRAND | 5970 | 106 | Paused | 2 |
---------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
1 row in set (0.00 sec)
4)INSERT INTO clients.externalCampaignJobItem (externalCampaignID, externalCampaignJobTypeID, createTime) values ('radiusboostqa3_GM', 6, now());
INSERT INTO clients.externalCampaignJobItem (externalCampaignID, externalCampaignJobTypeID, createTime) values ('radiusboostqa3_GT', 6, now());
INSERT INTO clients.externalCampaignJobItem (externalCampaignID, externalCampaignJobTypeID, createTime) values ('radiusboostqa3_MO', 6, now());
INSERT INTO clients.externalCampaignJobItem (externalCampaignID, externalCampaignJobTypeID, createTime) values ('radiusboostqa3-1_BRAND', 6, now());
mysql> select * from clients.externalCampaignJobItem;
-------------------------------------------------------------------------------------------
| id | externalCampaignJobTypeID | externalCampaignJobID | externalCampaignID | createTime |
-------------------------------------------------------------------------------------------
| 1 | 6 | NULL | radiusboostqa3_GM | 2012-08-07 12:03:42 |
| 2 | 6 | NULL | radiusboostqa3_GT | 2012-08-07 12:03:42 |
| 3 | 6 | NULL | radiusboostqa3_MO | 2012-08-07 12:03:42 |
| 4 | 6 | NULL | radiusboostqa3-1_BRAND | 2012-08-07 12:03:44 |
-------------------------------------------------------------------------------------------
4 rows in set (0.00 sec)
5) tail -f /var/local/tsa/log/tsa-admax-jmslistener/tsa-admax-jmslistener.log ===Detailed log attached===
2012-08-07 22:06:33.792 (2) [pool-4-thread-1]: Error: CampID: radiusboostqa3-1_BRAND Info: Error during update request.
2012-08-07 22:06:33.792 (1) [pool-4-thread-1]: Exception [Error during update request.]:com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry '211-1453' for key 'PRIMARY'
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
