powered by Jive Software

Setting up Monitoring Service plugin - failed to Rebuild Index


#1

I installed Monitoring Service plugin and set settings described above. When I hit “Rebuild Index” it shows an error. Error log has the following, “org.jivesoftware.openfire.reporting.stats.RrdSqlBackend - Error while accessing information in database: java.sql.SQLException: Invalid object name ‘ofRRDs’.” No “ofMessageArchive” table was created. Please help.

We currently use OpenFire 4.1.7. Database is SQL Server.


#2

I added dbOwner role to a SQL user used by OpenFire. Uninstalled and reinstalled Monitoring Service plugin. Restarted OpenFire. Still - no ofRRDs table and no ofMessageArchive table and errors in a log:

at org.jivesoftware.openfire.reporting.stats.StatsEngine$SampleTask.run(StatsEngine.java:359)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
2018.12.07 20:23:39 org.jivesoftware.openfire.reporting.stats.RrdSqlBackend - Error while accessing information in database: java.sql.SQLException: Invalid object name ‘ofRRDs’.
2018.12.07 20:23:39 org.jivesoftware.openfire.reporting.stats.StatsEngine - Error sampling for statistic muc_incoming
java.io.FileNotFoundException: Could not open muc_traffic [non existent]
at org.jrobin.core.RrdDb.<init>(RrdDb.java:227)
at org.jrobin.core.RrdDb.<init>(RrdDb.java:203)
at org.jivesoftware.openfire.reporting.stats.StatsEngine$SampleTask.run(StatsEngine.java:359)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
2018.12.07 20:23:39 org.jivesoftware.openfire.reporting.stats.RrdSqlBackend - Error while accessing information in database: java.sql.SQLException: Invalid object name ‘ofRRDs’.
2018.12.07 20:23:39 org.jivesoftware.openfire.reporting.stats.StatsEngine - Error sampling for statistic muc_rooms
java.io.FileNotFoundException: Could not open muc_rooms [non existent]
at org.jrobin.core.RrdDb.<init>(RrdDb.java:227)
at org.jrobin.core.RrdDb.<init>(RrdDb.java:203)
at org.jivesoftware.openfire.reporting.stats.StatsEngine$SampleTask.run(StatsEngine.java:359)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
2018.12.07 20:23:39 org.jivesoftware.openfire.reporting.stats.RrdSqlBackend - Error while accessing information in database: java.sql.SQLException: Invalid object name ‘ofRRDs’.
2018.12.07 20:23:39 org.jivesoftware.openfire.reporting.stats.StatsEngine - Error sampling for statistic server_sessions
java.io.FileNotFoundException: Could not open server_sessions [non existent]
at org.jrobin.core.RrdDb.<init>(RrdDb.java:227)
at org.jrobin.core.RrdDb.<init>(RrdDb.java:203)
at org.jivesoftware.openfire.reporting.stats.StatsEngine$SampleTask.run(StatsEngine.java:359)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
2018.12.07 20:23:39 org.jivesoftware.openfire.reporting.stats.RrdSqlBackend - Error while accessing information in database: java.sql.SQLException: Invalid object name ‘ofRRDs’.
2018.12.07 20:23:39 org.jivesoftware.openfire.reporting.stats.StatsEngine - Error sampling for statistic muc_users
java.io.FileNotFoundException: Could not open muc_users [non existent]
at org.jrobin.core.RrdDb.<init>(RrdDb.java:227)
at org.jrobin.core.RrdDb.<init>(RrdDb.java:203)
at org.jivesoftware.openfire.reporting.stats.StatsEngine$SampleTask.run(StatsEngine.java:359)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)