BI Platform Root Cause Analysis Wiki

This SDN WIKI space documents techniques for performing root cause analysis and troubleshooting techniques using tools including: Solution Manager Diagnostics CA Wily Introscope BI Platform Monitoring Log Viewers 3rd Party Tools & Utilities   Please note this wiki is a work in progress.  Some links are still under construction

Solution Manager Diagnostics  Important Documentation Documents for configuring and implementing Solution Manager for BI Platform 4.x SolMan 7.1: Managed Sys Setup - BI Platform 4.0 SolMan 7.1: Managed Sys Setup - BI Platform 4.1 Solution Manager 7.1 BI Monitoring Pre-requisites 1833501 - Diagnostics Agent - Installer Versions BI 4.x Managed System Setup Tutorial Solman Root Cause Analysis Features for BI Platform 4.x How to troubleshoot BI 4.x SLD data supplier issues Troubleshooting Solution Manager Root Cause Analysis for BOE Solution Manager 7.1 SDN Home Solution Manager 7.1 Documentation Guide for cleaning up duplicate entries in SLD 1766713 - Re-Synch from SLD not possible due to missing data supplier    Tutorials   Tutorials for performing root cause analysis tasks with Solution Manager and SAP BI Platform 4.x Prepare BW for E2E tracing with BI Platform BI Platform E2E tracing with Solution Manager E2E Trace Tutorials Coming Soon.... Finding performance bottlenecks in BI Platform with E2E Workload Analysis Checking the performance of CMS system database with DBA Cockpit Checking for system changes with E2E Change Analysis Triggering and analyzing a BI Platform Java thread dump Triggering and analyzing a BI Platform Java heap memory dump Identifying recurring problems with E2E Exception Analysis How to analyze the BI Platform EarlyWatch Alert report Guide to BI Platform Alerts in System Monitoring Workcenter How to access Solution Manager Root Cause Analysis Workcenter

CA Wily Introscope  Important Documentation Documents for configuring and utilizing CA Wily Introscope for BI Platform 4.x Wily Introscope for BI Platform 4.0: Why it is important and how to get started A complete guide to setup CA APM Introscope 9 for monitoring SAP BI Platform 4.1 on Windows Installing the Solution Manager Diagnostic Agent in stand-alone mode on Linux (x86) How to configure the Introscope Java Agent 9 on Websphere Application Server Note 1540591: Wily Introscope Setup for SAP BOE 4.0 Note 1825993: How to perform a silent install of the SMD Agent for BI Platform 4.0 in stand-alone mode Introscope Troubleshooting Introscope Configuration and Administration Guide Introscope Workstation User Guide Wily Introscope 8 Installation Guide CA APM Introscope 9 Installation Guide CA APM Introscope 9 Sizing Guide How to increase the length of time in which Wily Introscope stores performance data 2138346 - How do I specify the location of the CA APM Introscope SmartStor metric database?  SCN Blogs Useful blogs on Wily Introscope Dashboards and RCA Web Intelligence: Memory Leak or Sizing Issue? Read between the lines with Wily Introscope Diagnostics in SAP BI 4.0 - What's it all about? Why adopt Wily Introscope for BI monitoring?   Tutorials   Tutorials for performing root cause analysis tasks with CA Wily Introscope and SAP BI 4.x Capturing an E2E Transaction Trace using SAP Passport Meet The Experts - BI Platform 4.0: Monitoring performance with Wily Introscope and SAP EarlyWatch Alert Analyzing the performance of Apache Tomcat Finding performance bottlenecks in the Adaptive Processing Server Using SapOsCol to check system resources of each node in the BI landscape

BI Platform & Third Party Tools   BI Monitoring Application   Tutorials for performing root cause analysis tasks with the BI Platform Monitoring Application How to monitor the availability of a BI Platform 4.0 server using the BI Monitoring application How to configure an InfoView Probe for SSL (https) SAP BusinessObjects 4.0 Monitoring Configuration - Part(1) SAP BusinessObjects 4.0 Monitoring Configuration - Part(2) SAP BusinessObjects 4.0 Monitoring Configuration - Part(3) BusinessObjects Servers monitoring and their executables path How is the Health State metric calculated? SAPOSCOL Overview and Unix Installation for BI Monitoring  Important Documentation Useful documents for BI Platform Monitoring Understanding "Health State" in the BI Platform Monitoring Application and Repairing Broken Watches Developing and deploying a custom Java probe in BI Platform 4.0: Tutorial & Sample Five Important Things Every BI4 Administrator Should Know About the BI Monitoring Application BI Platform Administration - What to monitor? How to configure Tomcat to use SAP JVM instead of Oracle JVM How to install the SAP Host Agent for BI Platform Host Monitoring What do the memory related metrics mean when analyzing the Adaptive Processing Server?   E2E Tracing without Solution Manager Download SAP Client Plug-in Customer instructions and best practice for collecting a BI Platform 4.x end to end trace How to: E2E tracing using Introscope Transaction Tracer, SAP Passport, and the BI Platform Support Tool Using End to End Trace to troubleshoot the BI Platform Scheduling Workflow   Log Viewers & Problem Analysis SAP provided tools for performing Root Cause Analysis on BI Platform Generate a Landscape Analysis Report with SAP BI Support Tool 2103024 - *** MASTER NOTE *** How To Trace Business Objects 4.0 and 4.1 (Servers and Clients) Analyzing end to end traces to identify root cause with Web Intelligence workflow BOE and Data Services Patch History Analysis Tool Using JVMTOP and JVMMON to analyze SAP JVM CPU bottlenecks Download GLF Viewer (Requires S-USER logon) How to generate and consume an E2E trace with BI4.x (for non-SolMan landscapes) XI 3.1 SI_FILES Integrity Checker

SAP BI Platform Support Tool  Generate Landscape Analysis Report E2E Trace Wizard (automatic log collection, bo_trace.ini override) SAP Passport Decoder Change Analysis Tool Server comparison and inspection Alert Summary Microsoft Sysinternals   These tools allow low level analysis of process activities occurring on the Windows Operating System Process Monitor Process Explorer Handle Process Monitor TCPView Process Explorer (coming soon) Wireshark / Packet Capture Capture server to server communications filter traces by protocol, IP address, port number, etc Extremely helpful for communications between different products over a network WireShark KBA 1969914 Wireshark direct download Wireshark external tutorial  Strace Troubleshooting BI on Linux with strace GLF Log Readers Flexible Log Reader SAP Client Plugin How to generate and consume E2E trace with BI 4.x Fiddler Fiddler    SAP Netweaver (BW) transactions related to BI integration These transactions are common and helpful transactions that can be used to help troubleshoot issues related to various reporting and configurations within the BI suite. ST01 RSTT MDXTEST SE37 - /Crystal/* functions  Useful SAP transactions related to troubleshooting BI  JMeter   BI4 Web Intelligence Performance Test with JMeter Introduction to Apache JMETER SAP BusinessObjects Performance Testing with Apache JMeter Repository Diagnostic Tool (RepoScan) Identify / clean up orphaned InfoStore objects Identify orphaned File Repository contents BOE and Data Services Patch History Analysis Tool  Identify the following information on a BusinessObjects system Which products and patches were installed What order were they installed What date/time it was installed Was it an install, uninstall, repair Which user installed it What was the build number What is the setup language Was the installation committed successfully to the manifest JVMTOP Analyze CPU consumption by Java threads in real-time command line interface   Dependency Walker Find missing dependency files for executables and DLLs Find invalid or mismatched dependency files