You are currently offline, waiting for your internet to reconnect

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

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 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:
Properties

Article ID: 2642402 - Last Review: 02/29/2012 08:02:00 - Revision: 2.0

Microsoft BizTalk Server Branch 2010, Microsoft BizTalk Server Developer 2010, Microsoft BizTalk Server Enterprise 2010, Microsoft BizTalk Server Standard 2010

  • kbbtsbam kbqfe kbfix kbsurveynew kbexpertiseadvanced kbbtspipeline KB2642402
Feedback
ml>0&did=1&t=">