SAP Knowledge Base Article - Preview

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

Symptom

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

2017-06-26_15-19-48.jpg

 

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


Read more...

Environment

  • 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

Product

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

Keywords

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

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.