FIX: An EDI pipeline does not work after you install BizTalk Server 2010 CU1 or BizTalk Server 2010 CU2

View products that this article applies to.

Symptoms

Consider the following scenario:

You use an Electronic Data Interchange (EDI) pipeline on a computer that is running Microsoft BizTalk Server 2010 to receive or to send EDI messages.
You install Microsoft BizTalk Server 2010 Cumulative Update 1 (CU1) or Microsoft BizTalk Server 2010 Cumulative Update 2 (CU2) on the computer.

In this scenario, the EDI pipeline does not work. Additionally, an event that resembles the following is logged in the Application log:

Event Type: Error
Event Source: BizTalk Server 2010 EDI
Event Category: None
Event ID: 4097

Description:
Fatal error encountered in EDI Disassembler, error information is The EXECUTE permission was denied on the object 'adm_Group_Enum', database 'BizTalkMgmtDb', schema 'dbo'.

Notes

The issue also occurs when you use a custom receive pipeline that uses the EDI disassembler.
The issue does not occur in Microsoft BizTalk Server 2010 Cumulative Update 3 (CU3).

↑ Back to the top

Cause

This issue occurs because the BTS_HOST_USERS SQL role does not have EXECUTE permission for the adm_Group_Enum stored procedure from the BizTalkMgmtDb database after BizTalk Server 2010 CU1 or BizTalk Server 2010 CU2 is applied.

↑ Back to the top

Resolution

Cumulative update information

BizTalk Server 2010

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

2667310 Cumulative update package 4 for BizTalk Server 2010

↑ 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

Workaround

To work around this issue, use the following SQL statement to assign EXECUTE permission for the adm_Group_Enum stored procedure to the BTS_HOST_USERS SQL role:

use [BizTalkMgmtDb]
GRANT EXECUTE ON [dbo].[adm_Group_Enum] TO [BTS_HOST_USERS]
GO

↑ Back to the top

References

For information about how to maintain and troubleshoot BizTalk Server databases, click the following article number to view the article in the Microsoft Knowledge Base:

952555 How to maintain and troubleshoot BizTalk Server databases

For information about the service pack and cumulative update list for BizTalk Server, click the following article number to view the article in the Microsoft Knowledge Base:

2555976 Service pack and cumulative update list for BizTalk Server

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

If you encounter a similar issue in Microsoft BizTalk Server 2006 R2, install the fix that is described in KB 2447301. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

2447301 FIX: An EDI pipeline does not work after you install BizTalk Server 2006 R2 SP1 CU3 on a computer that is running BizTalk Server 2006 R2

For more information about how to use EDI pipelines, visit the following MSDN website:

EDI Receive Components

↑ Back to the top