DBSync Cloud Replication and CDM

2022

Page tree

Versions Compared

Old Version 1

changes.mady.by.user Shri Raksha N

Saved on

compared with

New Version Current

changes.mady.by.user Shri Raksha N

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Issue Description:

Salesforce and Microsoft SQL Server Column size mismatch Issue : A column of a table in Microsoft SQL server has an column size lesser than that of column that is mapped with that of configured Salesforce Object so while Replicating the data, The system throws the error of below format. 

SEVERE [Thread-CONSUMER:Opportunity] com.dbsync.salesforce.integration.DBAdapter.commitSynch BATCHED INSERT FAILED:Incorrect syntax near 'r_of_Approved_Transact'.

Solution: 

The issue is because the Microsoft SQL Server limits any column name of a table to be more than fifty characters, To overcome this issue you might have to Rename the column name with no more than fifty characters from the replication tool itself. 

...