03-29-2010 04:46 PM
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.
Solved! Go to Solution.
03-29-2010 06:47 PM
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.
03-29-2010 06:17 PM
Are there things that you don't want to lose?
03-29-2010 06:19 PM
No, don't need to keep anything.
03-29-2010 06:47 PM
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.
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: