Process upload jobs encountered ProcessSourceRequestHeaderException Dynamics Ax 2012 R3.

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.

alirazazaidi

Advisory software engineer, Software engineer, Last 4 years focus on Dynamics Ax 2012. MVP and Microsoft Certified trainer for Dynamics AX.