WebSphere Hyperion Upgrade 9.3.3.x

Steps to upgrade Hyperion from 9.1.x to 9.3.3.x

Upgrade Shared Services
1) Download SharedServices_9_3_3_aix.tar and extract the contents
2) Stop Workspaces, Reporting servers, SharedServices and OpenLDAP
3) Run setup.bin
   install path reference
   -W bean6.hyperionHome=/apps/Hyperion
   -P installLocation="/apps/Hyperion/SharedServices/9.3.1"
  Exit the installation wizard without launching the Hyperion Configuration Utility.

4) Run ./configtool.sh -console
5) Verify css.install.upgrade=true in CMS.properties
6) Deploy interop.ear manually through websphere console
7) If plugin is used, check <Config AcceptAllContent="true">. If not, change it.
8) Start OpenLDAP and SharedServices Server
9) Validate Shared Services URL
   http://servername:port/interop/index.jsp
   http://servername:port/interop/content

Upgrade Workspace
1) Download Workspace patch p9900557_93300_AIX.tar and extract the contents
2) Stop Workspaces, Reporting servers, SharedServices and OpenLDAP
3) Update 9.3.3.0.0.158_aix/SP_Installer/patch.properties with correct db information if desired.
4) Set BIPLUS_HOME in patch.sh
5) Run 9.3.3.0.0.158_aix/SP_Installer/patch.sh from the extracted files
6) Run ./configtool.sh -console
   a) Because WebSphere ND is used, set manual mode as true (Manual: true)
   b) Choose both options Deploy to App Server & Configure Web Server
   c) Configure components: type false for all components
8) workspace.war will be created in /apps/Hyperion/BIPlus/InstallableApps directory
9) Deploy the workspace.war manually through the console - you can pick precompilejsps=true
10) Create a file context.properties with the following content and place it under workspace.war/conf directory
   This step is very important. Otherwise, Explore icon in workspace will not show up and login will be impacted as well
    #cat context.properties
    HPSU=Y
    ChangeManagement=Y
    Reports=N
    Analyzer=N
    HP=N
    BPMA=N
    HFM=N
    HPS=N
 
11) Update WEB-INF/web.xml with session timeout of 120 instead of 60
12) Make these changes in JSPs in workspace.war/jsp/shared directory
    - editBQYActionEmailOptionsWidget.jsp (2 occurrences of 250 that needs to be 2000)
    - editBQYActionEmailSectionWidget.jsp (2 occurrences of 250 that needs to be 2000)
    - editBQYActionEmailWidget.jsp (1 occurrence of 250 that needs to be 2000)
13) Start OpenLDAP, Shared Services and Wokspace
14) Validate workspace URL
    http://servername:port/workspace/index.jsp
15) Apply Microsoft 2010 patch - copy clientservlet.jar to workspace WEB/lib (no restart required)
16) Repeat steps on all workspace servers.

IHS/Plugin steps
1) Regenerate the plugin from WebSphere ND.
2) In plugin-cfg.xml, Check <Config AcceptAllContent="true">. If not, change it.
3) In plugin-cfg.xml, Replace workspace/* with the following.

   <Uri AffinityCookie="JSESSIONID" AffinityURLIdentifier="jsessionid" Name="/workspace/cdsrpc"/>
   <Uri AffinityCookie="JSESSIONID" AffinityURLIdentifier="jsessionid" Name="/workspace/administration/*"/>
   <Uri AffinityCookie="JSESSIONID" AffinityURLIdentifier="jsessionid" Name="/workspace/browse/*"/>
   <Uri AffinityCookie="JSESSIONID" AffinityURLIdentifier="jsessionid" Name="/workspace/personalpages/*"/>
   <Uri AffinityCookie="JSESSIONID" AffinityURLIdentifier="jsessionid" Name="/workspace/viewmanager/*"/>
   <Uri AffinityCookie="JSESSIONID" AffinityURLIdentifier="jsessionid" Name="/workspace/jobmanager/*"/>
   <Uri AffinityCookie="JSESSIONID" AffinityURLIdentifier="jsessionid" Name="/workspace/ihtml/*"/>
   <Uri AffinityCookie="JSESSIONID" AffinityURLIdentifier="jsessionid" Name="/workspace/dataaccess/*"/>
   <Uri AffinityCookie="JSESSIONID" AffinityURLIdentifier="jsessionid" Name="/workspace/logon"/>
   <Uri AffinityCookie="JSESSIONID" AffinityURLIdentifier="jsessionid" Name="/workspace/logon/*"/>
   <Uri AffinityCookie="JSESSIONID" AffinityURLIdentifier="jsessionid" Name="/workspace/prefs"/>
   <Uri AffinityCookie="JSESSIONID" AffinityURLIdentifier="jsessionid" Name="/workspace/js/*"/>
   <Uri AffinityCookie="JSESSIONID" AffinityURLIdentifier="jsessionid" Name="/workspace/modules/*"/>
   <Uri AffinityCookie="JSESSIONID" AffinityURLIdentifier="jsessionid" Name="/workspace/resources/*"/>
   <Uri AffinityCookie="JSESSIONID" AffinityURLIdentifier="jsessionid" Name="/workspace/conf/*"/>
   <Uri AffinityCookie="JSESSIONID" AffinityURLIdentifier="jsessionid" Name="/workspace/media/*"/>
   <Uri AffinityCookie="JSESSIONID" AffinityURLIdentifier="jsessionid" Name="/workspace/BPMContext"/>
   <Uri AffinityCookie="JSESSIONID" AffinityURLIdentifier="jsessionid" Name="/workspace/wsrp4j/*"/>
   <Uri AffinityCookie="JSESSIONID" AffinityURLIdentifier="jsessionid" Name="/workspace/ResourceProxy"/>
   <Uri AffinityCookie="JSESSIONID" AffinityURLIdentifier="jsessionid" Name="/workspace/"/>
   <Uri AffinityCookie="JSESSIONID" AffinityURLIdentifier="jsessionid" Name="/workspace/*.jsp"/>
   <Uri AffinityCookie="JSESSIONID" AffinityURLIdentifier="jsessionid" Name="/workspace/*.jsv"/>
   <Uri AffinityCookie="JSESSIONID" AffinityURLIdentifier="jsessionid" Name="/workspace/*.jsw"/>

4) Check LoadModule and WebSpherePluginConfig lines are not commented out in httpd.conf. Hyperion installer sometimes update httpd.conf.
5) Restart web server

Troubleshooting
1) workspace.ear/workspace.war/WEB-INF/config/ws.conf & workspace.ear/workspace.war/WEB-INF/portlet.xml will have references to reporting server.
   ./WEB-INF/config/ws.conf:WebClient.UserInterface.Login.RMServer=myhypr01:6800
   ./WEB-INF/config/ws.conf:WebClient.Diagnostics.Log.LoggingService=myhypr01:6800
   ./WEB-INF/portlet.xml:            <value>myhypr01</value>