Monitoring Services 1.3 not working on OpenFire 3.8

Openfire Openfire Support
1

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

2

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.