Configure dimension server is failed in EPMA Configuration

In this page we are going to see how to resolve the configuration dimension server failed issue while configuring the EPMA Component in EPM 11.1.2.4

Note : We get this issue if we use MS SQL Express edition as a source for Hyperion 

Please check the diagnostics logs as below

Navigation : Start- AllProgramms-OracleEPM System-FoundationServices - EPMSystem Daignostics

FAILED DimEditorLoadAdf Launch external checker with next command: C:\Oracle\Middleware\EPMSystem11R1\..\jdk160_35/bin/java -DEPM_ORACLE_HOME=C:\Oracle\Middleware\EPMSystem11R1 -DEPM_ORACLE_INSTANCE=C:\Oracle\Middleware\user_projects\epmsystem1 -Djava.util.logging.config.class=oracle.core.ojdl.logging.LoggingConfiguration -Doracle.core.ojdl.logging.config.file=C:\Oracle\Middleware\user_projects\epmsystem1\config\validation\11.1.2.0\validationTool-logging.xml com.oracle.epm.epma.config.validations.dimeditor.DimEditorLoadAdf
Error: DimEditorLoadAdf failed on initialization. Please check all registry information is valid and that HSS is running. 

Recommended Action: Make sure external checker is working.

FAILED EnumApplications Launch external checker with next command: C:\Oracle\Middleware\EPMSystem11R1\..\jdk160_35/bin/java -DEPM_ORACLE_HOME=C:\Oracle\Middleware\EPMSystem11R1 -DEPM_ORACLE_INSTANCE=C:\Oracle\Middleware\user_projects\epmsystem1 -Djava.util.logging.config.class=oracle.core.ojdl.logging.LoggingConfiguration -Doracle.core.ojdl.logging.config.file=C:\Oracle\Middleware\user_projects\epmsystem1\config\validation\11.1.2.0\validationTool-logging.xml com.oracle.epm.epma.config.validations.repository.EnumApplications
Error: EnumApplications failed on initialization. Please check all registry information is valid and that HSS is running.
Recommended Action: Make sure external checker is working.

FAILED EnumDataSyncs Launch external checker with next command: C:\Oracle\Middleware\EPMSystem11R1\..\jdk160_35/bin/java -DEPM_ORACLE_HOME=C:\Oracle\Middleware\EPMSystem11R1 -DEPM_ORACLE_INSTANCE=C:\Oracle\Middleware\user_projects\epmsystem1 -Djava.util.logging.config.class=oracle.core.ojdl.logging.LoggingConfiguration -Doracle.core.ojdl.logging.config.file=C:\Oracle\Middleware\user_projects\epmsystem1\config\validation\11.1.2.0\validationTool-logging.xml com.oracle.epm.epma.config.validations.repository.EnumDataSyncs
Error: EnumDataSyncs failed on initialization. Please check all registry information is valid and that HSS is running. 

Recommended Action: Make sure external checker is working.

FAILED EnumDimensions Launch external checker with next command: C:\Oracle\Middleware\EPMSystem11R1\..\jdk160_35/bin/java -DEPM_ORACLE_HOME=C:\Oracle\Middleware\EPMSystem11R1 -DEPM_ORACLE_INSTANCE=C:\Oracle\Middleware\user_projects\epmsystem1 -Djava.util.logging.config.class=oracle.core.ojdl.logging.LoggingConfiguration -Doracle.core.ojdl.logging.config.file=C:\Oracle\Middleware\user_projects\epmsystem1\config\validation\11.1.2.0\validationTool-logging.xml com.oracle.epm.epma.config.validations.dimeditor.EnumDimensions
Error: EnumDimensions failed on initialization. Please check all registry information is valid and that HSS is running. 

Recommended Action: Make sure external checker is working. 

Please change the TCP/IP Port to 1433 as SQL Express Database is running on that port as shown below