Skip to page contentSkip to chat
ServiceNow support
    • Community
      Ask questions, give advice, and connect with fellow ServiceNow professionals.
      Developer
      Build, test, and deploy applications
      Documentation
      Find detailed information about ServiceNow products, apps, features, and releases.
      Impact
      Accelerate ROI and amplify your expertise.
      Learning
      Build skills with instructor-led and online training.
      Partner
      Grow your business with promotions, news, and marketing tools
      ServiceNow
      Learn about ServiceNow products & solutions.
      Store
      Download certified apps and integrations that complement ServiceNow.
      Support
      Manage your instances, access self-help, and get technical support.
Update Set commit fails to create a unique index when the unique index got created on the source instance by selecting the 'Unique' checkbox on a Dictionary Entry record - Support and Troubleshooting
  • >
  • Knowledge Base
  • >
  • Support and Troubleshooting (Knowledge Base)
  • >
  • Update Set commit fails to create a unique index when the unique index got created on the source instance by selecting the 'Unique' checkbox on a Dictionary Entry record
KB0713711

Update Set commit fails to create a unique index when the unique index got created on the source instance by selecting the 'Unique' checkbox on a Dictionary Entry record


2688 Views Last updated : Jan 23, 2023 public Copy Permalink
KB Summary by Now Assist

Issue

When you select the 'Unique' checkbox on a Dictionary Entry record in order to create a unique index on that column and capture that change in an Update Set, promoting that Update Set to a target instance does not create the unique index on the target instance.

Cause

The 'Unique' checkbox on the Dictionary Entry record is NOT intended to be used from the UI. It might create an unique index but it DOES NOT create a sys_index_* record in the Customer Update table [sys_update_xml]. When the creation of that Dictionary Entry is captured in an Update Set and that Update Set is promoted to the target instance, the unique index on that column is not created on the target instance.

By default, the 'Unique' checkbox is not added on the Dictionary Entry form, hence, this is NOT the recommended usage. 

Unique Indexes MUST be created via the Table form [sys_db_object] ('Tables' module or 'Tables & Columns' module) so that a sys_index_* record is created in the Customer Update table. Subsequent commit of the Update Set on target instance will create the unique index.

Resolution

Steps to follow in order to create a Table Index:

  1. Navigate to: System Definition ➔ Tables
  2. Search and access the table on which you want to create the index.
  3. Navigate to the 'Database Indexes' related list.
  4. Click on 'New'.
  5. In the Index Name field, type a name for your index.
  6. Use the slush bucket to select the fields you want to be included in the index.
    The order in which you select the fields affects how the index works. If you do not have expertise in database design, we suggest you consult someone who does.
  7. To create a unique index, check the 'Unique Index' check box.
  8. Click on the 'Create Index' UI Action.

The above steps are also available in the following documentation chapter: Create a table index


The world works with ServiceNow.

Sign in for more! There's more content available only to authenticated users Sign in for more!
Did this KB article help you?
Did this KB article help you?

How would you rate your Now Support digital experience?

*

Very unsatisfied

Unsatisfied

Neutral

Satisfied

Very satisfied

Very unsatisfied

Unsatisfied

Neutral

Satisfied

Very satisfied

What can we improve? Please select all that apply.

What are we doing well? Please select all that apply.

Tell us more

*

Do you expect a response from this feedback?

  • Terms and conditions
  • Privacy statement
  • GDPR
  • Cookie policy
  • © 2025 ServiceNow. All rights reserved.