SQL Debugging is not ready

[architectSAP]

Dear experts,

I am following Chaim Bendelac's excellent blog Developing with XS Advanced: A TinyWorld Tutorial.

However, executing the tinyworld:tinydb::createCountry SQL Procedure fails with a strange error message "Executing the SQL Statement is not valid...":

Any idea what might cause this would be very much appreciated. My HANA system is version 1.00.121.00.1466466057.

However, I did not leave it there, but tried to debug the SQL Procedure. For this I gave my user the Debugger role:

I also set the system parameters accordingly and restarted it to be sure that the changes got applied:

However, when trying to Toggle the Connection, I get this error message, that SQL Debugging is not ready. Could not connect SQL Debugging for Service...:

What am I missing?

Many thanks for any help in advance

Frank

[Former Member · Accepted solution]

Hi colleageus,

Role is not necessary any more, debugg will be enable automatically at server side.

Ensure you start HRTT on chrome browser and not use domain address.

Otherwise you have to consider have trusted certificate for browser (IE and FF) and domain address for any browsers

[Former Member · Accepted solution]

https://wiki.wdf.sap.corp/wiki/display/hanacst/Setup+certificate+for+the+server+to+run+debugger+on+I...

https://wiki.wdf.sap.corp/wiki/pages/viewpage.action?pageId=1815502290

[architectSAP · Accepted solution]

Thank you Dat,

Using Chrome instead of Firefox did the trick. However, unfortunately, the links you shared seem to be SAP internal. Are there externally accessible alternatives?

Very best regards

Frank