iVend MC Enterprise Setting "Inter Store Transaction"

--INTERNAL TO CXS SUPPORT TEAM---

Problem Statement

In the Enterprise Setting section, User selected the 'Use Inter-store Transactions' field. want to uncheck it but the system does not allow it.

Environment

iVend 6.6 With SAPB1

Symptoms

Resolution/Work Around

We have to make the required changes using sql queries on HO DB and replication events were generated which will make changes on all the stores once replication is clear.

1. STOP Replication at HO.

2. Take Backup of RepObjectMapDBSelect * into RepObjectMapDB_Backup from RepObjectMapDB

3. Run Below two Queries at HOUpdate RepObjectMapDB set TableType = 0 where UseForInterStore = 1 and TableName like 'trx%'

4. Update CfgEnterprise set UseInterstoreTransaction = 0, ExchangeTransactionDataBetweenStore = 0

5. Now run Below Query at HO and execute result also to generate the replication events for change made on HO database

Declare @Batchkey nvarchar(100)

Set @BatchKey = newid()

Select 'exec DataNotification @pSourceType=217, @pSourceKey=''' + CONVERT(VARCHAR(100),objectID) + ''', @pBatchKey='''+ @BatchKey+''', @pOperationType=1, @pUserKey=''1'''

from

RepObjectMapDB WITH (NOLOCK) Where UseForInterStore = 1 and TableName like 'trx%'

UNION

Select 'exec DataNotification @pSourceType=8, @pSourceKey=''' + CONVERT(VARCHAR(100),EnterpriseKey) + ''', @pBatchKey='''+ @BatchKey+''', @pOperationType=1, @pUserKey=''1'''

from

CfgEnterprise WITH (NOLOCK)

6. start Replication at HO.

7. Close the MC and open again

8. Now to cross Check the changes made, run below queries on HO DB and any one Store DB

select * from RepObjectMapDB where UseForInterStore=1 and TableType=1

select UseInterstoreTransaction,* from CfgEnterprise

This KB article concludes here.

Note

1. On store DB run the queries after 5 minutes once turning on the replication service on HO

2. Changes in settings will have effect on the new transactions done onwards and old transactions will go without changes.