Error Messagejava.sql.BatchUpdateException: (conn=284652) Duplicate entry 'incident-assignment_group

[Nitish16]

what I am trying is in Incident table which is the child table of Task table, in assignment_group column trying to Override reference qualifier and adding the active=true^EQ
so that assignment_group  will reflect only active groups and that change should happen in the Incident table only which is child table, but it is throwing error as above

[Brad Bowman · Accepted solution]

What does your new reference qualifier look like?

To clarify, are you changing this on the dictionary entry - so on the task table:

Or on a new or existing dictionary override for the incident table?

[Nitish16]

This problem was solved by understanding the Dictionary Override functionality. There was already an entry for the Incident table with an existing override condition (which I didn't fully understand and didn't remove). When I tried to add another override for the Incident table with a new condition (active=true^EQ), it caused a duplicate entry error. To fix this, I located the pre-existing Incident table entry in the Dictionary Override and simply added my new condition (active=true^EQ) to the existing one, leaving the original condition as it was. This resolved the issue."

Easy Summary:

Basically, the system was saying, "You already told me how to handle the 'assignment group' field in Incidents once, you can't tell me again in a separate rule!" So, instead of trying to create a whole new rule, I found the old rule and just added my new instruction to it. Now it works!

[Robert H · Accepted solution]

@Nitish16 Yep, that's correct. You can't have more than one Dictionary Override for the same table and field. I wish I could mark your message as the correct answer.

[Nitish16]

Thank you Robert for your time