Dynamics Community Forum Thread Details

Hi Team,

Hope all are doing well !!!

We are facing below error while doing full sync of 1040 job.

Microsoft.Dynamics.Retail.CommerceDataExchange.ProcessDataPackageException: Error occurred when running SqlTargetRequestHandler. ---> Microsoft.Dynamics.Retail.CommerceDataExchange.SqlMergeRequestRunException: Failed to merge data into table [AX].[INVENTTABLE]. Query: DELETE FROM [AX].[INVENTTABLE];MERGE [AX].[INVENTTABLE] AS dst USING (SELECT [ABCCONTRIBUTIONMARGIN],[ABCREVENUE],[ABCTIEUP],[ABCVALUE],[ALTITEMID],[APPROXTAXVALUE_BR],[BATCHNUMGROUPID],[CNPJ_BR],[COSTMODEL],[DENSITY],[DEPTH],[EXCEPTIONCODE_BR],[EXEMPT_IN],[GROSSDEPTH],[GROSSHEIGHT],[GROSSWIDTH],[HEIGHT],[HSNCODETABLE_IN],[INVENTPRODUCTTYPE_BR],[ITEMBUYERGROUPID],[ITEMDIMCOSTPRICE],[ITEMID],[ITEMTYPE],[NAMEALIAS],[NETWEIGHT],[NONGST_IN],[PRIMARYVENDORID],[PRODGROUPID],[PRODPOOLID],[PROJCATEGORYID],[PROPERTYID],[PURCHMODEL],[RECID],[REQGROUPID],[SALESCONTRIBUTIONRATIO],[SALESMODEL],[SALESPERCENTMARKUP],[SALESPRICEMODELBASIC],[SCALEINDICATOR_BR],[SERIALNUMGROUPID],[SERVICEACCOUNTINGCODETABLE_IN],[SORTCODE],[TARAWEIGHT],[TAXATIONORIGIN_BR],[TAXFISCALCLASSIFICATION_BR],[TAXRATETYPE],[TAXSERVICECODE_BR],[UNITVOLUME],[USEALTITEMID],[WIDTH],[DATAAREAID] FROM [#AX_INVENTTABLE_c772ab42-1532-4328-9c48-712361de48a1]) AS src ON (dst.[ITEMID]=src.[ITEMID] AND dst.[DATAAREAID]=src.[DATAAREAID]) WHEN MATCHED THEN UPDATE SET [ABCCONTRIBUTIONMARGIN]=src.[ABCCONTRIBUTIONMARGIN],[ABCREVENUE]=src.[ABCREVENUE],[ABCTIEUP]=src.[ABCTIEUP],[ABCVALUE]=src.[ABCVALUE],[ALTITEMID]=src.[ALTITEMID],[APPROXTAXVALUE_BR]=src.[APPROXTAXVALUE_BR],[BATCHNUMGROUPID]=src.[BATCHNUMGROUPID],[CNPJ_BR]=src.[CNPJ_BR],[COSTMODEL]=src.[COSTMODEL],[DENSITY]=src.[DENSITY],[DEPTH]=src.[DEPTH],[EXCEPTIONCODE_BR]=src.[EXCEPTIONCODE_BR],[EXEMPT_IN]=src.[EXEMPT_IN],[GROSSDEPTH]=src.[GROSSDEPTH],[GROSSHEIGHT]=src.[GROSSHEIGHT],[GROSSWIDTH]=src.[GROSSWIDTH],[HEIGHT]=src.[HEIGHT],[HSNCODETABLE_IN]=src.[HSNCODETABLE_IN],[INVENTPRODUCTTYPE_BR]=src.[INVENTPRODUCTTYPE_BR],[ITEMBUYERGROUPID]=src.[ITEMBUYERGROUPID],[ITEMDIMCOSTPRICE]=src.[ITEMDIMCOSTPRICE],[ITEMTYPE]=src.[ITEMTYPE],[NAMEALIAS]=src.[NAMEALIAS],[NETWEIGHT]=src.[NETWEIGHT],[NONGST_IN]=src.[NONGST_IN],[PRIMARYVENDORID]=src.[PRIMARYVENDORID],[PRODGROUPID]=src.[PRODGROUPID],[PRODPOOLID]=src.[PRODPOOLID],[PROJCATEGORYID]=src.[PROJCATEGORYID],[PROPERTYID]=src.[PROPERTYID],[PURCHMODEL]=src.[PURCHMODEL],[RECID]=src.[RECID],[REQGROUPID]=src.[REQGROUPID],[SALESCONTRIBUTIONRATIO]=src.[SALESCONTRIBUTIONRATIO],[SALESMODEL]=src.[SALESMODEL],[SALESPERCENTMARKUP]=src.[SALESPERCENTMARKUP],[SALESPRICEMODELBASIC]=src.[SALESPRICEMODELBASIC],[SCALEINDICATOR_BR]=src.[SCALEINDICATOR_BR],[SERIALNUMGROUPID]=src.[SERIALNUMGROUPID],[SERVICEACCOUNTINGCODETABLE_IN]=src.[SERVICEACCOUNTINGCODETABLE_IN],[SORTCODE]=src.[SORTCODE],[TARAWEIGHT]=src.[TARAWEIGHT],[TAXATIONORIGIN_BR]=src.[TAXATIONORIGIN_BR],[TAXFISCALCLASSIFICATION_BR]=src.[TAXFISCALCLASSIFICATION_BR],[TAXRATETYPE]=src.[TAXRATETYPE],[TAXSERVICECODE_BR]=src.[TAXSERVICECODE_BR],[UNITVOLUME]=src.[UNITVOLUME],[USEALTITEMID]=src.[USEALTITEMID],[WIDTH]=src.[WIDTH] WHEN NOT MATCHED THEN INSERT ([ABCCONTRIBUTIONMARGIN],[ABCREVENUE],[ABCTIEUP],[ABCVALUE],[ALTITEMID],[APPROXTAXVALUE_BR],[BATCHNUMGROUPID],[CNPJ_BR],[COSTMODEL],[DENSITY],[DEPTH],[EXCEPTIONCODE_BR],[EXEMPT_IN],[GROSSDEPTH],[GROSSHEIGHT],[GROSSWIDTH],[HEIGHT],[HSNCODETABLE_IN],[INVENTPRODUCTTYPE_BR],[ITEMBUYERGROUPID],[ITEMDIMCOSTPRICE],[ITEMID],[ITEMTYPE],[NAMEALIAS],[NETWEIGHT],[NONGST_IN],[PRIMARYVENDORID],[PRODGROUPID],[PRODPOOLID],[PROJCATEGORYID],[PROPERTYID],[PURCHMODEL],[RECID],[REQGROUPID],[SALESCONTRIBUTIONRATIO],[SALESMODEL],[SALESPERCENTMARKUP],[SALESPRICEMODELBASIC],[SCALEINDICATOR_BR],[SERIALNUMGROUPID],[SERVICEACCOUNTINGCODETABLE_IN],[SORTCODE],[TARAWEIGHT],[TAXATIONORIGIN_BR],[TAXFISCALCLASSIFICATION_BR],[TAXRATETYPE],[TAXSERVICECODE_BR],[UNITVOLUME],[USEALTITEMID],[WIDTH],[DATAAREAID]) VALUES (src.[ABCCONTRIBUTIONMARGIN],src.[ABCREVENUE],src.[ABCTIEUP],src.[ABCVALUE],src.[ALTITEMID],src.[APPROXTAXVALUE_BR],src.[BATCHNUMGROUPID],src.[CNPJ_BR],src.[COSTMODEL],src.[DENSITY],src.[DEPTH],src.[EXCEPTIONCODE_BR],src.[EXEMPT_IN],src.[GROSSDEPTH],src.[GROSSHEIGHT],src.[GROSSWIDTH],src.[HEIGHT],src.[HSNCODETABLE_IN],src.[INVENTPRODUCTTYPE_BR],src.[ITEMBUYERGROUPID],src.[ITEMDIMCOSTPRICE],src.[ITEMID],src.[ITEMTYPE],src.[NAMEALIAS],src.[NETWEIGHT],src.[NONGST_IN],src.[PRIMARYVENDORID],src.[PRODGROUPID],src.[PRODPOOLID],src.[PROJCATEGORYID],src.[PROPERTYID],src.[PURCHMODEL],src.[RECID],src.[REQGROUPID],src.[SALESCONTRIBUTIONRATIO],src.[SALESMODEL],src.[SALESPERCENTMARKUP],src.[SALESPRICEMODELBASIC],src.[SCALEINDICATOR_BR],src.[SERIALNUMGROUPID],src.[SERVICEACCOUNTINGCODETABLE_IN],src.[SORTCODE],src.[TARAWEIGHT],src.[TAXATIONORIGIN_BR],src.[TAXFISCALCLASSIFICATION_BR],src.[TAXRATETYPE],src.[TAXSERVICECODE_BR],src.[UNITVOLUME],src.[USEALTITEMID],src.[WIDTH],src.[DATAAREAID]) OPTION (MAXDOP 1); DROP TABLE [#AX_INVENTTABLE_c772ab42-1532-4328-9c48-712361de48a1]; ---> Microsoft.Dynamics.Retail.CommerceDataExchange.SqlWriteRequestRunException: Failed to run SqlWriteRequestRunner for table [AX].[INVENTTABLE]. Query: DELETE FROM [AX].[INVENTTABLE];MERGE [AX].[INVENTTABLE] AS dst USING (SELECT [ABCCONTRIBUTIONMARGIN],[ABCREVENUE],[ABCTIEUP],[ABCVALUE],[ALTITEMID],[APPROXTAXVALUE_BR],[BATCHNUMGROUPID],[CNPJ_BR],[COSTMODEL],[DENSITY],[DEPTH],[EXCEPTIONCODE_BR],[EXEMPT_IN],[GROSSDEPTH],[GROSSHEIGHT],[GROSSWIDTH],[HEIGHT],[HSNCODETABLE_IN],[INVENTPRODUCTTYPE_BR],[ITEMBUYERGROUPID],[ITEMDIMCOSTPRICE],[ITEMID],[ITEMTYPE],[NAMEALIAS],[NETWEIGHT],[NONGST_IN],[PRIMARYVENDORID],[PRODGROUPID],[PRODPOOLID],[PROJCATEGORYID],[PROPERTYID],[PURCHMODEL],[RECID],[REQGROUPID],[SALESCONTRIBUTIONRATIO],[SALESMODEL],[SALESPERCENTMARKUP],[SALESPRICEMODELBASIC],[SCALEINDICATOR_BR],[SERIALNUMGROUPID],[SERVICEACCOUNTINGCODETABLE_IN],[SORTCODE],[TARAWEIGHT],[TAXATIONORIGIN_BR],[TAXFISCALCLASSIFICATION_BR],[TAXRATETYPE],[TAXSERVICECODE_BR],[UNITVOLUME],[USEALTITEMID],[WIDTH],[DATAAREAID] FROM [#AX_INVENTTABLE_c772ab42-1532-4328-9c48-712361de48a1]) AS src ON (dst.[ITEMID]=src.[ITEMID] AND dst.[DATAAREAID]=src.[DATAAREAID]) WHEN MATCHED THEN UPDATE SET [ABCCONTRIBUTIONMARGIN]=src.[ABCCONTRIBUTIONMARGIN],[ABCREVENUE]=src.[ABCREVENUE],[ABCTIEUP]=src.[ABCTIEUP],[ABCVALUE]=src.[ABCVALUE],[ALTITEMID]=src.[ALTITEMID],[APPROXTAXVALUE_BR]=src.[APPROXTAXVALUE_BR],[BATCHNUMGROUPID]=src.[BATCHNUMGROUPID],[CNPJ_BR]=src.[CNPJ_BR],[COSTMODEL]=src.[COSTMODEL],[DENSITY]=src.[DENSITY],[DEPTH]=src.[DEPTH],[EXCEPTIONCODE_BR]=src.[EXCEPTIONCODE_BR],[EXEMPT_IN]=src.[EXEMPT_IN],[GROSSDEPTH]=src.[GROSSDEPTH],[GROSSHEIGHT]=src.[GROSSHEIGHT],[GROSSWIDTH]=src.[GROSSWIDTH],[HEIGHT]=src.[HEIGHT],[HSNCODETABLE_IN]=src.[HSNCODETABLE_IN],[INVENTPRODUCTTYPE_BR]=src.[INVENTPRODUCTTYPE_BR],[ITEMBUYERGROUPID]=src.[ITEMBUYERGROUPID],[ITEMDIMCOSTPRICE]=src.[ITEMDIMCOSTPRICE],[ITEMTYPE]=src.[ITEMTYPE],[NAMEALIAS]=src.[NAMEALIAS],[NETWEIGHT]=src.[NETWEIGHT],[NONGST_IN]=src.[NONGST_IN],[PRIMARYVENDORID]=src.[PRIMARYVENDORID],[PRODGROUPID]=src.[PRODGROUPID],[PRODPOOLID]=src.[PRODPOOLID],[PROJCATEGORYID]=src.[PROJCATEGORYID],[PROPERTYID]=src.[PROPERTYID],[PURCHMODEL]=src.[PURCHMODEL],[RECID]=src.[RECID],[REQGROUPID]=src.[REQGROUPID],[SALESCONTRIBUTIONRATIO]=src.[SALESCONTRIBUTIONRATIO],[SALESMODEL]=src.[SALESMODEL],[SALESPERCENTMARKUP]=src.[SALESPERCENTMARKUP],[SALESPRICEMODELBASIC]=src.[SALESPRICEMODELBASIC],[SCALEINDICATOR_BR]=src.[SCALEINDICATOR_BR],[SERIALNUMGROUPID]=src.[SERIALNUMGROUPID],[SERVICEACCOUNTINGCODETABLE_IN]=src.[SERVICEACCOUNTINGCODETABLE_IN],[SORTCODE]=src.[SORTCODE],[TARAWEIGHT]=src.[TARAWEIGHT],[TAXATIONORIGIN_BR]=src.[TAXATIONORIGIN_BR],[TAXFISCALCLASSIFICATION_BR]=src.[TAXFISCALCLASSIFICATION_BR],[TAXRATETYPE]=src.[TAXRATETYPE],[TAXSERVICECODE_BR]=src.[TAXSERVICECODE_BR],[UNITVOLUME]=src.[UNITVOLUME],[USEALTITEMID]=src.[USEALTITEMID],[WIDTH]=src.[WIDTH] WHEN NOT MATCHED THEN INSERT ([ABCCONTRIBUTIONMARGIN],[ABCREVENUE],[ABCTIEUP],[ABCVALUE],[ALTITEMID],[APPROXTAXVALUE_BR],[BATCHNUMGROUPID],[CNPJ_BR],[COSTMODEL],[DENSITY],[DEPTH],[EXCEPTIONCODE_BR],[EXEMPT_IN],[GROSSDEPTH],[GROSSHEIGHT],[GROSSWIDTH],[HEIGHT],[HSNCODETABLE_IN],[INVENTPRODUCTTYPE_BR],[ITEMBUYERGROUPID],[ITEMDIMCOSTPRICE],[ITEMID],[ITEMTYPE],[NAMEALIAS],[NETWEIGHT],[NONGST_IN],[PRIMARYVENDORID],[PRODGROUPID],[PRODPOOLID],[PROJCATEGORYID],[PROPERTYID],[PURCHMODEL],[RECID],[REQGROUPID],[SALESCONTRIBUTIONRATIO],[SALESMODEL],[SALESPERCENTMARKUP],[SALESPRICEMODELBASIC],[SCALEINDICATOR_BR],[SERIALNUMGROUPID],[SERVICEACCOUNTINGCODETABLE_IN],[SORTCODE],[TARAWEIGHT],[TAXATIONORIGIN_BR],[TAXFISCALCLASSIFICATION_BR],[TAXRATETYPE],[TAXSERVICECODE_BR],[UNITVOLUME],[USEALTITEMID],[WIDTH],[DATAAREAID]) VALUES (src.[ABCCONTRIBUTIONMARGIN],src.[ABCREVENUE],src.[ABCTIEUP],src.[ABCVALUE],src.[ALTITEMID],src.[APPROXTAXVALUE_BR],src.[BATCHNUMGROUPID],src.[CNPJ_BR],src.[COSTMODEL],src.[DENSITY],src.[DEPTH],src.[EXCEPTIONCODE_BR],src.[EXEMPT_IN],src.[GROSSDEPTH],src.[GROSSHEIGHT],src.[GROSSWIDTH],src.[HEIGHT],src.[HSNCODETABLE_IN],src.[INVENTPRODUCTTYPE_BR],src.[ITEMBUYERGROUPID],src.[ITEMDIMCOSTPRICE],src.[ITEMID],src.[ITEMTYPE],src.[NAMEALIAS],src.[NETWEIGHT],src.[NONGST_IN],src.[PRIMARYVENDORID],src.[PRODGROUPID],src.[PRODPOOLID],src.[PROJCATEGORYID],src.[PROPERTYID],src.[PURCHMODEL],src.[RECID],src.[REQGROUPID],src.[SALESCONTRIBUTIONRATIO],src.[SALESMODEL],src.[SALESPERCENTMARKUP],src.[SALESPRICEMODELBASIC],src.[SCALEINDICATOR_BR],src.[SERIALNUMGROUPID],src.[SERVICEACCOUNTINGCODETABLE_IN],src.[SORTCODE],src.[TARAWEIGHT],src.[TAXATIONORIGIN_BR],src.[TAXFISCALCLASSIFICATION_BR],src.[TAXRATETYPE],src.[TAXSERVICECODE_BR],src.[UNITVOLUME],src.[USEALTITEMID],src.[WIDTH],src.[DATAAREAID]) OPTION (MAXDOP 1); DROP TABLE [#AX_INVENTTABLE_c772ab42-1532-4328-9c48-712361de48a1]; ---> Microsoft.Dynamics.Retail.CommerceDataExchange.PerformWriteOperationException: Error when writing data to table [AX].[INVENTTABLE]. Query: DELETE FROM [AX].[INVENTTABLE];MERGE [AX].[INVENTTABLE] AS dst USING (SELECT [ABCCONTRIBUTIONMARGIN],[ABCREVENUE],[ABCTIEUP],[ABCVALUE],[ALTITEMID],[APPROXTAXVALUE_BR],[BATCHNUMGROUPID],[CNPJ_BR],[COSTMODEL],[DENSITY],[DEPTH],[EXCEPTIONCODE_BR],[EXEMPT_IN],[GROSSDEPTH],[GROSSHEIGHT],[GROSSWIDTH],[HEIGHT],[HSNCODETABLE_IN],[INVENTPRODUCTTYPE_BR],[ITEMBUYERGROUPID],[ITEMDIMCOSTPRICE],[ITEMID],[ITEMTYPE],[NAMEALIAS],[NETWEIGHT],[NONGST_IN],[PRIMARYVENDORID],[PRODGROUPID],[PRODPOOLID],[PROJCATEGORYID],[PROPERTYID],[PURCHMODEL],[RECID],[REQGROUPID],[SALESCONTRIBUTIONRATIO],[SALESMODEL],[SALESPERCENTMARKUP],[SALESPRICEMODELBASIC],[SCALEINDICATOR_BR],[SERIALNUMGROUPID],[SERVICEACCOUNTINGCODETABLE_IN],[SORTCODE],[TARAWEIGHT],[TAXATIONORIGIN_BR],[TAXFISCALCLASSIFICATION_BR],[TAXRATETYPE],[TAXSERVICECODE_BR],[UNITVOLUME],[USEALTITEMID],[WIDTH],[DATAAREAID] FROM [#AX_INVENTTABLE_c772ab42-1532-4328-9c48-712361de48a1]) AS src ON (dst.[ITEMID]=src.[ITEMID] AND dst.[DATAAREAID]=src.[DATAAREAID]) WHEN MATCHED THEN UPDATE SET [ABCCONTRIBUTIONMARGIN]=src.[ABCCONTRIBUTIONMARGIN],[ABCREVENUE]=src.[ABCREVENUE],[ABCTIEUP]=src.[ABCTIEUP],[ABCVALUE]=src.[ABCVALUE],[ALTITEMID]=src.[ALTITEMID],[APPROXTAXVALUE_BR]=src.[APPROXTAXVALUE_BR],[BATCHNUMGROUPID]=src.[BATCHNUMGROUPID],[CNPJ_BR]=src.[CNPJ_BR],[COSTMODEL]=src.[COSTMODEL],[DENSITY]=src.[DENSITY],[DEPTH]=src.[DEPTH],[EXCEPTIONCODE_BR]=src.[EXCEPTIONCODE_BR],[EXEMPT_IN]=src.[EXEMPT_IN],[GROSSDEPTH]=src.[GROSSDEPTH],[GROSSHEIGHT]=src.[GROSSHEIGHT],[GROSSWIDTH]=src.[GROSSWIDTH],[HEIGHT]=src.[HEIGHT],[HSNCODETABLE_IN]=src.[HSNCODETABLE_IN],[INVENTPRODUCTTYPE_BR]=src.[INVENTPRODUCTTYPE_BR],[ITEMBUYERGROUPID]=src.[ITEMBUYERGROUPID],[ITEMDIMCOSTPRICE]=src.[ITEMDIMCOSTPRICE],[ITEMTYPE]=src.[ITEMTYPE],[NAMEALIAS]=src.[NAMEALIAS],[NETWEIGHT]=src.[NETWEIGHT],[NONGST_IN]=src.[NONGST_IN],[PRIMARYVENDORID]=src.[PRIMARYVENDORID],[PRODGROUPID]=src.[PRODGROUPID],[PRODPOOLID]=src.[PRODPOOLID],[PROJCATEGORYID]=src.[PROJCATEGORYID],[PROPERTYID]=src.[PROPERTYID],[PURCHMODEL]=src.[PURCHMODEL],[RECID]=src.[RECID],[REQGROUPID]=src.[REQGROUPID],[SALESCONTRIBUTIONRATIO]=src.[SALESCONTRIBUTIONRATIO],[SALESMODEL]=src.[SALESMODEL],[SALESPERCENTMARKUP]=src.[SALESPERCENTMARKUP],[SALESPRICEMODELBASIC]=src.[SALESPRICEMODELBASIC],[SCALEINDICATOR_BR]=src.[SCALEINDICATOR_BR],[SERIALNUMGROUPID]=src.[SERIALNUMGROUPID],[SERVICEACCOUNTINGCODETABLE_IN]=src.[SERVICEACCOUNTINGCODETABLE_IN],[SORTCODE]=src.[SORTCODE],[TARAWEIGHT]=src.[TARAWEIGHT],[TAXATIONORIGIN_BR]=src.[TAXATIONORIGIN_BR],[TAXFISCALCLASSIFICATION_BR]=src.[TAXFISCALCLASSIFICATION_BR],[TAXRATETYPE]=src.[TAXRATETYPE],[TAXSERVICECODE_BR]=src.[TAXSERVICECODE_BR],[UNITVOLUME]=src.[UNITVOLUME],[USEALTITEMID]=src.[USEALTITEMID],[WIDTH]=src.[WIDTH] WHEN NOT MATCHED THEN INSERT ([ABCCONTRIBUTIONMARGIN],[ABCREVENUE],[ABCTIEUP],[ABCVALUE],[ALTITEMID],[APPROXTAXVALUE_BR],[BATCHNUMGROUPID],[CNPJ_BR],[COSTMODEL],[DENSITY],[DEPTH],[EXCEPTIONCODE_BR],[EXEMPT_IN],[GROSSDEPTH],[GROSSHEIGHT],[GROSSWIDTH],[HEIGHT],[HSNCODETABLE_IN],[INVENTPRODUCTTYPE_BR],[ITEMBUYERGROUPID],[ITEMDIMCOSTPRICE],[ITEMID],[ITEMTYPE],[NAMEALIAS],[NETWEIGHT],[NONGST_IN],[PRIMARYVENDORID],[PRODGROUPID],[PRODPOOLID],[PROJCATEGORYID],[PROPERTYID],[PURCHMODEL],[RECID],[REQGROUPID],[SALESCONTRIBUTIONRATIO],[SALESMODEL],[SALESPERCENTMARKUP],[SALESPRICEMODELBASIC],[SCALEINDICATOR_BR],[SERIALNUMGROUPID],[SERVICEACCOUNTINGCODETABLE_IN],[SORTCODE],[TARAWEIGHT],[TAXATIONORIGIN_BR],[TAXFISCALCLASSIFICATION_BR],[TAXRATETYPE],[TAXSERVICECODE_BR],[UNITVOLUME],[USEALTITEMID],[WIDTH],[DATAAREAID]) VALUES (src.[ABCCONTRIBUTIONMARGIN],src.[ABCREVENUE],src.[ABCTIEUP],src.[ABCVALUE],src.[ALTITEMID],src.[APPROXTAXVALUE_BR],src.[BATCHNUMGROUPID],src.[CNPJ_BR],src.[COSTMODEL],src.[DENSITY],src.[DEPTH],src.[EXCEPTIONCODE_BR],src.[EXEMPT_IN],src.[GROSSDEPTH],src.[GROSSHEIGHT],src.[GROSSWIDTH],src.[HEIGHT],src.[HSNCODETABLE_IN],src.[INVENTPRODUCTTYPE_BR],src.[ITEMBUYERGROUPID],src.[ITEMDIMCOSTPRICE],src.[ITEMID],src.[ITEMTYPE],src.[NAMEALIAS],src.[NETWEIGHT],src.[NONGST_IN],src.[PRIMARYVENDORID],src.[PRODGROUPID],src.[PRODPOOLID],src.[PROJCATEGORYID],src.[PROPERTYID],src.[PURCHMODEL],src.[RECID],src.[REQGROUPID],src.[SALESCONTRIBUTIONRATIO],src.[SALESMODEL],src.[SALESPERCENTMARKUP],src.[SALESPRICEMODELBASIC],src.[SCALEINDICATOR_BR],src.[SERIALNUMGROUPID],src.[SERVICEACCOUNTINGCODETABLE_IN],src.[SORTCODE],src.[TARAWEIGHT],src.[TAXATIONORIGIN_BR],src.[TAXFISCALCLASSIFICATION_BR],src.[TAXRATETYPE],src.[TAXSERVICECODE_BR],src.[UNITVOLUME],src.[USEALTITEMID],src.[WIDTH],src.[DATAAREAID]) OPTION (MAXDOP 1); DROP TABLE [#AX_INVENTTABLE_c772ab42-1532-4328-9c48-712361de48a1]; ---> System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'I_-137955366_-474954108'. Cannot insert duplicate key in object 'ax.INVENTTABLE'. The duplicate key value is (0, 1002).The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.Dynamics.Retail.CommerceDataExchange.SqlWriteRequestRunner.ExecuteDataOperationStatement(SqlConnection connection, SqlTransaction sqlTransaction) at Microsoft.Dynamics.Retail.CommerceDataExchange.SqlWriteRequestRunner.ExecuteDataOperationStatement(SqlConnection connection) at Microsoft.Dynamics.Retail.CommerceDataExchange.SqlWriteRequestRunner.PerformWriteOperation(SqlConnection connection) --- End of inner exception stack trace --- at Microsoft.Dynamics.Retail.CommerceDataExchange.SqlWriteRequestRunner.PerformWriteOperation(SqlConnection connection) at Microsoft.Dynamics.Retail.CommerceDataExchange.SqlWriteRequestRunner.Run(SqlConnection connection) --- End of inner exception stack trace --- at Microsoft.Dynamics.Retail.CommerceDataExchange.SqlWriteRequestRunner.Run(SqlConnection connection) at Microsoft.Dynamics.Retail.CommerceDataExchange.SqlMergeRequestRunner.Run(SqlConnection connection) --- End of inner exception stack trace --- at Microsoft.Dynamics.Retail.CommerceDataExchange.SqlMergeRequestRunner.Run(SqlConnection connection) at Microsoft.Dynamics.Retail.CommerceDataExchange.CDXDownloadSubJobContext.ProcessWriteRequest() at Microsoft.Dynamics.Retail.CommerceDataExchange.CDXDownloadSubJobContext.ProcessSubjob() at Microsoft.Dynamics.Retail.CommerceDataExchange.SqlTargetRequestHandler.ProcessSubJobs(SqlConnection connection) at Microsoft.Dynamics.Retail.CommerceDataExchange.SqlTargetRequestHandler.ProcessDataPackage(DataPackage dataPackage, Boolean runPostDataSyncOperations) --- End of inner exception stack trace --- at Microsoft.Dynamics.Retail.CommerceDataExchange.SqlTargetRequestHandler.ProcessDataPackage(DataPackage dataPackage, Boolean runPostDataSyncOperations) at Microsoft.Dynamics.Retail.CommerceDataExchange.SqlTargetRequestHandler.Apply(DataPackage dataPackage) at Microsoft.Dynamics.Retail.CommerceDataExchange.SqlTargetRequestHandler.ApplyToTargetDatabase(SqlTargetRequestContext targetRequestContext)

Can anyone please suggest how can we resolve this issue?

Thanks In Advance...