change logged at exact same time with number but different sys_id

Paresh Raniga2
Tera Contributor

Hello,

 

Any one experienced where a change logged at the exact same time however with number but different sys_ids

Any guidance/advice would be much appreciated. screen shot below, opened by is same person. This is our prod environment. TIA

PareshRaniga2_0-1750932540185.png

 

3 REPLIES 3

Sudhir Urkude3
Tera Contributor

 Hi @Paresh Raniga2 

Could you check if there are any Business Rules running on the Change or Task tables that use current.update()? That might be causing the duplicate issue.

You may also find this community thread helpful:
Solved: seeing duplicate incidents with same number - ServiceNow Community

Regards,
Sudhir Urkude

Paresh Raniga2
Tera Contributor

Hi @Sudhir Urkude3 

 

No business rule found.

Unique number is set to false on the number dictionary.

Default value is already set to this:

PareshRaniga2_0-1750937008388.png

"glide.itil.assign.number.on.insert", is set to false.

 

Paresh Raniga2
Tera Contributor

I logged a case with Servicenow Support and this was their response

 

*Most Probable Cause: *
> The unique identifier for all records, including duplicate records in
> ServiceNow, is the respective sys_id generated by the system.
> By default, ServiceNow does not enforce uniqueness on the task.number
> column. This opens the possibility of having records with the same number. (Not sure why Servicenow does not enforce uniqueness on the task.number, this would save a lot of time and inconsistencies!!)
>
> Reason 1:
> The issue can occur from multiple pushes being made to the submit button.
> Although generally this is in conjunction with a network latency issue
> (i.e. where a push is sent and upon reconnection, another push is sent
> separately), it can simply occur without.
>
> Reason 2:
> One possibility is if there is a double insert caused by a custom business
> rule that contains a current.update or an .update when the record is
> inserted.
> — please kindly review the custom business rule on insert using
> current.update() or gr.update or *.update
>
> Reason 3:
> One scenario is where you cloned over from production and production
> already have that number.
>
>
> *Solution Proposed: *
> As of now, unless there is a way to reproduce this issue, or if there is
> some type of pattern of the issue, it would be difficult to pin point what
> may cause the issue.
>
> To impose the unique numbering on task table via a Business rule so that
> duplicate numbers will not be created. Before every update, it will make
> sure that a new number is assigned to the record.
>
>
> https://docs.servicenow.com/bundle/utah-platform-administration/page/administer/field-administration...
>