Logging Custom Passthrough

Executes a string containing an ODBC SQL statement. CIC Logging Server executes this string on the same database connection that is used for all of our log info. This tool allows you to send an Insert statement through PMQ queues to the CIC Logging and have the insert happen in the same server and database. This lets you reliably send your own data to custom logging tables with the same reliability as used for CIC data.

To use the Logging Custom Passthrough tool, set 9999 - Custom Passthrough to Yes in the Report Logs subcontainer under System Configuration in Interaction Administrator. By default, 9999-Custom Passthrough is set to No.

This string is not error checked.

Inputs

SQL Text to be executed on Logging Server

The string containing the SQL statement to execute.

Exit Paths

Success

This tool takes the Success exit path unless a failure condition occurred (see failure conditions below).

Failure

This tool takes the Failure exit path if it was unable to send the command due to PMQ problems. Since this tool is asynchronous, any database errors caused by an invalid statement or caused by some other type of error will occur on the CIC logging machine and be logged with CIC logging errors.