BizTalk BAM activity Deploy problem – Old format or invalid type library. (Exception from HRESULT: 0x80028018 (TYPE_E_INVDATAREAD)).

When trying to deploy BAM activity: “C:\Program Files\Microsoft BizTalk Server 2009\Tracking>bm.exe deploy-all -DefinitionFile:BAMSample.xls”, you can get “Old format or invalid type library” error:

Microsoft (R) Business Activity Monitoring Utility Version 3.8.368.0 Copyright (C) 2006 Microsoft Corporation.  All rights reserved.
Using ‘BAMPrimaryImport’ BAM Primary Import database on server ‘…’…
ERROR: Failed to open BAM Excel workbook file – ‘C:\Program Files\Microsoft BizTalk Server 2009\Tracking\MyBAMSample.xls’. Old format or invalid type library. (Exception from HRESULT: 0x80028018 (TYPE_E_INVDATAREAD))

Cause

  • When you use a locale setting other than English (United States) while installing the English version of BizTalk Server, your deployment of the Bam.xls file generates a “fnGetString” or “Old format or invalid type library” error.

Solution

  • Change the computer locale to English (United States) and re-run the bm deploy command at the command prompt.
  • To change your computer locale to English (United States)
    • Click Start, click Control Panel, and then click Regional and Language Options.
    • In the Regional and Language Options dialog, on the Regional Options tab, choose the English (United States) locale from the drop-down box, and click OK.

Other Possible Solution

  • To work around this problem, you can either install the Office Multilingual User Interface (MUI) pack which can be found on http://www.microsoft.com/ or change your locale to US-EN just for the duration of the deployment.

Tags: BizTalk | BAM | Deploy | Errors and Warnings, Causes and Solutions

Author: Sandro Pereira

Sandro Pereira lives in Portugal and works as a consultant at DevScope. In the past years, he has been working on implementing Integration scenarios both on-premises and cloud for various clients, each with different scenarios from a technical point of view, size, and criticality, using Microsoft Azure, Microsoft BizTalk Server and different technologies like AS2, EDI, RosettaNet, SAP, TIBCO etc. He is a regular blogger, international speaker, and technical reviewer of several BizTalk books all focused on Integration. He is also the author of the book “BizTalk Mapping Patterns & Best Practices”. He has been awarded MVP since 2011 for his contributions to the integration community.

Leave a Reply

Your email address will not be published. Required fields are marked *

BizTalk360
BizTalk Server

Over 500+ customers across
30+ countries depend on BizTalk360

Learn More
Serverless360
Azure

Manage and monitor serverless
components effortlessly

Learn More
Atomicscope
Business Users

Monitor your Business Activity in iPaaS
or Hybrid integration solutions

Learn More

Back to Top