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 ....
Category: Questions
Zoho Books - Missing custom fields in SQL Replication
Hi guys, please can you assist me with a query, I have created custom fields in Zoho Books "estimate' and others. When I try to pull the custom fields "customFieldHash" from the ....
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 ....
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 ....
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 ....
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 ....
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 ....
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. ....
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 ....
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 ....
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 ....
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. ....