Business Analytics Connect, learn and share with over 10000 users across the IBM Business Analytics. Join / Log in
have you checked used functions and filters?
This error is most likely caused by an invalid data type comparison.
As others have suggested, there is at least one expression that ORACLE is trying type convert a value to a numeric type and failing.
This could be an implicit data type conversion, where you have a column reference, string expression or literal value, which ORACLE is trying to convert to a numeric type.
select 1 from dual where 'abc' > 123
select 1 from dual where 'abc' + '123' = 22
Typically you will start by looking at the SQL statement being sent to ORACLE, and review expressions. Should a "table" referenced in the statement be a view, then you would need to review the view definition, in case the expression is there.
These are the typical scenarios to check first.