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.