Skip to main content

How to repair a Btrieve error in the catalogue database

Bally
  • Updated

Note! The following article is intended for IT service support professionals only.

Note! Due to technical content, the following article is only available in English (EN-GB).

 

In Winner, users may experience a Btrieve error, for example Btrieve error code #54 (variable page error) or Btrieve error code #2 (I/O error), which can corrupt the user's catalogue database.

If the user's Btrieve error is not in the catalogue database, they should instead consult one of the following:

 

Btrieve errors can be caused by any of the following:

  • Unstable network connection, for example a loss of connection from disconnecting an ethernet cable or loss of power to the network server.

  • Forced shutdowns, for example the user's PC being shutdown by holding the power button.

  • An electrical blackout, brownout or other sudden loss of power, for example the mains power outlet for the user's PC being switched off.

  • Using End task in Windows Task Manager to forcibly stop the Winner program.

  • The operating system (OS) of the user's PC crashing.

  • Corrupted files on the user's PC.

Note! The best way for a user to protect against the effects of a Btrieve error is for the user to frequently backup their invoice data. For more information, Winner Flex users should see Winner Flex: Backups. Winner Design users should see Creating a backup or copy of Winner Design.

 

If the user has a Btrieve error

If the user has a Btrieve error that has corrupted their catalogue database they can restore a manual backup or use Winner Info to recover the products database.

If the user is unsure about attempting either of these methods, they should contact our Support team for assistance. For more information, see New to the Support Centre? Look here!

 

Restore from a manual backup

To attempt this method, the user must have created a manual backup of their Winner installation. For more information, Winner Flex users should see Winner Flex: Backups. Winner Design users should see  Creating a backup or copy of Winner Design.

Note! Users should be aware that any progress made after their last backup will be lost.

 

To restore from a manual backup: 

  1. Connect the device containing the user's backup copy of Winner.
    Note: For example on a USB flash drive, or an external hard drive.

  2. Open Windows File Explorer and navigate to the device containing the user's Winner backup. Then navigate to Winner\DB. 

  3. Right-click the PRODUCTS folder and select Copy.

  4. Navigate to where the user's Winner installation was installed and then navigate to Winner\DB.
    Note: A user's Winner installation is located on the user's hard drive, normally the C: drive. A network installation will be located on a different drive. Users who are unsure should contact their IT support service provider.

  5. Right-click  the PRODUCT folder and select Rename. Enter a different name for the folder, for example, PRODUCT1.

  6. Right-click and select Paste. This will copy the PRODUCT folder from the user's backup to the Winner installation on their PC.

 

Recover from Winner Info

  1. Exit Winner.

  2. Click the Windows Start icon and select Winner Info.
    Note: Users can also enter Winner Info into the search bar.

  3. In the Winner - System information window, select the Maintenance tab.

  4. Left-click the tick box next to Recover catalogue database.

  5. Click Save & Close.

  6. Open Windows File Explorer and navigate to Winner\DB\PRODUCTS.
    Note: Normally located on the user's hard drive, normally the C: drive. A network installation will be located on a different drive. Users who are unsure should contact their IT support service provider.

  7. Right-click the PRODUCTS.btr file and select Rename.

  8. Rename the damaged file, for example to PRODUCTS_damaged.btr.

  9. Start Winner to begin the recovery process.
    Note: The recovery process may take several minutes, depending on the size of the database that is to be recovered.

  10. Once the recovery process is complete, users will be prompted to confirm their index settings.
    Click the Reset option and then click OK.
    Note! It is recommended users check the indexes of their most important catalogues. 

 

 

Related articles

Winner Flex: Backups

Creating a backup or copy of Winner Design

New to the Support Centre? Look here!

How to repair a Btrieve error in the catalogue database

How to repair a Btrieve error in the invoice database

How to repair a Btrieve error in the project database

Related articles