Fixing the errors by trouble shooting a session

 Discuss about how to troubleshoot the sessions and fixing errors in ODI.


It is obvious that while we develop our ODI objects we may get errors.


I am going to give you some general steps to debug errors.

• Open the operator, find the session in error. Also find the step in Error state. And finally find the task in error.
• Then double click the task and click on description tab and click on code to look at the generated code by the ODI.This code will be usually in SQL for interfaces. And it is completely dependent on the knowledge modules which you used int the interface.
• Fix the errors in the code. This may be a complex task if you dont have solid understanding how the ODI works with the relevant technology.
• After fixing the errors clik apply and save. Refresh the session. Check error has been resolved or not. If the error has not been resolved try again the same method to resolve it.
• When you have fixed the error in the generated code, you should apply the same changes to your object (interface, procedure,package etc). And restart the session execution.
• Otherwise it will use the old code to generate the code.