search cancel

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".


Article ID: 53788


Updated On:


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



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>

Figure 1

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.


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

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.


Component: SMPLC


1558711408580000053788_sktwi1f5rjvs16s81.gif get_app