SAP Knowledge Base Article - Preview

2779137 - HANA: Database error 258 at OPC in SM21 when accessing table "sap.hana.xs.lm.usage.db::SUSAGE"

Symptom

After implementing note 2182722 in Solution Manager, which provide enhancement for HANA usage data collection,

you may find following error shown in the system log (transaction code: SM21):

<SID> Database: Database error 258 at OPC
insufficient privilege: Not authorized

From the corresponding work process trace file (dev_w* in transaction code ST11), you could see following content:

Connect to <SID> as <user_name> with XXXX
...
SQLCODE : 258
SQLERRTEXT : insufficient privilege: Not authorized
...
select PPMSPV,FEATURE,TYPE,SUBTYPE,CALENDAR_MONTH AS MEASURE_MONTH,TRAFFIC,NORM from "SAP_XS_USAGE"."sap.hana.xs.lm.usage.db::SUSAGE" where CALENDAR_MONTH = CONCAT(YEAR(ADD_MONTHS(CURRENT_UTCDATE,-1)),LPAD(MONTH(ADD_MONTHS(CURRENT_UTCDATE,-1)),2,'0'));
***LOG BY2=> sql error 258 performing OPC [dbds 495]
***LOG BY0=> insufficient privilege: Not authorized [dbds 495]

Read more...

Environment

HANA 1.0: SPS12 or later

HANA 2.0: All SPS

Product

SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0 ; SAP Solution Manager 7.1 ; SAP Solution Manager 7.2

Keywords

Database error 258 at OPC, sap.hana.xs.lm.usage.db::SUSAGE, Solution Manager, sap.hana.admin.roles::SolutionManagerMonitoring , KBA , HAN-DB , SAP HANA Database , SV-SMG-SER-RFW , Report Framework BI SelfService , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.