Skip to Content
0
Former Member
Nov 20, 2013 at 04:53 AM

Error message while validating Calculation View created using CE Functions

241 Views

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