Unique key violation

[Sai Easwer Tej]

Hi All,

I am getting two errors while creating a new record.

Errors:

1. Invalid insert

2. "Unique key violation detected by database ((conn=number) Duplicate entry 'Field value entered by me' for key 'field'

Note: The field is unique false in dictionary and I'm not using current.update.() in the business rules.

How can I fix these errors?  I'm not sure because of which script I'm getting error.

Thanks in advance

[Daniel Oderbolz · Accepted solution]

Hi Sai

Check if there is a database index (sys_index) on the table in question with a UNIQUE constraint (unique_index=true).
This is enforced on the lowest possible level (the database) and is not reflected in the dictionary.
Best
Daniel

[Daniel Oderbolz]

Hi @kalpesh9 
Thats a good hint, but typically does not lead to a UNIQUE CONSTRAINT violation. The only unique index that is always present on a table is on sys_id, normally number is not unique.