2508724 - liveCache on HANA - DBIF_DSQL2_SQL_ERROR - OmsTerminate: error=-28530 | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

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

Symptom

 

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!!! .


Read more...

Environment

liveCache on HANA

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.