Error log showing errors

Openfire Openfire Support
1

In openfire 3.7.1 administration console when I check out the error log, its showing me a bunch of errors. Is this normal? or have I missed something seriously important while installing/configuring.

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.jav a:953)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:12 22)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatem ent.java:3387)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatemen t.java:3468)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedS tatementWrapper.java:1062)
at sun.reflect.GeneratedMethodAccessor26.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)
at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)
at $java.sql.Wrapper$$EnhancerByProxool$$48851372.executeUpdate()
at org.jivesoftware.openfire.roster.RosterItemProvider.insertGroups(RosterItemProv ider.java:357)
at org.jivesoftware.openfire.roster.RosterItemProvider.updateItem(RosterItemProvid er.java:165)
at org.jivesoftware.openfire.roster.Roster.updateRosterItem(Roster.java:420)
at org.jivesoftware.openfire.handler.PresenceSubscribeHandler.manageSub(PresenceSu bscribeHandler.java:304)
at org.jivesoftware.openfire.handler.PresenceSubscribeHandler.process(PresenceSubs cribeHandler.java:158)
at org.jivesoftware.openfire.PresenceRouter.handle(PresenceRouter.java:189)
at org.jivesoftware.openfire.PresenceRouter.route(PresenceRouter.java:85)
at org.jivesoftware.openfire.spi.PacketRouterImpl.route(PacketRouterImpl.java:84)
at org.jivesoftware.openfire.net.StanzaHandler.processPresence(StanzaHandler.java: 355)
at org.jivesoftware.openfire.net.ClientStanzaHandler.processPresence(ClientStanzaH andler.java:100)
at org.jivesoftware.openfire.net.StanzaHandler.process(StanzaHandler.java:272)
at org.jivesoftware.openfire.net.StanzaHandler.process(StanzaHandler.java:194)
at org.jivesoftware.openfire.nio.ConnectionHandler.messageReceived(ConnectionHandl er.java:169)
at org.apache.mina.common.support.AbstractIoFilterChain$TailFilter.messageReceived (AbstractIoFilterChain.java:570)
at org.apache.mina.common.support.AbstractIoFilterChain.callNextMessageReceived(Ab stractIoFilterChain.java:299)
at org.apache.mina.common.support.AbstractIoFilterChain.access$1100(AbstractIoFilt erChain.java:53)
at org.apache.mina.common.support.AbstractIoFilterChain$EntryImpl$1.messageReceive d(AbstractIoFilterChain.java:648)
at org.apache.mina.common.IoFilterAdapter.messageReceived(IoFilterAdapter.java:80)
at org.apache.mina.common.support.AbstractIoFilterChain.callNextMessageReceived(Ab stractIoFilterChain.java:299)
at org.apache.mina.common.support.AbstractIoFilterChain.access$1100(AbstractIoFilt erChain.java:53)
at org.apache.mina.common.support.AbstractIoFilterChain$EntryImpl$1.messageReceive d(AbstractIoFilterChain.java:648)
at org.apache.mina.filter.codec.support.SimpleProtocolDecoderOutput.flush(SimplePr otocolDecoderOutput.java:58)
at org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(ProtocolCodecF ilter.java:185)
at org.apache.mina.common.support.AbstractIoFilterChain.callNextMessageReceived(Ab stractIoFilterChain.java:299)
at org.apache.mina.common.support.AbstractIoFilterChain.access$1100(AbstractIoFilt erChain.java:53)
at org.apache.mina.common.support.AbstractIoFilterChain$EntryImpl$1.messageReceive d(AbstractIoFilterChain.java:648)
at org.apache.mina.filter.executor.ExecutorFilter.processEvent(ExecutorFilter.java :239)
at org.apache.mina.filter.executor.ExecutorFilter$ProcessEventsRunnable.run(Execut orFilter.java:283)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at org.apache.mina.util.NamePreservingRunnable.run(NamePreservingRunnable.java:51)
at java.lang.Thread.run(Unknown Source)
2011.12.30 10:45:48 org.jivesoftware.util.Log - — Marker inserted by admin at Dec 30, 2011 10:45:48 AM —
2011.12.30 10:45:53 org.jivesoftware.util.Log - — Marker inserted by admin at Dec 30, 2011 10:45:53 AM —
2011.12.30 10:45:54 org.jivesoftware.util.Log - — Marker inserted by admin at Dec 30, 2011 10:45:54 AM —

2

You did not print the error message, only a stack trace. It seems that one user tries to update the roster and this fails.

3

Dear LG,

First of all a very happy new year to you.

Secondly, I am deeply grateful for your response.

I have a ~300kb complete error log file, kindly have a look

http://www.mediafire.com/?6ape72nr8jx5vp8

PS:

I have been trying to implement openfire in my office for quite some time now. The first time I implemented it, was with Candy (Web Chat Client) . I was greatly dissappointed and embarrased as it kicked the users out during an important MUC session in with around 200 users.

I have also used grinder to test Openfire and I have been getting “Invalid SID” error.

It would be really great of you to give me some hint or guidline on how I should go about solving this.

4 
2011.12.12 12:57:01 org.jivesoftware.openfire.roster.RosterItemProvider - ORA-01400: cannot insert NULL into ("UCHAT"."OFROSTERGROUPS"."GROUPNAME")
java.sql.SQLException: ORA-01400: cannot insert NULL into ("UCHAT"."OFROSTERGROUPS"."GROUPNAME")

It seems that one client has a roster with a group name which is not set. Unfortunately the logging is poor and does not help to identify the user. This may be improved in an upcoming version.