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