Issue: Occasionally, after installing a new server, you will want to change the BI numbers of future Batch Instances so that there’s no duplication in BI numbers.

 

Solution: You can change a setting in the Database to whatever number you want moving forward.

The following query needs to be executed on batch_instance table. You will need to figure out the Hex – Decimal conversion (The 1001 in my example will start from BI3E9).

 

MYSQL :

 

ALTER TABLE batch_instance AUTO_INCREMENT=1001;

 

MSSQL :

 

DBCC CHECKIDENT (batch_instance, RESEED, 1001);

Was this article helpful to you?

Rob Marshall

Comments are closed.