SAP Knowledge Base Article - Preview

3757590 - DBIF_DSQL2_SQL_ERROR with Invalid column name 'sysstat4' is reported - ASE on Business Suite

Symptom

After applying the BASIS 740 SP34 upgrade from SP12, a dump occurs as shown below when attempting to activate a table after adding new columns.
ASE 15.7 is used as a database for Business Suite.
 
===============================================================
Category           Installation Errors
Runtime Errors     DBIF_DSQL2_SQL_ERROR
Except.            CX_SY_NATIVE_SQL_ERROR
Date and Time      YYYY/MM/DD    hh:mm:ss
 
Short Text
        SQL error 207 occurred while executing Native SQL.
 
What happened?
        Error 207 has occurred on the current database connection "DEFAULT".
        Database error text: .[ASE Error SQL207]Invalid column name 'sysstat4'
        Triggering SQL statement: "SELECT t3.name, t2.name, t2.partitionid, t4.text,
        t4.id, t5.conditionid, CASE t5.partitiontype WHEN NULL THEN 3 ELSE
        t5.partitiontype END, case when ( sysstat3 & 8192 = 8192 and sysstat4 & 64 =
        0 ) then 8192 when ( sysstat4 & 64 = 64 ) then 64 else 0 end,"
===============================================================


Read more...

Environment

Business Suite on Adaptive Server Enterprise (ASE) 15.7

Product

SAP enhancement package 8 for SAP ERP 6.0

Keywords

DBIF_DSQL2_SQL_ERROR, SQL207, invalid column name, sysstat4, sysobjects, table activation, BASIS 740 SP34, ASE 15.7, SDB2FSYB , 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.