Steps to check the issue : 'Database size increase
Scenario :
If iVend database size is high in size, suggest to check the following information :
Steps :
1) Where is the user getting this abnormal data in size (Enterprise or Store)
2) What is the SQL server version. (Express edition has a limit and SQL version may help in narrowing down the cause)
3) Go to SQL server --> Right click on the concerned DB --> Click on Properties --> Click on Options -->(ask customer to) share the screenshot the recovery model should be "Simple"
4) Right click on the DB --> select Reports --> Disk usage by top tables --> share the screenshot of this screen with us
Check which table is occupying the most space and if it is an abnormal behavior.
5) Try to shrink the database in downtime with taking backup of existing one.
Precautions : such activities should be performed in customer downtime when noone is working on iVend databases.
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 ...Database health check & Optimization steps
Steps and walkthrough to do a health check and optimization of iVend database. The entire process broadly consists of 8 steps: Step 1: Take Backup of DB. Open SQL Server Management Studio Express and connect to the SQL server. Expand Databases. ...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 ...iVend POS Slowness Issue taking time to close one Check
Product Version iVend 6.5.6 Patch 2 Problem Statement IVend POS Slowness Issue (Currently System taking 2-3 minutes to close one Check ). Proposed Solution Sometimes users are facing problems with iVend POS slowness issues and because of which the ...Not able to re-initialize the Store from the backup file taken from the HO MC: Database size issue
Version 6.6, Not the version-specific Issue Not able to re-initialize the Store from the backup file taken from the Enterprise MC. Finding: Below is the error in the Event Viewer log of the Store server where the issue is occurring: "CREATE DATABASE ...