Store has been deleted and iVend HO database log grows very fast in Drive

Store has been deleted and iVend HO database log grows very fast in Drive

Environment:

iVend Version 6.5 Update 4 with SAP B1 9.2

Problem Statement:

Store has been deleted and iVend  HO database log grows very fast in Drive.


Symptoms:

Environment Specific.

Resolution/Work Around:

If store was active in iVend Enterprise and getting replication events from Enterprise MC as well and now if you marked the store as DELETED from iVend Enterprise,iVend Replication events towards this store will be deleted automatically. As Store was active in iVend since 2018 , however physically closed, so its replication events would be high and it will take time
As you are facing High database size, suggest you to shrink the database from SQL Server . HO Database shrunken and size remain the same. We have suggested to try and increase E drive size so that SQL can clear the data.

Recommendations/Suggestion: 

Not Applicable

    • Related Articles

    • ISSUES WHEN INTIALIZING MASTER TABLES FROM SAP: "iVend 6.*.*.* add-on failed to update the database"

      Product version 6.5 Update 6 Problem statement Getting Error "iVend 6.*.*.* add-on failed to update the database" when initializing master tables from SAP Reason CXSINTEGRATION DATABASE IS DELETED SAP database, already initialized with iVend database ...

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

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

    • Cannot open database 'CXSIntegration' login failed

      Environment: iVend 6.6 Problem Statement: Cannot open database 'CXSIntegration' login failed Symptoms: Environment Specific Resolution/Work Around: It seems wrong SQL password is entered for user "sa". So need to check correct password for SQL login ...

    • SQL Queries : iVend Enterprise /HO database Purge

      ****************INTERNAL TO SUPPORT TEAM ( Not for Customers) ************************* Note:-This article is created only for Support team and will be done along with product expert. Environment: iVend 6.6 integrated with SAPB1 Problem Statement: ...