最新消息:ww12345678 的部落格重装上线,希望大家继续支持。

Process upload jobs encountered ProcessSourceRequestHeaderException Dynamics Ax 2012 R3.

网络文摘 alirazazaidi 545浏览 0评论
After completing VAT patch in Dynamics Ax 2012 R3, We got error in Retail Process job.  
Process upload jobs encountered ProcessSourceRequestHeaderException. Error Details: Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.ProcessSourceRequestHeaderException: ProcessSourceRequestHeader failed to execute all delete requests —> Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.ProcessReadRequestsException: Read request num: 1 on table:[ax].[RETAILFISCALDOCUMENT_BR] failed to execute. —> Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.RunException: Query: SELECT [ACCESSKEY],[AUTHORITYCODE],[CHANNEL],[CONSUMEREFDOCINQUIRYURL],[CONTINGENCYDATETIME],[CONTING FROM [ax].[RETAILFISCALDOCUMENT_BR] WHERE [ReplicationCounterFromOrigin]>@__scSqlFilterParam0 AND [ReplicationCounterFromOrigin]<=@__scSqlFilterParam1;; ParamNameList: ; ParamValueList:  —> System.Data.SqlClient.SqlException: Invalid column name ‘EFRREGISTERNUMBER’. Invalid column name ‘FISCALESTABLISHMENTTRADENAME’. Invalid column name ‘ORIGINALDISCOUNTAMOUNT’. Invalid column name ‘SENDBYEMAIL’. Invalid column name ‘SOFTWAREHOUSECNPJ’. Invalid column name ‘TAXAUTHORITYINFO’. Invalid column name ‘THIRDPARTYFORMATTEDADDRESS’. Invalid column name ‘THIRDPARTYICMSCONTRIBUTOR’. Invalid column name ‘THIRDPARTYIE’
    Yes one thing is clear that some fields in missing In Retail store database. On opening in AX, The same table has more fields then retail store db, these fields came with Patch. Some Sync problem.  So I have to follow these steps to complete the sync   Retails==> setup ==> Scheduler subjobs.     Scheduler Sub jobs select the required table and click on Transfer folder list       Functions => mapping.   Click on Yes   Run the process job, error is gone.
发表我的评论
取消评论

表情

Hi,您需要填写昵称和邮箱!

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址