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

SQL error 21, Fatal Error 4409, database view mismatch, SAP ASE error, SQL code 21, view definition mismatch, query definition mismatch, database view recreation, SAP Adaptive Server Enterprise, SAP NetWeaver error, ASE errorlog, runtime error DBSQL_SQL_ERROR, CX_SY_OPEN_SQL_DB exception, installation error , 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.