I am facing problem as my EPMA (version 188.8.131.52) connection is not working and it is showing the following error after giving the user credentials
Description: An error occurred processing the result from the server.
The connection was working fine till last Friday and I had to restart all the services followed by a network slowness. After that I could not make EPMA working. I have tried the following steps so far (as recommended on similar issues)
1. Increased the DimensionServer startup time to 1800 in BPMA_Server_Config.xml
2. Restarted EPMA server and services.
Please note that I have the environment where EPMA is on Windows server and Essbase is in Linux server. Hyperion planning and Essbase connection is working fine. I am using Oracle 11g for EPMA relational database.
Would appreciate your help to resolve the issue.
Thanks so much for your response.
I checked the event viewer and found some Oracle connection error.
[EPMA Server Startup] FATAL An error occurred during initialization of the Dimension Server Engine: ORA-03114: not connected to ORACLE.Oracle.DataAccess.Client.OracleException ORA-03114: not connected to ORACLE at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) at Oracle.DataAccess.Client.OracleTransaction.Commit() at Hyperion.DataAccessLayerCore.DatabaseContext.Commit() at Hyperion.DataAccessLayerCore.DALDatasetCommand.Dispose(Boolean disposing) at Hyperion.DataAccessLayerCore.DALRowset`1.Dispose(Boolean Disposing) at Hyperion.DataAccessLayerCore.CommandWrapper.Dispose() at Hyperion.DataAccessLayerCore.SchemaCommand`1.Dispose(Boolean disposing) at Hyperion.DataAccessLayerCore.SchemaCommand`1.Dispose() at Hyperion.DataAccessLayerCore.GenericDAO.Select[T](Action`1 callback, SetParamsEvent`1 onSetParams) at Hyperion.DimensionServer.DAO.DimensionPropertyManagerDAO.LoadDimensionMemberMemoProperties(Int32 libraryID, Int32 dimensionID, Action`1 action) at Hyperion.DimensionServer.PropertyManager.LoadDimension(Dimension dimension) at Hyperion.DimensionServer.PropertyManager.LoadProperties() at Hyperion.DimensionServer.Library.Load() at Hyperion.DimensionServer.Global.Initialize(ISessionManager sessionMgr, Guid systemSessionID, String sqlConnectionString)
[EPMA Server Startup] ERROR SVR_ERR_PROCESSMGR_CANT_INIT_SESSIONMGR:Cannot initialize the Session Manager.Hyperion.DimensionServer.Interface.Exceptions.EPMAServiceException: Cannot initialize the Session Manager. ---> Oracle.DataAccess.Client.OracleException Connection request timed out at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, Object src) at Oracle.DataAccess.Client.OracleConnection.Open() at Hyperion.DataAccessLayerCore.DatabaseContext..ctor(DataAccessLayer dataAccessLayer) at Hyperion.DataAccessLayerCore.DataAccessLayer..ctor(NameValueCollection settings, String tablePrefix, String baseNamespace, String schemaVersion, Boolean onlyLoadKnownTables) at Hyperion.DataAccessLayerCore.DataAccessLayer..ctor(NameValueCollection settings, String tablePrefix, String baseNamespace, String schemaVersion) at Hyperion.SessionManager.DAO.SessionManagerDataAccessLayer..ctor(NameValueCollection settings) at Hyperion.DimensionServer.SessionManager.SessionStoreRdbms.Initialize(String rdbmsVendor, String rdbmsConnParams, Int32 rdbmsCommandTimeout, Boolean logAllSQL) at Hyperion.DimensionServer.SessionManager.SessionManager.Initialize(String configFileName, Boolean restorePastInstanceSessions, Boolean enableCaching) --- End of inner exception stack trace --- at Hyperion.DimensionServer.Service.Main.InitializeSessionManager() at Hyperion.DimensionServer.Service.Main.Start()
I am working on different recommendations for this type of error and update if I find any solution. Any help in this regard will speed up the process.
Thanks again for the guidance.
Thanks John for your help. The issue is finally resolved now.
On further analysis we found TNS-12557 error also.
TNS-12557: TNS:protocol adapter not loadable
We checked that it might occur on a Windows machine that has two or more Oracle homes installed. We had the similar situation. We took the following steps and now we are able to make EPMA working.
1. Set the ORACLE_HOME environment variable using the OUI under Start > Programs > Oracle_home > Oracle Installation Products > Universal Installer. Use the OUI to set the Environment properly on Windows.
* Refer metalink doc 556895.1 for details.
2. The tnslistener.ora was not present in this oracle_home. Created the file there.
3. The service id (from tnsnames.ora) was then added in this tnslistener.ora file.