OPSS - Auditing run-time event with database audit store not working as expected showing IAU:Unable to write Audit Event (Doc ID 2216161.1)

Last updated on AUGUST 25, 2017

Applies to:

Oracle Platform Security for Java - Version 11.1.2.2.0 and later
Information in this document applies to any platform.

Symptoms

OAM auditing run-time event with database audit store , not working as expected

After set up the database audit store to audit user login activities in the database according to this guide

9.7.1 Setting Up the Audit Database Store

Observing On average, once a day, sometimes once every two days, the database audit would stop.
The log file continues to log the user's login activities, but the database store stops.
Every time this happens, it is necessary restart the OAM server to restore the service.

Observing these errors in logs

[2016-11-01T10:58:46.329-05:00] [oam_server1] [ERROR] [] [oracle.security.audit.logger] [tid: AuditLoaderRunner] [userId: <WLS Kernel>] [ecid: <ECID>] IAU:Unable to write Audit Event for Type: OAM
[2016-11-01T10:58:46.330-05:00] [oam_server1] [ERROR] [] [oracle.security.audit.logger] [tid: AuditLoaderRunner] [userId: <WLS Kernel>] [ecid: <ECID>] IAU:Unable to prepare statement:INSERT INTO OAM COLUMNS ( IAU_ID, IAU_ApplicationDomainName, IAU_AuthenticationSchemeID, IAU_AgentID, IAU_SSOSessionID, IAU_AdditionalInfo, IAU_AuthorizationScheme, IAU_UserDN, IAU_ResourceID, IAU_AuthorizationPolicyID, IAU_AuthenticationPolicyID, IAU_PolicyObjectID, IAU_ReadOnly, IAU_PolicyAdminContext, IAU_PolicyType, IAU_UserID, IAU_ResourceHost, IAU_RequestID, IAU_Impersonator, IAU_ProtectionLevel, IAU_ResourceType, IAU_ServiceURI, IAU_ServiceIdentifier, IAU_ServiceOperation, IAU_AdminRoleName, IAU_ClientIPAddress, IAU_SessionCreationTime, IAU_SessionExpirationTime, IAU_SessionLastUpdateTime, IAU_SessionLastAccessTime, IAU_IdentityDomain, IAU_GenericAttribute1, IAU_GenericAttribute2, IAU_GenericAttribute3, IAU_GenericAttribute4, IAU_GenericAttribute5, IAU_PolicyName, IAU_SchemeName, IAU_ResourceHostName, IAU_OldAttributes, IAU_OldSettings, IAU_NewAttributes, IAU_NewSettings, IAU_ResponseType, IAU_AgentType, IAU_ConstraintType, IAU_InstanceName, IAU_DataSourceName, IAU_DataSourceType, IAU_HostIdentifierName, IAU_ResourceURI, IAU_ResourceOperations, IAU_ResourceTemplateName, IAU_TstzOriginating, IAU_EventType, IAU_EventCategory ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )

Changes

 

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