Exception Handling  under IIB :-


                      The tree will be like as follows :-


ExceptionList------->RecoverableException
 --->RecoverableException
--->RecoverableException
-->File
-->Line
-->Function
-->Type
-->Name
-->Label
-->Catalog
-->Severity
-->Number
-->Text
-->Insert
-->Type
-->Text
-->ParserException
-->File
-->Line
-->Function
-->Type
-->Name
-->Label
-->Catalog
-->Severity
-->Number
-->Text
-->Insert
-->Type
-->Text
Likewise tree will generate the ExceptionList...

MostLikely the LastChild  of the ExceptionList tree will be the current Exception that is thrown by the respective node 
   
Exception Class under IIB :-
Fatal
Recoverable
Configuration
Parser
Conversion
User
Database


How to access the above tree in ESQL code :-
So below are the code by which you can access the ExceptionList tree last exact Exception type and text ....
------------------------------------------------------------------------------------------------

DECLARE envarea REFERENCE TO Environment;
DECLARE exceptionList REFERENCE TO ExceptionList;
CREATE PROCEDURE getExceptionDescription ( IN envarea REFERENCE,IN exceptionList REFERENCE)
BEGIN

DECLARE errDescRef REFERENCE TO exceptionList.*[1];


DECLARE X INTEGER;
DECLARE I INTEGER 1;
DECLARE TXT CHARACTER '';
WHILE LASTMOVE(errDescRef) DO
IF FIELDNAME(errDescRef.Number) IS NOT NULL THEN
SET envarea.ErrorNumber=errDescRef.Number;
SET envarea.Errortype=FIELDNAME(errDescRef);
--
-- SET X = (CARDINALITY (errDescRef.Insert[]));
-- IF X >0 THEN
-- WHILE I < X +1 DO
-- DECLARE TEMP CHARACTER errDescRef.Insert[I].Text;
-- SET TXT = TXT || '[' || TEMP || ']';
-- SET I = I + 1;
-- END WHILE;
-- END IF;
-- SET envarea.ErrorText = TXT;

IF envarea.ErrorType = 'DatabaseException' THEN
SET envarea.SQLCode = errDescRef.Insert[2].Text;
END IF;
IF envarea.ErrorType = 'UserException' THEN
SET envarea.ErrorText=errDescRef.Text||'. Exception : '||errDescRef.Insert.Text;
END IF;
END IF;
MOVE errDescRef LASTCHILD;
END WHILE;
END;
-----------------------------------------------------------------------------------------------------------

Thanks For reading ....If u like this blog than please Comments and Like .........

You can find more question below ....

11. If the failure terminal of the compute node is connected to a queue, whre do you look for the error message.

12. For loop Syntax

13. when a HTTp and SOAP nodes are used ? (this sis specific to the project experience)

14. SAP Node flow and business scenario in which it is used (specific to project experience)

15. what is your scope in the project and how many flows you have developed

                                   

                                                                                                  To be Continue............

Here I am going to give Number of Questions which not only raise your interest in IIB as well as How You  come up with those question being asked in interview .........It will go likewise 

WMB IIB Interview Questions for

1. Brief Introduction

 They are expecting detailed introduction like the nodes used etc.

2.Diffrence and usage of XMLNSC and XMLNS domains

3. Imagine the input is 3000 bytes long and CWF format. inside which an xml is coming,  How do you access 5th field in XML.

4. Difference between Database and Compute node  and steps in accessing a DB. 

5. Trace commands

6. Imagine 3000 messages are coming to the flow at a given interval and your flow is capable of handling 1000 messages, how do you increase message thruput.

We can deploy additional instances to increase thruput, and then maximum instances allowed is 256.

7. How do access second last child element in the xml.

8. If you are assigning InputRoot to OutputRoot ,where as the inputrootreferance is null, what will happen?

9. When you have a field and its attribute with the same, the target should require only the attribute value, how do you access it?

they mean to say for eg:  < Folder1 Item ='ABCDE'>

                        <Item> 12345 </Item>

                  </Folder1>

Inorder to access Attribute you should specify as

      SET AttrValue = InputRooot.XMLNSC.Folder1.(XMLNSC.Attribute) Item ;

10. How do you make a variable available across\multiple messages,.

      Variable scoping, use external variable, which will be available across messages and to the entire life of the flow.

Hi 

This is the beginning of what are the things still hidden from us.....