Version 8.2
Hi,
I have attempted to insert a value of more than 50 characters into an identity attribute, and it resulted in an error. Is it advisable to extend it? What would need to be modified and how to extend the range?
Thanks
Hi Espino,
Welcome to Sailpoint Developer’s Community - max size of the attribute is generaly related to the database column size.
It is configurable in Hibernate configuration files and later on “transfered” into the DB schema.
for example here you can see content of LinkExtended.hbm.xml file which contains information about size of Link extended attributes. Same applies to Identity Extended attributes.
Once you change HBM config you also need to recreate DB schema by executing iiq console schema to reflect it into the DB.
Here you can see example of default sized in the DB for spt_identity table
Hi @espino,
It depends upon your database capability, and you can extend your data size as per your expectation. But as the size increases you may face issue with indexing and making it searchable.
Thanks
you can check the column value in spt_identity table , check on database and execute below cmd
desc spt_identity;
What is the error? Is it related to the size “Column size too large”?
Hi @espino, could you please share the error details?
Hi, @espino
In the SailPoint IIQ database tables, some data types have limits. We can increase these limits if we need an identity attribute to allow 50 characters. This is useful for attributes that need more space for longer input. Which identity attribute needs this change?
Hi,
I was able to try it just now and it worked.
Thanks Kamil.
The error was:
“Exception running rule: The application script threw an exception: sailpoint.tools.GeneralException: org.hibernate.exception.DataException: could not execute statement BSF info:…”
Kamil provided the solution.
Thanks
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.
