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