Functionality

Automatic Routine for the Fulltextworker

The automatic routine is designed to reprocess documents that were not handled by the Fulltextworker within specified time frames. The routine ensures that no documents need to be manually initiated.

Functionality

  • The routine runs by default between 12:00 AM and 4:00 AM.

  • The time can be configured via the “tblFlag” table in the database.

  • During the first run, it checks if a “Last Update Fulltext Date” exists:

    • If yes, all unprocessed documents from that point are found and reprocessed.
    • If no, all unprocessed documents up to the current time are processed.

  • Only 1000 documents are processed per batch. The next batch starts only after the current one is completed.

  • Documents that were processed with errors are not reprocessed.

  • The routine continues to work past the defined time if not all documents have been processed.

Logging

The following information is stored in the server log:

  • Number of unprocessed documents found
  • Start and end time of the routine
  • Duration of the routine execution

Adjustment and Runtime

If the runtime needs to be adjusted for a specific office, this can be done via the “tblFlag” table. The routine reads this configuration and adjusts its runtime accordingly.

  • FillFulltextBatchStartHour - Start time, value from 0 to 24.
  • FillFulltextBatchEndHour - End time, value from 0 to 24.

If Start time = 0 and End time = 24, then the automatic routine is turned off.

Example SQL for changing start and end times:

UPDATE [dbo].[tblFlag] SET Value = 23 WHERE Name = ‘FillFulltextBatchStartHour’

UPDATE [dbo].[tblFlag] SET Value = 5 WHERE Name = ‘FillFulltextBatchEndHour’

SELECT [Name], [Value] FROM [dbo].[tblFlag]

Limitations

  • Documents already marked as faulty are not considered by the routine.
  • If the routine is interrupted due to an error, the unprocessed documents must be found and processed in a new run.

Related to