Skip to main content

How to repair a Btrieve error in the invoice 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).

Note! Winner Flex users should not attempt to repair their invoice database without first contacting our Support team.

 

In Winner Flex and Winner Design, 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 invoice 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 invoice 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: 

  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.

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

  4. Navigate to where user's Winner installation was installed, right-click the Winner folder and select Rename. Enter a different name for the folder, for example Winner1.
    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.

  5.  Right-click and select Paste. This will copy the Winner folder from the user's backup to 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 invoice database.

  5. 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.

  6. Open Windows File Explorer and navigate to Winner\DB\Projects.
    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 SETTLMNT.btr file and select Rename.
    Note: Or the file identified in the error message.

  8. Rename the damaged file, for example to SETTLMNT_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.

 

 

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 statistics database

How to repair a Btrieve error in the project database

Related articles