2607883 - Checking Column View and Calculation Scenario Errors in BW Queries

When running a Bex query, calling an F4 help (LOV, input help) or extracting data from a BW InfoProvider errors occur on the HANA database.

• Instantiation of calculation model failed, exception 306002
• Instantiation of calculation model failed;exception 306105: Invalid query.
• Error 2.048 has occurred in the BWA/SAP HANA server: Creation of column view for <BW object> failed
• Error 34.023 has occurred in the BWA/SAP HANA server
• EC:2048 column store error: fail to create scenario: [34011] Inconsistent calculation model"
• Error 2,949 has occurred in the BWA/SAP HANA server
• Error 2,981 has occurred in the BWA/SAP HANA server
• Error 34.051 when display data of composite provider
• Error 2.434 has occurred in the BWA/SAP Hana Server
• Error 34.011 has occurred in the BWA/SAP HANA server (DBMAN-901)
  "Inconsistent calculation model;scenario -> MetadataProvider
• Error 2999 has occured in the BWA/SAP HANA server: Search on olapIndex failed, QueryId: < >,
• general error (no fuirther information available); Failed to lookup path '$transient_path, J1IOBJ1'. calcEngine...
• Error 34.023: Instantiation of calculation model failed;exception 306105: Invalid query. Failed to find 'object' at node 'JOIN'
• view or procedure invalidated;table or view name = 0BW:BIA:xxx:<provider_technical_name>
• table does not exists;SAPHANADB:0BW:BIA:<provider_technical_name>
• table does not exists;SAPHANADB:0BW:BIA:<characteristic_technical_name>_F4
• Error 5,519 has occurred in the BWA/SAP HANA server
• ...

Errors captured in the indexserver trace:

• The following errors occurred: Index does not exist;Failed to get CalcIndex 'SAPSR3:0BW:BIA:xxxx (t -1)' (2007) 
• Error during executing SQL statement (2116): CREATE COLUMN VIEW "SAPxxx"."0BW:BIA:BI0_0Q0000####_oi" WITH PARAMETERS (DESCRIPTION='', INDEXTYPE=5, JOININDEX = "SAPxxx"."/BIC/Axxxxxx00", JOININDEXTYPE = 1, VIEWATTRIBUTE =, CHARACTERISTIC=('SID', SIDATTRIBUTE="SID"), ISMEMORYINDEX=1, OPTIMIZEMETAMODEL=1): sql syntax error: incorrect syntax

Runtime information in almost all of these looks like this:

• Error in BW: _HCPR_PROCESS-3-
• An error occurred when getting data from the processor.
• Information >> Row: 59 Inc: MAP_TREX_EXCEPTION Prog: CL_RSDRH_TREX_STORAGE

Read more...

• SAP NetWeaver 2004
• SAP NetWeaver 7.0
• SAP NetWeaver 7.3
• SAP NetWeaver 7.4
• SAP NetWeaver 7.5
• SAP enhancement package 1 for SAP NetWeaver 7.0
• SAP enhancement package 1 for SAP NetWeaver 7.3
• SAP enhancement package 2 for SAP NetWeaver 7.0
• SAP enhancement package 3 for SAP NetWeaver 7.0
• SAP BW/4HANA - All Versions

SAP BW/4HANA all versions ; SAP NetWeaver 2004 ; SAP NetWeaver 7.0 ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5 ; SAP enhancement package 1 for SAP NetWeaver 7.0 ; SAP enhancement package 1 for SAP NetWeaver 7.3 ; SAP enhancement package 2 for SAP NetWeaver 7.0 ; SAP enhancement package 3 for SAP NetWeaver 7.0

BRAIN 670, DBMAN 305 navigation attribute, 34.023, 3060002, 2949, _HCPR_PROCESS-3-, CL_RSDRH_TREX_STORAGE, MAP_TREX_EXCEPTION, 2881, 2,981, 1,699, 1699, function is not implemented, _SID, calcEngine search on olapIndex failed, 0BW:BIA:BI0, GET_FILTER_VALUES_CHA:03, function is not implemented, Failed to insert requested attribute, calcEngine search on olapIndex, 0Q, temporary, column store error, CL_SQL_STATEMENT, EXECUTE_QUERY, search table error, $transient_path, 2.018, DBMAN-901, calculation model, Error 34.051 has occurred, upgradeError 34.051 has occurred in the BWA/SAP HANA server, Error 34051 has occurred in the BWA/SAP HANA server, Error 34051 has occurred, 34.051, 34051 , KBA , BW-BEX-OT , OLAP Technology , BW-BEX-OT-OLAP , Analyzing Data , BW-BEX-OT-DBIF , Interface to Database , BW4-AE-CORE , Core Services , BW-BEX-OT-F4 , MasterData read services , BW-BEX-OT-MDX , MDX,OLAP-BAPI,OLE DB for OLAP , BW4-AE-F4 , MasterData Read Services , BW-BEX-OT-HCPR , CompositeProvider Query , BW4-AE , Analytic Engine , How To