Changing the next available ID for new requests

In this topic:

Database command scenarios for changing the next available request ID

The Request ID is used to automatically generate the unique index number attached to each BMC Remedy AR System request. Under some conditions, you might need to reset the next available ID. For example, you might need to establish different ranges for a similar form on two different servers, or you might need to reserve a range of numbers for later use.

You must restart the AR System server to see the latest request IDs.

Note

Do not change the next available ID to a number lower than the greatest existing ID. The Request ID field value must be unique within BMC Remedy AR System, and resetting the ID to a lower number could conflict with existing Request ID field values. If you try to submit a request with an existing ID, BMC Remedy AR System returns an error and prevents the request from being submitted until the conflict is resolved.

If you must change the next available ID, change it when the system is not in use to avoid conflicts with users who are submitting new requests.

To change the next available ID for a form in an SQL database

Stop AR System server.
Using any front-end tool that provides direct access to an SQL database, log in as a user with write access to the AR System tables.
Connect to the AR System table area.
Find the Request ID field for the form that you want to modify. The maximum next ID range is 9999999999 (10 digits). We allow five characters for the Request ID field prefix.
Update the next available ID.
Restart the AR System server.

Database command scenarios for changing the next available request ID

The following scenarios show how to change the next available ID for Oracle, and Microsoft SQL Server databases. In the scenarios, the next available ID for a form named ZZZ is changed from the current value of 1291 to a new value of 25000.

Oracle scenario

% sqlplus
Enter user-name: ARAdmin
Enter password: <password> (AR#Admin# by default.)
SQL>select name, nextId from ARAdmin.arschema where name ='ZZZ';
NAME NEXTID
------------------------------ ----------
ZZZ 1291
SQL>update ARAdmin.arschema set nextId = 25000 where name = 'ZZZ';
1 row updated.

SQL>Commit;

commit complete

SQL>exit

Microsoft SQL Server scenario

% isql -Usa
Password: <password>
1>use ARSystem
2>go
1>select name, nextId from arschema where name = 'ZZZ'
2>go
name nextId
ZZZ 1291
------------------------------ ----------
(1 row affected)
1>update arschema set nextId = 25000 where name = 'ZZZ'
2>go
(1 row affected)
1>exit

PostgreSQL scenario

-bash-4.2$ psql
Password:
psql (10.19)
Type "help" for help.

postgres=# \c ARSystem
You are now connected to database "ARSystem" as user "postgres".
ARSystem=# select name, nextId from arschema where name = 'ZZZ';
name | nextid
------+--------
ZZZ | 1291
(1 row)

ARSystem=# update arschema set nextId = 25000 where name = 'ZZZ';
UPDATE 1
ARSystem=# exit