Number Sync giving error because of different formats

 
1
0
-1

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?

    CommentAdd your comment...