Auto-number on form and Number maintenance table

[naxis alx]

I m working on alm_license table

I have a line for numbering on All > number maintenance (sys_number)

this is record is used to to make the auto numbering.

On the the Control tab of Alm_licence form configuration Auto_number is not checked but numbering works with record in sys_number table.

When I check Auto-number field this is what I get

When I try to save I get a duplicate 

java.sql.BatchUpdateException: (conn=872658) Duplicate entry 'alm_license' for key 'category'

My question is why the data in sys_number is not reflecting in Auto-number fields although theses fields are inserted in sys_number table?

I spent some time to figure out where the prefix in alm_license table numbering were coming from.

[Alexandre Magea]

Hello,

I've never experienced this issue myself but I think a colleague of mine had something similar.

She ended up changing the Number Counters to fix her issue.

Hope it might help.

Alex

[Sagar Pagar]

Hi,

Navigate to Number maintenance table and search with table name.

in related links click Show Counter.

The count should be match/same with last number in your table.

if not then update to last number as count. it will solve your issue.

Thanks,

Sagar Pagar

[naxis alx]

Hello, thank you for you reply.

My concern is more why the record in the Number maintenance table is not reflecting on the form's Auto-number section fields although when you check the Auto number field and try to update, it tries to insert a record in Number maintenance table.

If you create a record in the Number maintenance table for a table that record will be taken for the numbering but will not reflect in the Auto-number fields on the form control section.

Servicenow dev team should check this.