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 , 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.