on 04-05-2016 10:22 AM
Hi Experts,
I am trying to create a calculation view with 2 tables in InnerJoin.
I added one of the columns, which is of type NCLOB, to the output and the view cannot be activated.
Error message:
"Repository: Encountered an error in repository runtime extension;Model inconsistency.
The following errors occurred: Inconsistent calculation model (34011)
Details (Errors):
- calculationNode (finalAggregation) -> attributes -> attribute (<My attribute column>😞 AggregationOp doesn't support the lob datatype of attribute <My attribute column>."
Please help on how I can bring the data to output.
Thanks and Regards,
Sarath Gopal
Hi Sarath,
Check in the semantics what is the type of your NCLOB column
Looks like you have assigned the type Measure to it.
We cannot do aggregation operation on NCLOB, CLOB ,TEXT datatypes.
So you can keep the type as Attribute and activate the view,Let me know if you still face issues
Regards
Priyanka
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I created a calculation view with final node as "aggregation" as I want to get the distinct values from this view. When I add CLOB columns into projection I get this error
AggregationOp doesn't support the lob datatype of attribute CLOB_TEXT(calculationNode (finalAggregation) -> attributes -> attribute (CLOB_TEXT))
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.