Length issue while provisioning picklist value in Salesforce

IdentityIQ (IIQ) IIQ Discussion and Questions
,
1

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 Team,

We have observed that if we select multiple picklist value to provision then it fails to provision in salesforce but when I concat all the selected picklist value as a single value separated by semicolon then it works fine, but we have more than 20 picklist values and user can select any number of these values, so when we select multiple picklist values which needs to be converted as a single string separated by semicolon then we are getting exception following exceptions:

2024-04-16T07:06:53,557 ERROR https-openssl-nio-8443-exec-10 engine.jdbc.spi.SqlExceptionHelper:142 - String or binary data would be truncated in table ‘identityiqQA.identityiqQA.spt_identity_request_item’, column ‘value’. Truncated value: ‘EMEA- Europe- Spain;APAC- Pacific- Australia;APAC- Asia- Singapore;Americas- LATAM- Venezuela;Americ’.
2024-04-16T07:06:53,557 ERROR https-openssl-nio-8443-exec-10 sailpoint.server.ScriptletEvaluator:143 - Step call threw an exception:
2024-04-16T07:06:53,573 ERROR https-openssl-nio-8443-exec-10 sailpoint.server.ScriptletEvaluator:144 - sailpoint.tools.GeneralException: org.hibernate.exception.SQLGrammarException: could not execute statement

2024-03-29T11:44:39,257 WARN https-openssl-nio-8443-exec-8 engine.jdbc.spi.SqlExceptionHelper:137 - SQL Error: 2628, SQLState: S0001
2024-03-29T11:44:39,257 ERROR https-openssl-nio-8443-exec-8 engine.jdbc.spi.SqlExceptionHelper:142 - String or binary data would be truncated in table ‘identityiqQA.identityiqQA.spt_identity_entitlement’, column ‘value’. Truncated value: ‘Americas- North America- USA;Americas- North America- International;Americas- North America- Canada;’.
2024-03-29T11:44:39,257 ERROR https-openssl-nio-8443-exec-8 sailpoint.server.ScriptletEvaluator:143 - Step call threw an exception:
2024-03-29T11:44:39,257 ERROR https-openssl-nio-8443-exec-8 sailpoint.server.ScriptletEvaluator:144 - sailpoint.tools.GeneralException: org.hibernate.exception.SQLGrammarException: could not execute statement

So to solve this issue I increased the “value” column length for these 2 table

identityiqQA.spt_identity_entitlement

identityiqQA.spt_identity_request_item

Now I am not getting this exception.

I am looking for following suggestion and best practices:

Will there be any impact if we increase the column length ?, because this is how it works at Salesforce side.

Thanks!

2

@vivek_kumar9
These are OOTB columns and pre-defined lengths as part of SailPoint IIQ OOTB table structure, at times users may need more length , I don’t think there is specific harm in modifying the length as you did but be cautious during any upgrades or patching.

1 Like
3

no impact at all, it may, depending on your company environment size , cause little lags, but with a powerfull db i dont see any problem.

1 Like