powered by Jive Software

Monitoring Services 1.3 not working on OpenFire 3.8

Hi all,

I’m running the OpenFire 3.8 on Windows Server 2012 with SQL Server 2012 Express, before the upgrade to version 3.8 the Monitoring Plugin was working fine, but after I upgraded I didn’t realize that Monitoring Services wasnt working until today…

Looking into the logs I found the following error

2013.02.26 14:59:31 org.jivesoftware.openfire.archive.Conversation - Violation of PRIMARY KEY constraint ‘ofConversation_pk’. Cannot insert duplicate key in object ‘dbo.ofConversation’. The duplicate key value is (64856).

java.sql.SQLException: Violation of PRIMARY KEY constraint ‘ofConversation_pk’. Cannot insert duplicate key in object ‘dbo.ofConversation’. The duplicate key value is (64856).

There is any patch to fix this or I did something wrong on the update ?

Thanks,

Best Regards,

Leonardo Lima

There is a Monitoring 1.3.1beta2 plugin posted somewhere on the forum. Or you can just grab the current nightly build which has it already - Probably easier just to do that.