I am unable to debug HANA SQL script on AMDP

[Former Member]

I have done the following by looking at various blogs and video's but I am still unable to debug the AMDP as it does not stop on the SAP procedure created for AMDP.

1) I have authorization for debug and execute on SAP<SYSID> schema

2) Authorization to attach the debugger to a SAP<SYSID> user session

3) I have set up a break point on the procedure which is created in SAP<SYSID> for the AMDP I created.

4) In debug perspective I have created a configuration for my SAP and HANA user for the HANA DB we are using and the debug thread is running for my procedure

6) When I call the program from ABAP perspective. I am able to debug on ABAP code which calls the AMDP but when executed the code never stops in the SQL Script.

my HANA version in SPS 7.

Can someone explain me if I am missing any step here.

Thanks

Nafran

[Former Member]

I have done the following by looking at various blogs and video's but I am still unable to debug the AMDP as it does not stop on the SAP procedure created for AMDP.

1) I have authorization for debug and execute on SAP<SYSID> schema

2) Authorization to attach the debugger to a SAP<SYSID> user session

3) I have set up a break point on the procedure which is created in SAP<SYSID> for the AMDP I created.

4) In debug perspective I have created a configuration for my SAP and HANA user for the HANA DB we are using and the debug thread is running for my procedure

6) When I call the program from ABAP perspective. I am able to debug on ABAP code which calls the AMDP but when executed the code never stops in the SQL Script.

my HANA version in SPS 7.

Can someone explain me if I am missing any step here.

Thanks

Nafran

[jasmin_gruschke]

Hi Nafran,
you certainly refer to the video: How to debug an ABAP Managed Database Procedure (AMDP) - YouTube) and/or to the blog: http://scn.sap.com/docs/DOC-51790.

One question, do you see an "error icon" on the procedure break point (something like a red cross icon on the breakpoint) when the debugger does not stop at your break point?

Can you execute the procedure directly from HANA's SQL Console and does it stop in that scenario?

Cheers,
  Jasmin

[jasmin_gruschke]

Hi Nafran,
additionally, please have a look at my comments/reply in , as you might suffer from similar issues/configurations.
Cheers,
  Jasmin

[Former Member]

Hi Jasmin,

No I don't have the error icon. I get the Icon with the check mark.

I did execute the procedure in HANA SQL console still the same result.It does not stop.

Thanks

Nafran

[Former Member]

Yes I have been referring to the given document.

I get all the screens same up to the debugger thread but it does not stop.

Thanks

Nafran