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

Nitish16
Tera Contributor

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

2 ACCEPTED SOLUTIONS

Brad Bowman
Kilo Patron
Kilo Patron

What does your new reference qualifier look like?

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

BradBowman_0-1743791241256.png

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

BradBowman_1-1743791294342.png

 

View solution in original post

@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.

View solution in original post

7 REPLIES 7

Brad Bowman
Kilo Patron
Kilo Patron

What does your new reference qualifier look like?

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

BradBowman_0-1743791241256.png

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

BradBowman_1-1743791294342.png

 

existing dictionary override for the incident table. 

Thank you so much Brad for your help 

You are welcome!