SAP Knowledge Base Article - Preview

2426180 - SYB - [ASE Error SQL21] Fatal Error 4409 occurred - SAP ASE for BS

Symptom

  • ST22 short dump:
    Category               Installation Errors
    Runtime Errors         DBSQL_SQL_ERROR
    Except.                CX_SY_OPEN_SQL_DB
    ----------------------------------------------------------------------------------------------------

    ----------------------------------------------------------------------------------------------------
    |Short Text                                                                                        |
    |    SQL error "SQL code: 21" occurred while accessing table "<object_name>".                      |
    ----------------------------------------------------------------------------------------------------

  • dev_w<*>:
    sql error 21 performing PRE on table <object_name> [dbdbslst 5138]
    [ASE Error SQL21]WARNING - Fatal Error 4409 occurred at <date>. Please note the error and time, and contact a user with System Administrator (SA) authorization. [dbdbslst 5138]

  • ASE errorlog <SID>.log:
    server Error: 4409, Severity: 20, State: 1
    server The columns in the query definition and the view definition do not match.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP NetWeaver (NW) - All versions

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

4409, SQL21, mismatch, view , 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.