2481738 - Create Index /BI0/ACCMSYSDA00-0: SQL0270N Function not supported | SAP Knowledge Base Article

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 with DB2 Universal Database , 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.