Openarchive 1.0.5 retrieving chat history

Hello, I’m using openfire as my xmpp server, and I have the openarchive 1.0.5 plugin working that automatically saves the chats on the server… The problem I have is that I can’t find a way to retrieve these messages (from the client app) that are saved on the server , for this

I’m using PSI+ and I send an xml with the format specified in the “retrieving a collection” section of the XEP-0136, but the answer I’m getting from the server is “internal server-error”

So I wanted to know what I’m doing wrong or if that plugin doesn’t support the retrieving action of the chat history from the server to the client???

Thank you

Check your error logs, this plugin still works. Sounds like a setup issue.

Same problem


2011.10.04 10:04:44 [org.jivesoftware.openfire.handler.IQHandler.process(] Internal server error


at com.reucon.openfire.plugin.archive.impl.JdbcPersistenceManager.getConversation(

at com.reucon.openfire.plugin.archive.impl.JdbcPersistenceManager.getConversation(

at com.reucon.openfire.plugin.archive.xep0136.IQRetrieveHandler.retrieve(IQRetriev

at com.reucon.openfire.plugin.archive.xep0136.IQRetrieveHandler.handleIQ(IQRetriev

at com.reucon.openfire.plugin.archive.xep0136.Xep0136Support$1.handleIQ(Xep0136Sup

at org.jivesoftware.openfire.handler.IQHandler.process(

at org.jivesoftware.openfire.IQRouter.handle(

at org.jivesoftware.openfire.IQRouter.route(

at org.jivesoftware.openfire.spi.PacketRouterImpl.route(


at .java:79)



at org.jivesoftware.openfire.nio.ConnectionHandler.messageReceived(ConnectionHandl

at$TailFilter.messageReceived (



at$EntryImpl$1.messageReceive d(

at org.apache.mina.common.IoFilterAdapter.messageReceived(



at$EntryImpl$1.messageReceive d(


at org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(ProtocolCodecF



at$EntryImpl$1.messageReceive d(

at org.apache.mina.filter.executor.ExecutorFilter.processEvent( :239)

at org.apache.mina.filter.executor.ExecutorFilter$

at java.util.concurrent.ThreadPoolExecutor.runWorker(

at java.util.concurrent.ThreadPoolExecutor$



It works for me with MySQL and OfChat. Try a re-index

That issue will not be resolved via a reindex. You are hitting this line with the exception:

pstmt.setLong(3, dateToMillis(start));

Which means you are not providing a start time. I know Vacuum-IM supports 136, but I believe it does not send a start date.

Your IQ should look like:

<iq id="f9a817f"type=“get”>

<list xmlns="urn:xmpp:archive"with="" start=“2011-08-16T01:33:24.592Z”><setxmlns=“”>


Hi Raw,

I am also struglling with the same implementation, not able to retrieve archived chat messages at client hand.

I checked that messages are properly stored on server, but i am unable to prepare the exact code with smack library, to retrieve the chat messages from server.

Please help me at this point, how can i implement this feature with smack library in my android application.



Hi Gabriel,

Can you please share that code with me, which used to get archived messages from xmpp server.



XEP-0136 clearly tells you how to retrieve logged messages from an XMPP client.

Read it again, this time slowly.

If you are looking for source code on how to do it, take a look at OfChat with javascript at ofchat%253Fstate%253Dclosed

You should be able to adapt that to Smack easily


First of all thanks to replying here.

I read XEP-0136 document very briefly, understand its basic concept, and tried too much time to implement it with smack library… but all the times either i am getting NULLPOINTEREXCEPTION or nothing returning as a response, when we are expecting to get archived messages.

I think there is a minor mistake done at my hand, so i am looking for exact code snippt, by which we can get archived message from server with the help of smack library.

I checked the project which you told, is totally build on java script, and i am fully illiterate in java script or any scripting languaging.

So if you can suggest any java language based project, then it will be benificial for me.

Any type of suggestion will definitely help me.