MQSeries.net :: View topic

nilayms · Posted: Wed Aug 08, 2007 3:17 am Post subject:

I am trying to develop a message flow which pics up xml messages from a queue and then a database node inserts the information into an oracle database on a remote server. I am using MQ v6.0 and WBIMB v6.0. Also we are using DB2 for the local databse. I have done the changes to the odbc.ini file and also updated the LIBPATH variable.

When i try to put the message on the queue it goes to the failure queue with the following error :

===========================
-- Begin Failure Message:--
===========================

Date/Time is: 2007-08-08 09:12:54.146582

Exception is:
------------

(
(0x01000000):RecoverableException = (
(0x03000000):File = '/build/S000_P/src/DataFlowEngine/ImbMqInputNode.cpp'
(0x03000000):Line = 1768
(0x03000000):Function = 'ImbCommonInputNode::eligibleForBackout'
(0x03000000):Type = 'ComIbmMQInputNode'
(0x03000000):Name = 'ACCOUNT_POC#FCMComposite_1_1'
(0x03000000):Label = 'ACCOUNT_POC.MQInput'
(0x03000000):Catalog = 'BIPv600'
(0x03000000):Severity = 3
(0x03000000):Number = 2652
(0x03000000):Text = 'Dequeued failed message. Propagating a message to the failure terminal'
)
)

Message is:
-----------

(
(0x01000000):Properties = (
(0x03000000):MessageSet = ''
(0x03000000):MessageType = ''
(0x03000000):MessageFormat = ''
(0x03000000):Encoding = 546
(0x03000000):CodedCharSetId = 1208
(0x03000000):Transactional = TRUE
(0x03000000):Persistence = TRUE
(0x03000000):CreationTime = GMTTIMESTAMP '2007-08-08 08:12:47.720'
(0x03000000):ExpirationTime = -1
(0x03000000):Priority = 0
(0x03000000):ReplyIdentifier = X'000000000000000000000000000000000000000000000000'
(0x03000000):ReplyProtocol = 'MQ'
(0x03000000):Topic = NULL
(0x03000000):ContentType = ''
)
(0x01000000):MQMD = (
(0x03000000):SourceQueue = 'BROKER_INPUT'
(0x03000000):Transactional = TRUE
(0x03000000):Encoding = 546
(0x03000000):CodedCharSetId = 1208
(0x03000000):Format = 'MQSTR '
(0x03000000):Version = 2
(0x03000000):Report = 0
(0x03000000):MsgType = 8
(0x03000000):Expiry = -1
(0x03000000):Feedback = 0
(0x03000000):Priority = 0
(0x03000000):Persistence = 1
(0x03000000):MsgId = X'414d5120514d5f4d51495f4445565f30456a7ed72003d102'
(0x03000000):CorrelId = X'000000000000000000000000000000000000000000000000'
(0x03000000):BackoutCount = 1
(0x03000000):ReplyToQ = ' '
(0x03000000):ReplyToQMgr = 'QM_MQI_DEV_0A '
(0x03000000):UserIdentifier = 'sundarn '
(0x03000000):AccountingToken = X'0000000000000000000000000000000000000000000000000000000000000000'
(0x03000000):ApplIdentityData = ' '
(0x03000000):PutApplType = 28
(0x03000000):PutApplName = 'WebSphere MQ Client for Java'
(0x03000000):PutDate = DATE '2007-08-08'
(0x03000000):PutTime = GMTTIME '08:12:47.720'
(0x03000000):ApplOriginData = ' '
(0x03000000):GroupId = X'000000000000000000000000000000000000000000000000'
(0x03000000):MsgSeqNumber = 1
(0x03000000):Offset = 0
(0x03000000):MsgFlags = 0
(0x03000000):OriginalLength = -1
)
(0x01000010):XML = (
(0x01000000):Create_Customer_Account_MSG = (
(0x01000000):Personal_Details = (
(0x01000000):First_Name = (
(0x02000000): = 'Peter'
)
(0x01000000):Last_Name = (
(0x02000000): = 'Smith'
)
(0x01000000):User_ID = (
(0x02000000): = 'PSmith'
)
(0x01000000):Password = (
(0x02000000): = 'p45sw0rd'
)
)
(0x01000000):Email_Address = (
(0x02000000): = 'Peter.Smith@nowhere.com'
)
(0x01000000):Daytime_Telephone = (
(0x02000000): = '1234567890'
)
(0x01000000):Evening_Telephone = (
(0x02000000): = '1234567890'
)
(0x01000000):Shipping_Address = (
(0x01000000):Address_1 = (
(0x02000000): = '19 Green Street'
)
(0x01000000):Address_2 = (
(0x02000000): = 'Littleton>'
)
(0x01000000):Town = (
(0x02000000): = 'Southington'
)
(0x01000000):Postcode = (
(0x02000000): = 'SU29 8YT'
)
)
(0x01000000):Billing_Address = (
(0x01000000):Address_1 = (
(0x02000000): = '19 Green Street'
)
(0x01000000):Address_2 = (
(0x02000000): = 'Littleton>'
)
(0x01000000):Town = (
(0x02000000): = 'Southington'
)
(0x01000000):Postcode = (
(0x02000000): = 'SU29 8YT'
)
)
(0x01000000):Payment_Details = (
(0x01000000):Card = (
(0x02000000): = 'VISA'
)
(0x01000000):Card_Number = (
(0x02000000): = '1234567890'
)
(0x01000000):Expiry_Date = (
(0x02000000): = '2009-09-12'
)
(0x01000000):Issue_Date = (
(0x02000000): = '2009-09-12'
)
(0x01000000):Issue_Number = (
(0x02000000): = '02'
)
(0x01000000):Security_Code = (
(0x02000000): = '333'
)
)
)
)
)

=========================
-- End Failure Message:--
=========================
[img][/img][img][/img]
_________________
Regards,
Nilay.