Tickets Tagged With:sql-server
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. ....
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 ....
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), ....
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. ....
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. ....
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. ....
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 ....
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 ....
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 ....
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 ....
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 ....
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 ....
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 ....
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 ....
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 ....
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 ....
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 ....
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 ....
Category: Bug Reports
Insertion Failed because the database is full database or disk is full
Ran into this issue today. " An exception has occured during data processing , the message returned from the provider is : Insertion failed because the database is full ....
Category: Questions
Transport Level error when loading 343230 records into Salesforce
I am running a package to import 343230 records into Salesforce. After inserting about 50000 records it gives the following error. A transport-level error has occurred when receiving results ....