How much time it takes for Indexing a Field?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-03-2019 02:47 AM
Hello, We have created a Transform map in which we have put Coalesce on the Asset table field "Serial Number", But whenever we are trying to index the field it is not getting done as we have tried multiple times, got a pop up like indexing has been scheduled but still not getting done. Also, it will be helpful like how much time it takes for getting Indexing done.
Thanks in advance!
- Labels:
-
Enterprise Asset Management
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-03-2019 02:49 AM
Its difficult to put a number on it. It depends om the number of records on the table and the size of the database in all i think.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-03-2019 02:50 AM
It completely depends on the number of records in the table in my opinion

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-03-2019 02:50 AM
Hi,
have a look to the Known Error below and the solution provided, it might be useful for fiy your issue:
Transform - Coalesce field not indexed
If I have answered your question, please mark my response as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list.
Thank you
Cheers
Alberto
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-03-2019 02:52 AM
Thank you! We have tried already the mentioned way to index the field but still it is not getting done just getting a pop up showing indexing has been scheduled , so thinking this might be an upgrade issue ?