Symptom
The following error message appears in the LenelError.log file during replication:
"1/15/2008 3:21:16 PM [Replicator] Could not validate timestamp on pre-allocated ID set for [BADGE NUMBER] between region [REGION] and master [MASTER]. The IDS_ALLOCATED table for [BADGE NUMBER] with DBID[10] and table ID [53] does not exist!"
Note: Information in brackets will be specific to the devices, regional and master servers, and IDs used in your system.
"1/15/2008 3:21:16 PM [Replicator] Could not validate timestamp on pre-allocated ID set for [BADGE NUMBER] between region [REGION] and master [MASTER]. The IDS_ALLOCATED table for [BADGE NUMBER] with DBID[10] and table ID [53] does not exist!"
Note: Information in brackets will be specific to the devices, regional and master servers, and IDs used in your system.
Resolution
Allocate new sets of IDs for all pre-allocated IDs used by the enterprise. This can be done by following these steps.
- Log into Replication Administration on a regional or master server, using the SA account.
- Open the Allocated IDs form for the region experiencing the failure.
- In the IDs list, select the item mentioned in the error message (make sure the item has a red check mark).
- Click [Get More IDs].
- The ID Allocation Operation form opens. Select the Obtain more pre-allocated IDs for SELECTED tables radio button, then click [OK].
- A Replication Administration warning opens, stating "ID Allocation happens automatically...Are you sure you would like to continue with this operation?" Click [Yes].
- The Pre-allocated ID Ranges form opens. The number of IDs to be obtained is listed for each table affected. Click [Allocate New IDs Now].
- Prompt and warning dialogs might open. Click [Yes] in each dialog.
- You might need to repeat steps 1-8 for each additional regional or master server in the enterprise.