Resource Dynamics, Inc.

Tele-Support HelpDesk Hot Tips

Problem:

Getting error message unable to find DBHistory_ID

Cause:

This is caused by a missing table in your database.  through version upgrades, somewhere along the line a patch did not update successfully.  Most likely because the database was not in an exclusive mode.

Solution:

Manually create the table.

Open your HelpDesk dagabase exclusively to edit.

Add New Table

Table Name = DBHISTORY

ACCESS format:

DBHistory_ID, Data Type = Auto Number

PatchID, Data Type = Text, length 30

PatchApplied, Data Type = Date/Time

In SQL, open exclusively to edit, add new table

DBHistory_ID, Data Type = INT, length 4

PatchID, Data type = Varchar, length 30

PatchApplied, Data Type = Date/Time