BI Publisher (MOSC)

MOSC Banner

Auditing has stopped writing to the audit tables. Is there a way to restart the auditing without sto

edited Jun 8, 2016 5:18AM in BI Publisher (MOSC) 3 commentsAnswered

In an OBIEE install, we have auditing configured to write to the ***_IAU schema tables in the repository database.

We had an error

15:17:02   BEA-001131      Received an exception when closing a cached statement for the pool "Audit_data": java.sql.SQLRecoverableException: Closed Connection

after which the audit records were not written to the table in the database.  We still had them being written to the  audit.log file.

We have errors such as

IAU:Unable to prepare statement:INSERT INTO xmlpserver COLUMNS ( IAU_ID, IAU_Format, IAU_Template, IAU_Locale, IAU_JobId, IAU_IsScheduled,

IAU_OutputId, IAU_UserJobName, IAU_UserJobDescription, IAU_StartDate, IAU_EndDate, IAU_Bursting, IAU_JobGroup, IAU_RunType, IAU_OutputInfo,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center