Dear AX Tech Experts,
We have run 1020 job on all pos machine from channel database. It has applied successfully on all POS but not applying on one of the POS.
Job status in Head office remain on Available but channel db shows error in event viewer:
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].[PRICEDISCTABLE] failed to execute. --->
Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.RunException:
Query: DELETE FROM [ax].[PRICEDISCTABLE] ;; filterNameList: ;filterValueList: ; --->
System.Data.SqlClient.SqlException: Execution Timeout Expired.
Strange is: when I cancel & delete this job from Headoffice and run any other job like 1040 but it is showing same PriceDiscTable error.
Question is : where this error has stuck and why this is not allowing any other job to run.
Please suggest me to get out of this error situation.
Regards
Kamran