-
Bug
-
Resolution: Unresolved
-
Low
-
None
-
5.12.22, 10.3.5, 10.6.1
-
1
-
Severity 3 - Minor
-
Issue Summary
Adding a few groups (or with too many characters on the group name) on User type Attribute of an Object fails silently. On the UI no error is displayed, you can only see an error 500 on developer tools.
Steps to Reproduce
- Create an Object Scheme
- Add a User attribute on an Object
- Try to include multiple groups on it (with long group name)
- Click on "Add" nothing happens
- Open developer tools, you will see it failed with error 500
Diagnosis
Checking the logs we can see this error:
2025-06-10 00:39:17,927-0400 http-nio-8080-exec-25 url: /rest/insight/1.0/objecttypeattribute/229/1551; user: C933984 ERROR C933984 39x210657x2 mbon18 10.107.242.48 /rest/insight/1.0/objecttypeattribute/229/1551 [c.r.j.p.i.c.w.a.r.exception.mapper.DefaultMapper] Unexpected exception was thrown while processing the request com.riadalabs.jira.plugins.insight.common.exception.RuntimeInsightException: InsightRuntimeException: java.lang.reflect.UndeclaredThrowableException; nested exception is: null java.lang.reflect.UndeclaredThrowableException at jdk.proxy99/jdk.proxy99.$Proxy6084.save(Unknown Source) at com.riadalabs.jira.plugins.insight.services.core.dal.impl.ConfigurationDalImpl.storeObjectTypeAttribute(ConfigurationDalImpl.java:765) at com.riadalabs.jira.plugins.insight.services.core.ObjectTypeAttributeServiceImpl.storeObjectTypeAttribute(ObjectTypeAttributeServiceImpl.java:153) at com.riadalabs.jira.plugins.insight.channel.web.api.rest.services.objecttypeattribute.ObjectTypeAttributeResource.updateObjectTypeAttribute(ObjectTypeAttributeResource.java:277) ... Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would be truncated in table 'Jira.dbo.AO_8542F1_IFJ_OBJ_TYPE_ATTR', column 'TYPE_VALUE'. Truncated value: 'BGE Security,ComEd Security,Exelon Corporate Security,PECO Security,PHI Security,esoc-support,OT Pro'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:262) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1632)
It is failing because of the char limit of column TYPE_VALUE on AO_8542F1_IFJ_OBJ_TYPE_ATTR table, which is 255.
Expected Results
An error should be thrown on the UI indicating it failed to add the groups.
Actual Results
Nothing happens on the UI. An error is seen only on developer tools and on the logs.
Workaround
To prevent this the customer can increase the char of TYPE_VALUE column:
alter table "AO_8542F1_IFJ_OBJ_TYPE_ATTR" alter column "TYPE_VALUE" type varchar (400);
Versions Tested
Please confirm all versions that have been tested for this issue, and indicate whether the tested version is affected or not affected, below:
| Testing Requirements | Version | Affected Version |
|---|---|---|
| Customers Reported Version | 5.12.22 | yes |
| Most Recent Bug-Fix Release | 10.6.1 | yes |
| Previous Major Release | ||
| Most Recent LTS | ||
| Previous Supported LTS | ||
| Other Versions.. | 10.3.5 | yes |
| (Add rows as needed) |
- links to
