SAP Knowledge Base Article - Preview

3120803 - Error SQL30046 reported during HR patch installation - SAP ASE for Business Suite

Symptom

  • Error SQL30046 is reported during patch installation SAPKE604H0 for table T50B
    4 ETW000 [ dev trc,00000] ERROR: -1 in function StartSelect (execute) [line 30566]
    4 ETW000 [ dev trc,00000] (30046) [08S01] [SAP][ASE ODBC Driver]Connection to the server has been lost. ASE Terminated the
    4 ETW000 [ dev trc,00000] connection. Check the server to determine the status of any open transactions.
    4 ETW000 [ dev trc,00000] syb_glob.dbsl_ca.errclass set to DBSL_EC_RESTART
    4 ETW000 [ dev trc,00000] ERROR: -1 in function StartSelect (execute) [line 30566]
    4 ETW000 [ dev trc,00000] (5702) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]ASE is terminating this process
    4 ETW000 [ dev trc,00000] s.
    4 ETW000 [ dev trc,00000] sql statement is ==> SELECT * FROM "T50BG" WHERE "MOLGA" = ? AND "SAGRP" = ? AND "DOCTY" = ? AND "STA
    4 ETW000 [ dev trc,00000] TUS" = ? AND "SUBST" = ? AND "STATUS_M" = ? AND "SUBST_M" = ? AND "MANDT" IN ( ?
    4 ETW000 [ dev trc,00000] , ? , ? ) FOR UPDATE
    4 ETW000 /* R3::0 T:T50BG */
    4 ETW000 /*9*/
    4 ETW000 [dbsyb.c ,00000] *** ERROR => allocation of statement handle failed (-1).
    4 ETW000 [ dev trc,00000] ERROR: -1 in function GetTranState (SQLAllocStmt failed) [line 53267]
    4 ETW000 [ dev trc,00000] evaluation of transaction state failed.
    4 ETW000 [ dbtran ,00000] ***LOG BY4=>sql error 30046 performing SEL on table T50BG
    4 ETW000 [ dbtran ,00000] ***LOG BY0=>[ASE Error SQL30046:08S01][SAP][ASE ODBC Driver]Connection to the server has been lost. ASE Terminated the connection. Check the server to determine the status of any open transactions.
    4 ETW000 [ dev trc,00000] dbtran ERROR LOG (hdl_dbsl_error): DbSl 'SEL'
    4 ETW000 RSLT: {dbsl=99, tran=1}
    4 ETW000 FHDR: {tab='T50BG', fcode=69, mode=2, bpb=0, dbcnt=0, crsr=1,
    4 ETW000 hold=0, keep=0, xfer=0, pkg=0, upto=0, init:b=0,
    4 ETW000 init:p=0000000000000000, init:#=0, wa:p=0X000000000826C440, wa:#=44}
    2EETW125 SQL error "30046" during "T50BG" access: "[ASE Error SQL30046:08S01][SAP][ASE ODBC Driver]Connection to the server has been lost. ASE Terminated the connection. Check the server to determine the status of any open transactions."

  • At the same datetime, the ASE error log is reporting a "Adaptive Server Enterprise system exception (0xc0000005) generated by a storage access violation." (or "segmentation fault / signal on Unix) followed by a stacktrace referring to the following modules:
    LogPropsBase::~LogPropsBase
    LogPropsBase::`scalar deleting destructor'
    CtrPtr<Pop<ParallelCost,ParallelProps> >::_ctrDec
    PopUpdate<ParallelCost,ParallelProps>::DestructObj
    CtrPtr<Pop<ParallelCost,ParallelProps> >::_ctrDec
    PopN<ParallelCost,ParallelProps>::Destructor


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.7 SP122
SAP NetWeaver (NW) - All versions

Keywords

KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.