SAP Knowledge Base Article - Preview

2905185 - DBA Cockpit - Single Table Analysis reported Database error 30013 at FET - SAP ASE for BS

Symptom

  • On systems running SAP applications, 

    t-code DBACockpit -> Space -> Tables and Indexes -> Single-Table Analysis -> Enter Owner and Table name -> Apply selection -> a blank under the 'Dependency Navigation' tab

  • The following error messages reports into SM21 and the developer trace.

    [SM21]

    Database error 30013 at FET
    > [ASE Error SQL30013:07009][SAP][ASE ODBC Driver]Invalid
    > descriptor index

    [Developer trace]

    C Wed Mar 18 16:37:03 2020
    C ERROR: -1 in function DescribeLobTable (SQLDescribeParam) [line 59632]
    C (102) [42000] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]Incorrect syntax near 't1'.
    C
    C
    C Wed Mar 18 16:37:07 2020
    C WARNING: 1 in function StartSelect (execute) [line 29810]
    C (9501) [01003] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]Warning - null value eliminate
    C d in set function
    C
    C WARNING: 1 in function StartSelect (execute) [line 29810]
    C (9501) [01003] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]Warning - null value eliminate
    C d in set function
    C
    C sql statement is ==> sp_showoptstats ?
    C
    C Wed Mar 18 16:37:24 2020
    C WARNING: 1 in function StartSelect (execute) [line 29810]
    C (0) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]Things inside the current data
    C base that reference the object.
    C sql statement is ==> <SID>..sp_depends '<Owner>.<Table_name>'
    C ERROR: -1 in function RefillBuffer (fetch) [line 31235]
    C (30013) [07009] [SAP][ASE ODBC Driver]Invalid descriptor index
    C sql statement is ==> <SID>..sp_depends '<Owner>.<Table_name>'
    C dbdssyb: DBSL99 SQL30013
    C [ASE Error SQL30013:07009][SAP][ASE ODBC Driver]Invalid descriptor index
    B ***LOG BY2=> sql error 30013 performing FET [dbds 531]
    B ***LOG BY0=> [ASE Error SQL30013:07009][SAP][ASE ODBC Driver]Invalid descriptor index [dbds 531]


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP Solution Manager (SOLMAN) 7.1, 7.2
  • SAP NetWeaver (NW) - All versions 

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP NetWeaver all versions ; SAP Solution Manager 7.1 ; SAP Solution Manager 7.2

Keywords

dbacockpit , TBTCO , TBTCP , space , no , record , row , eliminated , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , How To

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.