| Author |
Message
|
| SphereOfLove |
 Posted: Tue May 13, 2014 4:51 am Post subject: Integration Bus , Computer node |
 |
|
Apprentice
Joined: 13 May 2014
Posts: 38
|
ExceptionList
======2014-05-13 08:26:34.273428========
( ['MQROOT' : 0x4f3669a0]
(0x01000000:Name):RecoverableException = (
(0x03000000:NameValue):File = 'F:\build\slot1\S000_P\src\DataFlowEngine\MessageServices\ImbDataFlowNode.cpp' (CHARACTER)
(0x03000000:NameValue):Line = 1153 (INTEGER)
(0x03000000:NameValue):Function = 'ImbDataFlowNode::createExceptionList' (CHARACTER)
(0x03000000:NameValue):Type = 'ComIbmComputeNode' (CHARACTER)
(0x03000000:NameValue):Name = 'MyFlow#FCMComposite_1_11' (CHARACTER)
(0x03000000:NameValue):Label = 'MyFlow.Compute1' (CHARACTER)
(0x03000000:NameValue):Catalog = 'BIPmsgs' (CHARACTER)
(0x03000000:NameValue):Severity = 3 (INTEGER)
(0x03000000:NameValue):Number = 2230 (INTEGER)
(0x03000000:NameValue):Text = 'Node throwing exception' (CHARACTER)
(0x01000000:Name ):RecoverableException = (
(0x03000000:NameValue):File = 'F:\build\slot1\S000_P\src\DataFlowEngine\ImbRdl\ImbRdlStatementGroup.cpp' (CHARACTER)
(0x03000000:NameValue):Line = 666 (INTEGER)
(0x03000000:NameValue):Function = 'SqlStatementGroup::execute' (CHARACTER)
(0x03000000:NameValue):Type = '' (CHARACTER)
(0x03000000:NameValue):Name = '' (CHARACTER)
(0x03000000:NameValue):Label = '' (CHARACTER)
(0x03000000:NameValue):Catalog = 'BIPmsgs' (CHARACTER)
(0x03000000:NameValue):Severity = 3 (INTEGER)
(0x03000000:NameValue):Number = 2488 (INTEGER)
(0x03000000:NameValue):Text = 'Error detected, rethrowing' (CHARACTER)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = '.MyFlow_Compute2.Main' (CHARACTER)
)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = '14.5' (CHARACTER)
)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = 'SET OutputRoot.XMLNSC.Body.records[I].TRANSM_NO = InputRoot.XMLNSC.Body.records[I].TRANSM_NO;' (CHARACTER)
)
(0x01000000:Name ):RecoverableException = (
(0x03000000:NameValue):File = 'F:\build\slot1\S000_P\src\DataFlowEngine\ImbRdl\ImbRdlFieldRef.cpp' (CHARACTER)
(0x03000000:NameValue):Line = 2175 (INTEGER)
(0x03000000:NameValue):Function = 'SqlFieldReference::navigateAbsoluteToParentOfFirst' (CHARACTER)
(0x03000000:NameValue):Type = '' (CHARACTER)
(0x03000000:NameValue):Name = '' (CHARACTER)
(0x03000000:NameValue):Label = '' (CHARACTER)
(0x03000000:NameValue):Catalog = 'BIPmsgs' (CHARACTER)
(0x03000000:NameValue):Severity = 3 (INTEGER)
(0x03000000:NameValue):Number = 2498 (INTEGER)
(0x03000000:NameValue):Text = 'Navigation error' (CHARACTER)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = '.MyFlow_Compute2.Main' (CHARACTER)
)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = '14.9' (CHARACTER)
)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 2 (INTEGER)
(0x03000000:NameValue):Text = '4' (CHARACTER)
)
(0x01000000:Name ):RecoverableException = (
(0x03000000:NameValue):File = 'F:\build\slot1\S000_P\src\DataFlowEngine\ImbRdl\ImbRdlFieldRef.cpp' (CHARACTER)
(0x03000000:NameValue):Line = 1048 (INTEGER)
(0x03000000:NameValue):Function = 'SqlPathElement::navigateCursorFirst' (CHARACTER)
(0x03000000:NameValue):Type = '' (CHARACTER)
(0x03000000:NameValue):Name = '' (CHARACTER)
(0x03000000:NameValue):Label = '' (CHARACTER)
(0x03000000:NameValue):Catalog = 'BIPmsgs' (CHARACTER)
(0x03000000:NameValue):Severity = 3 (INTEGER)
(0x03000000:NameValue):Number = 2436 (INTEGER)
(0x03000000:NameValue):Text = 'Array subscript error' (CHARACTER)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 2 (INTEGER)
(0x03000000:NameValue):Text = '2' (CHARACTER)
)
)
)
)
)
)
( ['xmlnsc' : 0x53bb53b0]
(0x01000000:Folder):Body = (
(0x01000000:Folder):records = (
(0x03000000:PCDataField):TRANSM_NO = '1009' (CHARACTER)
)
(0x01000000:Folder):records = (
(0x03000000:PCDataField):TRANSM_NO = '1008' (CHARACTER)
)
(0x01000000:Folder):records = (
(0x03000000:PCDataField):TRANSM_NO = '1010' (CHARACTER)
)
)
)
------
I am trying to pick up a list retained in an XML file using fileInput Node, and using computer node to propagate one item at a time to be inserted in a table. The Computer node is throwing the above mentioned exception and just processes only first record from the list.
Please advise!
CODE
CREATE FUNCTION Main() RETURNS BOOLEAN
BEGIN
-- CALL CopyEntireMessage();
DECLARE ListCount Integer;
DECLARE I integer 1;
SET ListCount = CARDINALITY(InputRoot.XMLNSC.Body.*[]);
WHILE I <= ListCount DO
CALL CopyMessageHeaders();
SET OutputRoot.XMLNSC.Body.records[I].TRANSM_NO = InputRoot.XMLNSC.Body.records[I].TRANSM_NO;
PROPAGATE;
SET I = I + 1;
END WHILE;
RETURN FALSE;
-- RETURN TRUE;
END; |
|
| Back to top |
|
 |
| smdavies99 |
| Posted: Tue May 13, 2014 5:05 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
There is a problem on the output side of this line
| Code: |
SET OutputRoot.XMLNSC.Body.records[I].TRANSM_NO = InputRoot.XMLNSC.Body.records[I].TRANSM_NO;
|
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| SphereOfLove |
| Posted: Tue May 13, 2014 5:20 am Post subject: |
|
|
Apprentice
Joined: 13 May 2014
Posts: 38
|
May be i am not getting the point, or may need further advice
If I remove the Propagate statement and change return false to return true.
It gives me all the list data, but i can not send a complete list to invoke a web service which takes one record at a time.
What should i do? |
|
| Back to top |
|
|
| Esa |
| Posted: Tue May 13, 2014 5:44 am Post subject: |
|
|
Grand Master
Joined: 22 May 2008
Posts: 1387
Location: Finland
|
| Hint: OutputRoot.XMLNSC.Body will have only one 'record'... |
|
| Back to top |
|
|
| SphereOfLove |
| Posted: Tue May 13, 2014 5:58 am Post subject: |
|
|
Apprentice
Joined: 13 May 2014
Posts: 38
|
| Esa wrote: |
| Hint: OutputRoot.XMLNSC.Body will have only one 'record'... |
That is true, if i use propagate statement, the OutputRoot.XMLNSC.Body should propagate one record at a time and then execute all the following nodes and then should come back to process next record.
But it only produces one record and then throws the exception i posted earlier. |
|
| Back to top |
|
|
| Esa |
| Posted: Tue May 13, 2014 6:02 am Post subject: |
|
|
Grand Master
Joined: 22 May 2008
Posts: 1387
Location: Finland
|
| SphereOfLove wrote: |
But it only produces one record and then throws the exception i posted earlier. |
No, it fails to produce the record because of the error in your code... |
|
| Back to top |
|
|
| SphereOfLove |
| Posted: Tue May 13, 2014 6:32 am Post subject: |
|
|
Apprentice
Joined: 13 May 2014
Posts: 38
|
| Esa wrote: |
| SphereOfLove wrote: |
But it only produces one record and then throws the exception i posted earlier. |
No, it fails to produce the record because of the error in your code... |
Thank you Guys,
I have corrected the code
| Code: |
WHILE I <= ListCount DO
CALL CopyMessageHeaders();
SET OutputRoot.XMLNSC.Body.records.TRANSM_NO = InputRoot.XMLNSC.Body.records[I].TRANSM_NO;
SET I = I + 1;
PROPAGATE;
END WHILE;
RETURN FALSE; |
|
|
| Back to top |
|
|
| smdavies99 |
| Posted: Tue May 13, 2014 6:32 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
| Esa wrote: |
| SphereOfLove wrote: |
But it only produces one record and then throws the exception i posted earlier. |
No, it fails to produce the record because of the error in your code... |
As is indicated in my reply but has totally been ignored.  
Opps. Two edits with the same timestamp. Looks like problem solved.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| Esa |
| Posted: Tue May 13, 2014 6:48 am Post subject: |
|
|
Grand Master
Joined: 22 May 2008
Posts: 1387
Location: Finland
|
| smdavies99 wrote: |
As is indicated in my reply but has totally been ignored.
|
Far from ignored but extended with further going tease |
|
| Back to top |
|
|
| SphereOfLove |
| Posted: Tue May 13, 2014 7:58 am Post subject: |
|
|
Apprentice
Joined: 13 May 2014
Posts: 38
|
| Esa wrote: |
| smdavies99 wrote: |
As is indicated in my reply but has totally been ignored.
|
Far from ignored but extended with further going tease |
Thank you!
You were right too.. Thank you again.. |
|
| Back to top |
|
|
|
|
