Auditing has stopped writing to the audit tables. Is there a way to restart the auditing without sto
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,