How to add any missing Indexes/Procedures/Foreign Keys/Triggers back to the CA Service Desk Manager (SDM) MDB Oracle database?
Article ID: 49216
CA IT Asset ManagerCA Software Asset Manager (CA SAM)ASSET PORTFOLIO MGMT- SERVERSUPPORT AUTOMATION- SERVERCA Service Desk Manager - Unified Self ServiceCA Service Desk ManagerCA Service Management - Asset Portfolio ManagementCA Service Management - Service Desk Manager
Consider a scenario where you have setup a development CA SDM environment with a copy of the Production MDB. During this process, the database triggers did not get carried over. This document explains the steps to take to add them back into the MDB.
Access the file system of the MDB database server
Take the back-up of the existing MDB database using normal DB backup procedures
On the MDB server's file system, rename the existing directory "MDB" in the CA Shared Components directory to something else.
If the MDB Server is a Unix/Linux based system, then the default CA SharedComponents directory is either /opt/CA/SC or /opt/CA/SharedComponents. Rename the directory /opt/CA/SC/Mdb or /opt/CA/SharedComponents/Mdb to /opt/CA/SC/Mdb_ORIGINAL or /opt/CA/SharedComponents/Mdb_ORIGINAL
If the MDB Server is a Windows based system, then the default CA SharedComponents directory is C:\Program Files (x86)\CA\SC or C:\Program Files (x86)\CA\SharedComponents. Rename the C:\Program Files (x86)\CA\SC\Mdb or C:\Program Files (x86)\CA\SharedComponents\Mdb to C:\Program Files (x86)\CA\SC\Mdb_Original or C:\Program Files (x86)\CA\SharedComponents\Mdb_Original
Mount the CA SDM DVD1 install media which contains the MDB setup program
Run the CA SDM setup.exe or setup.sh program to launch the CA SDM Installer GUI
Select the Product Installs tab
Select the CA MDB option in the Product Installs tab (its option number 1 in the list)
Fill out the appropriate details about your MDB and let the CA MDB installer finish
Review the latest CA MDB install log file to verify that any missing triggers/foreign keys/procedures/indexes are added properly.
On Linux/Unix it is /opt/CA/SC/Mdb/logs/install_<OracleSID>_<Timestamp>.log file
On Windows it is C:\Program Files (x86)\CA\SC\Mdb\logs\install_<Timestamp>.log
Execute CA SDM 'pdm_configure' program to complete the CA SDM Configuration.
Make sure to take a full MDB database backup before starting any process that effects the MDB.
Make sure to use the correct release/version of CA SDM installer during this process. If you are intending to use SDM 12.6 CA SDM against the MDB, make sure you run the CA MDB Installer via the CA SDM 12.6 CA SDM DVD.
Engage CA Support for further assistance if you are not sure which route to take.