Get Next Incremental Number skipping values

[Katie A]

Hello, I have a Business Rule on the CMDB CI Computer table that will create a new asset tag "BEFORE" "INSERT".

I noticed that the auto-number counter is SKIPPING values. It starts at 30,000 and creates the new asset tag but it only creates even-numbers. So it started at 30,000 and the next one was 30,0002 and the next was 30,0004 and 30,0006 etc.

I have tested this by creating a bunch of new computers and each time it SKIPS the next odd number and jumps ahead to the next even number.

What could be the issue?

function onBefore(current, previous) {

  //Set asset tag incremental number maintenance counter on Configuration Item table

  current.asset_tag = getNextObjNumberPadded();

}

[Katie A]

I tried an onAfter business rule but it didn't work, the values are still skipping to the next one.

function onAfter(current, previous) {

  //Set asset tag incremental number maintenance counter on Configuration Item table

  current.asset_tag = getNextObjNumberPadded();

  current.setWorkflow(false); // Do not run business rules

  current.autoSysFields(false); // Do not update system fields

  current.update();

}

[Katie A]

The root cause of the issue was that there was another field on that table (a custom field created years ago by a previous administrator) that was also using the same numbering script. So I removed that field and it is working. Thanks all for the help.

[Chuck Tomasi]

Been there - done that. Hated it.

[Community Alums]

Aha! It was something doubling it up!