R151008: Repair Bills or Timer Database - V2.27+

Problem

These instructions only apply to RTG Bills and RTG Timer Version 2.27. For version 2.26, go here. For versions 2.17 through 2.25, go here. For earlier versions, go here.

Sometimes problems can occur in the RTG Bills or RTG Timer database. The cause might be a hardware problem, a software crash, or even a bug in RTG's software.

Certain problems are easily fixed with software that you can download by following the instructions on this page.

One such problem is the error message Invalid use of Null, which may occur when you try to edit a matter, fee, expense, payment, or adjustment. It also may occur when you try to view or print a bill, a prebill, or a report. When you click OK in response to the error message, RTG Bills exits.

This problem occurs when a record in the database contains bad data. A field in the record contains Null, which in database terminology means that the field was not given any value.

A few other problems can also be fixed by this software. RTG will refer you to this page if we believe the software described here can solve a problem for you.

 

Solution for
RTG Bills

You will install a small program that fixes bad database records. It puts appropriate "default" values in the fields that now contain Null. It also checks and may repair several other problems.

  1. Back up your data. We recommend using File > Backup in RTG Bills. If anything goes wrong, you can restore your data using File > Restore From Backup.

  2. All users should exit from RTG Bills and RTG Timer.

  3. To start RTG Bills, right-click the RTG Bills icon and choose Run as administrator. When RTG Bills appears, choose:

    File > Update > Yes > Check The Internet For Updates

  4. Ignore the list of updates. Click the Special button.

  5. On the Special Updates window, find Repair RTG Bills Database and click that item. A checkmark should appear next to it.

  6. Click Install to install this update.

  7. If the update is successful, the program will tell you that one update was applied. Click OK, Close, and Close again.

  8. Start RTG Bills again. Choose File > Tools from the menu. You should see Repair RTG Bills Database in the list of tools. Select it and click OK.

  9. The program should appear, with the title Repair RTG Bills Database. Click the Repair Database button. It says Done when it finishes.

  10. Choose File > Exit to leave the program.

Questions about this procedure should be directed to RTG Support.

 

Solution for
RTG Timer

The database problems described above for RTG Bills rarely occur in RTG Timer. However, if a problem does occur, we have a program to fix it.

You will install a small program that fixes bad database records. It puts appropriate "default" values in the fields that now contain Null.

  1. Back up your data. We recommend using File > Backup in RTG Timer. If anything goes wrong, you can restore your data using File > Restore From Backup.

  2. To start RTG Timer, right-click the RTG Timer icon and choose Run as administrator. When RTG Timer appears, choose:

    File > Update > Yes > Check The Internet For Updates

  3. Ignore the list of updates. Click the Special button.

  4. On the Special Updates window, find Repair RTG Timer Database and click that item. A checkmark should appear next to it.

  5. Click Install to install this update.

  6. If the update is successful, the program will tell you that one update was applied. Click OK, Close, and Close again.

  7. Start RTG Timer again. Choose File > Tools from the menu. You should see Repair RTG Timer Database in the list of tools. Select it and click OK.

  8. The program should appear, with the title Repair RTG Timer Database. Choose:

    File > Fix Fees and Expenses

    Click OK when it finishes.

  9. Choose File > Exit to leave the program.

Questions about this procedure should be directed to RTG Support.

 
 
 

 
What's New Site Map Software Orders Support Contact

Copyright © 2000-2024 RTG Data Systems | Privacy Policy