web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Async Client Error : ....
Microsoft Dynamics AX (Archived)

Async Client Error : .ProcessTargetRequestHeaderException: ProcessTargetRequestHeader failed to execute all delete requests

(0) ShareShare
ReportReport
Posted on by Community Member

ApplySessionFileToClientDatabase encountered Exception. Error Details: 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].[TestActivationDetail] failed to execute. ---> Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.RunException: Query: DELETE FROM [ax].[TestActivationDetail] ;; filterNameList: ;filterValueList: ; ---> System.Data.SqlClient.SqlException: Invalid object name 'ax.TestActivationDetail'.
   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 asyncWrite)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlDeleteByFilterRequestRunner.Run(SqlConnection connection, SqlTransaction transaction)
   --- End of inner exception stack trace ---
   at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlDeleteByFilterRequestRunner.Run(SqlConnection connection, SqlTransaction transaction)
   at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlTargetRequestHandler.ProcessDeleteRequest(SqlConnection connection, SqlTransaction transaction)
   --- End of inner exception stack trace ---
   at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlTargetRequestHandler.ProcessDeleteRequest(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)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].[TestActivationDetail] failed to execute. ---> Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.RunException: Query: DELETE FROM [ax].[TestActivationDetail] ;; filterNameList: ;filterValueList: ; ---> System.Data.SqlClient.SqlException: Invalid object name 'ax.TestActivationDetail'.
   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 asyncWrite)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlDeleteByFilterRequestRunner.Run(SqlConnection connection, SqlTransaction transaction)
   --- End of inner exception stack trace ---
   at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlDeleteByFilterRequestRunner.Run(SqlConnection connection, SqlTransaction transaction)
   at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlTargetRequestHandler.ProcessDeleteRequest(SqlConnection connection, SqlTransaction transaction)
   --- End of inner exception stack trace ---
   at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlTargetRequestHandler.ProcessDeleteRequest(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)

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    sumit0417 Profile Picture
    sumit0417 2,890 on at

    You need to compare the transfer field list for the TestActivationDetail table in scheduler job and the POS DB table for the fields.

  • Community Member Profile Picture
    Community Member on at

    Hi Sumit

    Sorry I still confuse. Where I can find the transfer field list in scheduler job ? This error not happen in all Async Client, some Async Client is working success without this error

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    Hi

    I solve this issue. I compare both database and found TestActivationDetail table is missing in my retail store database

    Thanks for your help

  • Community Member Profile Picture
    Community Member on at

    Hi,

    Good day!

    we're encountering the same issue. May I ask how did you make to work this out?

    Thanks

  • Community Member Profile Picture
    Community Member on at

    Hi

    I try suggestion from Sumit above. Do comparison and found that my table (TestActivationDetail table) is missing from my database, so that's why I got this error below :

    Delete request on table:[ax].[TestActivationDetail] failed to execute

  • Community Member Profile Picture
    Community Member on at

    How do you fix the problem?

    because in our case, we have, tables with different amounts of columns between HQ and Store, and jobs fail writing data on store table.

    we have two weeks at this and do not know how to solve it. Our partner does not know .

    either

  • Community Member Profile Picture
    Community Member on at

    Hi Salazar,

    Can you provide some reference regarding the issue on your system? or the logs in the Event viewer.

    Thanks,

  • Community Member Profile Picture
    Community Member on at

    Hi Salazar

    Could you share any logs from Event Viewer ? Maybe your problem same with my case or maybe not same too :)

  • Community Member Profile Picture
    Community Member on at

    Hi Pramudita,

    i'm currently having a similar issue but with failed write request. could you please share with me, how can this be resolved?

    ApplySessionFileToClientDatabase encountered Exception. Error Details: 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].[RETAILPERIODICDISCOUNTLINE] 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].[RETAILPERIODICDISCOUNTLINE] AS dst
    USING (SELECT [DISCOUNTPERCENTORVALUE],[INSTANCERELATIONTYPE],[ISDISCOUNTCODEREQUIRED],[LINENUM],[NAME],[OFFERID],[RECID],[RELATIONTYPE],[RETAILGROUPMEMBERLINE],[STATUS],[UNITOFMEASURE],[DATAAREAID] FROM [#ax_RETAILPERIODICDISCOUNTLINE_23c7fde4-d969-40e1-a805-157683927185]) AS src
    ON (dst.[RECID]=src.[RECID])
    WHEN MATCHED THEN
    UPDATE SET [DISCOUNTPERCENTORVALUE]=src.[DISCOUNTPERCENTORVALUE],[INSTANCERELATIONTYPE]=src.[INSTANCERELATIONTYPE],[ISDISCOUNTCODEREQUIRED]=src.[ISDISCOUNTCODEREQUIRED],[LINENUM]=src.[LINENUM],[NAME]=src.[NAME],[OFFERID]=src.[OFFERID],[RELATIONTYPE]=src.[RELATIONTYPE],[RETAILGROUPMEMBERLINE]=src.[RETAILGROUPMEMBERLINE],[STATUS]=src.[STATUS],[UNITOFMEASURE]=src.[UNITOFMEASURE],[DATAAREAID]=src.[DATAAREAID]
    WHEN NOT MATCHED THEN
    INSERT ([DISCOUNTPERCENTORVALUE],[INSTANCERELATIONTYPE],[ISDISCOUNTCODEREQUIRED],[LINENUM],[NAME],[OFFERID],[RECID],[RELATIONTYPE],[RETAILGROUPMEMBERLINE],[STATUS],[UNITOFMEASURE],[DATAAREAID])
    VALUES (src.[DISCOUNTPERCENTORVALUE],src.[INSTANCERELATIONTYPE],src.[ISDISCOUNTCODEREQUIRED],src.[LINENUM],src.[NAME],src.[OFFERID],src.[RECID],src.[RELATIONTYPE],src.[RETAILGROUPMEMBERLINE],src.[STATUS],src.[UNITOFMEASURE],src.[DATAAREAID]);
    DROP TABLE [#ax_RETAILPERIODICDISCOUNTLINE_23c7fde4-d969-40e1-a805-157683927185];
    ---> System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'I_-2095525985_1217888543'. Cannot insert duplicate key in object 'ax.RETAILPERIODICDISCOUNTLINE'.

  • Community Member Profile Picture
    Community Member on at

    Hi everyone!

    I think I'm facing the same issue, here the log:

    ApplySessionFileToClientDatabase encountered Exception. Error Details: 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].[RETAILATTRIBUTEFILTER] failed to execute. ---> Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.RunException: Query: DELETE FROM [ax].[RETAILATTRIBUTEFILTER] ;; filterNameList: ;filterValueList: ; ---> System.Data.SqlClient.SqlException: Invalid object name 

    'ax.RETAILATTRIBUTEFILTER'.
    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 asyncWrite)
    at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
    at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlDeleteByFilterRequestRunner.Run(SqlConnection connection, SqlTransaction transaction)
    --- End of inner exception stack trace ---
    at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlDeleteByFilterRequestRunner.Run(SqlConnection connection, SqlTransaction transaction)
    at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlTargetRequestHandler.ProcessDeleteRequest(SqlConnection connection, SqlTransaction transaction)
    --- End of inner exception stack trace ---
    at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlTargetRequestHandler.ProcessDeleteRequest(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)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].[RETAILATTRIBUTEFILTER] failed to execute. ---> Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.RunException: Query: DELETE FROM [ax].[RETAILATTRIBUTEFILTER] ;; filterNameList: ;filterValueList: ; ---> System.Data.SqlClient.SqlException: Invalid object name 'ax.RETAILATTRIBUTEFILTER'.
    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 asyncWrite)
    at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
    at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlDeleteByFilterRequestRunner.Run(SqlConnection connection, SqlTransaction transaction)
    --- End of inner exception stack trace ---
    at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlDeleteByFilterRequestRunner.Run(SqlConnection connection, SqlTransaction transaction)
    at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlTargetRequestHandler.ProcessDeleteRequest(SqlConnection connection, SqlTransaction transaction)
    --- End of inner exception stack trace ---
    at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlTargetRequestHandler.ProcessDeleteRequest(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)

    I would appreciate your suggestions.

    Thanks in advance.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans