SAP Knowledge Base Article - Preview

2297423 - "Warning The ATM setup on system 'DEV' is incomplete..." after upgrade - SAP ASE for Business Suite

Symptom

  • In the development system, ASE server has been upgraded from SAP ASE 16.0 SP01 PL02 to SAP ASE 16.0 SP02 PL02.
  • After upgrade, Automatic Table Maintenance (ATM) in DBA Cockpit shows the following error message:

Warning The ATM setup on system 'DEV' is incomplete or out-of-date and needs to be adjusted. Repair ATM

  • By clicking the button "Repair ATM", following ABAP dump is reported:

*********************************************************************************
Message:                       Error in RDI back-end setup occured!
caused by
Exception CX_DBA_RDI_SETUP in class CL_SYB_RDI_DBO_TABLE method IF_DBA_RDI_DBO~UPDATE line 157

Message:                       Unable to alter table 'ATM_WINDOWS'!

SQL statement: ALTER TABLE saptools..ATM_WINDOWS DROP "SYB_IDENTITY_COL" WITH NO DATACOPY
Database: +++SYBADM
caused by
Exception CX_SQL_EXCEPTION in class CL_SYB_RDI_QUERY 
Kernel Error ID: 
DB Error: Yes
SQL Code: 11050 
SQL Message: [ASE Error SQL9647][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Alter table drop column with no datacopy is not allowed for 'identity columns'('SYB_IDENTITY_COL'). The command will be aborted.
[ASE Error SQL4939][SAP][ASE ODBC Driver][Adaptive Server Enterprise]ALTER TABLE 'saptools..ATM_WINDOWS' failed. You cannot drop column 'SYB_IDENTITY_COL' because it is being used by an index. Drop the index 'ATM_WINDOW_6706224012' before dropping this column.
[ASE Error SQL11050][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Adaptive Server cannot process this ALTER TABLE statement due to one or more preceding errors. If there are no preceding errors, please contact SAP Technical Support.
**********************************************************************************


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP Enterprise Resource Planning (ERP) 6.0

Product

SAP Adaptive Server Enterprise 16.0 ; SAP ERP 6.0

Keywords

ATM_WINDOWS, SQL9647, 9647, SQL4939, 4939, SQL11050, 11050, "unique auto_identity index" , KBA , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , Problem

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.