Break Consolidation into Inidividual Transactions

Break Consolidation into Inidividual Transactions

** Internal Notes for Support Team Only**


Steps

The below activity must be done in non business hours and the integration/replication monitors must be cleared.


1. Take the SAP database backup


2. Stop the Replication on all stores and HO


3. Stop the Integration Service


4. Change the UseTransactionConsolidation to False in CfgEnterprise table

UPDATE CfgEnterprise SET UseTransactionConsolidation = 0 WHERE UseTransactionConsolidation = 1


5. Change the IsConsolidated to False in ConTrxTransactionMapping table

UPDATE ConTrxTransactionMapping SET IsConsolidated = 0 WHERE ConsolidatedTransactionKey = 'Put Consolidated Transction key' AND IsConsolidated = 1


6. Mark the stuck event as success

UPDATE RepIntegrationLog SET Flag = 1, Status = 0, ErrorMessage = 'Manual adjustment' WHERE SourceType = 200 AND SourceKey = 'Put Consolidated Transction key'AND Status = 1


7. Open the individual events (approx. 300)

UPDATE RepIntegrationLog SET Flag = 0 WHERE SourceType = 143 AND Flag = 1 AND SourceKey IN (SELECT TransactionKey FROM ConTrxTransactionMapping WHERE     ConsolidatedTransactionKey = 'Put Consolidated Transction key')


8. Start the Integration Service


9. Once all the transactions (approx. 300 ) are cleared from the integration monitor then reset the consolidation flag to true

UPDATE CfgEnterprise SET UseTransactionConsolidation = 1 WHERE UseTransactionConsolidation = 0


10. Restart the Replication Service on all stores and HO



    • Related Articles

    • How to break consolidation into inidividual transaction.

      Environment: iVend Version 6.6 with SAPB1 9.2 Problem Statement: How to break consolidation into individual transaction. Symptoms: Not Applicable Resolution/Work Around: Follow the below steps. 1. Take the SAP database backup 2. Stop the Replication ...

    • Kit Item Break

      Product version: iVend 6.6 latest patch Problem statement: We have created items as Kit. These items in the Kit are individually selling items also. In some cases we just need to open the kit and sold these items individually In these cases how we ...

    • Sale transactions are not syncing from iVend to SAP, the rest of the events are syncing to SAP

      Version Not the version-specific Issue The issue is reported that only Sale transactions are not syncing from iVend to SAP. However, the rest of the events are syncing to SAP without any issue. Resolution It was analysed that all the transactions ...

    • POS - Business Transactions

      Introduction iVend Add-on Framework is used for writing Custom Business Logic independently by a programmer. iVend Addon allows to extend business logic either in Management Console or at the Terminal POS. The addon framework allows deployment of ...

    • POS - Business Transactions

      Introduction iVend Add-on Framework is used for writing Custom Business Logic independently by a programmer. iVend Addon allows to extend business logic either in Management Console or at the Terminal POS.The addon framework allows deployment of ...