Issue:

How to Alter the BI Folder Naming Sequence?

Instead of starting with BI1 as the first Batch Instance name you can set the Starting Value to 5001.

Solution:

MySQL/MariaDB

Please use the below query for setting this value.

ALTER TABLE batch_instance AUTO_INCREMENT = 20481

As the Batch Instance Identifier is in Hexadecimal format. So we need to change the Id in decimal format for the same.This will set the next Batch Instance number to be BI5001 if the seed is changed to 20481.

5001(Hexa Decimal) = 20481 (Decimal)

MSSQL

Please use the below query for setting this value. This MUST be run by the sa user in MSSQL Management studio

DBCC CHECKIDENT (“batch_instance”, RESEED, 4983);

As the Batch Instance Identifier is in Hexadecimal format. So we need to change the Id in decimal format for the same. This will set the next Batch Instance number to be BI1377 if the seed is changed to 4983.

1377(Hexa Decimal) = 4983 (Decimal)

Was this article helpful to you?

Walter Lee

Comments are closed.