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
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.
SAP Knowledge Base Article - Preview