Why... Why... Why?
This blog is dedicated to documenting error resolution and other tidbits that I discover while working as a Consultant in the Oracle EPM (Hyperion) field. As much of my job revolves around issue resolution, I see an opportunity to supplement the typical troubleshooting avenues such as the Oracle Knowledgebase and Oracle Forums with more pinpointed information about specific errors as they are encountered. Beware, the information found in this blog is for informational purposes only and comes without any warranty or guarantee of accuracy.

EPMVirt: Create your own Oracle Hyperion Virtual Environment:

Friday, February 1, 2013

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.

By at
Labels:

2 comments:

  1. Henri VilminkoFebruary 4, 2013 at 12:42 AM

    Hi,
    The easiest way (and probably recommended by Oracle too) is to configure the EPM applications first and after this apply the patches. As far as I know this error only appears if you patch before configuring.

    Regards,
    Henri

    ReplyDelete
    Replies
    1. Nicholas KingFebruary 4, 2013 at 8:32 AM

      I am not sure that I agree. This issue prevents reconfiguring the db and redeployment for epma. So password rotation and database related changes are not possible. Potentially even other subsequent patches. I am sure some folks will start seeing the this over time.

      Delete

Subscribe to: Post Comments (Atom)