Recent Topics
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
All loads are failing and there is no explanation as to why. Adjust to never leave no error log
All loads are failing and there is no explanation as to why. Adjust to never leave no error log https://app.skyvia.com/#/76069/packages/156168/debug
loads are failing
Hi, All loads are failing and there is no error message please we need to solve this ASAP Thanks
Default changes entity set name
We have several data source tables from our SQL Server database that Skyvia, by default, is renaming the entity set name by adding an 's' at the end (which I found out recently in the documentation). Some of our source table names are long, so I didn't
version control for endpoints
Is there any way to do version control for endpoints? It would be helpful to see when changes were made to an endpoint other than the last modified date (and even more helpful if we could rollback to a previous version!).
cannot connect skyvia with jira sm
Hi team, I'm trying to connect skyvia with jira sm but the following error appears
it is Sunday an all packages are hanging, nothing can be restarted!!!
and nobody from support is available I need a panic button, where I can restart our environment on weekends, when no Skyvia help is available. I cancelled the packages, and after two hours (!), I wanted manually to start the packages...to no avail. This
Setting a variable in a control flow to a newly created ID
I have a Control Flow that starts with an Action which inserts a row into a SQL Server table, which then returns the ID of the newly created row. The output of the Action is as follows. action_8 { #ImportID } I simply want to store that ID into a variable
Zoho Desk Automation Rerun
Hi, i'm new with automation. I would like to know if it is possible to restart an execution if it fails. best regards marco
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,
Next Page