| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
| The nodes can't read the XML message |
« View previous topic :: View next topic » |
| Author |
Message
|
| wschutz |
 Posted: Thu Nov 03, 2005 3:34 am Post subject: |
 |
|
Jedi Knight
Joined: 02 Jun 2005
Posts: 3316
Location: IBM (retired)
|
it is deprecated, but it still works.
EDIT: I did a quick test of your posted code and it works on my machine -w 
_________________
-wayne |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Thu Nov 03, 2005 6:09 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
| wschutz wrote: |
| it is deprecated, but it still works. |
But it's deprecated for some very very good reasons. And it's been deprecated since I think CSD3 of 2.1, for a LONG time.
And ASBITSTREAM is a lot more flexible.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| wschutz |
| Posted: Thu Nov 03, 2005 6:51 am Post subject: |
|
|
Jedi Knight
Joined: 02 Jun 2005
Posts: 3316
Location: IBM (retired)
|
Jeff... true, but my point is: "thats probably not what his problem is"
_________________
-wayne |
|
| Back to top |
|
|
| Manuel_ch |
| Posted: Fri Nov 04, 2005 3:32 am Post subject: |
|
|
Apprentice
Joined: 27 Jul 2005
Posts: 31
|
I changed BITSTREAM to ASBITSTREAM and it doesn't change anything.
Do I have to put some particulare parameters? |
|
| Back to top |
|
|
| Manuel_ch |
| Posted: Fri Nov 04, 2005 3:40 am Post subject: |
|
|
Apprentice
Joined: 27 Jul 2005
Posts: 31
|
I trace the other flow F_FAIL which works fine in this same environment.
The trace is th same as the flow which fails F_RB.
I change my flow from an exec group to an other but it doesn't change. |
|
| Back to top |
|
|
| wschutz |
| Posted: Fri Nov 04, 2005 4:04 am Post subject: |
|
|
Jedi Knight
Joined: 02 Jun 2005
Posts: 3316
Location: IBM (retired)
|
Can you post the trace that works, so we compare the two?
_________________
-wayne |
|
| Back to top |
|
|
| Manuel_ch |
| Posted: Fri Nov 04, 2005 5:33 am Post subject: |
|
|
Apprentice
Joined: 27 Jul 2005
Posts: 31
|
The trace which doesn't work
| Quote: |
(
(0x1000000)Properties = (
(0x3000000)MessageSet = ''
(0x3000000)MessageType = ''
(0x3000000)MessageFormat = ''
(0x3000000)Encoding = 273
(0x3000000)CodedCharSetId = 819
(0x3000000)Transactional = TRUE
(0x3000000)Persistence = TRUE
(0x3000000)CreationTime = GMTTIMESTAMP '2005-11-04 12:28:13.340'
(0x3000000)ExpirationTime = -1
(0x3000000)Priority = 4
(0x3000000)ReplyIdentifier = X'000000000000000000000000000000000000000000000000'
(0x3000000)ReplyProtocol = 'MQ'
(0x3000000)Topic = NULL
)
(0x1000000)MQMD = (
(0x3000000)SourceQueue = 'Q_NABU.F_RB'
(0x3000000)Transactional = TRUE
(0x3000000)Encoding = 273
(0x3000000)CodedCharSetId = 819
(0x3000000)Format = 'MQSTR '
(0x3000000)Version = 2
(0x3000000)Report = 0
(0x3000000)MsgType = 8
(0x3000000)Expiry = -1
(0x3000000)Feedback = 0
(0x3000000)Priority = 4
(0x3000000)Persistence = 1
(0x3000000)MsgId = X'414d5120514d5f4541495f315f494e54436a303100058013'
(0x3000000)CorrelId = X'000000000000000000000000000000000000000000000000'
(0x3000000)BackoutCount = 0
(0x3000000)ReplyToQ = ' '
(0x3000000)ReplyToQMgr = 'QM_EAI_1_INTEVO '
(0x3000000)UserIdentifier = 'mqmie '
(0x3000000)AccountingToken = X'0332303800000000000000000000000000000000000000000000000000000006'
(0x3000000)ApplIdentityData = ' '
(0x3000000)PutApplType = 28
(0x3000000)PutApplName = 'MQSeries Client for Java '
(0x3000000)PutDate = DATE '2005-11-04'
(0x3000000)PutTime = GMTTIME '12:28:13.340'
(0x3000000)ApplOriginData = ' '
(0x3000000)GroupId = X'000000000000000000000000000000000000000000000000'
(0x3000000)MsgSeqNumber = 1
(0x3000000)Offset = 0
(0x3000000)MsgFlags = 0
(0x3000000)OriginalLength = -1
)
(0x1000010)XML = (
(0x1000000)Siprog = (
(0x1000000)MsgEntry = (
(0x1000000)Header = (
etc, etc, etc
)
)
|
The same message in the other flow which work
| Quote: |
(
(0x1000000)Properties = (
(0x3000000)MessageSet = ''
(0x3000000)MessageType = ''
(0x3000000)MessageFormat = ''
(0x3000000)Encoding = 273
(0x3000000)CodedCharSetId = 819
(0x3000000)Transactional = TRUE
(0x3000000)Persistence = TRUE
(0x3000000)CreationTime = GMTTIMESTAMP '2005-11-04 12:28:13.340'
(0x3000000)ExpirationTime = -1
(0x3000000)Priority = 4
(0x3000000)ReplyIdentifier = X'000000000000000000000000000000000000000000000000'
(0x3000000)ReplyProtocol = 'MQ'
(0x3000000)Topic = NULL
)
(0x1000000)MQMD = (
(0x3000000)SourceQueue = 'Q_REBUT'
(0x3000000)Transactional = TRUE
(0x3000000)Encoding = 273
(0x3000000)CodedCharSetId = 819
(0x3000000)Format = 'MQSTR '
(0x3000000)Version = 2
(0x3000000)Report = 0
(0x3000000)MsgType = 8
(0x3000000)Expiry = -1
(0x3000000)Feedback = 0
(0x3000000)Priority = 4
(0x3000000)Persistence = 1
(0x3000000)MsgId = X'414d5120514d5f4541495f315f494e54436a303100058013'
(0x3000000)CorrelId = X'000000000000000000000000000000000000000000000000'
(0x3000000)BackoutCount = 0
(0x3000000)ReplyToQ = ' '
(0x3000000)ReplyToQMgr = 'QM_EAI_1_INTEVO '
(0x3000000)UserIdentifier = 'mqmie '
(0x3000000)AccountingToken = X'0332303800000000000000000000000000000000000000000000000000000006'
(0x3000000)ApplIdentityData = ' '
(0x3000000)PutApplType = 28
(0x3000000)PutApplName = 'MQSeries Client for Java '
(0x3000000)PutDate = DATE '2005-11-04'
(0x3000000)PutTime = GMTTIME '12:28:13.340'
(0x3000000)ApplOriginData = ' '
(0x3000000)GroupId = X'000000000000000000000000000000000000000000000000'
(0x3000000)MsgSeqNumber = 1
(0x3000000)Offset = 0
(0x3000000)MsgFlags = 0
(0x3000000)OriginalLength = -1
)
(0x1000010)XML = (
(0x1000000)Siprog = (
(0x1000000)MsgEntry = (
(0x1000000)Header = (
etc, etc, etc
)
)
|
If the message can't be manage in the flow F_RB, it goes to the flow F_FAIL. This 2 flow's traces are above. |
|
| Back to top |
|
|
| wschutz |
| Posted: Fri Nov 04, 2005 5:26 pm Post subject: |
|
|
Jedi Knight
Joined: 02 Jun 2005
Posts: 3316
Location: IBM (retired)
|
Its interesting that the only thing different between the two traces is the source queue name. I would expect the msgId and timestamps to be different... Why are they the exact same value??
_________________
-wayne |
|
| Back to top |
|
|
| Manuel_ch |
| Posted: Sun Nov 06, 2005 6:18 am Post subject: |
|
|
Apprentice
Joined: 27 Jul 2005
Posts: 31
|
I believe the properties of the message have been copy from the first flow to the second. But I coundn't say if it shouldn't.
The first flow put the message in the queue Q_NABU.F_RB. The second flow takes the message from this queue and treat it. This explain why the SourceQueue are differents. |
|
| Back to top |
|
|
| Manuel_ch |
| Posted: Wed Nov 16, 2005 5:50 am Post subject: |
|
|
Apprentice
Joined: 27 Jul 2005
Posts: 31
|
I still have the problem and I still believe the problem, comes from the installation. Maybe a java class doesn't have the appropriate UNIX grants.
Which log could help me to find out this problem?
Manuel |
|
| Back to top |
|
|
| fschofer |
| Posted: Wed Nov 16, 2005 6:55 am Post subject: |
|
|
Knight
Joined: 02 Jul 2001
Posts: 524
Location: Mainz, Germany
|
Hi,
| Quote: |
| 2005-10-26 17:22:53.589935 1800 UserTrace BIP2540I: Node 'FL_F_RB.C_PS_EAI_OPX2_2': Finished evaluating expression 'BITSTREAM(InputBody)' at (6, 15). The result was 'X'''. |
for some reason your InputBody is empty, you have to find out why.
Can you post the debug trace data of what happens before this in your flow.
Greetings
Frank |
|
| Back to top |
|
|
| Manuel_ch |
| Posted: Wed Nov 16, 2005 8:12 am Post subject: |
|
|
Apprentice
Joined: 27 Jul 2005
Posts: 31
|
I built a complete new and simple flow.
MQInput=>Trace1->Compute1=>Trace2->MQoutput1
Trace1 writes ${Root}
Trace2 writes ${Root} and ${ExceptionList=
Compute1 ESQL code is :
| Quote: |
SET OutputRoot = InputRoot;
-- Entrez le code SQL sous cette ligne. Le SQL au-dessus de cette ligne pourrait être régénéré, ce qui entraînerait la perte des modifications.
DECLARE extrait BLOB;
DECLARE chaine CHARACTER;
SET extrait = ASBITSTREAM(InputRoot.BLOB.BLOB);
------------------------------
-- Chaine contient le message
------------------------------
SET chaine = CAST( extrait AS CHARACTER CCSID InputRoot.MQMD.CodedCharSetId);
DECLARE nPosition1 INTEGER;
DECLARE nPosition2 INTEGER;
DECLARE nPosition3 INTEGER;
SET nPosition1 = POSITION('<Content>' IN chaine);
SET nPosition2 = POSITION('</Content>' IN chaine);
SET nPosition3 = nPosition2 - 9 - nPosition1;
DECLARE sContent CHARACTER;
SET sContent = SUBSTRING (chaine FROM nPosition1+9 FOR nPosition3);
SET OutputRoot.XML.MsgEntry.Siprog.Content2=sContent;
|
In my compute Node I tried this with the same result :
| Quote: |
| SET extrait = BITSTREAM(InputBody); |
The result is quit similare as my final flow but the trace are different: the trace can manage to read the XML message.
Trace1 is :
| Quote: |
***Trace Root 16:41
(
(0x1000000)Properties = (
(0x3000000)MessageSet = ''
(0x3000000)MessageType = ''
(0x3000000)MessageFormat = ''
(0x3000000)Encoding = 546
(0x3000000)CodedCharSetId = 819
(0x3000000)Transactional = TRUE
(0x3000000)Persistence = TRUE
(0x3000000)CreationTime = GMTTIMESTAMP '2005-11-16 15:41:53.060'
(0x3000000)ExpirationTime = -1
(0x3000000)Priority = 0
(0x3000000)ReplyIdentifier = X'000000000000000000000000000000000000000000000000'
(0x3000000)ReplyProtocol = 'MQ'
(0x3000000)Topic = NULL
)
(0x1000000)MQMD = (
(0x3000000)SourceQueue = 'Q_MCHE'
(0x3000000)Transactional = TRUE
(0x3000000)Encoding = 546
(0x3000000)CodedCharSetId = 819
(0x3000000)Format = 'MQSTR '
(0x3000000)Version = 2
(0x3000000)Report = 0
(0x3000000)MsgType = 8
(0x3000000)Expiry = -1
(0x3000000)Feedback = 0
(0x3000000)Priority = 0
(0x3000000)Persistence = 1
(0x3000000)MsgId = X'414d5120514d5f4541495f315f494e5443706dc900015293'
(0x3000000)CorrelId = X'000000000000000000000000000000000000000000000000'
(0x3000000)BackoutCount = 0
(0x3000000)ReplyToQ = ' '
(0x3000000)ReplyToQMgr = 'QM_EAI_1_INTEVO '
(0x3000000)UserIdentifier = 'mqseries '
(0x3000000)AccountingToken = X'16010515000000ce7193628d36d84bf34d0f37460c000000000000000000000b'
(0x3000000)ApplIdentityData = ' '
(0x3000000)PutApplType = 11
(0x3000000)PutApplName = 'C:\WINNT\system32\mmc.exe'
(0x3000000)PutDate = DATE '2005-11-16'
(0x3000000)PutTime = GMTTIME '15:41:53.060'
(0x3000000)ApplOriginData = ' '
(0x3000000)GroupId = X'000000000000000000000000000000000000000000000000'
(0x3000000)MsgSeqNumber = 1
(0x3000000)Offset = 0
(0x3000000)MsgFlags = 0
(0x3000000)OriginalLength = -1
)
(0x1000000)BLOB = (
(0x3000000)UnknownParserName = 'MQSTR'
(0x3000000)BLOB = X'3c536970726f673e3c4d7367456e7472793e3c4865616465723e3c4f7....'
)
)
|
The trace2 is :
| Quote: |
***Trace Root2 16:41
(
(0x1000000)Properties = (
(0x3000000)MessageSet = ''
(0x3000000)MessageType = ''
(0x3000000)MessageFormat = ''
(0x3000000)Encoding = 546
(0x3000000)CodedCharSetId = 819
(0x3000000)Transactional = TRUE
(0x3000000)Persistence = TRUE
(0x3000000)CreationTime = GMTTIMESTAMP '2005-11-16 15:41:53.060'
(0x3000000)ExpirationTime = -1
(0x3000000)Priority = 0
(0x3000000)ReplyIdentifier = X'000000000000000000000000000000000000000000000000'
(0x3000000)ReplyProtocol = 'MQ'
(0x3000000)Topic = NULL
)
(0x1000000)MQMD = (
(0x3000000)SourceQueue = 'Q_MCHE'
(0x3000000)Transactional = TRUE
(0x3000000)Encoding = 546
(0x3000000)CodedCharSetId = 819
(0x3000000)Format = 'MQSTR '
(0x3000000)Version = 2
(0x3000000)Report = 0
(0x3000000)MsgType = 8
(0x3000000)Expiry = -1
(0x3000000)Feedback = 0
(0x3000000)Priority = 0
(0x3000000)Persistence = 1
(0x3000000)MsgId = X'414d5120514d5f4541495f315f494e5443706dc900015293'
(0x3000000)CorrelId = X'000000000000000000000000000000000000000000000000'
(0x3000000)BackoutCount = 0
(0x3000000)ReplyToQ = ' '
(0x3000000)ReplyToQMgr = 'QM_EAI_1_INTEVO '
(0x3000000)UserIdentifier = 'mqseries '
(0x3000000)AccountingToken = X'16010515000000ce7193628d36d84bf34d0f37460c000000000000000000000b'
(0x3000000)ApplIdentityData = ' '
(0x3000000)PutApplType = 11
(0x3000000)PutApplName = 'C:\WINNT\system32\mmc.exe'
(0x3000000)PutDate = DATE '2005-11-16'
(0x3000000)PutTime = GMTTIME '15:41:53.060'
(0x3000000)ApplOriginData = ' '
(0x3000000)GroupId = X'000000000000000000000000000000000000000000000000'
(0x3000000)MsgSeqNumber = 1
(0x3000000)Offset = 0
(0x3000000)MsgFlags = 0
(0x3000000)OriginalLength = -1
)
(0x1000000)BLOB = (
(0x3000000)UnknownParserName = 'MQSTR'
(0x3000000)BLOB = X'3c536970726f673e3c4d7367456e7472793e3c4865616465....'
)
)
***Trace ExceptionList 16:41
(
(0x1000000)RecoverableException = (
(0x3000000)File = '/build/S210_P/src/DataFlowEngine/ImbDataFlowNode.cpp'
(0x3000000)Line = 536
(0x3000000)Function = 'ImbDataFlowNode::createExceptionList'
(0x3000000)Type = 'ComIbmComputeNode'
(0x3000000)Name = '9da8be56-0701-0000-0080-ddd07afc285a'
(0x3000000)Label = 'FL_F_MCHE.Compute1'
(0x3000000)Text = 'Node throwing exception'
(0x3000000)Catalog = 'WMQIv210'
(0x3000000)Severity = 3
(0x3000000)Number = 2230
(0x1000000)RecoverableException = (
(0x3000000)File = '/build/S210_P/src/DataFlowEngine/ImbRdl/ImbRdlStringFunctions.cpp'
(0x3000000)Line = 295
(0x3000000)Function = 'SubstringFnCall::evaluateFunction'
(0x3000000)Type = 'ComIbmComputeNode'
(0x3000000)Name = '9da8be56-0701-0000-0080-ddd07afc285a'
(0x3000000)Label = 'FL_F_MCHE.Compute1'
(0x3000000)Text = 'Illegal arguments for SUBSTRING functions'
(0x3000000)Catalog = 'WMQIv210'
(0x3000000)Severity = 3
(0x3000000)Number = 2499
(0x1000000)Insert = (
(0x3000000)Type = 2
(0x3000000)Text = '21'
)
(0x1000000)Insert = (
(0x3000000)Type = 2
(0x3000000)Text = '16'
)
(0x1000000)Insert = (
(0x3000000)Type = 5
(0x3000000)Text = 'SUBSTRING('' FROM 9 FOR -9)'
)
)
)
)
|
The Flow Trace is
| Quote: |
2005-11-16 16:41:53.102195 2314 UserTrace BIP2632I: Message received and propagated to 'out' terminal of MQ input node 'FL_F_MCHE.MQInput1'.
2005-11-16 16:41:53.102558 2314 UserTrace BIP6060I: Parser type 'Properties' created on behalf of node 'FL_F_MCHE.MQInput1' to handle portion of incoming message of length 0 bytes beginning at offset '0'.
2005-11-16 16:41:53.113548 2314 UserTrace BIP6061I: Parser type 'MQMD' created on behalf of node 'FL_F_MCHE.MQInput1' to handle portion of incoming message of length '364' bytes beginning at offset '0'. Parser type selected based on value 'MQHMD' from previous parser.
2005-11-16 16:41:53.113742 2314 UserTrace BIP6061I: Parser type 'BLOB' created on behalf of node 'FL_F_MCHE.MQInput1' to handle portion of incoming message of length '542' bytes beginning at offset '364'. Parser type selected based on value 'NONE' from previous parser.
2005-11-16 16:41:53.138893 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Trace1': Evaluating expression 'EXTRACT(HOUR FROM CURRENT_TIMESTAMP)' at (1, 17).
2005-11-16 16:41:53.143611 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Trace1': Evaluating expression 'CURRENT_TIMESTAMP' at (1, 35).
2005-11-16 16:41:53.143882 2314 UserTrace BIP2540I: Node 'FL_F_MCHE.Trace1': Finished evaluating expression 'CURRENT_TIMESTAMP' at (1, 35). The result was 'TIMESTAMP '2005-11-16 16:41:53.102424''.
2005-11-16 16:41:53.174091 2314 UserTrace BIP2539I: Node 'FL_F_MCHE.Trace1': Finished evaluating expression 'EXTRACT(HOUR FROM CURRENT_TIMESTAMP)' at (1, 17). This resolved to 'EXTRACT(HOUR FROM TIMESTAMP '2005-11-16 16:41:53.102424')'. The result was '16'.
2005-11-16 16:41:53.174224 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Trace1': Evaluating expression 'EXTRACT(MINUTE FROM CURRENT_TIMESTAMP)' at (1, 57).
2005-11-16 16:41:53.174324 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Trace1': Evaluating expression 'CURRENT_TIMESTAMP' at (1, 77).
2005-11-16 16:41:53.174453 2314 UserTrace BIP2540I: Node 'FL_F_MCHE.Trace1': Finished evaluating expression 'CURRENT_TIMESTAMP' at (1, 77). The result was 'TIMESTAMP '2005-11-16 16:41:53.102424''.
2005-11-16 16:41:53.174587 2314 UserTrace BIP2539I: Node 'FL_F_MCHE.Trace1': Finished evaluating expression 'EXTRACT(MINUTE FROM CURRENT_TIMESTAMP)' at (1, 57). This resolved to 'EXTRACT(MINUTE FROM TIMESTAMP '2005-11-16 16:41:53.102424')'. The result was '41'.
2005-11-16 16:41:53.174827 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Trace1': Evaluating expression 'Root' at (2, 3).
2005-11-16 16:41:53.212532 2314 UserTrace BIP4067I: Message propagated to output terminal for trace node 'FL_F_MCHE.Trace1'.
The trace node 'FL_F_MCHE.Trace1' has received a message and is propagating it to any nodes connected to its output terminal.
No user action required.
2005-11-16 16:41:53.247917 2314 UserTrace BIP2537I: Node 'FL_F_MCHE.Compute1': Executing statement 'SET OutputRoot = InputRoot;' at (1, 1).
2005-11-16 16:41:53.248386 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Compute1': Evaluating expression 'InputRoot' at (1, 1 .
2005-11-16 16:41:53.248497 2314 UserTrace BIP2568I: Node 'FL_F_MCHE.Compute1': Performing tree copy of '' to 'OutputRoot'.
2005-11-16 16:41:53.248733 2314 UserTrace BIP2537I: Node 'FL_F_MCHE.Compute1': Executing statement 'DECLARE extrait BLOB;' at (4, 1).
2005-11-16 16:41:53.269142 2314 UserTrace BIP2537I: Node 'FL_F_MCHE.Compute1': Executing statement 'DECLARE chaine CHARACTER;' at (5, 1).
2005-11-16 16:41:53.269241 2314 UserTrace BIP2537I: Node 'FL_F_MCHE.Compute1': Executing statement 'SET extrait = ASBITSTREAM(InputRoot.BLOB.BLOB);' at (6, 1).
2005-11-16 16:41:53.269336 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Compute1': Evaluating expression 'ASBITSTREAM(InputRoot.BLOB.BLOB)' at (6, 15).
2005-11-16 16:41:53.272834 2314 UserTrace BIP2540I: Node 'FL_F_MCHE.Compute1': Finished evaluating expression 'ASBITSTREAM(InputRoot.BLOB.BLOB)' at (6, 15). The result was 'X'''.
2005-11-16 16:41:53.272968 2314 UserTrace BIP2537I: Node 'FL_F_MCHE.Compute1': Executing statement 'SET chaine = CAST(extrait AS CHARACTER CCSID InputRoot.MQMD.CodedCharSetId);' at (11, 1).
2005-11-16 16:41:53.273063 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Compute1': Evaluating expression 'CAST(extrait AS CHARACTER CCSID InputRoot.MQMD.CodedCharSetId)' at (11, 14).
2005-11-16 16:41:53.273155 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Compute1': Evaluating expression 'extrait' at (11, 20).
2005-11-16 16:41:53.273262 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Compute1': Evaluating expression 'InputRoot.MQMD.CodedCharSetId' at (11, 47).
2005-11-16 16:41:53.273994 2314 UserTrace BIP2539I: Node 'FL_F_MCHE.Compute1': Finished evaluating expression 'CAST(extrait AS CHARACTER CCSID InputRoot.MQMD.CodedCharSetId)' at (11, 14). This resolved to 'CAST(X'' AS CHARACTER CCSID 819 )'. The result was ''''.
2005-11-16 16:41:53.274105 2314 UserTrace BIP2537I: Node 'FL_F_MCHE.Compute1': Executing statement 'DECLARE nPosition1 INTEGER;' at (13, 1).
2005-11-16 16:41:53.274196 2314 UserTrace BIP2537I: Node 'FL_F_MCHE.Compute1': Executing statement 'DECLARE nPosition2 INTEGER;' at (14, 1).
2005-11-16 16:41:53.274288 2314 UserTrace BIP2537I: Node 'FL_F_MCHE.Compute1': Executing statement 'DECLARE nPosition3 INTEGER;' at (15, 1).
2005-11-16 16:41:53.274383 2314 UserTrace BIP2537I: Node 'FL_F_MCHE.Compute1': Executing statement 'SET nPosition1 = POSITION('<Content>' IN chaine);' at (16, 1).
2005-11-16 16:41:53.274471 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Compute1': Evaluating expression 'POSITION('<Content>' IN chaine)' at (16, 1.
2005-11-16 16:41:53.283332 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Compute1': Evaluating expression 'chaine' at (16, 42).
2005-11-16 16:41:53.296123 2314 UserTrace BIP2539I: Node 'FL_F_MCHE.Compute1': Finished evaluating expression 'POSITION('<Content>' IN chaine)' at (16, 1. This resolved to 'POSITION('<Content>' IN '')'. The result was '0'.
2005-11-16 16:41:53.296230 2314 UserTrace BIP2537I: Node 'FL_F_MCHE.Compute1': Executing statement 'SET nPosition2 = POSITION('</Content>' IN chaine);' at (17, 1).
2005-11-16 16:41:53.296318 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Compute1': Evaluating expression 'POSITION('</Content>' IN chaine)' at (17, 1.
2005-11-16 16:41:53.296413 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Compute1': Evaluating expression 'chaine' at (17, 43).
2005-11-16 16:41:53.296520 2314 UserTrace BIP2539I: Node 'FL_F_MCHE.Compute1': Finished evaluating expression 'POSITION('</Content>' IN chaine)' at (17, 1. This resolved to 'POSITION('</Content>' IN '')'. The result was '0'.
2005-11-16 16:41:53.296619 2314 UserTrace BIP2537I: Node 'FL_F_MCHE.Compute1': Executing statement 'SET nPosition3 = nPosition2 - 9 - nPosition1;' at (18, 1).
2005-11-16 16:41:53.296710 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Compute1': Evaluating expression 'nPosition2 - 9 - nPosition1' at (18, 34).
2005-11-16 16:41:53.308906 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Compute1': Evaluating expression 'nPosition2 - 9' at (18, 30).
2005-11-16 16:41:53.309020 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Compute1': Evaluating expression 'nPosition2' at (18, 19).
2005-11-16 16:41:53.309139 2314 UserTrace BIP2539I: Node 'FL_F_MCHE.Compute1': Finished evaluating expression 'nPosition2 - 9' at (18, 30). This resolved to '0 - 9'. The result was '-9'.
2005-11-16 16:41:53.309234 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Compute1': Evaluating expression 'nPosition1' at (18, 36).
2005-11-16 16:41:53.309333 2314 UserTrace BIP2539I: Node 'FL_F_MCHE.Compute1': Finished evaluating expression 'nPosition2 - 9 - nPosition1' at (18, 34). This resolved to '-9 - 0'. The result was '-9'.
2005-11-16 16:41:53.309432 2314 UserTrace BIP2537I: Node 'FL_F_MCHE.Compute1': Executing statement 'DECLARE sContent CHARACTER;' at (20, 1).
2005-11-16 16:41:53.309528 2314 UserTrace BIP2537I: Node 'FL_F_MCHE.Compute1': Executing statement 'SET sContent = SUBSTRING(chaine FROM nPosition1 + 9 FOR nPosition3);' at (21, 1).
2005-11-16 16:41:53.309616 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Compute1': Evaluating expression 'SUBSTRING(chaine FROM nPosition1 + 9 FOR nPosition3)' at (21, 16).
2005-11-16 16:41:53.309707 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Compute1': Evaluating expression 'chaine' at (21, 27).
2005-11-16 16:41:53.309799 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Compute1': Evaluating expression 'nPosition1 + 9' at (21, 49).
2005-11-16 16:41:53.309886 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Compute1': Evaluating expression 'nPosition1' at (21, 39).
2005-11-16 16:41:53.310073 2314 UserTrace BIP2539I: Node 'FL_F_MCHE.Compute1': Finished evaluating expression 'nPosition1 + 9' at (21, 49). This resolved to '0 + 9'. The result was '9'.
2005-11-16 16:41:53.310173 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Compute1': Evaluating expression 'nPosition3' at (21, 56).
2005-11-16 16:41:53.338165 2314 UserTrace BIP2231E: Error detected whilst processing a message 'FL_F_MCHE.Compute1'.
The message broker detected an error whilst processing a message in node 'FL_F_MCHE.Compute1'. The message has been augmented with an exception list and has been propagated to the node's failure terminal for further processing.
See the following messages for details of the error.
2005-11-16 16:41:53.338199 2314 RecoverableException BIP2499E: (21, 16) : Illegal arguments to SUBSTRING function called as 'SUBSTRING('' FROM 9 FOR -9)'.
Valid syntax for SUBSTRING is: SUBSTRING( source_string FROM start_position [FOR string_length]). The function was called as 'SUBSTRING('' FROM 9 FOR -9)'.
Correct the syntax of the expression and redeploy the message flow.
2005-11-16 16:41:53.338417 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Trace2': Evaluating expression 'EXTRACT(HOUR FROM CURRENT_TIMESTAMP)' at (1, 1.
2005-11-16 16:41:53.338512 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Trace2': Evaluating expression 'CURRENT_TIMESTAMP' at (1, 36).
2005-11-16 16:41:53.338706 2314 UserTrace BIP2540I: Node 'FL_F_MCHE.Trace2': Finished evaluating expression 'CURRENT_TIMESTAMP' at (1, 36). The result was 'TIMESTAMP '2005-11-16 16:41:53.338289''.
2005-11-16 16:41:53.338840 2314 UserTrace BIP2539I: Node 'FL_F_MCHE.Trace2': Finished evaluating expression 'EXTRACT(HOUR FROM CURRENT_TIMESTAMP)' at (1, 1. This resolved to 'EXTRACT(HOUR FROM TIMESTAMP '2005-11-16 16:41:53.338289')'. The result was '16'.
2005-11-16 16:41:53.338951 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Trace2': Evaluating expression 'EXTRACT(MINUTE FROM CURRENT_TIMESTAMP)' at (1, 5.
2005-11-16 16:41:53.339069 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Trace2': Evaluating expression 'CURRENT_TIMESTAMP' at (1, 7.
2005-11-16 16:41:53.339183 2314 UserTrace BIP2540I: Node 'FL_F_MCHE.Trace2': Finished evaluating expression 'CURRENT_TIMESTAMP' at (1, 7. The result was 'TIMESTAMP '2005-11-16 16:41:53.338289''.
2005-11-16 16:41:53.339305 2314 UserTrace BIP2539I: Node 'FL_F_MCHE.Trace2': Finished evaluating expression 'EXTRACT(MINUTE FROM CURRENT_TIMESTAMP)' at (1, 5. This resolved to 'EXTRACT(MINUTE FROM TIMESTAMP '2005-11-16 16:41:53.338289')'. The result was '41'.
2005-11-16 16:41:53.339412 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Trace2': Evaluating expression 'Root' at (2, 3).
2005-11-16 16:41:53.341960 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Trace2': Evaluating expression 'EXTRACT(HOUR FROM CURRENT_TIMESTAMP)' at (4, 26).
2005-11-16 16:41:53.342052 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Trace2': Evaluating expression 'CURRENT_TIMESTAMP' at (4, 44).
2005-11-16 16:41:53.342163 2314 UserTrace BIP2540I: Node 'FL_F_MCHE.Trace2': Finished evaluating expression 'CURRENT_TIMESTAMP' at (4, 44). The result was 'TIMESTAMP '2005-11-16 16:41:53.338289''.
2005-11-16 16:41:53.342288 2314 UserTrace BIP2539I: Node 'FL_F_MCHE.Trace2': Finished evaluating expression 'EXTRACT(HOUR FROM CURRENT_TIMESTAMP)' at (4, 26). This resolved to 'EXTRACT(HOUR FROM TIMESTAMP '2005-11-16 16:41:53.338289')'. The result was '16'.
2005-11-16 16:41:53.342399 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Trace2': Evaluating expression 'EXTRACT(MINUTE FROM CURRENT_TIMESTAMP)' at (4, 66).
2005-11-16 16:41:53.342521 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Trace2': Evaluating expression 'CURRENT_TIMESTAMP' at (4, 86).
2005-11-16 16:41:53.342636 2314 UserTrace BIP2540I: Node 'FL_F_MCHE.Trace2': Finished evaluating expression 'CURRENT_TIMESTAMP' at (4, 86). The result was 'TIMESTAMP '2005-11-16 16:41:53.338289''.
2005-11-16 16:41:53.342758 2314 UserTrace BIP2539I: Node 'FL_F_MCHE.Trace2': Finished evaluating expression 'EXTRACT(MINUTE FROM CURRENT_TIMESTAMP)' at (4, 66). This resolved to 'EXTRACT(MINUTE FROM TIMESTAMP '2005-11-16 16:41:53.338289')'. The result was '41'.
2005-11-16 16:41:53.342864 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Trace2': Evaluating expression 'ExceptionList' at (5, 3).
2005-11-16 16:41:53.355274 2314 UserTrace BIP4067I: Message propagated to output terminal for trace node 'FL_F_MCHE.Trace2'.
The trace node 'FL_F_MCHE.Trace2' has received a message and is propagating it to any nodes connected to its output terminal.
No user action required.
2005-11-16 16:41:53.363460 2314 UserTrace BIP2638I: The MQ output node 'FL_F_MCHE.MQOutput1' attempted to write a message to the specified queue 'Q_REBUT' connected to queue manager ''. The MQCC was 0 and the MQRC was 0.
2005-11-16 16:41:53.363563 2314 UserTrace BIP2622I: Message successfully output by MQ output node 'FL_F_MCHE.MQOutput1' to queue 'Q_REBUT' on queue manager ''.
|
Finally the MQOutput1 is connect to an other flow F_FAIL and this on manage to read and parse the XML message :
| Quote: |
2005-11-16 16:44:26.210971 2057 UserTrace BIP2632I: Message received and propagated to 'out' terminal of MQ input node 'FL_FAIL.In_Q_REBUT'.
2005-11-16 16:44:26.211286 2057 UserTrace BIP6060I: Parser type 'Properties' created on behalf of node 'FL_FAIL.In_Q_REBUT' to handle portion of incoming message of length 0 bytes beginning at offset '0'.
2005-11-16 16:44:26.211526 2057 UserTrace BIP6061I: Parser type 'MQMD' created on behalf of node 'FL_FAIL.In_Q_REBUT' to handle portion of incoming message of length '364' bytes beginning at offset '0'. Parser type selected based on value 'MQHMD' from previous parser.
2005-11-16 16:44:26.211894 2057 UserTrace BIP6061I: Parser type 'XML' created on behalf of node 'FL_FAIL.In_Q_REBUT' to handle portion of incoming message of length '542' bytes beginning at offset '364'. Parser type selected based on value 'XML' from previous parser.
2005-11-16 16:44:26.212125 2057 UserTrace BIP2538I: Node 'FL_FAIL.Trace1': Evaluating expression 'EXTRACT(HOUR FROM CURRENT_TIMESTAMP)' at (2, 13).
2005-11-16 16:44:26.212236 2057 UserTrace BIP2538I: Node 'FL_FAIL.Trace1': Evaluating expression 'CURRENT_TIMESTAMP' at (2, 31).
2005-11-16 16:44:26.212484 2057 UserTrace BIP2540I: Node 'FL_FAIL.Trace1': Finished evaluating expression 'CURRENT_TIMESTAMP' at (2, 31). The result was 'TIMESTAMP '2005-11-16 16:44:26.211130''.
2005-11-16 16:44:26.212638 2057 UserTrace BIP2539I: Node 'FL_FAIL.Trace1': Finished evaluating expression 'EXTRACT(HOUR FROM CURRENT_TIMESTAMP)' at (2, 13). This resolved to 'EXTRACT(HOUR FROM TIMESTAMP '2005-11-16 16:44:26.211130')'. The result was '16'.
2005-11-16 16:44:26.212781 2057 UserTrace BIP2538I: Node 'FL_FAIL.Trace1': Evaluating expression 'EXTRACT(MINUTE FROM CURRENT_TIMESTAMP)' at (2, 53).
2005-11-16 16:44:26.212877 2057 UserTrace BIP2538I: Node 'FL_FAIL.Trace1': Evaluating expression 'CURRENT_TIMESTAMP' at (2, 73).
2005-11-16 16:44:26.212997 2057 UserTrace BIP2540I: Node 'FL_FAIL.Trace1': Finished evaluating expression 'CURRENT_TIMESTAMP' at (2, 73). The result was 'TIMESTAMP '2005-11-16 16:44:26.211130''.
2005-11-16 16:44:26.213125 2057 UserTrace BIP2539I: Node 'FL_FAIL.Trace1': Finished evaluating expression 'EXTRACT(MINUTE FROM CURRENT_TIMESTAMP)' at (2, 53). This resolved to 'EXTRACT(MINUTE FROM TIMESTAMP '2005-11-16 16:44:26.211130')'. The result was '44'.
2005-11-16 16:44:26.216459 2057 UserTrace BIP4067I: Message propagated to output terminal for trace node 'FL_FAIL.Trace1'.
The trace node 'FL_FAIL.Trace1' has received a message and is propagating it to any nodes connected to its output terminal.
No user action required.
2005-11-16 16:44:26.216556 2057 UserTrace BIP4080I: Message propagated to try terminal from try-catch node 'FL_FAIL.TryCatch'.
The try-catch node 'FL_FAIL.TryCatch' has received a message and is propagating it to any nodes connected to its try terminal.
No user action required.
2005-11-16 16:44:26.216760 2057 UserTrace BIP2538I: Node 'FL_FAIL.Trace2': Evaluating expression 'EXTRACT(HOUR FROM CURRENT_TIMESTAMP)' at (2, 3).
2005-11-16 16:44:26.216863 2057 UserTrace BIP2538I: Node 'FL_FAIL.Trace2': Evaluating expression 'CURRENT_TIMESTAMP' at (2, 21).
2005-11-16 16:44:26.217041 2057 UserTrace BIP2540I: Node 'FL_FAIL.Trace2': Finished evaluating expression 'CURRENT_TIMESTAMP' at (2, 21). The result was 'TIMESTAMP '2005-11-16 16:44:26.216648''.
2005-11-16 16:44:26.217182 2057 UserTrace BIP2539I: Node 'FL_FAIL.Trace2': Finished evaluating expression 'EXTRACT(HOUR FROM CURRENT_TIMESTAMP)' at (2, 3). This resolved to 'EXTRACT(HOUR FROM TIMESTAMP '2005-11-16 16:44:26.216648')'. The result was '16'.
2005-11-16 16:44:26.217319 2057 UserTrace BIP2538I: Node 'FL_FAIL.Trace2': Evaluating expression 'EXTRACT(MINUTE FROM CURRENT_TIMESTAMP)' at (2, 43).
2005-11-16 16:44:26.217416 2057 UserTrace BIP2538I: Node 'FL_FAIL.Trace2': Evaluating expression 'CURRENT_TIMESTAMP' at (2, 63).
2005-11-16 16:44:26.217540 2057 UserTrace BIP2540I: Node 'FL_FAIL.Trace2': Finished evaluating expression 'CURRENT_TIMESTAMP' at (2, 63). The result was 'TIMESTAMP '2005-11-16 16:44:26.216648''.
2005-11-16 16:44:26.217674 2057 UserTrace BIP2539I: Node 'FL_FAIL.Trace2': Finished evaluating expression 'EXTRACT(MINUTE FROM CURRENT_TIMESTAMP)' at (2, 43). This resolved to 'EXTRACT(MINUTE FROM TIMESTAMP '2005-11-16 16:44:26.216648')'. The result was '44'.
2005-11-16 16:44:26.217796 2057 UserTrace BIP2538I: Node 'FL_FAIL.Trace2': Evaluating expression 'Root' at (5, 3).
2005-11-16 16:44:26.221639 2057 UserTrace BIP4067I: Message propagated to output terminal for trace node 'FL_FAIL.Trace2'.
The trace node 'FL_FAIL.Trace2' has received a message and is propagating it to any nodes connected to its output terminal.
No user action required.
2005-11-16 16:44:27.305242 2057 UserTrace BIP2537I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Executing statement 'SET OutputRoot = InputRoot;' at (1, 1).
2005-11-16 16:44:27.305437 2057 UserTrace BIP2538I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Evaluating expression 'InputRoot' at (1, 1.
2005-11-16 16:44:27.305574 2057 UserTrace BIP2568I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Performing tree copy of '' to 'OutputRoot'.
2005-11-16 16:44:27.306110 2057 UserTrace BIP2537I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Executing statement 'DECLARE sDate1 CHARACTER;' at (8, 1).
2005-11-16 16:44:27.306249 2057 UserTrace BIP2537I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Executing statement 'DECLARE sDate2 CHARACTER;' at (9, 1).
2005-11-16 16:44:27.306356 2057 UserTrace BIP2537I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Executing statement 'DECLARE sDate3 CHARACTER;' at (10, 1).
2005-11-16 16:44:27.306459 2057 UserTrace BIP2537I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Executing statement 'DECLARE sDate4 CHARACTER;' at (11, 1).
2005-11-16 16:44:27.306564 2057 UserTrace BIP2537I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Executing statement 'DECLARE sDate5 CHARACTER;' at (12, 1).
2005-11-16 16:44:27.306667 2057 UserTrace BIP2537I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Executing statement 'DECLARE sFormat1 CHARACTER;' at (13, 1).
2005-11-16 16:44:27.306770 2057 UserTrace BIP2537I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Executing statement 'DECLARE sFormat2 CHARACTER;' at (14, 1).
2005-11-16 16:44:27.306871 2057 UserTrace BIP2537I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Executing statement 'SET sDate1 = InputRoot.XML.Siprog.MsgEntry.Header.EventDate;' at (15, 1).
2005-11-16 16:44:27.306983 2057 UserTrace BIP2538I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Evaluating expression 'InputRoot.XML.Siprog.MsgEntry.Header.EventDate' at (15, 14).
2005-11-16 16:44:27.307117 2057 UserTrace BIP2537I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Executing statement 'SET sDate2 = InputRoot.XML.Siprog.MsgEntry.Header.SendingDate;' at (16, 1).
2005-11-16 16:44:27.307321 2057 UserTrace BIP2538I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Evaluating expression 'InputRoot.XML.Siprog.MsgEntry.Header.SendingDate' at (16, 14).
2005-11-16 16:44:27.307439 2057 UserTrace BIP2537I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Executing statement 'SET sDate3 = InputRoot.XML.Siprog.MsgEntry.Header.FlowDate;' at (17, 1).
2005-11-16 16:44:27.307548 2057 UserTrace BIP2538I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Evaluating expression 'InputRoot.XML.Siprog.MsgEntry.Header.FlowDate' at (17, 14).
2005-11-16 16:44:27.307664 2057 UserTrace BIP2537I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Executing statement 'SET sDate4 = '01/01/2001 12:00:00';' at (19, 1).
2005-11-16 16:44:27.307777 2057 UserTrace BIP2537I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Executing statement 'SET sDate5 = InputRoot.XML.Siprog.MsgEntry.Header.LastSubmitDate;' at (20, 1).
2005-11-16 16:44:27.307884 2057 UserTrace BIP2538I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Evaluating expression 'InputRoot.XML.Siprog.MsgEntry.Header.LastSubmitDate' at (20, 14).
2005-11-16 16:44:27.307998 2057 UserTrace BIP2537I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Executing statement 'SET sFormat1 = 'DD/MM/YYYY HH24:MI:SS';' at (21, 1).
2005-11-16 16:44:27.308107 2057 UserTrace BIP2537I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Executing statement 'SET sFormat2 = 'YYYY-MM-DD HH24:MI:SS';' at (22, 1).
2005-11-16 16:44:27.308233 2057 UserTrace BIP2537I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Executing statement 'DECLARE nIdError INTEGER;' at (29, 1).
2005-11-16 16:44:27.308343 2057 UserTrace BIP2537I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Executing statement 'SET OutputRoot.XML.Siprog.MsgEntry.Header.IdError[ ] = PASSTHRU('select TO_NUMBER(SEQ_IDERROR.NEXTVAL) as NEXTVAL from dual');' at (30, 1).
2005-11-16 16:44:27.308448 2057 UserTrace BIP2538I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Evaluating expression 'PASSTHRU('select TO_NUMBER(SEQ_IDERROR.NEXTVAL) as NEXTVAL from dual')' at (30, 55).
2005-11-16 16:44:27.308568 2057 UserTrace BIP2544I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Executing database SQL statement 'select TO_NUMBER(SEQ_IDERROR.NEXTVAL) as NEXTVAL from dual' derived from (30, 55); expressions ''; resulting parameter values ''.
2005-11-16 16:44:27.312555 2057 UserTrace BIP2562I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Assigning a list to 'OutputRoot.XML.Siprog.MsgEntry.Header.IdError[]'.
2005-11-16 16:44:27.313106 2057 UserTrace BIP2537I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Executing statement 'SET nIdError = CAST(OutputRoot.XML.Siprog.MsgEntry.Header.IdError.NEXTVAL AS DECIMAL);' at (31, 1).
2005-11-16 16:44:27.313241 2057 UserTrace BIP2538I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Evaluating expression 'CAST(OutputRoot.XML.Siprog.MsgEntry.Header.IdError.NEXTVAL AS DECIMAL)' at (31, 16).
2005-11-16 16:44:27.313358 2057 UserTrace BIP2538I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Evaluating expression 'OutputRoot.XML.Siprog.MsgEntry.Header.IdError.NEXTVAL' at (31, 21).
2005-11-16 16:44:27.313613 2057 UserTrace BIP2539I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Finished evaluating expression 'CAST(OutputRoot.XML.Siprog.MsgEntry.Header.IdError.NEXTVAL AS DECIMAL)' at (31, 16). This resolved to 'CAST('4.2455E+4' AS DECIMAL )'. The result was '42455'.
2005-11-16 16:44:27.313751 2057 UserTrace BIP2537I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Executing statement 'DECLARE sLoginUser CHARACTER;' at (38, 1).
2005-11-16 16:44:27.313856 2057 UserTrace BIP2537I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Executing statement 'DECLARE nIdLotError INTEGER;' at (39, 1).
2005-11-16 16:44:27.313953 2057 UserTrace BIP2537I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Executing statement 'DECLARE nPosition1 INTEGER;' at (40, 1).
2005-11-16 16:44:27.314054 2057 UserTrace BIP2537I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Executing statement 'DECLARE nPosition2 INTEGER;' at (41, 1).
2005-11-16 16:44:27.314155 2057 UserTrace BIP2537I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Executing statement 'DECLARE nPosition3 INTEGER;' at (42, 1).
2005-11-16 16:44:27.314258 2057 UserTrace BIP2537I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Executing statement 'DECLARE extrait BLOB;' at (43, 1).
2005-11-16 16:44:27.314363 2057 UserTrace BIP2537I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Executing statement 'DECLARE chaine CHARACTER;' at (44, 1).
2005-11-16 16:44:27.314460 2057 UserTrace BIP2537I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Executing statement 'DECLARE sContent CHARACTER;' at (45, 1).
2005-11-16 16:44:27.314571 2057 UserTrace BIP2537I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Executing statement 'IF InputBody.Siprog.FlagLot IS NOT NULL THEN... ELSE... END IF;' at (51, 1).
2005-11-16 16:44:27.314699 2057 UserTrace BIP2538I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Evaluating expression 'InputBody.Siprog.FlagLot IS NOT NULL' at (51, 29).
2005-11-16 16:44:27.314805 2057 UserTrace BIP2538I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Evaluating expression 'InputBody.Siprog.FlagLot' at (51, 4).
2005-11-16 16:44:27.314905 2057 UserTrace BIP2543E: Node 'FL_FAIL.C_InsDB_EAI_ERROR': (51, 21) : Failed to navigate to path element because it does not exist.
2005-11-16 16:44:27.315010 2057 UserTrace BIP2540I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Finished evaluating expression 'InputBody.Siprog.FlagLot IS NOT NULL' at (51, 29). The result was 'FALSE'.
2005-11-16 16:44:27.315132 2057 UserTrace BIP2537I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Executing statement 'SET sLoginUser = InputBody.Siprog.MsgEntry.Header.LoginUser;' at (70, 3).
2005-11-16 16:44:27.315240 2057 UserTrace BIP2538I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Evaluating expression 'InputBody.Siprog.MsgEntry.Header.LoginUser' at (70, 20).
2005-11-16 16:44:27.315355 2057 UserTrace BIP2537I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Executing statement 'SET nIdLotError = NULL;' at (71, 5).
2005-11-16 16:44:27.315519 2057 UserTrace BIP2537I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Executing statement 'SET extrait = BITSTREAM(InputBody);' at (77, 3).
2005-11-16 16:44:27.316064 2057 UserTrace BIP2538I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Evaluating expression 'BITSTREAM(InputBody)' at (77, 17).
2005-11-16 16:44:27.317743 2057 UserTrace BIP2540I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Finished evaluating expression 'BITSTREAM(InputBody)' at (77, 17). The result was 'X'3c536970726f673e3c4d7367456e7472793e3c4865616465723e3c4f72....''.
2005-11-16 16:44:27.317909 2057 UserTrace BIP2537I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Executing statement 'SET chaine = CAST(extrait AS CHARACTER CCSID InputRoot.MQMD.CodedCharSetId);' at (78, 3).
2005-11-16 16:44:27.318000 2057 UserTrace BIP2538I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Evaluating expression 'CAST(extrait AS CHARACTER CCSID InputRoot.MQMD.CodedCharSetId)' at (78, 16).
2005-11-16 16:44:27.318092 2057 UserTrace BIP2538I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Evaluating expression 'extrait' at (78, 22).
2005-11-16 16:44:27.318229 2057 UserTrace BIP2538I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Evaluating expression 'InputRoot.MQMD.CodedCharSetId' at (78, 49).
2005-11-16 16:44:27.319766 2057 UserTrace BIP2539I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Finished evaluating expression 'CAST(extrait AS CHARACTER CCSID InputRoot.MQMD.CodedCharSetId)' at (78, 16). This resolved to 'CAST(X'3c536970726f673e3c4d7...' AS CHARACTER CCSID 819 )'. The result was ''<Siprog><MsgEntry><Header><OrderId>3456</OrderId><LoginUser>MCHE</LoginUser><SendingApp>Nabucco</SendingApp><MessageType>F_MCHE</MessageType><EventDate>16/11/2005 07:36:38</EventDate><SendingDate>16/11/2005 07:50:35</SendingDate><LastSubmitDate>16/11/2005 10:00:01</LastSubmitDate><FlowName>F_MCHE</FlowName><QueueManagerName>QM_EAI_1_INTEVO</QueueManagerName><QueueName>Q_MCHE</QueueName><FlowDate>2005-07-03 07:50:35</FlowDate><History>M. Jackson</History></Header><Content><Fournisseur>FOUR_MCHE</Fournisseur></Content></MsgEntry></Siprog>''.
2005-11-16 16:44:27.320066 2057 UserTrace BIP2537I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Executing statement 'SET nPosition1 = POSITION('<Content>' IN chaine);' at (79, 3).
2005-11-16 16:44:27.320161 2057 UserTrace BIP2538I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Evaluating expression 'POSITION('<Content>' IN chaine)' at (79, 20).
2005-11-16 16:44:27.320272 2057 UserTrace BIP2538I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Evaluating expression 'chaine' at (79, 44).
2005-11-16 16:44:27.320428 2057 UserTrace BIP2539I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Finished evaluating expression 'POSITION('<Content>' IN chaine)' at (79, 20). This resolved to 'POSITION('<Content>' IN '<Siprog><MsgEntry><Header><OrderId>3456</OrderId><LoginUser>MCHE</LoginUser><SendingApp>Nabucco</SendingApp><MessageType>F_MCHE</MessageType><EventDate>16/11/2005 07:36:38</EventDate><SendingDate>16/11/2005 07:50:35</SendingDate><LastSubmitDate>16/11/2005 10:00:01</LastSubmitDate><FlowName>F_MCHE</FlowName><QueueManagerName>QM_EAI_1_INTEVO</QueueManagerName><QueueName>Q_MCHE</QueueName><FlowDate>2005-07-03 07:50:35</FlowDate><History>M. Jackson</History></Header><Content><Fournisseur>FOUR_MCHE</Fournisseur></Content></MsgEntry></Siprog>')'. The result was '468'.
2005-11-16 16:44:27.320556 2057 UserTrace BIP2537I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Executing statement 'SET nPosition2 = POSITION('</Content>' IN chaine);' at (80, 3).
2005-11-16 16:44:27.320646 2057 UserTrace BIP2538I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Evaluating expression 'POSITION('</Content>' IN chaine)' at (80, 20).
2005-11-16 16:44:27.320775 2057 UserTrace BIP2538I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Evaluating expression 'chaine' at (80, 45).
2005-11-16 16:44:27.320920 2057 UserTrace BIP2539I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Finished evaluating expression 'POSITION('</Content>' IN chaine)' at (80, 20). This resolved to 'POSITION('</Content>' IN '<Siprog><MsgEntry><Header><OrderId>3456</OrderId><LoginUser>MCHE</LoginUser><SendingApp>Nabucco</SendingApp><MessageType>F_MCHE</MessageType><EventDate>16/11/2005 07:36:38</EventDate><SendingDate>16/11/2005 07:50:35</SendingDate><LastSubmitDate>16/11/2005 10:00:01</LastSubmitDate><FlowName>F_MCHE</FlowName><QueueManagerName>QM_EAI_1_INTEVO</QueueManagerName><QueueName>Q_MCHE</QueueName><FlowDate>2005-07-03 07:50:35</FlowDate><History>M. Jackson</History></Header><Content><Fournisseur>FOUR_MCHE</Fournisseur></Content></MsgEntry></Siprog>')'. The result was '513'.
2005-11-16 16:44:27.321056 2057 UserTrace BIP2537I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Executing statement 'SET nPosition3 = nPosition2 - nPosition1 - 9;' at (81, 3).
2005-11-16 16:44:27.321151 2057 UserTrace BIP2538I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Evaluating expression 'nPosition2 - nPosition1 - 9' at (81, 45).
2005-11-16 16:44:27.321243 2057 UserTrace BIP2538I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Evaluating expression 'nPosition2 - nPosition1' at (81, 32).
2005-11-16 16:44:27.321332 2057 UserTrace BIP2538I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Evaluating expression 'nPosition2' at (81, 21).
2005-11-16 16:44:27.321422 2057 UserTrace BIP2538I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Evaluating expression 'nPosition1' at (81, 34).
2005-11-16 16:44:27.321613 2057 UserTrace BIP2539I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Finished evaluating expression 'nPosition2 - nPosition1' at (81, 32). This resolved to '513 - 468'. The result was '45'.
2005-11-16 16:44:27.321727 2057 UserTrace BIP2539I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Finished evaluating expression 'nPosition2 - nPosition1 - 9' at (81, 45). This resolved to '45 - 9'. The result was '36'.
2005-11-16 16:44:27.324777 2057 UserTrace BIP2537I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Executing statement 'SET sContent = SUBSTRING(chaine FROM nPosition1 + 9 FOR nPosition3);' at (82, 3).
2005-11-16 16:44:27.324890 2057 UserTrace BIP2538I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Evaluating expression 'SUBSTRING(chaine FROM nPosition1 + 9 FOR nPosition3)' at (82, 1.
2005-11-16 16:44:27.324989 2057 UserTrace BIP2538I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Evaluating expression 'chaine' at (82, 29).
2005-11-16 16:44:27.325090 2057 UserTrace BIP2538I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Evaluating expression 'nPosition1 + 9' at (82, 51).
2005-11-16 16:44:27.325180 2057 UserTrace BIP2538I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Evaluating expression 'nPosition1' at (82, 41).
2005-11-16 16:44:27.325296 2057 UserTrace BIP2539I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Finished evaluating expression 'nPosition1 + 9' at (82, 51). This resolved to '468 + 9'. The result was '477'.
2005-11-16 16:44:27.325624 2057 UserTrace BIP2538I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Evaluating expression 'nPosition3' at (82, 5.
2005-11-16 16:44:27.325809 2057 UserTrace BIP2539I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Finished evaluating expression 'SUBSTRING(chaine FROM nPosition1 + 9 FOR nPosition3)' at (82, 1. This resolved to 'SUBSTRING('<Siprog><MsgEntry><Header><OrderId>3456</OrderId><LoginUser>MCHE</LoginUser><SendingApp>Nabucco</SendingApp><MessageType>F_MCHE</MessageType><EventDate>16/11/2005 07:36:38</EventDate><SendingDate>16/11/2005 07:50:35</SendingDate><LastSubmitDate>16/11/2005 10:00:01</LastSubmitDate><FlowName>F_MCHE</FlowName><QueueManagerName>QM_EAI_1_INTEVO</QueueManagerName><QueueName>Q_MCHE</QueueName><FlowDate>2005-07-03 07:50:35</FlowDate><History>M. Jackson</History></Header><Content><Fournisseur>FOUR_MCHE</Fournisseur></Content></MsgEntry></Siprog>' FROM 477 FOR 36)'. The result was ''<Fournisseur>FOUR_MCHE</Fournisseur>''.
2005-11-16 16:44:27.325988 2057 UserTrace BIP2537I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Executing statement 'PASSTHRU(nIdError, nIdLotError, InputBody.Siprog.MsgEntry.Header.OrderId, sLoginUser, InputBody.Siprog.MsgEntry.Header.FlowName, InputBody.Siprog.MsgEntry.Header.SendingApp, InputBody.Siprog.MsgEntry.Header.MessageType, InputBody.Siprog.MsgEntry.Header.QueueManagerName, InputBody.Siprog.MsgEntry.Header.QueueName, InputBody.Siprog.MsgEntry.Header.SubmitNumber, InputBody.Siprog.MsgEntry.Header.Error.Code, InputBody.Siprog.MsgEntry.Header.Error.Text, InputBody.Siprog.MsgEntry.Header.Error.Node, sContent, InputBody.Siprog.MsgEntry.Header.History, sDate1, sFormat1, sDate2, sFormat1, sDate3, sFormat2, sDate4, sFormat1, sDate5, sFormat1)' at (90, 1).
2005-11-16 16:44:27.326162 2057 UserTrace BIP2538I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Evaluating expression 'nIdError' at (114, 3).
2005-11-16 16:44:27.326267 2057 UserTrace BIP2538I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Evaluating expression 'nIdLotError' at (115, 3).
2005-11-16 16:44:27.326402 2057 UserTrace BIP2538I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Evaluating expression 'InputBody.Siprog.MsgEntry.Header.OrderId' at (116, 3).
2005-11-16 16:44:27.326519 2057 UserTrace BIP2538I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Evaluating expression 'sLoginUser' at (117, 3).
2005-11-16 16:44:27.326625 2057 UserTrace BIP2538I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Evaluating expression 'InputBody.Siprog.MsgEntry.Header.FlowName' at (118, 3).
2005-11-16 16:44:27.326744 2057 UserTrace BIP2538I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Evaluating expression 'InputBody.Siprog.MsgEntry.Header.SendingApp' at (119, 3).
2005-11-16 16:44:27.326858 2057 UserTrace BIP2538I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Evaluating expression 'InputBody.Siprog.MsgEntry.Header.MessageType' at (120, 3).
2005-11-16 16:44:27.326974 2057 UserTrace BIP2538I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Evaluating expression 'InputBody.Siprog.MsgEntry.Header.QueueManagerName' at (121, 3).
2005-11-16 16:44:27.327095 2057 UserTrace BIP2538I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Evaluating expression 'InputBody.Siprog.MsgEntry.Header.QueueName' at (122, 3).
2005-11-16 16:44:27.327209 2057 UserTrace BIP2538I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Evaluating expression 'InputBody.Siprog.MsgEntry.Header.SubmitNumber' at (123, 3).
2005-11-16 16:44:27.327301 2057 UserTrace BIP2543E: Node 'FL_FAIL.C_InsDB_EAI_ERROR': (123, 36) : Failed to navigate to path element because it does not exist.
2005-11-16 16:44:27.327432 2057 UserTrace BIP2538I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Evaluating expression 'InputBody.Siprog.MsgEntry.Header.Error.Code' at (124, 3).
2005-11-16 16:44:27.327522 2057 UserTrace BIP2543E: Node 'FL_FAIL.C_InsDB_EAI_ERROR': (124, 36) : Failed to navigate to path element because it does not exist.
2005-11-16 16:44:27.327625 2057 UserTrace BIP2538I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Evaluating expression 'InputBody.Siprog.MsgEntry.Header.Error.Text' at (125, 3).
2005-11-16 16:44:27.327713 2057 UserTrace BIP2543E: Node 'FL_FAIL.C_InsDB_EAI_ERROR': (125, 36) : Failed to navigate to path element because it does not exist.
2005-11-16 16:44:27.327814 2057 UserTrace BIP2538I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Evaluating expression 'InputBody.Siprog.MsgEntry.Header.Error.Node' at (126, 3).
2005-11-16 16:44:27.327903 2057 UserTrace BIP2543E: Node 'FL_FAIL.C_InsDB_EAI_ERROR': (126, 36) : Failed to navigate to path element because it does not exist.
2005-11-16 16:44:27.327995 2057 UserTrace BIP2538I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Evaluating expression 'sContent' at (127, 3).
2005-11-16 16:44:27.328105 2057 UserTrace BIP2538I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Evaluating expression 'InputBody.Siprog.MsgEntry.Header.History' at (128, 17).
2005-11-16 16:44:27.328264 2057 UserTrace BIP2538I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Evaluating expression 'sDate1' at (129, 3).
2005-11-16 16:44:27.328413 2057 UserTrace BIP2538I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Evaluating expression 'sFormat1' at (129, 11).
2005-11-16 16:44:27.328588 2057 UserTrace BIP2538I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Evaluating expression 'sDate2' at (130, 3).
2005-11-16 16:44:27.328689 2057 UserTrace BIP2538I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Evaluating expression 'sFormat1' at (130, 11).
2005-11-16 16:44:27.328792 2057 UserTrace BIP2538I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Evaluating expression 'sDate3' at (131, 3).
2005-11-16 16:44:27.328891 2057 UserTrace BIP2538I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Evaluating expression 'sFormat2' at (131, 11).
2005-11-16 16:44:27.328992 2057 UserTrace BIP2538I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Evaluating expression 'sDate4' at (132, 3).
2005-11-16 16:44:27.329092 2057 UserTrace BIP2538I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Evaluating expression 'sFormat1' at (132, 11).
2005-11-16 16:44:27.329191 2057 UserTrace BIP2538I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Evaluating expression 'sDate5' at (133, 3).
2005-11-16 16:44:27.329290 2057 UserTrace BIP2538I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Evaluating expression 'sFormat1' at (133, 11).
2005-11-16 16:44:27.329399 2057 UserTrace BIP2544I: Node 'FL_FAIL.C_InsDB_EAI_ERROR': Executing database SQL statement 'INSERT INTO EAI_ERROR (
IDERROR,
IDLOT,
ORDERID,
LOGINUSER,
FLOWNAME,
SENDINGAPPLICATION,
MESSAGETYPE,
QMANAGER,
QNAME,
SUBMITNUMBER,
ERRORCODE,
ERRORTEXT,
ERRORNODE,
BUFFERXML,
HISTORY,
EVENTDATE,
SENDINGDATE,
FLOWDATE,
CHANGINGDATE,
LASTSUBMITDATE)
VALUES (?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?,
TO_DATE(?, ?), TO_DATE(?, ?), TO_DATE(?, ?), TO_DATE(?, ?), TO_DATE(?, ?))' derived from (90, 1); expressions 'nIdError, nIdLotError, InputBody.Siprog.MsgEntry.Header.OrderId, sLoginUser, InputBody.Siprog.MsgEntry.Header.FlowName, InputBody.Siprog.MsgEntry.Header.SendingApp, InputBody.Siprog.MsgEntry.Header.MessageType, InputBody.Siprog.MsgEntry.Header.QueueManagerName, InputBody.Siprog.MsgEntry.Header.QueueName, InputBody.Siprog.MsgEntry.Header.SubmitNumber, InputBody.Siprog.MsgEntry.Header.Error.Code, InputBody.Siprog.MsgEntry.Header.Error.Text, InputBody.Siprog.MsgEntry.Header.Error.Node, sContent, InputBody.Siprog.MsgEntry.Header.History, sDate1, sFormat1, sDate2, sFormat1, sDate3, sFormat2, sDate4, sFormat1, sDate5, sFormat1'; resulting parameter values '42455, NULL, '3456', 'MCHE', 'F_MCHE', 'Nabucco', 'F_MCHE', 'QM_EAI_1_INTEVO', 'Q_MCHE', NULL, NULL, NULL, NULL, '<Fournisseur>FOUR_MCHE</Fournisseur>', 'M. Jackson', '16/11/2005 07:36:38', 'DD/MM/YYYY HH24:MI:SS', '16/11/2005 07:50:35', 'DD/MM/YYYY HH24:MI:SS', '2005-07-03 07:50:35', 'YYYY-MM-DD HH24:MI:SS', '01/01/2001 12:00:00', 'DD/MM/YYYY HH24:MI:SS', '16/11/2005 10:00:01', 'DD/MM/YYYY HH24:MI:SS''.
2005-11-16 16:44:27.340963 2057 UserTrace BIP4124I: Message propagated to 'out' terminal of compute node 'FL_FAIL.C_InsDB_EAI_ERROR'.
|
|
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed Nov 16, 2005 8:25 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
You do not need to use BITSTREAM or ASBITSTREAM on InputRoot.BLOB.BLOB.
It's already a bitstream.
So try
| Code: |
--SET extrait = ASBITSTREAM(InputRoot.BLOB.BLOB);
------------------------------
SET chaine = CAST( InputRoot.BLOB.BLOB AS CHARACTER CCSID InputRoot.MQMD.CodedCharSetId); |
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| JT |
| Posted: Wed Nov 16, 2005 9:34 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
| Quote: |
SET OutputRoot = InputRoot;
-- Entrez le code SQL sous cette ligne. Le SQL au-dessus de cette ligne pourrait être régénéré, ce qui entraînerait la perte des modifications.
DECLARE extrait BLOB;
DECLARE chaine CHARACTER;
SET extrait = ASBITSTREAM(InputRoot.BLOB.BLOB);
------------------------------
-- Chaine contient le message
------------------------------
SET chaine = CAST( extrait AS CHARACTER CCSID InputRoot.MQMD.CodedCharSetId);
DECLARE nPosition1 INTEGER;
DECLARE nPosition2 INTEGER;
DECLARE nPosition3 INTEGER;
SET nPosition1 = POSITION('<Content>' IN chaine);
SET nPosition2 = POSITION('</Content>' IN chaine);
SET nPosition3 = nPosition2 - 9 - nPosition1;
DECLARE sContent CHARACTER;
SET sContent = SUBSTRING (chaine FROM nPosition1+9 FOR nPosition3);
SET OutputRoot.XML.MsgEntry.Siprog.Content2=sContent; |
You can't set two different domains for your output message (BLOB & XML), you'll sustain another error after correcting your current problem. My guess is you want to copy just the message headers and not the entire message:
| Code: |
DECLARE I INTEGER 1;
DECLARE J INTEGER CARDINALITY(InputRoot.*[]);
WHILE I < J DO
SET OutputRoot.*[I] = InputRoot.*[I];
SET I = I + 1;
END WHILE; |
instead of this:
| Code: |
| SET OutputRoot = InputRoot; |
|
|
| Back to top |
|
|
| Manuel_ch |
| Posted: Thu Nov 17, 2005 1:47 am Post subject: |
|
|
Apprentice
Joined: 27 Jul 2005
Posts: 31
|
I've corrected my test flow F_MCHE with his MQInput domain as XML.
Then I put the compute ESQL code from the flow which doesn't work to the compute node of the test flow.
The ESQL code Compute node of the test flow becomes similare as the compute node which fails in the flow F_RB:
| Quote: |
SET OutputRoot = InputRoot;
-- Entrez le code SQL sous cette ligne. Le SQL au-dessus de cette ligne pourrait être régénéré, ce qui entraînerait la perte des modifications.
DECLARE extrait BLOB;
DECLARE chaine CHARACTER;
SET extrait = BITSTREAM(InputBody);
------------------------------
-- Chaine contient le message
------------------------------
SET chaine = CAST( extrait AS CHARACTER CCSID InputRoot.MQMD.CodedCharSetId);
--SET chaine = ASBITSTREAM( extrait OPTIONS RootBitStream CCSID InputRoot.MQMD.CodedCharSetId FORMAT CHARACTER);
DECLARE nPosition1 INTEGER;
DECLARE nPosition2 INTEGER;
DECLARE nPosition3 INTEGER;
SET nPosition1 = POSITION('<Content>' IN chaine);
SET nPosition2 = POSITION('</Content>' IN chaine);
SET nPosition3 = nPosition2 - 9 - nPosition1;
DECLARE sContent CHARACTER;
SET sContent = SUBSTRING (chaine FROM nPosition1+9 FOR nPosition3);
-----------------------------
-- Traitement des guillemets
-----------------------------
-- DECLARE n INTEGER;
-- DECLARE i INTEGER;
-- SET n = POSITION('''' in sContent);
-- SET i = 1;
-- while n <> 0 and i < 100 do
-- SET i = i+1;
-- SET sContent = OVERLAY (sContent PLACING '''''' FROM n FOR 1);
-- SET n = position('''' in substring(sContent from n+2));
-- end while;
-----------------
-- Appel PS OPX2
-----------------
--PASSTHRU('{call FLUX_RB.EAI_OPX2_CREATIONREFBUD(?)}', sContent);
|
I submit a message in the both flows F_MCHE and F_RB.
The trace before and during the processing of the compute Node of the F_MCHE is :
| Quote: |
***Trace Root 10:10
(
(0x1000000)Properties = (
(0x3000000)MessageSet = ''
(0x3000000)MessageType = ''
(0x3000000)MessageFormat = ''
(0x3000000)Encoding = 273
(0x3000000)CodedCharSetId = 819
(0x3000000)Transactional = TRUE
(0x3000000)Persistence = TRUE
(0x3000000)CreationTime = GMTTIMESTAMP '2005-11-17 09:10:55.430'
(0x3000000)ExpirationTime = -1
(0x3000000)Priority = 0
(0x3000000)ReplyIdentifier = X'000000000000000000000000000000000000000000000000'
(0x3000000)ReplyProtocol = 'MQ'
(0x3000000)Topic = NULL
)
(0x1000000)MQMD = (
(0x3000000)SourceQueue = 'Q_MCHE'
(0x3000000)Transactional = TRUE
(0x3000000)Encoding = 273
(0x3000000)CodedCharSetId = 819
(0x3000000)Format = 'MQSTR '
(0x3000000)Version = 2
(0x3000000)Report = 0
(0x3000000)MsgType = 8
(0x3000000)Expiry = -1
(0x3000000)Feedback = 0
(0x3000000)Priority = 0
(0x3000000)Persistence = 1
(0x3000000)MsgId = X'414d5120514d5f4541495f315f494e5443706dc9002d6013'
(0x3000000)CorrelId = X'000000000000000000000000000000000000000000000000'
(0x3000000)BackoutCount = 0
(0x3000000)ReplyToQ = ' '
(0x3000000)ReplyToQMgr = 'QM_EAI_1_INTEVO '
(0x3000000)UserIdentifier = 'mqmie '
(0x3000000)AccountingToken = X'0332303800000000000000000000000000000000000000000000000000000006'
(0x3000000)ApplIdentityData = ' '
(0x3000000)PutApplType = 28
(0x3000000)PutApplName = 'MQSeries Client for Java '
(0x3000000)PutDate = DATE '2005-11-17'
(0x3000000)PutTime = GMTTIME '09:10:55.430'
(0x3000000)ApplOriginData = ' '
(0x3000000)GroupId = X'000000000000000000000000000000000000000000000000'
(0x3000000)MsgSeqNumber = 1
(0x3000000)Offset = 0
(0x3000000)MsgFlags = 0
(0x3000000)OriginalLength = -1
)
(0x1000010)XML = (
(0x1000000)Siprog = (
(0x1000000)MsgEntry = (
(0x1000000)Header = (
.... etc
)
(0x1000000)Content = (
.... etc
)
)
)
)
)
Timestamps are formatted in local time, 60 minutes past GMT.
2005-11-17 10:09:11.464030 2571 UserTrace BIP7082I: Node '': Publishing to destination QM_CFG_MGR:SYSTEM.BROKER.ADMIN.REPLY:4366674d677253756233 for user mqseries.
A publication destination is being added to the list of destinations to QM_CFG_MGR:SYSTEM.BROKER.ADMIN.REPLY:4366674d677253756233 for user mqseries.
No user action required.
2005-11-17 10:10:55.482631 2314 UserTrace BIP2632I: Message received and propagated to 'out' terminal of MQ input node 'FL_F_MCHE.MQInput1'.
2005-11-17 10:10:55.483066 2314 UserTrace BIP6060I: Parser type 'Properties' created on behalf of node 'FL_F_MCHE.MQInput1' to handle portion of incoming message of length 0 bytes beginning at offset '0'.
2005-11-17 10:10:55.483383 2314 UserTrace BIP6061I: Parser type 'MQMD' created on behalf of node 'FL_F_MCHE.MQInput1' to handle portion of incoming message of length '364' bytes beginning at offset '0'. Parser type selected based on value 'MQHMD' from previous parser.
2005-11-17 10:10:55.483833 2314 UserTrace BIP6061I: Parser type 'XML' created on behalf of node 'FL_F_MCHE.MQInput1' to handle portion of incoming message of length '1880' bytes beginning at offset '364'. Parser type selected based on value 'XML' from previous parser.
2005-11-17 10:10:55.484085 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Trace1': Evaluating expression 'EXTRACT(HOUR FROM CURRENT_TIMESTAMP)' at (1, 17).
2005-11-17 10:10:55.484199 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Trace1': Evaluating expression 'CURRENT_TIMESTAMP' at (1, 35).
2005-11-17 10:10:55.484466 2314 UserTrace BIP2540I: Node 'FL_F_MCHE.Trace1': Finished evaluating expression 'CURRENT_TIMESTAMP' at (1, 35). The result was 'TIMESTAMP '2005-11-17 10:10:55.482881''.
2005-11-17 10:10:55.484626 2314 UserTrace BIP2539I: Node 'FL_F_MCHE.Trace1': Finished evaluating expression 'EXTRACT(HOUR FROM CURRENT_TIMESTAMP)' at (1, 17). This resolved to 'EXTRACT(HOUR FROM TIMESTAMP '2005-11-17 10:10:55.482881')'. The result was '10'.
2005-11-17 10:10:55.484748 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Trace1': Evaluating expression 'EXTRACT(MINUTE FROM CURRENT_TIMESTAMP)' at (1, 57).
2005-11-17 10:10:55.484844 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Trace1': Evaluating expression 'CURRENT_TIMESTAMP' at (1, 77).
2005-11-17 10:10:55.484985 2314 UserTrace BIP2540I: Node 'FL_F_MCHE.Trace1': Finished evaluating expression 'CURRENT_TIMESTAMP' at (1, 77). The result was 'TIMESTAMP '2005-11-17 10:10:55.482881''.
2005-11-17 10:10:55.485122 2314 UserTrace BIP2539I: Node 'FL_F_MCHE.Trace1': Finished evaluating expression 'EXTRACT(MINUTE FROM CURRENT_TIMESTAMP)' at (1, 57). This resolved to 'EXTRACT(MINUTE FROM TIMESTAMP '2005-11-17 10:10:55.482881')'. The result was '10'.
2005-11-17 10:10:55.485244 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Trace1': Evaluating expression 'Root' at (2, 3).
2005-11-17 10:10:55.490573 2314 UserTrace BIP4067I: Message propagated to output terminal for trace node 'FL_F_MCHE.Trace1'.
The trace node 'FL_F_MCHE.Trace1' has received a message and is propagating it to any nodes connected to its output terminal.
No user action required.
2005-11-17 10:10:55.701133 2314 UserTrace BIP2537I: Node 'FL_F_MCHE.Compute1': Executing statement 'SET OutputRoot = InputRoot;' at (1, 1).
2005-11-17 10:10:55.701324 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Compute1': Evaluating expression 'InputRoot' at (1, 1.
2005-11-17 10:10:55.701488 2314 UserTrace BIP2568I: Node 'FL_F_MCHE.Compute1': Performing tree copy of '' to 'OutputRoot'.
2005-11-17 10:10:55.702156 2314 UserTrace BIP2537I: Node 'FL_F_MCHE.Compute1': Executing statement 'DECLARE extrait BLOB;' at (4, 1).
2005-11-17 10:10:55.702278 2314 UserTrace BIP2537I: Node 'FL_F_MCHE.Compute1': Executing statement 'DECLARE chaine CHARACTER;' at (5, 1).
2005-11-17 10:10:55.702377 2314 UserTrace BIP2537I: Node 'FL_F_MCHE.Compute1': Executing statement 'SET extrait = BITSTREAM(InputBody);' at (6, 1).
2005-11-17 10:10:55.702514 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Compute1': Evaluating expression 'BITSTREAM(InputBody)' at (6, 15).
2005-11-17 10:10:55.707519 2314 UserTrace BIP2540I: Node 'FL_F_MCHE.Compute1': Finished evaluating expression 'BITSTREAM(InputBody)' at (6, 15). The result was 'X'3c536970726f673e3c4d73674...''.
2005-11-17 10:10:55.708091 2314 UserTrace BIP2537I: Node 'FL_F_MCHE.Compute1': Executing statement 'SET chaine = CAST(extrait AS CHARACTER CCSID InputRoot.MQMD.CodedCharSetId);' at (11, 1).
2005-11-17 10:10:55.708202 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Compute1': Evaluating expression 'CAST(extrait AS CHARACTER CCSID InputRoot.MQMD.CodedCharSetId)' at (11, 14).
2005-11-17 10:10:55.708293 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Compute1': Evaluating expression 'extrait' at (11, 20).
2005-11-17 10:10:55.708396 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Compute1': Evaluating expression 'InputRoot.MQMD.CodedCharSetId' at (11, 47).
2005-11-17 10:10:55.713359 2314 UserTrace BIP2539I: Node 'FL_F_MCHE.Compute1': Finished evaluating expression 'CAST(extrait AS CHARACTER CCSID InputRoot.MQMD.CodedCharSetId)' at (11, 14). This resolved to 'CAST(X'3c536970726f673....e' AS CHARACTER CCSID 819 )'. The result was ''<Siprog><MsgEntry><Header>...etc etc </Header><Content>... etc etc</Content></MsgEntry></Siprog>''.
2005-11-17 10:10:55.713733 2314 UserTrace BIP2537I: Node 'FL_F_MCHE.Compute1': Executing statement 'DECLARE nPosition1 INTEGER;' at (14, 1).
2005-11-17 10:10:55.713836 2314 UserTrace BIP2537I: Node 'FL_F_MCHE.Compute1': Executing statement 'DECLARE nPosition2 INTEGER;' at (15, 1).
2005-11-17 10:10:55.713939 2314 UserTrace BIP2537I: Node 'FL_F_MCHE.Compute1': Executing statement 'DECLARE nPosition3 INTEGER;' at (16, 1).
2005-11-17 10:10:55.714038 2314 UserTrace BIP2537I: Node 'FL_F_MCHE.Compute1': Executing statement 'SET nPosition1 = POSITION('<Content>' IN chaine);' at (17, 1).
2005-11-17 10:10:55.714134 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Compute1': Evaluating expression 'POSITION('<Content>' IN chaine)' at (17, 1.
2005-11-17 10:10:55.714252 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Compute1': Evaluating expression 'chaine' at (17, 42).
2005-11-17 10:10:55.714553 2314 UserTrace BIP2539I: Node 'FL_F_MCHE.Compute1': Finished evaluating expression 'POSITION('<Content>' IN chaine)' at (17, 1. This resolved to 'POSITION('<Content>' IN '<Siprog><MsgEntry><Header> .... </Content></MsgEntry></Siprog>')'. The result was '971'.
2005-11-17 10:10:55.714763 2314 UserTrace BIP2537I: Node 'FL_F_MCHE.Compute1': Executing statement 'SET nPosition2 = POSITION('</Content>' IN chaine);' at (18, 1).
2005-11-17 10:10:55.714855 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Compute1': Evaluating expression 'POSITION('</Content>' IN chaine)' at (18, 1.
2005-11-17 10:10:55.714950 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Compute1': Evaluating expression 'chaine' at (18, 43).
2005-11-17 10:10:55.715255 2314 UserTrace BIP2539I: Node 'FL_F_MCHE.Compute1': Finished evaluating expression 'POSITION('</Content>' IN chaine)' at (18, 1. This resolved to 'POSITION('</Content>' IN '<Siprog><MsgEntry><Header>.....</Content></MsgEntry></Siprog>')'. The result was '1851'.
2005-11-17 10:10:55.715461 2314 UserTrace BIP2537I: Node 'FL_F_MCHE.Compute1': Executing statement 'SET nPosition3 = nPosition2 - 9 - nPosition1;' at (19, 1).
2005-11-17 10:10:55.715553 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Compute1': Evaluating expression 'nPosition2 - 9 - nPosition1' at (19, 34).
2005-11-17 10:10:55.715644 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Compute1': Evaluating expression 'nPosition2 - 9' at (19, 30).
2005-11-17 10:10:55.715728 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Compute1': Evaluating expression 'nPosition2' at (19, 19).
2005-11-17 10:10:55.715843 2314 UserTrace BIP2539I: Node 'FL_F_MCHE.Compute1': Finished evaluating expression 'nPosition2 - 9' at (19, 30). This resolved to '1851 - 9'. The result was '1842'.
2005-11-17 10:10:55.715938 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Compute1': Evaluating expression 'nPosition1' at (19, 36).
2005-11-17 10:10:55.716068 2314 UserTrace BIP2539I: Node 'FL_F_MCHE.Compute1': Finished evaluating expression 'nPosition2 - 9 - nPosition1' at (19, 34). This resolved to '1842 - 971'. The result was '871'.
2005-11-17 10:10:55.716171 2314 UserTrace BIP2537I: Node 'FL_F_MCHE.Compute1': Executing statement 'DECLARE sContent CHARACTER;' at (21, 1).
2005-11-17 10:10:55.716266 2314 UserTrace BIP2537I: Node 'FL_F_MCHE.Compute1': Executing statement 'SET sContent = SUBSTRING(chaine FROM nPosition1 + 9 FOR nPosition3);' at (22, 1).
2005-11-17 10:10:55.716354 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Compute1': Evaluating expression 'SUBSTRING(chaine FROM nPosition1 + 9 FOR nPosition3)' at (22, 16).
2005-11-17 10:10:55.716445 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Compute1': Evaluating expression 'chaine' at (22, 27).
2005-11-17 10:10:55.716541 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Compute1': Evaluating expression 'nPosition1 + 9' at (22, 49).
2005-11-17 10:10:55.716625 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Compute1': Evaluating expression 'nPosition1' at (22, 39).
2005-11-17 10:10:55.716739 2314 UserTrace BIP2539I: Node 'FL_F_MCHE.Compute1': Finished evaluating expression 'nPosition1 + 9' at (22, 49). This resolved to '971 + 9'. The result was '980'.
2005-11-17 10:10:55.716835 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Compute1': Evaluating expression 'nPosition3' at (22, 56).
2005-11-17 10:10:55.717193 2314 UserTrace BIP2539I: Node 'FL_F_MCHE.Compute1': Finished evaluating expression 'SUBSTRING(chaine FROM nPosition1 + 9 FOR nPosition3)' at (22, 16). This resolved to 'SUBSTRING('<Siprog><MsgEntry><Header>....</Content></MsgEntry></Siprog>' FROM 980 FOR 871)'. The result was ''<Mission>....</Mission>''.
2005-11-17 10:10:55.717613 2314 UserTrace BIP4124I: Message propagated to 'out' terminal of compute node 'FL_F_MCHE.Compute1'.
2005-11-17 10:10:55.717884 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Trace2': Evaluating expression 'EXTRACT(HOUR FROM CURRENT_TIMESTAMP)' at (1, 1.
2005-11-17 10:10:55.717987 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Trace2': Evaluating expression 'CURRENT_TIMESTAMP' at (1, 36).
2005-11-17 10:10:55.718208 2314 UserTrace BIP2540I: Node 'FL_F_MCHE.Trace2': Finished evaluating expression 'CURRENT_TIMESTAMP' at (1, 36). The result was 'TIMESTAMP '2005-11-17 10:10:55.717731''.
2005-11-17 10:10:55.718349 2314 UserTrace BIP2539I: Node 'FL_F_MCHE.Trace2': Finished evaluating expression 'EXTRACT(HOUR FROM CURRENT_TIMESTAMP)' at (1, 1. This resolved to 'EXTRACT(HOUR FROM TIMESTAMP '2005-11-17 10:10:55.717731')'. The result was '10'.
2005-11-17 10:10:55.718490 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Trace2': Evaluating expression 'EXTRACT(MINUTE FROM CURRENT_TIMESTAMP)' at (1, 5.
2005-11-17 10:10:55.718582 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Trace2': Evaluating expression 'CURRENT_TIMESTAMP' at (1, 7.
2005-11-17 10:10:55.718696 2314 UserTrace BIP2540I: Node 'FL_F_MCHE.Trace2': Finished evaluating expression 'CURRENT_TIMESTAMP' at (1, 7. The result was 'TIMESTAMP '2005-11-17 10:10:55.717731''.
2005-11-17 10:10:55.718822 2314 UserTrace BIP2539I: Node 'FL_F_MCHE.Trace2': Finished evaluating expression 'EXTRACT(MINUTE FROM CURRENT_TIMESTAMP)' at (1, 5. This resolved to 'EXTRACT(MINUTE FROM TIMESTAMP '2005-11-17 10:10:55.717731')'. The result was '10'.
2005-11-17 10:10:55.718929 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Trace2': Evaluating expression 'Root' at (2, 3).
2005-11-17 10:10:55.722751 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Trace2': Evaluating expression 'EXTRACT(HOUR FROM CURRENT_TIMESTAMP)' at (4, 26).
2005-11-17 10:10:55.722850 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Trace2': Evaluating expression 'CURRENT_TIMESTAMP' at (4, 44).
2005-11-17 10:10:55.722965 2314 UserTrace BIP2540I: Node 'FL_F_MCHE.Trace2': Finished evaluating expression 'CURRENT_TIMESTAMP' at (4, 44). The result was 'TIMESTAMP '2005-11-17 10:10:55.717731''.
2005-11-17 10:10:55.723091 2314 UserTrace BIP2539I: Node 'FL_F_MCHE.Trace2': Finished evaluating expression 'EXTRACT(HOUR FROM CURRENT_TIMESTAMP)' at (4, 26). This resolved to 'EXTRACT(HOUR FROM TIMESTAMP '2005-11-17 10:10:55.717731')'. The result was '10'.
2005-11-17 10:10:55.723255 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Trace2': Evaluating expression 'EXTRACT(MINUTE FROM CURRENT_TIMESTAMP)' at (4, 66).
2005-11-17 10:10:55.723346 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Trace2': Evaluating expression 'CURRENT_TIMESTAMP' at (4, 86).
2005-11-17 10:10:55.723461 2314 UserTrace BIP2540I: Node 'FL_F_MCHE.Trace2': Finished evaluating expression 'CURRENT_TIMESTAMP' at (4, 86). The result was 'TIMESTAMP '2005-11-17 10:10:55.717731''.
2005-11-17 10:10:55.723587 2314 UserTrace BIP2539I: Node 'FL_F_MCHE.Trace2': Finished evaluating expression 'EXTRACT(MINUTE FROM CURRENT_TIMESTAMP)' at (4, 66). This resolved to 'EXTRACT(MINUTE FROM TIMESTAMP '2005-11-17 10:10:55.717731')'. The result was '10'.
2005-11-17 10:10:55.723690 2314 UserTrace BIP2538I: Node 'FL_F_MCHE.Trace2': Evaluating expression 'ExceptionList' at (5, 3).
2005-11-17 10:10:55.724205 2314 UserTrace BIP4067I: Message propagated to output terminal for trace node 'FL_F_MCHE.Trace2'.
The trace node 'FL_F_MCHE.Trace2' has received a message and is propagating it to any nodes connected to its output terminal.
No user action required.
2005-11-17 10:10:55.767635 2314 UserTrace BIP2638I: The MQ output node 'FL_F_MCHE.MQOutput1' attempted to write a message to the specified queue 'Q_REBUT' connected to queue manager ''. The MQCC was 0 and the MQRC was 0.
2005-11-17 10:10:55.767738 2314 UserTrace BIP2622I: Message successfully output by MQ output node 'FL_F_MCHE.MQOutput1' to queue 'Q_REBUT' on queue manager ''.
Threads encountered in this trace:
2314 2571
|
The trace before and during the processing of the compute node of the F_RB flow :
| Quote: |
***Root :9:59
(
(0x1000000)Properties = (
(0x3000000)MessageSet = ''
(0x3000000)MessageType = ''
(0x3000000)MessageFormat = ''
(0x3000000)Encoding = 273
(0x3000000)CodedCharSetId = 819
(0x3000000)Transactional = TRUE
(0x3000000)Persistence = TRUE
(0x3000000)CreationTime = GMTTIMESTAMP '2005-11-17 08:58:20.820'
(0x3000000)ExpirationTime = -1
(0x3000000)Priority = 4
(0x3000000)ReplyIdentifier = X'000000000000000000000000000000000000000000000000'
(0x3000000)ReplyProtocol = 'MQ'
(0x3000000)Topic = NULL
)
(0x1000000)MQMD = (
(0x3000000)SourceQueue = 'Q_NABU.F_RB'
(0x3000000)Transactional = TRUE
(0x3000000)Encoding = 273
(0x3000000)CodedCharSetId = 819
(0x3000000)Format = 'MQSTR '
(0x3000000)Version = 2
(0x3000000)Report = 0
(0x3000000)MsgType = 8
(0x3000000)Expiry = -1
(0x3000000)Feedback = 0
(0x3000000)Priority = 4
(0x3000000)Persistence = 1
(0x3000000)MsgId = X'414d5120514d5f4541495f315f494e5443706dc9002cd013'
(0x3000000)CorrelId = X'000000000000000000000000000000000000000000000000'
(0x3000000)BackoutCount = 0
(0x3000000)ReplyToQ = ' '
(0x3000000)ReplyToQMgr = 'QM_EAI_1_INTEVO '
(0x3000000)UserIdentifier = 'mqmie '
(0x3000000)AccountingToken = X'0332303800000000000000000000000000000000000000000000000000000006'
(0x3000000)ApplIdentityData = ' '
(0x3000000)PutApplType = 28
(0x3000000)PutApplName = 'MQSeries Client for Java '
(0x3000000)PutDate = DATE '2005-11-17'
(0x3000000)PutTime = GMTTIME '08:58:20.820'
(0x3000000)ApplOriginData = ' '
(0x3000000)GroupId = X'000000000000000000000000000000000000000000000000'
(0x3000000)MsgSeqNumber = 1
(0x3000000)Offset = 0
(0x3000000)MsgFlags = 0
(0x3000000)OriginalLength = -1
)
(0x1000010)XML = (
(0x1000000)Siprog = (
(0x1000000)MsgEntry = (
(0x1000000)Header = (
... etc etc
)
)
(0x1000000)Content = (
... etc etc
)
)
)
)
)
2005-11-17 09:59:28.529703 1800 UserTrace BIP2537I: Node 'FL_F_RB.If_DB_OPX2_2': Executing statement 'RETURN Body.Siprog.MsgEntry.Header.DatabaseStatut.DSN_OPX2 = 1;' at (1, 1).
2005-11-17 09:59:28.529796 1800 UserTrace BIP2538I: Node 'FL_F_RB.If_DB_OPX2_2': Evaluating expression 'Body.Siprog.MsgEntry.Header.DatabaseStatut.DSN_OPX2 = 1' at (1, 53).
2005-11-17 09:59:28.529897 1800 UserTrace BIP2538I: Node 'FL_F_RB.If_DB_OPX2_2': Evaluating expression 'Body.Siprog.MsgEntry.Header.DatabaseStatut.DSN_OPX2' at (1, 1).
2005-11-17 09:59:28.530035 1800 UserTrace BIP2539I: Node 'FL_F_RB.If_DB_OPX2_2': Finished evaluating expression 'Body.Siprog.MsgEntry.Header.DatabaseStatut.DSN_OPX2 = 1' at (1, 53). This resolved to ''1' = 1'. The result was 'TRUE'.
2005-11-17 09:59:28.530199 1800 UserTrace BIP4004I: Message propagated to 'true' terminal of filter node 'FL_F_RB.If_DB_OPX2_2'.
2005-11-17 09:59:28.530376 1800 UserTrace BIP2538I: Node 'FL_F_RB.Trace1': Evaluating expression 'EXTRACT(HOUR FROM CURRENT_TIMESTAMP)' at (1, 12).
2005-11-17 09:59:28.530469 1800 UserTrace BIP2538I: Node 'FL_F_RB.Trace1': Evaluating expression 'CURRENT_TIMESTAMP' at (1, 30).
2005-11-17 09:59:28.530637 1800 UserTrace BIP2540I: Node 'FL_F_RB.Trace1': Finished evaluating expression 'CURRENT_TIMESTAMP' at (1, 30). The result was 'TIMESTAMP '2005-11-17 09:59:28.530263''.
2005-11-17 09:59:28.530767 1800 UserTrace BIP2539I: Node 'FL_F_RB.Trace1': Finished evaluating expression 'EXTRACT(HOUR FROM CURRENT_TIMESTAMP)' at (1, 12). This resolved to 'EXTRACT(HOUR FROM TIMESTAMP '2005-11-17 09:59:28.530263')'. The result was '9'.
2005-11-17 09:59:28.530870 1800 UserTrace BIP2538I: Node 'FL_F_RB.Trace1': Evaluating expression 'EXTRACT(MINUTE FROM CURRENT_TIMESTAMP)' at (1, 52).
2005-11-17 09:59:28.530956 1800 UserTrace BIP2538I: Node 'FL_F_RB.Trace1': Evaluating expression 'CURRENT_TIMESTAMP' at (1, 72).
2005-11-17 09:59:28.531068 1800 UserTrace BIP2540I: Node 'FL_F_RB.Trace1': Finished evaluating expression 'CURRENT_TIMESTAMP' at (1, 72). The result was 'TIMESTAMP '2005-11-17 09:59:28.530263''.
2005-11-17 09:59:28.531192 1800 UserTrace BIP2539I: Node 'FL_F_RB.Trace1': Finished evaluating expression 'EXTRACT(MINUTE FROM CURRENT_TIMESTAMP)' at (1, 52). This resolved to 'EXTRACT(MINUTE FROM TIMESTAMP '2005-11-17 09:59:28.530263')'. The result was '59'.
2005-11-17 09:59:28.531330 1800 UserTrace BIP2538I: Node 'FL_F_RB.Trace1': Evaluating expression 'Root' at (2, 3).
2005-11-17 09:59:28.534519 1800 UserTrace BIP4067I: Message propagated to output terminal for trace node 'FL_F_RB.Trace1'.
The trace node 'FL_F_RB.Trace1' has received a message and is propagating it to any nodes connected to its output terminal.
No user action required.
2005-11-17 09:59:28.534732 1800 UserTrace BIP2537I: Node 'FL_F_RB.C_PS_EAI_OPX2_2': Executing statement 'SET OutputRoot = InputRoot;' at (1, 1).
2005-11-17 09:59:28.534830 1800 UserTrace BIP2538I: Node 'FL_F_RB.C_PS_EAI_OPX2_2': Evaluating expression 'InputRoot' at (1, 1.
2005-11-17 09:59:28.534925 1800 UserTrace BIP2568I: Node 'FL_F_RB.C_PS_EAI_OPX2_2': Performing tree copy of '' to 'OutputRoot'.
2005-11-17 09:59:28.535419 1800 UserTrace BIP2537I: Node 'FL_F_RB.C_PS_EAI_OPX2_2': Executing statement 'DECLARE extrait BLOB;' at (4, 1).
2005-11-17 09:59:28.535518 1800 UserTrace BIP2537I: Node 'FL_F_RB.C_PS_EAI_OPX2_2': Executing statement 'DECLARE chaine CHARACTER;' at (5, 1).
2005-11-17 09:59:28.535610 1800 UserTrace BIP2537I: Node 'FL_F_RB.C_PS_EAI_OPX2_2': Executing statement 'SET extrait = BITSTREAM(InputBody);' at (6, 1).
2005-11-17 09:59:28.535705 1800 UserTrace BIP2538I: Node 'FL_F_RB.C_PS_EAI_OPX2_2': Evaluating expression 'BITSTREAM(InputBody)' at (6, 15).
2005-11-17 09:59:28.535816 1800 UserTrace BIP2540I: Node 'FL_F_RB.C_PS_EAI_OPX2_2': Finished evaluating expression 'BITSTREAM(InputBody)' at (6, 15). The result was 'X'''.
2005-11-17 09:59:28.535991 1800 UserTrace BIP2537I: Node 'FL_F_RB.C_PS_EAI_OPX2_2': Executing statement 'SET chaine = CAST(extrait AS CHARACTER CCSID InputRoot.MQMD.CodedCharSetId);' at (11, 1).
2005-11-17 09:59:28.536092 1800 UserTrace BIP2538I: Node 'FL_F_RB.C_PS_EAI_OPX2_2': Evaluating expression 'CAST(extrait AS CHARACTER CCSID InputRoot.MQMD.CodedCharSetId)' at (11, 14).
2005-11-17 09:59:28.536186 1800 UserTrace BIP2538I: Node 'FL_F_RB.C_PS_EAI_OPX2_2': Evaluating expression 'extrait' at (11, 20).
2005-11-17 09:59:28.536283 1800 UserTrace BIP2538I: Node 'FL_F_RB.C_PS_EAI_OPX2_2': Evaluating expression 'InputRoot.MQMD.CodedCharSetId' at (11, 47).
2005-11-17 09:59:28.536439 1800 UserTrace BIP2539I: Node 'FL_F_RB.C_PS_EAI_OPX2_2': Finished evaluating expression 'CAST(extrait AS CHARACTER CCSID InputRoot.MQMD.CodedCharSetId)' at (11, 14). This resolved to 'CAST(X'' AS CHARACTER CCSID 819 )'. The result was ''''.
2005-11-17 09:59:28.536544 1800 UserTrace BIP2537I: Node 'FL_F_RB.C_PS_EAI_OPX2_2': Executing statement 'DECLARE nPosition1 INTEGER;' at (14, 1).
2005-11-17 09:59:28.536634 1800 UserTrace BIP2537I: Node 'FL_F_RB.C_PS_EAI_OPX2_2': Executing statement 'DECLARE nPosition2 INTEGER;' at (15, 1).
2005-11-17 09:59:28.536724 1800 UserTrace BIP2537I: Node 'FL_F_RB.C_PS_EAI_OPX2_2': Executing statement 'DECLARE nPosition3 INTEGER;' at (16, 1).
2005-11-17 09:59:28.536813 1800 UserTrace BIP2537I: Node 'FL_F_RB.C_PS_EAI_OPX2_2': Executing statement 'SET nPosition1 = POSITION('<Content>' IN chaine);' at (17, 1).
2005-11-17 09:59:28.536937 1800 UserTrace BIP2538I: Node 'FL_F_RB.C_PS_EAI_OPX2_2': Evaluating expression 'POSITION('<Content>' IN chaine)' at (17, 1.
2005-11-17 09:59:28.537040 1800 UserTrace BIP2538I: Node 'FL_F_RB.C_PS_EAI_OPX2_2': Evaluating expression 'chaine' at (17, 42).
2005-11-17 09:59:28.537164 1800 UserTrace BIP2539I: Node 'FL_F_RB.C_PS_EAI_OPX2_2': Finished evaluating expression 'POSITION('<Content>' IN chaine)' at (17, 1. This resolved to 'POSITION('<Content>' IN '')'. The result was '0'.
2005-11-17 09:59:28.537261 1800 UserTrace BIP2537I: Node 'FL_F_RB.C_PS_EAI_OPX2_2': Executing statement 'SET nPosition2 = POSITION('</Content>' IN chaine);' at (18, 1).
2005-11-17 09:59:28.537353 1800 UserTrace BIP2538I: Node 'FL_F_RB.C_PS_EAI_OPX2_2': Evaluating expression 'POSITION('</Content>' IN chaine)' at (18, 1.
2005-11-17 09:59:28.537450 1800 UserTrace BIP2538I: Node 'FL_F_RB.C_PS_EAI_OPX2_2': Evaluating expression 'chaine' at (18, 43).
2005-11-17 09:59:28.537561 1800 UserTrace BIP2539I: Node 'FL_F_RB.C_PS_EAI_OPX2_2': Finished evaluating expression 'POSITION('</Content>' IN chaine)' at (18, 1. This resolved to 'POSITION('</Content>' IN '')'. The result was '0'.
2005-11-17 09:59:28.537658 1800 UserTrace BIP2537I: Node 'FL_F_RB.C_PS_EAI_OPX2_2': Executing statement 'SET nPosition3 = nPosition2 - 9 - nPosition1;' at (19, 1).
2005-11-17 09:59:28.537752 1800 UserTrace BIP2538I: Node 'FL_F_RB.C_PS_EAI_OPX2_2': Evaluating expression 'nPosition2 - 9 - nPosition1' at (19, 34).
2005-11-17 09:59:28.537872 1800 UserTrace BIP2538I: Node 'FL_F_RB.C_PS_EAI_OPX2_2': Evaluating expression 'nPosition2 - 9' at (19, 30).
2005-11-17 09:59:28.537961 1800 UserTrace BIP2538I: Node 'FL_F_RB.C_PS_EAI_OPX2_2': Evaluating expression 'nPosition2' at (19, 19).
2005-11-17 09:59:28.538080 1800 UserTrace BIP2539I: Node 'FL_F_RB.C_PS_EAI_OPX2_2': Finished evaluating expression 'nPosition2 - 9' at (19, 30). This resolved to '0 - 9'. The result was '-9'.
2005-11-17 09:59:28.538175 1800 UserTrace BIP2538I: Node 'FL_F_RB.C_PS_EAI_OPX2_2': Evaluating expression 'nPosition1' at (19, 36).
2005-11-17 09:59:28.538280 1800 UserTrace BIP2539I: Node 'FL_F_RB.C_PS_EAI_OPX2_2': Finished evaluating expression 'nPosition2 - 9 - nPosition1' at (19, 34). This resolved to '-9 - 0'. The result was '-9'.
2005-11-17 09:59:28.538375 1800 UserTrace BIP2537I: Node 'FL_F_RB.C_PS_EAI_OPX2_2': Executing statement 'DECLARE sContent CHARACTER;' at (21, 1).
2005-11-17 09:59:28.538467 1800 UserTrace BIP2537I: Node 'FL_F_RB.C_PS_EAI_OPX2_2': Executing statement 'SET sContent = SUBSTRING(chaine FROM nPosition1 + 9 FOR nPosition3);' at (22, 1).
2005-11-17 09:59:28.538558 1800 UserTrace BIP2538I: Node 'FL_F_RB.C_PS_EAI_OPX2_2': Evaluating expression 'SUBSTRING(chaine FROM nPosition1 + 9 FOR nPosition3)' at (22, 16).
2005-11-17 09:59:28.538702 1800 UserTrace BIP2538I: Node 'FL_F_RB.C_PS_EAI_OPX2_2': Evaluating expression 'chaine' at (22, 27).
2005-11-17 09:59:28.538799 1800 UserTrace BIP2538I: Node 'FL_F_RB.C_PS_EAI_OPX2_2': Evaluating expression 'nPosition1 + 9' at (22, 49).
2005-11-17 09:59:28.538921 1800 UserTrace BIP2538I: Node 'FL_F_RB.C_PS_EAI_OPX2_2': Evaluating expression 'nPosition1' at (22, 39).
2005-11-17 09:59:28.539031 1800 UserTrace BIP2539I: Node 'FL_F_RB.C_PS_EAI_OPX2_2': Finished evaluating expression 'nPosition1 + 9' at (22, 49). This resolved to '0 + 9'. The result was '9'.
2005-11-17 09:59:28.539129 1800 UserTrace BIP2538I: Node 'FL_F_RB.C_PS_EAI_OPX2_2': Evaluating expression 'nPosition3' at (22, 56).
2005-11-17 09:59:28.539930 1800 UserTrace BIP4081I: Message propagated to catch terminal from try-catch node 'FL_F_RB.TryCatch'.
The try-catch node 'FL_F_RB.TryCatch' has caught an exception which occurred in a node connected to its try terminal. The message has been augmented with an exception list and is propagating it to any nodes connected to its catch terminal for further processing. See the following messages for details of the exception list.
No user action required.
2005-11-17 09:59:28.539962 1800 RecoverableException BIP2230E: Error detected whilst processing a message in node 'FL_F_RB.C_PS_EAI_OPX2_2'.
The message broker detected an error whilst processing a message in node 'FL_F_RB.C_PS_EAI_OPX2_2'. An exception has been thrown to cut short the processing of the message.
See the following messages for details of the error.
2005-11-17 09:59:28.539987 1800 RecoverableException BIP2499E: (22, 16) : Illegal arguments to SUBSTRING function called as 'SUBSTRING('' FROM 9 FOR -9)'.
Valid syntax for SUBSTRING is: SUBSTRING( source_string FROM start_position [FOR string_length]). The function was called as 'SUBSTRING('' FROM 9 FOR -9)'.
Correct the syntax of the expression and redeploy the message flow.
2005-11-17 09:59:28.540205 1800 UserTrace BIP2537I: Node 'FL_F_RB.C_Err': Executing statement 'SET OutputRoot = InputRoot;' at (1, 1).
|
Both Traces before the compute node seems to be identique. But the executions traces show that the compute node from F_RB can't manage to parse the message where as the F_MCHE does. |
|
| Back to top |
|
|
|
|
|
|
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
|
|
|
|
