Primary key violation exception in the MIVR logs while trying to insert a historical record to the Database table
From DocWiki
Primary key violation exception in the MIVR logs while trying to insert a historical record to the Database table
| Problem Summary | Primary key violation exception in the MIVR logs while trying to insert a historical record to the Database table. |
|---|---|
| Error Message | EXCEPTION:java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK_ContactCallDetail'. Cannot insert duplicate key in object 'ContactCallDetail' |
| Possible Cause | Mainly primary key violation happens when trying to insert a record into the database table, which is already present in it. This is due to collision of SessionIDs. |
| Recommended Action | open registry by using regedit command and open the following path. HKEY_LOCAL_MACHINE->SOFTWARE->Cisco Systems, Inc.>CRS>Properties->application.MIVR.properties.
Edit the entry com.cisco.session.id.block and give a large 3 digit value. This key value is used as the seed for generating the session ids. Close regedit and restart the node manager. Do the same operation in both the nodes if it is an HA setup. |
| Release | Release 7.0, Release 5.0 |
| Associated CDETS # | None |
