Data not purging on store server properly

Data not purging on store server properly

*********** For Internal CitiXsys Use only ***********

Environment : 

iVend 6.6 

Problem Description : 

Data is not purging on for a single store at the time of EOD.

Scenario :

On a store data not purging properly and the database growing larger by the day.  (on HO server, it shows that the purge ran successfully, but the local store server still has sales data, and data size not reduced).

Most likely you will need to purge data manually as of now.
You can request us to setup a remote session to help you with the data purge. 
General practice is to purge the data that are more than 2 months old.

Solution:



1) Check the Database Size and logs.

2) Check the Fragmentation of the database.

3) Check the Data Purge for a different date and check its affect at EOD.

4) Check if data not purged from iVend frond end then use then execute the following on Store DB and check the records.

Exec [sp_DatabasePurge] @purgeDate='4/30/2021',@purgeInventoryLog='1',@purgeAuditlog='1'   

Resolution/Work Around:

After run the Exec [sp_DatabasePurge] @purgeDate='4/30/2021',@purgeInventoryLog='1',@purgeAuditlog='1'  on Store DB data has been successfully purged for the mentioned date and reports all showing the records after mentioned date.

    • Related Articles

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

    • iVend POS - Purge Data to Reduce iVend Store database size

      Introduction The Data Purging feature in iVend helps the Administrator to control the size of the iVend database at each store. Data purging at stores is controlled centrally and is managed from the iVend Enterprise at Head Office. The Administrator ...

    • Offline Terminal POS Data Sync with Store

      iVend Retail - Offline Terminal POS Data Synchronisation with the Store server This document describes the Offline Terminal POS feature and the data synchronisation with the Store Server. · This feature allows the Terminal POS to function even if the ...

    • Store database purging manually

      ***************************** Internal to Citixsys Support Team********************************* Environment : iVend 6.6 7989 with SAPB1 Problem Statement : Store database doesn't purge by iVend MC End of day process. so there is need to purge the ...

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