kb article number getting duplicated after migration

[bhupendra paree]

Hello All , 

Few days ago, I migrated Knowledge articles from instance A to Instance B. But after migration ; there are several Kbs found with same number in KB article list (one record from A and another record from B ). Main issue is , they both are now having same number and even the number is non editable. 

And even if number becomes editable what nomenclature I can use ,recommended in corporate.

In above screenshot,  Both kbs have same number(one from Instance A & one from B) ; But different short description . category and all. 
Please advise me the best possible way to get rid of this issue, as it is bit critical.

Thanks in advance.

[Hayo Lubbers]

Hi @bhupendra paree,

Have a look at the number range, you can (re)set the number here:

https://<your instance>.service-now.com/sys_number_counter_list.do?sysparm_query=table%3Dkb_knowledge&sysparm_view=

[bhupendra paree]

Thanks for such a quick response Hayo.

Can you please elaborate a bit more on this. How shall i proceed in kb table further.

[Hayo Lubbers]

Hi @bhupendra paree,

For (more or less) every table there is a number range. The number range current value is kept in the number counter table. You can set the number where you are currently.

More information regarding record numbers : https://docs.servicenow.com/bundle/tokyo-platform-administration/page/administer/field-administratio...

For the existing ones, that is an issue where you probably need to create some kind of migration script for. Be aware the knowledge articles have related records also referencing the number.

Hope this helps.

[Sohail Khilji]

Hi @bhupendra paree ,

For this you need to reset the counter for kb table. 

You can go to module called > number maintenance find the  kb table and update the counter number to largest number based on your records.

i hope this helps...