We came across several cases, where the search is not working properly due to the index file corruption or Indexing thread gets locked. For which we need to follow the below steps.
Steps to follow
1. Shut down the application.
2. Execute the below query :
update task_input set operational_status=4 where schedule_id in(select schedule_id from schedule where schedule_name='DocumentIndexingTaskSchedule');
Hit enter
Then the below query :
update Globalconfig set paramvalue=25 where category='search';
4. Now go to the Supportcenter Plus application folder SupportCenter\index --> rename ALL folders in it.
5. Connect to the database, execute the below queries one by one
Replace 'x' with the scheduled id taken from the scheduled activities link
6. Open a command prompt in administrative mode
7. Navigate into <Supportcenter>/bin directory.
8. Execute indexData.bat contact
This will reindex the contacts module.
Once it is done and you see a success message,
9. Then Execute - indexData.bat request 2020
This will reindex the request 2020 module. Please avoid indexing for all year as it leads to corrupt the data again.
Then do indexing for solutions modules and others.
Other module_names : account , solution, contract
Once it is done and you see a success message,
10. Now execute the below query :
update task_input set operational_status=3 where schedule_id in(select schedule_id from schedule where schedule_name='DocumentIndexingTaskSchedule');
Start the application and check the mentioned issue.