Page tree

Versions Compared

Key

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

This section lists the categories of all the known Issue and resolution steps with DBSync Cloud Replication, To report a bug which is not listed here raise a ticket by clicking on Submit Your Ticket . 

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. 

Follow, the article from the link Rename Table or Column to renaming a column from replication UI