After re-initialization of the Store, the customer can not log in to MC and POS at the store
Version
6.6, not the version-specific
Issue
After re-initialization of the Store, the customer can not log in to MC and POS at the store.
Cause
We can see the below error in the MC log file:
<InnerExceptionInfo>
<Type>System.Data.SqlClient.SqlException</Type>
<Message>Could not find stored procedure 'DataNotification'.</Message>
<Source>.Net SqlClient Data Provider</Source>
<TargetSite>Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action])</TargetSite>
and the below error in the POS log file:
<Event>
<Version>6.6.7747.25902</Version>
<Category>ERROR</Category>
<Time>7:34:59 PM</Time>
<Message>Could not find stored procedure 'DataNotification'.</Message>
<ExceptionInfo>
<Type>System.Data.SqlClient.SqlException</Type>
<Message>Could not find stored procedure 'DataNotification'.</Message>
<Source>.Net SqlClient Data Provider</Source>
<TargetSite>Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action])</TargetSite>
<StackTrace> 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)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at .(String , Int32 , OperationType )
at .[]( , Boolean )</StackTrace>
</ExceptionInfo>
</Event>
Resolution
As per the above-mentioned errors, it shows that the Store backup which is used to re-initialize the store is incomplete. So please take a fresh backup for the store from the Enterprise again and re-initialize it at the store.
This KB article concludes here.
Related Articles
Require to make the inventory as Zero for particular store
Environment: iVend 6.6 with SAP B1 10 Problem statement: Require to make the inventory as Zero for particular store. Symptoms: products Inventory show in negative and some are in positive numbers. Resolution/Work Around: There is need to check if SAP ...Store re-intialization Step
Product version: 6.5 Update 6 or 6.6 Problem statement: User want to re-intialize the store. Proposed solution: Suggested customer to re-initalize Store by creating Store backup file from iVend Enterprise MC screen only when replication is cleared ...After store re-initialization, no old transaction on the POS and not in store table TrxTransaction
Product version: Not a version-specific Problem statement: Customer re-initialized an existing Store as it was Crashed and now at that store after re-initialization process customer does not find any old transactions on the POS and not in SQL DB ...Addon information was not updated for newly created store
Environment: iVend 6.6 integrated with SAPB1 Problem Statement: Addon information was not updated for newly created store Symptoms: Not Applicable Resolution/Work Around: Issue is already fixed in the latest iVend patch (8567). As a workaround we ...Not able to re-initialize the Store from the backup file taken from the HO MC: Database size issue
Version 6.6, Not the version-specific Issue Not able to re-initialize the Store from the backup file taken from the Enterprise MC. Finding: Below is the error in the Event Viewer log of the Store server where the issue is occurring: "CREATE DATABASE ...