I have upgrade openfire 3.5.1. previous version what we had is 3.3.3. we are using db2 database. while upgrade I'm getting the following errors
1. DB upgrade problem,
2008.05.06 05:01:12 org.jivesoftware.database.SchemaManager.checkSchema(SchemaManager.java:252) com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -104, SQLSTATE: 42601, SQLERRMC: );AR(10) NOT NULL,;<table_element> at com.ibm.db2.jcc.b.zc.e(zc.java:1606) at com.ibm.db2.jcc.b.zc.b(zc.java:1174) at com.ibm.db2.jcc.a.db.i(db.java:234) at com.ibm.db2.jcc.a.db.b(db.java:50) at com.ibm.db2.jcc.a.r.b(r.java:36) at com.ibm.db2.jcc.a.sb.f(sb.java:141) at com.ibm.db2.jcc.b.zc.m(zc.java:1171) at com.ibm.db2.jcc.b.zc.a(zc.java:1890) at com.ibm.db2.jcc.b.zc.e(zc.java:775) at com.ibm.db2.jcc.b.zc.execute(zc.java:759) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:64) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.ja va:43) at java.lang.reflect.Method.invoke(Method.java:615) at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100) at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57) at com.ibm.db2.jcc.b.cd$$EnhancerByProxool$$1d022119.execute(<generated>) at org.jivesoftware.database.SchemaManager.executeSQLScript(SchemaManager.java:349 ) at org.jivesoftware.database.SchemaManager.checkSchema(SchemaManager.java:249) at org.jivesoftware.database.SchemaManager.checkOpenfireSchema(SchemaManager.java: 69) at org.jivesoftware.database.DbConnectionManager.setConnectionProvider(DbConnectio nManager.java:488) at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager .java:78) at org.jivesoftware.util.JiveProperties.loadProperties(JiveProperties.java:330) at org.jivesoftware.util.JiveProperties.init(JiveProperties.java:72) at org.jivesoftware.util.JiveProperties$JivePropertyHolder.<clinit>(JiveProp erties.java:39) at java.lang.J9VMInternals.initializeImpl(Native Method) at java.lang.J9VMInternals.initialize(J9VMInternals.java:148) at org.jivesoftware.util.JiveProperties.getInstance(JiveProperties.java:51) at org.jivesoftware.util.JiveGlobals.getProperty(JiveGlobals.java:525) at org.jivesoftware.openfire.XMPPServer.initialize(XMPPServer.java:333) at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:447) at org.jivesoftware.openfire.XMPPServer.<init>(XMPPServer.java:161) at java.lang.Class.newInstanceImpl(Native Method) at java.lang.Class.newInstance(Class.java:1265) at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:106) at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:51) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:64) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.ja va:43) at java.lang.reflect.Method.invoke(Method.java:615) at com.exe4j.runtime.LauncherEngine.launch(Unknown Source) at com.install4j.runtime.Launcher.main(Unknown Source) 2008.05.06 05:01:16 org.jivesoftware.openfire.muc.spi.MUCPersistenceManager.loadRoomsFromDB(MUCPersi stenceManager.java:571) com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -206, SQLSTATE: 42703, SQLERRMC: ROOMPASSWORD at com.ibm.db2.jcc.b.zc.e(zc.java:1606) at com.ibm.db2.jcc.b.zc.a(zc.java:1206) at com.ibm.db2.jcc.a.db.h(db.java:149) at com.ibm.db2.jcc.a.db.a(db.java:43) at com.ibm.db2.jcc.a.r.a(r.java:30) at com.ibm.db2.jcc.a.sb.g(sb.java:152) at com.ibm.db2.jcc.b.zc.n(zc.java:1186) at com.ibm.db2.jcc.b.ad.db(ad.java:1761) at com.ibm.db2.jcc.b.ad.d(ad.java:2203) at com.ibm.db2.jcc.b.ad.U(ad.java:489) at com.ibm.db2.jcc.b.ad.executeQuery(ad.java:472)
2. I tried to connect the openfire server with wechat client that time I'm getting all the WorkGroup information on list(Index.jsp), if try to triger chat from any one of the work group, Spark could receive the chat request, after acepting the chat request nothing is happenfing, If look at the log I got the below error message
2008.05.06 05:13:16 Possible server misconfiguration. Received error presence:<presence from="pgikv51438@conference.darwin.dfw.ibm.com/tl-eu" to="tl-eu@workg roup.darwin.dfw.ibm.com/tl-eu" type="error"><x xmlns="http://jabber.org/protocol/muc"/><error code="404" type="wait"><recipient-unavailable xmlns="urn:ietf:p arams:xml:ns:xmpp-stanzas"/></error></presence> 2008.05.06 05:16:01 Connection closed on Error stream:error (system-shutdown) at org.jivesoftware.smack.PacketReader.parsePackets(PacketReader.java:357) at org.jivesoftware.smack.PacketReader.access$000(PacketReader.java:45) at org.jivesoftware.smack.PacketReader$1.run(PacketReader.java:77)
Please some one help me out to solve this problem