Clarity: "Logon Failed" error when using Crystal Reports to access CA Clarity universe

book

Article ID: 49582

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG CLARITY PPM FEDERAL CA Identity Manager CA Identity Governance CA Identity Portal Clarity PPM SaaS - Application Clarity PPM On Premise

Issue/Introduction

Description:

"Logon Failed" error when using Crystal Reports to access CA Clarity universes for Business Objects Reporting with database as MS SQL Server.

Cause: This error can occur due to a mismatch in DSN names defined in the system and the service name defined for the universes in the BO Designer.

Steps to reproduce:

  1. Launch Crystal reports
  2. Click on a new blank report
  3. Database Expert Opens. Click on Create New Connection
  4. Click on Universes. Give the necessary credentials.
  5. CA Universes > CA Clarity > Select the universe wished to be accessed.
  6. Select any field from the tables listed . Click on OK.
  7. Error > Logon Failed (ref fig error)

    <Please see attached file for image>

    Figure 1

Solution:

Resolution Steps:

A:
In CMC :

GoTo:

  1. Universes > CA Universes> CA Clarity .

    1. Here you will see a list of universes

  2. Select the Universe to be accessed.

  3. Right Click on the Universe > Properties > Connections.

  4. It will show a connection name. In this case CA_Clarity (ref fig 1 and fig 2)

<Please see attached file for image>

Figure 2

<Please see attached file for image>

Figure 3

B:
In the Universe Designer

GoTo:

  1. Tools > Connections
  2. Look for a connection named CA_Clarity or create one (This matches the name from group 1 steps. The connection name for the universe)
  3. If the connection exists , select the connection > Click on Edit else if creating new make a note of the Service Name used.
  4. Keep a note of The Service Name . In this case its "clarity" (ref fig 3)

    <Please see attached file for image>

    Figure 4

C:
On the Client Machine where Crystal Reports is installed

GoTo:

  1. DataSources(ODBC)
  2. ODBC Data Administrator - GoTo System DSN
  3. ADD SQL Server - Click on Finish
  4. Create the DataSource to SQL Server with name "clarity". This matches the Service Name taken from the Universe Designer, connection name for the Universe.

Environment

Release:
Component: PPMENV

Attachments

1558710098372000049582_sktwi1f5rjvs16rqx.gif get_app
1558710096549000049582_sktwi1f5rjvs16rqw.gif get_app
1558710094568000049582_sktwi1f5rjvs16rqv.gif get_app
1558710092474000049582_sktwi1f5rjvs16rqu.gif get_app