SQL query to disable "Use Inter-Store Transactions"

SQL query to disable "Use Inter-Store Transactions"

************************************ INTERNAL *********************************************************

Consult Support Manager/Technical manager before using this query

Below Queries is Only for 6.5 Update x

1. STOP Replication at HO.
2. Take Backup of RepObjectMapDB
Select * into RepObjectMapDB_Backup from RepObjectMapDB
3. Run Below two Queries at HO
Update 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

Select 'exec DataNotification @pSourceType=217, @pSourceKey=' + CONVERT(VARCHAR(100),objectID) + ', @pBatchKey=0, @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=0, @pOperationType=1, @pUserKey=1'
from
CfgEnterprise WITH (NOLOCK)

6. start Replication at HO.

 Below Queries is for 6.6 Update Only

--------------------------------------

1. STOP Replication at HO.
2. Take Backup of RepObjectMapDB
Select * into RepObjectMapDB_Backup from RepObjectMapDB

3. Run Below two Queries at HO
Update RepObjectMapDB set TableType = 0 where UseForInterStore = 1 and TableName like 'trx%'
Update CfgEnterprise set UseInterstoreTransaction = 0, ExchangeTransactionDataBetweenStore = 0

4. 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)

5. start Replication at HO.
6. Close the MC and open again
7. 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

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.



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

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

    • Inter-StoreCommunicationsUsingNotifications

      Overview Inter-store communication is key in a retail environment. In iVend Retail, the system allows users to setup inter-store notifications for the following back office transactions: · Stock Transfer Request · Stock Transfer Shipment · Purchase ...

    • Inventory Data not replicated with setting Replicate Inter-Store Inventory.

      Environment: iVend 6.6 Product Query: Can we check Business transaction like Goods Issue, Goods Receipt etc of one store in another store using functionality "Replicate Inter Store Inventory" (Shown in the below image): Proposed Solution: When Goods ...

    • Query for generate the email message which SQL job got executed or not

      Environment: iVend 6.6 integrated with SAPB1 Problem Statement: Query for generate the email message which SQL job got executed or not Symptoms: NA Resolution/Work Around: We can use below query to send email message which SQL job got executed or not ...