Skip to end of metadata
Go to start of metadata

Purpose

How to enable free text search on an IdM system running MSSQL

Symptom

Searching the UI with wildcard fails - in this case freetext search may not be enabled on the database for the IdM schema.

Solution

1. Run the following SQL query (log in as <prefix>_OPER):

select indexproperty(object_id('mxi_values'), 'IX_MXI_VALUES_Value_ID' ,'isfulltextkey'); (returns 1 if fretext search is enabled)

2. If Freetext search is enabled, try disabling it by running the following SQL commands:

DROP FULLTEXT INDEX ON mxi_values; DROP FULLTEXT CATALOG ftfull;

3. Verify that it is turned off, the following should return 0: select indexproperty(object_id('mxi_values'), 'IX_MXI_VALUES_Value_ID','isfulltextkey');

4. Try to perform search from WEB UI. Does it still take a lot of time to return entries?

5. Enable freetext search again by the following SQL commands: CREATE FULLTEXT CATALOG ftfull WITH ACCENT_SENSITIVITY=OFF AS DEFAULT;

CREATE FULLTEXT INDEX ON mxi_values(searchvalue) KEY INDEX IX_MXI_VALUES_Value_ID;

( Alternatively, run mxmc-(x)enable-fulltext.cmd )

6. Verify that freetext search is turned on (returns 1): select indexproperty(object_id('mxi_values'), 'IX_MXI_VALUES_Value_ID','isfulltextkey');

 

Related Content

Related Documents

 

Related SAP Notes/KBAs


__________________________________________________________________________________________________________

Use this structure to help you compose your contributions for WIKI and at the same time will ensure spelling and grammar.

  • No labels