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