Sage 200 CRM Logging Guide: How to Change Log Levels

In Sage 200 CRM, there are two main logs:

• System log
• SQL log

The system log records system-related activity in a log file called ewaresystem.log.

The SQL log records SQL-related activity in a log file called ewaresql.log.

Both logs can be found in the following path:

C:\<install dir>\Sage\CRM\CRM\Logs

Both System and SQL logs support three main log levels:

• 5 – Maximum log level / Debug logging
• 3 – Medium log level / Info logging
• 1 – Minimum log level / Errors only

5 - Maximum Log Level

This is the most verbose logging level and captures detailed diagnostic information.

It should only be used during active troubleshooting or debugging.

Logs can grow very quickly and may impact performance.

3 - Medium Log Level

This level records normal CRM activity, errors, and warnings.

This is what we used in our production environments.

1 - Minimum Log Level

This level records failures only. Only errors will be logged.

It is rarely recommended because it misses many useful warnings and diagnostic events.

Configure the Log Level in Registry Editor

To set the log level, open Registry Editor and browse to the relevant Sage CRM registry path. Then edit the highlighted logging-related entries.

You will need to perform an IISRESET for the registry changes to take effect.

Configure the Log Level in Sage CRM Administration

There is also a second place where the log level needs to be configured.

Go to the relevant Sage CRM Administration path, click Change, and select the required log level from the dropdown list.

#windows #logging