1 Reply Latest reply on May 19, 2017 11:23 AM by Daryl Herzmann

    Archive index rebuild failed error Openfire version 4.1.3

    Madhuri Jadhav

      I installed openfire 4.1.3 on windows...

      OpenArchive plugin of version 1.0.6-SNAPSHOT...

      everything else works fine... but i am not able to fetch history of chat Conversations (iq list- i am working on ios app).

      sql server used Microsoft SQL Server 12.00.2000 (in error log it seems to be error is with some database files)..

      And on archiving settings i keep getting this error "Archive index rebuild failed".

      Rebuild index option didn't work for me...

      does anyone have any idea how to solve this...

       

      Same Scenario happens even if i use monitoring plugin only instead of using archive plugin.

       

      at org.apache.mina.filter.executor.OrderedThreadPoolExecutor$Worker.runTasks(Order edThreadPoolExecutor.java:761) 
          at org.apache.mina.filter.executor.OrderedThreadPoolExecutor$Worker.run(OrderedThr eadPoolExecutor.java:703) 
          at java.lang.Thread.run(Unknown Source) 
         2017.04.28 11:14:52 org.jivesoftware.util.Log - Error selecting conversations
         java.sql.SQLException: The column 'startDate' was specified multiple times for 'ofConversation'. 
          at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372) 
          at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988) 
          at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421) 
          at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:671) 
          at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:505)  
          at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatem ent.java:1029) 
          at sun.reflect.GeneratedMethodAccessor5.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.PreparedStatement$$EnhancerByProxool$$75299267.executeQuery(<generate d>) 
          at com.reucon.openfire.plugin.archive.impl.JdbcPersistenceManager.findConversation s(JdbcPersistenceManager.java:311) 
          at com.reucon.openfire.plugin.archive.xep0136.IQListHandler.list(IQListHandler.jav a:52) 
          at com.reucon.openfire.plugin.archive.xep0136.IQListHandler.handleIQ(IQListHandler .java:37) 
          at com.reucon.openfire.plugin.archive.xep.AbstractXepSupport$1.handleIQ(AbstractXe pSupport.java:47) 
         at org.jivesoftware.openfire.handler.IQHandler.process(IQHandler.java:66) 
         at org.jivesoftware.openfire.IQRouter.handle(IQRouter.java:372) 
         at org.jivesoftware.openfire.IQRouter.route(IQRouter.java:115) 
         at org.jivesoftware.openfire.spi.PacketRouterImpl.route(PacketRouterImpl.java:78) 
         at org.jivesoftware.openfire.net.StanzaHandler.processIQ(StanzaHandler.java:341) 
         at org.jivesoftware.openfire.net.ClientStanzaHandler.processIQ(ClientStanzaHandler .java:99) 
         at org.jivesoftware.openfire.net.StanzaHandler.process(StanzaHandler.java:306) 
         at org.jivesoftware.openfire.net.StanzaHandler.process(StanzaHandler.java:198)
         at org.jivesoftware.openfire.nio.ConnectionHandler.messageReceived(ConnectionHandl er.java:181)
          at org.apache.mina.core.filterchain.DefaultIoFilterChain$TailFilter.messageReceive d(DefaultIoFilterChain.java:690) 
          at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(D efaultIoFilterChain.java:417) 
          at org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilt erChain.java:47) 
          at org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceiv ed(DefaultIoFilterChain.java:765) 
          at org.apache.mina.core.filterchain.IoFilterAdapter.messageReceived(IoFilterAdapte r.java:109) 
          at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(D efaultIoFilterChain.java:417) 
          at org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilt erChain.java:47) 
          at org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceiv ed(DefaultIoFilterChain.java:765) 
          at org.apache.mina.filter.codec.ProtocolCodecFilter$ProtocolDecoderOutputImpl.flus h(ProtocolCodecFilter.java:407) 
          at org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(ProtocolCodecF ilter.java:236) 
          at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(D efaultIoFilterChain.java:417) 
          at org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilt erChain.java:47) 
          at org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceiv ed(DefaultIoFilterChain.java:765) 
          at org.apache.mina.core.filterchain.IoFilterEvent.fire(IoFilterEvent.java:74) 
          at org.apache.mina.core.session.IoEvent.run(IoEvent.java:63) 
          at org.apache.mina.filter.executor.OrderedThreadPoolExecutor$Worker.runTask(Ordere dThreadPoolExecutor.java:769) 
          at org.apache.mina.filter.executor.OrderedThreadPoolExecutor$Worker.runTasks(Order edThreadPoolExecutor.java:761) 
          at org.apache.mina.filter.executor.OrderedThreadPoolExecutor$Worker.run(OrderedThr eadPoolExecutor.java:703) 
          at java.lang.Thread.run(Unknown Source)

       

      Message was edited by: Madhuri Jadhav