mO SharemO Share

"A severe error occurred on the current command. The results, if any, should be discarded" - Error message displayed while running data sync at POS

Owned by
Aparajita Basu Roy
Sept 15, 2022
2 min read

SYMPTOMS

The following error is shown during sync in GINESYS POS - "A severe error occurred on the current command. The results, if any, should be discarded"

CAUSE

One of the probable causes for the above error is an index corruption in the POS database.

RESOLUTION

  1. Run the Database Locator application supplied with GINESYS POS.
    1. Option 1: Right click on the GINESYS POS application shortcut on your desktop and select 'Open file location'. Find the 'DatabaseLocator.exe' file among the application files and double click the same to run the application.
    2. Option 2 (from Program Menu as per Windows 7): Run the following Start Menu > All Programs > GINESYS > Database Locator

  2. In the Database Locator utility click the Utilities tab.

  3. Click Rebuild All Indexes button. This action will take some time to complete based on your data volume.

  4. After completing the above steps your indexes should be built properly. Now, for safety, you should take a Full Backup which will also check the integrity of the data.

  5. Log on to GINESYS POS with Admin privileges (for Database Backup).

  6. Go to Application Control > Administration > Database and click on Take a FULL Backup Now.

  7. In the Backup utility, click on Start Backup Now.

  8. In case any integrity error is there in the database you will be notified of the same by this utility.

  9. Once the backup has completed without any error, try to resume data sync operation and check. 

    To ensure integrity of your POS database and also for data safety you should have a full backup threshold policy set to 1 day which implies that the POS stores would have to take a Full Backup every day. This will ensure that database the integrity check is performed every day during the full backup process. 

    While a Full Backup Threshold is set to 1, POS users will not be able to do POS billing/invoicing beyond a day without taking a Full Backup.

This should resolve your issue, in case you face it again please contact our Ginesys Care portal - https://care.ginesys.in/