Originally asked by Lara LG on 14 June 2023 (original question)
Hello,
I am syncing between cloud and server two number fields.
Outgoing from Cloud
replica.customFields.“Parcel ID” = issue.customFields.“Parcel ID”
Incoming in server
issue.customFields.“Parcel ID”.value = replica.customFields.“Parcel ID”.value
I am not sure if the problem is because the format of the number fields or because the number I am trying to send is too long.
1998072491600
Exalate has problems while trying to create an issue in this Jira. Details: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:CustomFieldValue][parentkey,null][customfield,19989][issue,1296261][id,18677470][updated,1686728960135][numbervalue,1.9980724916E12] (SQL Exception while executing the following:INSERT INTO customfieldvalue (ID, ISSUE, CUSTOMFIELD, UPDATED, PARENTKEY, STRINGVALUE, NUMBERVALUE, TEXTVALUE, DATEVALUE, VALUETYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Data truncation: Out of range value for column 'NUMBERVALUE' at row 1)) - org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:CustomFieldValue][parentkey,null][customfield,19989][issue,1296261][id,18677470][updated,1686728960135][numbervalue,1.9980724916E12] (SQL Exception while executing the following:INSERT INTO customfieldvalue (ID, ISSUE, CUSTOMFIELD, UPDATED, PARENTKEY, STRINGVALUE, NUMBERVALUE, TEXTVALUE, DATEVALUE, VALUETYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Data truncation: Out of range value for column 'NUMBERVALUE' at row 1))
Any tips on what might be the issue?