Error while activating Calculation View

[Former Member]

Hi,

I am trying to activate a very simple calculation view (using sql script) but it is failing with column store error - 34053. I tried different tables and schemas but still get the same error.

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

MDXRuntime: Internal deployment of object failed: Internal Error:Deploy Calculation View: SQL: column store error: [34053] failed to save calculation scenario : The following errors occured: Could not create repository entry for scenario (34053)nDetails (Warnings):n- CalculationNode (139206) -> attributes: No attributes found.nnnSet Schema DDL statement: set schema "EFashion"nType DDL: create type "_SYS_BIC"."efashion/CV_SCRIPT/proc/tabletype/VAR_OUT" as table ("ARTICLE_ID" INTEGER, "COLOR_CODE" INTEGER)nProcedure DDL: create procedure "_SYS_BIC"."efashion/CV_SCRIPT/proc" ( OUT var_out "_SYS_BIC"."efashion/CV_SCRIPT/proc/tabletype/VAR_OUT" ) language sqlscript sql security definer reads sql data as  n /********* Begin Procedure Script ************/ n BEGIN n t var_out = SELECT article_id, color_code t          FROM shop_facts;nnEND /********* End Procedure Script ************/nVersion: 62n

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

I'll appreciate any inputs on this.

Regards,

Vimal

[patrickbachmann]

Hi Vimal, since you are just doing a test using the EFASHION content can you post the actual SQLScript you are using here?  It might help to spot the problem.  Thanks.

[Former Member]

Hi Patrick,

Below is the script .. I've tested the same script through SQL editior (with Schema name before table name) and it works fine. I am sure I was able to activate calculation views before and somehow it just stopped working!

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

BEGIN

    var_out =

SELECT article_id, color_code FROM shop_facts;

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

Thannks,

Vimal Shah

[Ravi_Channe]

Hi Vimal,

Might be a stupid question, but did you define your OUTPUT structure matching exactly with the columns article_id and color code. Secondly which of the columns are you planning to use as measure ?

Regards,

Ravi

[Former Member]

HI Ravi,

This is just a test calculation view. I've defined article_id as an attribute and color_code as a measure. I also cross checked the output datatype matches with the column table. Digging deeper into this issue,  it seems that this error shows up due to resulting procedure is not getting compiled and SAP HANA is not able to store it under _SYS_BIC schema. This issue just started. Even if i try to redeploy existing calculation view i get this error. May be some kind of access issue... not sure..

Regards,

Vimal Shah