ESSO Fails to Log Audit Data To Reporting Server (Doc ID 1925564.1)

Last updated on JULY 17, 2017

Applies to:

Oracle Enterprise Single Sign-On Suite Plus - Version 11.1.2.2.0 and later
Information in this document applies to any platform.

Symptoms

Logon Manager is configured to send audit data to an Oracle Database on the Reporting Server but the Audit events specific to ESSO are not getting logged in the database.

The 11.1.2.2.0 Oracle_Setup.sql script was successfully run against the database. All of the required schema objects appear to be present and the script was completed successfully without errors.

The current repository configuration in Active Directory prohibits the use of integrated security on the database. The risk associated with having the uid and pwd in the connection string will be assumed because a user id with write-only privileges will be used to establish the database connection.

The workstation has the 11.2.0.3 database client installed.

The connection string has been verified and tested successfully.


Stored Procedure: dbo.sp_WriteEvents
Batch Size: 1 (changed for testing)

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms