over 5 hours stored procedure with INSERT on SAP HANA

[Former Member]

Hello Experts,

We are having a simple INSERT stored procedure which for some reasons goes for over 5 hours. When we execute the same INSERT statement in the pure SQL console it takes around 10 minutes. We are on the revision 67. Are there any known issues about this behavior of stored procedure with INSERT statement?

Any hints would be appreciated!

Regards

Casper

[rindia]

Hi Casper,

Sometimes the query might run out of memory (OOM). Can you have quick check on Administration -> Diagnosis Files tab and look for the trace based on time. You might get some trace info on this.

Regards

Raj