2494986 - Invalidated view: system-local.SAPERP.xxx.METADAT A::PRIMARY

Testing the BW search in the RSOS_SEARCH or RSOSM transaction you will facing one or more of below syptoms:

Unable to fetch result

Error in program CL_RSOS_UTILITIES=============CP (Include CL_RSOS_UTILITIES=============CM005, source position 25)
invalidated view: system-local.SAPERP.TRFN.METADAT A::PRIMARY: line 1 col 8310 (at pos 8309)
Error in program CL_SQL_STATEMENT==============CP (Include CL_SQL_STATEMENT==============CM004, source position 36)

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.AAOE.ME
Error in program CL_SQL_STATEMENT==============CP (Include CL_SQL_STATEMENT==============CM00L, source position 3)

Other errors that might occur:

SQLCODE : 391
SQLERRTEXT : invalidated view: system-local.SYSTEMID.ADSO.METADATA::PRIMARY: 
***LOG BY2=> sql error 391 performing OPC [dbds 451]
***LOG BY0=> invalidated view: system-local.SYSTEMID.ADSO.METADATA::PRIMARY: [dbds 451]
*** ERROR => prepare() of C_0786, rc=1, rcSQL=391 [dbsdbsql.cpp 3615]
*** ERROR => PREPARE C_0786 on connection 0, rc=391

When trying to recreate the invalid view manually, the below error might occur:

SAP DBTech JDBC: [260]: invalid column name

Error when managing ADSO in BW Cockpit:

error
Not Found
DB-views of DSO 'Not Found' are not up to date. Please run 'RSDG_ADSO_ACTIVATE'

• SAP NetWeaver 7.3
• SAP NetWeaver 7.4
• SAP NetWeaver 7.5
• SAP enhancement package 1 for SAP NetWeaver 7.3
• SAP enhancement package 1 for SAP NetWeaver 7.5
• SAP BW/4HANA

Business Warehouse, BW, 7.31, 7.4, 7.5, 7.51, BW/4H, BW Search, CL_RSOS_UTILITIES=============CP, CL_RSOS_UTILITIES=============CM005, CL_RSOS_UTILITIES, invalidated view: system-local.bw. bwsearch.SAPHANADB.AAOE.ME, Message no. RSOS_SEARCH000, not visible, Modeling tools, MT, create objects, ADSO.METADATA/PRIMARY, METADATA/PRIMARY, METADATA::PRIMARY, 391, invalid column name, [260], SAP DBTech JDBC , KBA , bpc11 bpc 11.0 , BW-MT , Modeling Tools (Eclipse) , BW-WHM-MTD-SRCH , BI Search , Problem