cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
677
Views
0
Helpful
3
Replies

LMS 2.6, how to re-initialize DFM 2.0 database?

andrea.meconi
Level 2
Level 2

DFM 2.0.12 is working with some errors.
I want to re-initialize the database and I'm looking for a step-by-step guide.
Regards.

Andrea

1 Accepted Solution

Accepted Solutions

Joel Monge
Cisco Employee
Cisco Employee

1. Login to the server as local Administrator. Then go to a DOS prompt and enter:

net stop crmdmgtd

2. Go to C:\program files\CSCOpx\bin and issue:

perl dbRestoreOrig.pl dsn=dfmInv dmprefix=INV npwd=cisco

perl dbRestoreOrig.pl dsn=dfmFh dmprefix=FH npwd=cisco

perl dbRestoreOrig.pl dsn=dfmEpm dmprefix=EPM npwd=cisco

*Note: The above assumes you use "cisco" as the database password. Change it to whatever you like.

3. Go to NMSROOT\CSCOpx\objects\smarts\local\repos\icf\.

4. Delete the files DFM.rps, DFM1.rps (DFM1 only in LMS 3.0 or above):

del DFM.rps

del DFM1.rps

5. Type:

net start crmdmgtd

  Check the below DOC which contains similar steps and details about database troubleshooting:

https://supportforums.cisco.com/docs/DOC-8796

View solution in original post

3 Replies 3

Joel Monge
Cisco Employee
Cisco Employee

1. Login to the server as local Administrator. Then go to a DOS prompt and enter:

net stop crmdmgtd

2. Go to C:\program files\CSCOpx\bin and issue:

perl dbRestoreOrig.pl dsn=dfmInv dmprefix=INV npwd=cisco

perl dbRestoreOrig.pl dsn=dfmFh dmprefix=FH npwd=cisco

perl dbRestoreOrig.pl dsn=dfmEpm dmprefix=EPM npwd=cisco

*Note: The above assumes you use "cisco" as the database password. Change it to whatever you like.

3. Go to NMSROOT\CSCOpx\objects\smarts\local\repos\icf\.

4. Delete the files DFM.rps, DFM1.rps (DFM1 only in LMS 3.0 or above):

del DFM.rps

del DFM1.rps

5. Type:

net start crmdmgtd

  Check the below DOC which contains similar steps and details about database troubleshooting:

https://supportforums.cisco.com/docs/DOC-8796

Small clarification I omitted, NMSROOT stands for your LMS installation path which by default is C:\Program Files\

CSCOpx. If it is different just change the patch accordingly.

Many thanks for your help Joel!

Regards.

Andrea

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: