Steps to fix DocumentIndexing or Search is not working properly or startout.log file is growing too much issue

Steps to fix DocumentIndexing or Search is not working properly or startout.log file is growing too much issue

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


delete from INDEXDETAILS;
delete from INDEXDETAILSQUEUE;
delete from task_input where Schedule_id=x;

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.







          • Related Articles

          • How to take console log ?

            This article is common for Servicedesk plus MSP and Supportcenter plus applications. To troubleshoot certain UI issues , JS errors , we need console log (output) from the browser. Steps to follow : 1. Login to the application. 2. Right click on the ...
          • How to take trimmed Backup file without archive, index folder

            This is compatible for 8121 builds. We recommend users only to take Trimmed backup without archive, index folder as below : 1. Please replace the attached backup batch file ( backupdata.bat, backupdata.sh depends on your OS) and place it ...
          • Transaction log full

            Logs:  Depends On Me: com.adventnet.persistence.DataAccessException: [TierComponent] The transaction log for database 'supportcenter' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases     ...
          • Steps for Performance Tuning

            Supportcenter Plus performance can be improved by tuning the JAVA performance as said below : 1. Shut down the application. 2. Navigate into \SupportCenter\server\default\conf  3. Edit the file -> wrapper.conf with administrator privilege  For 64 bit ...
          • Inputs required for analyzing Performance Issues

            We need a couple of details to analyze Performance issue. So, please send the below details : Below mentioned details should be gathered before restarting the application. 1. Let us know whether you are taking Scheduled full backup or backup without ...