My Oracle Support Banner

OPSS - Getting BEA-000365 BEA-000360 BEA-001153 BEA-000000 IAU Unable To Write Audit Event For Type Xmlpserver Exception (Doc ID 1987535.1)

Last updated on SEPTEMBER 20, 2019

Applies to:

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

Symptoms

1- Issue reported accessing Bi Publisher.

2- Following the next documentation:

12 Configuring and Managing Auditing


3- This works fine in 11.1.1.6 but is failing with the next error in 11.1.1.7

<BEA-000000> <IAU:Unable to write Audit Event for Type: xmlpserver>

4. Next messages reported in the AdminServer.log file

<SERVER> <main> <><Server started in RUNNING mode> ####<Dec 15, 2014 6:43:47 PM CET> <Warning> <JDBC> <HOST> <SERVER> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <><BEA-001153> <Forcibly releasing inactive connection "[weblogic.jdbc.wrapper.JTAConnection_weblogic_jdbc_wrapper_XAConnection_oracle_jdbc_driver_LogicalConnection-audit_datasource-0, oracle.jdbc.driver.LogicalConnection@46ffc795]" back into the connection pool "audit_datasource", currently reserved by: java.lang.Exception

at weblogic.jdbc.common.internal.ConnectionEnv.setup(ConnectionEnv.java:325)
at weblogic.common.resourcepool.ResourcePoolImpl.reserveResource(ResourcePoolImpl.java:363)
at weblogic.common.resourcepool.ResourcePoolImpl.reserveResource(ResourcePoolImpl.java:329)
at weblogic.jdbc.common.internal.ConnectionPool.reserve(ConnectionPool.java:417)
at weblogic.jdbc.common.internal.ConnectionPool.reserve(ConnectionPool.java:324)
at weblogic.jdbc.common.internal.ConnectionPoolManager.reserve(ConnectionPoolManager.java:94)
at weblogic.jdbc.common.internal.ConnectionPoolManager.reserve(ConnectionPoolManager.java:63)
at weblogic.jdbc.jta.DataSource.getXAConnectionFromPool(DataSource.java:1677)
at weblogic.jdbc.jta.DataSource.refreshXAConnAndEnlist(DataSource.java:1475)
at weblogic.jdbc.jta.DataSource.getConnection(DataSource.java:446)
at weblogic.jdbc.jta.DataSource.connect(DataSource.java:403)
at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:364)
at oracle.security.audit.ajl.loader.OracleRepository.<init>(OracleRepository.java:86)
at oracle.security.audit.ajl.loader.JDBCLogWriter.reinit(JDBCLogWriter.java:66)
at oracle.security.audit.ajl.loader.JDBCLogWriter.write(JDBCLogWriter.java:113)
at oracle.security.audit.ajl.loader.AuditLoader.readMessages(AuditLoader.java:488)
at oracle.security.audit.service.AuditLoaderManager.readMessages(AuditLoaderManager.java:260)
at oracle.security.audit.service.AuditLoaderManager$Runner.run(AuditLoaderManager.java:335)
.>
####<Dec 15, 2014 6:46:34 PM CET> <Error> <oracle.security.audit.logger> <HOST> <SERVER> <AuditLoaderRunner> <><BEA-000000> <IAU:Unable to prepare statement:INSERT INTO IAU_BASE COLUMNS ( IAU_ID, IAU_ComponentType, IAU_InstanceId, IAU_HostId, IAU_HostNwaddr, IAU_ModuleId, IAU_ProcessId, IAU_OracleHome, IAU_HomeInstance, IAU_ECID, IAU_RID, IAU_ContextFields, IAU_SessionId, IAU_TargetComponentType, IAU_ApplicationName, IAU_EventType, IAU_EventCategory, IAU_EventStatus, IAU_TstzOriginating, IAU_ThreadId, IAU_ComponentName, IAU_Initiator, IAU_MessageText, IAU_FailureCode, IAU_RemoteIP, IAU_Target, IAU_Resource, IAU_Roles, IAU_DomainName, IAU_ComponentData, IAU_AuditUser, IAU_TenantId, IAU_TransactionId, IAU_UserTenantId, IAU_AuthenticationMethod ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) > ####<Dec 15, 2014 6:46:34 PM CET> <Error> <oracle.security.audit.logger> <HOST> <SERVER> <AuditLoaderRunner> <><BEA-000000> <IAU:Unable to prepare statement:INSERT INTO IAU_BASE COLUMNS ( IAU_ID, IAU_ComponentType, IAU_InstanceId, IAU_HostId, IAU_HostNwaddr, IAU_ModuleId, IAU_ProcessId, IAU_OracleHome, IAU_HomeInstance, IAU_ECID, IAU_RID, IAU_ContextFields, IAU_SessionId, IAU_TargetComponentType, IAU_ApplicationName, IAU_EventType, IAU_EventCategory, IAU_EventStatus, IAU_TstzOriginating, IAU_ThreadId, IAU_ComponentName, IAU_Initiator, IAU_MessageText, IAU_FailureCode, IAU_RemoteIP, IAU_Target, IAU_Resource, IAU_Roles, IAU_DomainName, IAU_ComponentData, IAU_AuditUser, IAU_TenantId, IAU_TransactionId, IAU_UserTenantId, IAU_AuthenticationMethod ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) > ####<Dec 15, 2014 6:46:34 PM CET> <Error> <oracle.security.audit.logger> <HOST> <SERVER> <AuditLoaderRunner> <><BEA-000000> <IAU:Unable to write Audit Event for Type: xmlpserver> ####<Dec 15, 2014 6:46:49 PM CET> <Error> <oracle.security.audit.logger> <HOST> <SERVER> <AuditLoaderRunner> <>BEA-000000> <IAU:Unable to prepare statement:INSERT INTO IAU_BASE COLUMNS ( IAU_ID, IAU_ComponentType, IAU_InstanceId, IAU_HostId, IAU_HostNwaddr, IAU_ModuleId, IAU_ProcessId, IAU_OracleHome, IAU_HomeInstance, IAU_ECID, IAU_RID, IAU_ContextFields, IAU_SessionId, IAU_TargetComponentType, IAU_ApplicationName, IAU_EventType, IAU_EventCategory, IAU_EventStatus, IAU_TstzOriginating, IAU_ThreadId, IAU_ComponentName, IAU_Initiator, IAU_MessageText, IAU_FailureCode, IAU_RemoteIP, IAU_Target, IAU_Resource, IAU_Roles, IAU_DomainName, IAU_ComponentData, IAU_AuditUser, IAU_TenantId, IAU_TransactionId, IAU_UserTenantId, IAU_AuthenticationMethod ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) > ####<Dec 15, 2014 6:46:49 PM CET> <Error> <oracle.security.audit.logger> <HOST> <SERVER> <AuditLoaderRunner> <> <> <BEA-000000> <IAU:Unable to prepare statement:INSERT INTO IAU_BASE COLUMNS ( IAU_ID, IAU_ComponentType, IAU_InstanceId, IAU_HostId, IAU_HostNwaddr, IAU_ModuleId, IAU_ProcessId, IAU_OracleHome, IAU_HomeInstance, IAU_ECID, IAU_RID, IAU_ContextFields, IAU_SessionId, IAU_TargetComponentType, IAU_ApplicationName, IAU_EventType, IAU_EventCategory, IAU_EventStatus, IAU_TstzOriginating, IAU_ThreadId, IAU_ComponentName, IAU_Initiator, IAU_MessageText, IAU_FailureCode, IAU_RemoteIP, IAU_Target, IAU_Resource, IAU_Roles, IAU_DomainName, IAU_ComponentData, IAU_AuditUser, IAU_TenantId, IAU_TransactionId, IAU_UserTenantId, IAU_AuthenticationMethod ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) > ####<Dec 15, 2014 6:46:49 PM CET> <Error> <oracle.security.audit.logger> <HOST> <SERVER> <AuditLoaderRunner> <><BEA-000000> <IAU:Unable to write Audit Event for Type: xmlpserver> ####<Dec 15, 2014 6:50:19 PM CET> <Error> <oracle.security.audit.logger> <HOST> <SERVER> <AuditLoaderRunner> <><BEA-000000> <IAU:Unable to prepare statement:INSERT INTO IAU_BASE COLUMNS ( IAU_ID, IAU_ComponentType, IAU_InstanceId, IAU_HostId, IAU_HostNwaddr, IAU_ModuleId, IAU_ProcessId, IAU_OracleHome, IAU_HomeInstance, IAU_ECID, IAU_RID, IAU_ContextFields, IAU_SessionId, IAU_TargetComponentType, IAU_ApplicationName, IAU_EventType, IAU_EventCategory, IAU_EventStatus, IAU_TstzOriginating, IAU_ThreadId, IAU_ComponentName, IAU_Initiator, IAU_MessageText, IAU_FailureCode, IAU_RemoteIP, IAU_Target, IAU_Resource, IAU_Roles, IAU_DomainName, IAU_ComponentData, IAU_AuditUser, IAU_TenantId, IAU_TransactionId, IAU_UserTenantId, IAU_AuthenticationMethod ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) >

 

 

Cause

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
Symptoms
Cause
Solution


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