Database Table Column Length Issue

[anubhav_varshney07 (Anubhav Varshney)]

Which IIQ version are you inquiring about?

Version 8.3

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

Hello Experts

We are looking for your pointers to resolve the below issue:
We had increased value column length for below tables:
Spt_identity_entitlement
Spt_identity_request_item
We are trying to revert the change that we had done that means altering the table to set the ‘value’ column length back to default 450 chars.
We have done the clean up of data that was present in these tables which was exceeding the 450 chars. However, still we are getting an error while trying to reduce the size back to default.
Based on the error it looks like there may be some existing references in the other tables referring to this value.

Please share if any pointer to look for.
Error.txt (72 Bytes)

[enistri_devo (Emanuele Nistri)]

Hi @anubhav_varshney07,

if you want reduce/increase the columns length, you need to change the value in IdentityExtended.hbm.xml file too(or the object that you want).
For example if you want change the extended6 to 400, you need make this:

<property name="extended6" type="string" length="400"/>
<property name="extended7" type="string" length="450"/>
<property name="extended8" type="string" length="450"/>
<property name="extended9" type="string" length="450"/>
<property name="extended10" type="string" length="450"/>

for increse depends of type of DB(mysql,oracle,MSSQL…) and you need to check the supported type; in MSSQL you can you use the type text for a very large column.

But, is better if the db and the files have the same values.

[vishal_kejriwal1 (Vishal Kejriwal)]

What happen if you don’t revert it back ? It always good to have DB backup especially when you make changes at DB .