EPM System Configurator Crashes During EPMA Configure Database

I just saw this one on the forums. Since I spent some time scratching my head on the issue and others are starting to see it I thought I would write it up...

In a patched 11.1.2.2 environment while configuring the EPMA database connection in config tool the config tool will crash.

In the configtool.log you would find:
[2013-01-30T11:34:00.420-05:00] [EPMCFG] [TRACE] [EPMCFG-01758] [oracle.EPMCFG] [tid: 16] [ecid: 0000JmCJgspEwGIFmrADS31H2KhK000003,0] [SRC_CLASS: com.hyperion.config.wizard.impl.DBConnectionForm] DB type is Oracle
[2013-01-30T11:34:00.420-05:00] [EPMCFG] [ERROR] [EPMCFG-01020] [oracle.EPMCFG] [tid: 16] [ecid: 0000JmCJgspEwGIFmrADS31H2KhK000003,0] [SRC_CLASS: com.hyperion.cis.config.Configurator] Error: [[
java.lang.NoClassDefFoundError: com/hyperion/cis/ISMPWizardServices
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:247)
at com.hyperion.cis.config.Configurator.loadClass(Configurator.java:172)
at com.hyperion.cis.config.Configurator.loadProductDBConfigurators(Configurator.java:201)
at com.hyperion.config.wizard.impl.DBWizardState$1.validate(DBWizardState.java:348)
at com.hyperion.hit.wizard.Wizard$NextClass.run(Wizard.java:531)
at java.lang.Thread.run(Thread.java:662)
Caused by: java.lang.ClassNotFoundException: com.hyperion.cis.ISMPWizardServices
at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at java.lang.ClassLoader.loadClass(ClassLoader.java:247)
... 7 more

]]



The reason is that the Oracle patch has broken the jar file AWBConfig.jar located
d:\oracle\Middleware\EPMSystem11R1\products\Foundation\BPMA\Common

The broken EPMA patch number is 14031912

There are missing classes in the patched , newer version of this jar

To fix the config tool you can make a copy of this existing jar and replace the older unpatched version. To find the old version search,
\oracle\Middleware\EPMSystem11R1\.patch_storage\ for AwbConfig.jar

To confirm this, look at the size of the current jar and the older jar - the new one is 158k and the old one was 317k - obviously the new one is missing some classes.

Once you are done with the config tool put the "newer" one back.

EPMA - Troubleshooting

There are two main EPMA components, an Internet Information Services (IIS) component and a WebLogic component. It is helpful to know the difference to pinpoint issues in EPMA. Since they are completely different technologies, spending time looking into one part while the problem is in another is wasteful. One can narrow down where to look by these urls:
 
IIS Component:
http://hostname/hyperion-bpma-server/Sessions.asmx

Application Server Component(WebLogic/WebSphere)
http://hostname:19091/awb/conf/AwbConfig.xml

Configuring EPMA - the Service Name or SID must match with SERVICE_NAME

Problem Description
I am getting bellow error while configuring Financial Management on epma 11.1.2.1:

EPMCFG-10390: For successful completion of this task, the Service Name or SID must match with SERVICE_NAME in tnsnames.ora file.

I have made sure tnsnames.ora (from C:\app\Administrator\product\11.2.0\client_1\network\admin) has the same sid as i have given on configurator screen.


Resolution
I discovered that in my case the configurator was having trouble creating the .udl file for HFM. So I went in and manually created the .udl file and then the configuration tool, while still showing that warning, did complete successfully.

In user_projects\epmsystem1\products\FinancialManagement\Server Working Folder

Create a new file, ORACLE_hfm.udl

Enter the credentials to the Oracle ODE connection, click allow save password, and click test to ensure it works.

After this the config tool should be able to complete the remaining configuration tasks.