My Oracle Support Banner

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

Last updated on SEPTEMBER 17, 2019

Applies to:

Oracle Enterprise Single Sign-On Suite Plus - Version and later
Information in this document applies to any platform.
***Checked for relevance on 01-APR-2019***


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 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 database client installed.

The connection string has been verified and tested successfully.

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


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.