Issue Summary

      Bulk print Insight labels operation crash with Oracle Jira DB

      Steps to Reproduce

      1. In a Jira Oracle database create a label template in one of the Insight object schemas
      2. Make sure to leave the description of the template empty:
      3. Save the template and go back to object schema.
      4. In one object type which contains objects, select Bulk>Print Labels:
      5. Select the labels template just created and clic on Print:

      Expected Results

      The print preview with labels should appears.

      Actual Results

      The operation spin indefinitely and the operation is not completed.
      Nothing is into logs.

      This happen because Oracle threat empty values as null.

      Note that this happen with Insight 8.7.9 and latest 8.7.10 (so also with versions on Jira Server not only DC).

      Workaround

      Fill the description in the template with a value.

            [JSDSERVER-7375] Bulk print Insight labels operation crash with Oracle Jira DB

            Thomas Bowes (Inactive) made changes -
            Remote Link New: This issue links to "Page (Confluence)" [ 720376 ]
            François Dénommée (Inactive) made changes -
            Resolution New: Fixed [ 1 ]
            Status Original: Waiting for Release [ 12075 ] New: Closed [ 6 ]
            François Dénommée (Inactive) made changes -
            Fix Version/s New: 4.20.0 [ 96191 ]
            François Dénommée (Inactive) made changes -
            Status Original: In Review [ 10051 ] New: Waiting for Release [ 12075 ]
            François Dénommée (Inactive) made changes -
            Status Original: In Progress [ 3 ] New: In Review [ 10051 ]
            François Dénommée (Inactive) made changes -
            Remote Link New: This issue links to "Insight Platform › Insight Core › JSDSERVER-7375-label-without-description-oracle-fix (server-syd-bamboo)" [ 578295 ]
            François Dénommée (Inactive) made changes -
            Status Original: Needs Triage [ 10030 ] New: In Progress [ 3 ]
            François Dénommée (Inactive) made changes -
            Assignee New: François Dénommée [ 828a13f9a5a4 ]
            Tiziana Marchionni made changes -
            Description Original: h3. Issue Summary
            Bulk print Insight labels operation crash with Oracle Jira DB

            h3. Steps to Reproduce
             # In a Jira Oracle database create a label template in one of the Insight object schemas
             # Make sure to leave the description of the template empty:
             !Screenshot_2021-05-14_at_14_24_24.png|thumbnail!
             # Save the template and go back to object schema.
             # In one object type which contains objects, select Bulk>Print Labels:
             !Screenshot 2021-05-14 at 14.28.42.png|thumbnail!
             # Select the labels template just created and clic on Print:
              !Screenshot 2021-05-14 at 14.25.31.png|thumbnail!

            h3. Expected Results
            The print preview with labels should appears.
            h3. Actual Results
            The operation spin indefinitely and the operation is not completed.
            Nothing is into logs.

            This happen because Oracle threat empty values as null.

            Note that this happen with Insight 8.7.9 and latest 8.7.10 (so also with versions on Jira Server not only DC).

            h3. Workaround

            Workaround 1:
            Fill the description in the template with a value.
            New: h3. Issue Summary
            Bulk print Insight labels operation crash with Oracle Jira DB

            h3. Steps to Reproduce
             # In a Jira Oracle database create a label template in one of the Insight object schemas
             # Make sure to leave the description of the template empty:
             !Screenshot_2021-05-14_at_14_24_24.png|thumbnail!
             # Save the template and go back to object schema.
             # In one object type which contains objects, select Bulk>Print Labels:
             !Screenshot 2021-05-14 at 14.28.42.png|thumbnail!
             # Select the labels template just created and clic on Print:
              !Screenshot 2021-05-14 at 14.25.31.png|thumbnail!

            h3. Expected Results
            The print preview with labels should appears.
            h3. Actual Results
            The operation spin indefinitely and the operation is not completed.
            Nothing is into logs.

            This happen because Oracle threat empty values as null.

            Note that this happen with Insight 8.7.9 and latest 8.7.10 (so also with versions on Jira Server not only DC).

            h3. Workaround

            Fill the description in the template with a value.
            Bugfix Automation Bot made changes -
            Support reference count New: 1

              828a13f9a5a4 François Dénommée (Inactive)
              tmarchionni@atlassian.com Tiziana Marchionni
              Affected customers:
              0 This affects my team
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: