Qlik Community

Qlik Scalability

A group dedicated to advancing QlikView's scalability and performance. In this group we will share knowledge on how to perform load tests of Qlikview.

Highlighted
Not applicable

I am getting this error en QMC but in my computer works fine

Error: ErrorSource: OraOLEDB, ErrorMsg: ORA-01858: a non-numeric character was found where a numeric was expected qlikview.

VCTR_DSTRB_SRVC_HIER_V:

SQL

select

VDN_SRVC_KY,

VDN_KY,

ACD_ID,

VDN_ID,

CALL_CTR_PBX_SRC_LOC_NM,

VDN_NM,

VDN_DN,

BEGIN_EFF_DT,

END_EFF_DT,

VDN_SRVC_NM,

ACT_REC_FG

FROM ITR23.VCTR_DSTRB_SRVC_HIER_V;

The error do not make sence i not making any calculation and the query is working fine in an Oracle client.

Tags (1)
4 Replies
phaneendra_kunc
Valued Contributor III

Re: I am getting this error en QMC but in my computer works fine

are you using any where statements with Date filtering? if not

can you comment these two columns and see if that pulls the data?

BEGIN_EFF_DT,

END_EFF_DT,

if it pulls the data the try converting these two columns to TO_CHAR something like below.

TO_CHAR(BEGIN_EFF_DT, 'YYYY-MM-DD')

Not applicable

Re: I am getting this error en QMC but in my computer works fine

Nop, there you can see the query

phaneendra_kunc
Valued Contributor III

Re: I am getting this error en QMC but in my computer works fine

Can you comment one by one filed and load the table though QMC to identify which filed is causing that error.

i am assuming may be one of those fields data type is wrong.

MVP
MVP

Re: I am getting this error en QMC but in my computer works fine

Hi Alfredo,

is this an Oracle View? You could probably look into the SQL query of the view and the underlying data to find out more..

- Ralf