cancel
Showing results for 
Search instead for 
Did you mean: 

AMDP behavior inconsistent in Debug mode and live run

gaurav_sharan
Explorer
0 Kudos

We are facing one issue in AMDP when we put breakpoint in AMDP and execute we get correct result. Without debugger we get different result. We have written multiple methods which consists of complex SQL scripts. It works when we call in sequence (that happens when we put debugger). When we execute without putting breakpoint then we get completely different result. I guess could be some parallelization. Can we stop this parallelization in AMDP? Please let me know is there any way to get same results without breakpoint. We have used loop (WHILE ENDWHILE) as well. Please let me know.

Accepted Solutions (1)

Accepted Solutions (1)

lbreddemann
Active Contributor
0 Kudos

SQL Script provides the BEGIN SEQUENTIAL EXECUTION option for blocks.

With this you can disable the default parallelisation.

Not sure what might be the issue with your code, though, as the parallelisation should only be applied by HANA when it is safe to do that.

This might be worth getting in touch with the SQLScript developers for.

Answers (0)