CiscoWorks 3.2 ANI database engine failed to start

[marijanac]

CiscoWorks ANI database engine failed to start ...

We suppose we have found following bug. This is output from one discussion on Netpro https://supportforums.cisco.com/message/665869#665869 .

CSCsb52873

ANI Server fails to start

This problem occurs when you:

Start ANI Server, the server is up for sometime and shuts down with RC as -2 and Info as ANI Server failed to load from the database.

Workaround:

Stop the Daemon Manager. Re-initialize ANI database and start the daemons.

Enter the following command to reinitialize ANI database:

/opt/CSCOpx/bin/perl /opt/CSCOpx/bin/dbRestoreOrig.pl dsn=ani dmprefix=ANI

You should not be using this interface to start any CiscoWorks services.  Your statup parameters look okay.  Either your ANI database is corrupt, or your transaction log is corrupt.

First, set the CiscoWorks Daemon Manager service to Manual, and reboot the server.  When the server reboots, delete NMSROOT\databases\ani\ani.log if it exists.  Then run:

NMSROOT\objects\db\win32\dbsrv9 -f NMSROOT\databases\ani\ani.db

After that, set the Daemon Manager service back to Automatic, and reboot again.  See if the ANI database engine starts.  If not, you will need to reinitialize your ANI database with the command:

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

We have done reinitializing:

1. Delete NMSROOT\databases\ani\ani.log

NMSROOT\objects\db\win32\dbsrv10 -f NMSROOT\databases\ani\ani.db

After that done

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

After reinitializing ANI database took 1 hour to start, output of  pdshow command was

INFO: Daemon manager is processing other tasks in the queue. Please try again later.

In RME there is another problem:

JRM Service could be down. Check whether JRM services are running .

Tried to resolve by reinitializingRME

NMSROOT\bin\perl.exe NMSROOT\bin\dbRestoreOrig.pl dsn=rmeng dmprefix=RME

But did not help.

We are attaching some log files...

Thanks in advance...

[Joe Clarke]

Post the output of the pdshow command.

[marijanac]

You can find output of this command in attachment.

Just to mention that CiscoWorks LMS is installed on Windows 2008 Enterprise SP2. Everything was working well for 3 three days. The problem occured on Friday. A lot of Windows Updates are installed on Thursday night.I am sending you also screenshots of installed updates.

[Joe Clarke]

You are most likely seeing a port conflict between LMS and the Windows RM service.  You can either shutdown the Windows Remote Management service, then restart Daemon Manager, or do the following:

* Shutdown Daemon Manager

* Remove ctmregistry* from NMSROOT/MDC/tomcat/webapps/rme/WEB-INF/lib.

* With Windows Remote Management still running, restart Daemon Manager, and EssentialsDM should skip tcp/47001 because it is already in use.

[aaramire]

When you mention ctmregistry*, we have a ctm_static_registry.txt...is this the same and should we procede with it's removal?

thanks.

[Joe Clarke]

No, the ctm_static_registry.txt must NOT be removed.

[marijanac]

We did first procedure that you suggested and it seems we solved a problem. All services are up 6-7 min after restart.

Thank you Joe!