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:
- Log into the BO Central Management Console.
- Select Objects.
- Select the report name.
- Click on the Process tab > then the Database tab.
- On the left under "Data Source(s)" highlight "niku".
- Once "niku" is highlighted, select the "Use custom database logon..." radio button.
- Complete the fields
Server: database server
Database: name of database
User: database login name
Password: database login password
- At the bottom of the page, select the "Use same database login as when..." radio button.
- Hit the Update button to save changes.