When search query by any keyword when create a model based on a BW or S4HANA live connection, no data is shown.
SAP Analytics Cloud
Reproducing the Issue
- Create a live mode in SAC.
- Select System Type: SAP BW.
- Select a BW or S4HANA live connection.
- Click the value help for Data Source.
- Input any value and click "Search" icon, no data.
- Run RSOSN_SEARCH in SE38 and search by the same keyword, below error occurred:
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.SAPSR3.AINX.METADATA::PRIMARY"
Error in program CL_SQL_STATEMENT==============CP (Include CL_SQL_STATEMENT==============CM00L, source position 3)
The error is caused by invalid search views.
To resolve this issue, re-create the BW search views. This can be done for all views or for a single TLOGO object. Please refer to the solution in KBA 2494986.
In case the same situation happens for multiple TLOGO types, please switch off the BWSEARCH in RSOSM and then re-enable it, so the system can regenerate all required views and HANA objects.
KBA 2494986 Invalidated view: system-local.SAPERP.xxx.METADAT A::PRIMARY
No values, Empty result, No result , KBA , LOD-ANA-LDC-BW , SAC Live Data Connection BW , BW-WHM-MTD-SRCH , BI Search , Problem