Hi Folks,

This document is continuation to the below document:

SAP HANA: Data Cleansing ( Validations ) & Error Handling using SAP BODS

In this document, I will be focusing on Error Handling feedback using BODS while loading data into SAP HANA

They are multiple ways to support feedback, some of them i have listed below:

1) To show the messages in the “Monitor” screen.

2) To send an email to the support team with error code and message

I will show you the first one i.e to display the messages in “Monitor” screen.

Please find the steps below:

1) Add the following local variables as shown below:

2) Add Try & Catch block along with the “Script” ( where we will be adding the code to get the relevant error messages in the status monitor )

3) Add the following code to the script as mentioned below:

Now we are good. Let us now try executing the job and check the status monitor if we are getting any error messages.

As you see above we are getting the error messages.

Now if we need to send this as an email to the user, you just need to use this Variable Var1 (which we printed ) in SMTP function to configure the emails.

Note: This syntax is relevant to HANA only if you are trying to configure to some other data base then you need to change the SQL syntax.

Hope you enjoyed reading this. Please let me know your feedback on this.

Yours

Krishna Tangudu

To report this post you need to login first.

1 Comment

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

  1. David Szatmari

    Dear Krishna,

    it is a great guide, thanks!

    Where can you clean the data that has been violated? You have loaded the data into SAP Hana already into  a “fail” table. Do you have any idea where can u manually correct the fileds that did not pass the validation? Is there any tool like SM30 in Hana or BO, or you have to use sql?

    Thanks,

    David.

    (0) 

Leave a Reply