Error Connecting To Database Connection Hyperion
when creating a new database connection of Financial Rerporting on a 64-bit server and 11.1.2 version you just will need to change some JVM Options of Financial Reporting Server to solve this issue. Errors "Error connecting to database connection
to database connection: Server/Cluster is incorrectly configured." [ID 1238573.1] Modified17-OCT-2011TypePROBLEMStatusPUBLISHED In this Document Symptoms Cause Solution ReferencesApplies to:Hyperion BI+ - Version: 9.3.0.0.00 to 11.1.2.1.000 - Release: 9.3 to 11.1Information in this document applies to any platform.SymptomsIn Financial Reporting Studio, users are trying to run reports that use a HFM datasource are getting an error."Error connecting to database connection [name]: Server/Cluster https://oraclebrasil.wordpress.com/2011/04/01/error-when-creating-a-new-fr-connection/ is incorrectly configured. Please reconfigure your Cluster or Server connection."CauseFinancial Reporting Studio is not able to locate the HFM cluster.Testing also determined that the HFM client could not connect to the HFM cluster.The HFM cluster was not correctly configured.SolutionSet up the HFM cluster on the FR http://oraclehyperionstuff.blogspot.com/2012/02/error-connecting-to-database-connection.html Studio machine.1. Go to Start > All Programs > Hyperion >Financial Management >Server and Web Configuration2. Go to the Server/Cluster Registration tab.3. Enter the computer name of the HFM server used to get cluster information or the name of the single server if using a non-clustered environment. The HFM server needs to be referenced exactly as it is on the HFM server (hostname/IP/FQDN/clustername, as well as case-sensitivity for any letters).4. Apply and OK.5. Restart FR Studio.Note: if HFM client is not on the FR Studio box, it will need to be installed prior to set up of the HFM cluster as listed above. Posted by Stuff at 6:00 AM Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest No comments: Post a Comment Newer Post Older Post Home Subscribe to: Post Comments (Atom) Followers Simple template. Powered by Blogger.
In this Document Symptoms Cause SolutionApplies http://kb.tableau.com/articles/knowledgebase/oracle-connection-errors to:Hyperion BI+ - Version: 9.0.0.0.00 to 11.1.1.3.00 - Release: 9.0 to 11.1Information in this document applies to any platform.***Checked for relevance on 06-Oct-2011***SymptomsYou open a report in error connecting Financial Reporting Studio, and receive the following messages:"Failed to connect to server. Error connecting to database connection
a unique format. Though the TNSNames.ora file may not always be required. For instance, if you have installed only the Tableau-provided Oracle files and do not have a stand-alone Oracle client. The Oracle error messages refer to the TNSNames.ora file. Typically, correcting route or naming syntax in the Advanced Oracle Connection dialog box or using your full .WORLD database name resolves most Oracle connection issues. If your connection error requires more troubleshooting, refer to the four common connection errors listed below. ORA-03113: end-of-file on communication channelORA-12154: TNS: could not resolve the connect identifier specified HOST value incorrect or Global name incorrect or unknownORA-12514: TNS listener does not currently know of service requested in connect descriptorSERVICE value incorrectORA-12541: TNS: no listenerPORT value incorrectORA-00932: inconsistent data types ORA-03113: end-of-file on communication channel ORA-03113 is a catch-all type error for any problem interrupting an Oracle session. There can be numerous causes for this error. Please refer to the list below for some troubleshooting guidance. Refer to Oracle documentation specific to this error: My Oracle Support.Refer to Oracle's B Troubleshooting Common Errors page.Oracle recommends that you check for network problems and review the SQL*Net setup.If you're connecting to Oracle 9.2.0.5, in many cases the primary cause of this error is Oracle bug 3010227. Ask your Oracle database administrator to apply Oracle patch 9.2.0.6 or another patch appropriate for your server. Set the Oracle initialization parameter 'STAR_TRANSFORMATION_ENABLED' to FALSE.Alternatively, if you would like to test this issue further follow the optional procedure listed below. Step 1 From the Tableau Deskt