Reset QPM 4.x database

Answered Question
Mar 29th, 2010
User Badges:

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.

Correct Answer by yjdabear about 7 years 1 month ago

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.

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (1 ratings)
Loading.
yjdabear Mon, 03/29/2010 - 18:17
User Badges:
  • Gold, 750 points or more

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

Correct Answer
yjdabear Mon, 03/29/2010 - 18:47
User Badges:
  • Gold, 750 points or more

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.

Actions

This Discussion

Related Content