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 for Me (Login required).

Search for additional results

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