Exact Synergy Enterprise

Configuring settings for truncating log files

Menu path

System à Setup à Settings – Database à Log: Truncate

Introduction

You can define the number of days for certain log entries to be stored in the database. With this feature, the Exact.Jobs.SysLogTool.dll background job will truncate the log tables where the log entries are kept in order to reduce the database size as new log entries are created. The background process will truncate the log tables that are older than a certain number of days.

Roles and rights

Only users with the Administrator role can define the settings for truncating log tables.

Note:

For more details on function rights, go to System à Setup à Security à Function rights.
For more details on roles, go to System à Setup à Security à Roles.

What version are you using?

The information in this document is based on product update 251.

How do I define the settings for truncating log files?

On the Log – Truncate: Settings page, define the required fields.
Click Save, and then Close to exit.

Buttons

Fields

Application

Type the number of days for the application log to be stored in the database. Based on this setting, the background job will truncate the BacoAppLog table. You can obtain a report displaying the application log entries. For more information, see Viewing application log report.

Documents (Read)

Type the number of days for the documents (read) log to be stored in the database. Based on this setting, the background job will truncate the BacoAppLog table. You can obtain a report displaying the documents (read) log entries. For more information, see Viewing activity history report.

Errors

Type the number of days for the errors log to be stored in the database. Based on this setting, the background job will truncate the BacoErrorLog table. You can obtain a report displaying the error log entries. For more information, see Viewing error log report.

Data

Type the number of days for the data log to be stored in the database. Based on this setting, the background job will truncate the EbcDataLog table. You can obtain a report displaying the data log entries. For more information, see Viewing data log report.

Data (Workflow)

Type the number of days for the data (workflow) log to be stored in the database. Based on this setting, the background job will truncate the EbcDataLog table.

Data (Accounts)

Type the number of days for the data (accounts) log to be stored in the database. Based on this setting, the background job will truncate the EbcDataLog table.

Data (Documents)

Type the number of days for the data (documents) log to be stored in the database. Based on this setting, the background job will truncate the EbcDataLog table.

Processes

Type the number of days for the processes log to be stored in the database. Based on this setting, the background job will truncate the BacoProcessLog table. You can obtain a report displaying the processes log entries. For more information, see Viewing process log report.

Import (Financial)

Type the number of days for the import (financial) log to be stored in the database. Import (financial) log are the log entries created when you import financial transactions from the Microsoft Excel spreadsheet. Based on this setting, the background job will truncate the CompanyLogs table.

XML – Results

Type the number of days for the log entries, which are created when you upload or download data in XML format to or from Exact Synergy Enterprise, to be stored in the database. Based on this setting, the background job will truncate the XMLEvents table.

Mail merge

Type the number of days for the mail merge log to be stored in the database. Based on this setting, the background job will truncate the HRErrorLog table. You can obtain a report displaying the mail merge log entries. For more information, see Viewing mail merge log report.

Performance Counters

Type the number of days for the performance counter log to be stored in the database. Based on this setting, the background job will truncate the Counterdata table.