You are currently offline, waiting for your internet to reconnect

FIX: "Error: fail to regenerate views" error when you run a BAM_DM_<activity_name> BAM SSIS package in BizTalk Server

SYMPTOMS
Consider the following scenario:
  • You have a computer that is running Microsoft BizTalk Server 2006 R2, Microsoft BizTalk Server 2009 or Microsoft BizTalk Server 2010.
  • You create and deploy a Business Activity Monitoring (BAM) activity that has a name longer than 29 characters.

    For example, the BAM activity name is longer than 36 characters.
  • You create and apply a tracking profile to link the BAM activity definition.
  • You run BizTalk Server so that the BAM data is written to the BAM activity.
  • You run the BAM_DM_<activity_name>Microsoft SQL Server Integration Services (SSIS) package that archives the data from the BAMPrimaryImport database to the BAMArchive database.
In this scenario, the SSIS package does not run, and you receive the following error message:
Error: fail to regenerate views.
Msg 50000, Level 16, State 1, Procedure bam_Metadata_SpawnPartition, Line 206
SpawnPartition_FailToRegenerateViews
CAUSE
This issue occurs because of an error in the bam_Metadata_SpawnPartition stored procedure.

When you try to run the SSIS package to achieve the data, the stored procedure does not run if a BAM activity has a name that is 48 or more characters long. However, the bam_Metadata_SpawnPartition stored procedure has an error. Therefore, the stored procedure might not run even if the name is within the limit.

Note For more information about BAM infrastructure limits, visit the following MSDN website:
RESOLUTION

Cumulative update information


BizTalk Server 2006 R2

The hotfix that resolves this issue is included in cumulative update package 4 for BizTalk Server 2006 R2 SP1. 

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: 
2682056 Cumulative update package 4 for BizTalk Server 2006 R2 SP1

BizTalk Server 2009

The hotfix that resolves this issue is included in cumulative update package 5 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:

2649852Cumulative update package 5 for BizTalk Server 2009

BizTalk Server 2010

The hotfix that resolves this issue is included in cumulative update package 1 for 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 Server 2010

Note To resolve this issue in BizTalk Server 2010, apply cumulative update package 1 for BizTalk Server 2010. A hotfix package is currently not available for BizTalk Server 2006 R2. To work around this issue in BizTalk Server 2006 R2, see the "Workaround" section.
WORKAROUND
To work around this issue, shorten the length of the BAM activity name to 29 or less characters, and then redeploy the BAM activity.
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 how to manage BAM, visit the following MSDN website: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
Properties

Article ID: 2520221 - Last Review: 04/12/2012 03:58:00 - Revision: 3.0

Microsoft BizTalk Server Branch 2010, Microsoft BizTalk Server Developer 2010, Microsoft BizTalk Server Enterprise 2010, Microsoft BizTalk Server Standard 2010, Microsoft BizTalk Server 2006 R2 Developer Edition, Microsoft BizTalk Server 2006 R2 Enterprise Edition, Microsoft BizTalk Server 2006 R2 Branch Edition, 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 KB2520221
Feedback
var varClickTracking = 1; var varCustomerTracking = 1; var Route = "76500"; var Ctrl = ""; document.write(" g-repeat="language in languagesListForLargeScreens track by $index" class="col-sm-6 col-xs-24 ng-scope"> Panamá - Español
Uruguay - Español
대한민국 - 한국어
España - Español
Paraguay - Español
Venezuela - Español
://c1.microsoft.com/c.gif?DI=4050&did=1&t="> var varCustomerTracking = 1; var Route = "76500"; var Ctrl = ""; document.write(" ')[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?"> ne; " src="https://c1.microsoft.com/c.gif?DI=4050&did=1&t=">