Upgrade error from 2.5.1 to 2.6.1

Openfire Openfire Support
1

OS: WInXP

DB: ORACLE 9.2 under Linux

I can’'t start Wildfire server vecause of the following error:

2006.04.12 12:16:33 [org.jivesoftware.database.DbConnectionManager.setConnectionProvider(DbConnecti onManager.java:445)

] Database upgrade failed. Please manually upgrade your database.

java.sql.SQLException: ORA-00911: invalid character

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:579)

at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1894)

at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1094)

at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2132)

at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2015)

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:28 77)

at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:925)

at org.jivesoftware.database.DbConnectionManager.upgradeDatabase(DbConnectionManag er.java:883)

at org.jivesoftware.database.DbConnectionManager.setConnectionProvider(DbConnectio nManager.java:442)

at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager .java:85)

at org.jivesoftware.util.JiveProperties.loadProperties(JiveProperties.java:269)

at org.jivesoftware.util.JiveProperties.init(JiveProperties.java:67)

at org.jivesoftware.util.JiveProperties.(XMPPServer.java:142)

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

at java.lang.reflect.Constructor.newInstance(Unknown Source)

at java.lang.Class.newInstance0(Unknown Source)

at java.lang.Class.newInstance(Unknown Source)

at org.jivesoftware.wildfire.starter.ServerStarter.start(ServerStarter.java:88)

at org.jivesoftware.wildfire.starter.ServerStarter.main(ServerStarter.java:49)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at com.exe4j.runtime.LauncherEngine.launch(Unknown Source)

at com.exe4j.runtime.WinLauncher.main(Unknown Source)

2

Hi,

please check the jiveVersion table to make sure that you are using version 6. I’'m quite sure you do, if not please upgrade it manually to version 6.

Manually upgrading to v7 (@Gato: is there an official guide somewhere?):

Shutdown Wifi.

See wildfire\resources\database\upgrade\7\wildfire_oracle.sql for the statements which are executed. Maybe some of the tables were already created. You should be able to execute the script using @wildfire_oracle.sql within sqlplus.

If you see this error again please try to identify which create table causes the trouble - I have currently no Oracle db to test.

After successfully executing it may be necessary (I did never update the db manually) to run[code]

INSERT INTO jiveVersion (name, version) VALUES (’‘wildfire’’, 7);

commit;[/code]

Startup Wifi - hopefully without errors this time.

LG