| Author |
Message
|
| klabran |
 Posted: Thu May 06, 2004 6:19 am Post subject: Yet another XML to XML Integrator question |
 |
|
Master
Joined: 19 Feb 2004
Posts: 259
Location: Flagstaff AZ
|
I was just reading in my old class exercises (from MQSI 2.0.2) that when doing Message sets based on XML the message set does not need to be assigned/deployed to the broker.
If this is the case then should on my input q settings set the DOMAIN to XML and not MRM and then ignore the message ID etc. properties? Which is what I thought I should do with an XML to XML flow with the XML mapped to an MRM.
I also noticed that the sample in my exercise showed that the runtime tab for this message was set to XML not MRM. However, mqsiimpxmlschema set the runtime tab to MRM. Should I change this to XML? Remove the message sets from the broker and treat the input q as an XML Domain?
Doing this would still allow for the drag and drop functionality and the use of the db nodes ect?
I am using WMQI 2.1 CSD6 now.
Thanks for any assistance to helping my fledgling Integrator knowledge.
Kevin |
|
| Back to top |
|
 |
| klabran |
| Posted: Thu May 06, 2004 3:17 pm Post subject: |
|
|
Master
Joined: 19 Feb 2004
Posts: 259
Location: Flagstaff AZ
|
UNCLE !!!! 
Can anyone point me to tutorials,ect.... that would walk me through taking a flow that has an incoming XML and an outgoing XML with both of them defined in message sets so that I can take advantage of the drag/drop and DB nodes.
I've seen MRM - XML and TDW-XML or TDW-MRM but nothing on XML-XML with the XML being defined in messages.
I've already done XML - XML without message definitions...no problem.
 Thanks for any assistance. 
Kevin |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu May 06, 2004 4:21 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
You can't use the drag&drop functionality without an MRM model.
You can, however, just map XML to XML without MRM at all.
But you can't validate the XML automatically.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| klabran |
| Posted: Mon May 10, 2004 8:05 am Post subject: |
|
|
Master
Joined: 19 Feb 2004
Posts: 259
Location: Flagstaff AZ
|
Jeff,
What do mean by...
| Quote: |
You can, however, just map XML to XML without MRM at all.
|
I am currently using ESQL to map XML to XML flows without any message set definitions.
I am trying to take the XML incoming message and XML outgoing message convert them to MRM using the mqsiimpxmlschema program. Then I could use drag and drop functionality and with the XML wire formats still use the incoming and outgoing XML formats. Hence, I gain more functionality in the control center and I can still use XML without any conversion before I put it to a queue/flow.
This appears to be what I have seen/told to do by individuals and/or some manuals.
In the impxmlschema manual it states
| Quote: |
| The importer imports W3C standard XML Schema into the Websphere MQ Integrator Message Repository Manager (MRM). The message sets that are created by the importer can then be used by MRM domain with Wire Format XML NOT the Generic XML Domain as in SupportPac id04. The imported message sets can be deployed to Websphere MQ Integrator V2.1 brokers. The message sets can also be used to for drag and drop when writing ESQL within compute nodes. |
Am I missing something?
Kevin |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Mon May 10, 2004 9:30 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
You have to make sure you're at the right csd levels for mqsiimpxmlschema program to work. And understand the limitations of schema importing and validation in v2.1.
And then it's mostly the same as using any other MRM message set on the input and output. You access the elements using InputRoot.MRM.<elementname>.
But you don't get things like (XML.Attribute) - those are modeled as regular (but also special) MRM fields.
So, what have you tried? What has or has not worked? Are you getting errors... etc.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| klabran |
| Posted: Mon May 10, 2004 9:52 am Post subject: |
|
|
Master
Joined: 19 Feb 2004
Posts: 259
Location: Flagstaff AZ
|
Jeff I have tried for several days to get it to work....
I am getting either errors or completely unexpected (for me) results.
My main thought is whether or not my idea on how this works is fundamentaly flawed or not.
I was hoping to use the MRM to model the incoming XML and outgoing XML in order to take advantage of the drag/drop while still using the incoming/outgoing XML without any changes to them.
However, the below post is a sample of some of the issues I am having.
http://www.mqseries.net/phpBB2/viewtopic.php?t=15134
It appears that something is not mapping on the incoming and/or outgoing the way I thought it would.
One thought I have but am not sure if it has any bearing on my situation is that my MRM field names have to be exactly the same as my incoming and outgoing XML tag names. I created a simple flow for this but the results were much the same as the above post.
I am dazed and confused at this point as to where and / or what I should be doing to get this to work.
I am using mqsi v2.1 with CSD06 and MQ 5.3 with CSD05. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Mon May 10, 2004 10:26 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Like I said, there are limitations, and caveats with mqsiimpxmlschema - both in how it works and what it can and can not do.
I don't remember where they are documented - I think they are only in the memo.ptf/readme. They might be in the Working With Messages guide.
The stuff you're seeing with "ANON^" is probably the importer trying to handle unnamed local elements or unnamed local types.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| klabran |
| Posted: Mon May 10, 2004 10:35 am Post subject: |
|
|
Master
Joined: 19 Feb 2004
Posts: 259
Location: Flagstaff AZ
|
currently my traces show that the incoming is getting mapped nicely to the MRM from the XML. When I go into the compute node however it appears that the output is blank and thus the xml parser blows up with no valid body of the document could be found error.
Any ideas?
here is the trace dump...
***************************************
(
(0x1000000)Properties = (
(0x3000000)MessageSet = 'DVVCFP808G001'
(0x3000000)MessageType = 'OUTMSG'
(0x3000000)MessageFormat = 'OUTXML'
(0x3000000)Encoding = 273
(0x3000000)CodedCharSetId = 437
(0x3000000)Transactional = TRUE
(0x3000000)Persistence = TRUE
(0x3000000)CreationTime = GMTTIMESTAMP '2004-05-10 18:30:27.530'
(0x3000000)ExpirationTime = -1
(0x3000000)Priority = 0
(0x3000000)ReplyIdentifier = X'000000000000000000000000000000000000000000000000'
(0x3000000)ReplyProtocol = 'MQ'
(0x3000000)Topic = NULL
)
(0x1000000)MQMD = (
(0x3000000)SourceQueue = 'QL_TEST2'
(0x3000000)Transactional = TRUE
(0x3000000)Encoding = 273
(0x3000000)CodedCharSetId = 437
(0x3000000)Format = 'MQSTR '
(0x3000000)Version = 2
(0x3000000)Report = 0
(0x3000000)MsgType = 1
(0x3000000)Expiry = -1
(0x3000000)Feedback = 0
(0x3000000)Priority = 0
(0x3000000)Persistence = 1
(0x3000000)MsgId = X'414d5120514d5f43435f5031202020207848904020033201'
(0x3000000)CorrelId = X'000000000000000000000000000000000000000000000000'
(0x3000000)BackoutCount = 0
(0x3000000)ReplyToQ = 'MQREPLY '
(0x3000000)ReplyToQMgr = 'MYQM '
(0x3000000)UserIdentifier = 'klabranche '
(0x3000000)AccountingToken = X'16010515000000b459d40753474578915f302f1d04000000000000000000000b'
(0x3000000)ApplIdentityData = ' '
(0x3000000)PutApplType = 11
(0x3000000)PutApplName = 'es\XML_MRM_TEST\mqsiputc.exe'
(0x3000000)PutDate = DATE '2004-05-10'
(0x3000000)PutTime = GMTTIME '18:30:27.530'
(0x3000000)ApplOriginData = ' '
(0x3000000)GroupId = X'000000000000000000000000000000000000000000000000'
(0x3000000)MsgSeqNumber = 1
(0x3000000)Offset = 0
(0x3000000)MsgFlags = 0
(0x3000000)OriginalLength = -1
)
(0x1000010)XML =
)
-----------------------------------
(
(0x1000000)RecoverableException = (
(0x3000000)File = 'F:\build\S210_P\src\DataFlowEngine\ImbDataFlowNode.cpp'
(0x3000000)Line = 536
(0x3000000)Function = 'ImbDataFlowNode::createExceptionList'
(0x3000000)Type = 'ComIbmMQOutputNode'
(0x3000000)Name = '354b9338-fc00-0000-0080-9be125d68863'
(0x3000000)Label = 'XMLMRM_TEST.MQOutput1'
(0x3000000)Text = 'Node throwing exception'
(0x3000000)Catalog = 'WMQIv210'
(0x3000000)Severity = 3
(0x3000000)Number = 2230
(0x1000000)ParserException = (
(0x3000000)File = 'F:\build\S210_P\src\MTI\MTIforBroker\GenXmlParser2\XmlImbParser.cpp'
(0x3000000)Line = 258
(0x3000000)Function = 'XmlImbParser::refreshBitStreamFromElements'
(0x3000000)Type = 'ComIbmMQInputNode'
(0x3000000)Name = '36429338-fc00-0000-0080-9be125d68863'
(0x3000000)Label = 'XMLMRM_TEST.MQInput1'
(0x3000000)Text = 'XML Writing Errors have occurred'
(0x3000000)Catalog = 'WMQIv210'
(0x3000000)Severity = 3
(0x3000000)Number = 5010
(0x1000000)ParserException = (
(0x3000000)File = 'F:\build\S210_P\src\MTI\MTIforBroker\GenXmlParser2\XmlImbParser.cpp'
(0x3000000)Line = 562
(0x3000000)Function = 'XmlImbParser::checkForBodyElement'
(0x3000000)Type = ''
(0x3000000)Name = ''
(0x3000000)Label = ''
(0x3000000)Text = 'No valid body of the document could be found.'
(0x3000000)Catalog = 'WMQIv210'
(0x3000000)Severity = 3
(0x3000000)Number = 5005
)
)
)
)
***************************************
***************************************
(
(0x1000000)Properties = (
(0x3000000)MessageSet = 'DVVCFP808K001'
(0x3000000)MessageType = 'INMSG'
(0x3000000)MessageFormat = 'INXML'
(0x3000000)Encoding = 273
(0x3000000)CodedCharSetId = 437
(0x3000000)Transactional = TRUE
(0x3000000)Persistence = TRUE
(0x3000000)CreationTime = GMTTIMESTAMP '2004-05-10 18:30:27.530'
(0x3000000)ExpirationTime = -1
(0x3000000)Priority = 0
(0x3000000)ReplyIdentifier = X'000000000000000000000000000000000000000000000000'
(0x3000000)ReplyProtocol = 'MQ'
(0x3000000)Topic = NULL
)
(0x1000000)MQMD = (
(0x3000000)SourceQueue = 'QL_TEST2'
(0x3000000)Transactional = TRUE
(0x3000000)Encoding = 273
(0x3000000)CodedCharSetId = 437
(0x3000000)Format = 'MQSTR '
(0x3000000)Version = 2
(0x3000000)Report = 0
(0x3000000)MsgType = 1
(0x3000000)Expiry = -1
(0x3000000)Feedback = 0
(0x3000000)Priority = 0
(0x3000000)Persistence = 1
(0x3000000)MsgId = X'414d5120514d5f43435f5031202020207848904020033201'
(0x3000000)CorrelId = X'000000000000000000000000000000000000000000000000'
(0x3000000)BackoutCount = 1
(0x3000000)ReplyToQ = 'MQREPLY '
(0x3000000)ReplyToQMgr = 'MYQM '
(0x3000000)UserIdentifier = 'klabranche '
(0x3000000)AccountingToken = X'16010515000000b459d40753474578915f302f1d04000000000000000000000b'
(0x3000000)ApplIdentityData = ' '
(0x3000000)PutApplType = 11
(0x3000000)PutApplName = 'es\XML_MRM_TEST\mqsiputc.exe'
(0x3000000)PutDate = DATE '2004-05-10'
(0x3000000)PutTime = GMTTIME '18:30:27.530'
(0x3000000)ApplOriginData = ' '
(0x3000000)GroupId = X'000000000000000000000000000000000000000000000000'
(0x3000000)MsgSeqNumber = 1
(0x3000000)Offset = 0
(0x3000000)MsgFlags = 0
(0x3000000)OriginalLength = -1
)
(0x1000021)MRM = (
(0x300000B)NAME = 'TEST'
(0x300000B)VERSION = '1'
(0x1000013)COMPLEX = (
(0x300000B)TEST = 'HELLO'
)
)
)
-----------------------------------
*************************************** |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Mon May 10, 2004 10:51 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
| klabran wrote: |
currently my traces show that the incoming is getting mapped nicely to the MRM from the XML. When I go into the compute node however it appears that the output is blank and thus the xml parser blows up with no valid body of the document could be found error.
Any ideas? |
So, you have
MQInput->Trace1->Compute->Trace2->MQOutput, or similar.
You are getting the "no valid body" error at Trace2?
Or Trace1?
If you're getting it at Trace1, then your message isn't valid for the MRM model - which likely means the model is wrong.
If you're getting it at Trace2, then likely your ESQL is wrong - or you have configured the Compute node to not pass the message body.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| klabran |
| Posted: Mon May 10, 2004 11:06 am Post subject: |
|
|
Master
Joined: 19 Feb 2004
Posts: 259
Location: Flagstaff AZ
|
That was correct on how I have it setup....
I was only copying the headers. I modified it to copy the entire message and now my error is....
***************************************
(
(0x1000000)Properties = (
(0x3000000)MessageSet = 'DVVCFP808K001'
(0x3000000)MessageType = 'INMSG'
(0x3000000)MessageFormat = 'OUTXML'
(0x3000000)Encoding = 273
(0x3000000)CodedCharSetId = 437
(0x3000000)Transactional = TRUE
(0x3000000)Persistence = TRUE
(0x3000000)CreationTime = GMTTIMESTAMP '2004-05-10 19:03:39.720'
(0x3000000)ExpirationTime = -1
(0x3000000)Priority = 0
(0x3000000)ReplyIdentifier = X'000000000000000000000000000000000000000000000000'
(0x3000000)ReplyProtocol = 'MQ'
(0x3000000)Topic = NULL
)
(0x1000000)MQMD = (
(0x3000000)SourceQueue = 'QL_TEST2'
(0x3000000)Transactional = TRUE
(0x3000000)Encoding = 273
(0x3000000)CodedCharSetId = 437
(0x3000000)Format = 'MQSTR '
(0x3000000)Version = 2
(0x3000000)Report = 0
(0x3000000)MsgType = 1
(0x3000000)Expiry = -1
(0x3000000)Feedback = 0
(0x3000000)Priority = 0
(0x3000000)Persistence = 1
(0x3000000)MsgId = X'414d5120514d5f43435f5031202020207848904020033501'
(0x3000000)CorrelId = X'000000000000000000000000000000000000000000000000'
(0x3000000)BackoutCount = 0
(0x3000000)ReplyToQ = 'MQREPLY '
(0x3000000)ReplyToQMgr = 'MYQM '
(0x3000000)UserIdentifier = 'klabranche '
(0x3000000)AccountingToken = X'16010515000000b459d40753474578915f302f1d04000000000000000000000b'
(0x3000000)ApplIdentityData = ' '
(0x3000000)PutApplType = 11
(0x3000000)PutApplName = 'es\XML_MRM_TEST\mqsiputc.exe'
(0x3000000)PutDate = DATE '2004-05-10'
(0x3000000)PutTime = GMTTIME '19:03:39.720'
(0x3000000)ApplOriginData = ' '
(0x3000000)GroupId = X'000000000000000000000000000000000000000000000000'
(0x3000000)MsgSeqNumber = 1
(0x3000000)Offset = 0
(0x3000000)MsgFlags = 0
(0x3000000)OriginalLength = -1
)
(0x100001B)MRM = (
(0x300000B)NAME = 'TEST'
(0x300000B)VERSION = '1'
(0x1000013)COMPLEX = (
(0x300000B)TEST = 'HELLO'
)
)
(0x1000010)XML =
)
-----------------------------------
(
(0x1000000)RecoverableException = (
(0x3000000)File = 'F:\build\S210_P\src\DataFlowEngine\ImbDataFlowNode.cpp'
(0x3000000)Line = 536
(0x3000000)Function = 'ImbDataFlowNode::createExceptionList'
(0x3000000)Type = 'ComIbmMQOutputNode'
(0x3000000)Name = '354b9338-fc00-0000-0080-9be125d68863'
(0x3000000)Label = 'XMLMRM_TEST.MQOutput1'
(0x3000000)Text = 'Node throwing exception'
(0x3000000)Catalog = 'WMQIv210'
(0x3000000)Severity = 3
(0x3000000)Number = 2230
(0x1000000)ParserException = (
(0x3000000)File = 'F:\build\S210_P\src\MTI\MTIforBroker\MtiImbParser2\MtiImbRMErrorMap.cpp'
(0x3000000)Line = 139
(0x3000000)Function = 'MtiImbRMErrorMap::checkRC'
(0x3000000)Type = ''
(0x3000000)Name = ''
(0x3000000)Label = ''
(0x3000000)Text = 'RM Descriptor Not Found.'
(0x3000000)Catalog = 'WMQIv210'
(0x3000000)Severity = 3
(0x3000000)Number = 5313
(0x1000000)Insert = (
(0x3000000)Type = 2
(0x3000000)Text = '32'
)
(0x1000000)Insert = (
(0x3000000)Type = 5
(0x3000000)Text = 'rmLoadWorker'
)
(0x1000000)Insert = (
(0x3000000)Type = 5
(0x3000000)Text = 'DVVCFP808K001'
)
(0x1000000)Insert = (
(0x3000000)Type = 5
(0x3000000)Text = 'OUTXML'
)
)
)
)
***************************************
***************************************
(
(0x1000000)Properties = (
(0x3000000)MessageSet = 'DVVCFP808K001'
(0x3000000)MessageType = 'INMSG'
(0x3000000)MessageFormat = 'INXML'
(0x3000000)Encoding = 273
(0x3000000)CodedCharSetId = 437
(0x3000000)Transactional = TRUE
(0x3000000)Persistence = TRUE
(0x3000000)CreationTime = GMTTIMESTAMP '2004-05-10 19:03:39.720'
(0x3000000)ExpirationTime = -1
(0x3000000)Priority = 0
(0x3000000)ReplyIdentifier = X'000000000000000000000000000000000000000000000000'
(0x3000000)ReplyProtocol = 'MQ'
(0x3000000)Topic = NULL
)
(0x1000000)MQMD = (
(0x3000000)SourceQueue = 'QL_TEST2'
(0x3000000)Transactional = TRUE
(0x3000000)Encoding = 273
(0x3000000)CodedCharSetId = 437
(0x3000000)Format = 'MQSTR '
(0x3000000)Version = 2
(0x3000000)Report = 0
(0x3000000)MsgType = 1
(0x3000000)Expiry = -1
(0x3000000)Feedback = 0
(0x3000000)Priority = 0
(0x3000000)Persistence = 1
(0x3000000)MsgId = X'414d5120514d5f43435f5031202020207848904020033501'
(0x3000000)CorrelId = X'000000000000000000000000000000000000000000000000'
(0x3000000)BackoutCount = 1
(0x3000000)ReplyToQ = 'MQREPLY '
(0x3000000)ReplyToQMgr = 'MYQM '
(0x3000000)UserIdentifier = 'klabranche '
(0x3000000)AccountingToken = X'16010515000000b459d40753474578915f302f1d04000000000000000000000b'
(0x3000000)ApplIdentityData = ' '
(0x3000000)PutApplType = 11
(0x3000000)PutApplName = 'es\XML_MRM_TEST\mqsiputc.exe'
(0x3000000)PutDate = DATE '2004-05-10'
(0x3000000)PutTime = GMTTIME '19:03:39.720'
(0x3000000)ApplOriginData = ' '
(0x3000000)GroupId = X'000000000000000000000000000000000000000000000000'
(0x3000000)MsgSeqNumber = 1
(0x3000000)Offset = 0
(0x3000000)MsgFlags = 0
(0x3000000)OriginalLength = -1
)
(0x1000021)MRM = (
(0x300000B)NAME = 'TEST'
(0x300000B)VERSION = '1'
(0x1000013)COMPLEX = (
(0x300000B)TEST = 'HELLO'
)
)
)
-----------------------------------
*************************************** |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Mon May 10, 2004 11:09 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Again, is this at Trace1 or Trace2?
Have you yet taken the time to look for the documentation on schema support in 2.1, and what you can and can't do with it, and how you have to deal with anonymous types?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| klabran |
| Posted: Mon May 10, 2004 12:14 pm Post subject: |
|
|
Master
Joined: 19 Feb 2004
Posts: 259
Location: Flagstaff AZ
|
This is after trace 1 and on the failure of the compute.
I have searched the memo.ptf/readme.txt and several of the WMQI books and I have not come up with much on the mqsiimpXMLSchema program.
I also have read the mqsiimpxmlschema pdf and don't see anything glaring in their that may point to my problem.
I am a little miffed at the ANON^ because my elements are all named. Here is my simple schema file that I used to import with. Do the complex types need to be named also?
<?xml version="1.0"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" >
<xs:element name="INMSG">
<xs:complexType>
<xs:sequence>
<xs:element name="NAME" type="xs:string" minOccurs="0" />
<xs:element name="VERSION" type="xs:string" minOccurs="0" />
<xs:element name="COMPLEX" minOccurs="0" maxOccurs="unbounded">
<xs:complexType>
<xs:sequence>
<xs:element name="TEST" type="xs:string" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element>
<xs:complexType>
<xs:choice maxOccurs="unbounded">
<xs:element ref="INMSG" />
</xs:choice>
</xs:complexType>
</xs:element>
</xs:schema>
Last edited by klabran on Mon May 10, 2004 12:18 pm; edited 1 time in total |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Mon May 10, 2004 12:17 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
| klabran wrote: |
I am a little miffed at the ANON^ because my elements are all named. Here is my simple schema file that I used to import with. |
But your complex types aren't named.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| klabran |
| Posted: Mon May 10, 2004 12:38 pm Post subject: |
|
|
Master
Joined: 19 Feb 2004
Posts: 259
Location: Flagstaff AZ
|
Gotcha.... But how does this affect MQSI? I can't seem to find any info on what happens if it is anonymous.
The message at trace 1 shows the message in the MRM domain. It's during the compute it blows up? |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Mon May 10, 2004 12:44 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
It's either blowing up in the compute or after it, if you're seeing a complete trace at Trace1.
As for the anonymous types - this is where the effect comes in. If you're assigning to them, you need to get their names right. If there are no names... it gets tricky. And it may or may not keep you from using Drag&Drop.
But I don't remember how it works in v2.1. Hopefully the documents you looked at should have said.
Or you could see what things look like if you give your types a name, and then make your elements use those as their type.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
|
|
