Error in Skyvia: "Value was either too large or too small for an Int32" and issues with query in DataFlow

Error in Skyvia: "Value was either too large or too small for an Int32" and issues with query in DataFlow

Hi Skyvia Support Team,

I am encountering two issues related to the integration between Jira and Skyvia, specifically in a DataFlow that uses a query as its source.

Issues Identified

1. Int32 Data Type Error in the IssueWorklogs Table

While synchronizing time tracking data from the IssueWorklogs table, I receive the following error:

Error:
Value was either too large or too small for an Int32.: [Value: '8432755200', Table: "IssueWorklogs", Column: "TimeSpentSeconds", Id: '']

  • Affected Table: IssueWorklogs
  • Specific Column: TimeSpentSeconds
  • Problematic Value: 8432755200
    This value exceeds the allowable range for an Int32 data type (-2,147,483,648 to 2,147,483,647).

Impact: This error prevents the DataFlow from successfully synchronizing the time tracking data.