Monday 12 September 2016

AX Retail Pos Error Number 13000 – Could not load all external service modules

Error number 13000, Error when launching Retail POS: could not load all external service modules









Missing dll in the “C:\Program Files (x86)\Microsoft Dynamics AX\60\Retail POS\Connectors” folder.
From Folder => Copying “Microsoft.Dynamics.Retail.TestConnector.dll” from “C:\Program Files (x86)\Microsoft Dynamics AX\60\Client\Bin\Connectors” 
TO Folder=> “C:\Program Files (x86)\Microsoft Dynamics AX\60\Retail POS\Connectors”

Sunday 4 September 2016

Getting Error :- Cannot insert multiple records in Security user role (SecurityUserRole). The record already exists.

When Insert Users form System Administration Getting Error :- Cannot insert multiple records in Security user role (SecurityUserRole). The record already exists.

 
 
 

Solution: Open SSMS, SQL DB, Select the MicrosoftDynamicsAX database and run the below query 

Select * from dbo.SecurityUserRole
Delete from dbo.SecurityUserRole Where User_='USERID'

Getting Error When Sync Database Invalid Column Name "DateRequested"

Getting Error When Sync Database Invalid Column Name "DateRequested" in Event Viewer

-----------------------------------------EVENT LOG--------------------------------------------------------------
DataException happenes when updating download session. Error Detail: System.Data.EntityCommandExecutionException: An error occurred while executing the command definition. See the inner exception for details. ---> System.Data.SqlClient.SqlException: Invalid column name 'DateRequested'.
Invalid column name 'DateDownloaded'.Invalid column name 'DateApplied'.
Invalid column name 'Status'.Invalid column name 'Message'. 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)

-----------------------------------------EVENT LOG--------------------------------------------------------------

This error getting because of wrong message DataBase settings in Async client settings. Change Async Client Database Selection option Enter new message DB as "Channel Massage Database" as AsyncHoustonMessageDB & select existing store database as Store database option. In Async client settings you may be using Async Server message DB in the message DB option. Use only Store message DB in the Async client settings.