Sage 200 CRM Logging Guide: How to Change Log Levels

In Sage 200 CRM there are 2 main logs:

• system log 
• sql log

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

The sql log as its name suggests, records all SQL related activity in a log file called ewaresql.log.

Both these logs can be found in the following path:

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

Both System and SQL logs supports 3 main types of log levels:

• 5 – max log level (Debug logging)
• 3 – medium log level (Info logs)
• 1 – minimum log level (Errors only)

5 (Max log level)

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

It should only be used in active troubleshooting times for investigating and debugging.

Logs can grow very quickly and may even impact performance.

3 (Medium log level)

This level records normal CRM activity, errors and warnings. 

This is what we used in out production environments.

1 (Minimum log level)

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

Rarely recommended because it misses many useful errors.

To set the log level you need to open regedit and browse to the following path and edit the highlighted logging related entries. 

You will need to perform an IISRESET to apply these settings.

Then there is also a second place you need to set the log level. It can be found in the following Administration path. Hit change and you will be given the option to change the log level from a drop down list.