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

Article Id: 36866
Status: Published
Updated On: 14-02-2018 07:37
Legacy Id: TEC1278997
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: