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

[#1]

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.

[phaneendra_kunc]

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')

[#3]

Nop, there you can see the query

[phaneendra_kunc]

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.

[rbecher]

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