Symptom
One of the following symptoms occur when using LargeString or LargeBinary attributes in a dimension of SAP Datasphere Analytic Model:
When deploying an Analytical Model in Datasphere an error message appears:
- The deploy fails:
"The deployment of AM was unsuccessful.
Error(s): Failed to execute a database statement for Artifact XX of type column store error: fail to create scenario: [34011] Inconsistent calculation model;calculationNode (finalNode) -> operation (SemanticQueryOp): semanticQuery doesn't support the lob datatype of attribute XX ,Details (Errors): - calculationNode (finalNode) -> operation (SemanticQueryOp): semanticQuery doesn't support the lob datatype of attribute XX [...]"; - A warning appears: "Attribute type from attribute " " in dimension source " " is not supported:
- In the preview the attributes are not present:
- Attributes are not visible as "Dimensions" in SAC while creation of SAC story.
Read more...
Environment
SAP Datasphere
Product
SAP Datasphere all versions
Keywords
LargeBinary, LargeString, LOB, attribute, preview, A SQL error happened. For details you could check on the SQL-Error-Code: 264 - invalid datatype, "cds.LargeBinary","cds.LargeString","hana.CLOB","cds.hana.CLOB", dwc , KBA , DS-MD-AM , Analytic Model , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.