Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Won't Fix
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: Data Summarization
-
Labels:None
-
Environment:
BidManager Build 46
Description
Test Account: Martian Tourism
1.Added new campaign - 'Campaign #2' - see the snapshot.
2.Ran ./seupdate.sh -d 3 --distribution 3 --accounts -U3201 2>&1| /tmp/newcampaign.log ===log attached====
3.mysql> select * from tsacommon.searchEngineAccounts where searchEngineUserID=3201 and description like '%Campaign #2%';
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| id | accountID | distributionID | searchEngineUserID | description | shortCode | paused | searchEngineIdentifier | searchEngineScope | inContent | enabled | useConversionData | searchEngineStatus | searchEngineStatusText | budgetType | budgetAmount | lastChecked | networkType | contentType | biddingStrategy | hidden |
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| 56633 | 780 | 3 | 3201 | Campaign #2_test | NULL | false | 65150098 | true | false | false | ok | SERVING | dailyDivide | 0.5 | NULL | CONTENT_CONTEXTUAL,CONTENT_NETWORK | CONTENT_CONTEXTUAL,CONTENT_NETWORK | ManualCPC | false |
| 57211 | 0 | 3 | 3201 | Campaign #2 | NULL | false | 68958898 | true | false | false | ok | SERVING | dailyDivide | 0.8 | NULL | CONTENT_CONTEXTUAL,CONTENT_NETWORK | CONTENT_CONTEXTUAL,CONTENT_NETWORK | ManualCPC | false |
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2 rows in set (0.00 sec)
mysql> update tsacommon.searchEngineAccounts set accountID=618 where id=57211;
Query OK, 1 row affected (0.11 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> update tsacommon.searchEngineAccounts set enabled='true' where id=57211;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
4.Ran ./seupdate.sh -d 3 --distribution 3 --accounts -U3201 2>&1| /tmp/newcampaign_sync.log ===log attached===
2012-01-25 03:29:36.256 (3) [P1T1]: DatabasePool with a limit of 80 created
2012-01-25 03:29:36.735 (2) [P1T1]: Exception [Saving targeting for accountID 618]:com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry 'campaign-57211-3201-5' for key 'level'
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)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
