XSJS out of memory error
I am having an issue where the XS engine is running an out of memory allocation error. I am using HANA SP09 (1.0.96)
I have an XSJS service which calls a stored procedure returning 180k records. if I add a filter, the XS API is returning successful, however, if i return a bigger result set (180k rows in the db) then I get a service unavailable error. the error on the performance tab states "invalid protocol or service shutdown during distributed query execution" a recent post suggested to add a jsvm property in the xsengine.ini and set it to 100GB. that solution didnt work in my case.
while debugging, i am getting the error while assignign the output table type from the stored procedure call into a JS variable.
any other suggestion is highly appreciated.