IBM Support

Error connecting to Planning Analytics from PA for Excel

Troubleshooting


Problem

An error message is displayed in Planning Analytics for Excel after the environment to connect to is chosen, and before the login prompt comes up.

Symptom

Error Message:
The application has failed to start because its side by side configuration is incorrect. Please see the application event log or use the command line sxstrace.exe tool for more detail. (Exception from HRESULT: 080073681)
Details:
System.Runtime.InteropServices.COMException (0x800736B1): The application has failed to start because its side-by-side configuration is incorrect. Please see the application event log or use the command line sxstrace.ex tool for more detail: (Exception from• HRESULT: 0x800736B1)
  at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRIntemal(Int 32 errorCode. IntPtr errorInfo)
  at Microsoft.Web.WebView2.Core.CoreWebView2Environment.<CreateCoreWebView2ControllerAsync>d_54. MoveNext()
- End of stack trace from previous location where exception was thrown
  at System.Runtime. ExceptionServices.ExceptionDispatchInfo. Throw()
  at. System.Runtime.CompilerServices.TaskAwaiter. HandleNonSuccessAndDebuggerNotification(Task task)
  at Microsoft.Web.WebView2.Wpf.WebView2.<>c_DisplayClass27_0. <<EnsureCoreWebView2Async>g_Init|(((0>d.MoveNext()
:
:
:
PAfeError
Application Event Viewer log entry:

Source: SideBySide
Activation context generation failed for "C:\Program Files (x86)\Microsoft\EdgeWebView\Application\109.0.1518.52\msedgewebview2.exe". Dependent Assembly
nnn.n.nnnn.nn,language="&#x2a;",type="win32",version=" nnn.n.nnnn.nn" could not be found. Please use sxstrace.exe for detailed diagnosis.
Event

Cause

Planning Analytics for Excel user profile got corrupted.

Resolving The Problem

  1. Make sure that Excel is closed so no Excel process is running
  2. Navigate to the "Office Connection" folder in the user's profile in Windows. For instance: "C:\Users\userprofile\AppData\Local\Cognos\Office Connection
  3. Rename the "Office Connection" folder to "Office Connection_old"
  4. Launch PA for Excel and connect to the PA instance -- this step will generate a new Office Connection directory

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCTEW","label":"IBM Planning Analytics Local"},"ARM Category":[{"code":"a8m50000000KzLFAA0","label":"Planning Analytics-\u003EPlanning Analytics For Microsoft Excel-\u003EModel and Reporting"}],"ARM Case Number":"TS011879502","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]

Document Information

Modified date:
29 June 2023

UID

ibm17008321