Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.


Helpful Answer

Not what you were looking for? View more on this topic or Ask a question