# Integration with Skyvia **URL:** \ **Category:** APIs & Integrations\ **Tags:** developer-tools, object, contacts\ **Created:** [March 25, 2019, 4:58pm UTC](https://community.hubspot.com/t/integration-with-skyvia/13670 "2019-03-25T16:58:57Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![tromero](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/tromero/32/84335_2.png) [@tromero](https://community.hubspot.com/u/tromero)\ **Post date:** [March 25, 2019, 4:58pm UTC](https://community.hubspot.com/t/integration-with-skyvia/13670/1 "2019-03-25T16:58:57Z")
Hi, we tried to integrate our Hubspot Data with Skyvia. The tables were created in our SQL server; however they are empty and we are getting a failure error. Skyvia has checked their additional logs and saw that error comes from HubSpot. Can someone please take a look at this so the issue can be fixed? Thanks! ---
**Author:** ![IsaacTakushi](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/isaactakushi/32/70387_2.png) [@IsaacTakushi](https://community.hubspot.com/u/IsaacTakushi)\ **Post date:** [March 27, 2019, 5:33pm UTC](https://community.hubspot.com/t/integration-with-skyvia/13670/2 "2019-03-27T17:33:52Z")
Welcome, @tromero. Happy to help. To troubleshoot effectively, though, I’ll need more information. In fact, it will be easiest to resolve this for you if your contact at Skyvia joins this thread as well. Would you: 1. Confirm whether your account’s Hub ID ends in **8235**? 2. Share the text or a screenshot of the “failure error” you get in Skyvia. 3. A request URL Skyvia is using, which fails. (This will have to come from Skyvia.) 4. If applicable, the raw request body from Skyvia, including headers. (This will have to come from Skyvia.) 5. The _full_ error response Skyvia sees in their logs. Without knowing what calls Skyvia is making and the responses their app is receiving, I have no way to isolate the issue. I appreciate your assistance and look forward to getting to the bottom of this. ---
**Author:** ![tromero](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/tromero/32/84335_2.png) [@tromero](https://community.hubspot.com/u/tromero)\ **Post date:** [March 28, 2019, 9:30am UTC](https://community.hubspot.com/t/integration-with-skyvia/13670/3 "2019-03-28T09:30:45Z")
Thanks a lot for your response Isaac! I can confirm our account HubID ends in 8235. We tried to use the integration and backup products from skyvia and both of them are failing. The error for the integration is: 19251087 Failed Internal error Mar 14,2019 3:01 AM 2 min 48 sec The error for the backup is: Contacts internal error I have shared your questions with Skyvia, as soon as I get an answer I will get back to you. I have also asked them if I can include them on this thread. Thank you so much for your help! ---
**Author:** ![MariiaZ](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/mariiaz/32/27089_2.png) [@MariiaZ](https://community.hubspot.com/u/MariiaZ)\ **Post date:** [April 3, 2019, 10:33am UTC](https://community.hubspot.com/t/integration-with-skyvia/13670/4 "2019-04-03T10:33:30Z")
Hello Isaac! I’m Mariia from Skyvia Team. We performed extended logging for data integration package with an error. We can provide you with the full log file, please specify the best way to do this. Log file contains all requests sent to HubSpot, with headers and information about the error. According to the log file Skyvia is retrieving data from HubSpot - data is returned page by page, 250 records per 1 API call. Each result contains an offset (pointer) to the next page. This offset is used in the subsequent API call. On one of such calls the error occurs. ---
**Author:** ![IsaacTakushi](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/isaactakushi/32/70387_2.png) [@IsaacTakushi](https://community.hubspot.com/u/IsaacTakushi)\ **Post date:** [April 3, 2019, 7:33pm UTC](https://community.hubspot.com/t/integration-with-skyvia/13670/5 "2019-04-03T19:33:14Z")
It’s good to hear from you, @MariiaZ! Could you send the log file to my email? I will direct message you my email address. To be clear, could you send me a log of **only the calls for @tromero’s account (ending in 8235)**? I won’t be able to look through a log of _all_ of your app’s calls to all HubSpot accounts. Also, could you specify which endpoint is consistently returning a `500` error? Is it the [Get all deals](https://developers.hubspot.com/docs/methods/deals/get-all-deals) endpoint? Additionally, are you seeing one particular`offset` value always fail? I should be able to find the above information in the log file, but it saves me time if you already know where I should look! ---
**Author:** ![MariiaZ](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/mariiaz/32/27089_2.png) [@MariiaZ](https://community.hubspot.com/u/MariiaZ)\ **Post date:** [April 4, 2019, 9:26am UTC](https://community.hubspot.com/t/integration-with-skyvia/13670/6 "2019-04-04T09:26:39Z")
Hi @IsaacTakushi ! I have sent you log file, please check your email. The log file is related to @tromero’s account and shows an error on Contacts table. We have some more customers who get “internal error” on reading Contacts, Deals and Engagements, however, we did not perform extended logging for their packages and we cannot provide you with more details. Please look at the log file and let me know if you have any further questions. Best regards, Mariia ---
**Author:** ![IsaacTakushi](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/isaactakushi/32/70387_2.png) [@IsaacTakushi](https://community.hubspot.com/u/IsaacTakushi)\ **Post date:** [April 4, 2019, 9:58pm UTC](https://community.hubspot.com/t/integration-with-skyvia/13670/7 "2019-04-04T21:58:55Z")
Hi, @MariiaZ. Thank you for sending that file along! The file contains five hundred and two `GET` requests to various HubSpot endpoints. Two-thirds of the way through, I see the `500` error, triggered by a query to the [Get all contacts](https://developers.hubspot.com/docs/methods/contacts/get_contacts) endpoint: `https://api.hubapi.com/contacts/v1/lists/all/contacts/all?vidOffset=32069401&count=250&property=x&property=y&property=z&property=etc`. I have replicated this exact request multiple times in Chrome, Firefox, and the REST Client [Postman](https://www.getpostman.com/downloads/) with `200` OK responses every time. Since every test has returned contacts and I cannot reproduce the `500` error, I have to believe these are transient timeouts. HubSpot has seen slightly elevated rates over the past week, which might be why you’re seeing them more frequently. That said, the overwhelming majority of transient errors can be resolved after a single retry. (Again, I wasn’t able to get a `500` error in all of my tests.) Can you confirm whether Skyvia retries requests which fail after a short delay? This should almost universally resolve these types of issues for our mutual customers. We recommend that all our integrators use some mechanism to retry `500` errors. If you are seeing `5XX` errors which are _consistently reproducible_ (i.e. with a specific`vidOffset`value), please let me know. ---
**Author:** ![tromero](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/tromero/32/84335_2.png) [@tromero](https://community.hubspot.com/u/tromero)\ **Post date:** [April 12, 2019, 11:42am UTC](https://community.hubspot.com/t/integration-with-skyvia/13670/8 "2019-04-12T11:42:58Z")
Hi @MariiaZ !! Do you have any feedback? thanks! Tania ---
**Author:** ![IsaacTakushi](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/isaactakushi/32/70387_2.png) [@IsaacTakushi](https://community.hubspot.com/u/IsaacTakushi)\ **Post date:** [April 12, 2019, 12:27pm UTC](https://community.hubspot.com/t/integration-with-skyvia/13670/9 "2019-04-12T12:27:02Z")
Hey, @tromero! For context, I’ve been working with another Skyvia customer through our [customer support channel](https://help.hubspot.com/) who is encounters similar `500` errors. We haven’t been able to reproduce those errors, either, so also seem to be transient. Per my last message, @MariiaZ: Can you confirm whether Skyvia retries requests which fail after a short delay? This should almost universally resolve these types of issues for our mutual customers. We recommend that all our integrators use some mechanism to retry `500` errors. If you are seeing `5XX` errors which are _consistently reproducible_ (i.e. with a specific`vidOffset`value), please let me know. ---
**Author:** ![MariiaZ](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/mariiaz/32/27089_2.png) [@MariiaZ](https://community.hubspot.com/u/MariiaZ)\ **Post date:** [May 20, 2019, 12:42pm UTC](https://community.hubspot.com/t/integration-with-skyvia/13670/10 "2019-05-20T12:42:59Z")
Hi @IsaacTakushi , @tromero ! Sorry for the delayed response. We have improved retry logic on Skyvia side and this should solve this issue. We plan to update Skyvia with these changes soon. We will definitely notify our customers when it is done. Best regards, Mariia Skyvia Team ---
**Author:** ![IsaacTakushi](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/isaactakushi/32/70387_2.png) [@IsaacTakushi](https://community.hubspot.com/u/IsaacTakushi)\ **Post date:** [May 20, 2019, 1:07pm UTC](https://community.hubspot.com/t/integration-with-skyvia/13670/11 "2019-05-20T13:07:57Z")
Thanks for the update, @MariiaZ! ---
**Author:** ![johnelmer](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/johnelmer/32/55984_2.png) [@johnelmer](https://community.hubspot.com/u/johnelmer)\ **Post date:** [March 28, 2021, 3:44pm UTC](https://community.hubspot.com/t/integration-with-skyvia/13670/12 "2021-03-28T15:44:55Z")
@IsaacTakushi @I know this is an older thread, but for anyone struggling with connecting HubSpot to a SQL Server data warehouse there is a low cost solution. We offer an app in the HubSpot App Marketplace called [MS SQL Server for HubSpot](https://app.hubspot.com/ecosystem/2756921/marketplace/apps/marketing/data-management/mssql-replicator) . The app pulls your HubSpot data into a SQL data warehouse via prebuilt API connectors. A SQL data warehouse in Azure is included in the cost. Once your HubSpot data is in the data warehouse, it automatically refreshes on a scheduled basis. You can connect the SQL data warehouse to any other application that has a SQL connector.