After re-initialization of the Store, the customer can not log in to MC and POS at the store

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&amp; 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&amp; 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&amp; task, Boolean&amp; usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean&amp; usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at ‪‌‏‫‬‫‎‮‬‪‪‎‍‎‫‎‮‏‪‌‮.‌‏‭‬‭‏‌‮‪‭‏‏‏‭‫‬‭‮(String , Int32 , OperationType )
   at ‪‌‏‫‬‫‎‮‬‪‪‎‍‎‫‎‮‏‪‌‮.‎‎‪‮‫‌‪‫‬‌‌‫‌‭‮‫‍‍‌‏‫‏‎‌‮[&#x1;](&#x1; , 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 ...

    • Inventory Audit report showing Blank After Store Re-initialization

      Problem Statement Inventory Audit report showing Blank After Store Re-initialization Investigation Upon reviewing the issue, it was found that the inventory log data was missing in the respective SQL table. After further inspection, we identified ...

    • 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 ...