Cannot set Unique in sys_dictionary for custom field

[SNowUser11]

Hi,

I have created a new custom field in cmdb_ci_service table and want that to be unique . I am trying to make the Unique filed as TRUE but it does not takes and not updating keeps as FALSE. I have checked all records though is my new instance there are only few records no duplicate values in all those records and they are empty.

Still can not make that new custom field UNIQUE in dictionary as I want Autonumber on that field. Any thing I am missing please help.

Many Thanks

[Ashutosh Munot1]

Hi,

I advise you to check this uniqueness in Business rule instead for marking it as unique/

Thanks,
Ashutosh

[SNowUser11 · Accepted solution]

Hi,

I just saw this thread and was able to make field as UNIQUE because even though all duplicates I removed still it was not updating not sure if Disabling the BR has impact but now the UNIQUE was updated to TRUE

https://community.servicenow.com/community?id=community_question&sys_id=96f647e5db1cdbc01dcaf3231f96...

But still strange even after having UNIQUE set to TRUE when I do INSERT & STAY it does not create a new unique number . Am I missing again something? but it works when i create new from the module.

Many Thanks

[Ashutosh Munot1]

HI,

Dont touch OOB configuration.

This BR is used by other configurations and may have impact on system. YOu can activate that BR again if possible.

I need to check the insert and stay button. It should also force Uniqueness.

Thanks,
Ashutosh

[SNowUser11]

Hi Ashutosh,

Okay I enabled again the BR. But when I do Insert& Stay it is the same number for new record.

Many Thanks