Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

PI OLEDB Enterprise

Activate logging

  • Last UpdatedFeb 07, 2023
  • 2 minute read

You can turn on logging with the Log File and Log Level initialization properties. To successfully create the log file, its parent directory must exist.

PI OLEDB Enterprise supports the following log levels:

Log level

Messages logged

0

  • Initialization information

  • SQL Engine errors

1

  • OLE DB COM interface calls (excluding IRowset interface)

  • OLE DB COM errors and warnings

  • SQL Engine information (optimization, execution time, and so on)

  • SQL Engine warnings

2

  • OLE DB COM interface call input and output arguments (excluding IRowset interface)

3

  • OLE DB IRowset COM interface calls, their input and output arguments

PI OLEDB Enterprise also has a global log directory that should be used by remote clients. Typically, clients that leverage PI OLEDB Enterprise remotely do not know the directory structure of the host. Instead of the Log File parameter the Server Log parameter should be used. Log files then are created in the [PIHOME]\OLEDB\Log\ directory with the name of the Server Log parameter.

Note: The server log directory points to a system location, and therefore the OLEDB consumer needs administrative privileges in order to create or append the log file. For example, when using PI SQL Commander Lite, make sure to use Run as administrator .

When PI OLEDB Enterprise is used by remote clients, administrators may want to restrict or enforce log file creation. This can be done by specifying minimum log level and maximum log level, using the PIOLEDBENT LogOptions tool located in the [PIHOME]\OLEDB\Tools\log viewer directory.

TitleResults for “How to create a CRG?”Also Available in