how is (version) "update in progress" flagged for other computers

[Jess]

First, this office is quite out-of-date, which I'm attempting to fix. We are on version 17.4. Sorry!

Also the database and shared folders are on a linux server for stability and ease of backup. I don't think this is relevant to this particular issue.

The Open Dental application on one of our computers attempted to run a version update, which I believe failed because the file it expected to find online was not available. It's no issue for that computer. I can still start the OD application and perform all tasks.

On other computers on the network, however, immediately after starting the OD application I get:

An update is in progress on workstation: 'FRONT-DESK'.

Not allowed to start Open Dental Software while an update is in progress.
Please wait and click 'Try Again'.

I have looked for hidden files in the shared folders and I have tried to find references to this update in the database, but I can't find anything. There was a reference in the securitylog table but deleting that row didn't help.

What do I need to do to clear this flag so the Open Dental application may be used on other computers in the office?

[Jess]

FYI, this is stored in the PREFERENCE table. Tools->Database Maintenance->Tools->Clear on the still-functional host will update the offending row, or in at least some cases running OD in admin mode on an authorized host will do this clearing automatically.

Code: Select all

mysql> select * from opendental.preference where PrefName like "%updatein%";
+--------------------------------+-------------+---------+-----------------------------------------------------------------------------------------------------------------------------------+
| PrefName                       | ValueString | PrefNum | Comments                                                                                                                          |
+--------------------------------+-------------+---------+-----------------------------------------------------------------------------------------------------------------------------------+
| UpdateInProgressOnComputerName |             |     227 | Will be blank if update is complete.  If in the middle of an update, the named workstation is the only one allowed to startup OD. |
+--------------------------------+-------------+---------+-----------------------------------------------------------------------------------------------------------------------------------+

In future I will pay more attention to this table!