Tickets Tagged With:sql-server

0
votes
10
answers
102 views

Category: Bug Reports

When adding Sugar CRM's "Contacts" object to a replication package, getting Unexpected SugarType

I created a connection to a Sugar CRM account. I am using it to create a replication package to replicate information from Sugar to SQL Server. I succesfully added Accounts, ....

Created by antony neely antony neely 21 March 2022.

Latest by Mariia Zaharova Mariia Zaharova 28 April 2022.

0
votes
2
answers
69 views

Category: Questions

Salesforce Record Id not being written back

Hi,  I have a synchronization in place with Salesforce as Source and SQL Server as Target. When I add a row to a table in SQL Server a corresponding record ....

Created by Sean Canny Sean Canny 23 February 2022.

Latest by Sean Canny Sean Canny 25 February 2022.

0
votes
1
answers
36 views

Category: Questions

Skyvia Agent - TLS 1.2 and 1.3 support

I got a message from our clients server manager telling me they will update their servers. They will disable SSL 2.0, SSL 3.0, TLS 1.0 and TLS 1.1   Instead ....

Created by Niels Rossel Niels Rossel 18 January 2022.

Latest by Nataliia Nikulina Nataliia Nikulina 19 January 2022.

0
votes
1
answers
51 views

Category: Questions

Will Salesforce MFA requirement affect my SQL replication connection?

https://help.salesforce.com/s/articleView?id=000352937&type=1 Salesforce will require multi-factor authentication. How does this affect my Salesforce to SQL Server replication OAuth 2.0 connection. I use the web service not the installed agent. ....

Created by HIS Admin HIS Admin 18 January 2022.

Latest by Nataliia Nikulina Nataliia Nikulina 19 January 2022.

0
votes
1
answers
24 views

Category: Questions

Changing name of target table in a Replication Package

Is there a way to modify the target table name when setting up a replication? I am replicating multiple tenants in Pipedrive to a single database and because the primary ....

Created by Woody Chin Woody Chin 11 January 2022.

Latest by Mariia Zaharova Mariia Zaharova 11 January 2022.

0
votes
1
answers
41 views

Category: Bug Reports

Agent that Connects to SQL Server is Failing to Connect

Hi, I'm testing a proof of concept implementation of Skyvia's Salesforce - SQL Server synchronization capability. As part of this I've downloaded and configured an agent on a machine that sits ....

Created by Sean Canny Sean Canny 10 December 2021.

Latest by Nataliia Nikulina Nataliia Nikulina 13 December 2021.

0
votes
8
answers
111 views

Category: Questions

Synchronization creates new row rather than update old row

I have set up synchronization to move data from a website (mysql) to sql server and vice versa. When data is updated on the website, instead of syncing that data ....

Created by John Coolidge John Coolidge 21 October 2021.

Latest by Nataliia Nikulina Nataliia Nikulina 02 November 2021.

0
votes
1
answers
80 views

Category: Questions

Sync Package error Zoho to SQL Server, suspect destination column is to small.

I have encountered an error while running one of my sync packages that syncs data from Zoho to a table in SQL Server.  The sync has run trouble free for ....

Created by Lonnie Chin Lonnie Chin 19 August 2021.

Latest by Nataliia Nikulina Nataliia Nikulina 20 August 2021.

0
votes
1
answers
257 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
113 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
985 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
107 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
107 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
211 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
162 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
252 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
123 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
234 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
186 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
158 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.

Close