-
Title
Error when using {0} placeholder in VI_ITShop_Filter_AccProduct with multiple recipients -
Description
When using the configuration parameter ServerConfig/VI_ITShop_Filter_AccProduct with a custom WHERE clause containing the {0} placeholder, selecting multiple recipients in the Web Portal causes an error:
"Error occurred while processing your request"
The error only occurs when two or more recipients are selected. Single-recipient selections work correctly.
Affected versions: Identity Manager 9.3.0
-
Cause
A code regression in QER.CompositionApi.Server.PlugIn.dll causes the {0} placeholder to be substituted incorrectly when multiple recipients are selected.
The recipient UIDs are joined using a single quote character (') instead of a comma (,), producing malformed SQL.
For example, instead of:
UID_Person IN ('uid1','uid2','uid3')The system generates:
UID_Person IN ('uid1''''uid2''''uid3') -
Resolution
If you encounter this issue, please contact our Support and ask for hotfix #488057.
The hotfix corrects the UID joining logic in QER.CompositionApi.Server.PlugIn.dll so that multiple recipient UIDs are properly comma-separated.
Alternatively, upgrade to Identity Manager 9.3.1 or later, which includes this fix.
-
Change Request
488057