Skip to Content
0
Jul 24, 2019 at 03:53 PM

Memory allocation error through qlik

1708 Views

Hi Team,

Got below error while the query was executing from qlik application.

Error: QVX_UNEXPECTED_END_OF_DATA: SQL##f - SqlState: S1000, ErrorCode: 139, ErrorMsg: [SAP AG][LIBODBCHDB DLL][HDBODBC] General error;139 current operation cancelled by request and transaction rolled back

error code 139 indicates current operation cancelled by request and transaction rolled back

Here we don't understand this error properly , like if this is cancelled by user or connection issue ??

Please help us in understanding this error in detail.

Gt below trace in indexserver trace file:\

[94192]{259876}[673/-1] 2019-07-11 21:30:32.439684 e Executor PlanExecutor.cpp(00877) : search table error: [9] Memory allocation failed(2048), plan: 3 pops: RowPlanOperator pop1(out a), RowPlanOperator pop2(out b), RowPlanOperator pop3(in ab, out cd)
[94192]{259876}[673/-1] 2019-07-11 21:30:32.439693 e Executor PlanExecutor.cpp(00877) : pop1, 21:25:44.990 +4:45.842, cpu 140407358755923, RowPlanOperator, rc 2048, search table error: [9] Memory allocation failed

Is there any way we can find out which all queries were executed from qlik and how much memory it consumes.

HDB version
HDB version info:
version: 1.00.122.21.1540267292
branch: fa/hana1sp12
machine config: linuxx86_64
git hash: 6c864a0d6935ca712477bfdec1a2a9daa312f502
git merge time: 2018-10-23 06:01:32
weekstone: 0000.00.0
compile date: 2018-10-23 06:11:24
compile host: ld7272
compile type: rel

Regards

Parag Jhade