Synchronize Next Keys

The Service Management database includes a NextKeys table that lists the last value used for alphanumeric keys whose system-generated value can have a prefix. For example, purchase orders can include a prefix like PO, so the order numbers would be PO00001115, PO00001116, and so on. The value in NextKeys is incremented to determine the next system-generated value for the key.

Occasionally, the data in the NextKeys table gets out of synchronization with the contents of the other database tables that contain the key values. When this happens, the system shows "duplicate key" error messages.

Use this utility to synchronize the NextKeys table with the contents of the database tables that contain the key values. The Synchronize Next Keys form rebuilds only from local site data.

Note: To prevent blocking, this utility should be run only when no other users are logged into the application database.