01-08-2008 11:07 PM
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
01-09-2008 08:44 AM
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.
01-09-2008 09:09 AM
01-09-2008 09:16 AM
This looks okay, at least today. The log message, however, is from late November. Do you have more recent logs pertaining to this job?
01-09-2008 09:53 AM
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
01-09-2008 10:30 AM
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...
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: