How to increase the size of extended attribute

IdentityIQ (IIQ) IIQ Discussion and Questions
,
1

Which IIQ version are you inquiring about?

8.4

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

Hi Team,

I’m trying to set the extended attribute for a managed entitlement using the following code:

ma.setAttribute(“businessDescription”, appDesc);

However, I’m encountering this error:

An unexpected error occurred: java.lang.Exception: sailpoint.tools.GeneralException: The application script threw an exception: java.lang.RuntimeException: sailpoint.tools.GeneralException: org.hibernate.exception.DataException: could not execute statement
BSF info: Moodys - ServiceNow CMDB Attribute Mapping Rule at line: 0 column: columnNo

I suspect the issue might be related to the length of the value in the businessDescription field. Could you please advise on:

  • How to increase the allowed length for this attribute?

  • Any alternative suggestions to resolve this error?

  • Also please suggest what is the maximum length.

2

Hi @Jeevith18,

this error is not related with the size of column.

Review the rule, puts some logs and find a more specific error.

3

Hi @enistri_devo ,

Thanks for the reply…when i comment out this line code is running successfully only when i am trying to set this getting this error.

and i can confirm the data i am trying to set has more than 1000 chars. please suggest

4

Hi @Jeevith18

Verify that the extended attribute is marked as searchable in ObjectConfig → ManagedAttribute. If searchable, the default length is 450.

To increase the attribute length:

  1. Update the attribute length in ManagedAttributeExtended.hbm.xml

  2. Go to [IdentityIQ installation directory]/WEB-INF/bin.

  3. Run iiq extendedSchema.

  4. This creates the DDL file add_identityiq_extensions.[dbms].

  5. Run that script on your database to update the tables and indexes.

    refer : https://community.sailpoint.com/t5/Technical-White-Papers/Managing-Extended-Attributes/ta-p/77088#toc-hId--2040101391

5

Check the Hibernate configuration file and try increasing the length value to see if that helps

6

Hi @EnugulaSrinivas ,

Thanks for your suggestion. it worked.

can you please help me to understand the best practices to increase this size.

when i ran iiq extendedSchema i got the below query.
alter table identityiq.spt_managed_attribute add extended10 varchar(4000);
create index spt_managed_attr_extended10_ci on identityiq.spt_managed_attribute (extended10(255));

when i tried to execute got the duplicate error so i tried to use the modify operation

alter table identityiq.spt_managed_attribute modify extended10 varchar(4000);

it ran for a very long time and server got crashed. can you please provide the best practices to perform this