Skip to Content
avatar image
Former Member

Not able to debug a SQLScript procedure

Hello Experts

I'm following a simple sample of the OPENSap course. I have a simple procedure to calculate the sales price and another procedure that works as a wrapper and calls the first procedure passing the parameters.

1. Which option do i need to set up for the debug configuration, i don't see an SQLScript Procedure option as the course indicates.

2. I tried to use the SAP HANA Stored Procedure option but it seems to be not working as the Debug steps are showing as <terminated>


Thanks in advance for your help

Francisco

debug1.PNG (27.9 kB)
Debug2.PNG (55.5 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Aug 06, 2014 at 06:18 PM

    SAP HANA Stored Procedure is the correct option. Just a naming change to the label in the later versions of the HANA Studio.  Also since SP6 you no longer need the wrapper procedure. You can directly debug a procedure with input parameters. 


    As far as why it is terminating; I couldn't say.  There isn't really enough information provided to know why.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 22, 2014 at 04:19 PM

    Where you able to solve this?

    I am having a very similar problem where procedure A calls procedure B and the debugger only stops in procedure B.

    If I set no breakpoint in A it runs through exactly as you described above ("treminated").

    If I set a breakpoint in B (or both A and B) it only stops in B.

    This is even the case if in the "Debug Configuration" under "Procedure to Debug" procedure A has been selected.

    Both procedures are in the same XS project and schema so there is no complicated constellation.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 12, 2016 at 11:34 AM

    Hi Francisco,

    I have the very same problem, were you able to solve it?

    Thank you!

    Add comment
    10|10000 characters needed characters exceeded