SAP Knowledge Base Article - Preview

2670747 - HCO_HBA_R_SB_CORE deployment errors in HANA 2 SP3+

Symptom

When attempting to deploy HCO_HBA_R_SB_CORE on a HANA 2 SP03 backend, the following error is given:

Content error: Repository: Encountered an error in repository runtime extension;Model inconsistency. Deploy Calculation View: SQL: inconsistent datatype: lob type comparison: line 4 col 400 (at pos 737)
Set Schema DDL statement: set schema "SYSTEM"
Type DDL: create type "_SYS_BIC"."sap.hba.r.sb.core.v/GET_HANA_USERS_WITH_SELECTED/proc/tabletype/VAR_OUT" as table ("NAME" NVARCHAR(256), "OBJECT_NAME" NVARCHAR(512))
Procedure DDL: create procedure "_SYS_BIC"."sap.hba.r.sb.core.v/GET_HANA_USERS_WITH_SELECTED/proc" ( IN P_EVALUATION_ID NVARCHAR(512), OUT var_out "_SYS_BIC"."sap.hba.r.sb.core.v/GET_HANA_USERS_WITH_SELECTED/proc/tabletype/VAR_OUT" ) 

language sqlscript sql security definer reads sql data as
/********* Begin Procedure Script ************/
BEGIN
granted_users = select G."GRANTEE" as "NAME",G."GRANTEE_TYPE" as "TYPE",G."OBJECT_NAME" as "OBJECT_NAME",S."OPERAND" as "ID" from "SYS"."GRANTED_PRIVILEGES" as G left outer join "SYS"."STRUCTURED_PRIVILEGES" as S on (S."STRUCTURED_PRIVILEGE_N

With HCO_HBA_R_SB_CORE patch 13, the error appears as follows:

Activation of at least one object failed
Object: sap.hba.r.sb.core.v.AUTHORIZED_COUNT_FOR_EVALUATION.calculationview ==> Error Code: 40117
Repository: Encountered an error in repository runtime extension;Model inconsistency. Deploy Calculation View: SQL: invalid datatype: "S.OPERAND" LOB type in GROUP BY clause: line 4 col 285 (at pos 593)

Set Schema DDL statement: set schema "SYSTEM"

Type DDL: create type "_SYS_BIC"."sap.hba.r.sb.core.v/AUTHORIZED_COUNT_FOR_EVALUATION/proc/tabletype/VAR_OUT" as table ("AUTHORIZED_COUNT" INTEGER, "EVALUATION_ID" NVARCHAR(512))

Procedure DDL: create procedure "_SYS_BIC"."sap.hba.r.sb.core.v/AUTHORIZED_COUNT_FOR_EVALUATION/proc" ( OUT var_out "_SYS_BIC"."sap.hba.r.sb.core.v/AUTHORIZED_COUNT_FOR_EVALUATION/proc/tabletype/VAR_OUT" )

language sqlscript sql security definer reads sql data as

/********* Begin Procedure Script ************/

BEGIN
var_out = select COUNT(*) as "AUTHORIZED_COUNT", TO_NVARCHAR(S."OPERAND") as "EVALUATION_ID" from "PUBLIC"."GRANTED_PRIVILEGES" as G inner join "PUBLIC"."STRUCTURED_PRIVILEGES" as S on (S."STRUCTURED_PRIVILEGE_NAME" = G."OBJECT_NAME") WHERE S."

Read more...

Environment

  • HANA 2 SP03
  • Smart Business for Suite on HANA

Product

SAP Smart Business all versions

Keywords

SSB SOH, CAR, HCOHBARSBCORE03P_12-20012110.ZIP, HCOHBARSBCORE03P_13-20012110.ZIP , KBA , fiori , kpi , CA-GTF-SB-SOH , Smart Business for SoH , BC-XS-ADM , Admin Tools , HAN-AS-XS , SAP HANA Extended Application Services , HAN-DB , SAP HANA Database , 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.