Starting the UpdateDB Utility

You can start the UpdateDB Utility by right-clicking the Worktime tab in the Access Manager interface window.

As a result, the UpdateDB Utility window will open.

Working with the UpdateDB Utility

You can work with the UpdateDB Utility as follows:

1. The Triggers area (1) displays triggers. If necessary, for example, when upgrading to a newer version of ACFA PSIM, you must update the triggers by clicking the Update Triggers button (2). The progress is displayed in the area (3). To cancel the action, click the button (4).

2. To update the database, click the Update DB button (7). Both triggers and stored procedures, required for the correct operation of the subsystem, are updated. You need to do this once when connecting the Time and Attendance subsystem. The progress is displayed in the area (3). To cancel the action, click the button (4).

3. If it is necessary to take into account the passes made before configuring the Time and Attendance subsystem, after starting the Time and Attendance subsystem in Axxon PSIM, re-account the database using the Re-account by Protocol (5) and Re-account by Region Pass (6) buttons. The progress is displayed in the area (3). To cancel the action, click the button (4).
   

   It is strongly not recommended to use the re-account buttons without recommendations of AxxonSoft technical support specialists! When you click the Re-account by Protocol button (5), the dbo.Region_Enter_Exit table is completely cleared and filled out again depending on the pass information currently contained in the dbo.protocol table.  When you click the Re-account by Region Pass button (6), the dbo.Region_Enter_Exit table is completely cleared and filled out again depending on the pass information currently contained in the dbo.Region_pass table. Attention! Because of the different depth of the event archive of these tables, there is a risk of data loss when clearing the dbo.Region_Enter_Exit table.

   If the update (re-account) succeeds or fails, the corresponding message appears: about success in the first case and failure in the second case.
   
   
   

   If the reaccounting is completed with an error, we recommend increasing the time for waiting for the system response by changing the value of the RecalcTimeoutInSec parameter in the account_manager_run.config file. The default value is 600 seconds.

   
   
4. Click the OK button in the message window.

5. To close the UpdateDB Utility window, click the button in the top right corner of the form.

Working with the UpdateDB Utility is complete.