Cumulative update package 1 for BizTalk Server 2009

INTRODUCTION

This cumulative update for Microsoft BizTalk Server 2009 contains hotfixes for the BizTalk Server 2009 issues that were resolved after the release of BizTalk Server 2009．

We recommend that you test hotfixes before you deploy them in a production environment. Because the builds are cumulative, each new update release contains all the hotfixes and all the security updates that were included in the previous BizTalk Server 2009 update release. We recommend that you consider applying the most recent update release that contains this hotfix.

Important notes about the cumulative update package

One cumulative hotfix package includes all the component packages. However, the cumulative update package updates only those features that are installed on the system.

Important To check whether a newer Service pack or Cumulative Update is available for BizTalk Server, click the following article number to view the article in the Microsoft Knowledge Base:

More Information

Cumulative update (CU) is a rollup update that contains all previous hotfixes to date for BizTalk Server 2009.

The BizTalk Server team is using this model as a pilot and also for this specific version. The plan to apply this model is based on the feedback we received from the community.

For more information about the terminology that is used to describe Microsoft product updates, click the following article number to view the article in the Microsoft Knowledge Base:

824684 Description of the standard terminology that is used to describe Microsoft software updates

BizTalk Server 2009 hotfixes that are included in Cumulative Update 1 for BizTalk Server 2009

Microsoft Knowledge Base articles that discuss these hotfixes are released as they become available. For more information about BizTalk Server bugs, click the following article numbers to view the articles in the Microsoft Knowledge Base:

"<MapName.btm>: Exception Caught" error message when you try to use Visual Studio Team System 2010 TFS to build and deploy a BizTalk 2009 project that contains a map that references a schema in another project

FIX: BizTalk Server 2006 or BizTalk Server 2006 R2 or BizTalk Server 2009 experiences low performance when you execute an SQL query that refers to the "ActivityID" field in the bam_ActivityName_CompletedRelationships table

FIX: Error message when you try to deploy BAM update when partitioning is enabled for an existing activity: "All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists"

FIX: The generated XML files are much larger than expected when you try to split an EDI document that contains multiple sub-documents by using a "multiple" type schema in BizTalk Server 2006 R2 or in BizTalk Server 2009

FIX: Messages are not delivered to the destination after you change the host for a send handler in BizTalk Server

How to obtain Cumulative Update 1 for BizTalk Server 2009

A supported cumulative update package is now available from Microsoft. However, the cumulative update package is intended to correct only the problems that are described in this article. Apply the cumulative update package only to systems that are experiencing these specific problems. This cumulative update package may receive additional testing. Therefore, if you are not severely affected by any of these problems, we recommend that you wait for the next BizTalk Server 2009 service pack. The next service pack will contain the hotfixes that are in this cumulative update package.

If the cumulative update is available for download, there is a "Hotfix download available" section at the top of this Knowledge Base article. If this section does not appear, contact Microsoft Customer Service and Support to obtain the cumulative update package.

Note If additional issues occur or if any troubleshooting is required, you may have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this specific cumulative update package. For a complete list of Microsoft Customer Service and Support telephone numbers or to create a separate service request, visit the following Microsoft Website:

Note The "Hotfix Download Available" form displays the languages for which the cumulative update is available. If you do not see a certain language, no cumulative update package is available for that language.

Cumulative update package information

Prerequisites

To apply this update, you must have Microsoft BizTalk Server 2009 installed.

Additionally, the following features have some corresponding hotfixes in this update. To apply the corresponding hotfixes, the feature must be installed.

If a Readme.txt file is included in this update, see the Readme.txt file for more information about how to install this update.

Restart requirement

You may have to restart the computer after you apply this cumulative update.

File information

The English version of this cumulative update package has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.

For all supported x86-based versions of BizTalk Server 2009

File name

File version

File size

Date

Time

Platform

Admin_server_logic.sql

Not applicable

72,832

29-Nov-2010

14:17

Not applicable

Biztalkcommon.targets

Not applicable

10,681

29-Nov-2010

14:17

Not applicable

Biztalkmsgboxdbsps.sql

Not applicable

57,211

29-Nov-2010

14:17

Not applicable

Bts_tracking_logic.sql

Not applicable

322,096

29-Nov-2010

14:17

Not applicable

Btsasmext.dll

3.8.454.2

888,664

29-Nov-2010

14:17

x86

Btsedimessagecontenttables.sql

Not applicable

2,070

29-Nov-2010

14:17

Not applicable

Btsmessageagent.dll

3.8.454.2

712,544

29-Nov-2010

14:17

x86

Btsmetadataom.dll

3.8.454.2

427,872

29-Nov-2010

14:17

x86

Btsmsgcore.dll

3.8.454.2

1,248,088

29-Nov-2010

14:17

x86

Btswmiprovider.dll

3.8.454.2

617,312

29-Nov-2010

14:17

x86

Exsmime.dll

6.5.7653.24

187,728

29-Nov-2010

14:17

x86

Interop.xceedftplib.dll

3.8.454.2

59,240

29-Nov-2010

14:17

x86

Microsoft.biztalk.adapter.runtime.dll

3.8.454.2

83,848

29-Nov-2010

14:17

x86

Microsoft.biztalk.adapter.wcf.admin.dll

3.8.454.2

1,386,376

29-Nov-2010

14:17

x86

Microsoft.biztalk.adapter.wcf.common.dll

3.8.454.2

378,760

29-Nov-2010

14:17

x86

Microsoft.biztalk.adapter.wcf.consuming.dll

3.8.454.2

259,984

29-Nov-2010

14:17

x86

Microsoft.biztalk.adapter.wcf.publishing.dll

3.8.454.2

173,968

29-Nov-2010

14:17

x86

Microsoft.biztalk.adapter.wcf.runtime.dll

3.8.454.2

210,832

29-Nov-2010

14:17

x86

Microsoft.biztalk.admin_server_logic.sql.dll

3.8.454.2

11,664

29-Nov-2010

14:17

x86

Microsoft.biztalk.administration.snapin.dll

3.8.454.2

3,528,592

29-Nov-2010

14:17

x86

Microsoft.biztalk.applicationdeployment.engine.dll

3.8.454.2

567,200

29-Nov-2010

14:17

x86

Microsoft.biztalk.bam.management.dll

3.8.454.2

4,196,224

29-Nov-2010

14:17

x86

Microsoft.biztalk.biztalkmsgboxdbsps.sql.dll

3.8.454.2

11,664

29-Nov-2010

14:17

x86

Microsoft.biztalk.brmacontrols.dll

3.8.454.2

714,624

29-Nov-2010

14:17

x86

Microsoft.biztalk.bts_tracking_logic.sql.dll

3.8.454.2

11,664

29-Nov-2010

14:17

x86

Microsoft.biztalk.btsedimessagecontentsps.sql.dll

3.8.454.2

11,680

29-Nov-2010

14:17

x86

Microsoft.biztalk.btsedimessagecontenttables.sql.dll

3.8.454.2

11,688

29-Nov-2010

14:17

x86

Microsoft.biztalk.coreadapter.dll

3.8.454.2

104,320

29-Nov-2010

14:17

x86

Microsoft.biztalk.dbaccessor.dll

3.8.454.2

18,808

29-Nov-2010

14:17

x86

Microsoft.biztalk.deployment.dll

3.8.454.2

350,072

29-Nov-2010

14:17

x86

Microsoft.biztalk.edi.baseartifacts.dll

3.8.454.2

919,432

29-Nov-2010

14:17

x86

Microsoft.biztalk.edi.batchingorchestration.dll

3.8.454.2

5,576,600

29-Nov-2010

14:17

x86

Microsoft.biztalk.edi.messagecore.dll

3.8.454.2

378,760

29-Nov-2010

14:17

x86

Microsoft.biztalk.edi.partneragreementmanager.dll

3.8.454.2

460,704

29-Nov-2010

14:17

x86

Microsoft.biztalk.edi.pipelinecomponents.dll

3.8.454.2

190,352

29-Nov-2010

14:17

x86

Microsoft.biztalk.edi.shared.dll

3.8.454.2

182,136

29-Nov-2010

14:17

x86

Microsoft.biztalk.epmtransform.dll

3.8.454.2

17,792

29-Nov-2010

14:17

x86

Microsoft.biztalk.explorerom.dll

3.8.454.2

505,720

29-Nov-2010

14:17

x86

Microsoft.biztalk.kwtpm.wssv3adapter.webservice.dll

3.8.454.2

79,776

29-Nov-2010

14:17

x86

Microsoft.biztalk.mapper.compiler.dll

3.8.454.2

157,576

29-Nov-2010

14:17

x86

Microsoft.biztalk.mapper.om.dll

3.8.454.2

128,888

29-Nov-2010

14:17

x86

Microsoft.biztalk.messaging.dll

3.8.454.2

92,024

29-Nov-2010

14:17

x86

Microsoft.biztalk.msgbox_application_logic.sql.dll

3.8.454.2

11,680

29-Nov-2010

14:17

x86

Microsoft.biztalk.msgboxlogic.sql.dll

3.8.454.2

11,656

29-Nov-2010

14:17

x86

Microsoft.biztalk.operations.dll

3.8.454.2

198,520

29-Nov-2010

14:17

x86

Microsoft.biztalk.orchestrationdesigner.dll

3.8.454.2

2,299,792

29-Nov-2010

14:17

x86

Microsoft.biztalk.pipeline.components.dll

3.8.454.2

292,752

29-Nov-2010

14:17

x86

Microsoft.biztalk.pipeline.dll

3.8.454.2

292,728

29-Nov-2010

14:17

x86

Microsoft.biztalk.resourcemanagers.dll

3.8.454.2

198,536

29-Nov-2010

14:17

x86

Microsoft.biztalk.schemaeditor.dll

3.8.454.2

214,912

29-Nov-2010

14:17

x86

Microsoft.biztalk.streaming.dll

3.8.454.2

51,064

29-Nov-2010

14:17

x86

Microsoft.biztalk.tom.dll

3.8.454.2

874,352

29-Nov-2010

14:17

x86

Microsoft.biztalk.webservices.dll

3.8.454.2

259,968

29-Nov-2010

14:17

x86

Microsoft.biztalk.xlanginterceptor.dll

3.8.454.2

46,984

29-Nov-2010

14:17

x86

Microsoft.visualstudio.biztalkproject.base.dll

3.8.454.2

32,664

29-Nov-2010

14:17

x86

Microsoft.visualstudio.biztalkproject.buildtasks.dll

3.8.454.2

41,384

29-Nov-2010

14:17

x86

Microsoft.visualstudio.biztalkproject.dll

3.8.454.2

341,904

29-Nov-2010

14:17

x86

Microsoft.xlangs.basetypes.dll

3.8.454.2

104,312

29-Nov-2010

14:17

x86

Microsoft.xlangs.biztalk.engine.dll

3.8.454.2

247,680

29-Nov-2010

14:17

x86

Microsoft.xlangs.engine.dll

3.8.454.2

272,240

29-Nov-2010

14:17

x86

Microsoft.xlangs.runtimetypes.dll

3.8.454.2

120,704

29-Nov-2010

14:17

x86

Msgbox_application_logic.sql

Not applicable

529,850

29-Nov-2010

14:17

Not applicable

Msgboxlogic.sql

Not applicable

570,596

29-Nov-2010

14:17

Not applicable

Wssadacfg.dll

3.8.454.2

117,080

29-Nov-2010

14:17

x86

Xceedftpbiztalk.dll

3.8.454.2

305,504

29-Nov-2010

14:17

x86

Biztalkmsgboxdbsps.sql

Not Applicable

57,211

16-Nov-2010

22:08

Not Applicable

Microsoftedixsdtemplateskb973415.exe

Not Applicable

1,785,557

08-Jul-2009

15:17

x86

For all supported x64-based versions of BizTalk Server 2009

File name

File version

File size

Date

Time

Platform

Admin_server_logic.sql

Not applicable

72,832

29-Nov-2010

17:37

Not applicable

Biztalkcommon.targets

Not applicable

10,681

29-Nov-2010

17:37

Not applicable

Biztalkmsgboxdbsps.sql

Not applicable

57,211

29-Nov-2010

17:37

Not applicable

Bts_tracking_logic.sql

Not applicable

322,096

29-Nov-2010

17:37

Not applicable

Btsasmext.dll

3.8.454.2

888,664

29-Nov-2010

17:37

x86

Btsedimessagecontenttables.sql

Not applicable

2,070

29-Nov-2010

17:37

Not applicable

Btsmessageagent.dll

3.8.454.2

1,345,888

29-Nov-2010

17:37

x64

Btsmessageagent.dll

3.8.454.2

712,544

29-Nov-2010

17:37

x86

Btsmetadataom.dll

3.8.454.2

427,872

29-Nov-2010

17:37

x86

Btsmsgcore.dll

3.8.454.2

1,248,088

29-Nov-2010

17:37

x86

Btsmsgcore.dll

3.8.454.2

1,977,176

29-Nov-2010

17:37

x64

Btswmiprovider.dll

3.8.454.2

617,312

29-Nov-2010

17:37

x86

Exsmime.dll

6.5.7653.24

187,728

29-Nov-2010

17:37

x86

Interop.xceedftplib.dll

3.8.454.2

59,240

29-Nov-2010

17:37

x86

Microsoft.biztalk.adapter.runtime.dll

3.8.454.2

83,848

29-Nov-2010

17:37

x86

Microsoft.biztalk.adapter.wcf.admin.dll

3.8.454.2

1,386,376

29-Nov-2010

17:37

x86

Microsoft.biztalk.adapter.wcf.common.dll

3.8.454.2

378,760

29-Nov-2010

17:37

x86

Microsoft.biztalk.adapter.wcf.consuming.dll

3.8.454.2

259,984

29-Nov-2010

17:37

x86

Microsoft.biztalk.adapter.wcf.publishing.dll

3.8.454.2

173,968

29-Nov-2010

17:37

x86

Microsoft.biztalk.adapter.wcf.publishing.dll

3.8.454.2

173,968

29-Nov-2010

17:37

x86

Microsoft.biztalk.adapter.wcf.runtime.dll

3.8.454.2

210,832

29-Nov-2010

17:37

x86

Microsoft.biztalk.admin_server_logic.sql.dll

3.8.454.2

11,664

29-Nov-2010

17:37

x86

Microsoft.biztalk.administration.snapin.dll

3.8.454.2

3,528,592

29-Nov-2010

17:37

x86

Microsoft.biztalk.applicationdeployment.engine.dll

3.8.454.2

567,200

29-Nov-2010

17:37

x86

Microsoft.biztalk.bam.management.dll

3.8.454.2

4,196,224

29-Nov-2010

17:37

x86

Microsoft.biztalk.biztalkmsgboxdbsps.sql.dll

3.8.454.2

11,664

29-Nov-2010

17:37

x86

Microsoft.biztalk.brmacontrols.dll

3.8.454.2

714,624

29-Nov-2010

17:37

x86

Microsoft.biztalk.bts_tracking_logic.sql.dll

3.8.454.2

11,664

29-Nov-2010

17:37

x86

Microsoft.biztalk.btsedimessagecontentsps.sql.dll

3.8.454.2

11,680

29-Nov-2010

17:37

x86

Microsoft.biztalk.btsedimessagecontenttables.sql.dll

3.8.454.2

11,688

29-Nov-2010

17:37

x86

Microsoft.biztalk.coreadapter.dll

3.8.454.2

104,320

29-Nov-2010

17:37

x86

Microsoft.biztalk.dbaccessor.dll

3.8.454.2

18,808

29-Nov-2010

17:37

x86

Microsoft.biztalk.deployment.dll

3.8.454.2

350,072

29-Nov-2010

17:37

x86

Microsoft.biztalk.edi.baseartifacts.dll

3.8.454.2

919,432

29-Nov-2010

17:37

x86

Microsoft.biztalk.edi.batchingorchestration.dll

3.8.454.2

5,576,600

29-Nov-2010

17:37

x86

Microsoft.biztalk.edi.messagecore.dll

3.8.454.2

378,760

29-Nov-2010

17:37

x86

Microsoft.biztalk.edi.partneragreementmanager.dll

3.8.454.2

460,704

29-Nov-2010

17:37

x86

Microsoft.biztalk.edi.pipelinecomponents.dll

3.8.454.2

190,352

29-Nov-2010

17:37

x86

Microsoft.biztalk.edi.shared.dll

3.8.454.2

182,136

29-Nov-2010

17:37

x86

Microsoft.biztalk.epmtransform.dll

3.8.454.2

17,792

29-Nov-2010

17:37

x86

Microsoft.biztalk.explorerom.dll

3.8.454.2

505,720

29-Nov-2010

17:37

x86

Microsoft.biztalk.kwtpm.wssv3adapter.webservice.dll

3.8.454.2

79,776

29-Nov-2010

17:37

x86

Microsoft.biztalk.mapper.compiler.dll

3.8.454.2

157,576

29-Nov-2010

17:37

x86

Microsoft.biztalk.mapper.om.dll

3.8.454.2

128,888

29-Nov-2010

17:37

x86

Microsoft.biztalk.messaging.dll

3.8.454.2

92,024

29-Nov-2010

17:37

x86

Microsoft.biztalk.msgbox_application_logic.sql.dll

3.8.454.2

11,680

29-Nov-2010

17:37

x86

Microsoft.biztalk.msgboxlogic.sql.dll

3.8.454.2

11,656

29-Nov-2010

17:37

x86

Microsoft.biztalk.operations.dll

3.8.454.2

198,520

29-Nov-2010

17:37

x86

Microsoft.biztalk.orchestrationdesigner.dll

3.8.454.2

2,299,792

29-Nov-2010

17:37

x86

Microsoft.biztalk.pipeline.components.dll

3.8.454.2

292,752

29-Nov-2010

17:37

x86

Microsoft.biztalk.pipeline.dll

3.8.454.2

292,728

29-Nov-2010

17:37

x86

Microsoft.biztalk.resourcemanagers.dll

3.8.454.2

198,536

29-Nov-2010

17:37

x86

Microsoft.biztalk.schemaeditor.dll

3.8.454.2

214,912

29-Nov-2010

17:37

x86

Microsoft.biztalk.streaming.dll

3.8.454.2

51,064

29-Nov-2010

17:37

x86

Microsoft.biztalk.tom.dll

3.8.454.2

874,352

29-Nov-2010

17:37

x86

Microsoft.biztalk.webservices.dll

3.8.454.2

259,968

29-Nov-2010

17:37

x86

Microsoft.biztalk.xlanginterceptor.dll

3.8.454.2

46,984

29-Nov-2010

17:37

x86

Microsoft.visualstudio.biztalkproject.base.dll

3.8.454.2

32,664

29-Nov-2010

17:37

x86

Microsoft.visualstudio.biztalkproject.buildtasks.dll

3.8.454.2

41,384

29-Nov-2010

17:37

x86

Microsoft.visualstudio.biztalkproject.dll

3.8.454.2

341,904

29-Nov-2010

17:37

x86

Microsoft.xlangs.basetypes.dll

3.8.454.2

104,312

29-Nov-2010

17:37

x86

Microsoft.xlangs.biztalk.engine.dll

3.8.454.2

247,680

29-Nov-2010

17:37

x86

Microsoft.xlangs.engine.dll

3.8.454.2

272,240

29-Nov-2010

17:37

x86

Microsoft.xlangs.runtimetypes.dll

3.8.454.2

120,704

29-Nov-2010

17:37

x86

Msgbox_application_logic.sql

Not applicable

529,850

29-Nov-2010

17:37

Not applicable

Msgboxlogic.sql

Not applicable

570,596

29-Nov-2010

17:37

Not applicable

Wssadacfg.dll

3.8.454.2

117,080

29-Nov-2010

17:37

x86

Xceedftpbiztalk.dll

3.8.454.2

305,504

29-Nov-2010

17:37

x86

Biztalkmsgboxdbsps.sql

Not Applicable

57,211

16-Nov-2010

22:08

Not Applicable

Microsoftedixsdtemplateskb973415.exe

Not Applicable

1,785,557

08-Jul-2009

15:17

x86

Installation Instructions

Before you install the hotfix, back up the following files:

Microsoft.BizTalk.Edi.BaseArtifacts.dll

Microsoft.BizTalk.MessageCore.dll

Microsoft.BizTalk.Edi.Shared.dll

Microsoft.BizTalk.Edi.PipelineComponents.dll

Notes

Microsoft.BizTalk.Edi.BaseArtifacts.dll, Microsoft.BizTalk.MessageCore.dll and Microsoft.BizTalk.Edi.Shared.dll are located at <Drive:>\Program Files\Microsoft BizTalk Server 2009.

Microsoft.BizTalk.Edi.PipelineComponents.dll is located at <Drive:>\Program Files\Microsoft BizTalk Server 2009\Pipeline Components.

In the same Resources directory that was mentioned in step 2, right-clickResources, click Add, and then clickBizTalk Assemblies.

In the Add Resources dialog box, clickAdd, and then browse to the following directory:

<Drive:>\Program Files\Microsoft BizTalk Server 2009

In this directory, double-click the Microsoft.BizTalk.Edi.BaseArtifacts.dll file.

Restart the BizTalk host instance.

Run the MicrosoftEdiXSDTemplatesKb973415.exe file that is in this hotfix package to self-extract the latest set of HIPAA5010-compliant schemas. Save them to the following suggested directory:

<Drive:>\Program Files\Microsoft BizTalk Server 2009\XSD_Schema\EDI

You can then follow the standard procedure for building and deploying schemas.

For more information, refer to the Readme.txt file that is contained in this hotfix package.

Important notes

In HIPAA 4010 schemas, elements of the X12_R type are not checked for minimum and maximum lengths. However, HIPAA 5010 guarantees that minimum and maximum lengths are checked.

The ST03 elements in the following schemas are not supposed to be changed because their values are used to identify the correct variant schemas:

837 variants (I, P, D)

277

This is a HIPAA 5010 standard.

Known issues

The design time tools have an issue when it validates batched EDI interchange for 837 message variants (I, P, D) that are included HIPAA 5010 schemas. This issue does not occur when the tools validate a non-batched EDI interchange.

BizTalk tracking may stop working because the required permissions are removed in certain DTA database tables after this cumulative update package is applied. To resolve this issue, follow these steps:

Open BizTalk Administration Console, click to select the Allow Host Tracking option in another BizTalk Server host, and then click to clear the option in the current tracking host.

Restart BizTalk Server host instances.

Click to select the Allow Host Tracking option in another BizTalk Server host, and then click to clear the option in the current tracking host.

Restart the host instances to correctly apply the permissions.

Some BizTalk databases may not be updated if you change the BizTalk Server group name before you apply this cumulative update package. To avoid this issue, rename the BizTalk Server group back to the following default name before you apply the update:

BizTalk Group

References

For more information about BizTalk Serverhotfixes, click the following article number to view the article in the Microsoft Knowledge Base: