Dynamic Attribute not working for Roles

New Contributor III
New Contributor III
We are trying to use dynamic attributes for Emergency access roles request.
We tried by adding dynamic attributes from the Role's page, but when submitting the attribute, we are getting popup:

We then tried from Global Config>>ROle Request >> dynamic attribute, there also same popup..

Trying with these details:
Dynamic Attribute Name: Exempted List
Type: Enum
Value: select case when ${REQUESTEE} in (select u.userkey from accounts a join account_entitlements1 ae ON ae.ACCOUNTKEY = a.ACCOUNTKEY join entitlement_values ev ON ae.ENTITLEMENT_VALUEKEY = ev.ENTITLEMENT_VALUEKEY join user_accounts ua on ua.ACCOUNTKEY=a.ACCOUNTKEY join users u on u.userkey=ua.userkey join endpoints e on a.endpointkey=e.endpointkey WHERE e.ENDPOINTNAME ='AD Green' and ev.ENTITLEMENT_VALUEKEY=1) then 'No_Approval_Required' else 'Approval_Required' end as id from dual
Default Value: Approval_Required 

What are we missing here?
From logs we could see the query which we are using on column 'ATTRIBUTE_VALUES is too long , 
2023-01-05 13:56:13,607 [https-jsse-nio-443-exec-93] INFO  services.UsersService  - starting to process roles auditing
2023-01-05 13:56:13,609 [https-jsse-nio-443-exec-93] INFO  services.UsersService  - Auditing for list of Roles
2023-01-05 13:56:13,612 [https-jsse-nio-443-exec-93] INFO  services.UsersService  - Auditing process completed for entitlement
2023-01-05 13:56:13,621 [https-jsse-nio-443-exec-93] ERROR util.JDBCExceptionReporter  - Data truncation: Data too long for column 'ATTRIBUTE_VALUES' at row 1
If this is so then is there no limit for dynamic attribute for endpoints?

A similar but even longer query is used in salesforce endpoint in DEV and it is working fine.






You need to raise support ticket to increase size . Endpoint dynamic  attribute data goes under endpoints-attributes