syslog purge problem

dragec · ‎01-08-2008

Hi

my syslog purge jobs are not running any more. Here is the info from the log

[ Tue Nov 27 01:00:20 CET 2007 ],ERROR,[main],SA0027: Error accessing DB

java.sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connection refused: connect

at com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(ErrorMessage.java:536)

at com.sybase.jdbc2.jdbc.ErrorMessage.raiseErrorCheckDead(ErrorMessage.java:840)

at com.sybase.jdbc2.tds.Tds.handleIOE(Tds.java:3479)

at com.sybase.jdbc2.tds.Tds.login(Tds.java:421)

at com.sybase.jdbc2.jdbc.SybConnection.tryLogin(SybConnection.java:247)

at com.sybase.jdbc2.jdbc.SybConnection.regularConnect(SybConnection.java:223)

at com.sybase.jdbc2.jdbc.SybConnection.<init>(SybConnection.java:198)

at com.sybase.jdbc2.jdbc.SybConnection.<init>(SybConnection.java:132)

at com.sybase.jdbc2.jdbc.SybDriver.connect(SybDriver.java:179)

at java.sql.DriverManager.getConnection(DriverManager.java:512)

at java.sql.DriverManager.getConnection(DriverManager.java:171)

at com.cisco.nm.cmf.dbservice2.DBConnection.<init>(DBConnection.java:221)

at com.cisco.nm.cmf.dbservice2.DBConnection.<init>(DBConnection.java:106)

at com.cisco.nm.cmf.dbservice2.DBUtil.getDBConnection(DBUtil.java:28)

at com.cisco.nm.rmeng.sa.db.RmeSaDbHandler.connectToDB(RmeSaDbHandler.java:189)

at com.cisco.nm.rmeng.sa.db.RmeSaDbHandler.connectWithRetry(RmeSaDbHandler.java:433)

at com.cisco.nm.rmeng.sa.db.RmeSaDbHandler.<init>(RmeSaDbHandler.java:133)

at com.cisco.nm.rmeng.sa.db.RmeSaPurgeDbHandler.<init>(RmeSaPurgeDbHandler.java:125)

at com.cisco.nm.rmeng.sa.RmeSaPurgeHandler.purge(RmeSaPurgeHandler.java:266)

at com.cisco.nm.rmeng.sa.RmeSaPurgeHandler.main(RmeSaPurgeHandler.java:1060)

any ideas how could I debug this

Joe Clarke · ‎01-09-2008

Looks like the RME database is not running. Please post the output of pdshow as well as the list of contents under NMSROOT\databases\rmeng.

dragec · ‎01-09-2008

here it is

Joe Clarke · ‎01-09-2008

This looks okay, at least today. The log message, however, is from late November. Do you have more recent logs pertaining to this job?

dragec · ‎01-09-2008

no ... strange .... purge job is trying to run every night and it is finished with message that there is nothing to purge and is referenced to log file in wich I've found this error msg. I've changed this log file name so will se tommorow if anything will be there

Martin Ermel · ‎01-09-2008

what is your purge job policy?

Do you see any entries in the syslog that should be purged but are still there?

I have seen this message confusing some customers after purging all syslog messages for some reason. because after that purge (purge records older than 30 days)no syslog messages matched the purge criteria.

- the message just said there was nothing to purge - and that was correct.... 31 days later the message was gone...