OF 3.3.0, Eval enterprise 3.3.0 - no chat auditing?

Steve_Davis · April 18, 2007, 9:13am

Hi,

As title explains we’‘ve just upgrade from WF3.2.0 to OF3.3.0 and I’'m evaluating the enterprise plugin again.

All seems to have installed without any obvious problem but whenever I search the chat logs I’'m getting messages from last sept which is when we last tested the plugin.

It’'s recording that fact that coversations are taking place and the number of connections and packets etc.

Have I done something worng? How can I fix this?

Steve

Steve_Davis · April 19, 2007, 12:35pm

anyone?

Steve_Davis · April 20, 2007, 9:44am

How can I manually fix the database?, it seems the DB didn’'t upgrade properly to the new version of enterprise.

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

2007.04.19 17:23:53 [org.jivesoftware.database.SequenceManager.getNextBlock(SequenceManager.java:23 9)

] WARNING: failed to obtain next ID block due to thread contention. Trying again…

2007.04.20 10:33:40 [org.jivesoftware.database.SchemaManager.checkSchema(SchemaManager.java:251)

]

java.sql.SQLException: [SQLServer 2000 Driver for JDBC][SQLServer]Column names in each table must be unique. Column name ‘‘room’’ in table ‘‘entConversation’’ is specified more than once.

at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)

at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)

at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)

at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)

at com.microsoft.jdbc.sqlserver.tds.TDSExecuteRequest.processReplyToken(Unknown Source)

at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)

at com.microsoft.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)

at com.microsoft.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)

at com.microsoft.jdbc.base.BaseStatement.postImplExecute(Unknown Source)

at com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown Source)

at com.microsoft.jdbc.base.BaseStatement.executeInternal(Unknown Source)

at com.microsoft.jdbc.base.BaseStatement.execute(Unknown Source)

at org.jivesoftware.database.SchemaManager.executeSQLScript(SchemaManager.java:348 )

at org.jivesoftware.database.SchemaManager.checkSchema(SchemaManager.java:248)

at org.jivesoftware.database.SchemaManager.checkPluginSchema(SchemaManager.java:11 1)

at org.jivesoftware.openfire.container.PluginManager.loadPlugin(PluginManager.java :378)

at org.jivesoftware.openfire.container.PluginManager.access$200(PluginManager.java :46)

at org.jivesoftware.openfire.container.PluginManager$PluginMonitor.run(PluginManag er.java:916)

at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

at java.util.concurrent.FutureTask$Sync.innerRunAndReset(Unknown Source)

at java.util.concurrent.FutureTask.runAndReset(Unknown Source)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101 (Unknown Source)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodi c(Unknown Source)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknow n Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

2007.04.20 10:33:40 [org.jivesoftware.openfire.container.PluginManager.loadPlugin(PluginManager.jav a:380)

] enterprise - Database update failed. Please manually upgrade your database.

2007.04.20 10:33:42 [com.jivesoftware.openfire.enterprise.archive.ArchiveIndexer.indexConversations (ArchiveIndexer.java:510)

]

java.sql.SQLException: [SQLServer 2000 Driver for JDBC]ResultSet can not re-read row data for column 2.

at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)

at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)

at com.microsoft.jdbc.base.BaseResultSet.validateColumnIndex(Unknown Source)

at com.microsoft.jdbc.base.BaseResultSet.getLong(Unknown Source)

at com.jivesoftware.openfire.enterprise.archive.ArchiveIndexer.indexConversations( ArchiveIndexer.java:486)

at com.jivesoftware.openfire.enterprise.archive.ArchiveIndexer.access$300(ArchiveI ndexer.java:57)

at com.jivesoftware.openfire.enterprise.archive.ArchiveIndexer$4.run(ArchiveIndexe r.java:362)

at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)

at java.util.concurrent.FutureTask.run(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

2007.04.20 10:33:43 [com.jivesoftware.openfire.enterprise.archive.ArchiveIndexer.indexConversations (ArchiveIndexer.java:510)