Recent Topics
Meaning and troublshooting an issue with a replicated object : 'The type initializer for 'Sql92Parser' threw an exception.'
One of our replicated table threw this exception this morning. What does this error mean and how can I troubleshoot the issue? `The type initializer for 'Sql92Parser' threw an exception.`
Time Tracking table not shown
Hi, i am fetching QuickBooks data through Skyvia and moved it Azure layer. around 53 tables have been moved. i want to see employee working hours and rates but in all these tables no such data is available. on investigation, it is observed that this data
QuickBooks Desktop (Enterprise Edition 23) - Unable to migrate all files data
We are using Skyvia Replication to migrate QuickBooks Desktop Data to Azure Synapse SQL Server. We are unable to migrate some of the data from QuickBooks, specifically Employee & Payroll -> TimeTracking.
Assistance with Downloading Devart ODBC Driver for Skyvia
Hello, I am attempting to connect to my Skyvia SQL endpoint via ODBC, and I have been advised to use the Devart ODBC Driver for Skyvia for optimal compatibility. However, I am unable to locate a download link for this specific driver. Could you please
Multiple Tables Created in Snowflake and Unwanted Files Generated in S3
There is an issue with Skyvia replication packages, where it was expected that only one table would be created in Snowflake, but several tables with alphanumeric names are being replicated automatically. Additionally, "dirty" files (with random names)
Update Asana Custom Task fields using SkyVia
I've created a simple customization to create and update Netsuite Support cases from Asana Tasks. It also closes Asana tasks when an associated case is closed in Netsuite. I need to update a custom task field in Asana but TaskCustomFields and CustomFields
Add Go High Level to Skyvia integrations
With more and more people leaving Active Campaign because of their pricing shenanigans, it would be great to have GHL as an integration option in Skyvia.
Integrations with Salesforce in Queued very long time
All of our Salesforce integations appear to be taking a very long time today. They are in "Queued" for up to an hour before running. Once running they seem to complete as expected. Are there system-wide issues today? Anyone else experiencing these i
Adding Date to Export Task File Name
Is there anyway to add the date that an export is run on an export task with a custom filename? For example: TLMHouseFile{DDmmYYYY}.csv Would produce TLMHouseFile05032024 if I ran it today?
Oracle Connector issue - invalid byte count
Hi Team, We have some setup connection with oracle using Agent. Last couple of days when we try to connect oracle we are getting error invalid byte Count Due to this out data sync is getting failed. Plz let us know solution on this as far as possible
Salesforce - Mailchimp integration - "requested resource could not be found"
I am importing from Salesforce and connecting to Mailchimp. All the fields that were mapped showed up correctly in the log. However, the import was unsuccessful because of the following error: "The requested resource could not be found." What is the requested
Moving an Integration to a different workspace
We are trying to organize our integrations. How do we move existing Integrations to a new Workspace?
Monday.com time outs
Hi, we regularly have the problem that individual objects in our Monday.com integration are not exported to the database due to time outs. Would it be possible to automatically restart the replication for the objects with time out? Best Dominic
Converting Date 14/12/2023 00:00:00 to YYYY-MM-DD format
Hi Team, I am getting the date as 14/12/2023 00:00:00, but my target system expects the date in YYYY-MM-DD format. is there a way/function in which we can convert the date in required format. I tries using date_format function but it is not giving me
No records after import
Hi all, new to Skyvia and have just set up my first integration and got a success message however, the import did hit my 10k record limit, but the target table has no records within it. So can't actually test if it has actually worked to see if it is
Dataflow Errors
I have over 100+ errors when I open the dataflow because expressions like isnull("Record ID") give an error. When I open/edit the expression, the error goes away. Again on refreshing the page, the errors show up. The data flow is not working. It takes
SQLite errors errors using incremental replication with Close.io connector
We keep getting intermittent failures\errors for some of the tables in our Close.IO replication activities. They don't shup up as failures, but seems like the new\changed data is not being picked up and replicated when this happens.
Shopify App Unlisted
I just received this notification in Shopify, concerning the Skyvia app (which we use to backup our 4 Shopify stores for ISO 27001 compliance: This app will be removed from Shopify Skyvia will be removed on October 1, 2024. Are there plans to have the
Issue with SalesForce Upsert
We continuously are getting the below error message. Do you have a solution? Automation failed: action_2: To be able to 'UPSERT' records one of the columns should be marked as 'ExternalId'.
Uploading attachments in Saleforce
Hi, Can Skyvia upload attachment files into Salesforce? I have a few thousand PDF files. Each file is named with the ID of a Contact record. I would like to upload the PDFs as attachments to these records. Does Skyvia support this type of upload? thank
View Quickbooks Desktop custom fields in Skyvia
Hello: I have a Custom field in the Customers table of my Quickbooks Desktop file, but I cannot see this field when querying this table from Skyvia. What could be the problem? Regards
HubSpot backup issue with URI length
Hello Support. We received an email notifying us of an error in a backup job. Looking at the control panel, it is a HubSpot backup job of all our records inside HubSpot. The actual error, as reported by your program, for "Contacts", is: (414) URI Too
Unintended bidirectional sync between MSSQL and Shopify using constant mapping
I can't achieve a one-way synchronization using the constant mapping. Any help or suggestion is greatly appreciated. Setup: Source: MSSQL products table Target: Shopify products Sync Field: A field named Sync in the MSSQL table, set to True for all rows.
Email Notification when throwing error in control flow
Hi, I have a control flow that doesn't send an email when I force an error to throw. I have a master control flow that calls two sub control flows. The sub control flows are each wrapped in Try/Catch. At the end of my master control flow, I check for
External Id not visible in drop down
I'm able to see the External Ids in my target salesforce org but when I'm using upsert operation in data flow I'm not able to see those External Ids in the drop down. So, why is this happening can you please help and make sure that all the external ids
Monday connection issue
Hello, I was just trying to modify our monday.com integrations, but I am getting the following error. Could you please check. Can you please analyse and solve the problem. Thanks!
Slow Data Flow
Why did the package below take longer than 2 hours? it's a simple update. https://app.skyvia.com/#/76069/packages/219228 Run Id: 138180829 Duration: 2 h 9 min 30 sec
Salesforce query takes forever
Hi everyone, I have a very simple query from SF (20 objects, about 20 fields, all exported to the .csv file on FTP). When this query is run in the background, it takes a fraction of a second to complete. However, when I run the same query from the Skyvia
Hubspot Associations
How do I get the Hubspot Associations tables for Custom Objects to show in the list of available tables?
Queue Times Inceasing?
I've noticed job time in queue increasingly lately. Is this something the Skyvia team is aware of? Has anything changed in capacity or prioritization?
How to Incrementally Update SQL Database from QuickBooks Online via Skyvia?
I'm using Skyvia to load data from QuickBooks Online (QBO) into a SQL database. However, I want to avoid reloading all the data each time. Instead, I want to incrementally update my SQL database by only bringing in new records and updating existing ones,
How to Auto-Generate a SQL Schema from QuickBooks Online Data Using Skyvia?
I'm looking for a way to automatically create a SQL database schema based on my QuickBooks Online (QBO) data. I plan to use Skyvia to load the data into my SQL database. The goal is to have a schema that includes all fields from the QBO data, organized
HubSpot EmailEvents API where clause
Thank you. I can work with that. One other question. I changed my Query to this and it comes back quickly: SELECT t.* FROM EmailEvents AS t where (t.CreatedAt > '2024-06-10 12:13:00' and t.type = 'SENT' ) But, if I add one more filter condition below,
SFTP - rename or move file after import or export
With the SFTP connector, Is it possible to rename a file or move files to an archive folder after an import or export?
Session expired or invalid
We are once again running into the below error on a regular basis. I had a ticket about this a while back which turned out to be an issue with the sftp Time to Live (TTL) settings on your end. After my last ticket, it worked a little better but we've
File mask date/time zone mismatched in scheduled import
I am scheduling a file import to run on a daily basis. I have selected UTC/PST as the time zone. The task is executing at the correct time locally, but it is using some other time zone to judge what date to use for the file mask. Is there a setting I
Sorting by Ascending Problem
This issue was brought up a couple weeks ago, and we've troubleshooted with Salesforce to the point of determining this must be something to do with Skyvia connection to our database. On any Contact page in Salesforce, we display several related lists:
Connection Issues - URGENT
Affecting the entire customer service team of over 100 users trying to help our customers. ui.services.connection.api.PartnerConnectionException: EXTERNAL_OBJECT_EXCEPTION: An error occurred while connecting to the external system. Please try again, or
Integration failed: GetResults failed: There is an error in XML document (2, 18127)
Skyvi I am receiving an error that I do not understand. Can someone help? This integration imports MySQL data to Salesforce and I have countless similar working integrations.
Chain control flows?
Hi, Is it possible to chain control flows? I have two control flows, Control Flow A and Control Flow B. When Control Flow A finishes, I would like it to start Control Flow B? Is that possible? I know I could just combine them into one large control flow,
Next Page