Sunday 12 January 2014

EPMA services not up and running in Hyperion 11.1.2.X versions

Errors:
EPMA  server is not starting after installation and configuration, when ever trying to create an EPMA application it ending with " Invalid URI:The hostname could not be parsed."


EPMA Event Log:

[EPMA Server Startup] ERROR Hyperion.DimensionServer.Interface.Exceptions.EPMAServiceException: Process 'C:\Oracle\Middleware\EPMSystem11R1\products\Foundation\BPMA\AppServer\DimensionServer\ServerEngine\bin\EPMA_ServerEngine.exe' could not be started.
   at Hyperion.DimensionServer.Service.Main.StartProcess(String applicationName, String arguments, String startupEventName, String terminateEventName, String logFileName, Int32 timeout, ProcessInfo& pi)

   at Hyperion.DimensionServer.Service.Main.StartServerEngineProcess(UInt16 serverPort, UInt16 netJniPort)



Solution:

Please execute below quires on EPMA Database 



1.  Login to MSSQL Server Management.
2.  Connect to the EPMA Database.
3.  Run the below SQL Statements:
    ALTER DATABASE <DatabaseName>   SET READ_COMMITTED_SNAPSHOT ON
    GO
    ALTER DATABASE <DatabaseName>    SET ALLOW_SNAPSHOT_ISOLATION ON
    GO
After successful execution of above queries,  Start the EPMA Server service.


For more information Contact us at

http://www.techthinkerslab.com

Mobile:

+91- 9663034204
+1 - 8473806550

Mail ids:

contact@techthinkerslab.com
trainings@techthinkerslab.com

Thank You

Techthinkerslab Staff











1 comment:

  1. Hi,

    I am also facing the issue of service not starting but the eventviewer log shows the below

    Faulting application name: EPMA_Server.exe, version: 11.1.2.4, time stamp: 0x5488d961
    Faulting module name: KERNELBASE.dll, version: 6.3.9600.18666, time stamp: 0x58f33794
    Exception code: 0xe0434352
    Fault offset: 0x00000000000095fc
    Faulting process id: 0x2b80
    Faulting application start time: 0x01d3767d9d0c027e
    Faulting application path: D:\Oracle\Middleware\EPMSystem11R1\products\Foundation\BPMA\AppServer\DimensionServer\ServerEngine\bin\EPMA_Server.exe
    Faulting module path: C:\windows\system32\KERNELBASE.dll
    Report Id: e3bace7c-e270-11e7-80e5-005056b604bf
    Faulting package full name:
    Faulting package-relative application ID:

    Can you please help in this?

    ReplyDelete