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

LMS Database consistency verification tool

Hello all,

I upgraded from LMS 3.1 to 3.2 yesterday. The upgrade went well, but DFM and Campus Manager didn't work afterwards.

After a few searches on the forum, and the help of a great Cisco TAC engineer, we were able to solve the PIDM database inconsistencies that were preventing DFM links from showing up. And Campus Manager needed a kick in the butt to start again it seems.

My PIDM table had many duplicate device ids, some registered to DFM 2.0 (on the previous server) and some registered to DFM 3.1 (current server). So it seems the previous upgrade (from 2.6 to 3.0 and then 3.1) had some bad entries.

My question for the pros is this : is there a tool that can be run against the LMS databases to check for inconsistencies like these ? Duplicate entries, wrong server names, application version, and other nasty stuff ?

My next chore is to move LMS from Windows 2003 to Windows 2008, but before I do that, I'd like to make sure the DB is clean

Thanks!

Alex.

Everyone's tags (4)
1 ACCEPTED SOLUTION

Accepted Solutions
Cisco Employee

Re: LMS Database consistency verification tool

No, there are no tools to verify data consistency.  There is a tool to validate the file structure consistency of the database, but if the database is running, that is typically not an issue.

The PIDM table is the source of quite a few problems, but they are generally easy to sort out.  If you have a good backup of your 2003 server data, I would say you can do the 2008 migration.

1 REPLY
Cisco Employee

Re: LMS Database consistency verification tool

No, there are no tools to verify data consistency.  There is a tool to validate the file structure consistency of the database, but if the database is running, that is typically not an issue.

The PIDM table is the source of quite a few problems, but they are generally easy to sort out.  If you have a good backup of your 2003 server data, I would say you can do the 2008 migration.

616
Views
0
Helpful
1
Replies
CreatePlease to create content