Skip to Content
avatar image
Former Member

How to get huge data from XSJS?

Hi,

I am trying to retrieve huge amount of data from XSJS.

But when I try to get more than 1Lakh rows, the XSJS request times out/gives 503 service error.

Is there any way to get this huge data, by either partitioning the data into parts or by any other method?

Please help.

Add comment
10|10000 characters needed characters exceeded

  • See even u are not using loop.From backend to front end if we want to get daya we use

    While(rs.next())

    {

    var record = {};

    record.a = rs.getString(1);

    ...

    ..

    record.f = rs.getString(6);

    output.push(record);

    }

    Hope the above bolded code is creating issue.

  • Former Member Florian Pfeffer

    Hi Florian, I am trying to plot a heatmap with this data.

    I don't know how to get the xsengine's sessiontimeout configuration parameter in HANA DB. Please let me know how I can fetch this data.

    I have to correct myself here. The XSJS doesn't time out. But it errors out, giving 503 service error. And I have to reload a couple of times and then the logon screen loads up.

  • As it is no timeout error and you get a 503 error, I would recommend to check the server logs.

  • Get RSS Feed

3 Answers

  • May 23, 2017 at 05:51 PM
    -1

    Hello,

    In the latest versions of SAP HANA, we can actually control the amount of memory to be consumed at XS Application Level.
    There you could possibly do extend your memory for this application which is data consuming.

    Nevertheless, it is not recommended to have such heavy data on the front end. I am guessing is it for Excel downloads from the front end?

    Regards,
    Krishna Tangudu

    Add comment
    10|10000 characters needed characters exceeded

  • May 24, 2017 at 09:05 AM
    -1

    I would suggest to get data in parts using some filterparameters that user can provide input from ui and then display map, or find out an event from map and and load data into the parts.

    Add comment
    10|10000 characters needed characters exceeded

  • May 19, 2017 at 06:44 AM

    Hi Chirag Maladkar,

    First of all, does it really make any sense for you to get so huge amount of data from the XSJS, what's the purpose of this?

    If you directly display these data on the page, then user will lost in such huge amount of data. If really required, to display these data on the web page. You have to paging it, e.g.10/20 rows each page, then you should only get the certain 10/20 records for the service.

    If you want to analysis these data, why you don't do it in HANA itself and response only the required data to end user?

    Best Regards,

    Hank.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Hank,

      I am trying to plot a heatmap with this data. If it was a simple tabular display of data, I wouldn't even bother about this.

      I have to correct myself here. The XSJS doesn't time out. But it errors out, giving 503 service error. And I have to reload a couple of times and then the logon screen loads up.