topic Direct Discovery Query Error -- ORA-00911 in QlikView

Direct Discovery Query Error -- ORA-00911

Thu, 10 Mar 2016 17:07:50 GMT

Hi All,

I'm doing nothing more than pulling straight table from oracle through direct discovery but it is resulting in error.

SQL##f - SqlState: S1000, ErrorCode: 911, ErrorMsg: [Oracle][ODBC][Ora]ORA-00911: invalid character

CMNT:

DIRECT QUERY

DIMENSION

VAL1 AS FLAG,

VAL2

FROM SCHEMA1.TABLE1

Please suggest me!

Thanks,

Vinod Kumar V

Re: Direct Discovery Query Error -- ORA-00911

Clever_Anjos — Thu, 10 Mar 2016 17:17:24 GMT

Oracle/PLSQL: ORA-00911

Re: Direct Discovery Query Error -- ORA-00911

Clever_Anjos — Thu, 10 Mar 2016 17:18:20 GMT

It would be easir if you post your actual query

Re: Direct Discovery Query Error -- ORA-00911

Thu, 10 Mar 2016 18:06:58 GMT

$(Include=..\oracleconnection.txt);

CMNT:

DIRECT QUERY

DIMENSION

VAL1 AS FLAG,

VAL2 AS COMNT,

USERNAME,

VALUE AS TRANSACTION_NAME

FROM PWI_PROFILER.BWISEDOSPOC2_SELECTION, PWI_PROFILER.BWISEDOSPOC2_DE

WHERE PWI_PROFILER.BWISEDOSPOC2_SELECTION.DE_ID = PWI_PROFILER.BWISEDOSPOC2_DE.ID AND PWI_PROFILER.BWISEDOSPOC2_DE.USERNAME<>'test';

This is my query. query is working absolutely fine when i try to run it from my desktop but it is failing in server.