Package takes long hours to get from Queued to Running and then not canceling
Hi, I have a package (165800) synchronizing Zoho tables into BigQuery. This package is scheduled to run every hour. This package has been running smoothly for years until recently. In the last 2-3 weeks it is going into Queued state and stay there for
Transfer Webhook request with file blob file to SFTP
Hi, I'm new here. I'm trying resolve problem. I need Call API endpoint(Webhook) with json and request contain file blob next I have to store store that file in SFTP. Any one have issue like this?
Vendor Import Fails Due to Customer Name Conflict Check
Dear Skyvia Support Team, We are experiencing another issue during Vendor data import. While importing records into the Vendor table, the process is validating the name against the Customer table. If the same name already exists as a Customer, the import
Connector MS Business Central - correct setup implementation?
Hello, regarding: https://app.skyvia.com/#/186447/connections/new 1. Looking for the help-document shows, it is written for on-premise not for cloud. 2. Sign in with Microsoft takes you to Microsoft Dynamics ERP, not to business central (cloud). This
Issue with Special Characters in Vendor GivenName Column
Dear Skyvia Support Team, We are currently facing an issue while syncing vendor data through Skyvia. The integration is failing when special characters are included in the Vendor GivenName column. It appears that special characters are not being accepted,
Unable to Query Salesforce & Database : Action Could not be empty
Hello, I am facing an issue while trying to Parse Salesforce or Database. Skyvia returns the error “Action could not be empty,” while using "Execute Query or Execute command" Could you please advise what could be causing this issue? If this is a known
A message error
Hello, I can't integrate a CSV file to Skyvia because I have this error message. A CSV file field is incorrectly enclosed in qualifier characters or contains an unescaped qualifier. I don't have thatcomma, colon, semicolon on my file. I don't get where
JIRA unauthorized_client
Why did the loading error start? the user did not have a profile change. https://app.skyvia.com/#/76069/packages/213996/debug Run Id 235274938 Error while retrieving an access token occurred. Error type: unauthorized_client.
Integration keeps failing
I have tried various troubleshooting steps and the integrations keeps failing. Please contact me ASAP
Removal of Junk Tables with IDs Automatically Generated during Ingestion via Dynamics API
Hello, When ingesting Dynamics data for Snowflake, we identified that, in addition to the correct tables (such as account, quote, annotation), the system is creating additional unwanted tables, with unique identifier suffixes. These "garbage" tables have
cannot connect skyvia with jira sm
Hi team, I'm trying to connect skyvia with jira sm but the following error appears
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.`
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)
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
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?
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:
Not able to use External Id of an Account on Contact Upsert through Data Flow
Hi I am not able to use External Id of an Account on Contact Upsert through Data Flow Object 'Contact' does not have field 'Account.Legacy_Record_ID__c'. Can you please share the right configuration for external Id mapping with related objects upsert
Package imported same data multiple times
Run ID: 184418611 We ran an import from a csv file into D365, the execution took a very long time to run but then gave us the below error. However we then noticed that the data actually went into D365 and repeated for 6 times. Can you please provide us
Unable to Parse range
I am getting the following error which I cannot seem to fix Integration failed: Invalid data[2010]: Unable to parse range: ComplaintsData!C0:C0 Error code: 400
Incorrectly receiving message You have reached a limit of CSV records.
I experience this error all of a sudden: You have reached a limit of CSV records.. Counting all the records in the runs of this month (which has just started), it doesn't add up at all to the number of CSV records I am credited for (200k). Previous months
Facing issue in opening task of integration package
Facing issue in opening task or creating new task for integration package it is saying please provide a valid connection (and showing time out) while in edit and test connection every thing is fine and says connection is valid. not sure what is the issue
Salesforce Reports Ran Through Skyvia Missing Data
When exporting and running a joined, 2000+ row Salesforce report through Skyvia, none of the columns from the joined objects are included in the exported CSV, and no rows past row 2000 are included. Is this a limitation of Skyvia? Of Salesforce? Is there
Dynamics Consider adding missed privilege to one of the principal (user/team) roles.
How to solve this problem? https://app.skyvia.com/#/76069/packages/208651/debug Principal user (Id=a65d00e1-4d83-eb11-a812-002248367004, type=8, roleCount=7, privilegeCount=349, accessMode=0, MetadataCachePrivilegesCount=11773, businessUnitId=4eb55f42-9424-e911-a957-000d3ac1be86),
HubSpot Replication not deleted rows from LineItems
We are using the Skyvia replication from HubSpot to a MySQL data warehouse. The replication is set up as for Incremental Updates. We are noticing on the LineItems of a deal, after they have been replicated to the database this behavior. 1) If new line
Google Big Query Doesn't Support JSON, ARRAY or STRUCT types
When working with Array or Struct types in BigQuery you cannot select any columns using these types for mapping. Having JSON type columns crashes the task creation wizard stopping you form being able to create a mapping.
Woocommerce / impossible to get product VARIATIONS sales
Hi, Everything's fine with my Skyvia / woocommerce connection, except the fact that it looks impossible to get product variations sales. I can get product total sales, I can get some product variation informations, but I can't get product variations sales,
No support for Affinity API field that is an array of objects
We are trying to export data from the affinity organizations API, docs here: https://api-docs.affinity.co/#the-organization-resource The list_entreies field is an array of objects according to the documentation, skyvia shows this as TEXT field in the
Completed integration / import shows as running and fails after 30 minutes after data successfully imported
Seeing odd behavior in UI and import / upsert from MySQL to SQL server: Initiated manual run to upsert 25K rows from MySQL to SQL. I see correct data being pulled into SQL and all rows transfered within few minutes, During this time no activity visible
'Trusted Devices' IPs listing Cloudflare instead of actual source
Hello, Theres something wrong with how 'Trusted Devices' are being logged here: https://app.skyvia.com/#/profile/two-factor-authentication Since at least June 1st, 2023, 100% of the IP address access logs against my account are listing Cloudflare proxy
undecipherable error
What clear explanation for the error of this execution? Run Id 152661201 quoteObject error Hide details Timeouts are not supported on this stream.
Dataflow not working
Why did Run Id 150581815 run for 127 hours? The tool needs to have an automatic cancellation mechanism and better log detail.
What detailed explanation for this error?
What detailed explanation for this error? https://app.skyvia.com/#/76069/packages/219228/debug 150831150 Error Sql error: Generic SQL error. CRM ErrorCode: -2147204784 Sql ErrorCode: -2146232060 Sql Number: 0
Run Id 150406607
It has to automatically cancel when a run has been running for more than 2 hours and restart it automatically. I no longer have any answers to tell users about delay in loads.
What is the cause of the error?
What is the cause of the error? It's a new package, with automatic creation by Skyvia, how can it give an error? https://app.skyvia.com/#/76069/packages/227362/debug
why did it run successfully, a short time later it doesn't run anymore?
why did it run successfully, a short time later it doesn't run anymore? Run Id 148445645 Date Jul 27, 2023 8:24:40 AM State Failed Run Id 148442409 Date Jul 27, 2023 7:52:03 AM State Succeeded
Enable logs for Skyvia users to see the issue
why did 148452273 run successfully, but 148456582 immediately failed? Enable logs for Skyvia users to see the issue. https://app.skyvia.com/#/76069/packages/166398/debug
Bug package dynamics to snowflake
Integration packs are not running. And it is not possible to see the error in the log. Even if the message "Click on quantity for preview and export errors" appears, there is no way to click.
Building a connection to a SQL Virtual Machine
Trying to build a connection to a SQL Virtual Machine for SQL Server. However, I am having some trouble with setting it up. How can I go about doing this?