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

Attention: The Community will be in read-only mode on 12/14/2017 from 12:00 am pacific to 11:30 am.

During this time you will only be able to see content. Other interactions such as posting, replying to questions, or marking content as helpful will be disabled for few hours.

We apologize for the inconvenience while we perform important updates to the Community.

New Member

Reset QPM 4.x database

Hi all,

I'm looking for a way to reset the database on my QPM install without having to reinstall QPM and patch it up again.  The reason for this is we've ended up with a number of ghost nested policy entries that are selectable in policy creation but do not show up in the nested policy table (provisioning > pre-configuration > nested policies), and some policies cannot be deleted (after selecting them and pressing delete they are still in the policy list!).

TIA.

Everyone's tags (1)
1 ACCEPTED SOLUTION

Accepted Solutions
Blue

Re: Reset QPM 4.x database

Alright, I'd still strongly suggest completing a backup from QPM's Common Services first before you go ahead. That being said, I'm guessing you could get it done with the following commands on the appropriate OS:

Solaris:

/etc/init.d/dmgtd stop

/opt/CSCOpx/bin/dbRestoreOrig.pl dsn=qpm dmprefix=???    <-- see note below

Windows:

net stop crmdmgtd

NMSROOT\bin\perl.exe NMSROOT\bin\dbRestoreOrig.pl dsn=qpm dmprefix=???    <-- see note below

Now the ??? part is what I'm not sure about. My bet would be either "QPM" or "Qpm", but I can't find any definitive answer about it. So YMMV, No Warranty Expressed or Implied, etc., etc.

3 REPLIES
Blue

Re: Reset QPM 4.x database

Are there things that you don't want to lose?

New Member

Re: Reset QPM 4.x database

No, don't need to keep anything.

Blue

Re: Reset QPM 4.x database

Alright, I'd still strongly suggest completing a backup from QPM's Common Services first before you go ahead. That being said, I'm guessing you could get it done with the following commands on the appropriate OS:

Solaris:

/etc/init.d/dmgtd stop

/opt/CSCOpx/bin/dbRestoreOrig.pl dsn=qpm dmprefix=???    <-- see note below

Windows:

net stop crmdmgtd

NMSROOT\bin\perl.exe NMSROOT\bin\dbRestoreOrig.pl dsn=qpm dmprefix=???    <-- see note below

Now the ??? part is what I'm not sure about. My bet would be either "QPM" or "Qpm", but I can't find any definitive answer about it. So YMMV, No Warranty Expressed or Implied, etc., etc.

351
Views
0
Helpful
3
Replies
CreatePlease to create content