EPMA Does not start

There could be many reasons for EPMA failed configuration or statup.
Generally EPMA issues are related to DB connectivity. Specially when only HFM & EPMA are not starting then it has to be DB.

One of the recent issues was very simple but had to hunt for every software and anti virus tools on the system . I received this error on the workspace.

Warning 
Invalid URI: The hostname could not be parsed. 
Code: 
com hyperion awb web common DimensionServiceException 
Description: An error occurred processing the result From the server 
Actor: none 

These were the steps for troubleshooting it. 

1. Checked if db clients are installed

2. TNSPING <DBSID> is reachable

3. sqlplus <dbuser>/<dbpasswd>@<SID> is connecting 

4. Check EventViewer for more details on the issue.

And the issue was with the 3rd one. I was able to connect but the 

connection kept dropping from the database. 

Solution: 1. Usually this could be due to the Firewall .

Looked for finer details and found that the client had another level 

of firewall

setup on DB & APP server. Got it shut on both the sides and it worked ! 

Event Viewer Log Details:

(EPMA DimensionServer Startup) ERROR WR ERR SESSION MGR DATABASE
UNAVAILABLE:Session Manager could not start because database connectivity 
could not be established.Hyperion.CommonSen.'ices.Exceptions.SessionManagerException
:Session Manager could not start because database connectivity could not be 
established. 
--0 Oracle.DataAccess.CIient.OracIeException: ORA-3135: connection lost contact 
 at Hyperion.DimensionServer.SessionManager.SessionManager.InitiaIizeSqIConnectionSt
ringO 
- End of inner exception stack trace 
at Hyperion.DimensionServer.SessionManager.SessionManager.InitiaIize
(BooIean restorePastInstanceSessions, Boolean enableCaching) 
at Hyperion.DimensionServer.Process.Program.InitiaIizeSessionManagerO 
at Hyperion.DimensionServer.Process.Program.StartDimensionServerO 
at args)