WebAnalysis Installation on a Patched EPM Platform

I had a unique situation present itself in front of me when business wanted me to install WebAnalysis on top of a complete with patches, pretty looking platform.  I got to it with much gusto and was able to get through with the installation smoothly.

The Configuration went fine as well except for the "Reregistration of Scripts",which failed. This is essential for creation of the WebAnalysis Tables in the BI+ Schema.

That didn't preven't me from logging into WebAnalysis Studio however and when I tried to create a connection and save it, it would never happen and the java console gave messages like

Java Plug-in 1.6.0_29

Using JRE version 1.6.0_29-b11 Java HotSpot(TM) Client VM

User home directory = C:\Users\XXXXXX

----------------------------------------------------

c:   clear console window

f:   finalize objects on finalization queue

g:   garbage collect

h:   display this help message

l:   dump classloader list

m:   print memory usage

o:   trigger logging

q:   hide console

r:   reload policy configuration

s:   dump system and deployment properties

t:   dump thread list

v:   dump thread stack

x:   clear classloader cache

0-5: set trace level to

---------------------------------------------------

load: class com.hyperion.analyzer.usersession_base.AnalyzerClient not found.

java.lang.ClassNotFoundException: com.hyperion.analyzer.usersession_base.AnalyzerClient

at sun.plugin2.applet.Applet2ClassLoader.findClass(Unknown Source)

at sun.plugin2.applet.Plugin2ClassLoader.loadClass0(Unknown Source)

at sun.plugin2.applet.Plugin2ClassLoader.loadClass(Unknown Source)

at sun.plugin2.applet.Plugin2ClassLoader.loadClass(Unknown Source)

at java.lang.ClassLoader.loadClass(Unknown Source)

at sun.plugin2.applet.Plugin2ClassLoader.loadCode(Unknown Source)

at sun.plugin2.applet.Plugin2Manager.createApplet(Unknown Source)

at sun.plugin2.applet.Plugin2Manager$AppletExecutionRunnable.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

The following was the solution:

1. Update 'EPM_ORACLE_HOME\upgrades\webanalysis\update_registry.bat' script:
"%JAVA_HOME%\bin\java" -DEPM_ORACLE_HOME=%EPM_ORACLE_HOME%
"%JAVA_HOME%\bin\java" -DEPM_ORACLE_HOME=%EPM_ORACLE_HOME%

Replace:

-DEPM_ORACLE_INSTANCE=%EPM_ORACLE_INSTANCE% %ODL_PROP% %LOCALEPROP%

com.hyperion.analyzer.upgrade.HYARegistryMigrator %SOURCE_SYSTEM% "  with

-DEPM_ORACLE_INSTANCE=%EPM_ORACLE_INSTANCE% %ODL_PROP% %LOCALEPROP%

com.hyperion.analyzer.upgrade.HYARegistryMigrator  "

and rerun the EPM System Configurator. The "Process Reregistration Script" portion should go through perfectly after this.

2. Run analyzer_upgrades.sql line by line on your BI plus schema.

3. Run your Web Server Config as the last step .