2272874 - EarlyWatch Alert for HANA: Error 258 performing OPC

Symptom

You are using SAP HANA Database and see in the System Log entries like: ,sql error 258 performing OPC' at certain times in the morning.

Other Terms

HANA, EarlyWatch Alert, /SDF/GET_HANA_TABLE

Reason and Prerequisites

The Data Collector of the EarlyWatch Alert for the HANA Database has not the enough permission to read some Views.

Solution

Assign to the user under which the Data Collection takes place the read permissions on the following views:
_sys_repo.change_entries
_sys_repo.package_catalog
_sys_repo.changes
_sys_repo.active_object
_sys_repo.package_catalog
_sys_repo.inactive_object
and
"SAP_XS_LM"."sap.hana.xs.lm.db::CONFIGURATION_VIEW"
"SAP_XS_LM"."sap.hana.xs.lm.db::SYSTEM_VIEW"
"SAP_XS_LM"."sap.hana.xs.lm.db::TRANSPORT_ROUTE_VIEW"
"SAP_XS_LM"."sap.hana.xs.lm.db::PRODUCTS"
"SAP_XS_LM"."sap.hana.xs.lm.db::PROCESS_VIEW"

Header Data

Released On	28.01.2016 17:45:46
Release Status	Released for Customer
Component	SV-SMG-SER SAP Support Services
Priority	Correction with medium priority
Category	Program error