Stopping writes into the taskstats table by tmclient.exe and TMSub.exe in IBM Datacap Taskmaster Capture

Stopping writes into the taskstats table by tmclient.exe

and TMSub.exe in IBM Datacap Taskmaster Capture

Abstract

How to stop Taskmaster Client or Taskmaster Client Service from writing into the taskstats table in in IBM Datacap Taskmaster Capture

Answer

You can prevent Taskmaster Client and Taskmaster Client Service from writing into the engine database's [taskstats] table on a per task and per status basis. To do this:

1. Locate the Batch Pilot Project (BPP) file corresponding to the task for which you want to disable writing into the [taskstats] table.

2. Backup the BPP file and then open the original using Notepad or similar text editor.

3. Add section [TaskStats] if it does not already exist.

4. Under [TaskStats], add SkipTaskStatsOnStatus=x, where x is the status to avoid.

5. Repeat step #4 as many times as necessary and then save the BPP.

 

Here are the most common list of returned task statuses:

0 = Abort

1 = Canceled

2 = Finished

3 = Waiting

4 = Hold

5 = Suspended

8 = Pending

Here is an example of content from a BPP:

[TaskStats]

SkipTaskStatsOnStatus=8

 

Assuming that this was the BPP of a VScan task, Taskmaster Client and Taskmaster Client Service will avoid inserting data into the [taskstats] data when the task returns a "pending" status due to no files being found in the input folder for VScan. However, if the task returns "finished" because files are in the source directory, then a record will be inserted into the [taskstats] table by Taskmaster Client or Taskmaster Client Service.