Unable to run audit reports in SiteMinder R12 Report Server due to error "The database logon information for this report is either incomplete or incorrect".

Products

• CA Single Sign On Secure Proxy Server (SiteMinder)
• CA Single Sign On SOA Security Manager (SiteMinder)
• CA Single Sign-On

Issue/Introduction

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:

• SiteMinder R12 Report Server R12 SP1 on Solaris.
  
  
• Oracle 10g as Audit Store.

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:

• While trying to generate a Report in R12 WAM UI Report Server, I get an error: Index: 0, Size: 0
  
  
• How to import a BIAR file using command line in SiteMinder R12 Report Server.

Environment

Release:
Component: SMPLC