Users are unable to select a service provider when creating or editing a notification device in the user preference window - Support and Troubleshooting

Users are unable to select a service provider when creating or editing a notification device in the user preference window Issue  Symptoms Users are getting Security constraints prevent access to requested page error when trying to select a service provider on creating or editing a notification device in the user preference window

Cause The active service provider (cmn_notif_service_provider) records number has surpassed the specified value on the system property glide.ui.max_ref_dropdown causing the reference field to become a normal reference field from it being a drop-down type.

Resolution There are several solution options as per below that could be applied for this issue:

Reduce the number of active cmn_notif_service_provider so it is 25 or less, or Increase the number of the system property glide.ui.max_ref_dropdown , or Create the appropriate table level read ACL on cmn_notif_service_provider so even if the reference field turns into a normal magnifying glass users would still have access (as long as they pass the ACL) Additional Information glide.ui.max_ref_dropdown has this description:

"Maximum number of records allowed for a reference field displayed as a choice list. If more records than this are available, default reference field UI is used."

This is the expected platform behavior:

When reference fields are loaded as a dropdown, an unprivileged user can see them regardless of ACL. When there are enough references (meaning the active records surpassed the number specified on the property) it does a lookup that does respect ACL (so if no ACL is specified non-admin users will fail access by default).