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 ONE Support launchpad (Login required).

Search for additional results

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