Troubleshooting
Problem
What can cause a "unique constraint" violation? Master Data Engine Log: ERROR ODBC [23000] [InitiateSystems][ODBC Oracle Wire Protocol driver][Oracle]ORA-00001: unique constraint (INITIATE.MPI_MEMHEAD0) violated (DBError=1)
Resolving The Problem
The unique constraint violation error occurs when there are 2 or more MEMPUTs occurring simultaneously. It is possible that two threads are attempting to create the same record. Check if your source system is sending duplicate MEMPUTs (via API or other method) and make the appropriate changes to avoid this.
[{"Product":{"code":"SSLVY3","label":"Initiate Master Data Service"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"Version Independent","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Historical Number
1262
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21471910