Droping config store tables manually

  • 7003907
  • 17-Jul-2009
  • 11-Jul-2012

Environment

BSM server with config store using an external database, Oracle, MS SQL or Sybase. This TID does not cover ODB based config stores.

Situation

You need to drop the three config store table and the Configuration Explorer (moscfg) is not available to re-initialize the tables. Due to multiple foreign constraints a direct drop of the tables will not work.

Resolution

Run these commands directly against the config store database. They will work with Oracle, MS SQL and Sybase.

ALTER TABLE CFG_ATTRIBUTE DROP CONSTRAINT "CFG_ATTR_ENTRY_KEY";
ALTER TABLE CFG_ENTRY DROP CONSTRAINT "CFG_ALGO_KEY";
ALTER TABLE CFG_ENTRY DROP CONSTRAINT "CFG_REL_LEFT_KEY";
ALTER TABLE CFG_ENTRY DROP CONSTRAINT "CFG_REL_RIGHT_KEY";
ALTER TABLE CFG_ENTRY DROP CONSTRAINT "CFG_CN_KEY";
ALTER TABLE CFG_ENTRY DROP CONSTRAINT "CFG_W_KEY";
ALTER TABLE CFG_ENTRY DROP CONSTRAINT "CFG_ALGODIS_KEY";
ALTER TABLE CFG_ENTRY DROP CONSTRAINT "CFG_ENTRY_PAR_KEY";
DROP TABLE CFG_ENTRY;
DROP TABLE CFG_ATTRIBUTE;
DROP TABLE CFG_ATOM;