Memory Allocation Error on XSJS (Successful through Web IDE in debugging)

[Former Member]

Dear All,

I am executing my xsjs code through xsjob and it fails at very first sql execute step where I am reading Hana calculation view, with below error -

Error Message Execution of script abcd.xsjs failed with error(s): InternalError: dberror($.hdb.Connection.executeQuery): 2048 - SQL error, server error code: 2048. column store error: search table error: [9] Memory allocation failed at /sapmnt/ld7272/a/HDB/jenkins_prod/workspace/8uyiojyvla/s/ptime/query/plan_executor/trex_wrapper/trex_wrapper_body/trex_executor.cc:153 (line 27 position 1 in ABCD.xsjs).

However, if I execute that very same sql in Hana Studio in sql window - I am able to retrieve data without any memory error. SQL is expected to retrieve only 10 records. I am also able to execute xsjs through Web IDE and I do not face any errors.

Can you please suggest how can I avoid this error when executed through xsjob ? We are currently on 1.00.122.16 version

Thanks

Hari

[former_member240094 · Accepted solution]

Hi Hari,

The error

- SQL error, server error code: 2048. column store error: search table error: [9] Memory allocation failed at

is a generic error when a job fails with memory related issues on HANA side. It needs to be checked why same query is successful in HANA directly. I would recommend you to check HANA indexserver log and other xsa traces to see if any memory related issues(ooms) were seen at the time of failure.

Thanks,

Arun Marria

[Former Member · Accepted solution]

Hi Arun,

Thank you for prompt response. indexserver logs were the first thing I checked and I do see composite memory errors but I cannot figure out why does this work well on Hana Studio sql window and also Web IDE but not through XSJOB. Any pointers please ?

StatementHash=297bb771c6d90e22ffdf1e5b96adb922 [79902]{227300}[88/-1] 2018-06-25 16:27:33.690256 e Memory ReportMemoryProblems.cpp(01463) : Composite limit violation (OUT OF MEMORY) occurred. Composite limit=322122547200 Limit correction value (additionally considered as 'used'): 31140 Executable: hdbindexserver PID: 41834 Failed to allocate 264512059712 byte.

Thanks

Hari

[former_member240094 · Accepted solution]

Is underlying statement exact same in both cases? Can you confirm from hash or traces (if captured)?