Solved

Search with Keywords does not work in Customer database - APP10


Userlevel 4
Badge +7

For some reason Search with Keywords does not functioning in APP10 Customer database. Is there any specific setup?

 

icon

Best answer by Charith Epitawatta 28 April 2021, 12:52

View original

This topic has been closed for comments

10 replies

Userlevel 6
Badge +13

Hi @ProThushA ,

Is the normal search works fine without any issue for this type of search?
Are you getting any specific error ?
 

Keywords search works based on the application search functionality. So could you please check whether the corresponding search domains are synchronized properly?

In order to do that please navigate to Solution Manager>Configuration>Application Search>Search Domains screen and get the details of the corresponding search domains. The search domain detail screen shows the last synchronized date, synchronizing schedule, and also whether there were any errors.

Furthermore, you can try out scheduling rebuild indexes job in an off-peak houres or trying to rebuild specific indexes

Userlevel 6
Badge +9

@ProThushA , Does it not work with ‘%’ at the end and start too?

 

Userlevel 4
Badge +7

Thank you very much for your valuable inputs. I have attached the steps which I followed based on your suggestions, but still no response from the application. 

Please make sure normal search works fine.

See below attachment.

Best Regards,

Thushan.

Userlevel 3
Badge +5

@ProThushA , please go to the search domain and query CustomerOrder. then click the Synchronized link and it will take you to the task schedule of the CustomerOrder. Check whether the task is active and the schedule of the execution. When a record is saved, keywords are getting updated using this task and this needs to be enabled.

Userlevel 4
Badge +7

Yes, this is Active and executed 421 times so far.

 

Userlevel 3
Badge +5

@ProThushA hope this data is saved not in a custom field? As far as i know custom fields are not possible to search via keyword search

Userlevel 4
Badge +7

It is not custom fields. Those are generic fields such as Customer in Customer Order.

Userlevel 7
Badge +31

Hi @ProThushA,

In some instances, the search domain index may not be indexed properly. This will be fixed by dropping and recreating the index.

To drop and recreate a search index, you can follow these steps. 

1. Go to "Search Domains" window in IEE.

2. RMB on the relevant search domain and select "Show Details...". This will direct you to the detail view of the search domain. 

3. RMB on the detail view and select "Drop Search Index".

This will drop the search domain. Refresh the window to see that it is dropped. 

4. RMB and select “Schedule Domain Activation”. 

5. Click on “Enable Schedule” link. This will direct you to Task Schedule window. 

6. RMB and select “Run”. 

7. Click “View background jobs for this task”. This will show the background job created for this. 

8. RMB on the Background job and execute if it isn’t already executing. 

9. Go through step 1 and 2 above again. Then click on "synchronized".

10. Go through steps 6, 7 and 8 above. 

After doing the above, go back to Search Domain detail window and see if the domain is activated and all the documents are properly synced. Refer to "Not Synchronized Documents" column for this. Value should be '0'. 

Hope this helps!
 

Userlevel 4
Badge +7

Hi Charith,

BIG THANKS, It works fine now. Is it a standard bug in the system?

Best Regards,

Thushan. 

Userlevel 7
Badge +31

Hi @ProThushA,

Glad to know you were able to get it resolved.

This is not an IFS error, just some quirk in Oracle database text indexes. Text indexes could get corrupted due to many reasons, the most common we have come across being due to maintenance activities such as copying/cloning databases.