Unique Key violation detected by database while trying to insert the record in the Enhancement table - Support and Troubleshooting

Unique Key violation detected by database while trying to insert the record in the Enhancement table Issue  Symptoms Unique Key violation detected by database while trying to insert the record in the Enhancement table

Release Kingston and earlier

Cause The issue is caused due to the business rule that runs on the Approval table

Resolution There is a business rule that runs on the Approval table, which is creating a new record on the "Internal Systems Request" (custom table) table (when approval records are added from the workflow) and therefore the "sys_id" that was allocated to the "Enhancement request" record gets assigned to the "Internal Systems Request" record. Therefore when we try to insert the "Enhancement Request" record with the same sys_id (which has been assigned to Internal systems request record), we get the "Unique key violation" error.