Unique Index

[srinivaskotha]

Hi All,

Per requirement, Added unique index for few fields of a Custome table by following the steps mentioned in the link (http://wiki.servicenow.com/index.php?title=Creating_a_Custom_Table#Adding_a_Database_Index&gsc.tab=0 ) but those fields are not yet showing under database indexs list.

As per the information mentioned in the above link, The index is not created immediately and it would take some time. But we have already crossed 4 business days.

Could anyone know how much time it would take?

[srinivaskotha]

Thank you, Sergiu.

Tried the background script but getting the error " GlideTableDescriptor is not allowed in scoped applications.Caused by error in script at line 1"

[sergiu_panaite]

You need to be in global scope.

[srinivaskotha]

Hi, Sergiu,

I have changed to Global and run the background script and go the list of existing but not able to see the index which is scheduled (number filed).

But the result is same as we can see all these indexes in the table under Database Index tab.

Now, what would be the next to do or to whom we have to contact for this. Please help me.

[srinivaskotha]

One updated...

After some more research, I'm able to see the requested unique indexes state are true from the table sys_index_list.do.

But not sure why these are not populating either under Database Indexes list or System Definition >>   <table name> >> Index.

Please guide me if you have any knowledge about this.

[sergiu_panaite]

It may be your index creation didn't finished successfully. You can check System Logs -> Table Changes and see if the index creation finished successfully or not.