active and inactive users are displayed by search function

Document ID : KB000098281
Last Modified Date : 29/05/2018
Show Technical Document Details
Issue:
When searching for Incidents (list_in.htmpl) inactive contacts are displayed in the Autosuggest drop-down list
Environment:
SDM 14.1
Resolution:
This problem is caused by the old usp_pdmMacroParam TABLE from 12.9. 
If the post-installation step from 12.9/CP1 was not done, then this problem occurs in 14.1.

Run 'select * from usp_pdm_macro_param where id=1487'. 
If the default_value field is null, complete the following steps: 

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