Hello Patsy,
Can you confirm if this has been happening for a while now? Did this just start happening?
I did come across something that might be of help, but it does come from an older release of SDM. I would suggest checking if your test environment has the problem as well, and if it does, try the following:
1)backup the table usp_pdmMacroParam by command.
pdm_extract usp_pdmMacroParam > backup.txt
2)Get the target row by below command.
pdm_extract -f "select * from usp_pdmMacroParam where caption = 'Extra URL' and id =1487" > target.txt
3)Modify the value for the 2nd field default_value from "" to "QBE.EQ.delete_flag=0". The record would look like this.
TABLE usp_pdmMacroParam
caption default_value del description help_form id is_advanced is_required
last_mod_by last_mod_dt macro name name_val_localized size_textbox tooltip
type value_list
{ "Extra URL" ,"QBE.EQ.delete_flag=0" ,"0",
"For passing extra URL information. Not for general use.",
"-properties_extraURL_index.html" ,"1487" ,"1" ,"0" ,"" ,"" ,"1150",
"extraURL" ,"0" ,"" ,"For passing extra URL information" ,"1" ,"" }
4)Load back the modified target.txt with pdm_load command
pdm_load -u -f target.txt
5)Recycle services to take effect.