Aggregation Failure

IdentityIQ (IIQ) IIQ Discussion and Questions
1

Which IIQ version are you inquiring about?

8.2

Please share any other relevant files that may be required (for example, logs).

Hi Community,

We are having an aggregation failure because of one user who has very long name the aggregation task is not able to pull his data alone.

Please help me how we can extend the column size in DB for the application Azure AD in SailPoint identityiq.

2

Hi @charan18,

you can increase the size of column or change the type (like “text”) depeds of type of DB.

Which db you have installed?

3

Microsoft SQL, please point me to the DB table where I can increase this.

4

the table is spt_identity.

But its not to easy, you must detect which attribute is too long and alter the column.
I suggest to you to work on the value and cut the it instead of changing the size of column.

Also this is the command

ALTER TABLE spt_identity ALTER COLUMN nameColumn VARCHAR(newIntvalue);
5

Thanks for the feedback but it’s happening while aggregating Azure - AD application and I know an attribute called upn which is lengthy.

6

@charan18
Are you using upn or any of the substring of upn as your native identity or display name , can you share the exact error you are getting here

you have to update spt_link table and column which is causing the error

7

Hi @sathishiam,

You can ask the azure ad team to reduce the length of the upn value. For one object it’s not ideal to increase the column size.
You can skip this entry using customisation rule to ignore it if you want the aggregation to be successful.

1 Like
8

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