Description:
I'm trying to run an Audit Report, however every time I try to run an audit report I get the following error:
<Please see attached file for image>
I know my audit information is accurate and I also tried to register the audit connection several times with no luck.
My environment is as shown below:
Solution:
The issue is because You didn't import the SiteMinder Audit Reports for Oracle in InfoView.
When you install the report server it is installed with the Audit Reports for SQL Server, in this case the report server is trying to connect to an Oracle database using the templates for SQL Server. As result the report server throws the error:
"The database logon information for this report is either incomplete or incorrect".
Additional steps are needed when you use Oracle as Audit Store and it has been documented in both SiteMinder R12 SP1 Release Notes and support.ca.com.
For more information please check the following KB articles: