IBM Support

"Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG))" error when launching Excel-related functionality, due to MS Office not being installed

Troubleshooting


Problem

User launches the 'main' Controller client (CCR.EXE) and then clicks any of the buttons which launch an Excel-related function, for example:

  • X = 'Controller Link'
  • "Maintain - Form Structure - Define" and then 'Run'

An error appears.

Symptom

image 2253

Retrieving the COM class factory for component with CLSID {00024500-
0000-0000-C000-000000000046} failed due to the following error:
80040154 Class not registered (Exception from HRESULT: 0x80040154
(REGDB_E_CLASSNOTREG)).
   at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean
publicOnly, Boolean noCheck, Boolean& canBeCached,
RuntimeMethodHandleInternal& ctor, Boolean& bNeedSecurityCheck)
   at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean
skipCheckThis, Boolean fillCache, StackCrawlMark& stackMark)
   at System.Activator.CreateInstance(Type type, Boolean nonPublic)
   at System.Activator.CreateInstance(Type type)
   at Cognos.Controller.Forms.Common.fFrmFrangoFunc.GetExcelApplication
(String sText, Object& startedFromCode, Int32 excelProcessId)
   at Cognos.Controller.Forms.Common.fFrmFrangoFunc.InitExcelLink
(Object& xlApp, String sText, Int32 excelProcessId)
   at Cognos.Controller.Forms.ControllerMDI.DoAction(Int32
iMenuIDNumber, ControllerMenuItem ClickedItem)

Cause

There are several known causes for this error.

  • TIP: See separate IBM Technote #0729489 for more examples.

This Technote specifically relates to the scenario where the cause is that the client device  does not have Microsoft Excel installed.

More Information

Controller client requires Microsoft Excel (for example as part of Microsoft Office) installed on the client device.

  • TIP: Search for 'Cognos Controller supported environments' to find out the supported versions of Excel (for your version of Controller).

Resolving The Problem

Install Microsoft Excel (typically as part of Microsoft Office) on the client device.

  • TIP: Search for 'Cognos Controller supported environments' to find out the supported versions of Excel (for your version of Controller).

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSPMZC","label":"Cognos Consolidator"},"Component":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.3.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
04 February 2020

UID

ibm10729463

Page Feedback