Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. If you'd prefer to explore, try our test area to get started. And see here for current known issues.

New Member

Ani Server Failure Log

Hi,

I have been trying to troubleshoot our Ciscoworks LMS 2.5 server.

I am unable to get the ANIServer process to start properly. I have followed the TAC notes about reinitialising the database with no luck. The ANI.log contains the following:

I= 0value *.*.*.*

I= 1value 6

I= 2value 1

2006/07/01 23:56:03 Thread-2 ani ERROR DBConnection$ConnectionCreator: Failed to establish DB connectivity because: java.sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connection refused: connect

2006/07/01 23:56:03 main ani ERROR DBConnection: Failed to acquire metadata for connection because of null DB connection

2006/07/01 23:56:04 Thread-3 ani ERROR DBConnection$ConnectionCreator: Failed to establish DB connectivity because: java.sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connection refused: connect

2006/07/01 23:56:04 main ani ERROR DBConnection: failed to connect to db via db-url jdbc:sybase:Tds:localhost:?SERVICENAME=aniDb

2006/07/01 23:56:04 main ani ERROR AniMain: failed to connect to db via db-url jdbc:sybase:Tds:localhost:?SERVICENAME=aniDb

ANI Server cannot connect to the database. Please stop and restart the System. If this does not work, please contact technical support.

Does anyone have any suggestions

28 REPLIES
New Member

Re: Ani Server Failure Log

The server doesnt seem to be listening on that port

when doing a netstat. I presume it should be listed and either listening or established.

Miron

Cisco Employee

Re: Ani Server Failure Log

Find out which TCP ports the dbsrv9 process associated with ANIDbEngine is listening on. It should only be listening on one TCP port, but be bound on two UDP ports (2638 and 43443).

Cisco Employee

Re: Ani Server Failure Log

Did you receive any error messages when trying to run the reinit procedure?

Did you run ./reinitdb.pl -restore?

New Member

Re: Ani Server Failure Log

Hi,

Yes this is the message I receive when attempting the command. I have checked and the daemon manager

process is running.

C:\Program Files\CSCOpx\campus\bin>reinitdb.pl -restore

This will erase all data from the database. Are you sure [y/n] ?y

CampusOGSServer is running. Stopping CampusOGSServer...done

START reinitdb...

Dropping database tables Wbu* ...

ani:::::Wbu

ERROR DropTable: Failed to establish DB connectivity because: java.sql.SQLExcept

ion: JZ006: Caught IOException: java.net.ConnectException: Connection refused: c

onnect

ERROR DropTable: Daemon Manager could be down.Please start the Daemon and try ag

ain..

Reinitdb terminated with errors.

Regards

Miron

Cisco Employee

Re: Ani Server Failure Log

what version of windows is LMS 2.5 installed on? Also, was this an upgrade from LMS 2.1 or 2.2 or a new install?

If you try restarting the daemon manager do you get an errors?

New Member

Re: Ani Server Failure Log

Windows version 2000.

Upgrade from 2.2. It has been running for about 6 months on the new version.

I can stop and start the daemon manager without errors.

Miron

New Member

Re: Ani Server Failure Log

Still no luck, think ill blow away this server.

Would be good if they actually brought out a version

of CiscoWorks software that was cutting edge.

Cisco Employee

Re: Ani Server Failure Log

Before trying a reinstall you might want to try doing a reset casuser and possibly a dbPasswd for ANI to see if it clears up these errors.

New Member

Re: Ani Server Failure Log

nope no luck, when i have 10 hours available ill

Ill reinstall the server.

Thanks for the help mate.

Cisco Employee

Re: Ani Server Failure Log

May not be that bad. Shutdown dmgtd. Then go to C:\PROGRA~1\CSCOpx\databases\ani. Do you see an ani.log file there? If you do, remove it, then run:

C:\PROGRA~1\CSCOpx\objects\db\win32\dbsrv9 -f ani.db

That should complete quickly. When it does, try starting dmgtd, and see if ANIServer can properly connect to the database.

New Member

Re: Ani Server Failure Log

Hi,

I followed your instructions but unfortunately still no luck.

C:\Program Files\CSCOpx\campus\bin>pdshow ANIServer

Process= ANIServer

State = Running with busy flag set

Pid = 9512

RC = 0

Signo = 0

Start = 07/04/2006 10:10:42 AM

Stop = Not applicable

Core = Not applicable

Info = ANIServer started.

C:\Program Files\CSCOpx\campus\bin>pdshow ANIServer

Process= ANIServer

State = Running with busy flag set

Pid = 9512

RC = 0

Signo = 0

Start = 07/04/2006 10:10:42 AM

Stop = Not applicable

Core = Not applicable

Info = ANI Server cannot connect to the database. Please stop and rest

art the System. If this does not work, please contact technical support.

This is after I have restarted the system.

Miron

Cisco Employee

Re: Ani Server Failure Log

What is the status of ANIDbEngine? What does ANIDbEngine.log look like? What do ANIServer.log and ani.log look like now?

New Member

Re: Ani Server Failure Log

Hi,

C:\Program Files\CSCOpx\bin>pdshow ANIDbEngine

Process= ANIDbEngine

State = Program started - No mgt msgs received

Pid = 8468

RC = 0

Signo = 0

Start = 07/04/2006 10:03:37 AM

Stop = Not applicable

Core = Not applicable

Info = Server started by admin request

ANI Log

************************************************

I= 0value *.*.*.*

I= 1value 6

I= 2value 1

2006/07/04 10:10:49 Thread-2 ani ERROR DBConnection$ConnectionCreator: Failed to establish DB connectivity because: java.sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connection refused: connect

2006/07/04 10:10:49 main ani ERROR DBConnection: Failed to acquire metadata for connection because of null DB connection

2006/07/04 10:10:50 Thread-3 ani ERROR DBConnection$ConnectionCreator: Failed to establish DB connectivity because: java.sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connection refused: connect

2006/07/04 10:10:50 main ani ERROR DBConnection: failed to connect to db via db-url jdbc:sybase:Tds:localhost:?SERVICENAME=aniDb

2006/07/04 10:10:50 main ani ERROR AniMain: failed to connect to db via db-url jdbc:sybase:Tds:localhost:?SERVICENAME=aniDb

ANI Server cannot connect to the database. Please stop and restart the System. If this does not work, please contact technical support.

ANIServer Log

***************************************************

Informational: ANIServer starting Cisco Process Manager communication thread

messages will be logged to file: C:/PROGRA~1/CSCOpx/log\ani.log

MESSAGE AniMain: Properties will be read from C:\PROGRA~1\CSCOpx\campus\etc\cwsi\ANIServer.properties

Informational: ANIServer starting Cisco Process Manager communication thread

messages will be logged to file: C:/PROGRA~1/CSCOpx/log\ani.log

The ANIDbEngine log is empty.

Regards

Miron

Cisco Employee

Re: Ani Server Failure Log

Check the TCP/IP network settings for the ANI datasource under Administrative Tools > Data Sources (ODBC). The server port should be tcp/43443. If it is, check the value of DBConnection.dataSourceUrl.ani in C:\PROGRA~1\CSCOpx\www\classpath\com\cisco\nm\cmf\dbservice\DBServer.properties. It should be:

jdbc:sybase:Tds:localhost:43443?SERVICENAME=aniDb

It sounds like those ports may not be in agreement.

New Member

Re: Ani Server Failure Log

I can confirm that in the ANI datasource is set as follows

HOST=localhost;DOBROADCAST=NO;ServerPort=43443

The extract below is from the DBServer.properties

The final line seems to be commented should I add that to the file and add :43443 after the px or at the top of the file next to the port reference

?

# "DBConnection.dataSourceUrl" should be [jdbc:sybase:Tds::].

# For example, if the dbos50 (open gateway server) is runnning on host "cawhite-ss20" and

# is listening to port 9999, then the datasource URL would be:

# [jdbc:sybase:Tds:cawhite-ss20:9999]

#

DBConnection.debugLevel=0

DBConnection.autoCommit=true

#DBConnection.jdbcDriver=sun.jdbc.odbc.JdbcOdbcDriver

#DBConnection.dataSourceUrl=jdbc:odbc:px

New Member

Re: Ani Server Failure Log

Apologies,

I saw what where you meant.

Ill let you know if that works.

New Member

Re: Ani Server Failure Log

Hmmmm,

The following is the contents of the file.

# (C) Copyright 1998 - 2002 Cisco Systems, Inc.

# All Rights Reserved

#

# The "DBServer.port" property specifies the port that the

# database service's module listens to for socket based

# requests.

DBServer.corbaName=dbservice

DBServer.debugLevel=0

DBServer.port=33333

DBServer.host=localhost

# Database services socket support debug levels.

DBServerSocket.debugLevel=0

DBServerSocketSelect.debugLevel=0

# The "DBSessionIPC.pingPeriod" is used by the RMI database client to

# periodically send a "I'm Alive" message so that the database

# session reaper will not deallocate the connection being used

# by the client.

#

# Ping period is set to 10800000 ms (3 hours) and the time out

# has been set to 21600000 (6 hours).

DBSession.debugLevel=0

DBSessionIPC.pingPeriod=10800000

DBSessionIPC.timeOut=21600000

# The database session reaper will check for timed out

# connections every "DBSessionReaper.sleepPeriod" milliseconds.

DBSessionReaper.debugLevel=0

DBSessionReaper.sleepPeriod=5000

DBConnectionPool.debugLevel=0

DBConnectionPool.poolSize=10

DBConnectionPool.softLimit=true

DBConnectionPool.maxConnections=30

# Driver can use two either the JDBC-ODBC Bridge driver

# or Sybase's jConnect JDBC driver

# . In order to use jConnect, you need to

# do the following:

#

# 1) Install the sybase CTLib libraries (for TDS protocol support).

# 2) Install the SQLAnywhere Open Gateway Server (dbos50)

# 3) Run the open gateway server (dbos50 listens on a specific port).

#

# NOTE: setAutoCommit(), commit() and rollback() database operations do not work

# with jConnect. Essentially, auto commit is turned on and can't be

# turned off thru jConnect without raising an exception.

#

# JDBC-ODBC Bridge Driver:

# ------------------------

# "DBConnection.dataSourceUrl" should be [jdbc:odbc:]. In

# CRM 1.x, the datasource name is "px", therefore the datasource URL is:

# [jdbc:odbc:px]

#

# jConnect Driver:

# ----------------

# "DBConnection.dataSourceUrl" should be [jdbc:sybase:Tds::].

# For example, if the dbos50 (open gateway server) is runnning on host "cawhite-ss20" and

# is listening to port 9999, then the datasource URL would be:

# [jdbc:sybase:Tds:cawhite-ss20:43443]

#

DBConnection.debugLevel=0

DBConnection.autoCommit=true

#DBConnection.jdbcDriver=sun.jdbc.odbc.JdbcOdbcDriver

#DBConnection.dataSourceUrl=jdbc:odbc:px

# Corba client properties.

corba.DBClient.corbaNoImplSleepPeriod=5000

corba.DBClient.corbaNoImplMaxAttempts=15

# jconnect tuning parameters.

DBConnection.PACKETSIZE=4096

DBConnection.REPEAT_READ=false

# STREAM_CACHE_SIZE limits only jconnect memory requirement; no performance chg

# DBConnection.STREAM_CACHE_SIZE=1000000

Any comments??

Cisco Employee

Re: Ani Server Failure Log

This looks like the orig version of this file (found in NMSROOT\www\classpath\com\cisco\nm\cmf\dbservice\orig. If this is the only copy of the file you have, and you do not have a good backup, you will have to reinstall CiscoWorks from scratch. All of your databases are missing.

New Member

Re: Ani Server Failure Log

Hi,

This the copy of the file in folder:

Sorry I didnt notice it before.

NMSROOT\www\classpath\com\cisco\nm\cmf\dbservice

Cisco Employee

Re: Ani Server Failure Log

This looks good. ANI clients should be trying to connect to port 43443. If this is Windows 2003, you can use netstat -a -b -o to track down if the PID for ANIDbEngine is properly listening on TCP port 43443. If you're using Windows 2000, you'd have to use a tool such as TCPView from http://www.sysinternals.com to do this.

New Member

Re: Ani Server Failure Log

Hi,

Using TCPView port 43443 is not listed at all.

New Member

Re: Ani Server Failure Log

dbsrv9.exe:4744 TCP eagle:43455 localhost:26158 ESTABLISHED

dbsrv9.exe:4744 TCP eagle:43455 localhost:26186 ESTABLISHED

dbsrv9.exe:4744 TCP eagle:43455 localhost:26213 ESTABLISHED

dbsrv9.exe:4744 TCP eagle:43455 localhost:26216 ESTABLISHED

dbsrv9.exe:4744 TCP eagle:43455 localhost:26243 ESTABLISHED

dbsrv9.exe:4744 TCP eagle:43455 localhost:26248 ESTABLISHED

dbsrv9.exe:4744 TCP eagle:43455 localhost:26254 ESTABLISHED

dbsrv9.exe:4744 TCP eagle:43455 localhost:26326 ESTABLISHED

dbsrv9.exe:4744 TCP eagle:43455 localhost:26538 ESTABLISHED

dbsrv9.exe:4744 TCP eagle:43455 localhost:26653 ESTABLISHED

dbsrv9.exe:4744 TCP eagle:43455 localhost:26993 ESTABLISHED

dbsrv9.exe:5408 TCP eagle:43447 localhost:29007 ESTABLISHED

dbsrv9.exe:5408 TCP eagle:43447 localhost:29017 ESTABLISHED

dbsrv9.exe:5408 TCP eagle:43447 localhost:29600 ESTABLISHED

dbsrv9.exe:5408 TCP eagle:43447 localhost:30165 ESTABLISHED

dbsrv9.exe:5408 TCP eagle:43447 localhost:30166 ESTABLISHED

dbsrv9.exe:5408 TCP eagle:43447 localhost:30167 ESTABLISHED

dbsrv9.exe:5556 TCP eagle:43446 localhost:26025 ESTABLISHED

dbsrv9.exe:5556 TCP eagle:43446 localhost:26165 ESTABLISHED

dbsrv9.exe:5556 TCP eagle:43446 localhost:26185 ESTABLISHED

dbsrv9.exe:5556 TCP eagle:43446 localhost:26619 ESTABLISHED

dbsrv9.exe:5556 TCP eagle:43446 localhost:26634 ESTABLISHED

dbsrv9.exe:5556 TCP eagle:43446 localhost:26636 ESTABLISHED

dbsrv9.exe:5556 TCP eagle:43446 localhost:26639 ESTABLISHED

dbsrv9.exe:5556 TCP eagle:43446 localhost:26640 ESTABLISHED

dbsrv9.exe:5556 TCP eagle:43446 localhost:26928 ESTABLISHED

dbsrv9.exe:5788 TCP eagle:43441 localhost:26101 ESTABLISHED

dbsrv9.exe:5788 TCP eagle:43441 localhost:26152 ESTABLISHED

dbsrv9.exe:5788 TCP eagle:43441 localhost:26178 ESTABLISHED

dbsrv9.exe:5788 TCP eagle:43441 localhost:26194 ESTABLISHED

dbsrv9.exe:5788 TCP eagle:43441 localhost:26203 ESTABLISHED

dbsrv9.exe:5788 TCP eagle:43441 localhost:26302 ESTABLISHED

dbsrv9.exe:5788 TCP eagle:43441 localhost:26456 ESTABLISHED

dbsrv9.exe:5788 TCP eagle:43441 localhost:26468 ESTABLISHED

dbsrv9.exe:5788 TCP eagle:43441 localhost:26479 ESTABLISHED

dbsrv9.exe:5788 TCP eagle:43441 localhost:26488 ESTABLISHED

dbsrv9.exe:5788 TCP eagle:43441 localhost:26779 ESTABLISHED

dbsrv9.exe:5788 TCP eagle:43441 localhost:26781 ESTABLISHED

dbsrv9.exe:5788 TCP eagle:43441 localhost:27143 ESTABLISHED

Cisco Employee

Re: Ani Server Failure Log

Looks my last reply got dropped. I had asked to see if this process is listening on any TCP ports. The above output only shows dbsrv9 processes and their established connections.

Additionally, please check your CiscoWorks services to make sure no one has altered the startup parameters (i.e. changed services from Manual to Automatic). See this thread for a guide: http://forums.cisco.com/eforum/servlet/NetProf?page=netprof&forum=Network%20Infrastructure&topic=Network%20Management&CommCmd=MB%3Fcmd%3Ddisplay_location%26location%3D.1ddb858d

Finally, if the services check out, try this. Set CiscoWorks Daemon Management to Manual, then reboot. When the server comes back, run the following as a local Administrator:

C:\PROGRA~1\CSCOpx\bin\perl C:\PROGRA~1\CSCOpx\bin\dbRestoreOrig.pl dsn=ani dmprefix=ANI

That should complete successfully. When it does, set CiscoWorks Daemon Management back to Automatic, then reboot again. ANIServer should hopefully be able to connect to the database now.

New Member

Re: Ani Server Failure Log

List of Process is attached.

New Member

Re: Ani Server Failure Log

Hi,

According to the link above I should have:

CiscoWorks ANI database engine : Manual

However that process isnt listed instead i have

CiscoWorks CMF data Engine : Manual

Is this the same process?

Cisco Employee

Re: Ani Server Failure Log

No. They are two different things. If you do not have the ANI Database engine service registered, you should probably try uninstalling Campus Manager, then reinstalling it.

New Member

Re: Ani Server Failure Log

Hi,

I have uninstalled and reinstalled campus manager and have the process functioning correctly again.

Thanks for all your help

Miron

New Member

Re: Ani Server Failure Log

Response when runing the command.

"C:\PROGRA~1\CSCOpx\bin\dbRestoreOrig.pl dsn=ani dmprefix=ANI

"

Usage:

Format1: dbRestoreOrig.pl dsn=odbc_datasource dmprefix=dmprefixname

Format2: dbRestoreOrig.pl dsn=odbc_datasource dmprefix=dmprefixname npwd=newpass

word

441
Views
10
Helpful
28
Replies