Dynamic Attribute not working for Roles

[haardik_verma]

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.

[rushikeshvartak]

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