Search This Blog

Sunday, April 10, 2011

Resolving error Loading DatasourceList to Repository in Hyperion Financial Reporting Studio

When you run Hyperion Financial Reporting Studio in version 9.3.1, create a new report and try to insert grid you may get an error:

DatasourceIDLogin.LoadDatasourceNames Error: -2147467259 Error Loading DatasourceList

Main cause for this error is that relational database repository for Hyperion BI+ and data folder \Hyperion\BIPlus\data on BI+ server are not in sync.

Folder \Hyperion\BIPlus\data contains metadata for Financial Reporting and relational database repository contains only pointers to that metadata. So Financial Reporting can function only if those two components are in sync.

It is therefore crucial for normal operation to backup both data folder and relational database repository on a daily basis.

So this error can occur in two different situations:

1. You lose contents of your data folder
2. You change DNS name of your BI+ server

In the first case you have two options:

1. If you have a backup of your data folder you must restore it to the point in time when it is in sync with the information stored in relational database repository
2. If you do not have a backup of your data folder you must reconfigure BI+ with config tool as follows:
a. stop BI+ services
b. uninstall and install BI+ software - this is necessary to restore Sample content in data folder
c. deregister BI+ from Shared Services
d. configure BI+ against empty database user
e. register BI+ with Shared Services
f. redeploy the application and web server
g. reconfigure Financial Reporting
h. start BI+ services

If you change DNS name of your BI+ server you must perform the following steps:
1. reconfigure BI+ with config tool
2. Financial Reporting stores metadata in a folder \Hyperion\BIPlus\data\RM1_hostname where hostname is a name of your BI+ server exactly as it is stored in DNS. So if you change a hostname or just append domain name to it you have to copy contents of folder \Hyperion\BIPlus\data\RM1_hostname to folder \Hyperion\BIPlus\data\RM1_new_hostname where new_hostname is name of your BI+ server after change in a DNS.

There are three Oracle Support documents that can also help you to solve this error:
1. In Workspace You Receive "Error Loading Datasource List to Repository" [ID 944084.1]
2. Cannot Open Database Connection Manager or Access Financial Reporting Objects After Database Restore [ID 860565.1]
3. Unable to Change the Database Connection for a Report [ID 734834.1]