Data tables return errors

  • 88Views
  • Last Post 23 July 2021
0
votes
Starboard Dev posted this 19 July 2021

I am trying to replicate data from freshdesk to Redshift. When connection between both sources are successfull, there are some data tables that returns an error. Is there any solutions to solve the errors in the data tables?

 

Based on the attached image, when run package, the errors show '' You have reached a linit of records''

 

Attached Files

Order By: Standard | Newest | Votes
0
votes
Olena Romanchuk posted this 23 July 2021

Hello,

Unfortunately it’s not possible to obtain a per-record error log in this case.

As we can see, the error is returned from the Amazon Redshift side.

To see the error message please check 'stl_load_errors' system table for details.

You can see the content of this table in Amazon Redshift UI or using Skyvia Query.

Please share the details with us, we will investigate it and provide recommendations.

We look forward to hearing from you.

 

 

0
votes
Starboard Dev posted this 20 July 2021

Hello,

I have been using a free trial for a standard and the errors is gone. After doing so, I have drop all my DB redshift tables. But, when I run the package again, it returns error. 

0
votes
Olena Romanchuk posted this 19 July 2021

Hello,

The error indicates that the Freshdesk API request limit is reached. When querying Freshdesk tickets via API v2, the amount of required Freshdesk API calls doubles, if you query ticket related fields. It means that to read the data from the 'TicketConversation' , 'TicketNote', TicketDetail' tables Skyvia needs to read each record in the parent 'Ticket' table, that is why the number of API calls is doubled. It is Freshdesk API specifics of implementation.

Regarding the record limits. Skyvia Free pricing plan allows to process up to 5000 records per month for Data Integration product.

As we can see you have reached this limit. It means that you will not be able to launch the Data Integration package until the counter resets. However you can activate a trial for any paid plan. 

More details on subscriptions and trials are available here https://docs.skyvia.com/account-management/subscriptions-payments-and-trials.html

 Should you have any questions please do not hesitate to contact us.

Close