BUSINESS OBJECTS REPORTS FAIL "Failed to open the connection. [Database vendor CODE:4060]"

book

Article ID: 51049

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:

Where ODBC, database and database logon id are not all 'niku', three Clarity reports fail, returning error 4060. One stock report and two PMO reports are affected.

The reports in question are:

Capacity vs Demand By Resource
Capacity vs Demand By Role
Project Transactions Inquiry

Solution:

For each affected report do the following:

  1. Log into the BO Central Management Console.

  2. Select Objects.

  3. Select the report name.

  4. Click on the Process tab > then the Database tab.

  5. On the left under "Data Source(s)" highlight "niku".

  6. Once "niku" is highlighted, select the "Use custom database logon..." radio button.

  7. Complete the fields

    Server: database server
    Database: name of database
    User: database login name
    Password: database login password

  8. At the bottom of the page, select the "Use same database login as when..." radio button.

  9. Hit the Update button to save changes.

Environment

Release:
Component: PPMENV