LMS 2.6 User Tracking has too many end hosts

Answered Question
May 30th, 2007

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.

I have this problem too.
0 votes
Correct Answer by Joe Clarke about 9 years 7 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

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

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

Joe Clarke Wed, 05/30/2007 - 15:48

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

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

Actions

This Discussion