Invalid insert. Service with SN App Service ID: BSNXXXXXXX already exists.

[Ajay37]

Hi All,

I am getting the above error, when I am trying to insert record into the custom tables extended from the Business Service(cmdb_ci_service) table. I have found the solution of updating Show counter in Number maintenance. But my doubt is, why it happens? It used to work previously, but suddenly it is throwing error like this. And also, the number field is getting updated with the number during insertion of the record. If any logic is updating that number, it should consider the latest number right? but why it is taking the existing numbers? Could anyone has an idea on this?

Note: We don't have auto number enabled on this table

Thanks

[wilco_luis]

Thank you, this worked for me.  The counter was behind in my case so manually updating it solved the problem.

[Tamara11]

Deleting the entire record made the next Business service create with no prefix (BSN0000#####).

[Rahul Priyadars]

Is this your custom Attribute - SN APP SERVICE ID which acts as a counter for numbering?

is sys auto conter is getting set each time?

i think this KB will help you-

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0829722

Regards

RP

[Ajay37]

Hi @Rahul Priyadarshy ,

Thanks for the response.

Is this your custom Attribute - SN APP SERVICE ID which acts as a counter for numbering?

Ans: This is the OOB rule written for checking the uniqueness of number field.

is sys auto counter is getting set each time?

Ans: I don't have any idea about this. Could you please brief?

I have gone through KB, but I don't have any record of custom table created in Number Counters table. Only the parent table has the record in that table.