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.
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.

BizTalk360
BizTalk Server

Over 650+ customers across
30+ countries depend on BizTalk360

Learn More
Serverless360
Azure

Operate efficiently with enterprise-grade Azure monitoring,
tracing, remediation & governance in one platform

Learn More

Back to Top