on 03-06-2017 11:24 AM
Hi,
I have created analytic view which used in Microstrategy and created the report.
when i am running the report in microstrategy,it's showing the below error,but if i am ruuning the Same SQL in HANA it's not showing any error.
Error: SQL Generation Complete
QueryEngine encountered error: Execute Query failed.
Error type: Odbc error. Odbc operation attempted: SQLExecDirect. [S1000:339: on SQLHANDLE] [SAP AG][LIBODBCHDB SO][HDBODBC] General error;339 invalid number: [6930] attribute value is not a number;BwPopSearch pop3(SAPBIP:/BIC/AJOBCARD200en) Connection String: SERVERNODE=10.121.3.98:30015;DSN=SAP_HANA_PRD_BIP;UID=BI_DEVELOP;. SQL Statement: select a11.KUNNR KUNNR,
a14.NAME1 NAME1,
a14.DEALER_ID "CustCol_2",
a11."_BIC_ZFR_NO" "_BIC_ZFR_NO",
count(distinct a11."_BIC_ZFR_NO") WJXBFS1
from "_SYS_BIC"."BI_DEVELOP/AN_TGW" a11
join #TQ5CQNNWDMQ001 pa12
on (a11."_BIC_ZFR_NO" = pa12."_BIC_ZFR_NO" and
a11.KUNNR = pa12.KUNNR)
join "_SYS_BIC"."BI_DEVELOP/CV_COMP_ACT" a13
on (a11.COMPGRP_ACT_ID = a13.COMP_ACT_ID)
join "_SYS_BIC"."BIPHANA/DEALER_AT" a14
on (a11.KUNNR = a14.KUNNR)
where (a11.JOBTYPE_ID in ('1', '2', '12')
and a11.KILOMETER between '0' and '3500'
and a13."_BIC_ZSTATS" = 'P')
group by a11.KUNNR,
a14.NAME1,
a14.DEALER_ID,
a11."_BIC_ZFR_NO"..
Error in Process method of Component: QueryEngineServer, Project HANABIP, Job 12637, Error Code= -2147212544.
User | Count |
---|---|
82 | |
10 | |
10 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.