emeadaxsupport: AX2012 Retail error 32769 in Store connect while running P-job

[Blog bot]

Источник: http://blogs.msdn.com/b/axsupport/ar...ing-p-job.aspx
==============

Version: AX 2012 FPK



Symptom: When running the P job following error message
appears in the event log or in the Retail store connect database
outgoingmessages table.



Error 32769

2012.6.7 13:21:45:114 (4684) [1]
CCommMgr::HandleException: Target request handler failed to process target
request header: Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlRequestHandlerException:
SQL target request handler failed to process request: SQL operation failure.
---> System.Data.SqlClient.SqlException: Invalid column name 'dataAreaId'.

Invalid column name 'replicationCounterFromOrigin'.

at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean
breakConnection)

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception,
Boolean breakConnection)

at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()

at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand
cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler,
TdsParserStateObject stateObj)

at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName,
Boolean async)

at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult
result, String methodName, Boolean sendToPipe)

at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

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)

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* r_file_path, SCRequestHandlerManager scRequestHandlerManager)





Reason:

The main reason is a code problem in AX that
generates a wrong WHERE criteria when figuring out the connection-string for
the AX database because of which it picks the first connection-profile mapped
to the Store Connect profile mapped to the AOS profile. If the database profile
happens to be mapped first, then the connection-string for the Store database
is used as if it was the AX database causing the
"REPLICATIONCOUNTERFROMORIGIN" field missing error.

SELECT * FROM
[RETAILCONNCONNECTIONPROFILE]

Incorrect setup, were the database profile was
created before the AOS profile






Correct setup:





Workaround:

1.

The normal setup is to have two store connects installed.

• 
  One store connect profile for HQ attached to the
  AOS profile
• 
  One store connect profile for the store attached
  to the database profile

2.

Second workaround, Delete all profiles

Create the profiles again.

Map the AOS profile to the Store Connect profile first.

Map the Database profile to the Store Connect profile next.



This issue will be fixed in the next major release, expected 6.2


Author: Kim
Truelsen

Date: 10/6-2012




Источник: http://blogs.msdn.com/b/axsupport/ar...ing-p-job.aspx