| Author |
Message
|
| arramna |
 Posted: Thu Jan 27, 2011 9:54 am Post subject: Exception in ESQL of Airline Reservation sample |
 |
|
Newbie
Joined: 17 Jul 2010
Posts: 4
|
HI,
I am newbie to WMB...
I am working with the Airline Reservation sample from WMB v6.1 .
In XML_Reservation flow while testing every message is getting into XML_RESERVATION_FAIL queue.
While debugging I found the following statement fails....How to find the exact reason for failure ?
-- populate the environment with flight info from the database
SET Environment.Variables =
THE (SELECT T.* FROM Database.XMLFLIGHTTB AS T
WHERE T.FLIGHTDATE = Root.XMLNSC.Reservation.FlightDetails.FlightDate
AND T.FLIGHTNO = Root.XMLNSC.Reservation.FlightDetails.FlightNumber);
Thanks a lot.
ramz |
|
| Back to top |
|
 |
| Vitor |
| Posted: Thu Jan 27, 2011 9:59 am Post subject: Re: Exception in ESQL of Airline Reservation sample |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| arramna wrote: |
| While debugging I found the following statement fails....How to find the exact reason for failure ? |
Old advice but good advice - take a user trace. Much more information than the debugger.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| arramna |
| Posted: Thu Jan 27, 2011 10:31 am Post subject: Re: Exception in ESQL of Airline Reservation sample |
|
|
Newbie
Joined: 17 Jul 2010
Posts: 4
|
| Quote: |
| Old advice but good advice - take a user trace. Much more information than the debugger. |
Following is the trace: I feel something is wrong with "DB2ADMIN.XMLFLIGHTTB" is an undefined name. SQLSTATE=42704
for the below trace..
How to fix this ?
- <Error timestamp="2011-01-27 18:09:53.929260" thread="3568" function="ImbTraceNode::writeToLog" type="ComIbmTraceNode" name="XML_Reservation#FCMComposite_1_10" label="XML_Reservation.LogException" text="'Application error output from TraceNode'" catalog="BIPv610" number="3052" file="F:\build\S610_P\src\DataFlowEngine\ImbTraceNode.cpp" line="477">
<Insert type="string">'Date is: 1/ 27/ 2011 Time is: 23: 39 Environment is: Exception List is: ( ['MQROOT' : 0x5d47e88] (0x01000000):RecoverableException = ( (0x03000000):File = 'F:\build\S610_P\src\DataFlowEngine\ImbDatabaseNode.cpp' (CHARACTER) (0x03000000):Line = 295 (INTEGER) (0x03000000):Function = 'ImbDatabaseNode::evaluate' (CHARACTER) (0x03000000):Type = 'ComIbmDatabaseNode' (CHARACTER) (0x03000000):Name = 'XML_Reservation#FCMComposite_1_2' (CHARACTER) (0x03000000):Label = 'XML_Reservation.UpdateFlightTable' (CHARACTER) (0x03000000):Catalog = 'BIPv610' (CHARACTER) (0x03000000):Severity = 3 (INTEGER) (0x03000000):Number = 2230 (INTEGER) (0x03000000):Text = 'Caught exception and rethrowing' (CHARACTER) (0x01000000):RecoverableException = ( (0x03000000):File = 'F:\build\S610_P\src\DataFlowEngine\ImbRdl\ImbRdlStatementGroup.cpp' (CHARACTER) (0x03000000):Line = 586 (INTEGER) (0x03000000):Function = 'SqlStatementGroup::execute' (CHARACTER) (0x03000000):Type = 'ComIbmDatabaseNode' (CHARACTER) (0x03000000):Name = 'XML_Reservation#FCMComposite_1_2' (CHARACTER) (0x03000000):Label = 'XML_Reservation.UpdateFlightTable' (CHARACTER) (0x03000000):Catalog = 'BIPv610' (CHARACTER) (0x03000000):Severity = 3 (INTEGER) (0x03000000):Number = 2488 (INTEGER) (0x03000000):Text = 'Error detected, rethrowing' (CHARACTER) (0x01000000):Insert = ( (0x03000000):Type = 5 (INTEGER) (0x03000000):Text = '.UpdateFlightTable.Main' (CHARACTER) ) (0x01000000):Insert = ( (0x03000000):Type = 5 (INTEGER) (0x03000000):Text = '4.3' (CHARACTER) ) (0x01000000):Insert = ( (0x03000000):Type = 5 (INTEGER) (0x03000000):Text = 'SET Environment.Variables = THE (SELECT ROW () FROM DATABASE(, Root.XMLNSC.Reservation.FlightDetails.FlightDate, Root.XMLNSC.Reservation.FlightDetails.FlightNumber));' (CHARACTER) ) (0x01000000):DatabaseException = ( (0x03000000):File = 'F:\build\S610_P\src\DataFlowEngine\ImbOdbc.cpp' (CHARACTER) (0x03000000):Line = 327 (INTEGER) (0x03000000):Function = 'ImbOdbcHandle::checkRcInner' (CHARACTER) (0x03000000):Type = '' (CHARACTER) (0x03000000):Name = '' (CHARACTER) (0x03000000):Label = '' (CHARACTER) (0x03000000):Catalog = 'BIPv610' (CHARACTER) (0x03000000):Severity = 3 (INTEGER) (0x03000000):Number = 2321 (INTEGER) (0x03000000):Text = 'Root SQL exception' (CHARACTER) (0x01000000):Insert = ( (0x03000000):Type = 2 (INTEGER) (0x03000000):Text = '-1' (CHARACTER) ) (0x01000000):DatabaseException = ( (0x03000000):File = 'F:\build\S610_P\src\DataFlowEngine\ImbOdbc.cpp' (CHARACTER) (0x03000000):Line = 456 (INTEGER) (0x03000000):Function = 'ImbOdbcHandle::checkRcInner' (CHARACTER) (0x03000000):Type = '' (CHARACTER) (0x03000000):Name = '' (CHARACTER) (0x03000000):Label = '' (CHARACTER) (0x03000000):Catalog = 'BIPv610' (CHARACTER) (0x03000000):Severity = 3 (INTEGER) (0x03000000):Number = 2322 (INTEGER) (0x03000000):Text = 'Child SQL exception' (CHARACTER) (0x01000000):Insert = ( (0x03000000):Type = 5 (INTEGER) (0x03000000):Text = '42S02' (CHARACTER) ) (0x01000000):Insert = ( (0x03000000):Type = 2 (INTEGER) (0x03000000):Text = '-204' (CHARACTER) ) (0x01000000):Insert = ( (0x03000000):Type = 5 (INTEGER) (0x03000000):Text = '[IBM][CLI Driver][DB2/NT] SQL0204N "DB2ADMIN.XMLFLIGHTTB" is an undefined name. SQLSTATE=42704 ' (CHARACTER) ) ) ) ) ) ) '</Insert>
<Insert type="string">XML_Reservation.LogException</Insert>
</Error> |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu Jan 27, 2011 12:21 pm Post subject: Re: Exception in ESQL of Airline Reservation sample |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| arramna wrote: |
| How to fix this ? |
Well never used the sample in question or attempted to set it up you understand, but looking at the error in isolation it seems clear that the database table XMLFLIGHTSB isn't in the DB2ADMIN schema of your particular database. Possibly for good & sufficient reason. It seems to me the simplest fix would be to amend the sample code to reference where that table does exist.
The 2nd simplest fix would be to define the table under that schema.
Other solutions are undoubably possible.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Wed Oct 03, 2012 5:16 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
|
| Back to top |
|
|
|
|
