Skip to main content

How to repair a Btrieve error in the statistics 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 are protected from statistics database errors, as users' statistics are saved on the Flex platform. For more information, see What is the difference between Winner Flex and Winner Design?

 

In 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 statistics 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 statistics data. For more information, 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 statistics database they can restore a manual backup or use Winner Info to recover the statistics 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 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. Tick the checkbox Recover statistic information for all projects in the Project folders section.
    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.

  5. Click Save & Close.

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

  8. Rename the file, for example to PRJINFO_damaged.btr.

  9. Start Winner Design 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

Creating a backup or copy of Winner Design

What is the difference between Winner Flex and Winner Design?

New to the Support Centre? Look here!

How to repair a Btrieve error in the invoice database

How to repair a Btrieve error in the project database

How to repair a Btrieve error in the catalogue database

Related articles