Dropdown object not working we have this error, AHD03053 Bad where clause Parse error at "( id IN ( 400001%2C 400002 ) )...

Document ID : KB000093926
Last Modified Date : 02/05/2018
Show Technical Document Details
Introduction:
After applied CP2 on 14.1, we may have dropdown not giving the list of possible values. The same problem is in 17.1

 
Question:
After applied CP2 on 14.1, we may have dropdown not giving the list of possible values.
In the stdlog we see this error message.
<< 
xxx web:local 7044 ERROR parse.c 8139 Unable to receive record for PDM_LIST at dtlDropdown.mac[107]: AHD03053:Bad where clause: Parse error at : "( id IN ( 400001%2C 400002 ) ) AND ( delete_flag = 0 )" (syntax error) 
>> 

We see the bad where clause causing the dropdown empty.

The syntax has to be "( id IN ( 400001, 400002 ) ) AND ( delete_flag = 0 )" , ServiceDesk replaced "," by "%2C"
 
Environment:
ServiceDesk 14.1 CP2
ServiceDesk 17.1
 
Answer:
Engineering created the patch
Please open a support standard case to get the fix
 
Additional Information:
Fix wolving this problem

PROBLEM SYMPTOM: WIN-COMMA REPLACED WITH %2C                       
----------------------------------------------------
After applying second set of cumulative patches for CA Service Desk Manager 14.1 Specifically USRD 2990, using esc_style as JS2 causing comma to replace with %2C.

Steps to reproduce:
1. Login to Service Desk Manager as Administrator.

2. Add 'test' in 'Administrator' contact as last name.

3. Create change order and update change order with log comment.

4. Add below code in detail_chg.htmpl file: <PDM_LIST PREFIX=act_log FACTORY=chgalg WHERE="change_id=$args.id AND type IN ('LOG')" ESC_STYLE=JS2> var test="$act_log.analyst.combo_name"; alert(test); </PDM_LIST>

5. Run pdm_webcache -bh through command prompt.

6. Open change order created in 2nd step.