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).
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.
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
Status
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
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
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 databasesFor 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:
