OpenFire 3.5.0 Primary key violation on jiveRoster


The SQL Server is MSSQL 2005

Trying to add a new roster, I get the following error on warn.log:

va.sql.SQLException: Violation of PRIMARY KEY constraint ‘jiveRoster_pk’. Cannot insert duplicate key in object ‘dbo.jiveRoster’

Is there a way to fix this may be updating the field used to know what is the last rosterID (I do not know how is inserted a new roster)?

It worked fine till last week.


I found this article, may be it will help.