Skip to Content

XSJS out of memory error

All,

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Aug 19, 2015 at 12:34 PM

    Hi Sergio,

    I've seen this sort of situation before. It's turning into a classic I think. I assume it's a CSV file generated in XSJS. Did I get it right?

    Why are you using XS engine for mass data extraction? It's definitely not meant for that. If you want to perform such a huge extraction, you should use a suitable tool (such as ODBC or JDBC ).

    Generating 180k records (times the avg amount of bytes per columns) you could easily reach the XS engine memory allocation, thus OOM'ing your service. And that is totally acceptable, given that XS Engine is a lightweight web container.

    In other words, it's better to review your application and use a suitable tool for that kind of job instead of squeezing in some much data into an HTTP based conversation and hoping that your service will keep up.

    BRs,

    Lucas de Oliveira

    Add comment
    10|10000 characters needed characters exceeded