Assign Access Control View appears in different font on 11.1.2.3

On 11.1.2.3 base version,once you launch Foundation via workspace, expand any Essbase Server and right click to assign access control, the view appears in a completely different font . It reminds me what it used to look like prior to 11.1.1.3.

This is a published Bug 17354487: ASSIGN ACCESS CONTROL BUTTON ICONS MISSING and the solution is to copy “ui_themes” folder from

  C:\Oracle\Middleware\user_projects\domains\EPMSystem\servers\FoundationServices0\tmp\_WL_user\SHAREDSERVICES_11.1.2.0\yidcyl\war

 To:

  C:\Oracle\Middleware\user_projects\domains\EPMSystem\servers\FoundationServices0\tmp\_WL_user\WORKSPACE_11.1.2.0\340u89\war

Stop and start foundation services for the change to be updated.

This problem will then be resolved. 

WebAnalysis on 11.1.2.3 doesn't launch SSL URL

When I installed SSL for all my applications on 11.1.2.3, The link for WebAnalysis Studio did not launch . It started the JRE but failed to launch the logon screen. In an attempt to debug the issue, I opened the java console and enabled logging. I saw the below exception there:

The link worked on 19000 but not on 443. The reason behind this is that rewrite rule was not present in my httpd.conf and adding the entry below in this section helped me resolve the issue.

RewriteRule ^/WebAnalysis/static/(.*) /epmstatic/webanalysis/$1 [PT]

So , the complete section should look like this when done.

RewriteEngine On

RewriteRule ^/interop/bpmstatic/(.*) /epmstatic/bpmui/$1 [PT]

RewriteRule ^/raframework/bpmstatic/(.*) /epmstatic/bpmui/$1 [PT]

RewriteRule ^/workspace/static/(.*) /epmstatic/wspace/$1 [PT]

RewriteRule ^/workspace/bpmstatic/(.*) /epmstatic/bpmui/$1 [PT]

RewriteRule ^/HyperionPlanning/help/(.*) /epmstatic/planning/docs/$1 [PT]

RewriteRule ^/calcmgr/bpmstatic/(.*) /epmstatic/bpmui/$1 [PT]

RewriteRule ^/awb/bpmstatic/(.*) /epmstatic/bpmui/$1 [PT]

RewriteRule ^/WebAnalysis/static/(.*) /epmstatic/webanalysis/$1 [PT]

This fix is explained in more detail in Doc ID 1354981.1

FR Icons missing in BI+ Workspace

When I installed 11.1.2.3, FR was my choice of reporting tool and I noticed something quite odd on the User Interface. The icons for FR were not visible and I would attach a screenshot, But I forgot to take one and I resolved the issue so the issue no longer is there. I have installed quite a few instances and this behavior has not been consistent. In any case, the resolution for it is below. Looks like there is a KM for this for 11.1.2.1 Doc ID 1368253.1 .

• Go to the C:\Oracle\Middleware\EPMSystem11R1\products\biplus\InstallableApps directory 
• Using 7-zip (http://www.7-zip.org), open the raframework.ear file 
• Using 7-zip, open the raframework.war file from within the raframework.ear file 
• Using 7-zip, open the WEB-INF directory from within the raframework.war file 
• Using 7-zip, open the weblogic.xml file from within the WEB-INF directory to modify the file 
• The tag may contain a path that looks like @oracleInstance@/ReportingAnalysis/RAFrameworkWebapp 
• Change so it will look like C:/Oracle/Middleware/user_projects/epmsystem1/ReportingAnalysis/RAFrameworkWebapp 
• Save the file and update the weblogic.xml file in the archive when prompted. 
• Restart the RAF webapp service 

This fix helps resolve the issue. 

Load balanced 2nd node for Hyperion BI+ doesn't work independently

While building 11.1.2.3 from the  ground up, I have run into a string of issues. I will continue to post on all the issues but these tips can help someone who may be in a similar situation and some things to think about while troubleshooting them.

I have every web application load balanced on windows 2008 r2 64 bit . I began testing as soon as I completed configuring everything and started to test indepently to see if node 2 continues to run when node1 is completely down because in an actual DR situation these things matter.Thats when I ran into this message for the first time.

"The Startup Document does not exist in the repository" followed by "GSM_unabletoacquire LSM"

On a network deployment there are several reasons that can cause this:

1. The service account for the HyS9RaFrameworkAgent_epmsystem is not the same as the installer but the "local system" account. This is an absolute must since RM1 is a shared folder across 2 servers.

2. The Service Broker service and the GSM on the second server is not enabled.
To Resolve this,
- Log on to EPM Workspace on Server1
- Select Navigate, then Reporting and Analysis, and then Services.
- Right-click Reporting and Analysis for server2 , and then select Properties.
- On the Services tab, set GSM to Enabled (Yes) and Service Broker to Enable (Yes).

3. Verify that HAVA ID in EPM registry matched in css_provisioning_info table
a: Execute the following query against the Shared Services registry database:
b: select application_id from css_provisioning_info where lower(application_id) like 'hava%';
 note this application id, e.g. HAVA:0000000b0000bf00-0000-0000-0acc1bac
c: Run epmsys_registry.bat from \Oracle\Middleware\user_projects\epmsystem1\bin
Open EPM registry.xml and search for HAVA and compare the HAVA ID using the ID above

d: If there is a mismatch, edit the Shared Services Registry:
Go to EPM_ORACLE_INSTANCE/bin and run the following command:
epmsys_registry updateproperty RA_FRAMEWORK/@applicationId

Where applicationId is the id returned from the query above. For example, using the id above:

epmsys_registry updateproperty RA_FRAMEWORK/@applicationId HAVA: 0000000b0000bf00-0000-0000-0acc1bac

e. Restart all services on Server1 and ensure Shared Services and Workspace are accessible

However, in my case, all of these seemed perfect. I stumbled upon my resolution by chance . The Location for the RM1 shared folder (in the configurator, Eg: \\server1\c$\Oracle\Middleware\user_projects\epmsystem1\ReportingAnalysis\data\RM1 stopped being recognized from server 2 . 

The way in which server 1 is resolved from server 2 turned out to be the root cause of my issue.It used to be accessible by the short name earlier and suddenly started to accept only the FQDN owing to some DNS related changes.  In my opinion, We should go with the same servername that we issue in the host file as part of the preinstall. To override that, I added an entry on the server 2 host file and it started working.

EAS SSL Link offloaded at OHS throws a jnlp file

I am on 11.1.2.3.503 and the SSL link for EAS presents me with a jnlp file and it works fine with the 19000 link .

But when you try to access the SSL link, it throws a " administration server does not exist" error.

While this has been discussed in plenty in various KMs DocID1346806.1 . This fix worked perfectly on 11.1.2.2 but on 11.1.2.3 , There is one additional fix that the KM doesn't cover.


The solution is to modify the link wherever you see a reference to the old link, modify that reference to include the 443 port.

Example of these entries are below:

       
       



Now if you save a local copy of these files, if you double click the jnlp it launches the SSL console and you don't see the error anymore.

SSL offloaded at OHS results in smartview RAF not displaying any reports

On a SSL implemented 11.1.2.3 system, which is offloaded at OHS , there is a problem with displaying the list of reports inside the cname. This is a really weird problem as the link works on 19000 .

The end result might look something like this.

According to the DocID1364770.1 , Applying the fix for the step 1 and 2 should fix the issue. But it doesn't , in my case.

Step 1:

• Configure Weblogic to look for specific HTTP headers, amongst which the "WL-Proxy-SSL" header:

1. Start the Weblogic Administration server
2. Log in to the Weblogic Administration Console, then put the Weblogic console into lock/edit mode
3. On the left-hand side, select the top level branch named "epm_system" (i.e. the domain name)
4. Select "Web Applications" on the right hand side
5. Scroll down and enable the option named "Weblogic Plugin Enabled"
6. Save and activate the changes.

Step 2:

• Configure the OHS component to populate the requests with the "WL-Proxy-SSL" HTTP header:

1. On all servers hosting the OHS component, edit the file called httpd.conf (located in \Middleware\user_projects\epmsystem1\httpConfig\ohs\config\OHS\ohs_component) and append the following line at the bottom:
2. WLProxySSL ON
3. Save and close that file.

To resolve the issue, I applied the below fix:

Backup Shared Services repository database 

1. On the server that hosts the Shared Services Registry, open a command prompt. 

2. Go to C:\Oracle\Middleware\user_projects\epmsystem1\bin and run the following commands: 

epmsys_registry addproperty system9/@enable_ssl_offloading true 

epmsys_registry addproperty system9/@external_url_host  (SSL_off_loader_host_name) 

epmsys_registry addproperty system9/@external_url_port 443 (SSL_off_loader_port) 

3: Restart Foundation, Workspace Agent, and Workspace web applications services 

This fixes the issue and the list can now be seen on Smartview