Microsoft EDI Leap Year Hotfix for BizTalk Server 2009 and 2006 R2 – FIX: “Invalid Date” error occurs when you use the EDI pipeline to receive EDI interchanges in BizTalk Server 2006 R2 or in BizTalk Server 2009 if a data element contains a leap date value

Please treat this as an Important Fix (on the line of Security updates) for all 2006 R2 and 2009 BizTalk servers.

This fix needs to be applied ASAP (before next week) as we will be hitting the leap year date 2/29/2012 in just about a week

This fix should be applied in:

• Microsoft BizTalk Server 2006 R2
• Microsoft BizTalk Server 2009 without CU installed (The fix has been available for quite some time and also included as part of the CU for BizTalk 2009 since CU1).

If you are not using X12 in your EDI transactions, this issue is not applicable to you and hence you don’t have to worry about taking this fix at this time.  The fix is only on the x12 code path and does not affect EDIFACT processing.

Problem

When you use the Electronic Data Interchange (EDI) pipeline to receive EDI interchanges in Microsoft BizTalk Server 2006 R2 or Microsoft BizTalk Server 2009, you may receive the following error message in the Application log:

Error encountered during parsing. The X12 transaction set with id ‘<n>’ contained in functional group with id ‘<n>’, in interchange with id ‘<n>’, with sender id ‘<sender id> ‘, receiver id ‘<receiver id>’ is being suspended with following errors:
Error: 1 (Field level error)
SegmentID: DTM
Position in TS: 42
Data Element ID: DTM02
Position in Segment: 2
Data Value: leapdate
8: Invalid Date

Cause

This issue occurs because the EDI interchange cannot validate a data element that contains a leap date value. For example, this issue occurs if the EDI interchange contains the “20120229” date value.

Hotfix

• EDI Leap Year hotfix: BizTalk 2009 and BizTalk 2006 R2:
  • https://support.microsoft.com/en-us/help/2435900/fix-invalid-date-error-occurs-when-you-use-the-edi-pipeline-to-receive
• BizTalk Server 2009:
  • Option1: Install any BizTalk 2009 Cumulative Update. KB 2555976 lists the available cumulative updates
  • Option 2: Install the stand-alone fix by clicking View and request hotfix downloads at the top of KB article 2435900.

Original post by Guru Venkataraman (BizTalk Customer Response Team) here and here.

Problem encountered during the install of the BizTalk EDI Leap Year Hotfix

• “The patch 861c5534-6cfa-4dcf-ba70-cbf01129b646 in the package Microsoft BizTalk Server 2006 R2 Hotfix [See KB article 2435900 for detail] cannot be applied. The minimum installed version of Microsoft BizTalk Server 2006 must be 3.6.2222.12. The installed version on this computer is 3.6.1404.0.”.

Note: you need to install this hotfix with a user with administrative privileges on the machine.

What do I do if I did not get the Leap Year Fix installed in time?

Check Guru Venkataraman (BizTalk Customer Response Team) post here!