LMS 2.6 User Tracking has too many end hosts

Answered Question
May 30th, 2007
User Badges:

I just updated from 2.5.1 to 2.6 and the User Tracking data in Campus manager reads 43,310 end hosts. How can I delete the data and grab new information? There are around 4,000 to 5,000 end hosts total on the network.

Correct Answer by Joe Clarke about 9 years 12 months ago

Since this is an upgrade, you will need to reinitialize your ANI database before the fix for all of the known UT duplicate entry bugs can take effect. After you perform the reinit, do another Data Collection followed by a UT major acquisition, these entries should not come back.


To reinitialize the ANI database, run the following:


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

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (1 ratings)
Loading.
Correct Answer
Joe Clarke Wed, 05/30/2007 - 15:27
User Badges:
  • Cisco Employee,
  • Hall of Fame,

    Founding Member

Since this is an upgrade, you will need to reinitialize your ANI database before the fix for all of the known UT duplicate entry bugs can take effect. After you perform the reinit, do another Data Collection followed by a UT major acquisition, these entries should not come back.


To reinitialize the ANI database, run the following:


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

chris43290 Wed, 05/30/2007 - 15:42
User Badges:

Can you be more specific on how to run this command? like what program?

Joe Clarke Wed, 05/30/2007 - 15:48
User Badges:
  • Cisco Employee,
  • Hall of Fame,

    Founding Member

I specified the command line:


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


NMSROOT is the path into which you installed CiscoWorks (e.g. C:\PROGRA~1\CSCOpx on Windows and /opt/CSCOpx on Solaris). If you are running this command on Windows, you will need to replace each '/' with '\'.


Just run that command in a shell, and it will walk you through the procedure.

chris43290 Wed, 05/30/2007 - 16:10
User Badges:

I think this worked. Waiting another 20-30min for the server to re-instalize

Actions

This Discussion