Recent Topics
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
Zoho Projects automation - Insert task failures on specific fields
I have been trying out the new automation tools, finding them pretty cool but having some headaches with the Zoho Projects connector. To be honest I think the issue is Zoho's absolute mess of a schema (and lack of consistency therein). I have an action
Exporting logs as .CSV
I am having issues exporting logs from the log preview window. I am seeing title.error files in my downloads instead of usable title.csv files. Thank you, Noah
Slow query
Slow query. Why is the query below taking so long? This slows down the Data Flow. When looking at the package you will see that the speed is faster select sim.opportunityid,sim.csh_origem,sim.csh_mktcanal,sim.csh_term,sim.csh_mktcampanha,sim.csh_urlcampanha
Data flow stfp connection fails while normal import works
I've run into a situation where I would prefer to use dataflow but for some reason when I try to run the sftp file through data flows I get the error, 'an established connection was aborted by the server'. I know that the connection is working, however
Amplitude query running for long periods of time with no output
Hi, I have written a query to pull data from Amplitude, but the task runs for a long time and produces no output - here is the url of the export task: https://app.skyvia.com/#/151008/packages/228237 Does the query in the task look okay in your opinion?
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.
Can I create a custom inbound webhook to receive POST data?
We use this platform for client survey data: https://formcrafts.com There's no integration available in Skyvia but Formcrafts over the ability to pipe survey responses into an external API using a webook connection. How to Configure Webhooks (formcrafts.com)
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
Data Flow schedule does not work
The Data Flow schedule of the type to run every 2 hours between 2 hours does not work. I had set the data flow below to run between 10PM and 2AM every 2 hours... but it didn't start. Now I changed it to between 8PM and 4AM to see if it runs. https:/
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.
File Mask for Yesterday, not today
Can I use the file mask to import a CSV that was produced yesterday? The data source I'm using (Toast POS) exports CSV files at 4am for the day prior in a folder structure like this: RestaurantID / yyyyDDmm / TimeEntries.csv So if I run this task at 4:30am
Four jobs are not working AND canceling does not work
It is the end of the workday, support is not availabe... 4 jobs are hanging. Cancel button does not end the tasks. 2 jobs should run hourly, they are fairly small 1 job should run every 4 hours 1 job should run twice a day. Our business has a problem,
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?
Data not inserting at bulk to the target Table.
I've been trying to insert all the data in a table from MySQL to Salesforce. But, it inserts the last row only. ''' SELECT * FROM countries where id > :MaxId ''' This is the query running from the source table
Importing to existing contact records in Salesforce NPSP
Hello, I'm attempting to import opportunities into existing contact records in Salesforce NPSP. I know the contacts have existing account but my lookup is not finding the records. I am currently using a Target lookup that searches the First Name, Last
Zoho Books replication ongoing fails on 2 tables
Hi guys, I've had 2 tables withing the Zoho Books connection continually failing for several weeks now. These are: Contacts Purchase Orders The error received is: Integration failed: For security reasons you have been blocked for some time as you have
Integration Failure: Sandbox Worker Process Crashed
We received an error while performing an integration, with the message stating: The plug-in execution failed because the Sandbox Worker process crashed. This is typically due to an error in the plug-in code. Please refer to this document: https://go.microsoft.com/fwlink/?linkid=2189390
package bug
A bug occurred in the integration below generating a very high cost that we cannot afford. Please eliminate this cost from the invoice. https://app.skyvia.com/#/76069/packages/214395/log?range=last7days&state=Failed In image A, note that it charged 96
Additional billing error
There is an error in the record counter. It is impossible to have charged this value. I suspect it's a bug caused by Data Flow, as that's the only thing we've implemented differently lately.
Convert a String to Date using Expression builder
Hello, Is there a way for us to convert a text string which is dd/mm/yyyy into a date value for importing? Thanks
Data Flow Error
What is the explanation for the error below? Run Id 143814122 Date Jun 30, 2023 1:04:26 AM State Failed Error The content type text/html; charset=utf-8 of the response message does not match the content type of the binding (text/xml; charset=utf-8). If
Airtable Repliaction Set Up Error: Cannot access child value on Newtonsoft.Json.Linq.JValue
Hi there, I am trying to create a replication using an Airtable connector as my source, but am getting the below error when trying to add the Airtable connector: Cannot access child value on Newtonsoft.Json.Linq.JValue https://gyazo.com/40b64b7b4ab0cb6ca96571499d5df398
Scheduled data flow packages that have stopped running.
The 2 data flow packages below have daily scheduling enabled, but in the last few days they have not been executed. https://app.skyvia.com/#/76069/packages/219228 https://app.skyvia.com/#/76069/packages/218908
Expression to replace Multi Picklist fields in Salesforce
Hi, We were wondering if anyone else has implemented this before. We have a Multipicklist field in Salesforce that needs to be mapped to multiple checkboxes in Salesforce, Question 1: Is this the correct way of populating the checkboxes if one of the
Technical feasibility of bi-directional sync JIRA(JSM and JWM) <-> ASANA
The goal of this question is: To validate whether this is possible with Skyvia If it is possible, has anyone here tried to do something like this or do you have any recommendations to point me in the right direction in terms o the approach? Im new to
Data loss within Skyvia platform
On April 12th I used Connectors on Hubspot and ASANA and successfully completed data backups of each. They both finished successfully, and without errors. The data and the associated activity log of events was visible in the dashboard. The data backups
Options for error notifications when scheduled packages execute other packages?
Hi - I was wondering if you have any suggestions for generating failed package notifications when the packages are executed inside a Control Flow, and it is the Control Flow that is scheduled. For an example see package ID 216134. This scheduled Control
FTP connection with DearSystems
I want to connect my FTP to DearSystems for Stock Adjustment. I have a simple CSV that contains SKU and Quantity. I need help with field mapping. Also which subscription plan is suitable for this FTP Integration?
Queue
Hello everyone, What should I know about the queue? and what dictates how long it will be? Does the amount of data change the duration of the queue? Thank you, I am exited to be joining this community. Noah
ActiveCampaign Connector Won't Synchronize ContactCustomFieldValues
We have a connection to our ActiveCampaign account which works well for synchronizing Contacts and ContactCustomFields to MySQL; but when using the same connections to synchronize ContactCustomFieldValues, the integration simply hangs. There are no errors,
How do I populate a custom field with a column from a database?
I have connections to Jira and the database but can't seem to find the documentation on how to do this. Any help is much appreciated!
MS Dynamics connection: Refresh the Access Token error
Hi, we are unable to authenticate using Dynamics OAuth 2.0 connection. We get the following error. {"error":"invalid_client","error_description":"AADSTS7000222: The provided client secret keys for app '6120e4ad-833a-48c0-a0dc-5463afd9dd70' are expired.
Dynamics 365 integrations failing
Some of our Dynamics 365 integrations failed overnight reporting error: Refresh the access token: {"error":"invalid_client","error_description":"AADSTS7000222: The provided client secret keys for app '6120e4ad-833a-48c0-a0dc-5463afd9dd70' are expired.
Package Controls
Hello, I need to know if skyvia has package reprocessing controls and execution controls to have notifications in case of error in the execution of the packages.
Find any information here
General forum for any kind of questions and discussions about Skyvia
Simply connect to any source
Discussion forums for open issues and questions regarding Skyvia Connectors
Publish your data via web API easily
Discussion forums for open issues and questions regarding Skyvia Connect
Next Page