How to remove a CA Service Desk Manager (CA SDM) custom field

book

Article ID: 36866

calendar_today

Updated On:

Products

SUPPORT AUTOMATION- SERVER CA Service Desk Manager - Unified Self Service KNOWLEDGE TOOLS CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

Issue/Introduction

Question

How to remove a customized CA Service Desk Manager (CA SDM) field that is already published using CA SDM Web Screen Painter (WSP)?

Answer

The following steps will ensure that a published CA SDM customized field is completely removed both at the application and database levels. 

Note:  Before making any changes, please backup your database and your entire NX_ROOT\site folder.

  1. Login to either the CA SDM Primary Server (Conventional) or Background Server (Advanced Availability)

  2. Access the NX_ROOT\site\mods directory (NX_ROOT is the CA SDM install directory)

  3. Edit the wsp_schema.sch file located at NX_ROOT\site\mods folder.  Delete the field reference.

  4. Edit the wsp.mods file located at NX_ROOT\site\mods\majic folder.  Delete the field reference.

  5. Go to an Administrative Command Prompt.  Run the command "pdm_wspupd".  This command will read through the above files and compare with the wspcol table in the backend MDB database and provide a listing of materials to indicate the changes you are making in the above modifications to the wsp_schema.sch and wsp.mods.

  6. If all of the changes appear to be correct, hit "Y" to confirm the changes in "pdm_wspupd".  The "pdm_wspupd" script will update the backend wspcol and wsptbl tables within the MDB database with the given changes.

  7. Stop CA SDM Services

  8. Delete the field from MDB database.  Please use the backend SQL tools to remove the given field directly from the MDB database.

  9. Remove the reference to the field being deleted from the wsp_schema.log file located at NX_ROOT\site\mods folder.
    Note: The wsp_schema.log is used to determine what has already been created.  If the line relating to the field you are deleting is not removed from the wsp_schema.log, you will not be able to recreate the field in the same table again.

  10. Run "pdm_publish" for the changes to take effect.

  11. Start CA SDM Services.

Warning: The above procedure should never be performed on a live production CA SDM installation unless extensive testing is carried out first.

Environment

Release: SDMU0M99000-14.1-Service Desk Manager-Full License
Component: