Autosuggest list includes both active and inactive records

Products

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

Issue/Introduction

Autosuggest list includes both active and inactive records

Environment

CA Service Desk Manager 14.1 and 17.0Any Supported OS

Resolution

1.  Backup the table usp_pdmMacroParam by running the following command via a command prompt on the CA SDM server (Primary or Background)

 
pdm_extract usp_pdmMacroParam > pdmMacroParamBackup.txt 

2.  Extract the a single row from the usp_pdmMacroParam table by running the following command via a command prompt on the CA SDM server (Primary or Background)

pdm_extract -f "select id, caption, default_value from usp_pdmMacroParam where id = 1487" > pdmMacroParamTarget.txt 

3.  Open the pdmMacroParamTarget output file with a plain text editor, like Notepad, and modify the value for the 3rd field (default_value) from "" to "QBE.EQ.delete_flag=0".  The record should look like the following once the change is made

TABLE usp_pdmMacroParam 
id caption default_value 
{ "1487" ,"Extra URL" ,"QBE.EQ.delete_flag=0" } 

4.  Load back the modified pdmMacroParamTarget file by running the following pdm_load command via a command prompt on the CA SDM server (Primary or Background)

pdm_load -f pdmMacroParamTarget.txt

5.  Run the following command via a command prompt on the CA SDM server (Primary or Background)

pdm_cache_refresh -t usp_pdmMacroParam