Kofax Capture - Manual (Page 31)

Configuration
Kofax Reporting Administrator's Guide 31
2 Restart the ETL Agent service to make the changes effective.
Parameter Description
PurgeFieldDataBatchSize Deleting large data from indexed tables can be
expensive, therefore the ETL Agent deletes data in
batches of a given size. The parameter determines
how many rows are deleted in a single transaction
when purging old field data. The ETL Agent will
continue to run transactions that delete the given
number of records until all data has been deleted.
The default value should fit most of the databases.
Default = 10000
DatabaseCmdTimeoutSec The timeout controls how many seconds is a SQL
command allowed to take. The default value should
fit most of the databases.
Default = 600
MQ2StagingServiceEnabled Setting this to False disables pulling of data from
WSA and saving into the staging database. It might
be used for debugging and tracking down issues.
Default = True
ETLServiceEnabled Setting this to False disables processing data from
the staging database into the warehouse. It might be
used for debugging and tracking down issues.
Default = True
ETLBatchSize The number of messages that are processed at a time
when processing data from staging database to the
warehouse. The default value should fit most of
the cases. However, if batches contain a very large
average number of pages (e.g. a batch in average
contains 100 documents and each document 100
pages), then it might be appropriate to decrease this
value.
Default = 10000
WSABatchSize The number of messages that are processed at a time
when processing data from WSA database to the
staging database. The default value should fit most
of the cases. However, if batches contain a very large
average number of pages (e.g. a batch in average
contains 100 documents and each document 100
pages), then it might be appropriate to decrease this
value.
Default = 10000