Identity Request - Long Attribute Values and DB Sizing Limits

IdentityIQ (IIQ) IIQ Discussion and Questions
1

Which IIQ version are you inquiring about?

IIQ 8.3P3

Share all details related to your problem, including any error messages you may have received.

We have been working on creating a custom workflow for creating Azure Cloud only accounts. This workflow leverages the Azure connector provided by SailPoint. One attribute value can be rather large, sometimes upwards of 450+ characters. The issue is that the IIQ database table spt_identity_request_item has a column value, which is only 450 characters long. When you have an IdentityRequest and that identity Request has an Attribute Request which is > 450 characters, the system will error when generating the Identity Request. Has anyone ever altered this table to enlarge the size of this column? Is this better added to the ideas site, or a support ticket?

2

Which column you are talking about from identity request item ?

3

The column name is [value], sorry it wasn’t entirely clear in my initial post.

4

Value column size is 450 , before coming to request item table , this will get populated in spt_managed_attribute column table i value column . this will fail first in your scenario if value size is >450.

5

Aggregation itself should fail for you .

6

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.