Error: ProcessTargetRequestHeader failed in AX Retail:Download Session
Dynamics AX Retail has an intense Architecture behind the scenes, so some issues could take much more time to troubleshoot and fix the problem. So I am just writing down about this issue I faced today working with AX Retail Channel Integration. When trying to perform a Full sync for the Job-1070 for a Channel data Group, I encountered the below error. Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.ProcessTargetRequestHeaderException: ProcessTargetRequestHeader failed to execute all delete requests ---> Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.ProcessDeleteRequestException: Delete request on table:[ax].[ACCOUNTANT_BR] failed to execute. ---> Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.RunException: Query: DELETE FROM [ax].[ACCOUNTANT_BR] ;; filterNameList: ;filterValueList: ; ---> System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object 'xp_cmdshell', database 'mssqlsystemresource',...