Error while updating the data in Multi select Custom Field

Question

I am getting following error when i try to insert data in Multi select Custom field.

2018-02-26 18:53:20,553 http-nio-8080-exec-24 ERROR prakash 1133x12510x1 1464o3u 52.164.210.137 /secure/QuickEditIssue.jspa [c.o.scriptrunner.runner.AbstractScriptListener] Script function failed on event: com.atlassian.jira.event.issue.IssueEvent, file: <inline script>
com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:CustomFieldValue][parentkey,null][customfield,10043][issue,584206][stringvalue,E1mm (Frontier) APAC/EMEA DS/E1mm (Frontier) APAC/EMEA SS/E1mm (Frontier) LATAM/Australia DS/E1mm (Frontier) LATAM/Australia SS/E2M (Dynamo2) SKU2 - LATAM DS/E2M (Dynamo2) SKU2 - LATAM SS/Onyx APAC DS/Onyx APAC SS/Plate 2 LATAM DS/Plate 2 LATAM SS/Plate 2 RoW/EMEA/APAC DS/Plate 2 RoW/EMEA/APAC SS][id,13678802][updated,1519651400442] (SQL Exception while executing the following:INSERT INTO dbo.customfieldvalue (ID, ISSUE, CUSTOMFIELD, UPDATED, PARENTKEY, STRINGVALUE, NUMBERVALUE, TEXTVALUE, DATEVALUE, VALUETYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (String or binary data would be truncated.))
at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.createValue(DefaultOfBizDelegator.java:299)
at com.atlassian.jira.ofbiz.WrappingOfBizDelegator.createValue(WrappingOfBizDelegator.java:172)
at com.atlassian.jira.issue.customfields.persistence.OfBizCustomFieldValuePersister.createValuesInt(OfBizCustomFieldValuePersister.java:129)
at com.atlassian.jira.issue.customfields.persistence.OfBizCustomFieldValuePersister.updateValues(OfBizCustomFieldValuePersister.java:154)
at com.atlassian.jira.issue.customfields.persistence.EagerLoadingOfBizCustomFieldPersister.updateValues(EagerLoadingOfBizCustomFieldPersister.java:54)
at com.atlassian.jira.issue.customfields.persistence.OfBizCustomFieldValuePersister.createValues(OfBizCustomFieldValuePersister.java:109)
at com.atlassian.jira.issue.customfields.persistence.EagerLoadingOfBizCustomFieldPersister.createValues(EagerLoadingOfBizCustomFieldPersister.java:42)
at com.atlassian.jira.issue.customfields.persistence.OfBizCustomFieldValuePersister.createValues(OfBizCustomFieldValuePersister.java:102)
at com.atlassian.jira.issue.customfields.persistence.EagerLoadingOfBizCustomFieldPersister.createValues(EagerLoadingOfBizCustomFieldPersister.java:36)

Any idea how to fix this?

Nic Brough -Adaptavist- · Answer

Yes, pass in a list of Options.  The array you're seeing in the error message is not a representation of list of options, it's a string.  So you're not doing what you claim there.  The fact you're talking about length of the string tells me you're not passing options.

Could you give us the actual code?

prakashmurugesan · Answer

@Nic Brough -Adaptavist- is there any way to fix this issue?.

prakashmurugesan · Answer

Hello Nic,

we are trying to pass list of Options only .

But one thing we noticed here is it accepts up to 280 characters as options in Multi Select Field .Any thing more than 280 characters it takes as text.

Basically for each option selected in Multi select custom field our script creates a linked issue . JIRA accepts 10/15/20 /30  Options in Multi Select field (But total number of characters of these options should be less than 280.