Project

General

Profile

Please help me regarding this patch https://projects.tigase.org/issues/1922

Pradeep Mathan
Added over 4 years ago

I applied the new patch suggested in https://projects.tigase.org/issues/1922, I build the message-archiving component and deployed it in the jars file of Tigase installation, I am running Tigase 5.2.0. I get a NoClassDefFoundError tigase/db/Repository. I took the latest tigase-server jar file but the error persists, basically it means the class is not there. I am not being able to track the right version of tigase-server which has the class. Can you please help me regarding this.


Replies (6)

Added by Wojciech Kapcia TigaseTeam over 4 years ago

The best and easiest option will be to grab latest nightly release, e.g.: http://build.tigase.org/nightlies/dists/2014-11-07/

Added by Pradeep Mathan over 4 years ago

We are using the Tigase build to go into production mode. We need a stable release. We had experimented with nightly builds some time back and on startup they were throwing exceptions.

Added by Pradeep Mathan over 4 years ago

I used http://build.tigase.org/nightlies/dists/2014-11-07/ replaced Tigase-Server and other jars specified to the jars directory of nightly dist. I build the message archiving component from git clone https://repository.tigase.org/git/message-archiving.git , I ran the 30 again, I am getting the following error. Can you please help me with this.

Caused by: java.sql.SQLException: 'date' is not a recognized built-in function n

ame.

    at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.j

ava:372)

    at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2894)

    at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2334)

    at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:643)

    at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement

.java:506)

    at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPrep

aredStatement.java:979)

    at tigase.archive.db.JDBCMessageArchiveRepository.getCollectionsCount(JD

BCMessageArchiveRepository.java:676)

    at tigase.archive.db.JDBCMessageArchiveRepository.getCollections(JDBCMes

sageArchiveRepository.java:471)

    at tigase.archive.MessageArchiveComponent.listCollections(MessageArchive

Component.java:307)

    at tigase.archive.MessageArchiveComponent.processActionPacket(MessageArc

hiveComponent.java:257)

    at tigase.archive.MessageArchiveComponent.processPacket(MessageArchiveCo

mponent.java:111)

    at tigase.server.AbstractMessageReceiver$QueueListener.run(AbstractMessa

geReceiver.java:1490)

Added by Wojciech Kapcia TigaseTeam over 4 years ago

This issue is related to #2442 and it will be fixed under it.

Added by Pradeep Mathan over 4 years ago

Tested it today, the error persists.

StackTrace

MessageArchiveComponent.listColl

ections() SEVERE: Error listing collections

tigase.db.TigaseDBException: Cound not retrieve collections

    at tigase.archive.db.JDBCMessageArchiveRepository.getCollections(JDBCMes

sageArchiveRepository.java:560)

    at tigase.archive.MessageArchiveComponent.listCollections(MessageArchive

Component.java:307)

    at tigase.archive.MessageArchiveComponent.processActionPacket(MessageArc

hiveComponent.java:257)

    at tigase.archive.MessageArchiveComponent.processPacket(MessageArchiveCo

mponent.java:111)

    at tigase.server.AbstractMessageReceiver$QueueListener.run(AbstractMessa

geReceiver.java:1490)

Caused by: java.sql.SQLException: 'date' is not a recognized built-in function n

ame.

    at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.j

ava:372)

    at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2894)

    at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2334)

    at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:643)

    at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement

.java:506)

    at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPrep

aredStatement.java:979)

    at tigase.archive.db.JDBCMessageArchiveRepository.getCollectionsCount(JD

BCMessageArchiveRepository.java:740)

    at tigase.archive.db.JDBCMessageArchiveRepository.getCollections(JDBCMes

sageArchiveRepository.java:527)

    at tigase.archive.MessageArchiveComponent.listCollections(MessageArchive

Component.java:307)

    at tigase.archive.MessageArchiveComponent.processActionPacket(MessageArc

hiveComponent.java:257)

    at tigase.archive.MessageArchiveComponent.processPacket(MessageArchiveCo

mponent.java:111)

    at tigase.server.AbstractMessageReceiver$QueueListener.run(AbstractMessa

geReceiver.java:1490)

Added by Pradeep Mathan over 4 years ago

AS this bug was supposed to be fixed with 2442, I tested it and I got the following exception, Can you please help me regarding this.

2014-12-02 12:01:08.166 [in_0-message-archive] MessageArchiveComponent.listColl

ections() SEVERE: Error listing collections

tigase.db.TigaseDBException: Cound not retrieve collections

    at tigase.archive.db.JDBCMessageArchiveRepository.getCollections(JDBCMes

sageArchiveRepository.java:586)

    at tigase.archive.MessageArchiveComponent.listCollections(MessageArchive

Component.java:307)

    at tigase.archive.MessageArchiveComponent.processActionPacket(MessageArc

hiveComponent.java:257)

    at tigase.archive.MessageArchiveComponent.processPacket(MessageArchiveCo

mponent.java:111)

    at tigase.server.AbstractMessageReceiver$QueueListener.run(AbstractMessa

geReceiver.java:1490)

Caused by: java.sql.SQLException: 'date' is not a recognized built-in function n

ame.

    at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.j

ava:372)

    at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2894)

    at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2334)

    at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:643)

    at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement

.java:506)

    at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPrep

aredStatement.java:979)

    at tigase.archive.db.JDBCMessageArchiveRepository.getCollectionsCount(JD

BCMessageArchiveRepository.java:762)

    at tigase.archive.db.JDBCMessageArchiveRepository.getCollections(JDBCMes

sageArchiveRepository.java:553)

    at tigase.archive.MessageArchiveComponent.listCollections(MessageArchive

Component.java:307)

    at tigase.archive.MessageArchiveComponent.processActionPacket(MessageArc

hiveComponent.java:257)

    at tigase.archive.MessageArchiveComponent.processPacket(MessageArchiveCo

mponent.java:111)

    at tigase.server.AbstractMessageReceiver$QueueListener.run(AbstractMessa

geReceiver.java:1490)

    (1-6/6)