One moment please...
 
Exact Synergy Enterprise   
 

How-to: Running Exact.Jobs.SysLogTool background job

Introduction 

The Exact.Jobs.SysLogTool background job is responsible for truncating the log entries that are made while using Exact Synergy Enterprise. Every action from every user results in log entries being made in the database. Over time, this can result in a huge database where a large amount of the size is due to log entries from several years ago. To prevent this, Exact Synergy Enterprise has created Exact.Jobs.SysLogTool to reduce the size of the database by deleting old log entries. Apart from cleaning up old log entries, which can be viewed at Modules ? System ? Reports ? Log ? Processes, the background job also updates the overviews of page views for documents and applications. These overviews for people, applications, hours, and history can be found at Modules ? System ? Reports ? Page views.

Technical information 

The following tables are involved when running Exact.Jobs.SysLogTool:

  • BacoProcessLog
  • BacoAppLogDays
  • BacoAppLogHours
  • BacoAppLogApps
  • BacoAppLog
  • BacoErrorLog
  • EbcDataLog
  • CompanyLogs
  • HRErrorLog
  • XMLEvents

Every action in Exact Synergy Enterprise results in a log entry made in the database. Exact.Jobs.SysLogTool helps to keep the size of the database small by truncating these log entries based on the Log truncate settings in Exact Synergy Enterprise. The settings must be configured before this background job can be called upon. For more information, see Configuring settings for truncating log files.  

The Exact.Jobs.SysLogTool background job checks for all log entries on the day these entries are created. If the entries created have passed the number of days set in Exact Synergy Enterprise, the entries will be deleted from the table. When this job is executed, the DELETE statement is executed on the SQL server on the BacoAppLog table. By default, the connection timeout to execute this job is set to 20 seconds. You can define a longer timeout period for a huge log table or when there is a significant time lapse since the job was last executed.

Parameters

The Exact.Jobs.SysLogTool background job supports the following parameter. The command line parameter is case-sensitive.

/T
This refers to Connection Timeout in seconds. If the parameter T is not specified, the default connection timeout is 20 seconds.

Syntax

The command line for Exact.Jobs.SysLogTool requires only the mandatory and standard parameters.

In this example, assume that Exact Synergy Enterprise is installed in the folder E:\Program Files\Exact Software\Exact Synergy Enterprise. The database server name is "SYNServer", the name of the database is "SynergyNET", and the virtual directory is also named "SynergyNET".

The syntax will be as follows:

Exact.Process.exe /DBCONFIG:<virtualdirectory> /ASSEMBLY:<bgJob Assembly> /CLASS:<bgJob Class> /T:<time>

This results in the following:

E:\Program Files\Exact Software\Exact Synergy Enterprise\bin\Exact.Process.exe /DBCONFIG:SynergyNET /ASSEMBLY:Exact.Jobs.SysLogTool /CLASS:SysLogTool /T:600

Troubleshooting 

Query Timeout = -1

This error message is displayed in the log if a query timeout error has occurred. The SQL server needs to reorganize the indexes on the table while records are being deleted. Due to this, a longer timeout period may be needed. Define a longer timeout period using the /T parameter to solve this issue.

Related documents

     
 Main Category: Support Product Know How  Document Type: Online help main
 Category: On-line help files  Security  level: All - 0
 Sub category: Details  Document ID: 16.169.207
 Assortment:  Date: 08-02-2018
 Release: 390  Attachment:
 Disclaimer

Attachments
ESE_PU251_HT - Running Exact.Jobs.SysLogTool background job.docx 31.5 KB View Download