cancel
Showing results for 
Search instead for 
Did you mean: 

NCLOB in Calculation View

Former Member
0 Kudos
1,408

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

former_member185490
Participant
0 Kudos

Hi,

I have some issue and my attribute is defined as dimension not a measure. Any advice?

Former Member
0 Kudos

Hi Naresh,

Can you explian what exactly is the error?

Did your view get activated successfully?And data preview gives error?

If you doesnt need any kind of aggreagtion to be applied you can change the type of the calculation view as DIMENSION instead of CUBE

Regards

Priyanka

former_member185490
Participant
0 Kudos

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

Answers (0)