Error: ErrorSource: OraOLEDB, ErrorMsg: ORA-01858: a non-numeric character was found where a numeric was expected qlikview.
The error do not make sence i not making any calculation and the query is working fine in an Oracle client.
are you using any where statements with Date filtering? if not
can you comment these two columns and see if that pulls the data?
if it pulls the data the try converting these two columns to TO_CHAR something like below.
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.