FIX: The BizTalk Mapper May Not Correctly Serialize a Flat File Document (330121)



The information in this article applies to:

  • Microsoft BizTalk Server 2002

This article was previously published under Q330121

SYMPTOMS

During serialization, if an incoming field contains a null value, the output document may not contain the field. This was originally by design, but this behavior will change when you install Microsoft BizTalk Server 2002 Service Pack 1 (SP1) . You can also change this behavior the installation of the hotfix that is discussed in this article.

RESOLUTION

Service Pack Information

To resolve this problem, obtain the latest service pack for Microsoft BizTalk Server 2002. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

815781 How to Obtain the Latest BizTalk Server 2002 Service Pack

Hotfix Information


A supported fix is now available from Microsoft, but it is only intended to correct the problem that is described in this article. Apply it only to computers that are experiencing this specific problem.

To resolve this problem, contact Microsoft Product Support Services to obtain the fix. For a complete list of Microsoft Product Support Services phone numbers and information about support costs, visit the following Microsoft Web site:NOTE: In special cases, charges that are ordinarily incurred for support calls may be canceled if a Microsoft Support Professional determines that a specific update will resolve your problem. The usual support costs will apply to additional support questions and issues that do not qualify for the specific update in question.

The English version of this fix has the file attributes (or later) 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 tool in Control Panel.
   Date         Time   Version            Size    File name
   ----------------------------------------------------------------------
   11-Apr-2002  16:41                     13,680  Btm_priorityupgrade.sql
   11-Apr-2002  16:40  1.0.0.2            33,040  Hotfixsetup.exe  
   22-Oct-2002  00:23                        901  Qfehotfix.ini
   22-Oct-2002  00:22                    500,224  Qfepatch.msp
   22-Oct-2002  00:23                      7,168  Qfeunpatch.msp
   11-Apr-2002  16:41                     19,632  Sq_priorityupgrade.sql
				
After the hotfix is installed, the following files will have the listed attributes or later:
   Date         Time   Version            Size    File name
   ----------------------------------------------------------------
   22-Oct-2002  00:09  3.0.1544.0        131,344  Cisapi.dll       
   22-Oct-2002  00:09  3.0.1544.0        524,560  Ciscore.dll      
   22-Oct-2002  00:09  3.0.1544.0        405,776  Cisengine.dll    
   22-Oct-2002  00:09  3.0.1544.0        471,312  Cisserializer.dll  
   22-Oct-2002  00:09  3.0.1544.0        348,432  Mscis.exe        
   22-Oct-2002  00:09  3.0.1544.0        188,688  Serializedoc.dll  
				

To apply the fix, follow these steps:
  1. Stop the BizTalk Messaging Service.
  2. Use the SQL Query Analyzer to apply BTM_PriorityUpgrade.sql to the InterchangeBTM database.
  3. Use the SQL Query Analyzer to apply SQ_PriorityUpgrade.sql to the InterchangeSQ database.
  4. Run the hotfix installation program (Hotfixsetup.exe).
  5. Start the BizTalk Messaging Service.
To change the behavior of BizTalk Server 2002 to permit the output of all trailing delimiters, set the following registry key:

HKLM\SYSTEM\CurrentControlSet\Services\BTSSvc
Value: AppendTrailingDelimiters
Data Type: REG_DWORD : 1

NOTE: When you do this, the change applies to all documents that BizTalk Server processes. You cannot set this per document.

STATUS

Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.
This problem was first corrected in Microsoft BizTalk Server 2002 Service Pack 1.

Modification Type:MinorLast Reviewed:10/17/2005
Keywords:kbHotfixServer kbQFE kbBizTalk2002SP1fix kbbug kbfix KB330121 kbAudDeveloper