Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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

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

View products that this article applies to.

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

↑ Back to the top

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:
General information about BAM infrastructure limits

↑ Back to the top

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:


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

↑ Back to the top

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.

↑ Back to the top

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

↑ Back to the top

References

For more information about how to manage BAM, visit the following MSDN website:
How to manage BAM
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

↑ Back to the top

Keywords: kbqfe, kbfix, kbexpertiseadvanced, kbsurveynew, kbbiztalk2009presp1fix, kb

↑ Back to the top

Article Info
Article ID : 2520221
Revision : 1
Created on : 1/7/2017
Published on : 4/12/2012
Exists online : False
Views : 474