| Author |
Message
|
| ARAMARK |
 Posted: Tue Sep 25, 2007 6:11 am Post subject: WBIMB Event Log-Error |
 |
|
Novice
Joined: 07 Sep 2007
Posts: 14
|
I am getting the follwoing error while the message flow is deployed:
Syntax error in SQL statements in node 'RetrieveDataFromDatabaseFlow.Compute'.
The configuration failed due to errors in the SQL statement text. See the following messages for details of the error
The following error messages will give specific details of the location and nature of the error. Check and correct the syntax of the SQL statements and redeploy.
.RetrieveDataFromDatabaseFlow_Compute.CopyEntireMessage, 2.7) : Illegal data type for target. A list field reference is required.
The expression supplying the target must evaluate to a value of a suitable type. The given expression cannot possibly do so.
Correct the logic of the ESQL program and re-deploy the message flow.
The ESQL code in Comput Node is as follows:
CREATE COMPUTE MODULE RetrieveDataFromDatabaseFlow_Compute
CREATE FUNCTION Main() RETURNS BOOLEAN
BEGIN
-- CALL CopyMessageHeaders();
CALL CopyEntireMessage();
RETURN TRUE;
END;
CREATE PROCEDURE CopyMessageHeaders() BEGIN
DECLARE I INTEGER;
DECLARE J INTEGER;
SET I = 1;
SET J = CARDINALITY(InputRoot.*[]);
WHILE I < J DO
SET OutputRoot.*[I] = InputRoot.*[I];
SET I = I + 1;
END WHILE;
END;
CREATE PROCEDURE CopyEntireMessage() BEGIN
SET OutputRoot = (SELECT T.EMPID, T.NAME, T.DESIGNATION FROM Database.Test.INFO AS T);
END;
END MODULE;
Please advice where I went wrong..... |
|
| Back to top |
|
 |
| Vitor |
| Posted: Tue Sep 25, 2007 6:14 am Post subject: Re: WBIMB Event Log-Error |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| ARAMARK wrote: |
CREATE PROCEDURE CopyEntireMessage() BEGIN
SET OutputRoot = (SELECT T.EMPID, T.NAME, T.DESIGNATION FROM Database.Test.INFO AS T);
END;
END MODULE;
Please advice where I went wrong..... |
Firstly, don't put code in CopyEntireMessage. Secondly, what are you trying to achieve with that ESQL? Thirdly, which part of the ESQL documentation has led you to this statement as the best implementation of your requirement?
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Tue Sep 25, 2007 6:33 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Please get training on WMB.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| ARAMARK |
| Posted: Tue Sep 25, 2007 11:54 pm Post subject: EventLog-Error |
|
|
Novice
Joined: 07 Sep 2007
Posts: 14
|
| Can you please tell me what is the process to take training on WBIMB?and what is the cost and duration? |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed Sep 26, 2007 12:02 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
http://www.ibm.com/products/finder/us/finders?pg=trfinder
Other training providers are available, this link should not be seen as an endorsement, no warrenty express or implied is accepted for any loss or damage resulting from the use of this link, etc, etc, etc.
IMHO your training should be guided by the objective of obtaining product certification, i.e.
http://www-03.ibm.com/certify/
Please see disclaimer above.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| ARAMARK |
| Posted: Wed Sep 26, 2007 2:52 am Post subject: Database Error in WBIMB. |
|
|
Novice
Joined: 07 Sep 2007
Posts: 14
|
Thanks for the advice,I corrected my ESQL code but after the deplyment of the message flow,I am getting the following error during runtime in the syslog of the Linux server.
Sep 26 06:45:40 wgcwebsphere04 WebSphere Broker v6000[29269]: (AUS_BRK06.RetrieveData)[475156]BIP4623E: Exception condition detected: object label 'RetrieveDataFromDatabaseFlow.TimeoutNotification'; input node '{1}'. : AUS_BRK06.59909af1-1401-0000-0080-c9752e0d1b31: /build/S000_P/src/DataFlowEngine/TimeoutControl/ImbTimeoutNotificationNode.cpp: 1272: ImbTimeoutNotificationNode::propagateToCatch: ComIbmTimeoutNotificationNode: RetrieveDataFromDatabaseFlow#FCMComposite_1_1
Sep 26 06:45:40 wgcwebsphere04 WebSphere Broker v6000[29269]: (AUS_BRK06.RetrieveData)[475156]BIP2230E: Error detected whilst processing a message in node 'RetrieveDataFromDatabaseFlow.Compute'. : AUS_BRK06.59909af1-1401-0000-0080-c9752e0d1b31: /build/S000_P/src/DataFlowEngine/ImbComputeNode.cpp: 464: ImbComputeNode::evaluate: ComIbmComputeNode: RetrieveDataFromDatabaseFlow#FCMComposite_1_2
Sep 26 06:45:40 wgcwebsphere04 WebSphere Broker v6000[29269]: (AUS_BRK06.RetrieveData)[475156]BIP2321E: Database error: ODBC return code '-1'. : AUS_BRK06.59909af1-1401-0000-0080-c9752e0d1b31: /build/S000_P/src/DataFlowEngine/ImbOdbc.cpp: 232: ImbOdbcHandle::checkRcInner: :
Sep 26 06:45:40 wgcwebsphere04 WebSphere Broker v6000[29269]: (AUS_BRK06.RetrieveData)[475156]BIP2322E: Database error: SQL State '78'; Native Error Code '0'; Error Text '523 76'. : AUS_BRK06.59909af1-1401-0000-0080-c9752e0d1b31: /build/S000_P/src/DataFlowEngine/ImbOdbc.cpp: 360: ImbOdbcHandle::checkRcInner: :
Please advice ...... |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed Sep 26, 2007 2:57 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
Looks a lot like there's a runtime error in your flow.
I'd use the debugger and / or the trace to locate it.
I'd also make sure your datasource is defined correctly. In fact I'd look at that first.
And see when the first available training course is. Or the fun's going to go out of your life surprisingly quickly.......
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
|
|
