| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| MtiImbSyntax Error: |
« View previous topic :: View next topic » |
| Author |
Message
|
| prabhu1950 |
 Posted: Fri Jun 18, 2004 12:50 pm Post subject: MtiImbSyntax Error: |
 |
|
Novice
Joined: 27 May 2004
Posts: 10
|
Hi,
I am trying to execute the following ESQL code to get data from a user database(DB2 v8.1.5) and I got an error message something like MtiImbSyntax Error. I have provided the details of the error message right after this code. Can anybody assist me to figure out the solution for this problem. Please explain me in detail.
SET OutputRoot.XML.Results[] = (SELECT T.LAST_NAME FROM Database.TESTD.PERSON AS T
WHERE T.FIRST_NAME=InputRoot.MRM.iface:InterfaceBody.jxdd:Subject.jxdd:PersonName.jxdd:PersonGivenName);
SET OutputRoot.MRM.iface:InterfaceBody.jxdd:Subject.jxdd:PersonName.jxdd:PersonSurName = TRIM(OutputRoot.XML.Results.CJCR01V_LAST_NAME);
ERROR MESSAGE FROM EVENT VIEWER:
=========================
[WBRK_BROKER.userxyz]An IMB syntax node Type Error has occurred during writing.
MtiImbSyntax Error: Unknown or Invalid Type found in IMB Tree. A call to getData() on a MtiImbSyntaxElement has found a type associated with an ImbValue which it cannot handle. This is an internal error.
Gather trace logs and contact support detailing what operations were performed. Examine any ESQL to see what type of manipulation occurred on elements. Review further error messages for an indication to the cause of the errors.
Thanks
Vinod |
|
| Back to top |
|
 |
| kirani |
| Posted: Fri Jun 18, 2004 2:08 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
I see that you have used : when referencing the elements in your MRM tree. Are you using Namespace in your message set? Can you provide trace for your input message?
Also, please provide your platform details.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| prabhu1950 |
| Posted: Sat Jun 19, 2004 2:03 pm Post subject: MtiImbSyntax Error: |
|
|
Novice
Joined: 27 May 2004
Posts: 10
|
Hi Kiran,
Thanks your the quick response. I am getting this error when I comment the procedure CALL CopyEntireMessage();. But I don't want to use this procedure. Here are the messages from two trace nodes.
trace node on MQInput node:
(
(0x01000000):Properties = (
(0x03000000):MessageSet = 'C77I5G0002001'
(0x03000000):MessageType = 'Interface'
(0x03000000):MessageFormat = 'XML1'
(0x03000000):Encoding = 273
(0x03000000):CodedCharSetId = 437
(0x03000000):Transactional = TRUE
(0x03000000):Persistence = FALSE
(0x03000000):CreationTime = GMTTIMESTAMP '2004-06-18 19:59:44.930'
(0x03000000):ExpirationTime = -1
(0x03000000):Priority = 0
(0x03000000):ReplyIdentifier = X'000000000000000000000000000000000000000000000000'
(0x03000000):ReplyProtocol = 'MQ'
(0x03000000):Topic = NULL
)
(0x01000000):MQMD = (
(0x03000000):SourceQueue = 'IN'
(0x03000000):Transactional = TRUE
(0x03000000):Encoding = 273
(0x03000000):CodedCharSetId = 437
(0x03000000):Format = ' '
(0x03000000):Version = 2
(0x03000000):Report = 0
(0x03000000):MsgType = 8
(0x03000000):Expiry = -1
(0x03000000):Feedback = 0
(0x03000000):Priority = 0
(0x03000000):Persistence = 0
(0x03000000):MsgId = X'414d51205742524b5f514d2020202020f31fd24020009210'
(0x03000000):CorrelId = X'000000000000000000000000000000000000000000000000'
(0x03000000):BackoutCount = 30
(0x03000000):ReplyToQ = ' '
(0x03000000):ReplyToQMgr = 'WBRK_QM '
(0x03000000):UserIdentifier = 'sriv '
(0x03000000):AccountingToken = X'160105150000004f54a0d967aef7dd73e712fe2e23000000000000000000000b'
(0x03000000):ApplIdentityData = ' '
(0x03000000):PutApplType = 11
(0x03000000):PutApplName = 'rs\eclipse\jre\bin\javaw.exe'
(0x03000000):PutDate = DATE '2004-06-18'
(0x03000000):PutTime = GMTTIME '19:59:44.930'
(0x03000000):ApplOriginData = ' '
(0x03000000):GroupId = X'000000000000000000000000000000000000000000000000'
(0x03000000):MsgSeqNumber = 1
(0x03000000):Offset = 0
(0x03000000):MsgFlags = 0
(0x03000000):OriginalLength = -1
)
(0x01000021):MRM = (
(0x01000013)cjis/interface/message/1.0.0.1:InterfaceHeader = (
(0x0300000B)cjis/interface/message/1.0.0.1:InterfaceName = 'REPOS'
(0x0300000B)cjis/interface/message/1.0.0.1:InterfaceDescription = 'CJIS-LE/REPOS'
(0x0300000B)cjis/interface/message/1.0.0.1:MessageName = 'REPOS1'
(0x0300000B)cjis/interface/message/1.0.0.1:MessageDescription = 'CJIS-LE Criminal History Search Parameters'
(0x0300000B)cjis/interface/message/1.0.0.1:MessageSource = 'CJIS-LE'
(0x0300000B)cjis/interface/message/1.0.0.1:MessageTarget = 'REPOS'
)
(0x01000013)cjis/interface/message/1.0.0.1:InterfaceBody = (
(0x01000013)http://www.it.ojp.gov/jxdd/prerelease/3.0.0.1:Subject = (
(0x01000013)http://www.it.ojp.gov/jxdd/prerelease/3.0.0.1:PersonName = (
(0x0300000B)http://www.it.ojp.gov/jxdd/prerelease/3.0.0.1:PersonGivenName = 'HAROLD'
(0x0300000B)http://www.it.ojp.gov/jxdd/prerelease/3.0.0.1:PersonMiddleName = 'JUNIOR'
(0x0300000B)http://www.it.ojp.gov/jxdd/prerelease/3.0.0.1:PersonSurName = 'DAVIS'
)
)
)
)
)
(
(0x01000013)cjis/interface/message/1.0.0.1:InterfaceHeader = (
(0x0300000B)cjis/interface/message/1.0.0.1:InterfaceName = 'REPOS'
(0x0300000B)cjis/interface/message/1.0.0.1:InterfaceDescription = 'CJIS-LE/REPOS'
(0x0300000B)cjis/interface/message/1.0.0.1:MessageName = 'REPOS1'
(0x0300000B)cjis/interface/message/1.0.0.1:MessageDescription = 'CJIS-LE Criminal History Search Parameters'
(0x0300000B)cjis/interface/message/1.0.0.1:MessageSource = 'CJIS-LE'
(0x0300000B)cjis/interface/message/1.0.0.1:MessageTarget = 'REPOS'
)
(0x01000013)cjis/interface/message/1.0.0.1:InterfaceBody = (
(0x01000013)http://www.it.ojp.gov/jxdd/prerelease/3.0.0.1:Subject = (
(0x01000013)http://www.it.ojp.gov/jxdd/prerelease/3.0.0.1:PersonName = (
(0x0300000B)http://www.it.ojp.gov/jxdd/prerelease/3.0.0.1:PersonGivenName = 'HAROLD'
(0x0300000B)http://www.it.ojp.gov/jxdd/prerelease/3.0.0.1:PersonMiddleName = 'JUNIOR'
(0x0300000B)http://www.it.ojp.gov/jxdd/prerelease/3.0.0.1:PersonSurName = 'DAVIS'
)
)
)
)
(
(0x01000000):RecoverableException = (
(0x03000000):File = 'F:\build\S500_P\src\DataFlowEngine\ImbMqInputNode.cpp'
(0x03000000):Line = 2947
(0x03000000):Function = 'ImbMqInputNode::eligibleForBackout'
(0x03000000):Type = 'ComIbmMQInputNode'
(0x03000000):Name = 'LE_REPOS_FLOW#FCMComposite_1_1'
(0x03000000):Label = 'LE_REPOS_FLOW.MQInput'
(0x03000000):Text = 'Dequeued failed message. Propagating a message to the failure terminal'
(0x03000000):Catalog = 'BIPv500'
(0x03000000):Severity = 3
(0x03000000):Number = 2652
)
)
Trace from trace node on Compute node.
(
(0x01000000):Properties = (
(0x03000000):MessageSet = 'C77I5G0002001'
(0x03000000):MessageType = 'Interface'
(0x03000000):MessageFormat = 'XML1'
(0x03000000):Encoding = 273
(0x03000000):CodedCharSetId = 437
(0x03000000):Transactional = TRUE
(0x03000000):Persistence = FALSE
(0x03000000):CreationTime = GMTTIMESTAMP '2004-06-19 00:22:04.510'
(0x03000000):ExpirationTime = -1
(0x03000000):Priority = 0
(0x03000000):ReplyIdentifier = X'000000000000000000000000000000000000000000000000'
(0x03000000):ReplyProtocol = 'MQ'
(0x03000000):Topic = NULL
)
(0x01000000):MQMD = (
(0x03000000):SourceQueue = 'IN'
(0x03000000):Transactional = TRUE
(0x03000000):Encoding = 273
(0x03000000):CodedCharSetId = 437
(0x03000000):Format = ' '
(0x03000000):Version = 2
(0x03000000):Report = 0
(0x03000000):MsgType = 8
(0x03000000):Expiry = -1
(0x03000000):Feedback = 0
(0x03000000):Priority = 0
(0x03000000):Persistence = 0
(0x03000000):MsgId = X'414d51205742524b5f514d2020202020f31fd2402000af10'
(0x03000000):CorrelId = X'000000000000000000000000000000000000000000000000'
(0x03000000):BackoutCount = 0
(0x03000000):ReplyToQ = ' '
(0x03000000):ReplyToQMgr = 'WBRK_QM '
(0x03000000):UserIdentifier = 'sriv '
(0x03000000):AccountingToken = X'160105150000004f54a0d967aef7dd73e712fe2e23000000000000000000000b'
(0x03000000):ApplIdentityData = ' '
(0x03000000):PutApplType = 11
(0x03000000):PutApplName = 'rs\eclipse\jre\bin\javaw.exe'
(0x03000000):PutDate = DATE '2004-06-19'
(0x03000000):PutTime = GMTTIME '00:22:04.510'
(0x03000000):ApplOriginData = ' '
(0x03000000):GroupId = X'000000000000000000000000000000000000000000000000'
(0x03000000):MsgSeqNumber = 1
(0x03000000):Offset = 0
(0x03000000):MsgFlags = 0
(0x03000000):OriginalLength = -1
)
(0x0100001B):MRM = (
(0x01000013)cjis/interface/message/1.0.0.1:InterfaceHeader = (
(0x0300000B)cjis/interface/message/1.0.0.1:InterfaceName = 'REPOS'
(0x0300000B)cjis/interface/message/1.0.0.1:InterfaceDescription = 'CJIS-LE/REPOS'
(0x0300000B)cjis/interface/message/1.0.0.1:MessageName = 'REPOS1'
(0x0300000B)cjis/interface/message/1.0.0.1:MessageDescription = 'CJIS-LE Criminal History Search Parameters'
(0x0300000B)cjis/interface/message/1.0.0.1:MessageSource = 'CJIS-LE'
(0x0300000B)cjis/interface/message/1.0.0.1:MessageTarget = 'REPOS'
)
(0x01000013)cjis/interface/message/1.0.0.1:InterfaceBody =
)
)
(
(0x01000013)cjis/interface/message/1.0.0.1:InterfaceHeader = (
(0x0300000B)cjis/interface/message/1.0.0.1:InterfaceName = 'REPOS'
(0x0300000B)cjis/interface/message/1.0.0.1:InterfaceDescription = 'CJIS-LE/REPOS'
(0x0300000B)cjis/interface/message/1.0.0.1:MessageName = 'REPOS1'
(0x0300000B)cjis/interface/message/1.0.0.1:MessageDescription = 'CJIS-LE Criminal History Search Parameters'
(0x0300000B)cjis/interface/message/1.0.0.1:MessageSource = 'CJIS-LE'
(0x0300000B)cjis/interface/message/1.0.0.1:MessageTarget = 'REPOS'
)
(0x01000013)cjis/interface/message/1.0.0.1:InterfaceBody =
)
(
(0x01000000):RecoverableException = (
(0x03000000):File = 'F:\build\S500_P\src\DataFlowEngine\ImbDataFlowNode.cpp'
(0x03000000):Line = 558
(0x03000000):Function = 'ImbDataFlowNode::createExceptionList'
(0x03000000):Type = 'ComIbmComputeNode'
(0x03000000):Name = 'LE_REPOS_FLOW#FCMComposite_1_3'
(0x03000000):Label = 'LE_REPOS_FLOW.Compute'
(0x03000000):Text = 'Node throwing exception'
(0x03000000):Catalog = 'BIPv500'
(0x03000000):Severity = 3
(0x03000000):Number = 2230
(0x01000000):RecoverableException = (
(0x03000000):File = 'F:\build\S500_P\src\DataFlowEngine\ImbRdl\ImbRdlStatementGroup.cpp'
(0x03000000):Line = 158
(0x03000000):Function = 'SqlStatementGroup::execute'
(0x03000000):Type = 'ComIbmComputeNode'
(0x03000000):Name = 'LE_REPOS_FLOW#FCMComposite_1_3'
(0x03000000):Label = 'LE_REPOS_FLOW.Compute'
(0x03000000):Text = 'Error detected, rethrowing'
(0x03000000):Catalog = 'BIPv500'
(0x03000000):Severity = 3
(0x03000000):Number = 2488
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = '.LE_REPOS_FLOW_Compute.Main'
)
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = '13.6'
)
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = 'CALL FetchdataQuery();'
)
(0x01000000):RecoverableException = (
(0x03000000):File = 'F:\build\S500_P\src\DataFlowEngine\ImbRdl\ImbRdlCallableProcedure.cpp'
(0x03000000):Line = 268
(0x03000000):Function = 'SqlCallableProcedure::execute'
(0x03000000):Type = 'ComIbmComputeNode'
(0x03000000):Name = 'LE_REPOS_FLOW#FCMComposite_1_3'
(0x03000000):Label = 'LE_REPOS_FLOW.Compute'
(0x03000000):Text = 'Error occured in procedure'
(0x03000000):Catalog = 'BIPv500'
(0x03000000):Severity = 3
(0x03000000):Number = 2934
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = 'FetchdataQuery'
)
(0x01000000):RecoverableException = (
(0x03000000):File = 'F:\build\S500_P\src\DataFlowEngine\ImbRdl\ImbRdlStatementGroup.cpp'
(0x03000000):Line = 158
(0x03000000):Function = 'SqlStatementGroup::execute'
(0x03000000):Type = 'ComIbmComputeNode'
(0x03000000):Name = 'LE_REPOS_FLOW#FCMComposite_1_3'
(0x03000000):Label = 'LE_REPOS_FLOW.Compute'
(0x03000000):Text = 'Error detected, rethrowing'
(0x03000000):Catalog = 'BIPv500'
(0x03000000):Severity = 3
(0x03000000):Number = 2488
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = '.LE_REPOS_FLOW_Compute.FetchdataQuery'
)
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = '4.5'
)
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = 'SET OutputRoot.XML.Results[ ] = (SELECT COLUMN(0) AS :CJCR01V_PID_NBR FROM DATABASE(SELECT T.CJCR01V_PID_NBR FROM TESTD.CJCR01V_PERSON T WHERE (T.CJCR01V_FIRST_NAME)=(?), InputRoot.MRM.iface:InterfaceBody.jxdd:Subject.jxdd:PersonName.jxdd:PersonGivenName));'
)
(0x01000000):ParserException = (
(0x03000000):File = 'F:\build\S500_P\src\MTI\MTIforBroker\MtiImbParser2\MtiImbParser.cpp'
(0x03000000):Line = 376
(0x03000000):Function = 'MtiImbParser::parseFirstChild'
(0x03000000):Type = 'ComIbmMQInputNode'
(0x03000000):Name = 'LE_REPOS_FLOW#FCMComposite_1_1'
(0x03000000):Label = 'LE_REPOS_FLOW.MQInput'
(0x03000000):Text = 'ImbRecoverableException caught from worker->parseNext.'
(0x03000000):Catalog = 'BIPv500'
(0x03000000):Severity = 3
(0x03000000):Number = 5285
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = 'Repos_Msgset'
)
(0x01000000):Insert = (
(0x03000000):Type = 2
(0x03000000):Text = '1'
)
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = 'XML1'
)
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = 'Interface'
)
(0x01000000):ParserException = (
(0x03000000):File = 'F:\build\S500_P\src\MTI\MTIforBroker\MtiImbParser2\MtiImbFIHandler.cpp'
(0x03000000):Line = 2316
(0x03000000):Function = 'MtiImbFIHandler::attachDefaultElement'
(0x03000000):Type = ''
(0x03000000):Name = ''
(0x03000000):Label = ''
(0x03000000):Text = 'An element has been deemed complete occuring less than specified minOccurs'
(0x03000000):Catalog = 'BIPv500'
(0x03000000):Severity = 3
(0x03000000):Number = 5374
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = 'http://www.it.ojp.gov/jxdd/prerelease/3.0.0.1:Warrant'
)
(0x01000000):Insert = (
(0x03000000):Type = 2
(0x03000000):Text = '0'
)
(0x01000000):Insert = (
(0x03000000):Type = 2
(0x03000000):Text = '1'
)
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = 'cjis/interface/message/1.0.0.1:99^InterfaceBody'
)
(0x01000000):Insert = (
(0x03000000):Type = 2
(0x03000000):Text = '1'
)
)
)
)
)
)
)
)
The msg flow looks like:
MQInput---trace---->ComputeNode---trace--->MQOutput
Thanks
Vinod |
|
| 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
|
|
|
|
