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

          • 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 ...
          • Backup file to ignore archive, index folder for trimmed backup

            This is compatible for 8121 builds. Please use attached backup batch file ( backupdata.bat, backupdata.sh ) and place it under SupportCenter/bin  This will ignore archive, index folder for trimmed backup. Command to execute to take the backup Open a ...
          • 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 ...
          • Unable to index (Documentindexingtaskschedule running behind server time)

            Please follow the steps below to solve this issue.  ​ Go to Support link --> SupportCenter Plus application status section --> Scheduled Activities If the Next scheduled time is greater than the current server time, please restart the application. ...