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.
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 invoice 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:
-
Connect the device containing the user's backup copy of Winner.
Note: For example on a USB flash drive, or an external hard drive. -
Open Windows File Explorer and navigate to the device containing the user's Winner backup.
-
Right-click the Winner folder and select Copy.
-
Navigate to where user's Winner installation was installed, right-click and select Paste.
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. -
If the Replace or Skip Files dialogue box appears, select Replace the files in the destination.
Note: The copying process may take several minutes.
Recover from Winner Info
- Exit Winner.
- Click the Windows Start icon and select Winner Info.
Note: Users can also enter Winner Info into the search bar.
- In the Winner - System information window, select the Maintenance tab.
-
Left-click the tick box next to Recover catalogue database.
- Click Save & Close.
Note! If the user has multiple project databases, it is advisable to click the Project folders drop-down menu and perform the recovery for large databases separately. - 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.
- Right-click the PRODUCTS.btr file and select Rename.
Note: Or the file identified in the error message.
- Rename the damaged file, for example to PRODUCTS_damaged.btr.
- 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.
- Once the recovery process is complete, users will be prompted to confirm their index settings.
Click the Reset option and then click OK.
Note! Tt is recommended users check the indexes of their most important catalogues.
Related articles
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