Error message while validating Calculation View created using CE Functions

[Former Member]

Hi,

I created a Calculation view consisting of 2 Attribute Views. The intent is to union a column and output the value. However when I try to validate the view I get the following error message.

The following is the script I have used

av1 = CE_JOIN_VIEW("ATTRIBUTEVIEW1",["COLUMNNAME"]);

av2 = CE_JOIN_VIEW("ATTRIBUTEVIEW2",["COLUMNNAME"]);

var_out = CE_UNION_ALL(:av1, :av2);

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: invalid table name:  Could not find table/view ATTRIBUTE_VIEW1 in schema YOGENDRA: line 4294967295 col 4294967295 (at pos 4294967295)nSet Schema DDL statement: set schema "SCHEMA_NAME"nType DDL: create type "_SYS_BIC"." PACKAGE/CALCULATION_VIEW/proc/tabletype/VAR_OUT" as table ("COLUMNNAME" VARCHAR(5))nProcedure DDL: create procedure "_SYS_BIC"." PACKAGE/CALCULATION_VIEW/proc" ( OUT var_out "_SYS_BIC"." PACKAGE/CALCULATION_VIEW/proc/tabletype/VAR_OUT" ) language sqlscript sql security definer reads sql data as  n /********* Begin Procedure Script ************/ n BEGIN nnav2 = CE_JOIN_VIEW("ATTRIBUTEVIEW1",["COLUMNNAME"]);nav2 = CE_JOIN_VIEW("ATTRIBUTEVIEW2",["COLUMNNAME "]);nvar_out = CE_UNION_ALL(:av1, :av2);nnEND /********* End Procedure Script ************/nVersion: 77n

Both views belong to the same schema. Please let me know if I am missing any setting/configuration. Any help is appreciated.

yogi

[vairma · Accepted solution]

Hi Yogesh,

Try to give whole path like as mentioned below..

av1 = CE_JOIN_VIEW("_SYS_BIC"."tmp.xxx/ATTRIBUTEVIEW1",["COLUMNNAME"]);

av2 = CE_JOIN_VIEW("_SYS_BIC"."tmp.xxx/ATTRIBUTEVIEW2",["COLUMNNAME"]);

Hope this help..

Best Regards,

Vaibhav

[Former Member · Accepted solution]

Hi Vibhav,

I have tried the process in 2 ways.

1. While creating the calc view, I selected the default schema to be 'MYSCHEMA' in which case I would not have to provide the schema name in the script

2. I selected the default schema as SYSTEM and prefixed my view with my schema name. "MYSCHEMA"."PKG/ATTRIBUTEVIEW/"

Both of them are giving me the same error message.

yogesh

[vivekbhoj · Accepted solution]

Hi Yogesh,

As Vaibhav mentioned above give full path of View.

Check for generated column view in _SYS_BIC schema for the attribute View and use that, then it will work

For Eg:

varr_out =  CE_JOIN_VIEW("_SYS_BIC"."m123/EMPSAL",["COMPETANCY","SALARY"]);

Regards,

Vivek

[vivekbhoj · Accepted solution]

In your case try out

var_out =  CE_JOIN_VIEW("_SYS_BIC"."PKG/ATTRIBUTEVIEW",["COLUMN"]);

For every View created in HANA, a Column View is generated that is accessed by reporting tools.

Regards,

Vivek

[Former Member · Accepted solution]

thank you..... I removed my schema name and added "_SYS_BIC" instead and it worked. Thank you for all your help.

yogesh