Skip to Content
avatar image
Former Member

NCLOB in Calculation View

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Apr 05, 2016 at 10:24 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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))