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:
DateTime:
TimeUser: N/A
Computer:
ComputerNameDescription:
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:
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.