Dear All,
I need help there is a random error on my Download session batch usually on job 1020 and 1040 ,
here is the message in the event viewer
MESSAGE
Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.ProcessTargetRequestHeaderException: ProcessTargetRequestHeader failed to execute all write requests. --->
Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.ProcessWriteRequestException: Write request on table:[ax].[INVENTTABLE] failed to execute. --->
Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.RunException: Run() failed while performing write operation on table. --->
Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.PerformWriteOperationException: Query: MERGE [ax].
[INVENTTABLE] AS dst USING (SELECT [ABCCONTRIBUTIONMARGIN],[ABCREVENUE],[ABCTIEUP],[ABCVALUE],[ALTITEMID],
[APPROXTAXVALUE_BR],[BATCHNUMGROUPID],[COSTMODEL],[DENSITY],[DEPTH],[EXCEPTIONCODE_BR],[GROSSDEPTH],
[GROSSHEIGHT],[GROSSWIDTH],[HEIGHT],[INVENTPRODUCTTYPE_BR],[ITEMBUYERGROUPID],[ITEMDIMCOSTPRICE],[ITEMID],
[ITEMTYPE],[NAMEALIAS],[NETWEIGHT],[PBAINVENTITEMGROUPID],[PBAITEMCONFIGURABLE],[PRIMARYVENDORID],
[PRODGROUPID],[PRODPOOLID],[PRODUCT],[PROJCATEGORYID],[PROPERTYID],[PURCHMODEL],[RECID],[REQGROUPID],
[SALESCONTRIBUTIONRATIO],[SALESMODEL],[SALESPERCENTMARKUP],[SALESPRICEMODELBASIC],[SERIALNUMGROUPID],
[SORTCODE],[TARAWEIGHT],[TAXATIONORIGIN_BR],[TAXFISCALCLASSIFICATION_BR],[TAXSERVICECODE_BR],[UNITVOLUME],
[USEALTITEMID],[WIDTH],[WMSPICKINGQTYTIME],[DATAAREAID] FROM [#ax_INVENTTABLE_d1009d42-e1fe-44cb-bfae-
ae8dd9daab23]) 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],[COSTMODEL]=src.[COSTMODEL],[DENSITY]=src.[DENSITY],[DEPTH]=src.
[DEPTH],[EXCEPTIONCODE_BR]=src.[EXCEPTIONCODE_BR],[GROSSDEPTH]=src.[GROSSDEPTH],[GROSSHEIGHT]=src.
[GROSSHEIGHT],[GROSSWIDTH]=src.[GROSSWIDTH],[HEIGHT]=src.[HEIGHT],[INVENTPRODUCTTYPE_BR]=src.
[INVENTPRODUCTTYPE_BR],[ITEMBUYERGROUPID]=src.[ITEMBUYERGROUPID],[ITEMDIMCOSTPRICE]=src.[ITEMDIMCOSTPRICE],
[ITEMTYPE]=src.[ITEMTYPE],[NAMEALIAS]=src.[NAMEALIAS],[NETWEIGHT]=src.[NETWEIGHT],[PBAINVENTITEMGROUPID]=src.
[PBAINVENTITEMGROUPID],[PBAITEMCONFIGURABLE]=src.[PBAITEMCONFIGURABLE],[PRIMARYVENDORID]=src.
[PRIMARYVENDORID],[PRODGROUPID]=src.[PRODGROUPID],[PRODPOOLID]=src.[PRODPOOLID],[PRODUCT]=src.[PRODUCT],
[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],
[SERIALNUMGROUPID]=src.[SERIALNUMGROUPID],[SORTCODE]=src.[SORTCODE],[TARAWEIGHT]=src.[TARAWEIGHT],
[TAXATIONORIGIN_BR]=src.[TAXATIONORIGIN_BR],[TAXFISCALCLASSIFICATION_BR]=src.[TAXFISCALCLASSIFICATION_BR],
[TAXSERVICECODE_BR]=src.[TAXSERVICECODE_BR],[UNITVOLUME]=src.[UNITVOLUME],[USEALTITEMID]=src.[USEALTITEMID],
[WIDTH]=src.[WIDTH],[WMSPICKINGQTYTIME]=src.[WMSPICKINGQTYTIME] WHEN NOT MATCHED THEN INSERT
([ABCCONTRIBUTIONMARGIN],[ABCREVENUE],[ABCTIEUP],[ABCVALUE],[ALTITEMID],[APPROXTAXVALUE_BR],[BATCHNUMGROUPID],
[COSTMODEL],[DENSITY],[DEPTH],[EXCEPTIONCODE_BR],[GROSSDEPTH],[GROSSHEIGHT],[GROSSWIDTH],[HEIGHT],
[INVENTPRODUCTTYPE_BR],[ITEMBUYERGROUPID],[ITEMDIMCOSTPRICE],[ITEMID],[ITEMTYPE],[NAMEALIAS],[NETWEIGHT],
[PBAINVENTITEMGROUPID],[PBAITEMCONFIGURABLE],[PRIMARYVENDORID],[PRODGROUPID],[PRODPOOLID],[PRODUCT],
[PROJCATEGORYID],[PROPERTYID],[PURCHMODEL],[RECID],[REQGROUPID],[SALESCONTRIBUTIONRATIO],[SALESMODEL],
[SALESPERCENTMARKUP],[SALESPRICEMODELBASIC],[SERIALNUMGROUPID],[SORTCODE],[TARAWEIGHT],[TAXATIONORIGIN_BR],
[TAXFISCALCLASSIFICATION_BR],[TAXSERVICECODE_BR],[UNITVOLUME],[USEALTITEMID],[WIDTH],[WMSPICKINGQTYTIME],
[DATAAREAID]) VALUES (src.[ABCCONTRIBUTIONMARGIN],src.[ABCREVENUE],src.[ABCTIEUP],src.[ABCVALUE],src.
[ALTITEMID],src.[APPROXTAXVALUE_BR],src.[BATCHNUMGROUPID],src.[COSTMODEL],src.[DENSITY],src.[DEPTH],src.
[EXCEPTIONCODE_BR],src.[GROSSDEPTH],src.[GROSSHEIGHT],src.[GROSSWIDTH],src.[HEIGHT],src.
[INVENTPRODUCTTYPE_BR],src.[ITEMBUYERGROUPID],src.[ITEMDIMCOSTPRICE],src.[ITEMID],src.[ITEMTYPE],src.
[NAMEALIAS],src.[NETWEIGHT],src.[PBAINVENTITEMGROUPID],src.[PBAITEMCONFIGURABLE],src.[PRIMARYVENDORID],src.
[PRODGROUPID],src.[PRODPOOLID],src.[PRODUCT],src.[PROJCATEGORYID],src.[PROPERTYID],src.[PURCHMODEL],src.
[RECID],src.[REQGROUPID],src.[SALESCONTRIBUTIONRATIO],src.[SALESMODEL],src.[SALESPERCENTMARKUP],src.
[SALESPRICEMODELBASIC],src.[SERIALNUMGROUPID],src.[SORTCODE],src.[TARAWEIGHT],src.[TAXATIONORIGIN_BR],src.
[TAXFISCALCLASSIFICATION_BR],src.[TAXSERVICECODE_BR],src.[UNITVOLUME],src.[USEALTITEMID],src.[WIDTH],src.
[WMSPICKINGQTYTIME],src.[DATAAREAID]); DROP TABLE [#ax_INVENTTABLE_d1009d42-e1fe-44cb-bfae-ae8dd9daab23];
---> System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of
the operation or the server is not responding. The statement has been terminated. --->
System.ComponentModel.Win32Exception: The wait operation timed out --- End of inner exception stack trace
--- at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection,
Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.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) at
System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName,
Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery
() at
Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlWriteRequestRunner.PerformWriteOperation
(SqlConnection connection, SqlTransaction transaction) --- End of inner exception stack trace --- at
Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlWriteRequestRunner.PerformWriteOperation
(SqlConnection connection, SqlTransaction transaction) at
Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlWriteRequestRunner.Run(SqlConnection connection,
SqlTransaction transaction) --- End of inner exception stack trace --- at
Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlWriteRequestRunner.Run(SqlConnection connection,
SqlTransaction transaction) at
Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlMergeRequestRunner.Run(SqlConnection connection,
SqlTransaction transaction) at
Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlTargetRequestHandler.ProcessWriteRequest
(SqlConnection connection, SqlTransaction transaction) --- End of inner exception stack trace --- at
Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlTargetRequestHandler.ProcessWriteRequest
(SqlConnection connection, SqlTransaction transaction) at
Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlTargetRequestHandler.ProcessTargetRequestHeader
(ISCTargetRequestHeader targetRequestHeader) --- End of inner exception stack trace --- at
Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlTargetRequestHandler.ProcessTargetRequestHeader
(ISCTargetRequestHeader targetRequestHeader) at
Microsoft.Dynamics.Retail.SynchClient.Core.DownloadAgent.ApplySessionFileToClientDatabase(SessionManager sessionMgr, String fileName)
Really need any of your suggestions
Thanks a lot
Heron
