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
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.