How to rebuild the XPS tree?

book

Article ID: 50281

calendar_today

Updated On:

Products

CA Single Sign On Secure Proxy Server (SiteMinder) AXIOMATICS POLICY SERVER CA Single Sign On SOA Security Manager (SiteMinder) CA Single Sign-On

Issue/Introduction

Description:

You maybe in a situation where your XPS repository is corrupted and you are not able to start your policy server.

The policy server is complaining with the following error messages:

[CA.XPS:EDIT0050][ERROR] Object #xxx has parent #yyy, which does not exist.

Even by running the XPSSweeper or trying to remove directly objects from the database does not solve the issue and you need to recreate the comple XPS tree.

Solution:

  1. Delete and recreate XPS Schemas by running the appropriate SQL/LDIF script under the <policy_server_home>\xps\db folder.

  2. Import XPS objects by executing

    • XPSDDInstall SmObjects.xdd

    • XPSDDInstall EPMObjects.xdd

    • XPSDDInstall SecCat.xdd

    • XPSDDInstall FssSmObjects.xdd

    • XPSDDInstall SoaSmObjects.xdd.

  3. Run xpssweeper.exe

  4. Start SM Policy Server service

  5. Remove WAMUI trusted host using XPSExplorer

  6. Delete directory $ADMINUI$/server/default/data/derby and
    $ADMINUI$/server/default/data/siteminder

  7. Run xpsregclient siteminder:<password> -adminui-setup

  8. Start SM WAMUI service

Environment

Release:
Component: SMPLC