SAP Knowledge Base Article - Preview

2988645 - Invalid schema name error when creating logical indexes for BW

Symptom

  • In Solution Manager, you are attempting to get a rating for JAVA systems running on HANA Database by following steps KBA 1824881 Summary of Grey Rated Early Watch Alert (EWA) Reports
  • During this process the error below occurs:

    No performance data is returned from BW InfoCube. Infocube: 0SMD_MPEH

  • You then attempt to create logical indexes for BW providers
  • This fails with the error "invalid schema name: <schema_name>" (schema_name is lower case)
    EppAction=RSDDB_LOGINDEX_CREATE, StatementExecutionID=1687792152441259
    2020-09-14 09:49:11.567214 e CubeHandler CubeSchema.cpp(06220) : ScenarioWrapper::executeSqlStatements: invalid schema name: sap<sid>: line 1 col 20 (at pos 19)
    at ptime/query/checker/check_cube.cc:64
  • In HANA Studio, you have created a schema mapping as per Define Schema Mapping but issue persists


Read more...

Environment

  • SAP HANA, platform edition;

Product

SAP HANA, platform edition all versions ; SAP Solution Manager 7.2

Keywords

SAP HANA, platform edition, sap_hana, database, db, saphana, Solman, table config for index , KBA , HAN-DB-ENG-BW , SAP HANA BW Engine , BW-BEX-OT-DBIF , Interface to Database , SV-SMG-SER-EWA , EarlyWatch Alert , 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.