EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB46408: In MicroStrategy Analytics Enterprise running against SAP HANA 1.0 SP7, ATAN2 function fails when used with the sum function over more than 200000 rows with the error "....Error executing physical plan: exception 6900:......"


Community Admin

• Strategy


Introduction
SAP Hana 1.0 SP7 is post-certified as a warehouse in Strategy Analytics Enterprise Intelligence Server 9.4.1 running on Windows and Linux operating systems. Refer to the following Strategy Knowledge Base document for further details.
KB46356: Support of SAP HANA 1.0 SP7 with MicroStrategy Analytics Enterprise 9.4.1 on Windows and Linux Operating Systems
 
SYMPTOM
In Strategy Analytics Enterprise 9.4.1, the following error is received against SAP HANA 1.0 SP7, when the report uses a metric which uses the ATAN2 function along with the sum function. This issue is only seen in cases where the table being accessed has more than 200,000 rows.


Could not execute 'select sum (1) + ATAN2(0.3,0.4) WJXBFS1 from "EAT_WH4"."ORDER_FACT"' in 153 ms 5 µs .
SAP DBTech JDBC: [2048]: column store error: search table error:  [6900] Error executing physical plan: exception 6900:
AttributeEngine/Parallel/Evaluator.cpp:94 Attribute engine failed; $function$=createEvaluator; $message$=input $$place_holder_0$$ unknown; $message$=input $$place_holder_0$$ unknown ,in executor::Executor in cube: EAT_WH4:0x7f86b2bea600:0

 
CAUSE
This error is because of an issue with SAP HANA 1.0 SP7.
 
ACTION
Follow up with SAP HANA support regarding this issue. The SAP support incident number corresponding to this issue is: Incident 232030 / 2014
 
WORKAROUND
ATAN2(n,m) produces the same result as ATAN(n/m). The issue is not seen when using the ATAN(n/m) function.


Comment

0 comments

Details

Knowledge Article

Published:

June 5, 2017

Last Updated:

June 5, 2017