SAP Knowledge Base Article - Public

2729036 - Installation of Microsoft DebugDiag 2 and Recording of Excel Dump File

Symptom

This document explains how to install the Microsoft Debug Diagnostic Tool V2 and record an Excel Dump File.

Environment

SAP BusinessObjects Analysis, edition for Microsoft Office

Resolution

  1. Please go to following URL and download “Debug Diagnostic Tool v2 Update 2”:
    >> https://www.microsoft.com/en-us/download/details.aspx?id=49924
    Note: you can also download the x64 (64 Bit) variant if you are using an x86 (32 Bit) Office.

  2. Install the tool;

  3. Open the "DebugDiag 2 Collection" application from your start menu;
  4. When opening the tool for the first time it should automatically bring up the "Select Rule Type" dialog.
    If this is not the case, click on "Add Rule…" button at the bottom of the dialog.

  5. Select "Crash" as rule type and click on "Next >":

    Debug - crash dialog.png
  6. Choose "A specific process" and press on "Next >":

    Specific process.png

  7. If Excel is currently running you can simply select it from the list of running processes. Otherwise you can just insert EXCEL.EXE in the "Selected Process" TextBox. Afterwards click on "Next >":

    Excel process.png
  8. The "Advanced Configuration" dialog will appear. Keep the default values and click on "Next >":

    Advanced config.png

  9. Optionally you can define a rule name and change the output location for the Dump files. Please remember the "Output Location" as you will need the output for the SAP case. Then click on "Next > ":

    dump location.png
  10. Select the "Activate the rule now" option and click on "Finish". The rule is now active;

  11. Reproduce the Excel crash. Afterwards you should be able to see an increased "Userdump Count":

    Dump count.png
  12. Zip the complete content of the "Output Location" and upload it to the OneDrive / SharePoint URL provided by the SAP employee processing the case;

  13. After the issue was reproduced and the Dump file collected, remember to delete or at least to deactivate the rule previously configured:

    deactivate rule.png

Keywords

dump, excel, microsoft, debugdiag, trace, error, crash , KBA , BI-RA-AO-XLA , Excel Addin , How To

Product

SAP Analysis for Microsoft Office all versions