‘TYPE_E_LIBNOTREGISTERED’ Error

Symptom

When you try to sign in to the SAP system, Process Runner was not able to make a successful call to SAP and error messages similar to the following are displayed:

A-108: Process Runner

Unable to cast COM object of type ' System.__ComObject' to interface type 'Microsoft.Office.Interop.Excel. Application’. This operation failed because the Query Interface call on the COM component for the interface with IID '{00020970-0000-0000-C000-000000000046}' failed due to the following error: Library not registered. (Exception from HRESULT: 0x8002801D (TYPE_E_LIBNOTREGISTERED))”, error message is the Microsoft Office Interop error.

FM:73 Process Runner

FM: 73 Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.Office.Interop.Excel.Workbook'. This operation is failed because the QueryInterface call on the COM component for the interface with IID '{000208DA-0000-0000-C000-000000000046}' failed due to '{000208DA-0000-0000-C000-000000000046}' failed due to following error : Library not registered. (Exception from HRESULT: 0x800280 1D (TYPE_E_LIBNOTREGISTERED)).

FM:73 Process Runner

FM:46 EM:3 Return argument has an invalid type.

Cause

This problem occurs due to incorrect COM Interop settings in the Windows registry or the leftover registry key if you have downgraded your version of Microsoft Office.

Solution

To resolve this issue, do one of the following:

  • Repair Microsoft Office installed on your system
  • Download 'FixExcelRegistryIssue' tool and fix the registry key issue
  • Fix inconsistencies in Windows Registry

The steps to repair Microsoft Office vary depending on your Windows operating system. For more information about how to repair Microsoft Office, see Microsoft documentation.

To fix Excel registry using FixExcelRegistryIssue tool, do the following:

  1. Download the FixExcelRegistryIssue tool.
  2. Extract the FixExcelRegistryIssue.zip file.
  3. Right-click the FixExcelRegistryIssue setup and select Run as administrator. The Fix Excel Registry Issue windows is displayed.
  4. Select Fix > Yes. The registry key issue is fixed.

To fix inconsistencies in Windows Registry, do one of the following:

  • Delete the incorrect registry key
  • Fix the incorrect Excel file path

To delete the incorrect registry key

  1. Open Run box, type Regedit, and then select OK. The Registry Editor window is displayed.
  2. Expand the HKEY_CLASSES_ROOT folder and search for the key that you have received in the error message.
  3. Expand the key and select TypeLib.
  4. Double-click Default and copy the Value data key displayed in the Edit String window.
  5. Expand HKEY_CLASSES_ROOT > TypeLib table and search for the key that you copied in the preceding step.
  6. Expand the key and select extra sub-folder. For example, if 1.7 is the main folder, then select 1.8 and delete the folder.

To fix the incorrect Excel file path

  1. Open Run box, type Regedit in the Open box, and then select OK. The Registry Editor window is displayed.
  2. Depending on whether you installed a 32-bit or 64-bit version of windows, navigate to HKEY_CLASSES_ROOT > TypeLib.
  3. Double-click the (Default), and in the Edit String window update the Value data field with the current path where you have installed Microsoft Office.
  4. Select OK.

Note: The registry key 1.8 may vary based on the Microsoft Office version you have installed.