Skip to Content
0

How to get huge data from XSJS?

May 18, 2017 at 11:42 AM

156

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded

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.

0
Former Member
Mantri Shekar

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.

0

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.

0

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.

0
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.

0

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

0
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Krishna Tangudu 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

Share
10 |10000 characters needed characters left characters exceeded
Akhilesh Upadhyay 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.

Share
10 |10000 characters needed characters left characters exceeded
Hank Li
May 19, 2017 at 06:44 AM
0

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.

Show 1 Share
10 |10000 characters needed characters left 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.

0