2508724 - liveCache on HANA - DBIF_DSQL2_SQL_ERROR - OmsTerminate: error=-28530

Runtime error DBIF_DSQL2_SQL_ERROR occurs while liveCache call is executed on HANA liveCache e.g.:

Category                Installation Errors
Runtime Errors       DBIF_DSQL2_SQL_ERROR
Except.                  CX_SY_NATIVE_SQL_ERROR
Date and Time        13.07.2017 12:24:06

Short Text
    SQL error 423 occurred while executing Native SQL.

What happened?
    Error 423 has occurred on the current database connection "DEFAULT".
    Database error text: AFL error: OmsTerminate: error=-28530,  liveCache
     BAD_ALLOCATION in APS_ORDER_GET_DATA# liveCache ERROR -1028000 in
     APS_ORDER_GET_DATA: SessionGlobals::isMarkedForTerminate(h) is true!!! .
    Triggering SQL statement: "EXECUTE PROCEDURE "APS_ORDER_GET_DATA""

[...]

System environment
    SAP Release..... 740
    SAP Basis level 0016

    Application server... appserv01
    Network address...... 192.168.1.101
    Operating system... Linux
    Release.............. 3.0.101-97-default
    Hardware type....... x86_64
    Character length..... 16 Bits
    Pointer length........ 64 Bits
    Work process number... 0
    Shortdump setting. full

Corresponding workprocess trace dev_w0 of affected application server:

C Thu Jul 13 12:24:06 2017
C  *** ERROR =>   execute() of C_0124, #rec=0, rc=1, rcSQL=423
 [dbsdbsql.cpp 2045]
C  {root-id=005056B530C51ED799F66105E7D360D5}_{conn-id=49B567E7325CF11880D5005056B530C5}_18
C  *** ERROR => EXECUTE C_0124 on connection 0, rc=423
 [dbslsdb.cpp  10016]
C  SQLCODE    : 423
C  SQLERRTEXT : AFL error: OmsTerminate: error=-28530,  liveCache BAD_ALLOCATION in APS_ORDER_GET_DATA
C   liveCache ER\
C               ROR -1028000 in APS_ORDER_GET_DATA: SessionGlobals::isMarkedForTerminate(h) is true!!! .
C  sc_p=7f4a25f71690,no=124,idc_p=(nil),con=0,act=1,slen=186,smax=256,#vars=31,stmt=94484e0,table="APS_ORDER_GET_DATA"
C  CALL  "APS_ORDER_GET_DATA"  (  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? , \
C   ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ?  ) ;
B  ***LOG BY2=> sql error 423 performing EXE [dbds         296]
B  ***LOG BY0=> AFL error: OmsTerminate: error=-28530,  liveCache BAD_ALLOCATION in APS_ORDER_GET_DATA
 liveCache ERROR -1028000 in APS_ORDER_GET_DATA: SessionGlobals::isMarkedForTerminate(h) is true!!! . [dbds         296]

HANA indexserver trace indexserver_dbserver.34903.007.trc:

[67836]{300104}[58/-1] 2017-07-13 12:24:06.162018 i TraceContext     TraceContext.cpp(00960) : UserName=SAPSID, ApplicationUserName=USER_01, ApplicationName=ABAP:SID, ApplicationSource=/SAPAPO/SAPLATPQ_USAGE:214, Client=000, StatementHash=ae3891f8898465b9c844d36f806d1c78, EppRootContextId=005056B530C51ED799F66105E7D360D5, EppTransactionId=49B567E7325CF11680D5005056B530C5, EppConnectionId=49B567E7325CF11880D5005056B530C5, EppConnectionCounter=1, EppComponentName=CF1/DEFTHW99R27_CF1_00, EppAction=COHV
[67836]{300104}[58/-1] 2017-07-13 12:24:06.162008 e Memory           ReportMemoryProblems.cpp(01461) : Composite limit violation (OUT OF MEMORY) occurred.
Composite limit=53687091200
Host: dbserver
Executable: hdbindexserver
PID: 66453
Failed to allocate 12288 byte.
...
 [67836]{300104}[58/-1] 2017-07-13 12:24:06.166575 w Memory           PoolAllocator.cpp(01105) : Out of memory for Pool/LVCAllocator/OMSAllocator/Session_300104/OMSSession/OMSDefaultContext, size 11912B, alignment=1B, flags 0x0
0x1: 0x00007f8b90326856 in Diagnose::CallStack::fillTrace(ltt::basic_ostream<char, ltt::char_traits<char> >&, void**, unsigned long, Diagnose::RegisterSet const*, void const*, bool)+0x222 at CallStack.cpp:785 (libhdbbasis.so)
...
49: 0x00007f8b90546628 in Execution::Thread::staticMain(void*)+0x34 at ThreadMain.cpp:26 (libhdbbasis.so)
[67836]{300104}[58/531868226] 2017-07-13 12:24:06.184331 e LVC_Session      ConsoleError(531868226) : 
[67836]{300104}[58/531868226] 2017-07-13 12:24:06.184340 e LVC_Session      ConsoleError(531868226) : ##### #!!# Bad Allocation exception   ##
[67836]{300104}[58/531868226] 2017-07-13 12:24:06.184342 e LVC_Session      ConsoleError(531868226) : #  in APS_ORDER_GET_DATA
[67836]{300104}[58/531868226] 2017-07-13 12:24:06.184343 e LVC_Session      ConsoleError(531868226) : #
[67836]{300104}[58/531868226] 2017-07-13 12:24:06.184345 e LVC_Session      ConsoleError(531868226) : ~< DbpError -28000 in APS_ORDER_GET_DATA >~
[67836]{300104}[58/531868226] 2017-07-13 12:24:06.184353 e LVC_Session      ConsoleError(531868226) : # COM build 100034.11 CL 470639 (10.0_REL)
[67836]{300104}[58/531868226] 2017-07-13 12:24:06.184355 e LVC_Session      ConsoleError(531868226) : #  on LINUX X86_64
[67836]{300104}[58/531868226] 2017-07-13 12:24:06.184358 e LVC_Session      ConsoleError(531868226) : #--------------------------------------#
[67836]{300104}[58/531868226] 2017-07-13 12:24:06.184534 e LVC_Session      ConsoleError(531868226) : # omsTerminate will be triggered:
[67836]{300104}[58/531868226] 2017-07-13 12:24:06.184540 e LVC_Session      ConsoleError(531868226) : # ERROR -1028000 in APS_ORDER_GET_DATA
[67836]{300104}[58/531868226] 2017-07-13 12:24:06.184543 e LVC_Session      ConsoleError(531868226) : # [incident] qcbz0G000005LZm0vMMB5m
[67836]{300104}[58/531868226] 2017-07-13 12:24:06.184545 e LVC_Session      ConsoleError(531868226) : #        --> COM trace 1
[67836]{300104}[58/531868226] 2017-07-13 12:24:06.184861 e LVC_Session      ConsoleError(531868226) : ########################################
[67836]{300104}[58/531868226] 2017-07-13 12:24:06.185171 e LVC_Session      ConsoleError(531868226) : OmsHandle::omsTerminate  in method APS_ORDER_GET_DATA :  liveCache BAD_ALLOCATION in APS_ORDER_GET_DATA
 liveCache ERROR -1028000 in APS_ORDER_GET_DATA: SessionGlobals::isMarkedForTerminate(h) is true!!!
[67836]{300104}[58/531868226] 2017-07-13 12:24:06.186179 e LVCProcedure     LVCProcedure.cc(01234) : Execute of SAPAPO::APS_ORDER_GET_DATA failed with OmsTerminate: error=-28530,  liveCache BAD_ALLOCATION in APS_ORDER_GET_DATA
 liveCache ERROR -1028000 in APS_ORDER_GET_DATA: SessionGlobals::isMarkedForTerminate(h) is true!!! .

liveCache on HANA

KBA , BC-DB-LCA , liveCache Applications , HAN-DB , SAP HANA Database , Problem