OroTimesheet 4.x (English)
OroTimesheet 4.x (French)

Error messages examples:
- "I/O error for file ..."
- "Error while trying to read from file ..."
- "Database file appears corrupt"
- "Database corrupted"


When using OroTimesheet in day-to-day operation, the database is sometimes subjected to events that pose minor problems to database structures. These events include:

- Abnormal termination of OroTimesheet or INTERBASE application.

- Write errors in the operating system or hardware.

- Hardware failures.

If OroTimesheet database become corrupted or damaged, here are the steps to follow to fix it. For more detailled information about correcting database errors, refer to the "Operations Guide" manual in the INTERBASE documentation (downloadable separately from our web site at http://www.orologic.com/downloads ).

If INTERBASE is installed on a LINUX server, you need to have the "Super Server" version of INTERBASE installed on your LINUX server to be able to use the "Database utility" mentionned in the procedure below. If you have the "Classic Server" version of INTERBASE installed on your LINUX server, refer to the "Operations Guide" manual in the INTERBASE documentation to use the "gfix" and "gbak" command line utilities instead of the "Database utility"

Before beginning, be sure that nobody access the damaged database or use OroTimesheet 4.

It is strongly recommended to make a copy of the OroTimesheet database file (usually "OT4.GDB") before trying to repair it. Use the operating system to make a copy of the database (Under Windows use "Windows Explorer" or the "copy" command. Under Unix/Linux use the "cp" command). By doing this, you ensure to have a copy of your database before any modification to this one.


1- Run the "Database utility" included with OroTimesheet 4.

2- Select the "Validation" tab.

4- Click on the top right button (button on the right side of the "On a remote server" radio button) to display the list of connections.

5- Select the connection to the database you want to repair and click the "OK" buton.

5- Type the password of the InterBase user "SYSDBA" into the "Password" field. (If you did not changed the password of the InterBase user "SYSDBA", the default password is "masterkey")

6- Check the following 3 options:

"Validate record fragments"
"Mark corrupt records"
"Ignore checksums errors"

Don't check any other options.

7- Click the "Start validation" button and click "Yes" to the confirmation.

8- After the validation process is finished, you get the "Validation completed" message. Click the "OK" button. A summary of the validation process is displayed on screen and can have the following format:

Summary of validation errors

Number of data page errors : 1
Number of database page errors : 2


Close this window by clicking the "X" button at the top right.

9- To complete the database repair process, a backup and a restore of the database must be done.

10- Select the "Backup" tab.

11- Click on the top right button (button on the right side of the "On a remote server" radio button) to display the list of connections.

12- Select the connection to the database you repaired and click the "OK" button.

13- Type the password of the InterBase user "SYSDBA" into the "Password" field. (If you did not changed the password of the InterBase user "SYSDBA", the default password is "masterkey")

14- Check the following 3 options:

"Ignore checksums"
"Ignore transactions in limbo"
"Disable garbage collection"

Don't check any other option.

15- Click the "Start Backup" button and click "Yes" to the confirmation.

16- When the backup process is finished, the "Backup successfully completed" message is displayed. Click the "OK" button.

17- Select the "Restore" tab.

18- Click on the top right button (button on the right side of the "On a remote server" radio button) to display the list of connections.

19- Select the connection to the database you repaired and click the "OK" buton.

20- Type the password of the InterBase user "SYSDBA" into the "Password" field. (If you did not changed the password of the InterBase user "SYSDBA", the default password is "masterkey")

21- Don't check any other option.

22- Click the "Start Restore" button and click "Yes" to the confirmation.

23- When the restore process is finished, the "Restore successfully completed" message is displayed. Click the "OK" button.

24- Quit the "Database utility".

25- The database is now repaired. You can run OroTimesheet 4.

Information

See also FAQ 10037-EN