Ignoring exceptions examples

The Ignoring exceptions policy shows two ways to ignore certain exceptions.

Rule 1: Ignore TNS errors that are logged as LOGIN_FAILED.

Session level criteria
- Server IP address in Group where,
  - Group type = Server IP
  - Members = IP addresses
- Database type = ORACLE
- Server port = 1521
Rule action = IGNORE REQUEST
- Request type = LOGIN FAILED
- Search prefix = TNS-

Rule 2: Ignore error 42702, which is caused by multiple SQL DROP TABLE and CREATE TABLE command pairs.

Session level criteria
- Database type = DB2
Rule action = IGNORE REQUEST
- Request type = SQL
- Search prefix = 42702

SR language examples

While both of the exceptions are managed with a single policy in the UI, two SR language policies are needed.

Example 1:

SR_POLICIES
{
        IF (SERVER_IP = ('', 20005) SERVER_PORT = 1521 DB_TYPE = 'ORACLE' )
        {
                IGNORE_REQUEST REQ_TYPE = LOGIN_FAILED SEARCH_PREFIX = 'TNS-'
        }

        GROUP_ID = 20005 TYPE = IP_ADDRESS SIZE = 2
        {
                '20.20.20.20' '30.30.30.30'
        }
}

Example 2:

SR_POLICIES
{
        IF (DB_TYPE = 'DB2' )
        {
                IGNORE_REQUEST REQ_TYPE = SQL_ERROR SEARCH_PREFIX = '42702'
        }
}