2670747 - HCO_HBA_R_SB_CORE deployment errors in HANA 2 SP3+

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."

• HANA 2 SP03
• Smart Business for Suite on HANA

SSB SOH, CAR, HCOHBARSBCORE03P_12-20012110.ZIP, HCOHBARSBCORE03P_13-20012110.ZIP , KBA , fiori , kpi , CA-GTF-SB-SOH , SoH , HAN-DB , SAP HANA Database , BC-XS-ADM , Admin Tools , HAN-AS-XS , SAP HANA Extended Application Services , Problem