Skip to main content

Data Integration

Ask questions, get answers, and engage in discussions about data integration solutions from CData.

97 Topics
A
AmbroseApprentice
asked in CData Sync
EXCEEDED_ID_LIMIT: there are '600000' or more records deleted in the specified time period. Please retry getDeleted() call using a shorter time period.

I am using cdata sync and getting the error “EXCEEDED_ID_LIMIT: there are '600000' or more records deleted in the specified time period. Please retry getDeleted() call using a shorter time period.”I have seen other posts say to use a Full vs partial copy but I am not sure that is something that Cdata sync does.   Is there a way go get beyond this error in cdata or salesforce?

1
E
1 year ago
B
bdempseyApprentice
asked in CData DBAmp
DBAMP Patches and Hotfix Plans

Is there a patch / hotfix official release schedule for DBAMP? There must be some fixes since the official V2022 release.  I did get some Hotfix patches but was wondering if I am to expect an official 2023 or 2022.1 release. I currently have to restart the windows service each night to prevent crashes.

1
E
1 year ago
D
Deb Cobb_PMMEmployee
posted in CData Sync
New Sync release - modern UI and even better hybrid cloud connectivity

Our newest Sync release is now generally available! In this release, as part of our ongoing work to improve the Sync user experience, we employed a Voice of the Customer methodology, soliciting and listening to customer feedback about navigation flows, tasks that would benefit from a more streamlined approach, and the need for improved schema support for common use cases. Read the blog to learn more.

0
D
1 year ago
D
Dani MoranEmployee
asked in CData DBAmp
I can't run any command using bulkapi!

Whenever I try to use the bulkapi, or pkchunk, or even just use SF_Mirror on a large table, it says that SF_Mirror fails. The message output looks like this:--- Starting SF_Mirror for Account V830410:53:19: Parameters: salesforce2022 Account bulkapi Version: V830410:53:19: DBAmpAZ 22.0.8304.0 Copyright c 2021 CData Software, Inc.10:53:19: Using options specified in Options parameter: bulkapi10:53:19: Obtaining Connection Props10:53:28: Obtaining User Information10:53:31: Using settings from Registry.10:53:33: Error: DBAmpWork directory does not exist.10:53:33: DBAmpAZ Operation FAILED.10:53:33: Error: MirrorCopy program was unsuccessful.10:53:33: Error: Command string is C:\"Program Files"\CData\"CData DBAmp"\bin\DBAmpAZ.exe MirrorCopy "Account"  "DL-7KVJRL3"  "salesforce_backups2022"  "salesforce2022"  "bulkapi"--- Ending SF_Mirror. Operation FAILED.Msg 50000, Level 16, State 1, Procedure sf_mirror, Line 173 [Batch Start Line 1]--- Ending SF_Mirror. Operation FAILED.

3
D
1 year ago
T
tc_1Apprentice
asked in CData DBAmp
Replacement for Replicate_KAV

I’ve upgraded to the CData version of DBAMP, and I see that there is no longer a separate procedure for replicating the KnowledgeBase.  Is there a replacement process for this sync?

1
D
1 year ago
D
Dani MoranEmployee
asked in CData DBAmp
SF_Refresh tells me that I've exceeded ID limit

When I run SF_Refresh on one of my tables, I get the error "EXCEEDED_ID_LIMIT: there are '600000' or more records deleted in the specified time period" and it won’t complete. How can I run SF_Refresh on that table?

1
D
1 year ago
D
Dani MoranEmployee
asked in CData DBAmp
Replicating fails for my big tables

When I run SF_Replicate on my tables with lots of fields, like Account and Case, it fails. SF_Mirror also fails, and I can’t run SF_Refresh because there’s been a field added so it just tries to run SF_Replicate anyway. The message output looks like this:--- Starting SF_Replicate for Account V5.1.812:58:41: Parameters: Salesforce Account  Version: V5.1.812:58:41: DBAmpAZ 5.1.8.0 Copyright c 2021 CData Software, Inc.12:58:41: Using options specified in Options parameter: soap12:58:42: Using settings from Registry.12:58:42: Using FullCopy to replicate the Account table.12:58:42: Server: DL-7KVJRL3, Database: olddbamp, Linked Server: Salesforce12:58:42: Using the Salesforce SOAP API.12:58:43: Opening SQL Server rowset12:58:43: Error: Commit failed.Source: Microsoft SQL Server Native Client 11.0Description: The statement has been terminated.Source: Microsoft SQL Server Native Client 11.0Description: Cannot create a row of size 8107 which is greater than the allowable maximum row size of 80

1
D
1 year ago
D
Dani MoranEmployee
asked in CData DBAmp
New standard fields not showing up

Salesforce added a couple new fields to the Contact and Lead objects, GenderIdentity and Pronouns. I can find them in Data Loader and in Workbench, but DBAmp is not bringing them down. How do I get DBAmp to find those new fields? I have DBAmp v22, if that makes a difference.

1
D
1 year ago
E
Elizabeth GEmployee
asked in CData DBAmp
Will enabling MFA affect DBAmp?

My organization is trying to enable MFA in Salesforce. Will this affect DBAmp's ability to function?

1
E
1 year ago
D
Deb Cobb_PMMEmployee
posted in CData Sync
CData Sync flyer datasheet

Take a look at CData Sync capabilities.

1
John C
1 year ago
James T
James TEmployee
asked in CData Sync
Why don't I see any records returned for my Sage Intacct tables?

I know I have data in my source but there a 0 records returned in my destination!

1
James T
1 year ago
E
Eric PEmployee
asked in CData Sync
Is there a migrate button on Sync?

I’m currently in the process of changing machines and I do have a lot of jobs and connections in my Sync machine, does Sync have a migrate feature that could help me transfer all the jobs and connections in an easier way or do I need to manually recreate all the connections and jobs?

1
E
1 year ago
B
Ben REmployee
asked in CData Sync
Error when trying to create and save a new connection in CData Sync

When I try to configure a new connection in CData Sync, I click the “Create & Test” button, then an error is displayed:“Add the connection failed: attempt to write to a readonly database”

1
B
1 year ago
O
OmarEmployee
posted in CData Sync
How do I get Databricks running with CData Sync?

I’m having an error with Sync timing out Databricks clusters when starting up, I’ve tried modifying the job timeout and connection timeout but haven’t been able to solve it.I’m also getting “Failed to check the directory status” 500 errors, what’s going on?

1
O
1 year ago
J
JonathanEmployee
asked in CData Sync
Rename job in CData Sync

I created a job in Sync, but decided I want to change the name I gave the job. However, I don’t see an option in Sync’s UI to do this. Am I able to rename a job in Sync once it’s been created?

1
J
1 year ago
M
Mike REmployee
asked in CData Sync
How do I enable CData Sync as a Windows service?

I want to be able to run Sync as a Windows service so that it can start automatically when I turn on my laptop.

1
M
1 year ago
M
MahaEmployee
asked in CData Sync
What is the recommended method to add a column to a replicated table recording when the data was synced by CData?

What is the recommended method to add a column to a replicated table recording when the data was synced by CData? Is there a built-in feature or a custom query?

1
M
1 year ago
D
Dani MoranEmployee
asked in CData DBAmp
I upgraded and now my stored procedures don't work

I upgraded to v22, and followed the instructions to set up a new linked server. Querying it works fine, but I can’t use the stored procedures. I get something like this every time:--- Starting SF_Replicate for account V5.1.811:34:36: Parameters: salesforce2022 account  Version: V5.1.811:34:36: DBAmpAZ 5.1.8.0 Copyright c 2021 CData Software, Inc.11:34:36: Using options specified in Options parameter: soap11:34:40: Retrying11:34:40: Retrying11:34:40: Retrying11:34:40: Error: Unable to retrieve settings from Registry.11:34:40: System.Data.SqlClient.SqlException (0x80131904): The OLE DB provider "MSOLEDBSQL" for linked server "salesforce2022" does not contain the table "sys_sfsession". The table either does not exist or the current user does not have permissions on that table.   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateO

1
D
1 year ago
D
Dani MoranEmployee
asked in CData DBAmp
Do I have to name the database salesforce backups?

When I went through the directions here, https://cdn.cdata.com/help/AFH/dbampd/Installation_Upgrading.html it says to create a database for the stored procedures called salesforce backups. That doesn’t fit our naming conventions - is there a way around that?

1
D
1 year ago
R
rariegEmployee
asked in CData Sync
How to generate CData Sync logs

Hello,I am having issues trying to generate logs in CData Sync. Could someone help me with it?

1
R
1 year ago
D
Dani MoranEmployee
asked in CData DBAmp
I installed the new DBAmp and the provider is missing

After I installed this new DBAmp v22, I tried to remake the linked server I had before, but the DBAmp.DBAmp provider wasn’t in the list. How do I get the provider?

1
D
1 year ago
D
Dani MoranEmployee
asked in CData DBAmp
DBAmp commands failing with timeout errors

Whenever I try to do anything with the linked server, I either get an error about the OLE DB provider returning a message that the “Login timeout expired” or “TCP Provider: The wait operation timed out.” Sometimes it also says "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible.” I can’t do anything with DBAmp, how do I fix this?

1
D
1 year ago
Virtual Event: Data Virtualization, Reimagined Ma”arch 14, 2024 style=

Badge winners

Show all badges
Terms and ConditionsCookie settings