ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » TDS Question - field with sub fields and repeating Resolved

Post new topic  Reply to topic
 TDS Question - field with sub fields and repeating Resolved « View previous topic :: View next topic » 
Author Message
wraymore
PostPosted: Thu Apr 16, 2009 1:18 pm    Post subject: TDS Question - field with sub fields and repeating Resolved Reply with quote

Centurion

Joined: 16 Aug 2005
Posts: 114
Location: Burlington, NC USA

WMB 6.0.0.8
AIX 5.8

HL7 input message

Code:
ZRL|1|BN|LabCorp Burlington|1447 York Court^^Burlington^NC^272153361|8007624344||MD^Hancock^William F^^^^MD|||||
ZOI|5|100111^SPECIM^E^STATUS REPORT~829574^MONOGR^I^Monogram Trofile~551697^GENOSU^R^GenoSure~998085^VENIPU^S^Venipuncture~X14500^MDP30^S^Oxon Hill,MD      301-567-2819~||||
EOP|0427||||
EOF|||||


The ZOI segment contains a field that has sub fields with the group of sub fields repeating up to 40 times. Sub fields are delimited by ^ and the ~ is the repeat delimiter.

Code:

Tag: ZOI|
Number of Occurrences: 5|
Test Item: 100111^
Test Name: SPECIM^
Status: E^
Order Name: STATUS REPORT~

Test Item: 829574^
Test Name: MONOGR^
Status: I^
Order Name: Monogram Trofile~

Test Item: 551697^
Test Name: GENOSU^
Status: R^
Order Name: Genosure~

Test Item: 998085^
Test Name: VENIPU^
Status: S^
Order Name: Venipuncture~

Test Item: X14500^
Test Name: MDP30^
Status: S^
Order Name: Oxon Hill, MD         301-567-2891~|

Future Field 4: |
Future Field 5: |
Future Field 6: |
Future Field 7: |
Future Field 8: <CR><LF>     


From Trace Node:
Code:

      (0x01000013):ZRL = (
      (0x0300000B):ZRL.2.TransmissionSequenceNumber = '1'
      (0x0300000B):ZRL.3.FacilityMnemonic           = 'BN'
      (0x0300000B):ZRL.4.FacilityName               = 'LabCorp Burlington'
      (0x01000013):ZRL.5.FacilityLocation           = (
        (0x0300000B):ZRL.5.1.FacilityAddress       = '1447 York Court'
        (0x0300000B):ZRL.5.3.FacilityCity          = 'Burlington'
        (0x0300000B):ZRL.5.4.FacilityStateProvince = 'NC'
        (0x0300000B):ZRL.5.5.FacilityZipPostalCode = '272153361'
      )
      (0x0300000B):ZRL.6.FacilityPhoneNumber        = '8007624344'
      (0x0300000B):ZRL.7.FacilityContact            = ''
      (0x01000013):ZRL.8.FacilityDirector           = (
        (0x0300000B):ZRL.8.1.FacilityDirectorTitle     = 'MD'
        (0x0300000B):ZRL.8.2.FacilityDirectorLastName  = 'Hancock'
        (0x0300000B):ZRL.8.3.FacilityDirectorFirstName = 'William F'
        (0x0300000B):ZRL.8.7.FacilityDirectorDegree    = 'MD'
      )
      (0x0300000B):ZRL.9.FutureField                = ''
      (0x0300000B):ZRL.10.FutureField               = ''
      (0x0300000B):ZRL.11.FutureFeild               = ''
      (0x0300000B):ZRL.12.FutureField               = ''
      (0x0300000B):ZRL.13.FutureField               = ''
    )
    (0x01000013):ZOI = (
      (0x0300000B):ZOI.2.NumberOfOccurences = '5'
      (0x01000013):ZOI.3.TIXTestData        = (
        (0x0300000B):ZOI.3.1.TIXTestNumber   = '100111'
        (0x0300000B):ZOI.3.2.TIXTestName     = 'SPECIM'
        (0x0300000B):ZOI.3.3.TIXTestStatus   = 'E'
        (0x0300000B):ZOI.3.4.OrderedItemName = 'STATUS REPORT'
      )
      (0x01000013):ZOI.3.TIXTestData        = (
        (0x0300000B):ZOI.3.1.TIXTestNumber   = '829574'
        (0x0300000B):ZOI.3.2.TIXTestName     = 'MONOGR'
        (0x0300000B):ZOI.3.3.TIXTestStatus   = 'I'
        (0x0300000B):ZOI.3.4.OrderedItemName = 'Monogram Trofile'
      )
      (0x01000013):ZOI.3.TIXTestData        = (
        (0x0300000B):ZOI.3.1.TIXTestNumber   = '551697'
        (0x0300000B):ZOI.3.2.TIXTestName     = 'GENOSU'
        (0x0300000B):ZOI.3.3.TIXTestStatus   = 'R'
        (0x0300000B):ZOI.3.4.OrderedItemName = 'GenoSure'
      )
      (0x01000013):ZOI.3.TIXTestData        = (
        (0x0300000B):ZOI.3.1.TIXTestNumber   = '998085'
        (0x0300000B):ZOI.3.2.TIXTestName     = 'VENIPU'
        (0x0300000B):ZOI.3.3.TIXTestStatus   = 'S'
        (0x0300000B):ZOI.3.4.OrderedItemName = 'Venipuncture'
      )
      (0x01000013):ZOI.3.TIXTestData        = (
        (0x0300000B):ZOI.3.1.TIXTestNumber   = 'X14500'
        (0x0300000B):ZOI.3.2.TIXTestName     = 'MDP30'
        (0x0300000B):ZOI.3.3.TIXTestStatus   = 'S'
        (0x0300000B):ZOI.3.4.OrderedItemName = 'Oxon Hill,MD      301-567-2819'
      )
    )
    (0x01000013):EOP = (
      (0x0300000B):EOP.2.MessageControlID = '0427'
      (0x0300000B):EOP.3.FutureField      = ''
      (0x0300000B):EOP.4.FutureField      = ''
      (0x0300000B):EOP.5.FutureField      = ''
      (0x0300000B):EOP.6.FutureField      = ''
    )
    (0x01000013):EOF = (
      (0x0300000B):EOF.2.FutureField = ''
      (0x0300000B):EOF.3.FutureField = ''
      (0x0300000B):EOF.4.FutureField = ''
      (0x0300000B):EOF.5.FutureField = ''
      (0x0300000B):EOF.6.FutureField = ''
    )




I defined ZOI.3.TIXTestData as:
Complex Type, All Elements Delimited, Group Terminator: <HL7_RS>,
Delimiter: <HL7_CS>, Suppress Absent Element Delimiter: End of Type, Observe Element Length is checked.

It is listing the tests in the trace, however, the Future fields are not as in the other segments. What am I missing? I have tried groups and nested complex types to no avail. I did not even get the test data to list out with the groups and nested complex types.


Last edited by wraymore on Thu May 14, 2009 7:45 am; edited 1 time in total
Back to top
View user's profile Send private message
kimbert
PostPosted: Thu Apr 16, 2009 1:56 pm    Post subject: Reply with quote

Jedi Council

Joined: 29 Jul 2003
Posts: 5542
Location: Southampton

I presume your questions is 'Why do segments ZRL, EOP, EOF contain the FutureField components, but ZOI does not?'

Without a detailed understanding of your message model, it is hard to answer that question. You would need to provide full details of how the ZOI segment is modelled. If you want me to help, you will need to change this into a TDS problem instead of an HL7 problem.
So
- Remove all segments apart from ZRL and ZOI
- Remove all components which are not relevant to this problem
- Change the delimiters from <HL7_CS> etc to hard-coded values
- Create a test input message which demonstrates the problem
- Post the input message, the ( full simplified ) message model, and the Trace node output which results.

Sorry if that sounds like a lot of work. The alternatives are
- upgrade to v6.1.0.3 and see whether the TDS user trace output gives a clue
- raise a PMR
Back to top
View user's profile Send private message
rekarm01
PostPosted: Thu Apr 16, 2009 10:18 pm    Post subject: Re: TDS Question - field with sub fields and repeating Reply with quote

Grand Master

Joined: 25 Jun 2008
Posts: 1415

Maybe this will help translate HL7 (v2.x) to TDS:
  • An HL7 message consists of one or more HL7 segments, each terminated with a segment terminator (default <CR>, no <LF>).
  • An HL7 segment consists of a 3-character segment name, and one or more HL7 fields, each delimited by a field separator character (default <HL7_FS>, or '|').
  • An HL7 field consists of one or more HL7 repetitions, each delimited by a repetition separator character (default <HL7_RS>, or '~').
  • An HL7 repetition consists of one or more HL7 components, each delimited by a component separator character (default <HL7_CS>, or '^').

"ZOI.3.TIXTestData" is a repeating field. It should have Repeating Element Delimiter = <HL7_RS>, or '~'.

Each repetition consists of one or more components; it should have a complex type, with All Elements Delimited, Delimiter = <HL7_CS>, or '^', and Supress Absent Element Delimiters = End of Type.

Other miscellaneous observations:
  • Putting periods in element names can make ESQL references a bit messy.
  • The HL7 standard numbers its fields differently, starting with 1; the element names should probably look more like:
    Code:
        (0x01000013):ZOI = (
          (0x0300000B):ZOI.1.NumberOfOccurences = '5'
          (0x01000013):ZOI.2.TIXTestData        = (
            (0x0300000B):ZOI.2.1.TIXTestNumber   = '100111'
            ...
          )
Back to top
View user's profile Send private message
wraymore
PostPosted: Mon Apr 20, 2009 10:16 am    Post subject: Reply with quote

Centurion

Joined: 16 Aug 2005
Posts: 114
Location: Burlington, NC USA

Thanks kimbert, I have switched my message model to TDS. Below are the items that you requested, at least I hope so.

Code:

Input Message:
   ZRL|1|Lab|Facility Name|Address^^City^NC^Zipplus4|phone nbr||Title^LName^FName^^^^degree|||||
ZOI|5|123456^TName1^TStatus1^OName1~234567^TName2^TStatus2^OName2~551697^TName3^TStatus3^OName3~998085^TName4^TStatus4^OName4~X14500^Tname5^TStatus5^OName5~||||
 


Code:

Message Model:
Message Data Element Separation="Tagged Delimited" TagLength="3" GroupTerminator="<CR><LF>" Delimiter="CR><LF>" Suppress Absent Element Delimiters="End of Type" Observe Element Length Not Checked
   ZRL Min Occurs 1 Max Occurs 1 Tag="ZRL" Data Element Separation="Tagged Delimited" Group Terminator="<CR><LF>" Delimiter = "|" Suppress Absent Element Delimiters="End of Type" Observe Element Length Checked
      ZRL_2_Transmission_Sequence_Number Min Occurs 1 Max Occurs 1 string
      ZRL_3_Facility_Mnemonic Min Occurs 1 Max Occurs 1 string
      ZRL_4_Facility_Name Min Occurs 1 Max Occurs 1 string
      ZRL_5_Facility_Location Min  Occurs 1 Max Occurs 1 Data Element Separation="All Elements Delimited" Delimiter="^" Suppress Absent Element Delimiters="End of Type" Observe Element Length Checked
           ZRL_5_1_Facility_Address Min Occurs 1 Max Occurs 1 string
           ZRL_5_2_Facility_Other_Designation Min Occurs 1 Max Occurs 1 string
           ZRL_5_3_Facility_City Min Occurs 1 Max Occurs 1 string
           ZRL_5_4_Facility_State_Province Min Occurs 1 Max Occurs 1 string
           ZRL_5_5_Facility_Zip_Postal_Code Min Occurs 1 Max Occurs 1 string
      ZRL_6_Facility_Phone_Number Min Occurs 1 Max Occurs 1 string
      ZRL_7_Facility_Contact Min Occurs 1 Max Occurs 1 string
      ZRL_8_Facility_Director Min Occurs 1 Max Occurs 1 Data Element Separation="All Elements Delimited" Delimiter="^" Suppress Absent Element Delimiters="End of Type" Observe Element Length Checked
           ZRL_8_1_Facility_Director_Title Min Occurs 1 Max Occurs 1 string
           ZRL_8_2_Facility_Director_Last_Name Min Occurs 1 Max Occurs 1 string
           ZRL_8_3_Facility_Director_First_Name Min Occurs 1 Max Occurs 1 string
           ZRL_8_4_Facility_Director_Middle_Initial Min occurs 1 Max Occurs 1 string
           ZRL_8_5_Facility_Director_Suffix Min Occurs 1 Max Occurs 1 string
           ZRL_8_6_Facility_Director_Prefix Min Occurs 1 Max Occurs 1 string
           ZRL_8_7_Facility_Director_Degree Min Occurs 1 Max Occurs 1 string
      ZRL_9_Future_Field Min Occurs 0 Max Occurs 1 string
      ZRL_10_Future_Field Min Occurs 0 Max Occurs 1 string     
      ZRL_11_Future_Field Min Occurs 0 Max Occurs 1 string
      ZRL_12_Future_Field Min Occurs 0 Max Occurs 1 string
      ZRL_13_Future_Field Min Occurs 0 Max Occurs 1 string

   ZOI Min Occurs 1 Max Occurs 1 Tag="ZOI" Data Element Separation="Tagged Delimited" Group Terminator="<CR><LF>" Delimiter = "|" Suppress Absent Element Delimiters="End of Type" Observe Element Length Checked
      ZOI_2_Number_Of_Occurrences Min Occurs 1 Max Occurs 1 string
      ZOI_3_Ordered_Item_List Min Occurs 1 Max Occurs -1 Repeating Delimiter="~" Data Element Separation="All Elements Delimited" Group Terminator="~" Delimiter="^" Suppress Absent Element Delimiters="End of Type" Observe Element Length Checked
           ZOI_3_1_TIX_Test_Number Min Occurs 1 Max Occurs 1 string
           ZOI_3_2_TIX_Test_Name Min Occurs 1 Max Occurs 1 string
           ZOI_3_3_TIX_Test_Status Min Occurs 1 Max Occurs 1 string
           ZOI_3_4_Ordered_Item_Name Occurs 1 Max Occurs 1 string
     ZOI_4_Future_Field Min Occurs 0 Max Occurs 1 string
     ZOI_5_Future_Field Min Occurs 0 Max Occurs 1 string
     ZOI_6_Future_Field Min Occurs 0 Max Occurs 1 string
     ZOI_7_Future_Field Min Occurs 0 Max Occurs 1 string
     ZOI_8_Future_Field Min Occurs 0 Max Occurs 1 string



Code:

Trace Node Output:
(
  (0x01000000):Properties = (
    (0x03000000):MessageSet      = 'LB8SAQG002001'
    (0x03000000):MessageType     = 'DOC1TDS'
    (0x03000000):MessageFormat   = 'TDS1'
    (0x03000000):Encoding        = 273
    (0x03000000):CodedCharSetId  = 819
    (0x03000000):Transactional   = TRUE
    (0x03000000):Persistence     = FALSE
    (0x03000000):CreationTime    = GMTTIMESTAMP '2009-04-20 16:23:43.400'
    (0x03000000):ExpirationTime  = -1
    (0x03000000):Priority        = 0
    (0x03000000):ReplyIdentifier = X'000000000000000000000000000000000000000000000000'
    (0x03000000):ReplyProtocol   = 'MQ'
    (0x03000000):Topic           = NULL
    (0x03000000):ContentType     = ''
  )
  (0x01000000):MQMD       = (
    (0x03000000):SourceQueue      = 'TEST.WELDON.IN.QL'
    (0x03000000):Transactional    = TRUE
    (0x03000000):Encoding         = 273
    (0x03000000):CodedCharSetId   = 819
    (0x03000000):Format           = 'MQSTR   '
    (0x03000000):Version          = 2
    (0x03000000):Report           = 0
    (0x03000000):MsgType          = 8
    (0x03000000):Expiry           = -1
    (0x03000000):Feedback         = 0
    (0x03000000):Priority         = 0
    (0x03000000):Persistence      = 0
    (0x03000000):MsgId            = X'414d5120514d4d53474441412020202049d9330f200a224a'
    (0x03000000):CorrelId         = X'000000000000000000000000000000000000000000000000'
    (0x03000000):BackoutCount     = 0
    (0x03000000):ReplyToQ         = '                                                '
    (0x03000000):ReplyToQMgr      = 'QMMSGDAA                                        '
    (0x03000000):UserIdentifier   = 'moorew      '
    (0x03000000):AccountingToken  = X'0000000000000000000000000000000000000000000000000000000000000000'
    (0x03000000):ApplIdentityData = '                                '
    (0x03000000):PutApplType      = 28
    (0x03000000):PutApplName      = 'WebSphere MQ Client for Java'
    (0x03000000):PutDate          = DATE '2009-04-20'
    (0x03000000):PutTime          = GMTTIME '16:23:43.400'
    (0x03000000):ApplOriginData   = '    '
    (0x03000000):GroupId          = X'000000000000000000000000000000000000000000000000'
    (0x03000000):MsgSeqNumber     = 1
    (0x03000000):Offset           = 0
    (0x03000000):MsgFlags         = 0
    (0x03000000):OriginalLength   = -1
  )
  (0x01000021):MRM        = (
    (0x01000013):ZRL = (
      (0x0300000B):ZRL_2_Transmission_Sequence_Number = '1'
      (0x0300000B):ZRL_3_Facility_Mnemonic            = 'Lab'
      (0x0300000B):ZRL_4_Facility_Name                = 'Facility Name'
      (0x01000013):ZRL_5_Facility_Location            = (
        (0x0300000B):ZRL_5_1_Facility_Address         = 'Address'
        (0x0300000B):ZRL_5_3_Facility_City            = 'City'
        (0x0300000B):ZRL_5_4_Facility_State_Province  = 'NC'
        (0x0300000B):ZRL_5_5_Facility_Zip_Postal_Code = 'Zipplus4'
      )
      (0x0300000B):ZRL_6_Facility_Phone_Number        = 'phone nbr'
      (0x0300000B):ZRL_7_Facility_Contact             = ''
      (0x01000013):ZRL_8_Facility_Director            = (
        (0x0300000B):ZRL_8_1_Facility_Director_Title      = 'Title'
        (0x0300000B):ZRL_8_2_Facility_Director_Last_Name  = 'LName'
        (0x0300000B):ZRL_8_3_Facility_Director_First_Name = 'FName'
        (0x0300000B):ZRL_8_7_Facility_Director_Degree     = 'degree'
      )
      (0x0300000B):ZRL_9_Future_Field                 = ''
      (0x0300000B):ZRL_10_Future_Field                = ''
      (0x0300000B):ZRL_11_Future_Field                = ''
      (0x0300000B):ZRL_12_Future_Field                = ''
      (0x0300000B):ZRL_13_Future_Field                = ''
    )
    (0x01000013):ZOI = (
      (0x0300000B):ZOI_2_Number_Of_Occurrences = '5'
      (0x01000013):ZOI_3_Ordered_Item_List     = (
        (0x0300000B):ZOI_3_1_TIX_Test_Number   = '123456'
        (0x0300000B):ZOI_3_2_TIX_Test_Name     = 'TName1'
        (0x0300000B):ZOI_3_3_TIX_Test_Status   = 'TStatus1'
        (0x0300000B):ZOI_3_4_Ordered_Item_Name = 'OName1'
      )
      (0x01000013):ZOI_3_Ordered_Item_List     = (
        (0x0300000B):ZOI_3_1_TIX_Test_Number   = '234567'
        (0x0300000B):ZOI_3_2_TIX_Test_Name     = 'TName2'
        (0x0300000B):ZOI_3_3_TIX_Test_Status   = 'TStatus2'
        (0x0300000B):ZOI_3_4_Ordered_Item_Name = 'OName2'
      )
      (0x01000013):ZOI_3_Ordered_Item_List     = (
        (0x0300000B):ZOI_3_1_TIX_Test_Number   = '551697'
        (0x0300000B):ZOI_3_2_TIX_Test_Name     = 'TName3'
        (0x0300000B):ZOI_3_3_TIX_Test_Status   = 'TStatus3'
        (0x0300000B):ZOI_3_4_Ordered_Item_Name = 'OName3'
      )
      (0x01000013):ZOI_3_Ordered_Item_List     = (
        (0x0300000B):ZOI_3_1_TIX_Test_Number   = '998085'
        (0x0300000B):ZOI_3_2_TIX_Test_Name     = 'TName4'
        (0x0300000B):ZOI_3_3_TIX_Test_Status   = 'TStatus4'
        (0x0300000B):ZOI_3_4_Ordered_Item_Name = 'OName4'
      )
      (0x01000013):ZOI_3_Ordered_Item_List     = (
        (0x0300000B):ZOI_3_1_TIX_Test_Number   = 'X14500'
        (0x0300000B):ZOI_3_2_TIX_Test_Name     = 'Tname5'
        (0x0300000B):ZOI_3_3_TIX_Test_Status   = 'TStatus5'
        (0x0300000B):ZOI_3_4_Ordered_Item_Name = 'OName5'
      )
      (0x01000013):ZOI_3_Ordered_Item_List     = (
        (0x0300000B):ZOI_3_1_TIX_Test_Number = '
'
      )
    )
  )
)

Back to top
View user's profile Send private message
kimbert
PostPosted: Mon Apr 20, 2009 11:26 am    Post subject: Reply with quote

Jedi Council

Joined: 29 Jul 2003
Posts: 5542
Location: Southampton

Hi wraymore,

Thanks - good information there. I cannot give a definite reason for the difference, but I did notice this:
Code:
ZOI_3_Ordered_Item_List Min Occurs 1 Max Occurs -1 Repeating Delimiter="~"...
In TDS, delimiters always occur *between* elements, and Repeating Element Delimiters always occurs *between* occurrences of the repeating thing. However, your input message looks like this:
Code:
ZRL|1|Lab|Facility Name|Address^^City^NC^Zipplus4|phone nbr||Title^LName^FName^^^^degree|||||
ZOI|5|
123456^TName1^TStatus1^OName1~
234567^TName2^TStatus2^OName2~
551697^TName3^TStatus3^OName3~
998085^TName4^TStatus4^OName4~
X14500^Tname5^TStatus5^OName5~
||||
...with some line breaks added for clarity.
It is possible that the ~ after OName5 may be tripping up the parser. After seeing it, the parser will expect another ZOI_3. Might be worth removing it just to see what happens.
Back to top
View user's profile Send private message
wraymore
PostPosted: Mon Apr 20, 2009 11:55 am    Post subject: Reply with quote

Centurion

Joined: 16 Aug 2005
Posts: 114
Location: Burlington, NC USA

Changed the input message to remove the "~" after the last OName5 and put to the input queue of the message flow.
Code:

Input Message:
ZRL|1|Lab|Facility Name|Address^^City^NC^Zipplus4|phone nbr||Title^LName^FName^^^^degree|||||
ZOI|5|123456^TName1^TStatus1^OName1~234567^TName2^TStatus2^OName2~551697^TName3^TStatus3^OName3~998085^TName4^TStatus4^OName4~X14500^Tname5^TStatus5^OName5||||



However the output was the same
Code:

From Trace Node:
(
  (0x01000000):Properties = (
    (0x03000000):MessageSet      = 'LB8SAQG002001'
    (0x03000000):MessageType     = 'DOC1TDS'
    (0x03000000):MessageFormat   = 'TDS1'
    (0x03000000):Encoding        = 273
    (0x03000000):CodedCharSetId  = 819
    (0x03000000):Transactional   = TRUE
    (0x03000000):Persistence     = FALSE
    (0x03000000):CreationTime    = GMTTIMESTAMP '2009-04-20 19:48:21.340'
    (0x03000000):ExpirationTime  = -1
    (0x03000000):Priority        = 0
    (0x03000000):ReplyIdentifier = X'000000000000000000000000000000000000000000000000'
    (0x03000000):ReplyProtocol   = 'MQ'
    (0x03000000):Topic           = NULL
    (0x03000000):ContentType     = ''
  )
  (0x01000000):MQMD       = (
    (0x03000000):SourceQueue      = 'TEST.WELDON.IN.QL'
    (0x03000000):Transactional    = TRUE
    (0x03000000):Encoding         = 273
    (0x03000000):CodedCharSetId   = 819
    (0x03000000):Format           = 'MQSTR   '
    (0x03000000):Version          = 2
    (0x03000000):Report           = 0
    (0x03000000):MsgType          = 8
    (0x03000000):Expiry           = -1
    (0x03000000):Feedback         = 0
    (0x03000000):Priority         = 0
    (0x03000000):Persistence      = 0
    (0x03000000):MsgId            = X'414d5120514d4d53474441412020202049d9330f200a224a'
    (0x03000000):CorrelId         = X'000000000000000000000000000000000000000000000000'
    (0x03000000):BackoutCount     = 0
    (0x03000000):ReplyToQ         = '                                                '
    (0x03000000):ReplyToQMgr      = 'QMMSGDAA                                        '
    (0x03000000):UserIdentifier   = 'moorew      '
    (0x03000000):AccountingToken  = X'0000000000000000000000000000000000000000000000000000000000000000'
    (0x03000000):ApplIdentityData = '                                '
    (0x03000000):PutApplType      = 28
    (0x03000000):PutApplName      = 'WebSphere MQ Client for Java'
    (0x03000000):PutDate          = DATE '2009-04-20'
    (0x03000000):PutTime          = GMTTIME '19:48:21.340'
    (0x03000000):ApplOriginData   = '    '
    (0x03000000):GroupId          = X'000000000000000000000000000000000000000000000000'
    (0x03000000):MsgSeqNumber     = 1
    (0x03000000):Offset           = 0
    (0x03000000):MsgFlags         = 0
    (0x03000000):OriginalLength   = -1
  )
  (0x01000021):MRM        = (
    (0x01000013):ZRL = (
      (0x0300000B):ZRL_2_Transmission_Sequence_Number = '1'
      (0x0300000B):ZRL_3_Facility_Mnemonic            = 'Lab'
      (0x0300000B):ZRL_4_Facility_Name                = 'Facility Name'
      (0x01000013):ZRL_5_Facility_Location            = (
        (0x0300000B):ZRL_5_1_Facility_Address         = 'Address'
        (0x0300000B):ZRL_5_3_Facility_City            = 'City'
        (0x0300000B):ZRL_5_4_Facility_State_Province  = 'NC'
        (0x0300000B):ZRL_5_5_Facility_Zip_Postal_Code = 'Zipplus4'
      )
      (0x0300000B):ZRL_6_Facility_Phone_Number        = 'phone nbr'
      (0x0300000B):ZRL_7_Facility_Contact             = ''
      (0x01000013):ZRL_8_Facility_Director            = (
        (0x0300000B):ZRL_8_1_Facility_Director_Title      = 'Title'
        (0x0300000B):ZRL_8_2_Facility_Director_Last_Name  = 'LName'
        (0x0300000B):ZRL_8_3_Facility_Director_First_Name = 'FName'
        (0x0300000B):ZRL_8_7_Facility_Director_Degree     = 'degree'
      )
      (0x0300000B):ZRL_9_Future_Field                 = ''
      (0x0300000B):ZRL_10_Future_Field                = ''
      (0x0300000B):ZRL_11_Future_Field                = ''
      (0x0300000B):ZRL_12_Future_Field                = ''
      (0x0300000B):ZRL_13_Future_Field                = ''
    )
    (0x01000013):ZOI = (
      (0x0300000B):ZOI_2_Number_Of_Occurrences = '5'
      (0x01000013):ZOI_3_Ordered_Item_List     = (
        (0x0300000B):ZOI_3_1_TIX_Test_Number   = '123456'
        (0x0300000B):ZOI_3_2_TIX_Test_Name     = 'TName1'
        (0x0300000B):ZOI_3_3_TIX_Test_Status   = 'TStatus1'
        (0x0300000B):ZOI_3_4_Ordered_Item_Name = 'OName1'
      )
      (0x01000013):ZOI_3_Ordered_Item_List     = (
        (0x0300000B):ZOI_3_1_TIX_Test_Number   = '234567'
        (0x0300000B):ZOI_3_2_TIX_Test_Name     = 'TName2'
        (0x0300000B):ZOI_3_3_TIX_Test_Status   = 'TStatus2'
        (0x0300000B):ZOI_3_4_Ordered_Item_Name = 'OName2'
      )
      (0x01000013):ZOI_3_Ordered_Item_List     = (
        (0x0300000B):ZOI_3_1_TIX_Test_Number   = '551697'
        (0x0300000B):ZOI_3_2_TIX_Test_Name     = 'TName3'
        (0x0300000B):ZOI_3_3_TIX_Test_Status   = 'TStatus3'
        (0x0300000B):ZOI_3_4_Ordered_Item_Name = 'OName3'
      )
      (0x01000013):ZOI_3_Ordered_Item_List     = (
        (0x0300000B):ZOI_3_1_TIX_Test_Number   = '998085'
        (0x0300000B):ZOI_3_2_TIX_Test_Name     = 'TName4'
        (0x0300000B):ZOI_3_3_TIX_Test_Status   = 'TStatus4'
        (0x0300000B):ZOI_3_4_Ordered_Item_Name = 'OName4'
      )
      (0x01000013):ZOI_3_Ordered_Item_List     = (
        (0x0300000B):ZOI_3_1_TIX_Test_Number   = 'X14500'
        (0x0300000B):ZOI_3_2_TIX_Test_Name     = 'Tname5'
        (0x0300000B):ZOI_3_3_TIX_Test_Status   = 'TStatus5'
        (0x0300000B):ZOI_3_4_Ordered_Item_Name = 'OName5'
      )
      (0x01000013):ZOI_3_Ordered_Item_List     = (
        (0x0300000B):ZOI_3_1_TIX_Test_Number = '
'
      )
    )
  )
)
Back to top
View user's profile Send private message
kimbert
PostPosted: Mon Apr 20, 2009 12:19 pm    Post subject: Reply with quote

Jedi Council

Joined: 29 Jul 2003
Posts: 5542
Location: Southampton

I think it's time to raise a PMR. It may be something obvious, but if it is, then I can't see it.
Back to top
View user's profile Send private message
wraymore
PostPosted: Mon Apr 20, 2009 12:49 pm    Post subject: Reply with quote

Centurion

Joined: 16 Aug 2005
Posts: 114
Location: Burlington, NC USA

Mr. Kimber, thanks for your help. I will enter a PMR.
Back to top
View user's profile Send private message
rekarm01
PostPosted: Wed Apr 22, 2009 1:41 pm    Post subject: Re: TDS Question - field with sub fields and repeating Reply with quote

Grand Master

Joined: 25 Jun 2008
Posts: 1415

wraymore wrote:
Code:
Message Data Element Separation="Tagged Delimited" TagLength="3" GroupTerminator="<CR><LF>" Delimiter="CR><LF>" ...

"CR><LF>" looks like a typo.

wraymore wrote:
Code:
      ZOI_3_Ordered_Item_List Min Occurs 1 Max Occurs -1 Repeating Delimiter="~" Data Element Separation="All Elements Delimited" Group Terminator="~" Delimiter="^" ...

Group Terminator should be empty.
Back to top
View user's profile Send private message
wraymore
PostPosted: Thu Apr 23, 2009 5:13 am    Post subject: Reply with quote

Centurion

Joined: 16 Aug 2005
Posts: 114
Location: Burlington, NC USA

rekarm01 wrote:
Quote:

wraymore wrote:

Message Data Element Separation="Tagged Delimited" TagLength="3" GroupTerminator="<CR><LF>" Delimiter="CR><LF>" ...

"CR><LF>" looks like a typo.


Yes, that was a typo, it is actually "<CR><LF>"

rekarm01 wrote:

Quote:

wraymore wrote:
Code:
ZOI_3_Ordered_Item_List Min Occurs 1 Max Occurs -1 Repeating Delimiter="~" Data Element Separation="All Elements Delimited" Group Terminator="~" Delimiter="^" ...

Group Terminator should be empty.


When I removed the Group Terminator, the following resulted:
Code:

(0x01000021):MRM        = (
    (0x01000013):ZRL = (
      (0x0300000B):ZRL_2_Transmission_Sequence_Number = '1'
      (0x0300000B):ZRL_3_Facility_Mnemonic            = 'BN'
      (0x0300000B):ZRL_4_Facility_Name                = 'LabCorp Burlington'
      (0x01000013):ZRL_5_Facility_Location            = (
        (0x0300000B):ZRL_5_1_Facility_Address         = '1447 York Court'
        (0x0300000B):ZRL_5_3_Facility_City            = 'Burlington'
        (0x0300000B):ZRL_5_4_Facility_State_Province  = 'NC'
        (0x0300000B):ZRL_5_5_Facility_Zip_Postal_Code = '272153361'
      )
      (0x0300000B):ZRL_6_Facility_Phone_Number        = '8007624344'
      (0x0300000B):ZRL_7_Facility_Contact             = ''
      (0x01000013):ZRL_8_Facility_Director            = (
        (0x0300000B):ZRL_8_1_Facility_Director_Title      = 'MD'
        (0x0300000B):ZRL_8_2_Facility_Director_Last_Name  = 'Hancock'
        (0x0300000B):ZRL_8_3_Facility_Director_First_Name = 'William F'
        (0x0300000B):ZRL_8_7_Facility_Director_Degree     = 'MD'
      )
      (0x0300000B):ZRL_9_Future_Field                 = ''
      (0x0300000B):ZRL_10_Future_Field                = ''
      (0x0300000B):ZRL_11_Future_Field                = ''
      (0x0300000B):ZRL_12_Future_Field                = ''
      (0x0300000B):ZRL_13_Future_Field                = ''
    )
    (0x01000013):ZOI = (
      (0x0300000B):ZOI_2_Number_Of_Occurrences = '5'
      (0x01000013):ZOI_3_Ordered_Item_List     = (
        (0x0300000B):ZOI_3_1_TIX_Test_Number   = '100111'
        (0x0300000B):ZOI_3_2_TIX_Test_Name     = 'SPECIM'
        (0x0300000B):ZOI_3_3_TIX_Test_Status   = 'E'
        (0x0300000B):ZOI_3_4_Ordered_Item_Name = 'STATUS REPORT~829574^MONOGR^I^Monogram Trofile~551697^GENOSU^R^GenoSure~998085^VENIPU^S^Venipuncture~X14500^MDP30^S^Oxon Hill,MD      301-567-2819~'
      )
      (0x01000013):ZOI_3_Ordered_Item_List     = (
        (0x0300000B):ZOI_3_1_TIX_Test_Number = '
'
      )
    )
  )

Back to top
View user's profile Send private message
wraymore
PostPosted: Thu Apr 23, 2009 10:33 am    Post subject: Reply with quote

Centurion

Joined: 16 Aug 2005
Posts: 114
Location: Burlington, NC USA

PMR has been submitted. Will reply with solution.
Back to top
View user's profile Send private message
wraymore
PostPosted: Tue Apr 28, 2009 12:13 pm    Post subject: Reply with quote

Centurion

Joined: 16 Aug 2005
Posts: 114
Location: Burlington, NC USA

No solution from the PMR (30779 499 000)

Quote:

From Support:
I took a look at the problem description but it doesn't seem to relate to the product defect.
As you know, we are from product defect support organization. We are not equipped to assist on this matter.
I would like to suggest you to work with IBM Service to get additional help.
You can contact your sales rep to find the contact info or more info.

Regards,
Minsung



Will continue trying to figure out how to make this work.

Thanks for all of the help!!
Back to top
View user's profile Send private message
wraymore
PostPosted: Thu May 14, 2009 7:44 am    Post subject: Reply with quote

Centurion

Joined: 16 Aug 2005
Posts: 114
Location: Burlington, NC USA

As stated by IBM support it was not a product defect. However they were able to determine why I was having the issue. I had the parent elements defined as Tagged Delimited which was telling the parser that the children would have tags. This was not the case. They instructed me to change the data element separation field to be "All Elements Delimited" and to remove the group terminator form the complex type for the field containing the repeats since it was defined as the Repeating Element Delimiter.

New Message Model:
Code:

Message Model:
Message Data Element Separation="Tagged Delimited" TagLength="3" GroupTerminator="<CR><LF>" Delimiter="CR><LF>" Suppress Absent Element Delimiters="End of Type" Observe Element Length Not Checked
   ZRL Min Occurs 1 Max Occurs 1 Tag="ZRL" Data Element Separation="All Elements Delimited" Group Terminator="<CR><LF>" Delimiter = "|" Suppress Absent Element Delimiters="End of Type" Observe Element Length Checked
      ZRL_2_Transmission_Sequence_Number Min Occurs 1 Max Occurs 1 string
      ZRL_3_Facility_Mnemonic Min Occurs 1 Max Occurs 1 string
      ZRL_4_Facility_Name Min Occurs 1 Max Occurs 1 string
      ZRL_5_Facility_Location Min  Occurs 1 Max Occurs 1 Data Element Separation="All Elements Delimited" Delimiter="^" Suppress Absent Element Delimiters="End of Type" Observe Element Length Checked
           ZRL_5_1_Facility_Address Min Occurs 1 Max Occurs 1 string
           ZRL_5_2_Facility_Other_Designation Min Occurs 1 Max Occurs 1 string
           ZRL_5_3_Facility_City Min Occurs 1 Max Occurs 1 string
           ZRL_5_4_Facility_State_Province Min Occurs 1 Max Occurs 1 string
           ZRL_5_5_Facility_Zip_Postal_Code Min Occurs 1 Max Occurs 1 string
      ZRL_6_Facility_Phone_Number Min Occurs 1 Max Occurs 1 string
      ZRL_7_Facility_Contact Min Occurs 1 Max Occurs 1 string
      ZRL_8_Facility_Director Min Occurs 1 Max Occurs 1 Data Element Separation="All Elements Delimited" Delimiter="^" Suppress Absent Element Delimiters="End of Type" Observe Element Length Checked
           ZRL_8_1_Facility_Director_Title Min Occurs 1 Max Occurs 1 string
           ZRL_8_2_Facility_Director_Last_Name Min Occurs 1 Max Occurs 1 string
           ZRL_8_3_Facility_Director_First_Name Min Occurs 1 Max Occurs 1 string
           ZRL_8_4_Facility_Director_Middle_Initial Min occurs 1 Max Occurs 1 string
           ZRL_8_5_Facility_Director_Suffix Min Occurs 1 Max Occurs 1 string
           ZRL_8_6_Facility_Director_Prefix Min Occurs 1 Max Occurs 1 string
           ZRL_8_7_Facility_Director_Degree Min Occurs 1 Max Occurs 1 string
      ZRL_9_Future_Field Min Occurs 0 Max Occurs 1 string
      ZRL_10_Future_Field Min Occurs 0 Max Occurs 1 string     
      ZRL_11_Future_Field Min Occurs 0 Max Occurs 1 string
      ZRL_12_Future_Field Min Occurs 0 Max Occurs 1 string
      ZRL_13_Future_Field Min Occurs 0 Max Occurs 1 string

   ZOI Min Occurs 1 Max Occurs 1 Tag="ZOI" Data Element Separation="All Elements Delimited" Group Terminator="<CR><LF>" Delimiter = "|" Suppress Absent Element Delimiters="End of Type" Observe Element Length Checked
      ZOI_2_Number_Of_Occurrences Min Occurs 1 Max Occurs 1 string
      ZOI_3_Ordered_Item_List Min Occurs 1 Max Occurs -1 Repeating Delimiter="~" Data Element Separation="All Elements Delimited" Group Terminator="" Delimiter="^" Suppress Absent Element Delimiters="End of Type" Observe Element Length Checked
           ZOI_3_1_TIX_Test_Number Min Occurs 1 Max Occurs 1 string
           ZOI_3_2_TIX_Test_Name Min Occurs 1 Max Occurs 1 string
           ZOI_3_3_TIX_Test_Status Min Occurs 1 Max Occurs 1 string
           ZOI_3_4_Ordered_Item_Name Occurs 1 Max Occurs 1 string
     ZOI_4_Future_Field Min Occurs 0 Max Occurs 1 string
     ZOI_5_Future_Field Min Occurs 0 Max Occurs 1 string
     ZOI_6_Future_Field Min Occurs 0 Max Occurs 1 string
     ZOI_7_Future_Field Min Occurs 0 Max Occurs 1 string
     ZOI_8_Future_Field Min Occurs 0 Max Occurs 1 string


Back to top
View user's profile Send private message
Vitor
PostPosted: Thu May 14, 2009 7:53 am    Post subject: Reply with quote

Grand High Poobah

Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA

Thank you for posting the solution!
_________________
Honesty is the best policy.
Insanity is the best defence.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » TDS Question - field with sub fields and repeating Resolved
Jump to:  



You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Protected by Anti-Spam ACP
 
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.