Duplicate change numbers created.

[mmr]

Hi Team,

We have faced one issue in change management, duplicate change records created when user created a new change by copying it from another change. When we checked in the logs, there was nothing logged in the log related to the duplicate change numbers related issue. Please assist if there was any particular reason there behind this duplicate numbers creation.

[Allen Andreas]

Hi,

Unless you have unique numbering turned on for that table/field (which OOB we don't), then there technically isn't anything preventing a duplicate number from happening. ServiceNow has however, provided documentation to set a business rule on your instance which will prevent duplicate numbers from happening. You'd need to place this on your change table, and really, on your incident, problem, knowledge, etc....

Please see link: https://docs.servicenow.com/bundle/london-platform-administration/page/administer/field-administrati...

Please mark reply as Helpful/Correct. Thanks!

[mmr]

Thank you Allen for your quickly reply on this. Yes, we would implement this business rule to prevent this. But would like to know on few things related to this issue. There was nothing captured in the log related to this duplicate entry to find out the root cause how these duplicate entries created. And another one is, should we implement the uniqueness by applying the Unique checkbox in the field dictionary? if we implement this by marking the Unique checkbox, will it cause any other issues while importing data etc? would like to know on these details. Appreciate your assistance in advance.

[Goran WitchDoc]

Are you using the OOB functionality to copy change? Then it shouldn't behave like that. First thing I would look at is that "number" isn't one of the fields that are configured to be copied. Take a look at change properties and the specific property:

//Göran

[mmr]

Hi Goran,

Thank you for your quick reply on this. Yes, we are using OOB copy functionality. Checked the change property and didn't find the number field in the list of attributes field in the properties.