Audit Settings Retrieval Errors Out With "Failed to Persist Collected Audit Settings to AV For Source"

(Doc ID 1462357.1)

Last updated on APRIL 19, 2013

Applies to:

Oracle Audit Vault - Version and later
Information in this document applies to any platform.


 Connect as AV Auditor and try to retrieve the audit policies from source fails with the following error:


"The retrieval process has been completed unsuccessfully."

The file av_client-0.log from AV Server's $ORACLE_HOME/av/log  will show:


java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "AVSYS.AV_ORCLDB_POLICY_ADMIN", line 168
ORA-06512: at line 1



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