Saturday, 3 September 2016

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.