SAP Knowledge Base Article - Preview

3544673 - Cannot find BW query in Open Query Dialog Box due to BW Search error

Symptom

Although a BW query can be directly run in transaction code RSRT, when searching for the query in the open query dialog box in Analysis for Office or transaction code RSRT, no results are displayed. 
Additionally, when running transaction code RSOS_SEARCH, click on "Search Metadata" button, input the query and run the metadata search, "invalidated view" error occurs.
The view name in the error can be different, such as: 

  • Unable to fetch result
    Error in program CL_RSOS_UTILITIES=============CP (Include CL_RSOS_UTILITIES=============CM005, source position 25)
    A database error occured. The error message in the  database was: "invalidated view: system-local.bw. bwsearch.SAPHANADB.ELEM.ME
    Error in program CL_SQL_STATEMENT==============CP (Include CL_SQL_STATEMENT==============CM00L, source position 3) 

  • Unable to fetch result
    Error in program CL_RSOS_UTILITIES=============CP (Include CL_RSOS_UTILITIES=============CM005, source position 25)
    A database error occured. The error message in the  database was: "invalidated view: system-local.bw. bwsearch.SAPABAP1.AINX.MET
    Error in program CL_SQL_STATEMENT==============CP (Include CL_SQL_STATEMENT==============CM00L, source position 3) 


Read more...

Environment

  • SAP NetWeaver
  • SAP BW/4HANA

Product

SAP BW/4HANA all versions ; SAP NetWeaver all versions

Keywords

SAP Analysis for Excel, AO, AFO, Open Query F4 List, F4 button for query, query missing, query not found, not visible , KBA , BW-BEX-OT-OLAP , Analyzing Data , BW-WHM-MTD-SRCH , BI Search , BW4-AE-CORE , Core Services , BW-MT , Modeling Tools (Eclipse) , 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.