Number Duplicate Issue

[Ben42]

Hi Experts,

I am having issues with duplicate numbers. When a new defect record is created the number is being duplicated. HI Portal proposed us a solution to create before insert business rule (below link). 

https://docs.servicenow.com/bundle/orlando-platform-administration/page/administer/field-administrat...

After creating that link, I get like this but the highlighted defect number also already exists in our system.

How can I solve this?

Thanks,

Ben.

[xiaix]

The default value for the 'number' field (which is from the task table) on the 'rm_defect' table should have this:

If so, how are you creating the new Defect record?  If you are doing it through code, is that code trying to manually assign a "Number" ?

[Ben42]

Yes, Number field has that default value. And I am creating defect from "New" button.

Thanks,

Ben.

[xiaix]

Ok, your situation is indeed odd then.

Here's what happens in my instance:

The only reason I'm missing some numbers in between 70 and 74 is because I deleted records 71, 72, and 73.

[mr18]

I have a workaround.

Click New but do not save the record, so this will bypass the number and next time you will click on New it will take the number as +1 than the previous one.

Suppose you have clicked on New button and Number shows is DFCT001. Dont save this record and again click on New button. This time number will be DFCT002. Keep doing the same till it passes on the last defect number.

Lets say last record is having number DFCT008 so keep doing the step unless it crosses DFCT008