Primary key violation exception in the MIVR logs while trying to insert a historical record to the Database table

From DocWiki

Jump to: navigation, search

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

Rating: 0.0/5 (0 votes cast)

Personal tools