Skip to Content

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jun 25 at 06:59 PM

    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

    Add comment
    10|10000 characters needed characters exceeded