| 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. |
|
| Back to top |
|
 |
| 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. |
|
| Back to top |
|
|
| 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 |
|
| Back to top |
|
|
| 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. |
|
| Back to top |
|
|
| 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 |
|
| Back to top |
|
|
| 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 |
|
| Back to top |
|
|
|
|
