Skip to Content
0
Apr 21, 2009 at 09:45 AM

ORA-02158: invalid CREATE INDEX option error message in SM21

2125 Views

Hi BI experts,

I receive this ORA-02158: invalid CREATE INDEX option error message in tcode SM21 on a daily basis. It doesn't produce a short-dump and the cubes are perfect ie. no problem with the data loads as well as the indexes.

The documentation for system log message says :

Access to the database system has returned an SQL code indicating that

the operation could not be performed correctly by the database system.

This system log entry shows the database text for the SQL error that

has occurred. It supplements the preceding system log entry, which

shows the SQL code, the table name and the SQL function where the error

has occurred.

Any clue why this happens? If so, what should I do to eliminate this error message.

I'm on BI7.0 SAPKW70018 by the way.

Thanks,

Anthony