Tickets Tagged With:sql-server

0
votes
1
answers
35 views

Category: Bug Reports

Skyvia does not allow me to pull more than 2048 records, then it errors out.

https://app.skyvia.com/#/29060/packages/123786/debug Source Connection is Marketing Cloud using a Data Extension.   Target is a SQL server 2016 connecting through an Agent.    We are using the new runtime.     It ....

Created by Craig Gjerdingen Craig Gjerdingen 05 April 2021.

Latest by Dmitriy Muzurov Dmitriy Muzurov 08 April 2021.

0
votes
3
answers
44 views

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 Technology Specialist Technology Specialist 19 March 2021.

Latest by Dmitriy Muzurov Dmitriy Muzurov 28 March 2021.

0
votes
6
answers
785 views

Category: Questions

Unable to connect to AWS Sql Server for replication from NetSuite

I'm trying to evaluate your replication software using NetSuite as source. For the destination I just created a new AWS SQL Server instance, and set it to be publicly accessible. ....

Created by Ed Zanelli Ed Zanelli 27 October 2017.

Latest by Mariia Zaharova Mariia Zaharova 26 February 2021.

0
votes
1
answers
53 views

Category: Bug Reports

What's the maximum number of column's to select ?

Hey, I have raised a ticket yesterday and with your help have resolved it, but I just have a question about whats the maximum number of coulmun's we can select ....

Created by Chandanesh KC Chandanesh KC 10 February 2021.

Latest by Mariia Zaharova Mariia Zaharova 11 February 2021.

0
votes
1
answers
55 views

Category: Bug Reports

Getting and error while replicating the data from Hubspot to SQL server

Hi all, I'm replicating the data from hubspot to SQL server and all other tables have replicated to the SQL server,but 'Deals" table is giving me an error(Screenshot attached below), ....

Created by Chandanesh KC Chandanesh KC 10 February 2021.

Latest by Mariia Zaharova Mariia Zaharova 10 February 2021.

0
votes
3
answers
74 views

Category: Bug Reports

Not able to map DT_I4 to DT_WSTR

While importing, whenever I try to map an integer field from SQL to string field in Salesforce, system says invalid type map.  ....

Created by Kaushal Kumar Kaushal Kumar 08 August 2020.

Latest by Mariia Zaharova Mariia Zaharova 10 August 2020.

0
votes
1
answers
76 views

Category: Bug Reports

Object reference not set to an instance of an object. - Import SQL to Salesforce

 When importing from the SQL Server to Salesforce, the import package always fails with the error. Object reference not set to an instance of an object. ....

Created by Kaushal Kumar Kaushal Kumar 08 August 2020.

Latest by Mariia Zaharova Mariia Zaharova 08 August 2020.

0
votes
6
answers
121 views

Category: Bug Reports

An item with the same key has already been added.

While exporting a table from sql-server to sftp task always fail stating "An item with the same key has already been added."Please Check. No tasks are working.   ....

Created by Kaushal Kumar Kaushal Kumar 15 July 2020.

Latest by Mariia Zaharova Mariia Zaharova 07 August 2020.

0
votes
3
answers
71 views

Category: Bug Reports

Getting A Task Was Cancelled on Salesforce and Azure SQL Server connections

I'm trying to edit and create some tasks that are transferring data between SF and Azure SQL Server but when I click the add task or edit task buttons the ....

Created by Duyen Doan Duyen Doan 12 July 2020.

Latest by Mariia Zaharova Mariia Zaharova 14 July 2020.

0
votes
3
answers
128 views

Category: Questions

Import job with sql server as source, to get incremental (delta) data changes using LAST_RUN

After initial data sync with SQL Server as source, we are trying to use an import job to pick up delta (new/changed) data. We are comparing the dateUpdated column (datetime datatype ....

Created by robert fisher robert fisher 19 March 2020.

Latest by Dmitriy Muzurov Dmitriy Muzurov 02 April 2020.

0
votes
4
answers
130 views

Category: Questions

Error: Push Order Shipments to BigCommerce

We are facing an error to map our DB table field with BigCommerce Create Shipment integration. Because, BigCommerce API request parameter "items" type is array.   API reference: https://developer.bigcommerce.com/api-reference/orders/orders-api/order-shipments/createordershipments   How we can ....

Created by Australian NaturalCare Australian NaturalCare 18 February 2020.

Latest by Dmitriy Muzurov Dmitriy Muzurov 06 March 2020.

0
votes
2
answers
84 views

Category: Questions

Create Record and Sync

How to question I use an import integration to create records in SalesForce. After this is complete I need SalesForce to update the original SQL data source with the new ....

Created by Ken Banks Ken Banks 25 February 2020.

Latest by Ken Banks Ken Banks 28 February 2020.

0
votes
2
answers
84 views

Category: Questions

Using SQL Server Views

I have a daily package that runs and part of it adds any recently Invoiced Orders to a custom module in zoho crm. I have noticed that it misses quite ....

Created by Ryan Mirto Ryan Mirto 25 February 2020.

Latest by Ryan Mirto Ryan Mirto 28 February 2020.

0
votes
5
answers
108 views

Category: Questions

Upsert to SQL Succeeds, but no data exists?

Hello,   I created a table in SQL that mirrors my Zendesk table (organization). I set the ID column as primary key not null identity, and enabled identy insert. When ....

Created by Ben West Ben West 18 December 2019.

Latest by Dmitriy Muzurov Dmitriy Muzurov 20 December 2019.

0
votes
1
answers
218 views

Category: Questions

Determining identical records during initial sync

I want to setup bi-directional integration between SalesForce and MS SQL Server. The amount of data is very large so we would like to import data beforehand from Source to ....

Created by Vlad Shmulskyi Vlad Shmulskyi 16 May 2019.

Latest by Dmitriy Muzurov Dmitriy Muzurov 17 May 2019.

0
votes
1
answers
258 views

Category: Questions

Unable to connect to SQL Server

Hi All, We are trying to connect to our local database (SQL Server) but even after setting the TCP/IP and Firewall as given in documentation it is not working. Please ....

Created by Darshan Bhattad Darshan Bhattad 09 May 2019.

Latest by Simon Bubnov Simon Bubnov 10 May 2019.

0
votes
2
answers
258 views

Category: Questions

Trying to map invalid data type sql to dynamics 365

1. If I pull data from sql and exported to excel, upload it to skyvia and do upsert to dynamics 365, works fine. If I try to do it straight ....

Created by Andy Le Andy Le 03 April 2019.

Latest by Andy Le Andy Le 04 April 2019.

0
votes
3
answers
291 views

Category: Bug Reports

Large Salesforce tables Replication Fails

My salesforce replication job's are failing to sync for the first time. I've copied details below on the tables affected. I have a lot of records in the tables and ....

Created by Steve Tempest Steve Tempest 07 January 2019.

Latest by Mariia Zaharova Mariia Zaharova 10 January 2019.

0
votes
1
answers
249 views

Category: Questions

Unable to synchronize records between Salesforce and SQL Server

Hello, I'm having trouble getting the syncronization integration between my salesforce account and a table on my sql server to actually syncronize records. I am trying to send salesforce contacts ....

Created by Jeff Monian Jeff Monian 11 July 2018.

Latest by Mariia Zaharova Mariia Zaharova 12 July 2018.

0
votes
3
answers
273 views

Category: Bug Reports

Not able to edit certain Tasks

Hi , We have 10 taks that have the same source (SQL Table) and destination (SFDC object) - The only change is the data selectio criteria.  We were able to edit ....

Created by Michael Kumaraswamy Michael Kumaraswamy 08 December 2017.

Latest by Simon Bubnov Simon Bubnov 13 December 2017.

Close