Capturing error logs of HANA Calculation views

[aravindmail0295]

Hello Experts,

My requirement is to capture the error logs and send alerts whenever HANA Calculation views are getting failed. Especially when it fails due to memory issue(OOM).

Unfortunately we do not have access to trace files to capture the logs. So are there other possible ways to record the error logs from a calculation view and send mail alerts through stored procedures. Thanks.

[aravindmail0295]

Thanks Sayantan for the quick reply.

I would definitely check on the xsjs part but would like to know if this scenario can be handled through hana stored procedures with SQL code.

[ghoshsayantan3]

Hi Aravind,

Yes querying the m_out_of_memory monitoring view can be handled inside a procedure but the results of the OOM error list would need a service call to send it via email.

Please let me know once you have tried.

Regards,

Sayantan

[ghoshsayantan3]

Hi Aravind,

You can create a xsjs service to run query on m_out_of_memory monitoring view. Thus you will be able to capture any Oom error and in xsjs only you can create the email body and send the results via email.

In a need to trigger this xsjs on a schedule basis ,you can use xsjobs.

Regards,

Sayantan