Epm Install Troubleshooting 11121
Epm Install Troubleshooting 11121
Epm Install Troubleshooting 11121
Installation and Configuration Troubleshooting Guide RELEASE 11.1.2.1 Updated: July 2011
EPM System Installation and Configuration Troubleshooting Guide, 11.1.2.1 Copyright 2007, 2011, Oracle and/or its affiliates. All rights reserved. Authors: EPM Information Development Team Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited. The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing. If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable: U.S. GOVERNMENT RIGHTS: Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are "commercial computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, duplication, disclosure, modification, and adaptation shall be subject to the restrictions and license terms set forth in the applicable Government contract, and, to the extent applicable by the terms of the Government contract, the additional rights set forth in FAR 52.227-19, Commercial Computer Software License (December 2007). Oracle America, Inc., 500 Oracle Parkway, Redwood City, CA 94065. This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. This software or hardware and documentation may provide access to or information on content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services.
Contents
Documentation Accessibility . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9 Chapter 1. Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11 About Troubleshooting EPM System Products . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11 Assumed Knowledge . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11 Installation Documentation Roadmap . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12 Chapter 2. Troubleshooting Basics . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15 Meeting System Requirements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15 Reviewing the Installation Start Here . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15 Checking Release Compatibility . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16 Avoiding Port Conflicts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16 Reviewing Startup Dependencies . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16 Reviewing the Readme . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16 Using the Installation Guide . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16 Validating the Installation and Configuration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 Checking Logs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 Increasing Logging Levels in Enterprise Manager . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 Using My Oracle Support . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 Accessing Technical Support Resources . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 Chapter 3. Using EPM System Logs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 Ziplogs Utility . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 ODL Files . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 Configuration Files . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20 Log Files . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27 EPM System Installer Logs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28 Upgrade Logs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30 EPM System Configurator and System Logs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31 Foundation Services Logs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32 Essbase Logs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34 Reporting and Analysis Logs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 41 Financial Performance Management Applications Logs . . . . . . . . . . . . . . . . . . . . . . . 47
Contents
iii
Other Logging Formats . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 49 Log Location . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 49 Log File Size and System Performance . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 49 Integration Services Logs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 49 Business Rules Logs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 50 Planning Logs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 52 Performance Scorecard Logs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 53 Strategic Finance Logs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 54 Data Management Logs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 54 Lifecycle Management Logs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 58 Lifecycle Management Logs for Shared Services . . . . . . . . . . . . . . . . . . . . . . . . . . . . 58 Lifecycle Management Logs for Performance Management Architect . . . . . . . . . . . . . 59 Lifecycle Management Logs for Calculation Manager . . . . . . . . . . . . . . . . . . . . . . . . 59 Lifecycle Management Logs for Essbase . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 59 Lifecycle Management Logs for Reporting and Analysis . . . . . . . . . . . . . . . . . . . . . . . 59 Lifecycle Management Logs for Planning . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 60 Lifecycle Management Logs for Financial Management . . . . . . . . . . . . . . . . . . . . . . . 60 Central Inventory Logs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 60 Chapter 4. General Tips and Solutions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 63 Installation Tips and Troubleshooting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 63 EPM System Installer Shutdown . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 63 EPM System Installer Files on Client Machines . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 64 Oracle HTTP Server . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 64 Product Selection Panel . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 65 EPM System Installer Extraction on Solaris . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 66 EPM System Installer Startup Failure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 66 EPM System Installer Startup After MSI Installation . . . . . . . . . . . . . . . . . . . . . . . . . 66 EPM System Installer Freeze . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 67 Welcome Panel Issue . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 67 Reinstallation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 67 Upgrades . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 68 Configuration Tips and Solutions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 69 Distributed Environments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 69 Changing a Host Name . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 69 Java Heap Size Changes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 70 Product Databases . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 70 EPM System Configurator Startup Failure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 70 Web Server Configuration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 70
iv
Contents
Out-of-Memory Error with Multiple Web Application Deployments . . . . . . . . . . . . . 71 First-Time Configuration of the Shared Services Database . . . . . . . . . . . . . . . . . . . . . 71 Missing JAR Files . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 72 Configuration Failure and Error Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 72 Configuration Task Panel: Missing Products . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 73 Configuration Errors for Hidden Tasks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 73 Unavailable Database Configuration Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 73 Failure Deploying to Application Server Without Configuration Errors . . . . . . . . . . . 73 Moving Web Applications to a Single Domain . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 73 Reconfiguration Without Reinstallation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 74 Windows Integrated Authentication Support . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 74 Out-of-Memory Errors With Concurrent Users . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 75 Resolving Connection Failures and Restarting Services . . . . . . . . . . . . . . . . . . . . . . . . . . 75 Demo Certificate Message . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 75 WebLogic Administration Console Port Changes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 76 Antivirus Software . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 76 UNIX-Specific Issues . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 76 Slow Web Application Startup with TC2000 Solaris . . . . . . . . . . . . . . . . . . . . . . . . . . 76 Web Server Configuration Failure on AIX . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 76 JAR Files Not Found . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 77 Installation on Different UNIX Systems . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 78 Preparing JVM Error Message . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 78 Oracle Common Files Installation Failure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 78 Chapter 5. Foundation Services . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 79 Foundation Services Upgrades . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 79 EPM Workspace . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 80 Slow Logon . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 81 Missing Products or Product Menus in EPM Workspace . . . . . . . . . . . . . . . . . . . . . . 81 Truncated Menus . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 82 Oracle Business Intelligence Enterprise Edition Startup . . . . . . . . . . . . . . . . . . . . . . . 82 Flickering Icons in Internet Explorer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 82 404 Error Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 83 Performance Degradation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 83 Shared Services . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 83 Running Remote Diagnostics Agent . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 83 Shared Services Logon Failure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 84 High Availability of Active Directory . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 84 Product Registration Failure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 84
Contents
Security Lockout After Failed Logon Attempts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 85 User Name Search Failure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 85 Asterisks in User Names . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 85 AuditHandler Message . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 85 Audit Data Purges and Oracle Database Tablespace . . . . . . . . . . . . . . . . . . . . . . . . . . 86 Single Sign-On . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 86 Shared Services Registry Contents and Updates . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 86 User Directories and Provisioning . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 87 Startup and Access Issues . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 90 Product-Specific Issues . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 91 Lifecycle Management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 93 Migration Tip: Naming . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 93 Command Line Utility . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 93 Comparing Environments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 94 SSL Application Freeze or Name Mismatch Error . . . . . . . . . . . . . . . . . . . . . . . . . . . 94 Shared Services Launch Failure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 94 Lifecycle Management Migration Wizard Freeze . . . . . . . . . . . . . . . . . . . . . . . . . . . . 94 Export Failure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 95 Import File Format Not Supported Error Message . . . . . . . . . . . . . . . . . . . . . . . . . . 95 Lifecycle Management Diagnostics . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 95 Lifecycle Management and Reporting and Analysis . . . . . . . . . . . . . . . . . . . . . . . . . . 95 Lifecycle Management and Financial Management . . . . . . . . . . . . . . . . . . . . . . . . . . 96 Performance Management Architect . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 99 Installation Failure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 100 Integration with EPM Workspace . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 100 Performance Management Architect Logon Failure . . . . . . . . . . . . . . . . . . . . . . . . . 101 Security Rights Issue During Logon . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 101 Hyperion EPMA Server Service Startup . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 101 Performance Management Architect Task Display . . . . . . . . . . . . . . . . . . . . . . . . . 102 Performance Management Architect Dimension or Application Library Access . . . . . 102 Application Issues . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 104 Smart View . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 104 Calculation Manager . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 104 Chapter 6. Essbase . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 105 Essbase Maintenance Releases . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 105 Essbase and Provider Services Upgrades . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 106 Essbase Staging Tool . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 106 Role Updates . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 106
vi
Contents
Essbase Studio Configure Database Task . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 106 Clusters . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 107 Pre-upgrade Security File Backup . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 107 Essbase Server Startup . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 107 Connections to Essbase Clusters . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 108 Essbase Failover Issues . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 109 Client-Server Connection . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 109 OPMN Startup . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 109 OPMN Restart . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 110 Startup: Port Conflict . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 110 Integration Services: Connection to OLAP Metadata Catalog or External Data Source . . . 110 Essbase Studio Startup . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 111 Essbase Studio Logs Deleted . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 111 Chapter 7. Reporting and Analysis . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 113 Reporting and Analysis Upgrades . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 113 Reporting and Analysis Framework Web Application Startup . . . . . . . . . . . . . . . . . . . . 113 Interactive Reporting Studio . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 114 Essbase Loading Error . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 114 Faulty Oracle Net Connection . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 114 Failure Processing an Oracle Procedure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 114 Fonts Displayed Incorrectly . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 115 Financial Reporting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 115 Financial Reporting Print Server Startup . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 115 Runtime and ActiveX Errors . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 115 Web Analysis . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 116 Error Connecting to SAP BW . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 116 BEx Query Not Listed . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 116 Chapter 8. Financial Performance Management Applications . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 117 Financial Performance Management Application Upgrades . . . . . . . . . . . . . . . . . . . . . . 117 Financial Management Application Upgrades . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 117 Planning Applications Not Visible in EPM Workspace . . . . . . . . . . . . . . . . . . . . . . 118 Planning . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 118 Planning and Administration Services . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 118 Performance Issues . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 118 Multibyte Characters . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 119 Using Planning in a Non-English Environment . . . . . . . . . . . . . . . . . . . . . . . . . . . . 119 Financial Management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 120 Installation with FDM on Windows 64-Bit System . . . . . . . . . . . . . . . . . . . . . . . . . 120
Contents
vii
Accessing Financial Management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 121 Connection Issues . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 122 Rights Required for Installation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 125 Large Data or File Load Failure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 125 Sticky Server Attempts to Redirect User . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 125 EnableServerLocking Option . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 125 JRF WebServices Asynchronous Services . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 126 Financial Close Management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 126 General Financial Close Management Troubleshooting Tips . . . . . . . . . . . . . . . . . . 126 Enabling OWSM Logging . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 127 Financial Close Management Installation and Configuration Issues . . . . . . . . . . . . . 127 Financial Close Management Schedule Execution Issues . . . . . . . . . . . . . . . . . . . . . 133 Disclosure Management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 140 Chapter 9. Data Management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 143 Data Management Product Upgrades . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 143 FDM . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 143 Shared Services Registration Failure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 143 ERP Integrator Process Failure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 144 Configuration with Financial Management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 144 Oracle Client-Provider Database Connection Failure . . . . . . . . . . . . . . . . . . . . . . . 144 Database User ID or Password . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 145 User Authentication Failure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 145 Bulk Insert Failure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 145 Active-X Component Error . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 146 Application Creation Access Error . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 146 ERP Integrator . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 146 Inaccessible Data Rules . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 146 ERP Integrator Unavailable in EPM Workspace . . . . . . . . . . . . . . . . . . . . . . . . . . . 146 Data Relationship Management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 147 Web Client Access Failure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 147 Inaccessible Online Help . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 147 Failure To Initialize . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 148 JVM Creation Error . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 148 Invalid Classpath Root . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 149 Data Relationship Management Server Startup . . . . . . . . . . . . . . . . . . . . . . . . . . . . 149 Error Message During Upgrade . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 149 Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 151
viii
Contents
Documentation Accessibility
For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.
10
Documentation Accessibility
1
In This Chapter
Introduction
About Troubleshooting EPM System Products...........................................................11 Assumed Knowledge.......................................................................................11 Installation Documentation Roadmap ...................................................................12
Check the Oracle Documentation Library (http://www.oracle.com/technology/documentation/ epm.html) on Oracle Technology Network to see whether an updated version of this guide is available.
Assumed Knowledge
This guide is for administrators who install, configure, and manage EPM System products. It assumes the following knowledge:
l
Security and server administration skills Windows or UNIX administration skills Web application server administration skills A strong understanding of your organization's security infrastructure, including authentication providers such as Oracle Internet Directory, LDAP, or Microsoft Active Directory, and use of SSL A strong understanding of your organization's database and server environments A strong understanding of your organization's network environment and port usage
11
Documentation That You Need Related Documentation Oracle Hyperion Enterprise Performance Management System Certification Matrix (http://www.oracle.com/technology/software/products/ias/files/ fusion_certification.html) Oracle Hyperion Enterprise Performance Management System Installation Start Here Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide
Task Meeting system requirements and understanding release compatibility Planning the installation Installing, configuring, and deploying EPM System products Starting EPM System products Validating the installation Upgrading EPM System products
l l l
Oracle Hyperion Enterprise Performance Management System Security Administration Guide Oracle Hyperion Enterprise Performance Management System User and Role Security Guide
Table 2 lists the documents to consult for additional installation tasks that you might need to perform.
Table 2
Documentation That You Might Need Related Documentation Oracle Hyperion Enterprise Performance Management System Installation and Configuration Troubleshooting Guide Oracle Hyperion Enterprise Performance Management System Backup and Recovery Guide Oracle Hyperion Enterprise Performance Management System Lifecycle Management Guide Oracle Hyperion Enterprise Performance Management System High Availability and Disaster Recovery Guide
Task Troubleshooting installations Creating a backup of product and application data Migrating from one environment to another Clustering EPM System applications for high availability and disaster recovery
12
Introduction
Additional content is available in the White Papers Library at Oracle Enterprise Performance Management / Business Intelligence White papers. (http://www.oracle.com/technetwork/ middleware/bi-foundation/resource-library-090986.html).
13
14
Introduction
2
In This Chapter
Troubleshooting Basics
Meeting System Requirements ..........................................................................15 Reviewing the Installation Start Here.....................................................................15 Reviewing the Readme ....................................................................................16 Using the Installation Guide ..............................................................................16 Validating the Installation and Configuration............................................................17 Checking Logs ..............................................................................................17 Increasing Logging Levels in Enterprise Manager .......................................................18 Using My Oracle Support..................................................................................18 Accessing Technical Support Resources ................................................................18
Note: Perform the tasks described in this chapter before contacting Technical Support for
assistance.
15
16
Troubleshooting Basics
EPM System Products, and Chapter 4, Configuring EPM System Products, of the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide.
Use Oracle's Hyperion Enterprise Performance Management System Diagnostics to test the status of installed and configured EPM System components, diagnose problems, and assist in problem resolution. Run EPM System Diagnostics on each machine in the deployment. The results of the tests are saved in HTML format. For instructions, see Using EPM System Diagnistics in Chapter 9, Validating the Installation and Verifying Deployment, of the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide. Check for exceptions and errors in the installation logs to ensure that all necessary components were installed successfully. See Chapter 3, Using EPM System Logs. Check that all configuration tasks succeeded, as follows:
m
The Oracle's Hyperion Enterprise Performance Management System Configurator summary panel does not display failures or warnings. If error messages are displayed, check EPM_ORACLE_INSTANCE/diagnostics/logs/ config/configtool_summary.log.
Checking Logs
A fundamental troubleshooting technique is to enable and use debugging information in product log files. Use this technique before calling Technical Support so that you can provide specific information about your issue. See Chapter 3, Using EPM System Logs. Check log files in these locations:
l
MIDDLEWARE_HOME/user_projects/domains/domain name/servers/managed server name/logsWeb application runtime logs Central Inventory/logsOracle Universal Installer (OUI) and OPatch logs
EPM_ORACLE_INSTANCE/diagnostics/logs/upgradesUpgrade logs
17
Oracle Configuration Manager, which EPM System installations include in the EPM Oracle home directory, collects information about your Oracle software installation and configuration and uploads the information to My Oracle Support. The information collected by Oracle Configuration Manager speeds resolution of problems and enables My Oracle Support to tailor content for your configuration. Oracle recommends that you adjust the default sources for your knowledge base searches, if necessary, to include documentation for your Hyperion products. For more information, click Getting Started on the My Oracle Support home page.
18
Troubleshooting Basics
3
In This Chapter
Ziplogs Utility ...............................................................................................19 ODL Files....................................................................................................19 Other Logging Formats.....................................................................................49 Lifecycle Management Logs...............................................................................58 Central Inventory Logs .....................................................................................60
Most EPM System products use the Oracle Diagnostic Logging framework (ODL) for logging purposes. EPM System Installer and EPM System Configurator create ODL files for all products. Products not using ODL leave these ODL files empty and write their logs to different file formats. For products not using ODL, see Other Logging Formats on page 49. Oracle Hyperion Enterprise Performance Management System Lifecycle Management uses ODL and other formats. See Lifecycle Management Logs on page 58.
Ziplogs Utility
Before creating a service request (SR) about an installation or configuration issue, run the utility ziplogs.bat (Windows) or ziplogs.sh (UNIX) in EPM_ORACLE_INSTANCE/bin. When you create the SR, attach the output from the script, which is saved to EPM_ORACLE_INSTANCE/diagnostics/ziplogs. The output is a zipped collection of logs, configuration files, and other information that can help Support to resolve installation and configuration issues.
ODL Files
ODL provides plug-in components that complement the standard Java framework to automatically integrate log data with Oracle log analysis tools. In the ODL framework, log files are formatted as text documents. Another key benefit of ODL is that log file rotation is supported. ODL consists of two file types:
l
Ziplogs Utility
19
Configuration Files
Subtopics
l l l l
Structure of Configuration Files Modifying Configuration Files Location of Configuration Files Changing the EPM Workspace Logging Level in WebLogic Administration Server Console
ODL uses a configuration file to manage and limit the logging information for EPM System components. Each configuration file contains options for log file location, size, rotation, logging level, and so on. For options, see Configuration File Properties on page 21.
20
<property name="format" value="ODL-Text" /> <property name="useThreadName" value="true" /> <property name="maxFileSize" value="5242880" /> <property name="maxLogSize" value="52428800" /> <property name="encoding" value="UTF-8" /> </log_handler> - <log_handler name="em-trc-handler" class="oracle.core.ojdl.logging.ODLHandlerFactory" level="TRACE:32"> <property name="logreader:" value="off" /> <property name="path" value="${domain.home}/servers/${weblogic.Name}/sysman/log/ emoms.trc" /> <property name="format" value="ODL-Text" /> <property name="useThreadName" value="true" /> <property name="locale" value="en" /> <property name="maxFileSize" value="5242880" /> <property name="maxLogSize" value="52428800" /> <property name="encoding" value="UTF-8" /> </log_handler> ... ... <loggers> - <logger name="" level="WARNING:1"> <handler name="odl-handler" /> <handler name="wls-domain" /> <handler name="console-handler" /> </logger> <logger name="oracle" level="NOTIFICATION:1" /> <logger name="oracle.adf" /> <logger name="oracle.adf.desktopintegration" /> <logger name="oracle.adf.faces" /> <logger name="oracle.adf.controller" /> <logger name="oracle.adfinternal" /> <logger name="oracle.adfinternal.controller" /> <logger name="oracle.jbo" /> ... ...
Configuration Properties Description Log path Format to use. The value must be ODL-Text The maximum size in bytes for each log file When the main log file reaches the given size, it triggers a log rotation, where the main log file is archived and a new log file is created.
Property Name
path format maxFileSize
maxLogSize
The maximum size in bytes for the entire log Older archive files are deleted to keep the total log size under the given limit.
ODL Files
21
Property Name
rotationFrequency
Description The frequency, in minutes, for rotating the logs The value must be a number (minutes), or hourly, daily, or weekly (values are not case-sensitive).
baseRotationTime
The base time for time-based log rotation The log is rotated every rotationFrequency minutes from the base time. The default base time is January 1, 1970, UTC. The time must be in one of these formats:
l l l l
where TZ is the time one indicator and can be either Z, indicating UTC, or specify the time zone offset in the format +/-HH:mmm If the time format does not specify a time zone, the local time zone is used.
retentionPeriod
How long older log file should be kept Files that are older than the given period are deleted. Files are deleted only when there is a log rotation; no background thread deletes log files. As a result, files may not be deleted for some time after the retention period expires. The value must be a number (minutes), or day, week, month (30 days) or year (values are not case-sensitive).
encoding
The name of the character encoding to use For this release, XML files must be UTF-8 encoded to handle extended characters. The default is
<?xml version="1.0" encoding="UTF-8" ?>
A comma-separated list of supplemental attribute names, which can be added to each log message The attribute value must be defined in class ExecutionContext.
useSourceClassAndMethod
Whether the Java source class and method name should be added to each log message The value is a Level name. Messages of a given level or lower include the source class and method name. The constants true and false are also accepted as aliases for OFF and ALL. The default value is TRACE:1 (FINE).
useDefaultAttributes
Whether default attribute values should be added to each log message The default attributes that can be assigned are HOST_ID, HOST_NWADDR and USER_ID. The value should be true or false. The default value is true for the ODL-XML format and false for the ODL-Text format.
includeMessageArguments
Whether message arguments should be included with formatted log messages that also have a message ID The value should be true or false. The default value is true in most cases true is the correct value.
22
Property Name
useThreadName
Description Sets the useThreadName flag, which flags controls if the handler attempts to log the real thread name instead of the threadID provided by the java.util.logging.LogRecord. If the flag is true, the handler attempts to log the real thread name. In some cases, the handler may not be able to determine the real thread name, in which case it will log the threadID. The default value is true. The useRealThreadId flag, which flags controls if the handler attempts to log the real thread ID instead of the threadID provided by the java.util.logging.LogRecord If the flag is true, the handler will attempt to log the real thread ID. In some cases, the handler may not be able to determine the real thread name, in which case it will log the threadID. The default value is false. Logging the real Thread ID is mutually exclusive with the useThreadName property. If useThreadName is true, the value of the useRealThreadId property is ignored.
useRealThreadId
locale
Default Locale override for localizing messages The default value is the default Locale.
keepOpen
The keepOpen flag setting In most cases you should use the default value. The value should be true or false. If the flag is set to true, the main log file is kept open all times. If the flag is set to false, the main log file is open and closed upon each log operation. The default value is true.
deleteFiles
The deleteFiles flag setting The value should be true or false. This flag determines whether archive files can be deleted when the total log size reaches the maximum limit. In most cases, the default value for the flag is true, which means that old files can be deleted. In rare use cases, in which archive files should not be deleted, this flag can be set to false. Note: If deleteFiles is set to false, and a maxLogSize limit is set, messages are not logged after the log size reaches the specified maxLogSize limit.
autoFlushLevel
The level setting for autoflushing The ODLHandler allows log records to be buffered, but it automatically flushes the buffer when it gets a log record with level equal to or higher than the specified autoFlush level. The default value is NOTIFICATION:1.
addJvmNumber
The JVM number added to the log file name The JVM number is defined by system property oracle.process.index. If the system property is not set, this option is ignored.
applicationContextProvider
The name of a class that implements the ApplicationContext interface The class must have a default constructor. The special value disabled can be used to disable logging of application name. The default application context provider is platform-specific; in most cases you need not set this property.
userContextProvider
The name of a class that implements the UserContext interface The class must have a default constructor. The special value disabled can be used to disable logging of the user name. The default user context provider is platform-specific; in most cases you need not set this property.
ODL Files
23
Message Types
Message type is the standard ODL terminology for a log level. Message types are controlled from the configuration file in loggers, and the recommendation is to set a lower message type as the default, to allow finer control.
Table 4
Message Types Description A serious problem that requires immediate attention from the System Administrator and is not caused by a product bug. A potential problem that the System Administrator should review A major lifecycle event such as the activation or deactivation of a primary subcomponent or feature Trace or debug information for events, such as public API entry/exit points. The messages should be understandable to those who do not know internal implementation details. May be used when the type is unknown
Tip: Administrators can change the EPM Workspace logging level using WebLogic
Administration Console without modifying the configuration file. See Changing the EPM Workspace Logging Level in WebLogic Administration Server Console on page 27.
For example, for Oracle Hyperion Profitability and Cost Management, Fusion Edition, you might navigate to this default location:
MIDDLEWARE_HOME/user_projects/domains/domain name/config/fmwconfig/ servers/managed server name/logging.xml
2
24
Locate the following line in logging.xml, and modify the line to reflect the appropriate logging level, as follows:
<logger name=oracle.EPMPCM level=NOTIFICATION:1 useParentHandlers=false>
to
<logger name=oracle.EPMPCM level=TRACE:32 useParentHandlers=false>
4 5
Save logging.xml with the modified message type. Restart Profitability and Cost Management.
Location of ODL Product Configuration Files Component EPM System Configurator Shared Services and EPM Workspace Configuration File Location
EPM_ORACLE_HOME/common/config/11.1.2.1/configTool-logging. xml
Shared Services for LCM Oracle Hyperion EPM Architect, Fusion Edition Dimension Server Performance Management Architect Data Synchronizer Performance Management Architect Web Application Hyperion Calculation Manager Oracle Hyperion Smart View for Office, Fusion Edition
EPM_ORACLE_INSTANCE/config/FoundationServices/logging.xml EPM_ORACLE_INSTANCE/config/EPMA/DimensionServer/logging.xml
MIDDLEWARE_HOME/user_projects/domains/domain name/config/ fmwconfig/servers/managed server name/logging.xml MIDDLEWARE_HOME/user_projects/domains/domain name/config/ fmwconfig/servers/managed server name/logging.xml MIDDLEWARE_HOME/user_projects/domains/domain name/config/ fmwconfig/servers/managed server name/logging.xml Smart View is a client-side application. The name and location of the file where it logs events, errors, and other information are specified as options in Smart View. For more information about Smart View logging options, see the Oracle Hyperion Smart View for Office User's Guide.
EPM_ORACLE_INSTANCE/EssbaseServer/essbaseserver1/bin/ logging.xml
Oracle Essbase1
Essbase Server Oracle Essbase Administration Services Oracle Hyperion Provider Services
MIDDLEWARE_HOME/user_projects/domains/domain name/config/ fmwconfig/servers/managed server name/logging.xml MIDDLEWARE_HOME/user_projects/domains/domain name/config/ fmwconfig/servers/managed server name/logging.xml
ODL Files
25
Product Family
Oracle's Hyperion Reporting and Analysis Framework Reporting and Analysis Framework Services Reporting and Analysis Framework Agent Reporting and Analysis Framework Job Utilities logging configuration for Calendar Manager Reporting and Analysis Framework SDK Reporting and Analysis Framework Migration Utility Oracle's Hyperion Interactive Reporting Oracle Hyperion Financial Reporting, Fusion Edition
logging.xml in MIDDLEWARE_HOME/user_projects/domains/ domain name/config/fmwconfig/servers/managed server name/ logging.xml printserverlogging.xml in EPM_ORACLE_HOME/products/ financialreporting/lib clientlogging.xml in EPM_ORACLE_HOME/products/ financialreporting/lib
Oracle's Hyperion Web Analysis Financial Performance Management Applications Oracle Hyperion Financial Management, Fusion Edition
MIDDLEWARE_HOME/user_projects/domains/domain name/config/ fmwconfig/servers/managed server name/logging.xml MIDDLEWARE_HOME/user_projects/domains/domain name/config/ fmwconfig/servers/managed server name/logging.xml
Profitability and Cost Management Oracle Hyperion Disclosure Management Oracle SOA Suite Oracle Hyperion Financial Close Management
1Oracle
MIDDLEWARE_HOME/user_projects/domains/domain name/config/ fmwconfig/servers/managed server name/logging.xml MIDDLEWARE_HOME/user_projects/domains/domain name/config/ fmwconfig/servers/managed server name/logging.xml MIDDLEWARE_HOME/user_projects/domains/domain name/config/ fmwconfig/servers/managed server name/logging.xml MIDDLEWARE_HOME/user_projects/domains/domain name/config/ fmwconfig/servers/managed server name/logging.xml
Essbase Integration Services do not use ODL formatting. See Other Logging Formats on page 49
26
Changing the EPM Workspace Logging Level in WebLogic Administration Server Console
Administrators can use WebLogic Administration Console to change the EPM Workspace logging level and some other log-related attributes without modifying logging.xml and without restarting the system.
To change the EPM Workspace logging level using WebLogic Administration Console:
1 2 3 4
Click Lock & Edit. Select EPMSystem(Domain), then Environment, then Servers. Click the server name, then click the Logging tab. Scroll down to expand the Advanced link, where you can set the logging level.
Log Files
Subtopics
l l l
Common Log File Naming Log Messages File Format Information Needed by Oracle Support Services
Log Message Format Description Date and time when the message was generated, adjusted for time difference between the host where the message was generated and the host of the common repository. This field is set only when the log message is written to a central repository and should not be set by components. Example: [2010-01-22T05:23:31.755-08:00] The component that originated the message. Example: [FoundationServices0].
Component ID
ODL Files
27
Description Defined message types: ERROR, WARNING, NOTIFICATION, and TRACE. The value UNKNOWN may be used when the type is unknown.
l
ERRORA serious problem that requires immediate attention from the System Administrator and is not caused by a bug in the product. WARNINGA potential problem that should be reviewed by the System Administrator. NOTIFICATIONA major lifecycle event such as the activation or deactivation of a primary subcomponent or feature. TRACETrace or debug information for events that are meaningful to users, such as public API entry/exit points. The messages should be understandable by those who do not know internal implementation details. UNKNOWN (may be used when the type is unknown).
l l
A short identifier that uniquely identifies the message. Example: [EPMWKSP-000001] An identifier of the module that originated the message. The value is component specific. Example: [Initialization] Execution context ID helps connect multiple log files. Example: [ecid: 0000IPMCrhW17ic5PjWByd1BMQPg000002, 0] Actual log message
EPM System Installation Log Files Contents Common Component files activity; for example, ODBC Oracle Configuration Manager activity Activity of Oracle HTTP Server, which is silently installed from an embedded installer Oracle Universal Installer information about Oracle HTTP Server installation
File Name
common-install.log common-ocm-install.log common-ohs-install.log
common-ohs-oui-out.log
28
File Name
common-product-install.log
Contents Product common component files activity; for example, ADM drivers, CRS utility Static content files (for example, Help) for each product on the Web server machine Embedded WebLogic installation activity Messages for .Net install Messages for .Net registration Error log for installer step to preserve old version of Oracle's Hyperion Business Rules Client.properties file Trace log for installer step to preserve old version of Business RulesClient.properties file Error log for registering HFMProfielReader.dll Trace log for registering HFMProfileReader.dll Error log for registering ZLib.dll Trace log for registering ZLib.dll Error log for setting cacls on the file transfer folder Trace log for setting cacls on the file transfer folder Error log for setting cacls for lcm service folder Trace log for setting cacls for lcm service folder Error log for each client DLL registration Trace log for each client DLL registration Error log for each ADM client DLL registration Trace log for each ADM client DLL registration Error log for each client DLL registration Trace log for each client DLL registration Error log for each common DLL registration Trace log for each common DLL registration Error log for each server DLL registration Error log for registering winhttp.dll Trace log for registering winhttp.dll
common-staticcontent-install.log
easconsole-move-hbrcfile-frtemp-stdout.log
epma-register-profilereaderdll-stderr.log epma-register-profilereaderdll-stdout.log epma-register-zlibdll-stderr.log epma-register-zlibdll-stdout.log hfm-cacls-filetransfer-stderr.log hfm-cacls-filetransfer-stdout.log hfm-cacls-lcmservice-stderr.log hfm-cacls-lcmservice-stdout.log hfm-registerclientdlls.log hfm-registercommondlls.log hfm-registerdlladmclient-stderr.log hfm-registerdlladmclient-stdout.log hfm-registerdllclient-stderr.log hfm-registerdllclient-stdout.log hfm-registerdllcommon-stderr.log hfm-registerdllcommon-stdout.log hfm-registerserverdlls.log hfm-regWinHttpErr.log hfm-regWinHttpOut.log
ODL Files
29
File Name
hfmsvcs-regAsyncCallback-stderr.log hfmsvcs-regAsyncCallback-stdout.log hfm-updatereg-stderr.log hfm-updatereg-stdout.log install-ocm-output.log installTool-install-DDD-MM.DD.YYYY-TIME.log installTool-install-stderr.log installTool-install-stdout.log. PRODUCTinstall.log
Contents Error log for registering AsyncCallback.dll Trace log for registering AsyncCallback.dll Error log for creating Financial Management Windows registry entries Trace log for creating Financial Management Windows registry entries Oracle Configuration Manager file information Main log written by EPM System Installer to log user activity Errors filtered from console output Console output Information about whether a product assembly installation fails Each assembly has a log file. Results of checks that EPM System Installer performs and displays in a command window before the Welcome screen opens Error log for registering font files Trace log for registering font files WebLogic install-time log, errors WebLogic install-time log, complete log
Upgrade Logs
In general, when you upgrade to Release 11.1.2.1 from release 9.2.1x, 9.3.3x, or 11.1.1.3x , logs are created in EPM_ORACLE_INSTANCE/diagnostics/logs/upgrades. Upgrade log files are named product-upgrade.log; for example, planning-upgrade.log or epmaupgrade.log. In general, upgrade logging configuration information is stored in EPM_ORACLE_HOME/ upgrades/product/*.xml. For example, upgrade logging configuration information for Reporting and Analysis is stored in EPM_ORACLE_HOME/upgrades/ReportingAnalysis/ logging_raf_upgrade.xml by default. The file name varies by product. Exceptions:
l
Shared ServicesThe location of log files created by the Migration Utility is set in
EPM_ORACLE_HOME/upgrades/foundation/conf/hssupgrade.properties. To set the location, open hssupgrade.properties in a text editor and specify the path in the hss.log.folder= parameter.
Provider ServicesThe Provider Services upgrade utility uses ODL for logging. You can set the path for the Provider Services upgrade log file in the logging.xml file, in
30
Financial ManagementYou create a log file for Financial Management application upgrades when you run the Financial Management Application Upgrade Utility from EPM System Configurator. You can also select several logging and error handling options. See Chapter 5, Upgrading EPM System Products, in the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide.
configtool.logConfiguration task output and warning messages configtool-http-ant.logTrace from ant code executed during
ConfigTool-stdout.logConsole output Configtool-appdeployment.logTrace of deployment steps configtool_summary.logSummary status about pass/fail tasks EssbaseExternalizationTask.logTrace information for the
ocm-config.logOracle Configuration Manager configuration log registry.logTrace of Oracle's Hyperion Shared Services Registry
execution Note: A file name validation-n.log indicates that the log has rolled over because of size limits
l
ODL Files
31
Log Type Application Server logs For Oracle WebLogic Server installed with EPM System Installer. For WebLogic Server installed outside EPM System Installer, see the WebLogic Server documentation for information about logs. Web server logsFor Oracle HTTP Server installed with EPM System Installer. For Web servers installed outside EPM System Installer, see vendor documentation for information about logs. Start and stop logs
Log Location WebLogic Server service, error, and console logs: EPM_
ORACLE_INSTANCE/ diagnostics/logs/
Name and Contents See the product folders for the specific logs.
PRODUCT
access_log and access_log.numberWebLogic-generated log file for a managed server console~OHS~1.logOracle HTTP Server-generated log file, console
output
l
PRODUCT-syserr.log and PRODUCT-out.logWindows service startup logs; trace of messages through startup
MIDDLEWARE_HOME/user_
projects/domains/ domain name/servers/ managed server name/ logs
registry.logRegistry activity
Security logs
SharedServices_SecurityClient.logNative Directory
WebLogic logs
MIDDLEWARE_HOME/user_
projects/domains/ domain name/servers/ managed server name/ logs
Services.
32
Table 9
Shared Services:
MIDDLEWARE_HOME/user_ projects/domains/domain name/servers/managed server name/logs
l l
SharedServices_Admin.logApplications Groups management activity SharedServices_Audit.logAudit server errors while reading/writing audit
SharedServices_Audit_Client.logInformation about the audit client SharedServices_CMSClient.logMetadata Service client activity SharedServices_Hub.logShared Services context listener and initialization activity SharedServices_LCM.logLifecycle Management activity SharedServices_Registry.logShared Services Registry activity SharedServices_Security.logUser management, provisioning, authentication,
SharedServices_TaskFlow.logInformation about Taskflows Workspace.logEPM Workspace error and informational messages Framework.log:
m m m m
EPM Workspace:
MIDDLEWARE_HOME/user_ projects/domains/domain name/servers/managed server name/logs
l l
EPM System common user interface framework error and informational messages Miscellaneous messages; for example, locale detection Messages regarding BPMUI configuration files or registry settings Any errors due to invalid configuration files; for example: corrupt BpmServer.
properties or registry.
BPMUI security messages, including CSS initialization, logon/logout logs from the Web application, and CSS authentication error messages
Note: The framework.log file exists only exists only for Foundation Services for Performance Management Architect for Reporting and Analysis. Smart View Smart View is a client-side application. The name and location of the file where it logs events, errors, and other information are specified as options in Smart View. For more information about Smart View logging options, see the Oracle Hyperion Smart View for Office User's Guide.
l
DimensionServer.logActivities from Performance Management Architect Dimension Server; for example, all export activities and dimension manipulation
ODL Files
33
epma.logLogging information from Web reports EpmaWebReports0.logPerformance Management Architect Web-tier activities
Calculation Manager:
MIDDLEWARE_HOME/user_ projects/domains/domain name/servers/managed server name/logs
Essbase servers
l l
CalcManager.logGenerates all Calculation Manager Web tier activities CalcMgr0.logGenerates all Calculation Manager activities
Essbase Logs
The following table contains information about Essbase product family logs that use ODL format:
l
Integration Services does not use ODL. See Integration Services Logs on page 49.
Note: For more information about analyzing Essbase logs, see the Oracle Essbase Database
Administrator's Guide.
34
Table 10
Data load log: dataload_ODL.err Data load and dimension build errors
Successfully completed spreadsheet update transactions. These are SSAUDIT log files; file name and location are specified through an essbase.cfg setting. See Monitoring Data, Applications, and Databases in the Oracle Essbase Database Administrator's Guide and the Essbase Technical Reference.
l
Exception log: log0000x.xcp Errors that result when Essbase Server stops abnormally
Essbase Server Lease Manager log: leasemanager_server_HOSTNAME.log Essbase Server Lease Manager information
Essbase Agent Lease Manager log: leasemanager_essbase_HOSTNAME.log Agent Lease Manager information
For more information on how to use these logs to troubleshoot Essbase failover problems, see Essbase Failover Logs on page 37. Essbase Studio upgrade log: EPM_
ORACLE_ INSTANCE/ diagnostics/ logs/upgrades
essStaging.logErrors that result when the staging tool (essStage.bat | sh prepares configuration and
security information, data, and applications for file transfer during an upgrade. For more information about the stating tool, see Preparing Essbase Data for Upgrading in Chapter 5, Upgrading EPM System Products, in the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide.
ODL Files
35
an upgrade. For more information about Essbase Server rehosting, see Rehosting Essbase Server in Appendix B, Rehosting Foundation Services Web Application and Essbase Server, of the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide.
Security_client.logTracking of EPM System component and CSS communications with native provider.
Also records the JDBC configuration from registry in this log file for any binds with native providers.
OPMN server log: /OPMN/opmn/opmn.log Diagnostic information that the OPMN server prints for various operations performed against a managed component (Essbase). This log contains information about when Essbase starts, stops, and how many retry attempts are made to start and stop.
Essbase console log: /OPMN/opmn/ console~ESSBASE_CLUSTER_NAME~ESSBASE_PROCESS_TYPE~AGENT~1.LOG All console messages are directed to a file that is called the "console" output file for a managed process, in this case, Essbase. Essbase often writes the same log file entries to Essbase.log and stdout; therefore there might be duplicate entries in Essbase.log and this console log file.
For more information on how to use these logs to troubleshoot Essbase failover problems, see Essbase Failover Logs on page 37. Essbase Plugin logs:
MIDDLEWARE_ HOME/user_ projects/ domains/domain name/servers/ managed server name/logs/ essbase/lcm essbaseplugin_ODL.logLog statements related to the LCM artifact listing
36
Note: To enable console logging, in admincon.lax, set the Java option parameter DEAS_ CONSOLE_LOG. to True. Essbase Studio:
EPM_ORACLE_ INSTANCE/ diagnostics/ logs/esbstudio server.logEssbase Studio server activity
Provider Services:
MIDDLEWARE_ HOME/user_ projects/ domains/domain name/servers/ managed server name/logs
l l
Essbase Server log Essbase Server Lease Manager log Essbase Agent Lease Manager log
ODL Files
37
OPMN server log Essbase console log OPMN Forward Ping log
Sample Scenario
The relational database that holds the lease information for Essbase is shut down. Two nodes are running in failover mode. Node behavior that causes a failure in this scenario: 1. Node 1 sequence of events: a. OPMN attempts a number of times to start Essbase on Node 1:
<start timeout="600" retry="2"/> // This is the default//
b. Because the Lease database is down, Essbase fails to start on Node 1. 2. Node two sequence of events: a. To achieve failover, OPMN attempts to start Essbase on Node 2 for the configured number of startup attempts.
Note: OPMN attempts to start Essbase 3 times (since the configuration is symmetrical
between the two nodes, the number of attempts will also be three on Node 2). b. Essbase will stay down on both Node 1 and Node 2. To find out why OPMN cannot start Essbase, analyze these logs:
l
Essbase is unable to get the database lease. The Essbase Agent attempts up to six times (Six times is the defaultattempts once, then attempts five more times) and after that, Essbase stops attempting and self-terminates. These lease manager log entries appear on both nodes of the cluster as OPMN attempts to start Essbase on both nodes. Chain these four logs with a timeline to understand the root of the issue. A sample time sequence of these events: 1. A request to start Essbase is issued at 2010-03-26T03:32:09 2. OPMN attempts to start Essbase at 2010-03-26T03:32:11 (first time) 3. Essbase starts up at Fri Mar 26 03:32:12 2010 (first time) 4. Normal bootstrap continues but then it appears to have stopped sometime between Fri Mar 26 03:32:12 2010 and Fri Mar 26 03:32:26 2010 5. Lease Manager, running within the Agent, attempts to acquire the Agent lease at 2010-03-26T03:32:12 (first time) 6. Lease Manager continues to attempt the acquisition up to 6 times and finally terminates the Agent at 2010-03-26T03:32:22
38
The following are sample snippets from logs that you check to diagnose the issue in the above scenario:
Note: The following snippets show only the relevant portions of these logs. Line items in bold
indicate the multiple OPMN attempts to start Essbase that fail. 1. Console output from OPMNCTL:
opmnctl startproc: starting opmn managed processes... opmn id=adc2170731.us.oracle.com:8001 0 of 1 processes started. ias-instance id=instance1 ias-component/process-type/process-set: <EssbaseClusterName>/EssbaseAgent/AGENT/ Error --> Process (index=0,uid=0,pid=0) Service fail over start failure Log: none --> Process (index=1,uid=1051800837,pid=12982) failed to start a managed process after the maximum retry limit Process terminated. Log: EPM_ORACLE_HOME/product/11.1.1/webtierIH/instances/instance1/diagnostics/logs/ OPMN/opmn/console~<EssbaseClusterName>~EssbaseAgent~AGENT~1.log
.... (product banner and startup info which abruptly stops after some time) ... 3. Log 2: opmn.log:
[2010-03-26T03:32:09][opmn][TRACE:1][667][OPMN][code:pm-requests]Request 5 Started. Command: /start?process-type=EssbaseAgent [2010-03-26T03:32:11][opmn][TRACE:1][662][OPMN][code:pm-process]Starting Process: <EssbaseClusterName>1~EssbaseAgent~AGENT~1 (1051800837:0) [2010-03-26T03:32:25][opmn][TRACE:1][662][OPMN][code:pm-process]Starting Process: <EssbaseClusterName>~EssbaseAgent~AGENT~1 (1051800837:0) [2010-03-26T03:32:39][opmn][TRACE:1][662][OPMN][code:pm-process]Starting Process: <EssbaseClusterName>~EssbaseAgent~AGENT~1 (1051800837:0) [2010-03-26T03:32:53][opmn][TRACE:1][][OPMN][code:pm-fos]Service-failover:
ODL Files
39
<ias-instance id="instance1"> <ias-component id="<EssbaseClusterName>"> <process-type id="EssbaseAgent"> <process-set id="AGENT"> <process id="0" pid="0" status="_fail" index="0" log="" operation="request" result="failure">
40
Reporting and Analysis Framework Logs Financial Reporting Logs Web Analysis Logs Interactive Reporting Logs
Reporting and Analysis Framework Log Files Log Name and Description
l
eiengine.logLog messages of EIEngine utility (export/import utility) logwriter_messages_${module}.logLog file with inside log Reporting and Analysis
Framework services log files. These files contain RAF services log messages.
m
Framework services. It contains the information about started Reporting and Analysis Framework services, some stdout console logs.
l
logging information
l l l l
JobUtilities.logJob Utilities activities for Calendar Manager migrator.logMigration activities /MigrationUtility/migration_systime}.logMigration utility logs /SDK/sdk.logSoftware Development Kit log
ODL Files
41
RaFramework0.logReporting and Analysis Framework Web application server logs RaFramework_Bpmui.log - Miscellaneous messages; for example, locale detection RaFramework_AdministrationServlet.logReporting and Analysis Framework Web
RaFramework_Changemgmt.logImpact Manager logs RaFramework_CommonClient.logReporting and Analysis Framework Web application logs
RaFramework_Portlets.log Portlet infrastructure messages RaFramework_Search.log Search-related messages RaFramework_WebServices.log Web services-related messages RaFramework_configuration_messages.log Configuration messages RaFramework_iHTMLServlet.logReporting and Analysis Framework Web application logs
42
CommonServices DataAccessService EventService GSM HarvesterService IntelligenceService IRJobService IRServiceHelper JobService LoggingService LSM PublisherService RepositoryService SearchIndexing SearchKeywordProvider SearchMonitor SessionManager ServiceBroker TransformerService UsageService
COMPONENT_NAMELoggingBackup.logContains logging messages when Logging Service is unavailable (for example, rafservicesLoggingBackup.log) configuration_messages.logContains basic environment and configuration
information
l
ODL Files
By default, Reporting and Analysis Framework services and Interactive Reporting services are configured to use remote logging: When you configure a machine for remote logging, the log files are not created on the local file system but are created on the machine where the logging service is running. You can change this default configuration and choose to log messages locally. Interactive Reporting Log Service uses remote logging by default. If a component is configured for local logging, then Logging Service is not used by that component. Changing From Remote to Local Logging
to
com.brio.one.mgmt.logging.LocalODLHandlerFactory
Logs folder location: path Maximum file size: maxFileSize Maximum log size: maxLogSize
Backup Files Used for Remote Logging If the Logging service fails, logging service log messages are written to backup files at the same location as the log files. Backup file names syntax:
COMPONENT_NAMELoggingBackup.log
When the remote login approach is used, log messages are backed up in
EPM_ORACLE_INSTANCE/diagnostics/logs/ReportingAnalysis/ rafservicesLoggingBackup.log.
After a failure, when the logging service becomes available, the data from the backup files are transferred to the appropriate log files on the machine where the logging service is running. The backup files are then removed.
44
Dynamically Changing of Logger Levels To dynamically change the logger levels for Reporting and Analysis Framework services:
1 2 3 4
In EPM Workspace, click Navigate, then Administer, then Reporting and Analysis, and then Services. Open the Properties dialog box for Reporting and Analysis Framework or the Interactive Reporting services Logs panel. Add, (for Reporting and Analysis Framework), remove (for custom loggers for Reporting and Analysis Framework), or modify logger levels. To apply the changes, in the context menu, click Refresh log Configuration. The changes are quickly applied.
To dynamically change the logger levels for Reporting and Analysis Framework Web
application:
1 2 3 4
Open EPM_ORACLE_INSTANCE/ReportingAnalysis/RAFrameworkWebapp/WEB-INF Create logging.properties. Add the required loggers with specific levels. Syntax for loggers:
oracle.EPMRAF.[logger name].level=[logger level]
FRAccess.logMonitors security access to Financial Reporting FRPerformance.logMonitors the performance of the Financial Reporting Server and
associated components
l l l l l l
FRClientAccess.log:Monitors Financial Reporting studio client security access FRClientLogging.logMonitors Financial Reporting studio client activities FRClientPerformance.logMonitors Financial Reporting studio client performance FRPrintLogging.logMonitors the Print Server activities FRPrintAccess.logMonitors Print Server access activities FRPrintPerformance.logMonitors Print Server performance
ODL Files
45
components
l
Adm.logADM APIs activity AdmAccess.logADM APIs activity AdmAps.logADM APIs activity AdmPerformance.logADM APIs activity WebAnalysis0.logWeb tier activity. This log is not ODL compliant. WebAnalysis.logWeb Analysis activity WebAnalysisAtf.logATF part of Oracle's Hyperion Web Analysis application WebAnalysisAudit.logAudit information
Remote and Local Logging on page 43 Backup Files Used for Remote Logging on page 44 Dynamically Changing of Logger Levels on page 45
Interactive Reporting Logs Log Name and Description
l l
Table 13
information
l
46
Changing Interactive Reporting Logging Levels To change Interactive Reporting logging levels:
1 2 3 4
In EPM Workspace, select Navigate, then Administrator, then Reporting and Analysis, and then Services. Open the Properties dialog box for either Reporting and Analysis Framework or Interactive Reporting services, and then select the Log panel. Add, (for Reporting and Analysis Framework), remove (for custom loggers for Reporting and Analysis Framework), or modify logger levels. In the context menu, click Refresh Log Configuration. The changes are applied shortly.
The service starts with local logging mode and the log files (*_das.log, *_BIService.log or *_IRJob.log) are found in EPM_ORACLE_INSTANCE/
diagnostics/logs/ReportingAnalysis
ODL Files
47
Table 14
hfm.odl.logFinancial Management core activity HsvEventLog.logFinancial Management activity InteropJava.logFinancial Management interop activity
useful for viewing logs Tip: You can navigate to the Financial Management log viewer from the Start menu: Select Programs, then EPM System, then Financial Management, and then Utilities. Financial Management Web services logs:
MIDDLEWARE_HOME/user_projects/domains/ domain name/servers/managed server name/ logs/hfm
Close Management For information about Financial Management Web services, see Financial Management Enable Web Services in Chapter 4, Configuring EPM System Products, of the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide.
HFMApplicationUpgrade.logApplication upgrade activity
Edition activity
activity
l l l l l l l
DiscMan.logDisclosure Management activity DiscManAuditService.logAudit service activity DiscManMappingTool.logMapping tool activity DiscManReportService.logReport service activity DiscManRepository.logRepository activity DiscManRepositoryService.logRepository services activity DiscManSessionService.logSession service activity FinancialClose0.logWeb tier activity FinancialClose.logFinancial Close Management activity
l l
l l
48
Log Location Log File Size and System Performance Integration Services Logs Business Rules Logs Planning Logs Performance Scorecard Logs Strategic Finance Logs Data Management Logs
This section describes the logs and products that do not use ODL formatting for logging. EPM System Installer and Configurator create ODL files for all products. Products not using ODL leave these ODL files empty and write their logs to a different file format.
Log Location
Logs that do not follow the ODL formatting are written to EPM_ORACLE_HOME/ diagnostics/logs/COMPONENT_NAME.
49
On Windows, add -Llevel to startup.bat. On UNIX, enter -Llevel when you start Integration Server. On any platform, add -Llevel to ais.cfg.
The default level is 2. You can specify these levels: Table 15 provides a list and description of the different log levels you can specify.
Table 15
Possible Log Levels Description To log all debug messages and the ODBC SQL generated by Integration Server: Generate dataloadrecord.txt, listing the first 1,000 records, which may include successfully loaded records and rejected records; and create hisdld.rul, consisting of the names of the dimensions loaded followed by the leaf node number of each dimension or member. Log all informational messages and some of the ODBC SQL generated by Integration Server. Log all warnings. Log all noncritical errors. Log all critical errors where Integration Server terminates the command. Log all critical server errors.
Level 0
2 3 4 7 8
The recommended level setting is 2 or 3. After changing log levels, you must restart the Integration Services server for the log settings to take effect.
The following sections contain information about Business Rules log files.
50
Contents Business Rules client activity Records general information and errors on the Business Rules server.
hbrserver.log
From Oracle Hyperion Planning, Fusion Edition, written to the location from which the Planning server is started. From Administration Services, written to
EPM_ORACLE_INSTANCE/diagnostics/logs/eas
hbrlaunch.log
Includes information regarding business rules names and RTP values for launched rules.
Archive
From Planning, written to the location from which the Planning server is started.
3 4 5
In the left pane of Administration Services, expand Business Rules, and then Administration. Double-click Properties.
The properties of the Oracle's Hyperion Business Rules client configuration are displayed.
To change the error-reporting level for the client on the Client Configuration tab, select a level from Log Level:
l
To change the error-reporting level for the server on the Server Configuration tab, select an error level from the Log Level list described in step 5.
Other Logging Formats
51
7 8
Click Save. After changing log levels, restart the server for the log settings to take effect.
Planning Logs
Subtopics
l l
Log File Names and Descriptions Setting Logging Levels for Planning
Note: Planning does not use ODL. See Other Logging Formats on page 49.
Rotation Archive
Security refresh information, such as provisioning or user not found issues. Facilitates troubleshooting of synchronization issues between Planning and Shared Services. Application migration information, shows line-byline application schema migration process. Upgrade log files are created for each upgraded application. Every Planning utility has a log and is logged to the same location
EPM_ORACLE_INSTANCE/diagnostics/ logs/planning
Can be deleted
ApplicationMigration.log MigrationLog.txt
EPM_ORACLE_INSTANCE/diagnostics/ logs/planning
Can be deleted
Can be deleted
Can be deleted
Log in to a Planning application as the administrator or owner. Select Administration, then Application, and then Manage Properties.
Using EPM System Logs
3 4 5
Select the System tab. Set DEBUG_ENABLED to true. After changing log levels, restart the Planning application server for the changes to take effect.
Note: Oracle Hyperion Performance Scorecard, Fusion Edition does not use ODL. See Other
Log Description Performance Scorecard application activity. Includes Lifecycle Management activity. Alerter Web application activity Performance Scorecard import or export errors Performance Scorecard import or export errors Performance Scorecard import or export records
Log Location
EPM_ORACLE_INSTANCE/ diagnostics/logs/hps
Rotation Archive for support call purposes Archive for support call purposes Archive for support call purposes Can be deleted Can be deleted
HPSAlerter.log
error.log
failedrecords.log
successfulRecords.log
53
Log Name
debug_YYYYMMDD_ HHMMSS.log
Log Description Debugging information from the Strategic Finance Server (detailed information on what is happening with every server operation) Information about Oracle Hyperion Strategic Finance, Fusion Edition, events Note: Using the Event logs tab of the Administrator utility, you can view individual event logs. See the Oracle Hyperion Strategic Finance Administrator's Guide.
eventYYYYMMDD.log
Oracle Hyperion Strategic Finance Server event logs can be managed in the server administrator (select Server and then select Settings). Archive
YYYYMMDD_HHMMSS_ seq.log
A history of user actions (called user results log files). Microsoft Application Event log. Note: To view application event logs, select Administrative Tools from the Windows Control Panel, and then select Event Viewer and Application.
event logs
Archived event log files can be used to audit the activity of users.1
1An
event log file is created each time the service process starts, and a file is started at least once a day.
FDM Logs on page 54 ERP Integrator Logs on page 55 Data Relationship Management Logs on page 56
FDM Logs
The following sections contain information about Oracle Hyperion Financial Data Quality Management, Fusion Edition logs.
Note: FDM does not use ODL. See Other Logging Formats on page 49.
54
Log Description Information about FDM activities and audit-related information. Batch processing, informational, and error log entries
Rotation Archive. Keep this log for the financial audit trail. Archive
l l l
username.err
Information about FDM user errors. Note: These logs assist in debugging customer issues.
Can be deleted
Event log entries that are written by the Application Manager and LoadBalance Manager Note: FDM Task Manager can also log scheduled task events (when logging is enabled) in the Windows Event Log.
Authentication.err
Log Description Information necessary for support and Development to triage issues. Information about ERP Integrator system errors.
Rotation
Table 16 provides a list and description of the ODI log levels that you can specify.
Table 16
Level 0
55
Level 1 2 3 4 5
Description Log fatal messages. Log error messages. Log all warnings. Log information messages. Log debug messages.
Each log level encompasses messages of the lower log levels; for example: level 2 logs errors and fatal messages. Similarly, Level 5 includes all messages.
Contents Database configuration logInformation generated by the Data Relationship Management console upon configuration of an application database. Information written by the Data Relationship Management Server. Includes Data Relationship Management events, server messages, and errors. Information written by the Data Relationship Management Batch Client. This log includes details about an Import operation.
Rotation Archive
Follow standard IT practices should be followed in managing the application event log. Can be deleted when not needed
56
Contents Information written by the Data Relationship Management Batch Client. Includes details about a Blender operation. Information written by the Data Relationship Management Batch Client (User can override the name and location). Includes processrelated information for all operations for a given date. Transaction information written by the Data Relationship Management system and maintained in the Data Relationship Management repository database Note: To view Transaction History from the Data Relationship Management client, click Audit.
Rotation Can be deleted when not needed Can be deleted when not needed
Transaction History
As Data Relationship Management versions are deleted, the corresponding transactional history is also deleted.
Logged Action records basic logging information, such as users logging in and logging out. Core Action records actions that change the version, hierarchy, or node information, such as Add Node, Change Property, or Move Node. Result Action records actions that result from core actions. For example, if the clear all below core action is performed, then properties are cleared from individual nodes. Clearing properties from the individual nodes is a result action. Loss Action records loss of data due to a core action. For example, when a node is deleted, the defined properties for that node are deleted, which is a loss action. Loss actions are controlled by the LossLevel system preference.
57
LossLevel indicates what to track for lost information. You can set the preference to Defined or All Items. When set to Defined, only values that are specifically set at the node are tracked when the node is deleted. When set to All, derived, default, and inherited values also are tracked in the LossAction. AllowAsOf forces tracking of Core Actions.
Note: If the Loss Action is specified, or if AllowAsOf is turned on, then Core Actions are tracked, even if not set in the TransactionLevels system preference.
Recommended preference settings are All Items and AllowAsOf unless you require different settings for storage or performance reasons.
58
EPM_ORACLE_HOME/diagnostics/ logs/epma/epma.log
59
InputTrace.webinfo OutputTrace.webinfo
If trace enabled is set is to true, the account running the Web service application pool (network service by default) must have full security rights to this folder: EPM_ORACLE_HOME/products/
FinancialManagement/Web/ HFMLCMService EPM_ORACLE_INSTANCE/ diagnostics/logs/hfm/ interopJava.log EPM_ORACLE_HOME/products/ FinancialManagement/ logging/InteropLogging. xml EPM_ORACLE_HOME/products/ FinancialManagement/ logging/logging.xml
To enable diagnostic logging, on the logger name line, change ERROR:1 to TRACE:1.
To enable diagnostic logging, on the logger name line, change ERROR:1 to TRACE:1.
hfm.odl.log HsvEventLog.log
In a Windows environment, Central Inventory is in System drive/program files/ Oracle/inventory. In a UNIX environment, the Central Inventory location is specified in the oraInst.loc file, which is generally in the /etc folder. Central Inventory log files are generally saved in this format:
ActionTimestamp.log
For example, this log is recorded for an attachHome operation performed on May 17, 2010, at 6.45AM:
AttachHome2010-05-17_06-45-00AM.log
61
62
4
In This Chapter
Installation Tips and Troubleshooting ....................................................................63 Upgrades ...................................................................................................68 Configuration Tips and Solutions .........................................................................69 Windows Integrated Authentication Support ............................................................74 Out-of-Memory Errors With Concurrent Users ...........................................................75 Resolving Connection Failures and Restarting Services ................................................75 Demo Certificate Message ................................................................................75 WebLogic Administration Console Port Changes........................................................76 Antivirus Software..........................................................................................76 UNIX-Specific Issues.......................................................................................76
EPM System Installer Shutdown EPM System Installer Files on Client Machines Oracle HTTP Server Product Selection Panel EPM System Installer Extraction on Solaris EPM System Installer Startup Failure EPM System Installer Startup After MSI Installation EPM System Installer Freeze Welcome Panel Issue Reinstallation
For help with configuration issues, see Configuration Tips and Solutions on page 69.
63
in a command window before the Welcome screen opens. Most of these checks are to ensure that you have the correct assemblies. For example, if you are installing EPM System components on 32-bit machine, EPM System Installer checks whether you have 32-bit assemblies.
Oracle HTTP Server installation documentation (http://download.oracle.com/docs/cd/ E15523_01/webtier.htm) Release Notes (http://download.oracle.com/docs/cd/E15523_01/relnotes.htm)
For information about Oracle HTTP Server installation issues and workarounds, see the readme platform: http://download.oracle.com/docs/cd/E15523_01/relnotes.htm. For information about EPM System logs with information about Oracle HTTP Server, see Chapter 3, Using EPM System Logs. in this guide. For additional information, see the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Readme and these sections in the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide:
l
Oracle HTTP Server Installation Prerequisites in Chapter 3, Installing EPM System Products Using EPM System Configurator and sections about specific products in Chapter 4, Configuring EPM System Products Web Server in Chapter 7, Starting and Stopping EPM System Products
64
Tip: You can also run the Oracle HTTP Server installer in GUI mode, outside EPM System Installer, using setup.exe (Windows) or runInstaller from EPM_ORACLE_HOME/ oui/bin. Specify MIDDLEWARE_HOME/ohs as the target installation folder, and accept the
defaults for all other settings. See also Chapter 3, Using EPM System Logs.
Partial installation of the product Assemblies not downloaded Assemblies placed in the wrong location Assemblies renamed Assembly not available for your platform
Solution: Ensure that the assemblies are in the correct locations. See Chapter 2, Preparing for Installation, in the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide.
65
Solution: Use the unzip -o to extract the EPM System Installer files.
The assembly folder has a 0-byte dat file or no dat file, because the assembly download failed. Take these steps:
m
Download the assembly again. Ensure that there are no spaces in the path to EPM System Installer.
The assembly folder was renamed or did not extract correctly, so that EPM System Installer does not recognize it. Take these steps:
m
Check the assembly folder name. If the assembly folder name is correct, reextract the assembly folder.
Caution!
When using WinZip to extract files from a downloaded assembly folder, clear the Use folder names option. If the Use folder names option is selected, the assemblies are extracted incorrectly, and you may be unable to launch EPM System Installer.
The JRE or Help folders are missing because the extraction failed. Reextract the folders.
66
<?xml version="1.0" encoding="UTF-8" standalone="no"?> <softwareRegistry> <userLocale>en_US</userLocale> <hyperionHome id="1"> <installLocation>c:\Oracle\Middleware\EPMSystem11R1</installLocation> <products> </products> </hyperionHome> </softwareRegistry>
Note: Adjust <installLocation> to fit your installation location. This example uses the
default location.
Check the amount of available space on the computer, and free more space if necessary. Installations can fail without warning if the available space is insufficient. If the available space is sufficient for the installation, no other error message is displayed on the summary panel, and the installation does not resume within 5 minutes, stop the installation and run the createInventory script in EPM_ORACLE_HOME/OPatch.
Reinstallation
Issue: You experience problems installing EPM System products after uninstalling then. Solution:
l
67
2. Uninstall from the Windows Add and Remove Programs option. 3. In C:/Documents and Settings/install_user/, delete .oracle.instances. 4. Rename program files/common files/installshield/universal/common as
program files/common files/installshield/universal/ common_hyperion.
UNIXRemove all entries for previous installation in ~/oraInventory/ContentsXML/ inventory.xml (Otherwise, the installer does not recognize MIDDLEWARE_HOME.)
Upgrades
When upgrading EPM System products, be sure to perform all high-level tasks described in Upgrading Checklist in Chapter 5, Upgrading EPM System Products, of the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide.
Note: For EPM System products other than Shared Services, run the Import Data from earlier
release task only on one machine in a distributed environment. The task fails if you run it on subsequent machines without copying the replicated data to those machines, but this is not an issue if the task succeeds on the first machine. Issue: When you upgrade to Release 11.1.2.1 without uninstalling the earlier release, EPM System Configurator does not start from EPM System Installer when you click Configure. This issue occurs if the character limit for the PATH variable has been exceeded. Solution: Edit the PATH variable to remove all references to the earlier release.
68
Distributed Environments Changing a Host Name Java Heap Size Changes Product Databases EPM System Configurator Startup Failure Web Server Configuration Out-of-Memory Error with Multiple Web Application Deployments First-Time Configuration of the Shared Services Database Missing JAR Files Configuration Failure and Error Messages Configuration Task Panel: Missing Products Configuration Errors for Hidden Tasks Unavailable Database Configuration Options Failure Deploying to Application Server Without Configuration Errors Moving Web Applications to a Single Domain Reconfiguration Without Reinstallation
For help with installation issues, see Installation Tips and Troubleshooting on page 63.
Distributed Environments
In a distributed environment, after completing the configuration of EPM System products on any machine, close EPM System Configurator before beginning configuration another machine.
Note: The name of the host component is not updated. You can use the same procedure to
69
Follow this procedure only if the host name has changed. If you have moved a component from one host to another, the Shared Services Registry is updated when you install and configure the component on the new host.
Note: If you install EPM System products on a new host machine during an upgrade to Release
11.1.2.1, you must update references for some products to reflect the new host name and port number. See Updating References to a Rehosted Environment in the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide.
Product Databases
Oracle recommends that you put each EPM System product in its own database schema to provide flexibility in database backup and recovery. In prototype and development environments, configuring one database for all products may be satisfactory.
HTTP Server installation. When Oracle HTTP Server is installed, you can choose Oracle HTTP Server or IIS during Web server configuration.
Solution: Inability to open the wallet results from a defect in Oracle Wallet Manager. Oracle Wallet Manager 11g cannot read the PKCS12 keystore created from third-party tools such as OpenSSL. Until this issue is resolved, use the Oracle Wallet Manager that is shipped with the Oracle 10g Client to read the new ewallet.p12 file and save it for use with Oracle HTTP Server 11gR1. To obtain a 10g version of Oracle Wallet Manager, download the Oracle 10g Client from the following URL, and install the Administrator components: http://www.oracle.com/technology/ software/products/database/oracle10g/htdocs/10201winsoft.html.
71
or component at a time. Issue: Configuration fails, or you receive error messages during configuration. Solution: Review the configtool_summary.log file in EPM_ORACLE_INSTANCE/ diagnotics/logs/config.
l
Issue: This error message is added to configtool.log file in EPM_ORACLE_INSTANCE/ diagnotics/logs/config when Oracle Database is configured for the first time:
ORA-00917: missing comma
This error can occur if the database is configured with the US7ASCII database character set. Solution: Recreate the database with the UTF-8 character set or another character set that has Unrestricted Multilingual Support. EPM System Release 11.1.2 supports only such character sets, as documented in Oracle Hyperion Enterprise Performance Management System Installation Start Here.
l
Issue: EPM System Configurator shows that the Configure Oracle Configuration Manager task failed. This can happen if Oracle Configuration Manager is unavailable during configuration. Solution: Restart EPM System Configurator when Oracle Configuration Manager is available, and select the Configure Oracle Configuration Manager task.
72
Sequence in a Distributed Environment in the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide. Solution: Use one of these procedures:
73
If the domain for Foundation Services works correctly, deploy all EPM System Web applications to that domain: 1. Run the WebLogic Administration Server on the Foundation Services machine for the domain. 2. Redeploy the Web applications that are deployed to domains other than the Foundation Services domain. In EPM System Configurator, select Deploy Web applications to an existing domain, and then enter the host, port, and domain name for the Foundation Services machine. 3. Redeploy any Web applications on the Foundation Services machine that were already deployed on that machine.
To deploy all EPM System Web applications to a new domain: 1. Use the WebLogic Configuration Wizard to create a basic domain. 2. Start WebLogic Administration Server for the new domain. 3. Redeploy the Web applications that were deployed on machines other than the Foundation Services machine. In EPM System Configurator, select Deploy Web applications to an existing domain, and then enter the host, port, and domain name for the new domain. 4. Redeploy any Web applications on the Foundation Services machine to the new domain.
74
Solution: Set up SQL Server for Windows Integrated Authentication. See Setting Up Microsoft SQL Server Windows Authentication in the Configuring EPM System Products chapter of the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide.
Press Ctrl+Shift+Esc. In Windows Security, click Task Manager. In Windows Task Manager, select Processes. Locate the name of the executable for that product.
If you cannot find it in the list of active processes, you may need to start it. If listed, select Mem Usage. If it is using more than 500 MB, a memory error might require you to restart the service.
75
Antivirus Software
Antivirus software can cause performance issues with EPM System products if, each time you access any resource on the server, the antivirus software tries to open and scan the object. To prevent these issues, exclude the EPM_ORACLE_HOME directory from automatic antivirus scans and scan this directory only at scheduled times.
UNIX-Specific Issues
Subtopics
l l l l l l
Slow Web Application Startup with TC2000 Solaris Web Server Configuration Failure on AIX JAR Files Not Found Installation on Different UNIX Systems Preparing JVM Error Message Oracle Common Files Installation Failure
76
If some file sets are missing, follow these steps: 1. Uninstall Foundation Services. 2. Install the missing file sets. 3. Run rootpre.sh. 4. Install and configure Foundation Services again.
UNIX-Specific Issues
77
1.jar not exists; file depth: 2; referenced from /HYPEPM2/Oracle/Middleware/ EPMSystem11R1/common/jlib/11.1.2.0/epm_soa.jar referenced from /HYPEPM2/Oracle/ Middleware/EPMSystem11R1/common/config/11.1.2.0/configtool.jar FATAL ERROR: Jars manifest check failed with message "Some referenced jars do not exist" Exiting in 30 seconds
Solution: Add the current user to the group of users who install other Oracle software, then uninstall EPM System and repeat the installation. The user installing EPM System must be a member of the same UNIX group as other users who install other Oracle software. This requirement is documented in the Installing EPM System Products section of the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide.
78
5
In This Chapter
Foundation Services
Foundation Services Upgrades ...........................................................................79 EPM Workspace ............................................................................................80 Shared Services ............................................................................................83 Lifecycle Management.....................................................................................93 Performance Management Architect .....................................................................99 Smart View................................................................................................ 104 Calculation Manager..................................................................................... 104
In the HYPERION_HOME/migrate/logs folder of earlier Shared Services release: 1. SharedServices_Migrate_Summary.log 2. SharedServices_Migrate.log In the EPM_ORACLE_INSTANCE/diagnostics/logs/upgrades/foundation folder of Shared Services Release 11.1.2.1: 1. SharedServices_Upgrade_Summary.log
Note: You can disregard this error message: EPMCSS-01572: Failed to deprovision Shared Services security admin user.
2. Individual logs, if the summary log reports errors. Issue: After an upgrade, no user, group, or provisioning information is available in Shared Services. This issue occurs if you do not import data from the earlier release of Shared Services during the upgrade.
79
Note: You must export data from the earlier release before upgrading EPM System products.
See Exporting Shared Services Data from the Earlier Release in Chapter 5, Upgrading EPM System Products, of the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide. Solution: In EPM System Configurator, select the Foundation task Import Data From Earlier Release.
Note: Provisioning information is available for upgraded products only.
Issue: During configuration with EPM System Configurator, you receive an error when you select the Foundation task Import Data From Earlier Release, because the file does not exist. This issue occurs if you do not export data from the earlier release of Shared Services before an upgrade. You must export data from the earlier release before upgrading EPM System products. Solution: Follow these steps: 1. Export Shared Services data from the earlier release. See Exporting Shared Services Data from the Earlier Release in Chapter 5, Upgrading EPM System Products, of the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide
Note: If you inadvertently uninstalled the earlier release of Shared Services before exporting
data, reinstall the earlier release and then export the data. You can then uninstall the earlier release of Shared Services. 2. When configuring the new release, in EPM System Configurator, select the Foundation task Import Data From Earlier Release.
EPM Workspace
Subtopics
l l l l l l l
Slow Logon Missing Products or Product Menus in EPM Workspace Truncated Menus Oracle Business Intelligence Enterprise Edition Startup Flickering Icons in Internet Explorer 404 Error Messages Performance Degradation
Complete configuration information about your EPM Workspace installation, including Shared Services information, is available at this URL:
http://hostname:port/workspace/debug/configInfo.jsp
80
Foundation Services
where hostname is the name of the Foundation Services server, and port is the TCP port on which the application server is listening. See Chapter 5, Ports, in Oracle Hyperion Enterprise Performance Management System Installation Start Here.
Note: For access to this URL, you must enable client debugging: Log on to EPM Workspace (http://server:port/workspace) and select Navigate, then Administer, then
Workspace Server Settings. After you enable client debugging, log out of EPM Workspace, close the browser, and log on again.
l
Check the logs for information on startup failures. See Chapter 3, Using EPM System Logs.
Slow Logon
Issue: Logon to EPM Workspace is very slow. Solution: Ensure that all integrated applications are started. Disable integrated applications that are not started, on the Workspace Server Settings panel. To access Workspace Server Settings, select Navigate, then Administer, and then Workspace Server Settings. See Chapter 3 of the Oracle Enterprise Performance Management Workspace Administrator's Guide. You can also run EPM System Diagnostics. For instructions, see Chapter 8, Validating the Installation and Verifying Deployment, in the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide.
Contact the administrator to verify user privileges. Go to http://host.example.com:port/workspace/status for a list of products integrated into EPM Workspace. Select Navigate, then Administer, and then Workspace Server Settings. Enable clientdebugging in Workspace Server Settings, and then log off EPM Workspace, close the browser, and log on again. Go to http://host.example.com:port/workspace/debug/userInfo.jsp for a list of user roles.
Note: After installing and configuring EPM System products, you must rerun the Web server
configuration task and restart the Web server and Foundation Services managed server.
EPM Workspace
81
Truncated Menus
Issue: From Internet Explorer 7 or a later version, when you log on to EPM Workspace and select Navigate, then Applications, then a product, and then Menus, the applications for the product are not displayed.
Note: This issue can also occur with other menus.
Solution: Edit the Internet Explorer 7 security option to enable the option that allows scriptinitiated windows without size or position constraints.
82
Foundation Services
Performance Degradation
Issue: Performance is degraded after you take a product offline. Solution: In EPM Workspace server settings, deselect the offline product from the Enabled Products list. See Workspace Server Settings in the Oracle Enterprise Performance Management Workspace Administrator's Guide.
Shared Services
Subtopics
l l l l l l l l l l l l l l
Running Remote Diagnostics Agent Shared Services Logon Failure High Availability of Active Directory Product Registration Failure Security Lockout After Failed Logon Attempts User Name Search Failure Asterisks in User Names AuditHandler Message Audit Data Purges and Oracle Database Tablespace Single Sign-On Shared Services Registry Contents and Updates User Directories and Provisioning Startup and Access Issues Product-Specific Issues
Shared Services
83
Specify the domain name. (Optional) Specify the site and the DNS IP address. Oracle recommends against selecting the Host Name option for Active Directory configuration in Shared Services. Use the Host Name option for testing purposes only.
Caution!
When configured to perform a DNS lookup, Shared Services queries the DNS server to identify registered domain controllers and switches to an available domain controller in case of a failure. For more information, see DNS Lookup and Host Name Lookup in the Oracle Hyperion Enterprise Performance Management System User and Role Security Guide.
Note: Oracle recommends configuring Shared Services to use DNS lookup to locate Active
Solution:
84
Foundation Services
Verify that the administrator's password for Shared Services is correct. Subscribe to any online time source that uses an atomic clock, and ensure that both machines use this time source so that they are synchronized.
AuditHandler Message
Issue: The SharedServices_Audit.log file includes this line:
AuditHandler - Server Audit Enable Status:- false
Solution: You can safely ignore this message, which indicates that auditing is not enabled on the Shared Services server. An AuditHandler status message is included whenever an audit client pings the server for status. If auditing is enabled, the client proceeds with auditing events; otherwise, the client ignores auditing events.
Shared Services
85
the tables. Solution: Follow these steps: 1. Stop the Shared Services server and run these queries to shrink the space occupied by the tables:
alter table SMA_AUDIT_ATTRIBUTE_FACT enable row movement alter table SMA_AUDIT_ATTRIBUTE_FACT shrink space alter table SMA_AUDIT_FACT enable row movement alter table SMA_AUDIT_FACT shrink space
Single Sign-On
Issue: With the Oracle Single Sign-On (OSSO) security agent enabled, single sign-on (SSO) fails. This issue occurs when the Shared Services security settings specify OSSO as the SSO provider or agent and Get Remote user from HTTP request as the SSO mechanism Solution: Using Oracle's Hyperion Shared Services Console, select these security settings:
l
SSO Provider or AgentOther SSO MechanismCustom HTTP Header The default value for the Custom HTTP Header is HYPLOGIN. You can specify a different value.
See Setting Security Options in the Oracle Hyperion Enterprise Performance Management System User and Role Security Guide.
Be extremely careful when editing the Shared Services Registry, because it is critical to running EPM System products. Always back up the Foundation Services database before making any changes to the Shared Services Registry.
The Registry Editor utilityepmsys_registry.bat (Windows) or epmsys_registry.sh (UNIX)is in EPM_ORACLE_INSTANCE/bin. Running this utility creates a report on the contents of the Shared Services Registry. See Appendix F, Updating the Shared Services
86
Foundation Services
Registry, in the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide. Issue: You cannot access the Shared Services Lifecycle Management user interface and must view the contents of the Shared Services Registry. Solution: Run the Registry Editor utility without parameters to generate a report called registry.html. Issue: You must change user directory information but cannot access the Shared Services Lifecycle Management user interface. Solution: Run the Registry Editor utility for a report of deployment information that can help you determine how to edit the Shared Services Registry.
Provisioning Issues and Best Practices External Users, Groups Information, and Performance Tips and Common Issues
See also the Oracle Hyperion Enterprise Performance Management System User and Role Security Guide.
Whether you can connect to the user directory from the server that you are using The response time The starting point (base DN) for any search of the user directory A count of the users and groups under the starting point
Minimize the number of groups and users for EPM System applications. Ensure that the server machines that host EPM System applications are in the same geographical location as the server machines that host the user directories used in the provisioning process. Find an optimal starting point for searches or create a custom group hierarchy.
Shared Services
87
For the first item in the search order, specify the directory from which the greatest number of users log in.
Set up a filter to retrieve only the required users. Oracle recommends that you set the group URL and tune the group filter to decrease the number of groups that Shared Services must parse to build the cache. Doing so improves runtime performance significantly.
See Faster User Retrieval, Application Registration, and Security Loading on page 88and Maximum Size Setting for User / Group Searches on page 89. Issue: Shared Services accesses LDAP and MSAD group information even though you do not use LDAP or MSAD groups. Solution: Create groups in Native Directory and assign users from LDAP and MSAD directories to them, then set the use groups option to false. Use the Shared Services Console to modify the user directory configuration. Verify that the Support Groups check box on the Group Configuration tab is clear.
Note: Oracle recommends that you set the group URL and tune the group filter to decrease the
number of groups that Shared Services must parse to build the cache. Doing so improves runtime performance significantly.
The Group URL is incorrectly defined. The host name, port, or domain controller is not specified correctly. Too many groups are defined in the Group URL.
Note: Shared Services displays a warning if the number of available groups within the Group
To increase performance:
1
If you plan to use groups:
a. Use native groups, not external groups, to provision external users, and clear the use groups option on the groups tab of LDAP/MSAD provider configuration panel. b. Always set a group URL to the lowest node that includes all your groups. c. Use a group filter, if possible.
a. Always define a User URL and set it as deep as possible. b. Set a user filter, if possible.
3 4
Use the default logging level of WARN. Change the level to <DEBUG> only for debugging purposes. See Configuration Files on page 20. For multiple groups and users, set the Java Heap Size in all products to 1 GB. See Java Heap Size Changes on page 70.
Group URL
Having more than 10,000 groups in the Group URL degrades performance. To resolve this issue:
l
Change the Group URL to point to a lower-level node. Use a group filter that retrieves only provisioned groups. Create a custom group hierarchy to support EPM System applications.
See the Oracle Hyperion Enterprise Performance Management System User and Role Security Guide.
Shared Services
89
Resolving a Shared Services Startup on the Application Server Resolving Problems Accessing Products from Shared Services Reregistering Products with Shared Services Reconfiguring the Shared Services Database
Performance is unacceptably slow because the group URL and group filter are not limiting the number of groups returned by a search. You are using invalid logon credentials. The server hosting the product is not connected to the servers hosting user directories and Shared Services, so you cannot be authenticated as a user.
Perform these tasks: 1. Review SharedServices_SecurityClient.log (on the server hosting the product) and SharedServices_Security.log (on the server). See Configuration Files on page 20
l
Check the Web application port to ensure that you are using the Web server. If group cache errors exist, stop Shared Services and refresh the cache. If authentication errors exist, verify that the user URL is correct.
90
Foundation Services
3. Ensure that the server hosting the product can connect to the servers hosting the user directories and Shared Services.
are reregistering.
Product-Specific Issues
Subtopics
l l
Shared Services and Essbase Components Shared Services and Financial Management
Solution: Refer to SharedServices_SecurityClient.log in the Essbase logs folder. See Chapter 3, Using EPM System Logs. Issue: You cannot create an Essbase application as a Microsoft Active Directory user.
Shared Services
91
This issue occurs if Microsoft Active Directory contains user and contact records and Shared Services is configured to return both record types. Solution: Edit CSS.xml to specify the setting objectClass=user. This setting prevents Shared Services the Microsoft Active Directory provider from returning contact records. The CSS.xml file is in EPM_ORACLE_INSTANCE/Config/FoundationServices.
Review SharedServices_SecurityClient.log. If group cache errors are displayed, ensure that the group URL and filter are set correctly to accommodate group counts. If data broker property errors are displayed, enable interopjava logging. Use JRE 1.5 to support 1,000 or more groups. On the server, review SharedServices_Security.log. If errors relate to group caching, ensure that the group URL and filter are set to accommodate group counts.
Review the Financial Management logs. See Financial Performance Management Applications Logs in Chapter 3, Using EPM System Logs.. Ensure that the Financial Management application server can communicate with Shared Services using HTTP and WEBDAV protocol. Webdav may be blocked if you proxy requests from IIS to interoperate with the Web application. If so, ensure that the UrlScan IIS extension does not block propfind methods. If you are using IIS on Windows 2003 SP1, add the IIS the UseBasicAuth registry key to dword 1 in the registry HKLM\SYSTEM\CurrentControlSet\Services\WebClient \Parameters.
If the interop Web site redirects to the Web application server, ensure that the authentication method is anonymous and that Windows integration authentication is not used.
Run the Server and Web configuration utility on the Financial Management Web server, and change the Web session timeout setting. (The default setting is 20 minutes.)
Foundation Services
92
If the client is using the URL provider for Smart View (not the Shared Services provider), right-click for the properties of the HFMOfficeProvider virtual directory in IIS and click Configuration on the Virtual Directory tab. In the new window, click Options and change the session state timeout setting. Change the setting of the default Web site.
Also check the timeout settings of the Default Web site and the Smart View Provider settings in the FM Server and Web Configuration.
Lifecycle Management
Subtopics
l l l l l l l l l l l
Migration Tip: Naming Command Line Utility Comparing Environments SSL Application Freeze or Name Mismatch Error Shared Services Launch Failure Lifecycle Management Migration Wizard Freeze Export Failure Import File Format Not Supported Error Message Lifecycle Management Diagnostics Lifecycle Management and Reporting and Analysis Lifecycle Management and Financial Management
Lifecycle Management
93
This error occurs because the -server option, which was used in earlier releases to export or import artifacts on the Shared Services file system and not on the server where the Lifecycle Managementt command-line utility is running, is deprecated in Release 11.1.2.1. Solution: To import or export to the Shared Services file system from the command line, mount the drive that is used by the Shared Services server from the computer where you are running the command-line utility, and then directly export to the directory structure that you want to use. For example, if the Shared Services server is on ServerA, and EPM ORACLE INSTANCE is c:/ oracle/middleware/user_projects/epmsystem1, use a UNC path (//host/share/ path) to the import_export folder and use the -b base path option, as in this command:
utility.sh PlanExportMDF.xml -b //ServerA/c$/$EPM_ORACLE_INSTANCE$/ import_export
Comparing Environments
Issue: You need to compare two environments, such as a Development and Test. Solution: Export the artifacts to the file system and use a compare utility (such as Beyond Compare) to see differences for text and XML artifacts.
94
Foundation Services
2 3 4 5 6 7 8
From the Tools menu, select Internet Options. Click the Security tab. Select the Internet Web content zone. Click Custom Level. Scroll to Miscellaneous. Select the Enable option under Allow META REFRESH. Click OK, and then click OK again.
Export Failure
Issue: Export fails because the user password for a Lifecycle Management export file contains braces ({ }). Solution: Do not use braces in user passwords.
Lifecycle Management
95
Table 17
Reporting and Analysis Common Issues and Resolutions Solution Ensure that the Oracle's Hyperion SQR Production Reporting subservice is created. Ensure that the Data Access Service data source is created. Ensure that the Financial Reporting data source exists in the destination application, and the Financial Reporting, data source is not changed. Ensure that the Shared Services Native Directory (Security) artifacts are migrated. Review the Migration Status ReportMigration Details for information on the missed object that should have been imported along with the failed object.
Issue Oracle's Hyperion SQR Production Reporting jobs are not imported. BQY files cannot be processed, and BQY jobs fail to run. Financial Reporting objects cannot be opened. Access control information is missing, ownership information is missing, or users' personal data is not imported. A specific object is not imported.
HFMLCMService Web Service Connectivity and Configuration Settings Timeout Setting for Lifecycle Management Server Communication Financial Management and Shared Services Logging Out-of-Memory Exception with Multiple Migrations on Large Applications Inability to Migrate Financial Management Artifacts Inability to View Financial Management Artifacts in Shared Services Console
1 2
In a text editor, open Web.Config in EPM_ORACLE_HOME/products/ FinancialManagement/Web/HFMLCMService. (Optional) For very large LCM artifacts, increase the values for executionTimeout (in seconds) and maxRequestLength (in kilobytes) in the following line:
96
Foundation Services
<!-- Maximum value allowed is 2GB - Currently set waiting time to 1hours, 1.5GB data transfer--> <httpRuntime executionTimeout="3600" maxRequestLength="1572864" />
Caution!
3 4
Save and close Web.Config. Reset Microsoft IIS Web server (iisreset).
Enable logging and diagnostics only when needed. Enabling them affects performance, especially with large migrations.
appSettings
<appSettings> <add key="Debug" value="true"></add> </appSettings>
Lifecycle Management
97
If an error occurs (even without the additional logging enabled), the IIS application pool account (Network Service) must have full access to the log directory; otherwise, no errors are caught. Log location: EPM_ORACLE_HOME/logs/hfm
m
Management
m
Shared Services
l
diagnostics
<diagnostics> <trace enabled="true" input="InputTrace.webinfo" output="OutputTrace.webinfo"/ > <detailedErrors enabled="true"/> </diagnostics>
If an error occurs (even without the additional logging enabled), the IIS application pool account (Network Service) must have full access to the log directory, otherwise no errors will be caught. Log location: EPM_ORACLE_HOME/products/FinancialManagement/Web/
HFMLCMService
m
InputTrace.webinfo OutputTrace.webinfo
98
Foundation Services
path that was specified during Financial Management installation and configuration. Solution: Ensure that the IIS pooling identity has Read, Write, and Execute rights to the Financial Management file transfer directory path that was specified during Financial Management installation and configuration.
To view the currently configured Financial Management file transfer folder path on the
computer hosting the Financial Management Web Service:
1 2
Open Registry Editor (click Start, click Run, type epmsys_registry, click OK). View the FileTransferFolderPath under HKEY_LOCAL_MACHINE\SOFTWARE \Hyperion Solutions\Hyperion Financial Management\Web.
Installation Failure Integration with EPM Workspace Performance Management Architect Logon Failure Security Rights Issue During Logon Hyperion EPMA Server Service Startup Performance Management Architect Task Display Performance Management Architect Dimension or Application Library Access Application Issues
If you have issues starting Performance Management Architect, start your troubleshooting by checking these points:
99
ValidationAfter configuring Performance Management Architect, click Validate. If an error message is displayed, scroll down to view any failed Performance Management Architect tests and check for recommended solutions. Windows Registry KeysEnsure that the required keys and values for Performance Management Architect are in the Windows registry: 1. From the Start menu, select Run, enter regedit, and click OK. 2. In the Registry Editor, click HKEY_LOCAL_MACHINE SOFTWARE and then ORACLE, and check for an entry for Performance Management Architect. 3. If there is no entry for Performance Management Architect, create an entry with these keys and values:
EPM_ORACLE_HOME = C:\Oracle\Middleware\EPMSystem11R1 EPM_ORACLE_INSTANCE = C:\Oracle\Middleware\user_projects\epmsystem1 JPS_CONFIG = C:\Oracle\Middleware\user_projects\domains\EPMSystem\config \fmwconfig\jps-config.xml
Installation Failure
l
Issue: Performance Management Architect Installation failed. Solution: This could be the result of a Microsoft .NET Framework 2.0 error during its automatic installation in Performance Management Architect. Install Microsoft .NET Framework 2.0 manually, and then rerun the installation.
Issue: You receive an ASP.NET error during configuration. Solution: Ensure that ASP.NET is installed and configured. See the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide.
This issue can occur because the Hyperion EPMA Server service is not running or because of missing user privileges in an Oracle database. Solutions: .
l
If the Hyperion EPMA Server service is not running, start service and then retry the connection. Assign the CREATE VIEW user privilege for the Oracle database. See Using an Oracle Database in Oracle Hyperion Enterprise Performance Management System Installation Start Here.
To check whether Microsoft .NET Framework 2.0 is installed and enabled on a Windows
2003 or Windows 2008 machine:
Select Start, then Programs, then Administrative Tools, and then Internet Information Services Manager. Run inetmgr.
2 3 4
In the left panel, select Web Service Extensions. In the right panel, note whether ASP.NET 2.0.50727 is listed. If ASP.NET 2.0 is listed, enable it by checking that the Status column is set to Allowed. If ASP.NET 2.0 was not listed and you have Microsoft .NET Framework 2.0 installed, register Microsoft .NET Framework 2.0 with IIS:
a. From the command prompt, go to C:\Windows\Microsoft.NET\Framework\v2. 0.50727. b. Enter run aspnet_regiis.exe iru. c. Repeat steps 1 - 3.
troubleshooting. Solution: If you are using Oracle Database, ensure that the Oracle Data Access Component version specified for this EPM System release is installed. Performance Management Architect Dimension Server requires Oracle Data Access Component, and this requirement is often overlooked during Oracle Database client installation.
For a large database, you can also increase the DimensionServerStartupTimeout setting. For instructions, see Configuration Settings in the BPMA_Server_Config.xml File in the Oracle Hyperion Enterprise Performance Management Architect Administrator's Guide. Check the Performance Management Architect logs for other possible causes. See Chapter 3, Using EPM System Logs.
Foundation Services is started. You have configured the EPM Workspace proxy server plug-in for your application server. If you cannot access this URL, you must configure the proxy server plug-in:
http://Web server:port/awb/conf/AWBConfig.xml, where Web Server is the Web server machine host name and port is the Web server listen port.
For more information, see Web Server Configuration Advanced Options in the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide.
http(s)://bpma_server:bmpa_port/awb/conf/AwbConfig.xml.
If this step works, then Performance Management Architect is not correctly enabled in EPM Workspace. Reconfigure EPM Workspace If this step does not work (error 404), then the Performance Management Architect Web Server is not started.
If a Sessions page is displayed, then IIS is correctly configured. If there is any error in IIS, check the Event Log to identify the problems. Check the System and Application Log to see if errors were logged by ASP.NET or IIS, and fix any errors. A possible cause is incorrect privileges for the user for the TEMP directory.
l
Check the Event Logs from sources starting with HyS9EPMA. Possible causes are communication errors with Shared Services or the database. The ASPNET user may not have access to certain folders. If the Event Log displays any security-related errors, assign rights to the ASPNET user. 1. From the command prompt, go to this directory: C:\Windows\Microsoft.NET
\Framework\v2.0.50727.
In the logs, if subcode is 2, and Win32 code is 1260, the problem is related to Web Service Extensions. In IIS, Web Service Extensions, ensure that the ASP.NET 2.0.50727 Web Service Extension status is Allowed. If SiteMinder is installed, remove the wildcard mapping: 1. From hyperion-bpma-server, click Properties and then Configuration. 2. Remove values in the wildcard mapping section.
Note: The Web service must be running with .NET Framework 2.0.
Solution: From the Control Panel, select Administrative Tools and then Services, and start World Wide Web Publishing Service, if it is not already started.
Application Issues
The state of a Performance Management Architect application can become out of sync with the Dimension Server, object repository, or target EPM System product for various reasons. You can run application diagnostics to check for application inconsistencies. See the Oracle Hyperion Enterprise Performance Management Architect Administrator's Guide for additional information.
Smart View
After installing and configuring EPM Workspace, you can use either of these methods to install Smart View:
l
From within EPM Workspace, select Tools, then Install, and then Smart View to launch the Smart View installer. Browse to EPM_ORACLE_HOME/common/epmstatic/wspace/SmartView and launch Smartview.exe.
For information about Oracle Hyperion Smart View for Office, Fusion Edition timeouts with Shared Services and Financial Management, see Shared Services and Financial Management on page 92.
Calculation Manager
See Multibyte Characters on page 119.
6
In This Chapter
Essbase
Essbase Maintenance Releases ........................................................................ 105 Essbase and Provider Services Upgrades ............................................................. 106 Pre-upgrade Security File Backup ...................................................................... 107 Essbase Server Startup.................................................................................. 107 Connections to Essbase Clusters....................................................................... 108 Essbase Failover Issues ................................................................................. 109 Client-Server Connection ................................................................................ 109 OPMN Startup ............................................................................................ 109 OPMN Restart ............................................................................................ 110 Startup: Port Conflict .................................................................................... 110 Integration Services: Connection to OLAP Metadata Catalog or External Data Source............ 110 Essbase Studio Startup ................................................................................. 111 Essbase Studio Logs Deleted ........................................................................... 111
services. Solution: Stop all EPM System processes (because a maintenance release affects all components in the Middleware home directory), verify that Essbase Server is stopped, and then try again to apply the maintenance release.
Essbase Maintenance Releases 105
Also ensure that you have met the prerequisites discussed in Maintenance Release Installation Prerequisites in Chapter 3, Installing EPM System Products, of the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide.
Essbase is unable to initialize Fusion utility functions. Error [%s] Error 1030803
These errors occur if the 64-bit version of the libaio package is not installed. Solution: Before you install Essbase or run the Essbase Staging Tool, install the 64-bit version of the libaio package, version 0.3.105-2 or higher, on the same machine.
Role Updates
Issue: When you upgrade an Essbase instance, Essbase roles for that instance are not updated. This issue occurs if you upgrade the Essbase instance before you import Shared Services data. Solution: Run the Update Native Directory utility to update the provisioning information. For instructions, see Chapter 10, Using the Update Native Directory Utility, in the Oracle Hyperion Enterprise Performance Management System Security Administration Guide for the release from which you are upgrading.
This error occurs if drill-through reports are inconsistent because data source connections have been renamed. Solution: Follow these steps:
106 Essbase
Note: Ensure that the Release 11.1.1.3 release environment is running and available until the
Essbase Studio catalog upgrade succeeds. 1. Take one of these actions to correct any drill-through report inconsistencies:
l
In the Release 11.1.1.3 environment, rename the data source connections to their original names. Update the invalid drill-through reports by providing new column values in the Report Contents tab of the drill-through report editor. You can also provide new filters. Delete the invalid drill-through reports from the 11.1.1.3 environment, and recreate them in the upgraded Essbase Studio environment.
2. Restart EPM System Configurator, and rerun the Configure Database task.
Clusters
Issue: After you upgrade from Provider Services Release 9.2.1 to Release 11.1.2.1, one or more clusters no longer exist. This issue can occur if you had both High Availability Services and Smart View Provider in Release 9.2.1 and the domain.db files from those products had clusters with the same name, but the cluster components did not match. Solution: See the aps-upgrade.log file for details, and use Administration Services Console to resolve the conflict.
Issue: You encounter this error message if JVMMODULELOCATION was not set correctly in essbase.cfg or in the shared library path for platform:
JVM load failed [jvm.dll]. Single Sign-On Initialization Failed
Solution: Open essbase.cfg in a text editor and edit it to specify the correct JVM. Issue: You encounter the error message Failed in GCInit(). This message occurs if the locale directory in ESSBASEPATH is not found or if files are missing files from the locale directory. Solution: Check ESSBASEPATH in hyperionenv.doc (UNIX) or setEssbaseEnv.cmd (Windows):
l
WindowsIn the command line, enter echo %ESSBASEPATH. UNIXIn the console window, enter > echo $ESSBASEPATH
See Files Installed in the Essbase Client Directory in the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide. Issue: Essbase does not start from the Start menu. Solution: Start Essbase from a command line. More error messages are displayed when Essbase is started from a command line, which facilitates troubleshooting. For example, error messages might identify missing or inaccessible files.
Ensure that the URL you are using follows one of these formats:
m
secure protocol)
l
To connect to an Essbase cluster using only the cluster name, modify a configuration file to specify the Provider Services server that resolves the cluster name in the URL. The Provider Services server is specified in these configuration files:
m
108 Essbase
You can specify several Provider Services servers in essbase.cfg, using a semicolon (:) between server names.
m
Note: The ApsResolver setting must be in essbase.cfg on the client side for tools or
applications that use Essbase CAPI (such as MAXL, Esscmd, and Planning). The ApsResolver setting must be in .essbase.properties on the client side for tools or applications that use Essbase JAPI (such as Oracle Hyperion Provider Services and Essbase Studio).
Client-Server Connection
Issue: You cannot establish an Essbase client-server connection. Solution: Use the ping command on the server to check that the server is running and visible to the client computer. If the ping command succeeds, try the TELNET command.
l
If the ping command succeeds but the TELNET command does not, there might be a problem with the inet daemon on the server. If the ping command fails, you might have a routing or hardware problem.
OPMN Startup
Issue: You cannot start OPMN when EPM System is installed in the same Oracle home directory as another Oracle product. Solution: Reinstall EPM System in an ORACLE_HOME location that is not shared with other Oracle products.
OPMN Restart
Issue: Approximately every 20 seconds, Essbase shows an error that resembles this one, which indicates that OPMN cannot ping Essbase after Oracle Process Manager and Notification Server is restarted.
[Thu Mar 11 18:00:04 2010]Local/ESSBASE0///Info(1056704) Received OPMN Ping Request [Thu Mar 11 18:00:04 2010]Local/ESSBASE0///Info(1056705) Sent the Response to OPMN Ping
Ensure that you are using the correct user name and password. If you are trying to connect to OLAP Metadata Catalog, ensure that you used the same user name and password as the user who created the tables in OLAP Metadata Catalog. If you create OLAP Metadata Catalog when logged in as one user name, you cannot access the tables in OLAP Metadata Catalog using a different user name unless you create an alias for the user name (for Microsoft SQL Server) or synonyms for the tables (for IBM DB2 and Oracle).
Ensure that the user name has the required access privileges for OLAP Metadata Catalog and for the data source at the database level. Ensure that all of the required components are up and running. The following components are required:
m
Oracle Essbase Integration Services Server The database servers that manage OLAP Metadata Catalog and the data source databases The data source database listener for OLAP Metadata Catalog and the data source
Ensure that OLAP Metadata Catalog and the data source are configured as ODBC data sources on the Integration Server computer.
110 Essbase
The information in the server.properties file is correct. The server.properties file is in EPM_ORACLE_HOME/products/Essbase/EssbaseStudio/Server. For information about the settings, see the Oracle Essbase Studio User's Guide. Your user name for connection to Studio Catalog has the correct privileges to work with Studio Catalog. The user should be a database owner. These required components are running:
m
Oracle Essbase Studio Server The database servers that manage Studio Catalog
112 Essbase
7
In This Chapter
Reporting and Analysis Upgrades ...................................................................... 113 Reporting and Analysis Framework Web Application Startup........................................ 113 Interactive Reporting Studio ............................................................................ 114 Financial Reporting ...................................................................................... 115 Web Analysis ............................................................................................. 116
Solution: Shorten the path to the temp directory by manually editing the
-Dweblogic.j2ee.application.tmpDir JVM option setting for the HKEY_LOCAL_MACHINE\SOFTWARE\Hyperion Solutions\RAFramework \HyS9RaFramework key, and then restart the service. For example, change the setting to C: \Temp\username
Essbase Loading Error Faulty Oracle Net Connection Failure Processing an Oracle Procedure Fonts Displayed Incorrectly
ORACLE_HOME
Path (for Windows) LD_LIBRARY_PATH (for Solaris and Linux) SHLIB_PATH (for HP-UX)
Windows: On the Advanced tab of the ODBC Oracle Wire Protocol Driver Setup box, select Procedure Returns Results.
Financial Reporting
Subtopics
l l
2. Ensure that you have created and started the FR Print Server service. 3. Verify that 32-bit Ghostscript is installed. 4. Check the FRPrintLogging.log file in EPM_ORACLE_INSTANCE/diagnostics/logs/ FinancialReporting. 5. Verify that the PrintServers property in FR MBeans shows the Financial Reporting Print Server machine and port. The default port is 8297.
Note: The PrintServers property shows all Financial Reporting Print Server machines
that are configured. 6. Verify that you can reach the Financial Reporting Print Server server name and port from the Financial Reporting Web Application server machine.
Web Analysis
Subtopics
l l
8
In This Chapter
Financial Performance Management Application Upgrades ......................................... 117 Planning................................................................................................... 118 Financial Management .................................................................................. 120 Financial Close Management ........................................................................... 126 Disclosure Management................................................................................. 140
Solution: Run HFM Application Upgrade_x64.exe (for 64-bit systems) or HFM Application Upgrade.exe (for 32-bit systems) from EPM_ORACLE_HOME/products/ FinancialManagement/server to override the database lock, and upgrade the database. The following issues that can occur during Financial Management upgrades both have the same solution. Issue: The Upgrade applications from earlier release task fails, and details are logged in
EPM_ORACLE_INSTANCE/diagnostics/logs/upgrades/ HFMApplicationUpgrade.log. The log contains a message resembling this one: Failed to find default cluster name for the application application name.
Issue: The Upgrade applications from earlier release task succeeds, but the application fails to open in EPM Workspace, and the Financial Management event log contains this message:
Server/Cluster is incorrectly configured. Please reconfigure your Cluster or Server connection.
Solution: Reregister applications manually through EPM Workspace to correct the assigned cluster name. After all applications are registered, restart Foundation Services and the Web server.
Planning
Subtopics
l l l l
Planning and Administration Services Performance Issues Multibyte Characters Using Planning in a Non-English Environment
Performance Issues
l
Issue: You use an Oracle database and want to improve the performance of Database Refresh. Solution: Ensure that CURSOR_SHARING in Oracle is set to EXACT (the default setting). Issue: You want to improve Planning, performance. Solution: Tune WebLogic or increase heap size, depending on your environment. For example, if Java runs out of memory, and your server has more memory available than the 512 MB that is allocated to Java by default, you can increase the amount that Java can use. See Increasing the JVM Memory Allocation in the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide.
Multibyte Characters
Issue: Multibyte characters do not show up in reports. Solution: Ensure that Unicode or Albany fonts are present in the Java Runtime Environment used by your WebLogic installation. If they are not, copy them from the fonts folder that has the Albany fonts laid out by Oracle Hyperion Enterprise Performance Management System Installer, Fusion Edition, to the fonts folder of the Java Runtime Environment used by your used by your WebLogic installation.
Note: This solution also applies to Hyperion Calculation Manager.
Before you install and configure Planning, in the OS system locale variable (if you have not already set it) After you install and configure Oracle Hyperion Planning, Fusion Edition, in
setCustomParamsHyperionPlanning.sh
This issue can also occur with other non-English languages. See (UNIX) Configuring the Planning Locale for Use in Non- English Environments in Chapter 7, Performing Postconfiguration Tasks, of the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide.
Planning 119
Financial Management
Subtopics
l l l l l l l l
Installation with FDM on Windows 64-Bit System Accessing Financial Management Connection Issues Rights Required for Installation Large Data or File Load Failure Sticky Server Attempts to Redirect User EnableServerLocking Option JRF WebServices Asynchronous Services
The Financial Management log viewer in the EPM_ORACLE_HOME/products/ FinancialManagement/Utilities directory is useful for troubleshooting Financial Management issues. These ODL logging configuration files, in EPM_ORACLE_HOME/products/ FinancialManagement/logging, are also useful for troubleshooting Financial Management installation and configuration issues:
l
logging.xml.template (Financial Management core) InteropLogging.xml (Financial Management interop) Tip: To enable diagnostic logging in InteropLogging.xml, change ERROR:1 to TRACE: 1 on line 14.
Note: If you experience problems installing or running Shared Services or have issues with
files:
l
EPMWindowsConfig.logFinancial Management-specific configuration hfm.odl.log (Financial Management core) HsvEventLog.log (Financial Management core) InteropJava.log (Financial Management interop)
For more information about error logs, see Chapter 3, Using EPM System Logs.
that FDM works, you can no longer open Financial Management applications. A test UDL produces an error message saying that the Oracle OLE DB provider is no longer available. Solution: Uninstall the Oracle Database 64-bit client and install it again. Financial Management and FDM can coexist on a Windows 2008 64-bit system using IIS7, but you must install Oracle Database 32-bit client and then install the Oracle Database 64-bit client.
Failure Accessing Financial Management Through EPM Workspace Financial Management Logon Failure Privileges for IIS
l l l
http://hfmserver:hfmport/ hfm/
l l
The Financial Management Web server is running. Web server configuration files point to the correct host name and port for the Financial Management Web server.
http://webserver:webport/ hfm/
For detailed instructions on configuring the Web server, see Chapter 4, Configuring EPM System Products, in the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide. 2. If step 1 does not work, verify that you have configured the EPM Workspace, proxy server plug-in. If it is configured, test whether you can directly access Financial Management.
Financial Management is installed and configured. IIS is started, and a virtual directory for Financial Management was created. In IIS, verify the settings for authentication. You can use Anonymous Authentication or Web Authentication, depending on your security policies.
Connection Issues
Subtopics
l l l l
Financial Management Connection Failure Failure after a Computer Restart Database Connection Failure SQL Server Connection Failure
log on to Financial Management with a user ID on Domain B (or any domain that Domain B can access), you cannot connect to a Financial Management server on Domain B. Solution: Perform an action:
l
Set up a one-way trust relationship from Domain B (Financial Management Server) to Domain A (Financial Management Client). Oracle recommends this method. On Windows 2008, set the DCOM Default Authentication Level to Connect on the client. In environments other than Windows 2008, set the DCOM Default Authentication Level to None on the client.
Caution!
Turning off the DCOM authentication on the client turns off DCOM authentication for all DCOM applications on the client.
Issue: You cannot connect to SQL Server or receive this error message: SQL Server:
Test connection failed because of an error in initializing provider. Client unable to establish connection.
Possible Solutions:
Windows authentication may have been used instead of Microsoft SQL Server authentication. Oracle recommends using SQL Server authentication. See Verifying Microsoft SQL Server Authentication Settings on page 124. The system may be using the Microsoft SQL Server default setting to connect to the database using named pipes instead of TCP/IP. Connection through TCP/IP is required. See Establishing the SQL Server Connection Using TCP/IP on page 124.
10 Click Next, and then click Finish. 11 Click Test Data Source. 12 When you receive the success message, click OK, and then click OK to close the dialog box. 13 Click OK to close the ODBC Administrator dialog box.
Verifying Microsoft SQL Server Authentication Settings To verify the Microsoft SQL Server authentication setting:
1 2 3 4 5 6
Select Start, then Programs, then Microsoft SQL Server, and then Enterprise Manager. Expand the list of Microsoft SQL Servers. Right-click the database server name, and then select Properties. Select Security. Ensure that this Authentication option is selected: SQL Server and Windows. Click OK.
The return code is always the same; only the application server name changes. Solution: This issue occurs when the signed-on token becomes invalid. Try these steps to resolve it:
l
Add this registry setting to each Web server and Financial Management Win32 client machine:
HKEY_LOCAL_MACHINE\SOFTWARE\Hyperion Solutions\Hyperion Financial Management\Client\Clusters\machine name
Verify any specific DCOM issues by setting up the appropriate logging. HKLM\Microsoft \Ole\CallFailureLoggingLevel and ActivationFailureLoggingLevel are enabled on all servers, and the login audit policy is set to both Success and Failure.
EnableServerLocking Option
Issue: After Financial Management is set up with multiple application servers, the EnableServerLocking option is not enabled. EPM System Configurator does not enable the EnableServerLocking option automatically. Therefore, if you have more than one Financial Management application server, Data Sync does not happen after 300 seconds, and the HsvEventLog.log shows Multi-server is not ON. Solution: Enable the option manually by updating the Windows Registry: 1. Locate this key:
HKEY_LOCAL_MACHINE\SOFTWARE\Hyperion Solutions\Hyperion Financial Management\Server
"EnableServerLocking"=dword:00000001
Solution: JRF WebServices Asynchronous services are required for Financial Management to work with Financial Close Management. If you are not using or have not installed Financial Close Management, selecting the Deploy to Application Server task for Financial Management in EPM System Configurator is unnecessary and can result in error messages but does not affect the functionality of Financial Management. If you inadvertently selected Deploy to Application Server for Financial Management, you can safely ignore the error messages.
General Financial Close Management Troubleshooting Tips Enabling OWSM Logging Financial Close Management Installation and Configuration Issues Financial Close Management Schedule Execution Issues
AdminServer.log AdminServer-diagnostic.log
SOA
m
soa_server1.log soa_server1-diagnostic.log
To check whether issues are related to EPM Workspace, use this link to bypass EPM Workspace and log on to Financial Close Management directly: http://host:port/fcc/faces/ oracle/apps/epm/fcc/ui/page/FCCDashboard.jspx. The default port for Financial Close Management is 8700. For more information, see Financial Close Management Postconfiguration Tasks in the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide.
Note: FINEST-level log messages are recorded in the log folder of the managed server; for example, MIDDLEWARE_HOME/user_projects/domains/domain name/ servers/FinancialClose0/logs/FinancialClose0.out.
Timeout Error Web Services Unavailable Startup Order Financial Close Management Launch from EPM Workspace Financial Close Management Web Application Startup E-Mail Content Errors Language Settings for E-Mail Notifications Financial Close Management User Provisioning Logon Access from E-Mail Domain Configuration RCU Schemas for SQLServer Repeated Warning of Unavailable Bean Deployment to SOA
Note: You can validate your Financial Close Management installation and setup with the FCM
Timeout Error
Issue: The FinancialClose.log file contains this error message:
weblogic.transaction.internal.TimedOutException: Transaction timed out after xx seconds
Solution: Using the WebLogic Administration Console, increase the JTA Timeout setting: 1. Log on to http://host name:7001/console. 2. Select Domain Structure then Services, and then the JTA page. 3. On the JTA tab, change the Timeout Seconds setting to 300. 4. Click Save. 5. Click Activate Changes.
Solution: Check the time on both machines and reset the time on one machine to ensure that the difference between the machines is less than 5 minutes. To see more details about the error, enable OWSM logging. See Enabling OWSM Logging on page 127. For more information, see Chapter 15, Diagnosing Problems, in the Oracle Fusion Middleware Security and Administrator's Guide for Web Services (http://download.oracle.com/ docs/cd/E12839_01/web.1111/b32511/diagnosing.htm#CHDIDCHA).
Startup Order
Issue: Mediators are invalidated because services and servers start in the wrong order.
Note: If you applied a maintenance release, you must follow a new start order for Release
11.1.2.1. Solution: Change the startup type for the services in the following list to Manual, and start the services and servers in this order: 1. WebLogic Administration Server 2. Hyperion Foundation Services - Managed Server 3. Oracle HTTP Server - Oracle Process Manager (ohsInstanceInstance Number) 4. These services in any order:
Oracle Financial Close Management - Web Application Financial Management Web Services Managed Server, if youre using Financial Management with Financial Close Management FDM Web application, if youre using FDM with Financial Close Management Financial Reporting Web application, if youre using Oracle Hyperion Financial Reporting, Fusion Edition with Financial Close Management
5. Oracle SOA Managed Server If the services start automatically, Hyperion Foundation Services - Managed Server and Oracle Financial Close Management - Web Application may start before the WebLogic Administration Server.
Caution!
If you started the SOA server to configure Financial Close Management, stop it before starting Oracle Hyperion Enterprise Performance Management System services.
Solution: Start the Financial Close Management Web application: 1. Log on to the WebLogic Administration Console (http://WebLogic Admin host:WebLogic Admin port/console). 2. On the Domain Structure panel, click Deployments. 3. Check whether the FinancialClose application is in an Active state. 4. If the FinancialClose application state is not Active, start the application by clicking Start and selecting Serving all Requests.
1. Connect to the SOAINFRA schema. 2. Run select * from WFTASKDISPLAY. 3. If the PARTITIONNAME and COMPOSITEVERSION columns do not have the values 'default and 1.0, respectively, run these commands:
update WFTASKDISPLAY set PARTITIONNAME = 'default'; update WFTASKDISPLAY set COMPOSITEVERSION = '1.0'; commit;
3. Rerun EPM System Configurator, and select only the top node of Financial Close Management.
Solution: Verify that the User From Name Filter that is specified for your MSAD security provider is using the correct attribute for your user name (for example, (&(sAMAccountName=%u) (objectclass=user)).
Domain Configuration
Issue: Attempting to deploy the Financial Close Management Web application from EPM System Configurator by extending the existing domain produces this error message:
EPMCFG-10072: Supplied admin user password for the "<domain path>" domain is incorrect. Please review the domain configuration and provide correct user password.
Solution: Add a security folder under domain/servers/AdminServer, and then add a boot.properties file in the security folder. Example of boot.properties file:
username=weblogic (WebLogic admin user name in clear text) password=welcome1 (WebLogic admin password in clear text)
ALTER database <RCU database name> SET READ_COMMITTED_SNAPSHOT ON ALTER database <RCU database name> COLLATE SQL_Latin1_General_CP1_CS_AS
For more information, see Financial Close Management Installation and Configuration Prerequisites and Roadmap in Chapter 3, Installing EPM System Products, in the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide.
Solution: Verify the that all targets for wsm-pm application are also targets for the mds-owsm datasource: 1. Log on to hostname:7001/console.
2. In the left panel, click Deployments, and check the targets listed for the wsm-pm application. 3. Click Data Sources, and check the targets for mds-owsm. 4. Add any wsm-pm application targets that are not already listed for the mds-owsm datasource.
Deployment to SOA
Issue: The SOA log includes error messages about missing columns or a table or view that does not exist. These errors indicate that the SOAINFRA database schema generated by RCU is incompatible with the version of SOA Suite server that is installed. Solution: Ensure that you have installed compatible versions of RCU and SOA Suite.
Tip: Oracle recommends that you download RCU and SOA Suite from the Oracle Enterprise
Performance Management System Media Pack from Oracle E-Delivery (http:// edelivery.oracle.com/) and install them. The media pack contains the correct versions of RCU and SOA Suite. To compare your SOA Suite and RCU versions, check the version.properties files in these folders:
l
Issue: If you run the Deploy to SOA task from Oracle's Hyperion Enterprise Performance Management System Configurator when applying a maintenance release, the task fails with this error message:
Failed deploying composite, status is: 500, error: Error during deployment: Deployment Failed: Unable to find a WSDL that has a definition for service
Solution: Consult the Oracle Hyperion Enterprise Performance Management System Certification Matrix (http://www.oracle.com/technology/software/products/ias/files/ fusion_certification.html), and install the correct SOA server for Release 11.1.2.1.
Note: Ensure that the prerequisites for a maintenance release installation are met. See
Maintenance Release Installation Checklist in the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide. Issue: You cannot configure SOA Server for SQLServer. Solution: Enable XA Transactions at the operating system and SQLServer levels. For more information, see Financial Close Management Installation and Configuration Prerequisites and Roadmap in Chapter 3, Installing EPM System Products, in the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide.
E-Mail Setup Verification Invalid XID Connection Resource Allocation Error Invalid Mediator Schedule Status
verify that the settings are still correct. Issue: You need to ensure that you receive e-mail notifications. Solutions: Use this procedure to verify that you are set up correctly to receive e-mail notifications: 1. In Enterprise Manager, expand the SOA folder. 2. Right-click soa-infra (soa_server1), click Service Engines, click Human Workflow, click Notification Management, and then click Send Test Notification. 3. Enter a SentTo e-mail address, select EMAIL as channel, enter a test message, and click Send. You will receive the test message by e-mail if the settings are correct.
Invalid XID
Issue: This error message is generated when SOA server attempts to connect to the database:
The XID is not valid start() failed on resource '[connection pool]'
This error can occur with JDBC data sources using XA drivers. Solution: Change the XA Transaction Timeout setting for the data source: 1. In the WebLogic Admin Console (http://WebLogic Admin host:WebLogic Admin port/console), select Services, then JDBC, then Datasources, then SOADataSource, and then Transactions. 2. Select Set XA Transaction Timeout. 3. Set XA Transaction Timeout to 0.
java.sql.SQLException: Could not retrieve datasource via JNDI url 'jdbc/ data source' weblogic.jdbc.extensions.PoolDisabledSQLException: weblogic.common.resourcepool.ResourceDisabledException: Pool data source is Suspended, cannot allocate resources to applications..]
This message indicates that you have exceeded the maximum connections allowed in the connection pool for the specified data source. Solution: Increase the capacity of the connection pool: 1. In the WebLogic Administration Console (http://WebLogic Admin host:WebLogic Admin port/console), select Services, then JDBC, and then Datasources. 2. Select your data source, then Connection Pool, and then Maximum Capacity. 3. Edit data source settings to increase their capacity. The recommended setting for the financialclose_datasource setting is 150, but you can use a different number according to your installation requirements.
Invalid Mediator
Issue: An system-automated task fails because an invalid mediator is invoked. The following error is logged in MIDDLEWARE_HOME/user_projects/domains/domain name/servers/managed server name/logs/soa_server1-diagnostic.log:
oracle.fabric.common.FabricInvocationException: Unable to access the following endpoint(s): http://host:8001/soa-infra/services/default/ Mediator100000000002001Composite Note: Mediator composites become invalid when required a Web service that communicates
with the mediators is not running. To determine whether a mediator is invalid, log on to Enterprise Manager (http://WebLogic Admin host:WebLogic Admin port/em), select SOA from the left panel, select soa-infra(soa_server1), and then click the Deployed Composite tab. Solution: Ensure that the startup order for services is correct; see Startup Order on page 128. Then fix the invalid mediator composites: 1. Stop the SOA Suite server. 2. Ensure that the Web service communicating with the mediators (for example, FMWebservices0) is running. 3. Restart the SOA Suite server. If restarting the Oracle SOA Suite server does not fix the invalidated mediators, then reimport the integration XML file (FMIntegrationTypes.xml for Financial Management).
Schedule Status
All issues addressed in this section indicate that tasks have not started as expected. Issue: Schedule status does not change from Pending or reverts to Pending after being set to Open. Solution: A schedule status reverting to Pending indicates that an error occurred when the main orchestration composite to SOA server was created and deployed. Follow these steps to locate and resolve the error: 1. Check MIDDLEWARE_HOME/user_projects/domains/domain name/servers/SOA managed server name/Logs/soa_server1-diagnostic.log for any exceptions in the SOA server at the time the status reverted. An exception might indicate, for example, that the SOA server ran out of memory. 2. Check MIDDLEWARE_HOME/user_projects/domains/domain name/servers/ managed server name/Logs/FinancialClose.log for errors that occurred in the Financial Close Management managed server.
Note: You can increase the logging level to get more debugging information by editing the logging.xml in MIDDLEWARE_HOME/user_projects/domains/domain name/ config/fmwconfig/servers/managed server name. to change the level to TRACE:32.
3. If you see the following NullPointerException in FinancialClose.log, log on to the database and ensure that the TEMPLATE_CONTENT column of FCC_COMPOSITE_TEMPLATES is populated:
Exception NullPointerException has occurred in fcc.model.applicationModule.bpel.CompositeGenerator.generateComposit eArtifacts() [line:120] after the invocation of method: fcc.model.applicationModule.IntegrationTypeManager.handleIntTypeMedi ator() [line:470]
4. Ensure that the SOA managed server and the WebLogic Administration Console server are both running. An error message resembling this one indicates that the SOA managed server is not running:
[2010-07-27T14:14:25.094-04:00] [FinancialClose0] [ERROR] [] [oracle.apps.epm.fcc.model] [tid: 23] [userId: admin] [ecid: 0000IcL7CiR1BhMLUM5Eic1CJPkU0000um,0] [SRC_CLASS: oracle.apps.epm.fcc.model.applicationModule.bpel.CompositeDeployer] [APP: FinancialClose] [SRC_METHOD: m_executeCommand] Can't find resource for bundle java.util.PropertyResourceBundle, key Failed deploying the composite[[ java.net.ConnectException: Connection refused: connect at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333) at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
An error message resembling this one indicates that the WebLogic Administration Console server is not running:
[2010-07-23T16:56:47.266-04:00] [FinancialClose0] [ERROR] [] [oracle.apps.epm.fcc.model]
[tid: 15] [userId: admin] [ecid: 0000Ic160D^2FSYVLqaQOA1CIS1300006t,0] [SRC_CLASS: oracle.apps.epm.fcc.model.applicationModule.SOAServerManager] [APP: FinancialClose] [SRC_METHOD: _initJMXConnector] [[ java.io.IOException at weblogic.management.remote.common.ClientProviderBase.makeConnection(ClientProviderBa se.j ava:195) at weblogic.management.remote.common.ClientProviderBase.newJMXConnector(ClientProviderB ase. java:83) at javax.management.remote.JMXConnectorFactory.newJMXConnector(JMXConnectorFactory.java : 338)
Issue: Tasks do not start after the schedule is set to Open status. Solution: After the schedule is set to Open status, any tasks that have start times in the past and that have no predecessors should change to Open Running status. Ensure that your system is configured correctly. If tasks do not start when the data sources are configured correctly, follow these steps: 1. Log on to the Enterprise Manager console (http://WebLogic Admin host:WebLogic Admin port/em). 2. On the left, expand SOA and then soa-infra (soa_server1). 3. In the Deployed Composites list in the Dashboard on the right, click MainOrchXXXComposite (at the top of the table), which is the composite for the most recently opened schedule.
l
If adminHost and adminPort properties do not exist, then Financial Close Management is not linked to the correct APP_SERVER component, which is WebLogic 10 (APP_SERVER). There must be two instances of APP_SERVER components in the registry. Make a note of the both APP_SERVER component ID, and run these commands to resolve the issue: a. epmsys_registry.bat removelink # Financial Close Management
Product ID # Wrong APP_SEVER Component ID
If the number of instances is zero, which indicates that an error may have occurred during event configuration, verify the EDN setup: a. If SOA server was configured using MS SQL Server, check EDN settings as follows:
Log on to the Oracle Enterprise Manager console (http://WebLogic Admin host:WebLogic Admin port/em), and ensure that the event is set to EDN-JMS mode. Log on to WebLogic Administration Console (http://WebLogic Admin host:WebLogic Admin port/console) and ensure that these conditions are true:
o
EDNDataSource and EDNLocalTxDataSource JDBC data sources are deleted. The EDN-JMS foreign JNDI provider is set up correctly.
b. If the SOA server was configured using Oracle Database, log on to WebLogic Administration Console (http://WebLogic Admin host:WebLogic Admin port/console) , and ensure that the EDNDataSource and EDNLocalTxDataSource data sources are targeted to both the Financial Close Management managed server and the SOA server.
Tip: If you are using Oracle Database, you can check all events published to the SOA
If the number of instances for the main orchestration composite is 1 or greater and you see no other issues with the main orchestration composite, click FCCTaskExecutionComposite, which is the composite that executes each task in the schedule. Check for any Recent Fault and Rejected Messages for the task execution composite in the Dashboard.
Tip: Ensure that the RECORDSTR column of the WL_LLR_FINANCIALCLOSE0 table has
a width of 4000.
l
Check MIDDLEWARE_HOME/user_projects/domains/domain name/servers/ SOA managed server name/Logs/soa_server1-diagnostic.log for exceptions in the SOA server at the time the schedule status was set to Open. An exception in the SOA diagnostic log might indicate, for example, that the business event was not published correctly or that SOA data sources were suspended.
Caused by: java.security.cert.CertificateExpiredException: NotAfter: Thu Aug 26 17:37:01 EDT 2010 at sun.security.x509.CertificateValidity.valid(CertificateValidit y.java:256) at sun.security.x509.X509CertImpl.checkValidity(X509CertImpl.java :570) at sun.security.x509.X509CertImpl.checkValidity(X509CertImpl.java :543) at oracle.wsm.security.jps.WsmKeyStore.getJavaCertificate(WsmKeyS tore.java:505)
This error indicates that the keystore has expired. Recreate it, and then copy the keystore files to the correct Oracle Fusion Middleware config folder. For
instructions, see Configuring the Keystore for Oracle Web Services Manager in the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide.
m
[ecid: 0000IgHXWnOCknYVLqNM8A1CZoZd0000DK,0:1:0x5f5e458:3: 100000862] [APP: soa-infra] <BaseCubeSessionBean:: log error> Error while invoking bean "cube delivery": Exception not handled by the Collaxa Cube system.[[ an unhandled exception has been thrown in the Collaxa Cube systemr; exception reported is: "ORABPEL-00000 Exception not handled by the Collaxa Cube system. an unhandled exception has been thrown in the Collaxa Cube systemr; exception reported is: "Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.2.0.v20091016-r5565): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLException: Internal error: Cannot obtain XAConnection weblogic.common.resourcepool.ResourceDeadException: 0:weblogic.common.ResourceException: Listener refused the connection with the following error: ORA-12516, TNS:listener could not find available handler with matching protocol stack at weblogic.common.resourcepool.ResourcePoolImpl.reserveResourceI nternal(ResourcePoolImpl.java:436) at weblogic.common.resourcepool.ResourcePoolImpl.reserveResource( ResourcePoolImpl.java:332) at weblogic.jdbc.common.internal.ConnectionPool.reserve(Connectio nPool.java:433) at weblogic.jdbc.common.internal.ConnectionPool.reserve(Connectio nPool.java:316) at weblogic.jdbc.common.internal.ConnectionPoolManager.reserve(Co nnectionPoolManager.java:93)
This error indicates that the database server cannot handle the load. Increase the PROCESSES parameter value of the database.
m
This error indicates that the database server cannot handle the load, and the call from SOA timed out. Increase the JTA configuration of this WebLogic Server domain: From WebLogic Admin Server Console, go to the JTA tab, and increase the value of Timeout Seconds.
m
ORABPEL-10509 User not found. User "#error:noapi#" is not found in configuration "jazn.com"...
The most likely cause of this error is that Financial Close Management failed to retrieve user ID from Shared Services. Check the JDBC data source EPMSystemRegistry in your WebLogic Administration Console to ensure that the
138 Financial Performance Management Applications
connection pool is large enough to handle the number of calls to retrieve user IDs. Connection pool size requirements vary, but the connection pool should exceed the number of close tasks that could start at the same time in the close process. For example, if 50 close tasks could start at the same time, then the connection pool size should be greater than 50.
m
Caused by: com.oracle.bpel.client.BPELFault: faultName: {{http://schemas.oracle.com/bpel/ extension}remoteFault}messageType: {{http:// schemas.oracle.com/bpel/extension}RuntimeFaultMessage} parts: {{ summary=<summary>oracle.fabric.common.FabricInvocationExceptio n: Unable to access the following endpoint(s): http:// <hostname>:<port>>/FCC-DataModel-context-root/SOAAMService<// summary> ,detail=<detail>Unable to access the following endpoint(s): http://<hostname>:<port>>/FCC-DataModel-context-root/ SOAAMService</detail> ,code=<code>null</code>
Ensure that all servers in the WebLogic domain have the correct keystore and credential store files. This error usually results from an incorrect keystore setup. If the error remains unresolved, enable OWSM logging to see more details about the error. See Enabling OWSM Logging on page 127.
m
These errors:
MDSConfigurationException encountered in parseADFConfigurationMDS-01330: unable to load MDS configuration document. MDS-01329: Unable to load element "persistence-config" MDS-01370:MetadataStore configuration for metadata-store-usage "OWSM_TargetRepos" is invalid. MDS-00922: The ConnectionManager "oracle.mds.internal.persistence.db.JNDIConnectionManagerImpl" cannot be instantiated. MDS-00929: Unable to look up name "jdbc/mds/owsm" in JNDI context While trying to lookup 'jdbc.mds.owsm' didn't find subcontext 'mds'. Resolved 'jdbc'
In WebLogic Administration Console, verify that wsm-pm is targeted only to the SOA managed server.. Also verify that the JDBC data source mds-owsm is targeted to AdminServer and the SOA managed server.
m
In a browser, open http://soa-host:soa-port/wsm-pm/validator (for example, http://localhost:8001/wsm-pm/validator) to verify that your OWSM configuration is correct. If the OWSM configuration is correct, the message Policy Manager Status: Operational is displayed with a list of supported security policies. If the policy manager status is not operational, check the settings in WebLogic Administration Console. Common OWSM configuration errors include having the application wsm-pm deployed to multiple targets and not targeting the JDBC data source mds-owsm correctly. The application wsm-pm should only be targeted for the SOA managed server.
m
java.sql.SQLException: Unexpected exception while enlisting XAConnection java.sql.SQLException: XA error: XAResource.XAER_NOTA start() failed on resource 'SOADataSource_EPMSystem': XAER_NOTA : The XID is not valid.
For a JDBC data source that uses XA drivers, use WebLogic Administration Console to verify that XA Transaction Timeout is enabled and XA Transaction Timeout is set to 0. Issue: A task is changed to Error status. Solution: Log on to Oracle Hyperion Financial Close Management, and click the History tab. A row on the History tab displays the detailed error message.
Disclosure Management
Issue: The Oracle Hyperion Disclosure Management Add-in is unavailable in Microsoft Word and Excel. This issue occurs if you do not select .NET programmability support for Microsoft Word and Excel when you install Microsoft Office. Solution: If you have the required Primary Interop Assemblies (PIAs) for Microsoft Office, open the Windows Control Panel and change the settings for Word and Excel: 1. Select Microsoft Office from the list of installed programs, and click Change. 2. Select Add or Remove Features, and click Continue. 3. In the Installation Options panel: a. Double-click Microsoft Office Excel, then click the arrow to the left of .NET programmability support and select Run from My Computer. b. Double-click Microsoft Office Word, then click the arrow to the left of .NET programmability support and select Run from My Computer. c. Click Continue. If you do not have the PIAs, use one of these links to a Microsoft Web site to download and install them for your version of Microsoft Office:
9
In This Chapter
Data Management
Data Management Product Upgrades.................................................................. 143 FDM ....................................................................................................... 143 ERP Integrator ............................................................................................ 146 Data Relationship Management ........................................................................ 147
FDM
Subtopics
l l l l l l l l l
Shared Services Registration Failure ERP Integrator Process Failure Configuration with Financial Management Oracle Client-Provider Database Connection Failure Database User ID or Password User Authentication Failure Bulk Insert Failure Active-X Component Error Application Creation Access Error
Solution: Synchronize the date and time on the FDM and the Shared Services servers. The Shared Services registration process uses an SSO Token, which requires an accurate datetime stamp to permit authentication. For example, if the dates on the FDM and the Shared Services servers differ by a day (excluding any time zone differences), authentication fails because Shared Services rejects an outdated CSS token.
Solution: Follow these steps: 1. Create a file named registry in the ODI_HOME/lib/scripting folder. 2. Insert this line in the registry file:
python.security.respectJavaAccessibility = false
Solution: Update the machine profile in the Workbench to point to the Financial Management cluster that is registered on the FDM application servers. In the profile, the setting for the target system server or cluster must exactly match what you set up for Oracle Hyperion Financial Management, Fusion Edition, or they cannot communicate.
Solution: Correct outstanding Oracle issues, and ensure that you can resolve the Oracle Service Name in tnsnames.ora.
Note: All values in tnsnames.ora are case-sensitive.
FDM 145
You have change permissions to the FDM application path \\servername\fdmshare \fdmappname. Microsoft Excel is installed on the FDM Web application tier. FDM server requires Excel for many functions, including schema update, journals, multiload, templates, and exporting grids.
ERP Integrator
Subtopics
l l
The aif.ear file is not copied to ERP Integrator server. The aif.ear file does not exist on the WebLogic server in the environment.
The aif.ear file must be on the same machine as WebLogic. Solution: Install Oracle Hyperion Financial Data Quality Management ERP Integration Adapter for Oracle Applications on the WebLogic Administration Server machine and then redeploy the Web application.
Web Client Access Failure Inaccessible Online Help Failure To Initialize JVM Creation Error Invalid Classpath Root Data Relationship Management Server Startup Error Message During Upgrade
Solution: In the IIS configuration file (C:/Windows/System32/inetsrv/config/ applicationHost.config), replace the two occurrences of Deny in the following section with Allow:
<configuration> <configSections> <sectionGroup name="system.webServer"> <section name="handlers" overrideModeDefault="Deny" /> <name="modules" allowDefinition="MachineToApplication" overrideModeDefault="Deny" />
Solution: Install IIS 6 Metabase Compatibility on the server: 1. Click Settings, and then Control Panel. 2. Select Programs and Features.
3. Click Turn Windows features on or off. 4. Under Roles, select Web Server (IIS). 5. Under Role Services, select IIS 6 Metabase Compatibility and click OK.
Failure To Initialize
Issue: You receive a message that Data Relationship Management has failed to initialize when the AuthMode System Preference is set to Mixed or CSS. Solution: Ensure that these conditions are met:
l
Any firewall software is configured so that communication with the host specified in the CSS Bridge Host field is possible. The JVM path is set to a valid JVM DLL; for example, C:\Oracle\Middleware \EPMSystem11R1\common\JRE\Sun\1.6.0\bin\server\jvm.dll. The Oracle Instance field is set to a valid Oracle instance on the CSS tab in the DRM Console; for example, C:\Oracle\Middleware\user_projects\epmsystem1. The Class Path tab includes the required JAR files; for example:
m
The database is running for the Shared Services instance. The Oracle DRM Server Processes service is running on the host machine for which CSS is enabled. CSS Bridge host is running. CSS Bridge service is running.
Enable CSS and restart the service: 1. On the Common Security Services page, click Enable CSS. 2. Restart the service. Ensure that the Java path is correct. Ensure that Oracle's Hyperion Shared Services is installed locally.
If you changed the classpath or system path, reboot the computer. Change the authentication mode to Internal, and restart the server. A successful start confirms that the issue is related to CSS. Check the Event Log for error messages.
Index
A
about troubleshooting, 11 access Architect Dimension Server Web services, 103 Financial Management applications, 121 products from Shared Services, 90 Reporting and Analysis modules, 81 application server startup failure, Shared Services, 90 application server deployment failure without configuration errors, 73 Architect accessing Dimension library or Application library, 102 accessing server Web services, 103 displaying Dimensions Library, 102 displaying tasks, 102 errors on server, 103 IIS startup on Architect Dimension Server, 103 installation failure, 100 logon, 101
Financial Data Management, 143 Financial Management, 120 Planning, 118 user directories and Shared Services, 88 configtool.log, 17 configtool_err.log, 17 configuration Data Relationship Management, 148 error log, 17 exceptions, logged, 17 Financial Data Management, 144 general tips, 69 validation, 17 connection failure Essbase client-server, 109 Financial Management, 122 general, resolving, 75 OLAP Metadata Catalog or external data source, 110, 123 Oracle NET, 114
B
BEx query unavailable, Web Analysis, 116 Business Rules logs, 50
D
Data Relationship Management common issues, 147 configuration issues, 148 invalid classpath root, 149 server startup failure, 149 unable to create JVM, 148 Data Relationship Management logs, 54, 56 deployment failure without configuration errors, 73 Disclosure Management Add-in, 140 documentation, 12
C
Calculation Manager, 34 cannot authenticate user, Financial Data Management, 145 cannot connect to Oracle database, Financial Data Management, 144 cannot perform bulk insert, Financial Data Management, 145 common issues Architect, 99 Data Relationship Management, 147
E
EPM System Configurator Web server configuration, 70
Index 151
EPM System Configurator startup, 70 EPM System Installer extraction on Solaris, 66 startup failure, 66 EPM system Installer freeze, 67 EPM System Installer files, 64 EPM System Installer shutdown, 63 ERP Integrator logs, 55 ERP Integrator ODI process failure, 144 error messages Essbase Administration Services, 91 Essbase load with Interactive Reporting, 114 Financial Data Management, 144 Financial Management, 92 JVM on UNIX, 78 out-of-memory, 75 Essbase application creation failure, 92 failover, 109 load failure, Interactive Reporting Studio, 114 server startup failure, 107 server-client connection, 109 troubleshooting, 105 Essbase Administration Services refreshing security to Shared Services, 91 use with Planning, 118 with Shared Services, 91 Essbase Integration Services OLAP or data source connection failure, 110 Essbase Integration Services logs, 49 Essbase logs, 34, 35 Essbase Server startup failure, 107 external user directories, 88
F
failover logs, 37 failure accessing Financial Management from Workspace, 121 application server deployment, 73 Architect Dimensions Library, displaying, 102 Architect tasks, displaying, 102 connection to OLAP Metadata Catalog or data source, 110
Data Relationship Management server startup, 149 Hyperion EPMA Server service, starting, 101 IIS startup on Architect Dimension Server, 103 login, Financial Management, 122 Oracle Procedure, processing, 114 Reporting and Analysis modules, accessing, 81 Shared Services startup, application server, 90 Financial Close Management e-mail notifications language settings, 130 setup verification, 133 invalid XID error message, 133 Financial Data Management cannot perform bulk insert, 145 common issues, 143 configuration issues, 144 Oracle/Client provider connection, 144 user authentication, 145 Financial Data Management logs, 54 Financial Management access from Workspace, 121 accessing, 121 and JRF WebServices Asynchronous services, 126 and Shared Services logging, 97 common issues, 120 connection failure, 122 EnableServerLocking option, 125 error messages, 92 installation failure, 123 large data or file loads, 125 logon failure, 122 rights for installation, 125 SQL Server connection failure, 123 troubleshooting, 96 use with Shared Services, troubleshooting, 92 Financial Performance Management applications Architect, accessing Dimension library or Application library, 102 common Architect issues, 99 common Financial Management issues, 120 establishing the SQL Server connection using TCP/ IP, 124 performance issues, 118 Planning with Administration Services, 118 troubleshooting connection issues, 122
152 Index
Financial Performance Management Applications logs, 47 Financial Reporting Studio runtime and ActiveX errors, 115 Foundation Services logs, 32
H
host name changes, 69
I
installation Architect, failure, 100 Financial Management, failure, 123 rights for Financial Management, 125 validation, 17 installation after uninstallation, 67 installation documentation, 12 Installation Start Here, 15 Interactive Reporting logs, 46 Interactive Reporting Studio data truncation, 115 Essbase load failure, 114 Oracle Net connection, 114 Oracle procedures, processing, 114 invalid classpath root, Data Relationship Management, 149
J
Jave heap size changes, 70 JVM error, UNIX, 78
K
knowledge base, My Oracle Support (MetaLink 3), 18
setting for Data Relationship Management, 57 setting for ERP Integrator, 56 setting for Performance Scorecard, 53 setting for Planning, 52 login Architect, 101 Financial Management, 122 Shared Services, improving performance, 87 Workspace, 101 logs, 41 Business Rules, 50 configuration, 17 configurator, start and stop, 31 Data Relationship Management, 54, 56 ERP Integrator, 55 Essbase, 34, 35 Essbase Integration Services, 49 Financial Data Management, 54 Financial Performance Management Applications, 47 Interactive Reporting, 46 ODL, install, 28 other formats, 49 overview, 17 Performance Scorecard, 53 Planning, 52 Provider Services, 37 remote and local logging, 43 remote logging, backing up, 44 Reporting and Analysis, 41, 45 Smart View, 33 Strategic Finance, 54 upgrade, 30 using EPM System logs, 19 Web Analysis, 46
L
Lifecycle Management diagnostics, 95 log files ODL, 19 logger levels, dynamically changing, 45 logging levels changing for Interactive Reporting, 47 for Business rules, 51 increasing in Oracle Enterprise Manager, 18
M
memory errors, 75 MetaLink 3, 18 missing JAR files, 72 multibyte characters, 119 My Oracle Support, 18
O
ODI process failure, 144 ODL
Index 153
configuration files, 20 location, 25 message types, 24 modifying, 24 properties, 21 structure, 20 installation logs, 28 log files common log file naming, 27 structure, 27 log messages format, 27 ODL files, 19 Oracle HTTP Server and Essbase, in a distributed environment, 65 installation failure, 65 installation prerequisites, 64 Oracle procedure, processing, 114 Oracle support services, 28 other logging formats file size, 49 performance issues, 49 system performance, 49 out-of-memory errors, 75
system requirements, satisfying, 15 Product Selection panel, 65 Provider Services logs , 37 provisioning, 88 best practices, 87
R
Reporting and Analysis Framework service and servlet log files, 42 release compatibility, 16 Remote Diagnostics Agent, 83 Reporting and Analysis logs, 45 Reporting and Analysis logs, 41 restarting services, 75 runtime and Active X errors Financial Reporting Studio, 115
S
server startup failure, Data Relationship Management, 149 services Architect Process Manager, startup, 101 start and restart, 75 Windows, verifying, 75 Shared Services application server startup failure, 90 external user directories, 88 failure accessing products from, 90 load performance, increasing, 88 login performance, improving, 87 logon failure, 84 Registry Editor, 86 running Remote Diagnostics Agent, 83 troubleshooting, 83 troubleshooting utility, 86 user provisioning best practices, 87 user provisioning, troubleshooting, 87 using with Financial Management, 92 using with Integration and Administration Services, 91 Shared Sservices database first-time configuration, 71 Smart View logs, 33 SQL Server, establishing a connection using TCP/IP, 124 starting services, 75
P
performance degradation with products offline, 83 Performance Management Architect common issues, 99 Performance Scorecard logs, 53 Planning common issues, 118 multibyte characters in reports, 119 with Essbase Administration Services, 118 Planning logs, 52 port conflicts avoiding, 16 defaults for all products, 15 prerequisites, 11 configuration, validation, 17 installation guide, reviewing, 16 Installation Start Here, reviewing, 15 installation, validation, 17 logs, reviewing, 17 port, avoiding, 16 readme, reviewing, 16 release compatibility, validating, 16 startup dependencies, reviewing, 16
154 Index
startup dependencies, 16 startup failure Essbase Server, 107 IIS on Architect Dimension Server, 103 Strategic Finance logs, 54 support, accessing, 18 system requirements, 15
T
technical support, 18 troubleshooting for Financial Management, 96 for Reporting and Analysis, 95
U
unable to create JVM, Data Relationship Management, 148 UNIX JVM error, 78 Upgrade issues, 68 upgrades, 16, 30, 79 user authentication, Financial Data Management, 145 user directories, using with Shared Services, 88 user provisioning, 83 best practices, 87 troubleshooting, 83, 87
V
validation, installation and configuration, 17
W
Web Analysis logs, 46 Web server configuration, 70 ewallet.p12 file, 71 failure on AIX, 76 IIS, 70 Welcome panel warning messages, 67 Workspace accessing Financial Management from, 121 logon security rights, 101
Z
ziplogs utility, 19
Index 155
156 Index