Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
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.

Labels (1)
4 Replies
phaneendra_kunc
Partner - Specialist III
Partner - Specialist III

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
Author

Nop, there you can see the query

phaneendra_kunc
Partner - Specialist III
Partner - Specialist III

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
MVP
MVP

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

Astrato.io Head of R&D