This blog is intended for Developers / Modelers who  want to learn debugging  Hana views and doesn’t have prior experience in working with Hana studio or any eclipse based IDE. Myself I found it very difficult to understand debugging with studio as I was having only experience of debugging ABAP programs, which was pretty much  straight forward for me with /h ( F5, F6 F7 🙂 ).


  • Once you have logged on to your Hana system, in the systems view find the name of your scripted view under the schema SYS_BIC under procedures. For all scripted views, system will generate a .procedure file under SYS_BIC, your script will be listed along with the package path here. Locate and open the procedure.

          /wp-content/uploads/2015/12/t_845096.jpg

  • Go to Run -> Debug Configuration -> HANA Stored procedure -> New configuration and select catalog schemas and browse for your Procedure / Scripted View under SYS_BIC

u.JPG

  • Name your configuration and click on apply
  • Go to Debug perspective

/wp-content/uploads/2015/12/t_845096.jpg

  • Set break points by double clicking on the left side of margin as shown below.
  • Go to Run->Debug Configurations-> select the configuration created and press Debug


/wp-content/uploads/2015/12/t_845096.jpg

Variable and Breakpoints will be visible on the top right window, where you can right click and get a data preview. Press F8 to continue to next break point,also if you want to debug the same view once again, right click on the configuration and Relaunch it.



Thanks & regards

Deric Pavoo 🙂


To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply