MQSeries.net :: View topic - How big can the ExceptionList structure be ?

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » How big can the ExceptionList structure be ?

How big can the ExceptionList structure be ?

« View previous topic :: View next topic »

Author

Message

ydsk

Posted: Wed Aug 16, 2006 12:02 pm Post subject: How big can the ExceptionList structure be ?

Chevalier

Joined: 23 May 2005
Posts: 410

I need to insert the entire ExceptionList structure into a database field. But I wonder how big it can be ? I allocated 2 KB but once it exceeded the size, and I am not sure what size to allocate for the database field.

Does it depend on the input msg size ?

Any suggestions ?

Thanks.

jefflowrey

Posted: Wed Aug 16, 2006 12:41 pm Post subject:

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

There's nothing that I know of that limits the number of included exceptions in an ExceptionList.

So in theory it could be bigger than anything you specify.
_________________
I am *not* the model of the modern major general.

madi

Posted: Wed Aug 16, 2006 1:11 pm Post subject:

Chevalier

Joined: 17 Jan 2006
Posts: 475

you should probably do a 'RIGHT' since the end exception is the one that is most useful

--madi

ydsk

Posted: Wed Aug 16, 2006 1:20 pm Post subject:

Chevalier

Joined: 23 May 2005
Posts: 410

I am using a loop ( sample ESQL provided in manuals) to drill down to the most nested error code and text, and I am inserting them into the database as 2 separate fields. But just want to dump the entire exceptionlist as a different field in the same table.

Don't ask me why I am doing it this way when I already have the most nested error code and text. I just thought it might help !

If people more experienced with the product feel what I am doing is redundant I'll probably do away with it.

The error text that I get by looping thru the entire nested Exceptionist structure isn't the same as the text shown in BIPv6.properties file in the installation path for the same error code. So, I thought it might help if I dump the whole ExceptionList structure into database.

Thanks.

madi

Posted: Wed Aug 16, 2006 1:46 pm Post subject:

Chevalier

Joined: 17 Jan 2006
Posts: 475

well . how about just dumping the two inner most exceptions into the DB?

that should be the info you will need

--madi

jbanoop

Posted: Sat Aug 19, 2006 12:43 am Post subject:

Chevalier

Joined: 17 Sep 2005
Posts: 401
Location: SC

we here insert only the last exception in the DB/log. However for database exceptions the higher levels usually makes it more helpful to debug as it shows the actual query string from ESQL that caused the DB error.

Anoop

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » How big can the ExceptionList structure be ?

Jump to:

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

Protected by Anti-Spam ACP