Clarity: Error "RPT-0007: Specified report did not execute properly." when running reports and BO XI is installed.

book

Article ID: 52450

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG CLARITY PPM FEDERAL CA Identity Manager CA Identity Governance CA Identity Portal CA IT Asset Manager CA Software Asset Manager (CA SAM) ASSET PORTFOLIO MGMT- SERVER CA Service Management - Service Desk Manager Clarity PPM SaaS - Application Clarity PPM On Premise

Issue/Introduction

Description

BO XI is installed successfully with Clarity 8.1 and Oracle database.

None error message is shown during installation process.

But if NSA "logs" tab is checked, just after the BO IX installation, the following error exception will be shown:

  [...]    (admin) Installing reports...    (admin) Source = bo\oracle\CA_Clarity.biar    (admin) bo\oracle\CA_Clarity.biar...    [InstallEntSdkWrapper.main] Connecting to CMS localhost:6400 as administrator    [InstallEntSdkWrapper.Connect] Exception: Unable to find servers in CMS localhost and cluster    with kind cms and extra criteria null. All such servers could be down or disabled by the administrator.    [InstallEntSdkWrapper.main] Could not connect to CMS    (admin) Activating vendor-specific report definitions...    (admin) Reports Installation Complete   [...] 

When user tries to run reports from Clarity, they won't work and error "RPT-0007: Specified report did not execute properly" will be shown.

Solution

    • Re-install the BI patches enclosed in the BI XI DVD: "C:\Temp\BO\Disk1\cabi\patch\biekpatch.exe"

    • Ensure All the BO Services are up and running.

    • Ensure password encryption is DISABLED.

    • Make sure that the SERVICE_NAME on your tnsnames entry is 'niku' all lower case. i.e.:
      your_entry =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = your_host)(PORT = your_port)))(CONNECT_DATA =(SERVICE_NAME = niku))) i.e: Customer's system database name is 'niku10g' and the username is 'niku' NIKU10G =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = niku)))
    • Verify the following parameters on NSA, under "Reporting Home Dir : X:\dbo"

      Service URL:
      http://<servername>:8080/dswsbobje/services/session

      Important! <servername> must be the server name, 'localhost' cannot be used

    Keywords: CLARITYKB, installation, configuration, business objects

Environment

Release: NCSVCS05900-8.1-Clarity-Service Connect-for MS-SQL
Component: