| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Need to attach Error to message and store it to DB as BLOB |
« View previous topic :: View next topic » |
| Author |
Message
|
| machinist |
 Posted: Fri Aug 19, 2016 1:37 am Post subject: Need to attach Error to message and store it to DB as BLOB |
 |
|
Novice
Joined: 17 Feb 2016
Posts: 15
Location: India
|
Hi All,
I want access exception generated and attach it to message store it to DB,i have written following ESQL code with access exception list,its type and trying to store message to DB,but its not working,
DECLARE exType CHAR;
DECLARE exRef REFERENCE TO InputExceptionList.*[1];
SET Incoming_Message=InputRoot.BLOB;
WHILE(FIELDNAME(exRef.*[<]) = 'RecoverableException' OR FIELDNAME(exRef.*[<]) = 'ParserException' OR FIELDNAME(exRef.*[<]) = 'DatabaseException' OR FIELDNAME(exRef.*[<]) = 'UserException' OR FIELDNAME(exRef.*[<]) = 'ConvertionException' ) DO
SET exType = FIELDNAME(exRef.*[<] );
SET TransactionStatus_FCUBS='FAIL';
MOVE exRef TO exRef.*[<];
END WHILE;
INSERT INTO Database.TRANSACTION_HISTORY_TABLE (CHANNEL_BATCH_UID,TRANSATIONTYPE,CHANNEL_TXN_UID,PARTICIPATING_SYSTEM,MW_UNIQUE_REF_ID,BRANCHCODE,AMOUNT,CURRENCY,INCOMINGREQUESTDATE,INPUTQUEUENAME,TRANSACTIONSTATUS_FCUBS,OUTGOINGRESPONSEDATE,OUTPUTQUEUENAME,INCOMING_MESSAGE)
VALUES(CHANNEL_BATCH_UID,TransationType,CHANNEL_TXN_UID,Participating_System,MW_Unique_Ref_Id,BranchCode,Amount,Currency,IncomingRequestDate,InputQueueName,TransactionStatus_FCUBS,OutgoingResponseDate,outputQueueName,Incoming_Message);
RETURN TRUE;
END;
Can anyone help me to correct?  |
|
| Back to top |
|
 |
| smdavies99 |
| Posted: Fri Aug 19, 2016 2:17 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
so it is not working. Good. What errors are you getting back?
That would help a lot.
_________________
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 |
|
|
| machinist |
| Posted: Fri Aug 19, 2016 4:07 am Post subject: |
|
|
Novice
Joined: 17 Feb 2016
Posts: 15
Location: India
|
| sir no error, but its not inserting data into DB |
|
| Back to top |
|
|
| mqjeff |
| Posted: Fri Aug 19, 2016 4:10 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
Take a user trace.
_________________
chmod -R ugo-wx / |
|
| Back to top |
|
|
| Vitor |
| Posted: Fri Aug 19, 2016 5:05 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| mqjeff wrote: |
| Take a user trace. |
This will tell you where your code is nulling out the data you're trying to insert.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
