Redeploying the order after deleting the bad keywords from keyword list throws DistinctError(reason: DistinctError.DUPLICATE_ELEMENT)

Redeploying the order after deleting the bad keywords from keyword list throws DistinctError(reason: DistinctError.DUPLICATE_ELEMENT)

Steps: (Related to AML-2317)

1. Select any BA and insert bad keyword for it.

Suppose: BA = Appliance Repair

insert into biz_function_location.keywords (keywordListID, keyword, matchType , isNegative , isGeoMod , isGeoTarget ) values (237, 'testingbad, keyword', 'exact', 0, 1, 1);

2.Create an order with this BA and deploy - order gets deployed and show ERROR

Snippet of listener log

{PFA AML_Deployment_Badkeyword}

2014-02-17 09:11:39.624 (2) [pool-15-thread-1]: Google Request Errors for accountID 302(KeywordChangeRequest)

Keyword: testingbad, keyword
Type: Exact
Status: Active
id=123451, code=0: CriterionError(reason: KEYWORD_HAS_INVALID_CHARS)(isExemptable: false), trigger=testingbad, keyword, field=operations[25].operand.criterion.text
2014-02-17 09:11:39.736 (3) [pool-15-thread-2]: KeywordDAO(accountID 302) Request contained 51 adds, 0 updates, 0 deletes.
2014-02-17 09:11:39.736 (3) [pool-15-thread-2]: KeywordDAO(accountID 302) DB updates: 51 items updated, 51 pending changes deleted, 0 pending updates deleted, 0 errors cleared
2014-02-17 09:11:39.741 (3) [pool-15-thread-2]: KeywordDAO(accountID 302): Inserted 3 Errors: Updated 3 pending changes, cleared 0 existing errors.
2014-02-17 09:11:39.741 (2) [pool-15-thread-2]: Google Request Errors for accountID 302(KeywordChangeRequest)

Keyword: testingbad, keyword in Cadron AR
Type: Exact
Status: Active
id=123509, code=0: CriterionError(reason: KEYWORD_HAS_INVALID_CHARS)(isExemptable: false), trigger=testingbad, keyword in Cadron AR, field=operations[3].operand.criterion.text

3.Edit account and delete the bad keyword from keyword list. (PFA screenshot)

4.Deploy the order and observe the listener log:

Actual result:

Listener log shows error for the keyword "RangeError(reason: RangeError.TOO_LOW)

Snippet log listener log:

{PFA complete log - AML_Redeployment_removing_badkeyword}

2014-02-17 09:14:32.845 (2) [pool-24-thread-2]: Google Request Errors for accountID 302(KeywordChangeRequest)

Keyword: testingbad, keyword Cadron AR
Type: Exact
Status: Active
id=123508, code=0: RangeError(reason: RangeError.TOO_LOW)(isExemptable: false), trigger=, field=operations[0].operand.criterion.id.id

Keyword: Cadron AR testingbad, keyword
Type: Exact
Status: Active
id=123510, code=0: DistinctError(reason: DistinctError.DUPLICATE_ELEMENT)(isExemptable: false), trigger=, field=operations[1]
id=123510, code=0: RangeError(reason: RangeError.TOO_LOW)(isExemptable: false), trigger=, field=operations[1].operand.criterion.id.id

Keyword: testingbad, keyword in Cadron AR
Type: Exact
Status: Active
id=123509, code=0: DistinctError(reason: DistinctError.DUPLICATE_ELEMENT)(isExemptable: false), trigger=, field=operations[2]
id=123509, code=0: RangeError(reason: RangeError.TOO_LOW)(isExemptable: false), trigger=, field=operations[2].operand.criterion.id.id
2014-02-17 09:14:32.851 (3) [pool-24-thread-1]: KeywordDAO(accountID 302): Inserted 1 Errors: Updated 1 pending changes, cleared 1 existing errors.
2014-02-17 09:14:32.851 (2) [pool-24-thread-1]: Google Request Errors for accountID 302(KeywordChangeRequest)

Keyword: testingbad, keyword
Type: Exact
Status: Active
id=123451, code=0: RangeError(reason: RangeError.TOO_LOW)(isExemptable: false), trigger=, field=operations[0].operand.criterion.id.id
2014-02-17 09:14:32.962 (3) [pool-24-thread-3]: KeywordDAO(accountID 302): Inserted 5 Errors: Updated 3 pending changes, cleared 3 existing errors.
2014-02-17 09:14:32.962 (2) [pool-24-thread-3]: Google Request Errors for accountID 302(KeywordChangeRequest)

Keyword: testingbad, keyword Cadron Arkansas
Type: Exact
Status: Active
id=123562, code=0: RangeError(reason: RangeError.TOO_LOW)(isExemptable: false), trigger=, field=operations[0].operand.criterion.id.id

Keyword: Cadron Arkansas testingbad, keyword
Type: Exact
Status: Active
id=123564, code=0: DistinctError(reason: DistinctError.DUPLICATE_ELEMENT)(isExemptable: false), trigger=, field=operations[1]
id=123564, code=0: RangeError(reason: RangeError.TOO_LOW)(isExemptable: false), trigger=, field=operations[1].operand.criterion.id.id

Keyword: testingbad, keyword in Cadron Arkansas
Type: Exact

Expected Result:

Order should get deployed successfully with out any ERROR related to keywords.