Hi All,

For some time now, our IS log4j.log as well as MWS logs are being filled with the folowing error. We have run the server in trace mode as well but it is not quite evident what exactly is causing this issue. Can anyone please give some clue or hint on how to debug this issue or what might cause this issue?

63095 [Thread-24] DEBUG com.webMethods.jms.db.DbJMSClient - Obtained timestamp 1369619555000 for jms client ad030alnxsyd.genworth.net.mws.library.7964820820916963328
63100 [Thread-24] WARN com.webMethods.jms.db.DbJMSClient - [SoftwareAG][Oracle JDBC Driver]Column index 2 is out of range.
java.sql.SQLSyntaxErrorException: [SoftwareAG][Oracle JDBC Driver]Column index 2 is out of range.
at com.wm.dd.jdbc.oraclebase.BaseExceptions40.createAppropriateSQLExceptionInstance(Unknown Source)
at com.wm.dd.jdbc.oraclebase.BaseExceptions40.createSQLException(Unknown Source)
at com.wm.dd.jdbc.oraclebase.BaseExceptions.createException(Unknown Source)
at com.wm.dd.jdbc.oraclebase.BaseExceptions.getException(Unknown Source)
at com.wm.dd.jdbc.oraclebase.BaseResultSet.throwBadOrdinal(Unknown Source)
at com.wm.dd.jdbc.oraclebase.BaseResultSet.getString(Unknown Source)
at com.webMethods.jms.db.impl.mssql.PurgeInactiveSubscriptions.executeUpdate(PurgeInactiveSubscriptions.java:34)
at com.webMethods.portal.service.sql.core.BaseSqlWorker.executeUpdateProc(BaseSqlWorker.java:887)
at com.webMethods.jms.db.DbJMSClient$ConnectionReaperThread.run(DbJMSClient.java:87)

Thanks and Regards,
Ninad Patil

Hi Ninad Patil,

Can you mention the environment Version with the IS and MWS fix details.

Regards,
Deepa Mourougayane

Hi,

The IS and MWS versions are 7.1.3. The fixes are as follows:

IS_7.1.3_Core_Fix25
PRT_7.1.2_Fix9
JMS_6.1_Fix16
JDBC_6-5_Fix25
MWS_7.1.3_Fix17

Thanks and REgards,
Ninad Patil

Hi Ninad Patil,

This issue is going to be fixed in MWS_7.1.3_Fix18 and the Fix is targeted to release on 07 June 2013. However, MWS_7.1.3_Fix18 is only available for customers who have purchased End of Maintenance Extension or who are entitled to it by other means.

You may raise a Support Incident to check further on this.

Regards,
Deepa Mourougayane

Thanks Deepa,

We will wait till then and try and update the post.

Thanks and Regards,
Ninad Patil