The data type size in database and salesforce are not the same for some fields.
We tried to troubleshoot from the article in help.mydbsync.com ‘http://help.mydbsync.com/docs/display/CloudReplication/Mismatch+in+Data+Type+Size’
But the same issue again, we use Dbsync Cloud Replication 4.0
Let’s know what properties we need to change to overcome this issue.
Suppose on the “Account” object for the field “Tradestyle” with size and datatype as “Text(255)”, if the size and datatype needs do be modified to a size of “VARCHAR(500)”, use the property “FORCE.TRADESTYLE=varchar(500)” in the system.properties file.
system.properties file can be found under <>/ dbsync-repl /WEB-INF / db /conf /
Once the property is added please restart the dbsync server.