Friday 18 May 2018

Error in Sync Job 1130 and 1040 Product Not Sync

Error in Sync Product N-1040 and N-1130 Product Availability
("Process Target Request Header Failed Due to An Invalid Operation Exception")

When running the sync job from Distribution Schedule, we came across this error - "System.InvalidOperationException: The given value of type String from the data source cannot be converted to type nvarchar of the specified target column. ---> System.InvalidOperationException: String or binary data would be truncated.".

Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.ProcessSourceRequestHeaderException: ProcessTargetRequestHeader failed due to an InvalidOperationException.
connectionString: Data Source=CDB;Initial Catalog=RetailBostanciTestStore;Integrated Security=True;Connect Timeout=60;Application Name="Commerce Data Exchange Async Client" ---> System.InvalidOperationException: The given value of type String from the data source cannot be converted to type nvarchar of the specified target column. ---> System.InvalidOperationException: String or binary data would be truncated.


  1. Normally this error comes due to mismatch both databases (AX and Channel DB), We need to Identify which table and which column has changed.
  2. Database Version Mismatch like any CU update or Retail Channel Utility  or Channel database not updated.
I found two tables which is having issue

ECORESPRODUCTTRANSLATION ( Column Name)
* INVENTDIM ( Column WMSLOCATIONID)

Run Query Into SQL on Channel Database 

Alter Table ECORESPRODUCTTRANSLATION  Alter Column Name Nvarchar (90) Not Null
Alter Table INVENTDIM Alter Column WMSLOCATIONID Nvarchar (15) Not Null

No comments:

Post a Comment