-
Bug
-
Resolution: Fixed
-
Medium
-
10.3.3
-
1
-
Severity 2 - Major
-
Issue Summary
Few Asset objects are currently missing from the Jira UI, and the clean reindex process fails due to an SQLException. Furthermore, the Jira assets custom field is generating an error: "Error rendering ‘com.atlassian.jira.jira-view-issue-plugin:details-module’."
Steps to Reproduce
JSM version 10.3.3 is configured with Oracle Database Server 19.26.0.0.0 and Oracle JDBC Driver 19.3. Users have reported that certain objects are missing in the user interface, and the asset clean reindex operation fails with an error. The Atlassian Jira logs are showing a recurring error: java.sql.SQLException: Cannot extract column 23 for type java.lang.Long
Expected Results
Assets clean reindex should be completed without any errors. There should not be any objects missing in the schema, and the assets custom field should accurately display the objects.
Actual Results
The below exception is thrown in the Atlassian-jira.log file:
2025-03-17 11:17:44,858+0100 support-zip ERROR Anonymous user [c.r.j.p.i.s.c.d.dao.sql.AbstractAOService] Error querying database: java.sql.SQLException: Cannot extract column 23 for type java.lang.Long at com.riadalabs.jira.plugins.insight.services.core.dal.dao.sql.AbstractAOService.getObjectWithNullCheck(AbstractAOService.java:860) at com.riadalabs.jira.plugins.insight.services.core.dal.dao.sql.AbstractAOService.findObjectAttributeValuesDTOs(AbstractAOService.java:718) at com.riadalabs.jira.plugins.insight.services.core.dal.impl.ObjectDalImpl.findDBObjectsInternal(ObjectDalImpl.java:578) at com.riadalabs.jira.plugins.insight.services.core.dal.impl.ObjectDalImpl.findDBObjects(ObjectDalImpl.java:538) at com.riadalabs.jira.plugins.insight.services.core.dal.impl.ObjectDalImpl.loadObject(ObjectDalImpl.java:358) at io.riada.insight.index.model.ObjectIndexImpl.render(ObjectIndexImpl.java:294) at io.riada.insight.index.model.ObjectIndexImpl.render(ObjectIndexImpl.java:65) at io.riada.insight.index.model.InsightIndexBase$1.load(InsightIndexBase.java:101) at io.riada.insight.index.model.InsightIndexBase$1.load(InsightIndexBase.java:98) at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3574) at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2316) at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2189) at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2079) at com.google.common.cache.LocalCache.get(LocalCache.java:4017) at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:4040) at com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4989) at io.riada.insight.index.model.InsightIndexBase.load(InsightIndexBase.java:71) at io.riada.insight.index.model.ObjectIndexImpl.loadObject(ObjectIndexImpl.java:172) at java.base/java.util.stream.ReferencePipeline$3$1.accept(Unknown Source) at java.base/java.util.concurrent.ConcurrentHashMap$KeySpliterator.forEachRemaining(Unknown Source) at java.base/java.util.stream.AbstractPipeline.copyInto(Unknown Source) at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(Unknown Source) at java.base/java.util.stream.ReduceOps$ReduceOp.evaluateSequential(Unknown Source) at java.base/java.util.stream.AbstractPipeline.evaluate(Unknown Source) at java.base/java.util.stream.ReferencePipeline.collect(Unknown Source) at io.riada.insight.index.filter.objectticketconnection.ObjectTicketConnectionFilterImpl.countObjectTicketConnectionsBySchema(ObjectTicketConnectionFilterImpl.java:51) at com.riadalabs.jira.plugins.insight.services.analytics.service.InsightInstanceAnalyticsServiceImpl.getPerSchemaStats(InsightInstanceAnalyticsServiceImpl.java:102) at com.riadalabs.jira.plugins.insight.services.analytics.service.InsightAtstSupportServiceImpl.getPerSchemaAnalytics(InsightAtstSupportServiceImpl.java:28) at com.atlassian.troubleshooting.jira.bundle.AssetsSupportBundle.get
Workaround
Required, if there is no workaround please state:
Currently there is no known workaround for this behavior. A workaround will be added here when available
- links to
| Form Name | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
[JSDSERVER-16117] Assets fails to handle Long values on Oracle DB
| Resolution | New: Fixed [ 1 ] | |
| Status | Original: Waiting for Release [ 12075 ] | New: Closed [ 6 ] |
| Support reference count | New: 1 |
| Status | Original: In Progress [ 3 ] | New: Waiting for Release [ 12075 ] |
| Status | Original: Short Term Backlog [ 12074 ] | New: In Progress [ 3 ] |
| Fix Version/s | New: 10.3.5 [ 110897 ] | |
| Fix Version/s | New: 10.6.0 [ 110418 ] | |
| Fix Version/s | New: 10.5.1 [ 110317 ] |
| Summary | Original: Missing Asset Objects in the UI and Clean Reindex Fail with SQLException. | New: Assets fails to handle Long values on Oracle DB |
| Assignee | New: Benjamin Suess [ c8bcca445054 ] |
| Status | Original: Needs Triage [ 10030 ] | New: Short Term Backlog [ 12074 ] |
| Labels | New: ril |
| Remote Link | New: This issue links to "Internal ticket (Web Link)" [ 999418 ] |