How to remove a customized CA Service Desk Manager (CA SDM) field that is already published using CA SDM Web Screen Painter (WSP)?
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.
- Login to either the CA SDM Primary Server (Conventional) or Background Server (Advanced Availability)
- Access the NX_ROOT\site\mods directory (NX_ROOT is the CA SDM install directory)
- Edit the wsp_schema.sch file located at NX_ROOT\site\mods folder. Delete the field reference.
- Edit the wsp.mods file located at NX_ROOT\site\mods\majic folder. Delete the field reference.
- 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.
- 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.
- Stop CA SDM Services
- Delete the field from MDB database. Please use the backend SQL tools to remove the given field directly from the MDB database.
- 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.
- Run "pdm_publish" for the changes to take effect.
- 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.