How to get huge data from XSJS?

[chirag_maladkar]

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.

[mantrishekar]

Hi Chirag Maladkar,

I am using XSJS to fetch Data from HANA DB.As of now i did not faced time out issue with xsjs.Even i am fetching more than one lakh Records.

This is some thing mistake with coding or looping.Please share the snippet how you are trying to fetch data using XSJS.So that we can help you.

[pfefferf]

Please can you share the value of the xsengines' sessiontimeout configuration parameter in your HANA db?

And please describe why it is necessary to load such an amount of data at one time into your UI5 client.

Thx.

[chirag_maladkar]

Hi Mantri Shekar, thanks for the reply.

There is no loop involved in the XSJS. I'm using HDB connection and a simple "select top 100000 * on tableName". The table contains 26 Lakh rows with 6 columns.

Still I am getting stuck here.

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.

[chirag_maladkar]

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.

[mantrishekar]

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.

[pfefferf]

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

[former_member227918]

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.

[former_member182302]

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

[former_member329238]

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.

[chirag_maladkar]

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.