OpenFire 3.5.0 Primary key violation on jiveRoster

Openfire Openfire Support
1

Hello,

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.

Thanks.

2

I found this article, may be it will help.

http://www.jivesoftware.com/community/docs/DOC-1422