Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-75765

Arithmetic Overflow Error When Converting Float to Numeric Datatype in SQL Server on Windows OS

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • Low
    • None
    • 8.20.12, 8.20.22
    • Custom fields
    • None

    Description

      Issue Summary

      An arithmetic overflow error occurs when trying to convert a float to a numeric datatype in a SQL Server database running on a Windows OS. This issue is specifically encountered when using a Number Field in Jira Software.
      In the case of PostgresDB on Linux, this issue is not occurring.

      This is reproducible on Data Center: Yes

      Steps to Reproduce

      1. Set up a SQL Server database on a Windows OS.
      2. Install and configure Jira Service Management Data Center on a Windows OS.
      3. Create a project with a Number Field.
      4. Create a issue and attempt to enter '100000000000000' into the Number Field.

      Expected Results

      The number should be successfully entered into the Number Field without any errors.

      Actual Results

      An arithmetic overflow error occurs when trying to convert a float to a numeric datatype, and the number cannot be entered into the Number Field. The following exception is thrown in the atlassian-jira.log file:

      Caused by: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO dbo.customfieldvalue (ID, ISSUE, CUSTOMFIELD, UPDATED, PARENTKEY, STRINGVALUE, NUMBERVALUE, TEXTVALUE, DATEVALUE, VALUETYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Arithmetic overflow error converting float to data type numeric.)
      

      Workaround

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

      Attachments

        Activity

          People

            Unassigned Unassigned
            720db0c924f0 Tomoya Suzuki
            Votes:
            2 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated: