Oracle Hyperion Reporting and Analysis
Release 11.1.2.1.000 Patch Set Update (PSU): 11.1.2.1.135
Readme
Defects Fixed in Patch 11.1.2.1.131 (14832995)
Defects Fixed in Patch 11.1.2.1.126 (14277930)
Defects Fixed in Patch 11.1.2.1.121 (13845220)
Defects Fixed in Patch 11.1.2.1.117 (13535756)
Defects Fixed in Patch 11.1.2.1.112 (13076636)
Defects Fixed in Patch 11.1.2.1.109 (12910457)
Defects Fixed in Patch 11.1.2.1.106 (12865010)
Defects Fixed in Patch 11.1.2.1.105 (12777979)
Why do I get the following patch conflict error message when running OPatch?
Why do I get the OUI-67078 warning message when applying OPatch?
How can I find out which releases and patches of EPM System products are installed in a deployment?
This Readme file describes the defects fixed in this patch and the requirements and instructions for applying this patch.
Caution: You are urged to carefully read and understand the following requirements. Failure to comply may result in applying a patch that can cause your application to malfunction, including interruption of service and/or loss of data. Before installing or applying this patch:
Verify that your system configuration (product version, patch level, and platform) exactly matches what is specified in the Readme.
This is a patch set update (PSU).
This patch replaces files in the existing installation and does not require a full installation.
This patch is cumulative and includes fixes from:
· 11.1.2.1.131 (14832995)
· 11.1.2.1.126 (14277930)
· 11.1.2.1.121 (13845220)
· 11.1.2.1.117 (13535756)
· 11.1.2.1.112 (13076636)
· 11.1.2.1.109 (12910457)
· 11.1.2.1.106 (12865010)
· 11.1.2.1.105 (12777979)
You can apply this patch to the following releases:
· 11.1.2.1.131 (14832995)
· 11.1.2.1.126 (14277930)
· 11.1.2.1.121 (13845220)
· 11.1.2.1.117 (13535756)
· 11.1.2.1.112 (13076636)
· 11.1.2.1.109 (12910457)
· 11.1.2.1.106 (12865010)
· 11.1.2.1.105 (12777979)
· 11.1.2.1.000
The user applying the patch should be the user who was set up to install and configure EPM System products. Required user privileges or rights:
Use the user account that has Local administrator rights and was set up for installation and configuration. This user is an administrator and is the same for all EPM System products. Assign local policies if required by the product. Such assignments typically are: “Act as part of the operating system, Bypass traverse checking, Log on as a batch job, Log on as a service.”
Use the account that was used to install EPM System products and has Read, Write, and Execute permissions on $MIDDLEWARE_HOME. If you installed other Oracle products, the user who installed EPM System products must be in the same group as the user who installed the other Oracle products. OPatches are not intended to be applied using a root user.
This patch applies to all supported platforms.
This patch supports all languages supported by Web Analysis, Release 11.1.2.1.000.
|
Defect Number |
Defect Fixed |
|
• 16683351 |
UNABLE TO CLICK ON DROPDOWN ON WA REPORT IN WORKSPACE WHEN ALIAS NAME HAS ")" |
|
Defect Number |
Defect Fixed |
|
• 14318647 |
Login time may increase if the Repository has a flat structure (folders contain a lot of subfolders). For instance, if there are lots of users provisioned in the EPM System and they use Web Analysis then all their home folders will be stored in the /Users folder. In this case login time will increase for non-admin users. |
|
• 14810767 |
The issue: in some cases, when a calculation results with missing data (for example, arguments of the calculation contains missing data only) and display options suppress missing data (for example, missing data in rows) the result of the calculation is still sown in spread sheet. This is incorrect because all missing rows must be suppressed. The fix for this bug resolves the issue and missing data calculation result is suppressed. This means that calculation will be suppressed if at least one parameter is missing. But if a user wants to calculate Total for all available members he should use function parameter @selectAllMembers and calculation script will look like: Sum( @selectAllMembers ) |
|
Defect Number |
Defect Fixed |
|
• 13844881 |
Opening/updating a report requires a lot of time in case when the report contains a lot of Analysis Tools which have references to OLAP members currently unavailable in the spreadsheet. This behaviour is a side effect of the 9795636 defect fix. If the issue described in the 9795636 defect is not critical, then corresponding fix can be disabled/deactivated by a new configurable application property - ResolvingOfNotFoundMemberEnabled. Set the property to False to increase the opening/updating speed. In this case the fix of the 9795636 defect will be disabled. Set the property to True to enable the fix of the 9795636 defect. The ResolvingOfNotFoundMemberEnabled property can be managed via Registry editor: Windows: <EPM_ORACLE_INSTANCE>\bin\epmsys_registry.bat UNIX/Linux: <EPM_ORACLE_INSTANCE>\bin\epmsys_registry.sh |
|
• 13877299 |
It is impossible to import into MS Excel (with SmartView plug-in) any WA report with Russian characters in the report name: MS Excel shows error message and report export is broken. |
|
• 13950632 |
This issue is connected to migrating 9.3.3 report into 11.1.2.1. If a 9.3.3 report contains Percent Of Member calculation after migration this report into 11.1.2.1 calculation script will be incorrect: opposite member for PoM function is lost. |
|
• 13995995 |
The imported reports take a long period of time for opening and may not be saved after the migration of Web Analysis to 11.1.2.1.117.79717. |
|
• 14273603 |
In some cases edited data is not saved and the user receives an error message containing the following string: "Error: Update data error [Cannot update. Essbase Error(1003047): Data Load maximal record size [32000] exceeded near record" |
|
Defect Number |
Defect Fixed |
|
• 13849162 |
Web Analysis renames some functions in reports migrated from Release 9.3.x to Release 11.1.2.1.x. |
|
• 13799276 |
There are formatting problems when printing Web Analysis reports in PDF format. |
|
• 13774710 |
Sometimes when running large reports, Web Analysis applications stop responding or significant performance slowdown is observed. |
|
• 13708181 |
When exporting Web Analysis reports to Microsoft Word using EPM Workspace, formatting problems can occur in the exported file. |
|
Defect Number |
Defect Fixed |
|
• 13535716 |
Some Web Analysis reports open slowly. |
|
• 13417817 |
The Sum function returns N/A if one dimension does not have a value. |
|
Defect Number |
Defect Fixed |
|
• 13064071 |
When Web Analysis reports have more than one row dimension, the column sort value is ignored. Set the property to True to sort the data query result set through all dimensions on the axis independently on member names. Set SortingByGroupDisabled to False to sort the data query result set within logical groups based on the selected members for each group. |
|
• 13031202 |
In Web Analysis Studio, sometimes reports are slow to open. |
|
Defect Number |
Defect Fixed |
|
• 12910418 |
Sometimes, saving Web Analysis documents as HTML files results in truncated or missing data objects (spreadsheets, charts, pinboards) in the HTML files. |
|
• 12910409, 12910395 |
If document names are double-byte strings, saving the files as HTML generates invalid files. |
|
• 12887340 |
When importing Web Analysis reports with charts into Smart View using Microsoft Word or Microsoft PowerPoint, memory problems may occur. |
|
Defect Number |
Defect Fixed |
|
• 12864992 |
Users cannot run an Essbase calculation script when using Web Analysis due to permission problems. |
|
Defect Number |
Defect Fixed |
|
• 12777954 |
If you use Save As to save a Web Analysis report, the report description is not copied to the renamed report. |
This patch does not contain any known issues.
A calculation will be totally suppressed if at least one parameter is missing. In some cases this behaviour may be not desirable. So if a user needs a Total for all available members they should consider using the "@selectAllMembers" function parameter and calculation formula like: Sum( @selectAllMembers ).
The section includes important information about applying this patch for Web Analysis.
To apply this patch:
1. Oracle recommends making a backup of the existing installation before applying this patch.
2. Shut down all services and servlet instances related to Hyperion Reporting and Analysis Release 11.1.2.1.
3. Download and unzip the downloaded patch file, <PATCH FILE NAME>.zip, to the <EPM_ORACLE_HOME>/OPatch directory (by default, Oracle/Middleware/EPMSystem11R1/OPatch).
NOTE: <PATCH FILE NAME>.zip is the name that My Oracle Support assigns to this patch. When you download the file, a message indicates the file name.
4. Navigate to <EPM_ORACLE_INSTANCE>/bin.
5. Run the following command on one line:
Windows:
epmsys_registry.bat addproperty
SYSTEM9/WEBANALYSIS_PRODUCT/LOGICAL_WEB_APP/@SortingByGroupDisabled true
UNIX:
epmsys_registry.sh addproperty
SYSTEM9/WEBANALYSIS_PRODUCT/LOGICAL_WEB_APP/@SortingByGroupDisabled true
6. Run the following command on one line:
Windows:
epmsys_registry.bat addproperty SYSTEM9/WEBANALYSIS_PRODUCT/LOGICAL_WEB_APP/@ResolvingOfNotFoundMemberEnabled
true
UNIX:
epmsys_registry.sh addproperty
SYSTEM9/WEBANALYSIS_PRODUCT/LOGICAL_WEB_APP/@ResolvingOfNotFoundMemberEnabled
true
7. From a command line, change the directory to <EPM_ORACLE_HOME>/OPatch.
8. To apply the patch, enter the following command on one line:
Windows:
opatch.bat apply
<EPM_ORACLE_HOME>\OPatch\16847890-oh <EPM_ORACLE_HOME>
-jdk <MIDDLEWARE_HOME>\jdk160_21
NOTE: The default for <EPM_ORACLE_HOME> is C:\Oracle\Middleware\EPMSystem11R1. The default for <MIDDLEWARE_HOME> is C:\Oracle\Middleware.
UNIX/Linux:
./opatch apply <EPM_ORACLE_HOME>/OPatch/16847890 -oh <EPM_ORACLE_HOME> -jdk <MIDDLEWARE_HOME>/jdk160_21 -invPtrLoc <EPM_ORACLE_HOME>/oraInst.loc
NOTE: The default for <EPM_ORACLE_HOME> is $HOME/Oracle/Middleware/EPMSystem11R1. The default for <MIDDLEWARE_HOME> is $HOME/Oracle/Middleware.
9. Clean up caches for RaFramework0 and WebAnalysis0 WebLogic servers. Clear the contents of the tmp directories:
Windows:
<WEBLOGIC_DOMAIN_HOME>\servers\RaFramework0\tmp
<WEBLOGIC_DOMAIN_HOME>\servers\WebAnalysis0\tmp
NOTE: The default for <WEBLOGIC_DOMAIN_HOME> is C:\Oracle\Middleware\user_projects\domains\EPMSystem
UNIX/Linux:
<WEBLOGIC_DOMAIN_HOME>/servers/RaFramework0/tmp
<WEBLOGIC_DOMAIN_HOME>/servers/WebAnalysis0/tmp
NOTE: The default for <WEBLOGIC_DOMAIN_HOME> is $HOME/Oracle/Middleware/user_projects/domains/EPMSystem
10. Start all services and servlets.
1. Oracle recommends making a back up of the existing installation before rolling back this patch.
2. Shut down all services and servlet instances related to Hyperion Reporting and Analysis Release 11.1.2.1.
3. From a command line, change the directory to <EPM_ORACLE_HOME>/OPatch (by default, Oracle/Middleware/EPMSystem11R1/OPatch).
4. To roll back the patch, enter the following command on one line:
Windows:
opatch.bat rollback -id 16847890 -oh <EPM_ORACLE_HOME> -jdk <MIDDLEWARE_HOME>\jdk160_21
NOTE: The default for <EPM_ORACLE_HOME> is C:\Oracle\Middleware\EPMSystem11R1. The default for <MIDDLEWARE_HOME> is C:\Oracle\Middleware.
UNIX/Linux:
./opatch rollback -id 16847890 -oh <EPM_ORACLE_HOME> -jdk <MIDDLEWARE_HOME> /jdk160_21 -invPtrLoc <EPM_ORACLE_HOME>/oraInst.loc
NOTE: The default for <EPM_ORACLE_HOME> is $HOME/Oracle/Middleware/EPMSystem11R1. The default for <MIDDLEWARE_HOME> is $HOME/Oracle/Middleware.
5. Navigate to <EPM_ORACLE_INSTANCE>/bin.
6. Run the following command on one line:
Windows:
epmsys_registry.bat removeproperty SYSTEM9/WEBANALYSIS_PRODUCT/LOGICAL_WEB_APP/@SortingByGroupDisabled
UNIX:
epmsys_registry.sh removeproperty SYSTEM9/WEBANALYSIS_PRODUCT/LOGICAL_WEB_APP/@SortingByGroupDisabled
7. Run the following command on one line:
Windows:
epmsys_registry.bat removeproperty SYSTEM9/WEBANALYSIS_PRODUCT/LOGICAL_WEB_APP/@ResolvingOfNotFoundMemberEnabled
UNIX:
epmsys_registry.sh removeproperty SYSTEM9/WEBANALYSIS_PRODUCT/LOGICAL_WEB_APP/@ResolvingOfNotFoundMemberEnabled
8. Clean up caches for RaFramework0 and WebAnalysis0 WebLogic servers. Clear the contents of the tmp directories:
Windows:
<WEBLOGIC_DOMAIN_HOME>\servers\RaFramework0\tmp
<WEBLOGIC_DOMAIN_HOME>\servers\WebAnalysis0\tmp
NOTE: The default for <WEBLOGIC_DOMAIN_HOME> is C:\Oracle\Middleware\user_projects\domains\EPMSystem
UNIX/Linux:
<WEBLOGIC_DOMAIN_HOME>/servers/RaFramework0/tmp
<WEBLOGIC_DOMAIN_HOME>/servers/WebAnalysis0/tmp
NOTE: The default for <WEBLOGIC_DOMAIN_HOME> is $HOME/Oracle/Middleware/user_projects/domains/EPMSystem
9. Start all services and servlets.
If the patch that you apply conflicts with a previously applied patch, you may receive the following error message when running OPatch:
Patch(es) <PreviousPatch#> conflict with the patch currently being installed (<NewPatch#>).
If you continue, patch(es) <PreviousPatch#> will be rolled back and the new patch (<NewPatch#>) will be installed.
If a merge of the new patch (<NewPatch#>) and the conflicting patch(es) (<PreviousPatch#>) is required, contact Oracle Support Services and request a Merged patch.
This error is returned when one patch attempts to update a previously patched file. When this conflict happens, you can either (1) roll back the previous patch and apply the new patch (this action might be appropriate if the previous patch was not critical) or (2) request a “merged patch” consisting of the new patch and the patch that it conflicts with. To request a merged patch, contact your Oracle Support representative.
This warning means that the patch being applied is a superset of a patch already on the deployment and the existing patch will be rolled back. The following snippet shows the context of this warning.
The following warnings have occurred during OPatch
execution:
1) OUI-67078:Interim patch 12345678 is a superset of the patch(es) [77777777]
in OH C:\Hyperion
-----------------------------------------------------------------------------------
OPatch Session completed with warnings.
In EPM System Release 11.x, you can use the lsinventory command to OPatch to find the release and patches that are installed in an Oracle Home. For example, enter the following command on one line:
Windows:
opatch.bat lsinventory -oh <EPM_ORACLE_HOME> -jdk <MIDDLEWARE_HOME>/jdk160_21
UNIX/Linux:
./opatch lsinventory -oh <EPM_ORACLE_HOME> -jdk <MIDDLEWARE_HOME>/jdk160_21 –invPtrLoc <EPM_ORACLE_HOME>/oraInst.loc
When patching an .EAR file for an application, you may need to delete the cached files in the following folders in order to see the changes provided with the patch:
<MIDDLEWARE_HOME>/user_projects/domains/<DOMAIN_NAME>/servers/
<MANAGED_SERVER_NAME/tmp/
<MIDDLEWARE_HOME>/user_projects/domains/<DOMAIN_NAME>/servers/
<MANAGED_SERVER_NAME/cache
Copyright © 2013, Oracle and / or its affiliates. All rights reserved. http://www.oracle.com