Skip to Content
0

Attribute is not a number

Mar 06, 2017 at 11:24 AM

311

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers