I upgraded from Enterprise 3.3.0 to 3.3.1 and got the following message in the error.log:
2007.06.02 07:30:55 org.jivesoftware.database.SchemaManager.checkSchema(SchemaManager.java:251)
java.sql.SQLException: ORA-00932: inconsistent datatypes: expected NUMBER got LONG
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:582)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1986)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1144)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2152)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2035)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:28 76)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:945)
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(Executors.java:417)
at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:280)
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:135)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101 (ScheduledThreadPoolExecutor.java:65)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodi c(ScheduledThreadPoolExecutor.java:142)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Schedu ledThreadPoolExecutor.java:166)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java: 650)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
at java.lang.Thread.run(Thread.java:595)
2007.06.02 07:30:55 org.jivesoftware.openfire.container.PluginManager.loadPlugin(PluginManager.java: 380) enterprise - Database update failed. Please manually upgrade your database.
This is on Solaris 10 using ojdbc14.jar.
Anything I can do to fix this?
Thanks!