You are currently offline, waiting for your internet to reconnect

A hotfix is available that enables BizTalk Server 2009 to remove zero and space characters that are leading or trailing in an EDI message


Introduction
A hotfix is available that enables Microsoft BizTalk Server 2009 to remove additional space and zero characters that are leading or trailing in an Electronic Data Interchange (EDI) message. The hotfix changes the user interface (UI) of the Validation and ACK Generation Settings page and the Validation and ACK Processing Settings page.

Note Because the update affects the EDI user interface (UI), the hotfix also affects Health Insurance Portability and Accountability Act (HIPAA) messages.
MORE INFORMATION
Before you apply the cumulative update package, the user interface (UI) of the Validation and ACK Generation Settings page and the Validation and ACK Processing Settings page resembles the following:
Before you install the cumulative update 2 for Biztalk 2009


If the Allow leading and trailing zeros and spaces check box is selected on the Validation and ACK Generation Settings page and on the Validation and ACK Processing Settings page, any additional space and zero characters that are leading or trailing are not removed from an EDI message that is generated by BizTalk Server. If an Allow leading and trailing zeros and spaces check box is cleared, an event is logged in the Application log.

For example, you process the following HIPPA message that has some spaces in BizTalk Server 2009:
<NM103_SubscriberLastName>NM103_Test </NM103_SubscriberLastName>
If the Allow leading and trailing zeros and spaces check box is selected on the Validation and ACK Generation Settings page and on the Validation and ACK Processing Settings page, BizTalk Server generates the following EDI message:
NM1*IL*1*NM103_Test *****II*NM109_SubscriberPrimaryIdentifier
If the Allow leading and trailing zeros and spaces check box is cleared on the Validation and ACK Generation Settings page or on the Validation and ACK Processing Settings page, an event that resembles the following is logged in the Application log:
Event Type: Error
Event Source: BizTalk Server 2009 EDI
Event Category: None
Event ID: 8116
Description:
Error: 1 (Field level error)
SegmentID: NM1
Position in TS: 15
Data Element ID: NM103_SubscriberLastName
Position in Segment: 3
Data Value:
6: Leading or trailing space found

After you apply the following cumulative update package, the Allow leading or trailing zeros and spaces check box is replaced by the Handling leading and trailing spaces and zeros options. The user interface (UI) resembles the following:
After you install the cumulative update 2 for Biztalk 2009

You can select one of the following Handling leading and trailing spaces and zeros options:
  • Allow
  • Do not allow
  • Trim
The Allow and Do not allow options are features that are available before this update is applied. However, the Trim option is a new feature.

If the Allow option is selected, BizTalk Server does not remove any additional space and zero characters that are leading or trailing from an EDI message.

If the Do not allow option is selected, BizTalk Server logs an instance of an event when an EDI message contains additional space and zero characters that are leading or trailing. The event that is logged has Event ID 8116 and the "Leading or trailing space found" error message.

If the Trim option is selected, BizTalk Server removes the additional space and zero characters that are leading or trailing. If the Trim option is selected in the previous example, BizTalk Server generates the following EDI message:
NM1*IL*1*NM103_Test*****II*NM109_SubscriberPrimaryIdentifier
Note In earlier versions of BizTalk Server, additional zero and space characters that are leading or trailing are removed.

Cumulative update information

The hotfix that resolves this issue is included in cumulative update package 2 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: 
    2497794 Cumulative update package 2 for BizTalk Server 2009

REFERENCES
For more information about the Validation and ACK Generation Settings page, visit the following MSDN website:

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

Properties

Article ID: 2510751 - Last Review: 03/18/2011 02:27:00 - Revision: 1.0

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

  • kbqfe kbexpertiseadvanced kbsurveynew kbbiztalk2009presp1fix KB2510751
Feedback
v>
Venezuela - Español
/html>microsoft.com/c.gif?DI=4050&did=1&t="> var varCustomerTracking = 1; var Route = "76500"; var Ctrl = ""; document.write(" ')[0].appendChild(m);" onload="var m=document.createElement('meta');m.name='ms.dqp0';m.content='false';document.getElementsByTagName('head')[0].appendChild(m);" src="http://c1.microsoft.com/c.gif?"> >>