Uploaded image for project: 'Jira Service Management Data Center'
  1. Jira Service Management Data Center
  2. JSDSERVER-15981

Unable to enter an AQL longer than 255 characters in the 'Object mapping (AQL)' field within the Assets Import OT mapping

XMLWordPrintable

      Issue Summary

      It is not possible to save an AQL longer than 255 characters in the 'Object mapping (AQL)' field within the Import OT mapping configuration. Additionally, no exceptions are displayed on the user interface.
      Issue occurs in Postgresql.

      Steps to Reproduce

      1. Create a new Assets Schema
      2. Set up any Assets Import
      3. Create a new Object Type Mapping
        • Add a new mapping and add an AQL longer than 255 characters

      Expected Results

      An exception should either be displayed in the user interface to inform customers why the AQL cannot be saved, or the AQL should be allowed to be saved without any issues.

      Actual Results

      The below exception is thrown in the atlassian-jira.log file:

      2025-01-14 09:10:21,609+0000 http-nio-8080-exec-59 url: /jsm/rest/insight/1.0/importsource/otattr/; user: admin ERROR admin 550x2520x1 1v38jz5  /rest/insight/1.0/importsource/otattr/ [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.proxy107/jdk.proxy107.$Proxy4785.save(Unknown Source)
	at com.riadalabs.jira.plugins.insight.services.core.dal.impl.ImportSourceConfigurationDalImpl.persistImportSourceOTAttr(ImportSourceConfigurationDalImpl.java:429)
	at com.riadalabs.jira.plugins.insight.services.core.dal.impl.ImportSourceConfigurationDalImpl.storeImportSourceOTAttr(ImportSourceConfigurationDalImpl.java:393)
	at com.riadalabs.jira.plugins.insight.services.core.impl.ImportSourceConfigurationServiceImpl.storeImportSourceOTAttr(ImportSourceConfigurationServiceImpl.java:753)
	at com.riadalabs.jira.plugins.insight.channel.web.api.rest.services.imports.ImportSourceConfigurationResource.storeImportSourceOTAttr(ImportSourceConfigurationResource.java:601)
	at com.riadalabs.jira.plugins.insight.channel.web.api.rest.services.imports.ImportSourceConfigurationResource.saveImportSourceOTAttr(ImportSourceConfigurationResource.java:498)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:569)
Caused by: org.postgresql.util.PSQLException: ERROR: value too long for type character varying(255)
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2725)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2412)

      Workaround

      Currently there is no known workaround for this behavior. A workaround will be added here when available

      Versions Tested

      Testing Requirements Version Affected Version
      Customers Reported Version 5.12.15 Yes
      Most Recent Bug-Fix Release 10.3.0 Yes
      Most Recent LTS 10.3.0 Yes

              b437717b5ac8 Yiwen Zhang
              9f03f4114502 Pablo Bartolome (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: