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>