SAP HANA: ColumnTable not found

[Former Member]

Hey guys,

I get the following error if I want to activate my scripted calculation view with a CE_COLUMN_TABLE function.

Message :

  Internal deployment of object failed;Repository: Encountered an error in repository runtime extension;Internal Error:Deploy Calculation View: SQL: transaction rolled back by an internal error: column store error: [34011] failed to save calculation scenario : The following errors occured: Inconsistent calculation model (34011)

Details (Errors):

- CalculationNode ($$VAR_OUT$$): ColumnTable _SYS_BIC:sap.connectedhealth.db.analytics.pseudonymized/CV_PATIENT_PROPERTIES not found (cannot get catalog object).

Set Schema DDL statement: set schema "SYSTEM"

Type DDL: create type "_SYS_BIC"."sap.analyticsforhealth/CV_SCRIPT_USAGE/proc/tabletype/VAR_OUT" as table ("HashID" VARBINARY(32), "Gender" NVARCHAR(1), "CONTENT_3" NVARCHAR(4000), "Height" DECIMAL(4,3), "CONTENT_2" NVARCHAR(4000), "Age" INTEGER, "RegisteredOnDate" DATE, "CONTENT_1" NVARCHAR(4000), "CONTENT" NVARCHAR(4000), "Time_in_Program" INTEGER)

Procedure DDL: create procedure "_SYS_BIC"."sap.analyticsforhealth/CV_SCRIPT_USAGE/proc" ( OUT var_out "_SYS_BIC"."sap.analyticsforhealth/CV_SCRIPT_USAGE/proc/tabletype/VAR_OUT" ) language sqlscript sql security definer reads sql data as 

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

BEGIN

  var_out = CE_COLUMN_TABLE("_SYS_BIC"."sap.connectedhealth.db.analytics.pseudonymized/CV_PATIENT_PROPERTIES", ["HashID", "Gender", "CONTENT_3", "Height", "CONTENT_2", "Age", "RegisteredOnDate", "CONTENT_1", "CONTENT", "Time_in_Program"]);

END /********* End Procedure Script ************/

But if I execute a SELECT Statement in the SQL Console it works:

SELECT * FROM "_SYS_BIC"."sap.connectedhealth.db.analytics.pseudonymized/CV_PATIENT_PROPERTIES"

Thanks for your help in advance.

Kind regards

Fabian

[lbreddemann · Accepted solution]

You might want to try and re-activate both views again.

Please make sure that the _SYS_REPO user has the SELECT with GRANT privilege on the underlying schema.

Also: don't use the deprecated CE-functions anymore!