Tickets Tagged With:sql
Category: Questions
New Skyvia IP 52.190.252.0
Dear users, Please be informed that Skyvia uses the new IP address 52.190.252.0 to access the databases. If you use firewall applications, please make sure that all three IP addresses ....
Created by
Category: Questions
oData request time outs because there is no "WITH (NOLOCK)"
I am currently experiencing regular time outs when requesting salesorders from SQL database: url: /orders?$filter=ordernr+eq+'22304425'&$expand=orderlines Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server ....
Created by
Latest by
Category: Questions
Error in SQL Execution after connecting to YugabyteDB
Hi, I have a free skyvia account and trying to see if I can connect to YugabyteDB. I connect to the database with no issues, afterward when I try to ....
Created by
Latest by
Category: Questions
SQL Transport Layer Error
Hello Support Team!I'm having an issue with Skyvia importing data into SQL and the issue seems to be inconsisntently happening. Today most of the automatic (Scheduled) package runs were successful ....
Created by
Latest by
Category: Questions
CRUD methods for an odata source in Connect
Hi I have recently created an odata layer in connect for one of my azure sql databases. and would like to know if there is any swagger documentation generated for ....
Created by
Latest by
Category: Questions
Import Error: AccountTrigger: System.LimitException: Too many SOQL queries: 101
I created a task to import and update my customers from an SQL Database to Salesforce, but I'm receiving error in all records. Below is the error message that is ....
Created by
Latest by
Category: Questions
Cannot import from LeadChangeEvent in Salesforce to SQL
How to import data from LeadChangeEvent? I am trying to get information for Converted Leads. ....
Created by
Latest by
Category: Bug Reports
Connection issue when copying from one DB to another
We are trying to copy from one table in one database to another table in another database. BOth the connections are available But when we run the job it says ....
Created by
Latest by
Category: Bug Reports
Replication - Async API not enabled for this Salesforce account. Disable Bulk API.
Hi, I have a replication set up that pulls my salesforce data into SQL. I have professional edition so I am using the SOAP API and we have not exceeded ....
Created by
Latest by
Category: Questions
Getdate() Generate error in SQL to Marketing cloud
Hi How could I use getdate() in sentences sql to Marketing cloud,? I tried getdate() but this generated error Thanks for your help ....
Created by
Latest by
Category: Questions
Timeout on SQL Integration
Hi, one of my integrations with SQL keeps failing with a timeout error. The integration is selecting from a SQL view, which does take some time to pull the data. ....
Created by
Latest by
