Details
-
Bug
-
Resolution: Unresolved
-
Low
-
None
-
8.20.12, 8.20.22
-
None
-
8.2
-
2
-
Severity 3 - Minor
-
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
- Set up a SQL Server database on a Windows OS.
- Install and configure Jira Service Management Data Center on a Windows OS.
- Create a project with a Number Field.
- 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.