By creating an issue and complete the phone field if we introduce the value 5,491,133,494,903 one errror occurs.
"Error creating issue: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:CustomFieldValue][id,4785227][issue,768222][numbervalue,5.491133494903E12][parentkey,null][customfield,10311] (SQL Exception while executing the following:INSERT INTO customfieldvalue (ID, ISSUE, CUSTOMFIELD, PARENTKEY, STRINGVALUE, NUMBERVALUE, TEXTVALUE, DATEVALUE, VALUETYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (Data truncation: Out of range value for column 'NUMBERVALUE' at row 1))"
How can we do to enter that phone number belongs to Argentina (Buenos Aires)?
I searched Atlassian documentation but it is not clear to my version of JIRA (v6.1.1#6155-sha1:7188aee)
Thanks!
Hi, if the number is saved in the db as a 32 bit int you must have gone about the limit (2,147,483,647 for signed int, and ~ x2 for unsigned). As a workaround you may try storing the phone numbers for string or have 2 fields - one for code and one for the number. Hope that helps
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.