Error Loading Datasourcelist To Repository
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] Posted by Zorac at 11:12 AM No comments: Post a Comment Older Post Home Subscribe to: Post Comments (Atom) About Me Zorac I have started working with Oracle technology as DBA in 1989 with Oracle version 5.1.17. Since that time I have been working on numerous projects related with implementation
(FR) Studio On A Client Desktop [ID 1111287.1] Modified26-OCT-2010TypePROBLEMStatusPUBLISHED In this Document Symptoms Changes Cause SolutionApplies to:Hyperion BI+ - Version: 11.1.1.0.00 to 11.1.1.3.00 - Release: 11.1 to 11.1Information in this document applies to any platform.SymptomsWhen using the Financial Reporting Studio, you are able to access different Financial Reporting Reports Servers as long as your Financial Reporting Studio version is the same as the Financial Reporting Server.As an administrator, if you want to access two separate Financial Reporting Reports Servers, you would just change the server name when logging into the Financial Reporting Studio.Due to the complexity on an installation, certain files may or may not get laid down if the installation is not done http://jzorac.blogspot.com/2011/04/resolving-error-loading-datasourcelist.html properly causing connection issues.ChangesTried to reconfigure the Financial Reporting Reports Server from your desktop by running the configuration utility.ORInstalled a new version of Financial Reporting Studio over an existing one.CauseAt some point in time you, as an administrator, needed to configure the Financial Reporting Server and you inadvertently did it from your Desktop machine. This should only be done by someone with admin privileges, and onlyon the Financial Reporting Server. When the configuration tool http://oraclehyperionstuff.blogspot.com/2012/02/cannot-login-to-financial-reporting-fr.html was run on the Financial Reporting Studio machine, it created a reg.properties file which should only reside on the Financial ReportingServer. The Financial Reporting Studio on the client machine reads it own reg.properties file instead of the one on the Financial Reporting Server.ORYou do not have the same Financial Reporting Studio version on your client as the Financial Reporting Reports Server you were trying to connect to. Solution1 - You are trying to connect to 2 different Financial Reporting Reports Servers from one Financial Reporting Studio, one server name works but the other does not you may get one of these or both errors:a) "Unexpected error occurred" Then as soon as you close that error, you immediately get this error: b) "DatasourceIDLoginLoadDatasoureceName Error: -2147467259 Error Loading DatasourceList to Repository" If you only see error b) then go to Step 2. If you only see error a) then go to Step 3. If you see both errors a) and b) then you need to check in hyperion\common\config\9.5.0.0 for the reg.properties file on your Financial Reporting Studio machine. If you find this file there then rename it to something different and save it. Then go back to make sure the file has been renamed. If you do not find this file, then refer to Doc ID 1109585.1 for more Financial Reporting Studio connectivity trouble
Loading DatasourceList to Repository com.hyperion.reporting.datasource.HrDatasourceManagerImpl.load(Unknown Source) com.hyperion.reporting.datasource.HrDatasourceManagerImpl.getDatasources(Unknown Source) com.hyperion.reporting.datasource.HrDsManagerBean.doDsComboList(Unknown Source) com.hyperion.reporting.datasource.HrDsManagerBean.process(Unknown Source) org.apache.jsp.modules.com.hyperion.reporting.web.dsMgr.HRDsMgrDlgFns_jsp._jspService(HRDsMgrDlgFns_jsp.java:1109) http://www.betterdevelopers.com/article/45608999/Hyperion+System+9+FR+DB+connection+issue org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324) org.apache.jasper.servlet.JspServlet.serv also these errors in FR studio and don't let me close these popup error msgs and I have to kill the application. 1. Error Loading DatasourceList to Repository (If try to open existing Report) 2. DatasourceIDLogin.LoadDatasourceNames Error: -2147467259 Error Loading DatasourceList to Repository (when I try to create new Reports error loading in FR studio) There is some issue with Database conenction, how do I reset it, I tried from Database connection manager but that will not help. Thanks There is some issue with Database conenction, how do I reset it, I tried from Database connection manager but that will not help.What specifically did you do in error loading datasourcelist Database Connection Manager? Try creating a new connection (different name) to the same application. Connect the reports to the new connection and see if you get the errors. Previous Page | Hyperion Query and Reporting | HOME Related Links New documentation for BI+ SDK? Need to Sort Report by Year to Date Values -FR IR connection to TERA DATA Setting up user preferences in web analysis workspace document permissions Hyperion Financial Reporting Query Failed to connect to server BEA WebLogic Tuning for Interactive Reporting, Web Analysis & Financial Rep Web Analysis error in Workspace Fin Rptg Studio Report Bldg Question_bottom of dimension function Listbox acheivement scheduling in Hyperion Reports 7.2 SQL*net error Workspace Error Running Financial Reports Post HFM Metadata Change how to export or save an inteactive report(xxxx.bqy) on descktop folder? Capture the value of OUT parameter of Stored Procedure in IR Categories Better Developers HomeDevelopment ToolsFusion MiddlewareDatabase ConnectivityDesigner HeadstartJHeadstartOracle CommunityProcurementAdvanced Planning & Sc...Development Tools Arch...HealthcarePL/SQL XML ProgrammingPHPIntegration - InterCon...Scheduler