AnalyticView Error

[Former Member]

Hi,

When i am trying to activate analytic view it always throws an exception like

"Large object data type check rule".

Please Find error message in attached screenshot.

Regards,

Harish

[Former Member]

HI Harish,

As mentioned in error log....the error is due to different datatype in joining condition....

Here EID_Dept is of integer type & other EDEPT is Nvarchar. So can you please check it again....

As per my understanding it is due to that....BLOB datatype is not supported for your view ,this might be due to following restrictions:-

• LOB columns cannot appear in ORDER BY or GROUP BY clauses.
• LOB columns cannot appear in FROM clauses as a join predicate.
• LOB columns cannot appear in WHERE clauses as a predicate except LIKE, CONTAINS, =, or <>.
• LOB columns cannot appear in SELECT clauses as an aggregate function argument.
• LOB columns cannot appear in SELECT DISTINCT clauses.
• LOB columns cannot be used in set operations such as EXCEPT. UNION ALL is an exception.
• LOB columns cannot be used as a primary key.
• LOB columns cannot be used in CREATE INDEX statements.
• LOB columns cannot be used in statistics update statements

Please check wether in your case it comes under any of these restrictions:-

You can refer following link:

http://help.sap.com/hana/html/_csql_data_types.html

Thnkss

Kulwinder

[Former Member]

Hi Kulwinder,

By using these below 2 tables i am creating analytic view and i am using WELL_ID as a join key between the 2 tables. I need well_id, SUM(GAS_VOLT),SUM(GAS_VOLP) as a output attributes.

Regards,

Harish

[former_member184768]

Hi Harish,

I am quite curious to know how did you manage to define SQL data type of ST_POINT which is of GEOMETRY column store data type.

So far, no such data type has been defined at http://help.sap.com/hana/html/_csql_data_types.html

It is possible for you to create another table without LOCATION and try building your view. I am not sure of the ST_POINT data type is supported currently.

Regards,

Ravi

[rindia]

Hi Harish,

In the analytic view check the join(s) you made as it might be between two different data types.

Also BLOB data type, and some other, in view is not supported if selected as one of the attributes.

If this does not work and joins are of same data type, could you please send the data types for all the joins.

    

Regards

Raj

[Former Member]

Hi Raj,

Thanks for your response, For join i am using NVARCHAR Datatype and filed in the both tables having

same length also.

For output attributes i am using Datatypes like DOUBLE, INTEGER and NVARCHAR.

Note: One of my table field contains ST_POINT as a  datatype, but i am not using this attribute as o/p.

Regards,

Harish