MQSeries.net :: View topic - Timeout Notification node Database access issue

siddique20 · Posted: Mon Aug 18, 2014 4:18 am Post subject:

Hi There

I have a Message Flow starting with the Timeout Notification node. Timeout node is configured to execute after every 10 seconds interval. First cycle of the flow execute without an error. but the second flow generate an error on Database select query. I'm accessing oracle database with ODBC connection.

This is the code generating an error....

DECLARE MyTimeStamp TIMESTAMP;
SET MyTimeStamp = TIMESTAMP '2014-08-13 10:10:10';
SET Environment.Variables.Alerts = NULL;
SET Environment.Variables.Alerts[] =
(SELECT SMS.DEBITBRANCHCODE, SMS.DEBITACCOUNTNO, SMS.TRDATE, SMS.AMOUNT, SMS.UNIQUEID
FROM Database.MB9_TRANSACTION_SMS_VIEW AS SMS WHERE SMS.TRDATE > MyTimeStamp);

This is the exception detail generated.....

(0x01000000:Name ):DatabaseException = (
(0x03000000:NameValue):File = 'F:\build\slot1\S000_P\src\DataFlowEngine\MessageServices\ImbOdbc.cpp' (CHARACTER)
(0x03000000:NameValue):Line = 3412 (INTEGER)
(0x03000000:NameValue):Function = 'ImbOdbcConnection::checkRcInner' (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 = 2322 (INTEGER)
(0x03000000:NameValue):Text = 'Child SQL exception' (CHARACTER)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = 'HY000' (CHARACTER)
)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 2 (INTEGER)
(0x03000000:NameValue):Text = '0' (CHARACTER)
)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = '[IBM][ODBC Oracle Wire Protocol driver]Data type for parameter 1 has changed since first SQLExecute call.' (CHARACTER)
)
)

Please help.