I have problem in upgrading openfire 3.3.3 to 3.5.1?

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)

  1. 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