You are currently offline, waiting for your internet to reconnect

FIX: "The attribute key cannot be found when processing" error when you run a BAM SSIS package in BizTalk Server

SYMPTOMS
Consider the following scenario:
  • You create and then deploy a Business Activity Monitoring (BAM) activity on a computer that is running Microsoft BizTalk Server 2009 or Microsoft BizTalk Server 2010.
  • The BAM activity tables of the BAMPrimaryImport database have at least one NULL value for a milestone in a date dimension.
  • You run the BAM Microsoft SQL Server Integration Services (SSIS) package to process the date dimension.
In this scenario, you receive an error message that resembles the following:
Errors in the OLAP storage engine: The attribute key cannot be found when processing: Table: 'bam_<activity name>_ActiveFacts', Column: '<column name>_ID', Value: '0', The attribute is '<column name>_ID'.

RESOLUTION
To resolve this issue, follow these steps:
  1. Apply the following cumulative update package.
  2. Re-create the scheduled aggregation views if the data in the existing dimension is not important. If the data in the existing dimension is important, create new BAM views.

    Note The new views are created from all the data in the BAMPrimaryImport database.

Cumulative update information

BizTalk Server 2010


For more information about how to obtain the cumulative update package, click the following article number to view the article in the Microsoft Knowledge Base:
2497789 Cumulative update package 1 for BizTalk 2010

The hotfix that resolves this issue is included in cumulative update package 2 for BizTalk Server 2009.

For more information about how to obtain the cumulative update package, click the following article number to view the article in the Microsoft Knowledge Base:
2497794 Cumulative update package 2 for BizTalk Server 2009
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
REFERENCES
For more information about BizTalk Server hotfixes, click the following article number to view the article in the Microsoft Knowledge Base:
2003907 Information about BizTalk Server hotfixes
kbbiztalk2010presp1fix
Properties

Article ID: 2475812 - Last Review: 05/23/2011 02:42:00 - Revision: 2.0

Microsoft BizTalk Server 2009 Branch, Microsoft BizTalk Server 2009 Developer, Microsoft BizTalk Server 2009 Enterprise, Microsoft BizTalk Server 2009 Standard

  • kbqfe kbfix kbexpertiseadvanced kbsurveynew kbbiztalk2009presp1fix kbbtsbam KB2475812
Feedback
"var m=document.createElement('meta');m.name='ms.dqp0';m.content='true';document.getElementsByTagName('head')[0].appendChild(m);" onload="var m=document.createElement('meta');m.name='ms.dqp0';m.content='false';document.getElementsByTagName('head')[0].appendChild(m);" src="http://c1.microsoft.com/c.gif?">