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) / Retail Synch Service E...
Microsoft Dynamics AX (Archived)

Retail Synch Service Error 32769

(0) ShareShare
ReportReport
Posted on by Amos 205

Guys, I try to Synch the N-1070 : Store and Tenders on my retail module but I keep having this error:

Error 32769 : Target request handler failed to process target request header: ProcessSourceRequestHeaderException: ProcessTargetRequestHeader failed due to an InvalidOperationException. connectionString: Application Name=Commerce Data Exchange Synch Service;Data S

Error 28673 : Failed to prepare target request handler/request header: SCRequestHandlerManagerException: Cannot unpack target request ArgumentException: File does not exist: C:\Users\administrator\AppData\Local\Microsoft Dynamics AX\60\Commerce Data Excha

 

this two error keep repeating even sometimes on other n-jobs like N-1040, N-1100, and N-1010.

I already try the Tech solution from the Synch Manual but still didn't get any result.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    NRN Profile Picture
    NRN on at

    We have seen the 32769 error many times. In our case, The cause can usually be tracked back to the N-1040 job.

    To fix this problem, we have to follow a 3 step process and this process must be done in order for the problem to be corrected. The steps involved are:

    1) Delete all of the records in the Incoming and Outgoing message tables.

    2) Run the script to drop and create the INVENTITEMBARCODE table.

    Navigate the Database Menu tree:

           Databases  > AxRetailPOS_StoreDB  > Tables  > dbo.INVENTITEMBARCODE

    Right Click the table name and select Script Table as.

    Select DROP and CREATE To and then choose New Query Editor Window.

    Run the script.

    3) Re-run the N-1040 job to the store.

    If the above steps do not work, (and the job just sits at a waiting status at the store DB) we do the following:

    1)      Shutdown the Synch Service at the store.

    2)      Delete all of the records in Incoming and Outgoing message tables. (again)

    3)      Delete all files in the Synch Service Work folder.

            (Microsoft Dynamics AX\60\Commerce Data Exchange\Synch Service\work)

    4)      Restart the Synch Service at the store.

    5)      Re-run the N job

    Hope this helps....

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Awesome, it works!

  • abhisince Profile Picture
    abhisince 40 on at

    Dear all,

    I am doing the fresh installation of retail in my PC. So in My PC HQ and POS both are in the Same laptop.

    I have done all the basic setup that is require to run the POS. Before open the POS we need to Run the N Job first.. While I am running N job 1070 I am getting error.

    Error from SQL for N Job 1070 is error no 32769

    Server Msg in SQL for n Job 1070 is Target request handler failed to process target request header: ProcessTargetRequestHeaderException: ProcessTargetRequestHeader failed to execute all write requests.  ProcessWriteRequestException: Write request on table:[dbo].[RETAILFUNCTIONALITYPROF

    for all your reference below is the error which i extracted from Event viewer for this same N Job 1070

    2014.5.8 22:15:9:843 (5036) [1] CCommMgr::HandleException: Target request handler failed to process target request header: 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:[dbo].[RETAILFUNCTIONALITYPROFILE] failed to execute. ---> Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.RunException: Run() failed while creating temporary table. ---> Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.CreateTempTableException: Query: SELECT TOP 0 [ADDTAXONPRICES],[AGGREGATEITEMS],[AGGREGATEITEMSFORPRINTING],[AGGREGATEPAYMENTS],[AMOUNTDECIMALPLACES],[AMOUNTROUNDINGTO],[APPLYDISCOUNTONUNITPRICES],[AUDITENABLED],[BACKUPTRAININGTRANSACTIONS],[BLOCKEDCLOSEDACCOUNT],[CENTRALTABLESERVER],[CENTRALTABLESERVERPORT],[CURRENCYSYMBOL],[CUSTOMER],[CUSTOMER2],[DATAENTRIES],[DAYSCUSTOMERHISTORY],[DAYSTRANSACTIONSEXISTS],[DECIMALNOTREQUIREDFORMINORCURRENCYUNIT],[DISCOUNTATTOTAL],[DISPLAYSECONDARYTOTALCURRENCY],[ENDOFTRANSACTION],[FLOATINGCASHIER],[INVENTORYLOOKUP],[ITEMNOTONFILE],[LIMITSTAFFLISTTOSTORE],[LINEITEMTAXCHANGE],[MARKDOWN],[MARKUP],[MAXIMUMPRICE],[MAXIMUMQTY],[MAXIMUMSTORETRANSLOG],[MINIMUMPASSWORDLENGTH],[MODIFIEDBY],[MODIFIEDDATE],[MULTIBLEITEMSYMBOL],[MUSTKEYINPRICEIFZERO],[NAME],[NEGATIVEADJUSTMENT],[NEGATIVESALESLINE],[NOTAXUSED],[OVERRIDEPRICE],[PRICEDECIMALPLACES],[PRICEROUNDINGTO],[PRINTXREPORTONTERMINAL],[PROFILEID],[RECID],[REFUNDSALE],[REQUIREAMOUNTDECLARATION],[SALESPERSON],[SALESPERSONMODE],[SECONDARYTOTALCURRENCY],[SENDTRANSACTION],[SERIALNUMBER],[SHOWSTAFFLISTATLOGON],[SKIPTAXONRECEIPT],[STAFFBARCODELOGON],[STAFFBARCODELOGONREQUIRESPASSWORD],[STAFFCARDLOGON],[STAFFCARDLOGONREQUIRESPASSWORD],[STAFFVALIDATION],[STARTOFTRANSACTION],[SUPPORTEDCOUNTRYREGIONISOCODE],[SUSPENDRETRIEVETRANSACTION],[TAENABLEREGISTRATION],[TAXREGISTRATIONNUMBERONRECEIPT],[TENDERDECLARATION],[TRANSACTIONDELETEREMINDER],[TRANSACTIONTAXCHANGE],[TSCENTRALTABLESERVER],[TSCUSTOMER],[TSDATAENTRIES],[TSFLOATINGCASHIER],[TSINVENTORYLOOKUP],[TSRESENDDELAY],[TSSENDTRANSACTIONS],[TSSENDVOIDTRANSACTIONS],[TSSTAFF],[TSSUSPENDRETRIEVETRANSACTIONS],[TSTRANSACTIONRESENDLIMIT],[TSUPDATEREPLICATIONCOUNTER],[VOIDISPRESSED],[VOIDPAYMENT],[VOIDPOSTEDTRANSACTION],[VOIDTRANSACTION] INTO [#dbo_RETAILFUNCTIONALITYPROFILE_8b1fe6f3-a362-4998-ac96-94f4995f165c] FROM [dbo].[RETAILFUNCTIONALITYPROFILE]; ---> System.Data.SqlClient.SqlException: Invalid column name 'APPLYDISCOUNTONUNITPRICES'. 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.CreateTempTable(SqlConnection connection, SqlTransaction transaction) --- End of inner exception stack trace --- at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlWriteRequestRunner.CreateTempTable(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.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 CCommMgr.ProcessTargetRequest(CCommMgr* , basic_string<wchar_t\,std::char_traits<wchar_t>\,std::allocator<wchar_t> >* r_file_path, SCComponentManager scComponentManager)

    can any one of your brilliant people help me to solve this issue..

    If any one wantto have more information I have the temp file, work folder along with log file and log folder also which i can share if anyone want to see that also.

    Thanks in anticipation of reply from all you expert people...

    Thanks

    Abhijeet...

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hi,

    I know that is it very late to reply but i am replying because it could help others who are having same problem currently.

    Most of the times this error occurs due to Dirparty tables(DirpartyTable, DirPartyAddressbook, etc..) due to field's mismatch.  Try to exclude the subjobs for DirParty Tables  from the above jobs and try to replicate the data down to POS store databases.   If Replication works by Excluding DirParty Tables then it means that there is filed mismatch in one of the tables. you have to go through table by table to check the datatypes of the columns. 

    If this doesn't work then try drop and create on the Dirparty Tables(Right Click On Table--> Script Table As --> DROP And CREATE To--> New Query Window--> Then execute the script which it create. 

  • ivan.kaselj Profile Picture
    ivan.kaselj 5 on at

    One more solution... Check if 'Delete' option is set on the 'Scheduler Subjobs' -> 'Setup fasttab' for all subjobs in the failing job. If not, Insert will try to populate table with existing data.

  • Community Member Profile Picture
    Community Member on at

    n

  • gulammusthafa2013 Profile Picture
    gulammusthafa2013 115 on at

    i checked but its not showing any dirty party tables.please suggest

  • Community Member Profile Picture
    Community Member on at

    Hi Musthafa,

    if you don't you have any data in DirParty Tables then problem is simple. There are only few party tables. Just compare the DataTypes of the Fields of Party Tables  on POS database with AX Database. There could be a field/s that have different size from POS to AX. Let me know if it works.

  • gulammusthafa2013 Profile Picture
    gulammusthafa2013 115 on at

    see am running N-1040 Job i got the same issue bro..  in that subjobs  nothing like that

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Can you give me full description of the problem?

     

    Right click on N-1040 and click on View Details. Then in new window you will see all the sub jobs related to N-1040.

    You must un-tick(Enabled column) all the Sub jobs first. 

    Then you can tick sub jobs one by one and replicate the data and see which sub job is giving you errors. 

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