Managing ms sql databases, Log files, Managing logs in wsa – Kofax Capture User Manual

Page 42: Managing logs in etl agent, Managing

Advertising
background image

Operation and Maintenance

42

Kofax Reporting Administrator's Guide

Managing MS SQL Databases

Microsoft SQL databases automatically create log files that contain historical changes in the

database. Depending on your database configuration, these log files can potentially fill the

hard drive.

If you select "Simple" as the "Recovery model", make sure that you truncate the log files.
E.g., you can use a similar SQL statement to perform this action manually:

-- recovery model must be "simple"
-- Shrink (truncate) the log file to 100 MB.
USE <databasename>
DBCC SHRINKFILE (<databasename>_Log, 100);
GO

Log Files

Kofax Reporting provides log files that can help with troubleshooting. Log files are stored

in the application / program data folder of all users. The exact path (<path>) depends on the

operating system:
▪ C:\Documents and Settings\All Users\Application Data\Kofax\Reporting (Windows XP

and Windows Server 2003)

▪ C:\ProgramData\Kofax\Reporting (Windows Vista, Windows Server 2008 and later)

Managing Logs in WSA

1 Start WSA Receiver Configuration or WSA Sender Configuration from the Kofax

Reporting group in the Windows Start menu.

2 Click Advanced to display additional configuration options.
3 Edit the settings in the Trace tab.

▪ The default values (TraceLevel 10 and MessageTraceSize 1) provide basic trace

information (that is often sufficient) without negatively impacting performance.

▪ Troubleshooting values (TraceLevel 40 and MessageTraceSize 100000) provide lot of

information; these are more suitable when duplicating error situations in controlled

environment.

4 Find log files in <path>\WSA-Receiver\log or <path>\WSA-Sender\log.
5 Click Save, then click Exit and restart service.

Managing Logs in ETL Agent

1 Go to the folder <path>\KofaxReportingETLAgent\LogConfig\.
2 Open the file log4net.config in a text editor.
3 Edit the line starting with "<level value=". Use "ERROR" for error output only, "INFO" for

normal operation, "DEBUG" for troubleshooting. The default value is "INFO".

4 Find log files in <path>\KofaxReportingETLAgent\log
5 Restart the ETL Agent service to make the changes effective.

Advertising