ANI Server failed to run

Unanswered Question
Nov 19th, 2008
User Badges:

ANIServer Failed to run


-----ani.log-----

I= 0value *.*.*.*

I= 1value 6

I= 2value 1

2008/11/19 00:00:08 Thread-2 ani ERROR DBConnection$ConnectionCreator: Failed to establish DB connectivity because: java.sql.SQLException: JZ00L: Login failed. Examine the SQLWarnings chained to this exception for the reason(s).

2008/11/19 00:00:08 main ani ERROR DBConnection: Failed to acquire metadata for connection because of null DB connection

2008/11/19 00:00:08 Thread-3 ani ERROR DBConnection$ConnectionCreator: Failed to establish DB connectivity because: java.sql.SQLException: JZ00L: Login failed. Examine the SQLWarnings chained to this exception for the reason(s).

2008/11/19 00:00:08 main ani ERROR DBConnection: failed to connect to db via db-url jdbc:sybase:Tds:localhost:?SERVICENAME=aniDb

2008/11/19 00:00:08 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------

2008/11/06 15:23:42 Thread-2 ani ERROR DBConnection$ConnectionCreator: Failed to establish DB connectivity because: java.sql.SQLException: JZ00L: Login failed. Examine the SQLWarnings chained to this exception for the reason(s).

2008/11/06 15:23:42 main ani ERROR DBConnection: Failed to acquire metadata for connection because of null DB connection

2008/11/06 15:23:42 Thread-3 ani ERROR DBConnection$ConnectionCreator: Failed to establish DB connectivity because: java.sql.SQLException: JZ00L: Login failed. Examine the SQLWarnings chained to this exception for the reason(s).

2008/11/06 15:23:42 main ani ERROR DBConnection: failed to connect to db via db-url jdbc:sybase:Tds:localhost:?SERVICENAME=aniDb

2008/11/06 15:23:42 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.

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

FATAL ERROR: ANIServer cannot connect to Cisco Process Manager


Please, help me!

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
Joe Clarke Wed, 11/19/2008 - 09:14
User Badges:
  • Cisco Employee,
  • Hall of Fame,

    Founding Member

Is this on Windows or Solaris?

Joe Clarke Wed, 11/19/2008 - 09:35
User Badges:
  • Cisco Employee,
  • Hall of Fame,

    Founding Member

Please post a screenshot of the Services control panel showing the startup parameters for the ANI database.

shevchiksv Wed, 11/19/2008 - 09:41
User Badges:

Where can i find this startup parameters?

Excuse me, but it's my first installation CiscoWorks

Joe Clarke Wed, 11/19/2008 - 09:42
User Badges:
  • Cisco Employee,
  • Hall of Fame,

    Founding Member

In the Services control panel in Windows. This is found under Start > Administrative Tools > Services. The startup parameters are shown in the list of services.

Joe Clarke Wed, 11/19/2008 - 10:02
User Badges:
  • Cisco Employee,
  • Hall of Fame,

    Founding Member

Не работает. First, you will need to set your server's locale to US English. Next, the services are set correctly, so you probably have an issue with your ANI database password. Run the following command:


NMSROOT\bin\perl.exe NMSROOT\bin\dbpasswd.pl dsn=ani


Where NMSROOT is the path into which you installed LMS.

shevchiksv Wed, 11/19/2008 - 10:20
User Badges:

Please enter the new password for database ani: Wed Nov 19 20:17:22 2008>

Please enter the new password again for verification: Wed Nov 19 20:17:26 2008>

INFO: Start changing password for database 'ani'...

Wed Nov 19 20:17:36 2008> ERROR: Failed to Start Database 'ani' because: Could not connect to engine 'aniEng' on 'aniDb' in Bulk mode. Check user id and passwords

Wed Nov 19 20:17:36 2008> ERROR: Failed to connect to database 'ani' with current password.

Wed Nov 19 20:17:36 2008> INFO: Trying the factory password for the database 'ani'.

Wed Nov 19 20:17:36 2008> ERROR: Failed to update new userinfo into database.

Wed Nov 19 20:17:41 2008> ERROR: Failed change password for database 'ani'.

Please see log file C:\PROGRA~1\CSCOpx\log\dbpwdChange.log for details.



Ok, but i have already set locale to English, or maybe better reinstall full english version

Windows?

Joe Clarke Wed, 11/19/2008 - 10:22
User Badges:
  • Cisco Employee,
  • Hall of Fame,

    Founding Member

That is probably not necessary. The ANI database is most likely corrupt. It can be reinitialized to the default with the following command:


NMSROOT\bin\perl.exe NMSROOT\bin\dbRestoreOrig.pl dsn=ani dmprefix=ANI


After that, ANIServer should start.

shevchiksv Thu, 11/20/2008 - 00:10
User Badges:

ANIserver still failed

ani.log

I= 0value *.*.*.*

I= 1value 6

I= 2value 1

2008/11/20 10:06:00 Thread-2 ani ERROR DBConnection$ConnectionCreator: Failed to establish DB connectivity because: com.cisco.nm.cmf.dbservice2.DBException: Invalid database property file. Database name or password are missing for DSN 'ani'.

2008/11/20 10:06:00 main ani ERROR DBConnection: Failed to acquire metadata for connection because of null DB connection

2008/11/20 10:06:00 Thread-3 ani ERROR DBConnection$ConnectionCreator: Failed to establish DB connectivity because: com.cisco.nm.cmf.dbservice2.DBException: Invalid database property file. Database name or password are missing for DSN 'ani'.

2008/11/20 10:06:00 main ani ERROR DBConnection: failed to connect to db via db-url jdbc:sybase:Tds:localhost:?SERVICENAME=aniDb

2008/11/20 10:06:00 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.


Joe Clarke Thu, 11/20/2008 - 08:16
User Badges:
  • Cisco Employee,
  • Hall of Fame,

    Founding Member

Please post the NMSROOT/www/classpath/com/cisco/nm/cmf/dbservice/DBServer.properties file.

Joe Clarke Thu, 11/20/2008 - 08:25
User Badges:
  • Cisco Employee,
  • Hall of Fame,

    Founding Member

This isn't good. The ANI database is not listed in this file. At this point, I suggest uninstalling Campus Manager, then reinstall it.


When you do this, do it as a local Administrator logged in on the server's console. Temporarily disable anti-virus software, and set your TEMP and TMP environment variables to short values (e.g. C:\WINDOWS\TEMP).

shevchiksv Mon, 11/24/2008 - 07:01
User Badges:

Hi. I tried to reinstall full LMS and in process of istalling RME i get message

"Could not open file C:\....CSCOpx\databases\rmeng\rmeng.db"

What does it mean. Really i can't find it. Where is it?

Actions

This Discussion