Symptom
- In the Earlywatch Alert(EWA) the following index is found to be missing: /BI0/ACCMSYSDA00~0
- When trying to create the index in SE14 or DBACOCKPIT/DB02 the following error is returned:
CREATE UNIQUE INDEX '/BI0/ACCMSYSDA00~0' on '/BI0/
('REQUEST',
'DATAPAKID',
'RECORD')
ALLOW REVERSE SCANS
SQL0270N Function not supported (Reason code = "1"). SQLSTATE=42997
DDL time(___1): .........5 milliseconds
The SQL statement was not executed
Index could not be created completely in the database
Index /BI0/ACCMSYSDA00-0 could not be created
Request for /BI0/ACCMSYSDA00 could not be executed
Read more...
Product
SAP Solution Manager 7.1
Keywords
red, object, same index, primary, SMIGR_CREATE_DDL, DataStore Object, 0CCMSYSDA, , KBA , BC-DB-DB6-DBA , Database Administration , 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.