Microsoft KB Archive/891427

= Event ID 24 is logged and you receive parse error messages or translation error messages when you create a document interchange by using the BizTalk Accelerator for HIPAA version 3.0 =

Article ID: 891427

Article Last Modified on 11/19/2007

-

APPLIES TO


 * Microsoft BizTalk Server 2004 Partner Edition
 * Microsoft BizTalk Server 2004 Enterprise Edition
 * Microsoft BizTalk Server 2004 Developer Edition
 * Microsoft BizTalk Server 2004 Standard Edition

-





SYMPTOMS
When you create a document interchange by using the Microsoft BizTalk Accelerator for HIPAA version 3.0, you may receive parse error messages or translation error messages. In this scenario, an event that is similar to the following is logged in the Application log on the computer that is running Microsoft BizTalk Server 2004: Event Type: Error

Event Source: HIPAA EDI Subsystem

Event Category: BizTalk Server 2004

Event ID: 24

Date:

Time:

User: N/A

Computer:

Description: Error encountered: ERROR (33), interchange 10018 :

The time format is not valid. Contact the sender.

source format: [5 00401 ,X12-4010]

source document: [(unknown)]

source segment: [data#0,def#3,tag=GS ,name=Functional Group Header]

source element: [def#5,elm#5,comp#0,tag=337,name=Time], value: [14445271], incorrect length. Time of type [TS] must be formatted as [HHMM[SS]] (seconds are optional) (msgnr:0 segnr:0)(line:2 pos:37 filepos:144)

Note You experience this problem even though you have a correct time value according to the Health Insurance Portability and Accountability Act of 1996 (HIPAA) documentation that describes the Time field. This documentation contains the following information:

Time ID GS05__Time Usage Required X12 # 337 Type TM Minimum 4 Maximum 8 Definition Time expressed in 24-hour clock time as follows: HHMM, or HHMMSS, or HHMMSSD, or HHMMSSDD, where H = hours (00-23), M = minutes (00-59), S = integer seconds (00-59) and DD = decimal seconds; decimal seconds are expressed as follows: D = tenths (0-9) and DD = hundredths (00-99)

Note 1 Use this time for the creation time. The recommended format is HHMM.



CAUSE
This problem occurs if your HIPAA document has a time value that contains decimal seconds. For example, this problem occurs if your document contains a time value that is in the following format:

HHMMSSDD

According to the HIPAA documentation about the Time field, this time format is correct. However, this time format causes parse errors or translation errors in the BizTalk Accelerator for HIPAA version 3.0. If you use a time format of HHMMSS, your document is processed successfully.

This problem occurs because the BizTalk Accelerator for HIPAA version 3.0 Microsoft SQL Server 2000 tables contain an incorrect definition of the HIPAA TM data type.



WORKAROUND
To work around this problem, run the following SQL statement in SQL Query Analyzer against the BizTalkHIPAA_EDIDb database:

UPDATE elmnts SET len=8 WHERE elmtyp='TS' AND fc=5 AND elmtag = 337 AND len=6



STATUS
Microsoft has confirmed that this is a problem in BizTalk Server Accelerator for HIPAA version 3.0.



MORE INFORMATION
For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

824684 Description of the standard terminology that is used to describe Microsoft software updates

The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.

Additional query words: ERROR(33)

Keywords: kbbug kbfix kbbtsaccelerators KB891427

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.