My Oracle Support Banner

Audit Settings Retrieval Errors Out With "Failed to Persist Collected Audit Settings to AV For Source" (Doc ID 1462357.1)

Last updated on APRIL 21, 2022

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



To view full details, 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 a vibrant support community of peers and Oracle experts.