SAP Knowledge Base Article - Preview

2481738 - Create Index /BI0/ACCMSYSDA00-0: SQL0270N Function not supported

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.