Setting Delimiters in the Essbase Server and Application Logs

You can change the symbol used to delimit log entries for server and application logs. Changing the delimiter also affects messages logged in the server console window. By default, Essbase Server uses spaces to delimit fields in a log, as in the following example:

[Thu May 10 20:14:46 2001]Local/ESSBASE0///Info(1051051)
Essbase Server - started

You can also use tildes, carets, colons, ampersands, or asterisks to delimit the entries in the server and application logs. If possible, choose a delimiter that does not occur frequently in the data, application, or database. The following example shows a log entry delimited by tildes (~):

Thu~May~10~20:16:13~2005~Local~ESSBASE0~~~Info~(1051051)~ \\ Oracle Essbase Server - started

Note:

If you set delimiters to anything other than spaces, you can no longer sort the log entries by date in Log Viewer.

Table 145, List of Log Message Delimiter Configuration Settings lists settings that you specify in the essbase.cfg file to determine the delimiters that Essbase Server uses in the server and application logs. If you change an essbase.cfg setting, restart Essbase Server to apply the change.

Table 145. List of Log Message Delimiter Configuration Settings

Setting

Description

DELIMITEDMSG

An essbase.cfg setting that, when set to TRUE, adds a tilde (~) between each field in the server and application logs.

To specify a different delimiter, use the DELIMITER setting.

DELIMITER

An essbase.cfg setting that specifies the delimiter used between each field in the server and application logs.

Essbase Server enables you to use the following characters as log delimiters: tilde (~), the default delimiter; caret (^); colon (:); ampersand (&); and asterisk (*).

The DELIMTER setting works only when DELIMITEDMSG is set to TRUE.