| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Migrating from MQSI 2.1 to MB 6.0 issues.... |
« View previous topic :: View next topic » |
| Author |
Message
|
| kevin_22 |
 Posted: Fri Aug 25, 2006 3:45 am Post subject: Migrating from MQSI 2.1 to MB 6.0 issues.... |
 |
|
Centurion
Joined: 08 Mar 2005
Posts: 100
|
Hi ,
I am migrating my Message sets and Message Flows from MQSI 2.1 to MB 6.0. While migrating Message sets i am encountering some problem.
Description of the problem:
My Input Message is CSV and my Output Message structure is CSV. I created a Compound elements in MQSI2.1 which containing some local elements for Input Message.
Message set structure for Input:
-------------------
Comp
ele1
...
up to ele13
Output Message Structure
G_comp ----not repeating
ele1
ele2....ele6
I_comp ----repeating
ele1 .....ele8
D_comp----repeating
ele1....ele5
Expected output is
G
I
D
D
I
D
D
This is working fine with MQSI2.1 but when i migrated to MB6.0 this is not working well.
The output it is producing is
G
I
D
D
While the second I and the two D's are missing.
Is this because of any problem with my Message set??? Why it is working well in MQSI 2.1 or is it a bug???
Thanks
Kevin |
|
| Back to top |
|
 |
| kimbert |
| Posted: Fri Aug 25, 2006 4:25 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
Migration should just work, so it's not a problem with your message set.
I may well be able to diagnose this and suggest a simple fix.
- Please post the details of the TDS physical format ( you have described the logical model, but not the TDS settings ).
- If you can, please also put a trace node after the MQInput node with pattern ${Root}, and post the output here. |
|
| Back to top |
|
|
| kevin_22 |
| Posted: Fri Aug 25, 2006 5:02 am Post subject: |
|
|
Centurion
Joined: 08 Mar 2005
Posts: 100
|
Hi kimbert,
Thanks for your help,
In both MQSI2.1 and MB 6.0 Input structure or Message doesn't got any problem but in MB 6.0 , problem lies with output Message creation.
Here is the Input Trace and OutputTrace,
Input Sturcture:
| Code: |
(
(0x1000000)Properties = (
(0x3000000)MessageSet = 'E8SMG6G07O001'
(0x3000000)MessageType = 'BEL_AR_INV'
(0x3000000)MessageFormat = 'TDS'
(0x3000000)Encoding = 546
(0x3000000)CodedCharSetId = 437
(0x3000000)Transactional = TRUE
(0x3000000)Persistence = FALSE
(0x3000000)CreationTime = GMTTIMESTAMP '2006-06-25 12:52:50.870'
(0x3000000)ExpirationTime = -1
(0x3000000)Priority = 0
(0x3000000)ReplyIdentifier = X'000000000000000000000000000000000000000000000000'
(0x3000000)ReplyProtocol = 'MQ'
(0x3000000)Topic = NULL
)
(0x1000000)MQMD = (
(0x3000000)SourceQueue = 'BE.AR.INVOICE.INPUT.QUEUE'
(0x3000000)Transactional = TRUE
(0x3000000)Encoding = 546
(0x3000000)CodedCharSetId = 437
(0x3000000)Format = ' '
(0x3000000)Version = 2
(0x3000000)Report = 0
(0x3000000)MsgType = 8
(0x3000000)Expiry = -1
(0x3000000)Feedback = 0
(0x3000000)Priority = 0
(0x3000000)Persistence = 0
(0x3000000)MsgId = X'414d51204d51495f514d20202020202095849e4420001408'
(0x3000000)CorrelId = X'000000000000000000000000000000000000000000000000'
(0x3000000)BackoutCount = 0
(0x3000000)ReplyToQ = ' '
(0x3000000)ReplyToQMgr = 'MQI_QM '
(0x3000000)UserIdentifier = 'mqsiuid '
(0x3000000)AccountingToken = X'160105150000000a4a06501a01e5116da02497f403000000000000000000000b'
(0x3000000)ApplIdentityData = ' '
(0x3000000)PutApplType = 11
(0x3000000)PutApplName = '\SupportPac IH03\rfhutil.exe'
(0x3000000)PutDate = DATE '2006-06-25'
(0x3000000)PutTime = GMTTIME '12:52:50.870'
(0x3000000)ApplOriginData = ' '
(0x3000000)GroupId = X'000000000000000000000000000000000000000000000000'
(0x3000000)MsgSeqNumber = 1
(0x3000000)Offset = 0
(0x3000000)MsgFlags = 0
(0x3000000)OriginalLength = -1
)
(0x1000021)MRM = (
(0x1000013)BEL_COMP = (
(0x300000B)Business_Unit = 'ORIGN'
(0x300000B)Invoice_Date = '20060716'
)
(0x1000013)BEL_COMP = (
(0x300000B)Business_Unit = 'BE001'
(0x300000B)Invoice_Date = '20060716'
(0x300000B)Customer_ID = '0042137'
(0x300000B)Item_ID = '76067'
(0x300000B)Inv_Gross_Amt = '172230'
(0x300000B)Entry_Type = 'CR'
(0x300000B)Payment_Terms = '060'
(0x300000B)SubCust_Qual1 = '0141'
(0x300000B)VAT_Amt = '29891'
(0x300000B)Net_Amt = '142339'
(0x300000B)Org_Inv_Number = '142339'
(0x300000B)Tax_Code = '210'
(0x300000B)AR_Account = '33333'
(0x300000B)VAT_Account = '444444'
(0x300000B)Revenue_Account = '555555'
(0x300000B)Revenue_Dept = '666666'
(0x300000B)VAT_Tax_Type_Code = '0141'
)
(0x1000013)BEL_COMP = (
(0x300000B)Business_Unit = 'BE001'
(0x300000B)Invoice_Date = '20060716'
(0x300000B)Customer_ID = '0042137'
(0x300000B)Item_ID = '76068'
(0x300000B)Inv_Gross_Amt = '289221'
(0x300000B)Entry_Type = 'CR'
(0x300000B)Payment_Terms = '060'
(0x300000B)SubCust_Qual1 = '0141'
(0x300000B)VAT_Amt = '50195'
(0x300000B)Net_Amt = '239026'
(0x300000B)Org_Inv_Number = '239026'
(0x300000B)Tax_Code = '210'
(0x300000B)AR_Account = '33333'
(0x300000B)VAT_Account = '444444'
(0x300000B)Revenue_Account = '555555'
(0x300000B)Revenue_Dept = '666666'
(0x300000B)VAT_Tax_Type_Code = '0141'
)
)
)
|
OutputStructure :
| Code: |
(
(0x1000000)Properties = (
(0x3000000)MessageSet = 'E8SMG6G07Q001'
(0x3000000)MessageType = 'PSFT'
(0x3000000)MessageFormat = 'TDS'
(0x3000000)Encoding = 546
(0x3000000)CodedCharSetId = 437
(0x3000000)Transactional = TRUE
(0x3000000)Persistence = FALSE
(0x3000000)CreationTime = GMTTIMESTAMP '2006-06-25 12:59:26.420'
(0x3000000)ExpirationTime = -1
(0x3000000)Priority = 0
(0x3000000)ReplyIdentifier = X'000000000000000000000000000000000000000000000000'
(0x3000000)ReplyProtocol = 'MQ'
(0x3000000)Topic = NULL
)
(0x1000000)MQMD = (
(0x3000000)SourceQueue = 'BE.AR.INVOICE.INPUT.QUEUE'
(0x3000000)Transactional = TRUE
(0x3000000)Encoding = 546
(0x3000000)CodedCharSetId = 437
(0x3000000)Format = ' '
(0x3000000)Version = 2
(0x3000000)Report = 0
(0x3000000)MsgType = 8
(0x3000000)Expiry = -1
(0x3000000)Feedback = 0
(0x3000000)Priority = 0
(0x3000000)Persistence = 0
(0x3000000)MsgId = X'414d51204d51495f514d20202020202095849e4420001409'
(0x3000000)CorrelId = X'000000000000000000000000000000000000000000000000'
(0x3000000)BackoutCount = 0
(0x3000000)ReplyToQ = ' '
(0x3000000)ReplyToQMgr = 'MQI_QM '
(0x3000000)UserIdentifier = 'mqsiuid '
(0x3000000)AccountingToken = X'160105150000000a4a06501a01e5116da02497f403000000000000000000000b'
(0x3000000)ApplIdentityData = ' '
(0x3000000)PutApplType = 11
(0x3000000)PutApplName = '\SupportPac IH03\rfhutil.exe'
(0x3000000)PutDate = DATE '2006-06-25'
(0x3000000)PutTime = GMTTIME '12:59:26.420'
(0x3000000)ApplOriginData = ' '
(0x3000000)GroupId = X'000000000000000000000000000000000000000000000000'
(0x3000000)MsgSeqNumber = 1
(0x3000000)Offset = 0
(0x3000000)MsgFlags = 0
(0x3000000)OriginalLength = -1
)
(0x1000021)MRM = (
(0x1000000)G_COMP = (
(0x3000000)G1 = 'G'
(0x3000000)G2 = 'BE001'
(0x3000000)G3 = 'NEXT'
(0x3000000)G4 = 'INTFC'
(0x3000000)G5 = 'B'
(0x3000000)G6 = 'L'
(0x3000000)G7 = '4614.51'
(0x3000000)G8 = '2'
(0x3000000)G9 = 'EPBILL'
(0x3000000)G10 = '2006-07-16'
(0x3000000)G11 = 'EUR'
(0x3000000)G12 = 'Y'
)
(0x1000000)I_COMP = (
(0x3000000)I1 = 'I'
(0x3000000)I2 = '0042137'
(0x3000000)I3 = '76067'
(0x3000000)I4 = '1722.30'
(0x3000000)I5 = '2006-07-16'
(0x3000000)I6 = '2006-07-16'
(0x3000000)I7 = 'CR'
(0x3000000)I8 = '060'
(0x3000000)I9 = 'I'
(0x3000000)I10 = '0141'
(0x3000000)I11 = '1423.39'
(0x3000000)I12 = '142339'
(0x3000000)I13 = '298.91'
)
(0x1000000)D_COMP = (
(0x3000000)D1 = 'D'
(0x3000000)D2 = 'A'
(0x3000000)D4 = '33333'
(0x3000000)D5 = '1722.30'
)
(0x1000000)D_COMP = (
(0x3000000)D1 = 'D'
(0x3000000)D2 = 'U'
(0x3000000)D3 = '666666'
(0x3000000)D4 = '555555'
(0x3000000)D5 = '1423.39'
)
(0x1000000)D_COMP = (
(0x3000000)D1 = 'D'
(0x3000000)D2 = 'V'
(0x3000000)D4 = '444444'
(0x3000000)D5 = '298.91'
(0x3000000)D6 = '210'
(0x3000000)D7 = '0141'
)
(0x1000000)I_COMP = (
(0x3000000)I1 = 'I'
(0x3000000)I2 = '0042137'
(0x3000000)I3 = '76068'
(0x3000000)I4 = '2892.21'
(0x3000000)I5 = '2006-07-16'
(0x3000000)I6 = '2006-07-16'
(0x3000000)I7 = 'CR'
(0x3000000)I8 = '060'
(0x3000000)I9 = 'I'
(0x3000000)I10 = '0141'
(0x3000000)I11 = '2390.26'
(0x3000000)I12 = '239026'
(0x3000000)I13 = '501.95'
)
(0x1000000)D_COMP = (
(0x3000000)D1 = 'D'
(0x3000000)D2 = 'A'
(0x3000000)D4 = '33333'
(0x3000000)D5 = '2892.21'
)
(0x1000000)D_COMP = (
(0x3000000)D1 = 'D'
(0x3000000)D2 = 'U'
(0x3000000)D3 = '666666'
(0x3000000)D4 = '555555'
(0x3000000)D5 = '2390.26'
)
(0x1000000)D_COMP = (
(0x3000000)D1 = 'D'
(0x3000000)D2 = 'V'
(0x3000000)D4 = '444444'
(0x3000000)D5 = '501.95'
(0x3000000)D6 = '210'
(0x3000000)D7 = '0141'
)
)
)
|
Thanks,
Kevin |
|
| Back to top |
|
|
| kevin_22 |
| Posted: Fri Aug 25, 2006 5:09 am Post subject: |
|
|
Centurion
Joined: 08 Mar 2005
Posts: 100
|
As you notice in the Input structure and Output structure ,
In the Input Structure there are 3 records of which 1st one is header which not consider. so there are two invoice records.Each invoice record maps to G , I , D , D ,D
Thanks,
Kevin |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Fri Aug 25, 2006 5:17 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
If I understand your logical model, then you have said that the output message can consist of the following things in the following order.
One G.
At least one I - but maybe more
At least one D - but maybe more.
You have not said that the model can have
One G.
At least one copy of the following structure:
- At least one I, but maybe more
- At least one D, but maybe more
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Fri Aug 25, 2006 5:19 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Depending on the actual message requirements, you could also model this as
One G.
At least one, but maybe more of the following choice:
-One I OR
-One D.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| kevin_22 |
| Posted: Sun Aug 27, 2006 10:15 pm Post subject: |
|
|
Centurion
Joined: 08 Mar 2005
Posts: 100
|
Hi Jeff,
The issue here is that, as you see the output structure containing one G and at least on copy of I and D records, when I am writing this message with out any manipulation to the output queue it was like
| Quote: |
G,BE001,NEXT,INTFC,B,L,5194.2,3,EPBILL,20060716,EUR,Y
I,0042137,76067,1722.30,2006-07-16,2006-07-16,CR,060,I,0141,1423.39,142339,298.91
D,A,,33333,1722.30
D,U,666666,555555,1423.39
D,V,,444444,298.91,210,0141
|
where the Expected output is
| Quote: |
G,BE001,NEXT,INTFC,B,L,5194.2,3,EPBILL,20060716,EUR,Y
I,0042137,76067,1722.30,2006-07-16,2006-07-16,CR,CR,I,0141,1423.39,142339,298.91
D,A,,33333,1722.30
D,U,666666,555555,1423.39
D,V,,444444,298.91,210,0141
I,0042137,76068,2892.21,2006-07-16,2006-07-16,CR,CR,I,0141,2390.26,239026,501.95
D,A,,33333,2892.21
D,U,666666,555555,2390.26
D,V,,444444,501.95,210,0141
I,0047061,76070,579.69,2006-07-16,2006-07-16,CR,CR,I,0143,479.08,47908,100.61
D,A,,33333,579.69
D,U,666666,555555,479.08
D,V,,444444,100.61,210,0143
|
I could able to achive this in MQSI2.1 but the migrated message flow was producing the earlier Output structure.
Environment Details:
Win 2003, MQSI 2.1 , MB Toolkit 6.0.0.1 ,Message Broker 6002 ,MQ 6.0
Thanks,
Kevin |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Mon Aug 28, 2006 1:40 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
You must have set some repeating counts or something on the message itself.
Nowhere in what you have posted of your message structure have you indicated that it is allowable for there to be more than one G structure.
And nowhere have you said that it is okay if there is an I that comes AFTER a D.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| kevin_22 |
| Posted: Mon Aug 28, 2006 2:33 am Post subject: |
|
|
Centurion
Joined: 08 Mar 2005
Posts: 100
|
Hi Jeff,
In my Output Message Set, the properties are - G is not repeating and I and D are repeating so I and D can occur at any combinations and yes i created this sturcture by keeping I and D in a loop. If i am not pointing to your question excuse me and please go in to the details.
Thanks,
Kevin. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Mon Aug 28, 2006 3:05 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
So you've said that that there can only be one G.
Edit:
The reason that it "works" in v2.1 is probably that the v2.1 output node is doing the "wrong" thing - by concatenating the output message tree to the message bitstream. And v6 has corrected this behavior, so all you get on the Output is the message itself.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
