Am trying to implement direct discovery on qlikview 11.2 sr5. My underlying table is in Oracle and am connecting via ODBC connection.
The direct query loads fine and after the reload, when I try to make a selection to see D/D in action, it fails saying Direct query failed(table box) and database connection failed(for a chart with dimension and expression as count(measure))..as shown in the attached image
I ran a trace on the ODBC and see this statement as a SQL ERROR and another statement as shown below with a invalid identifier message, when selecting a value in the dimension..
| X ODBC 9b0-2420 | ENTER SQLSetStmtAttrW |
| | SQLHSTMT 0x0000000005BCF3F0 |
| | SQLINTEGER 4 <SQL_ATTR_ASYNC_ENABLE> |
| | SQLPOINTER 1 <SQL_ASYNC_ENABLE_ON> |
| | SQLINTEGER -6 |
| X ODBC 9b0-2420 | EXIT SQLSetStmtAttrW with return code -1 (SQL_ERROR) |
| | SQLHSTMT 0x0000000005BCF3F0 |
| | SQLINTEGER 4 <SQL_ATTR_ASYNC_ENABLE> |
| | SQLPOINTER 1 <SQL_ASYNC_ENABLE_ON> |
| | SQLINTEGER -6 |
| | DIAG [S1C00] [Oracle][ODBC]Driver not capable. (0) |
Also, this is the logged text when I make a selection..
X ODBC 2a58-2024 ENTER SQLExecDirectW
HSTMT 0x0000000005D8F3F0
WCHAR * 0x000000000246ED18 [ -3] "SELECT COUNT("EVENT") FROM "TEMP" WHERE "MONITORING_TYPE" IN ( "a" )\ 0"
SDWORD -3
X ODBC 910-24c4 EXIT SQLErrorW with return code 0 (SQL_SUCCESS)
HENV 0x00000000008E89E0
HDBC 0x00000000008E8AB0
HSTMT 0x0000000005C9F3F0
WCHAR * 0x0000000002502C18 [ 5] "S0022"
SDWORD * 0x000000000012EA68 (904)
WCHAR * 0x00000000025DC458 [ 158] "[Oracle][ODBC][Ora]ORA-00904: "a": invalid identifier\ a\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0"
SWORD 2047
SWORD * 0x000000000012EA00 (158)
X ODBC 2a58-2024 EXIT SQLExecDirectW with return code -1 (SQL_ERROR)
HSTMT 0x0000000005D8F3F0
WCHAR * 0x000000000246ED18 [ -3] "SELECT COUNT("EVENT") FROM "TEMP" WHERE "MONITORING_TYPE" IN ( "a" )\ 0"
SDWORD -3
DIAG [S0022] [Oracle][ODBC][Ora]ORA-00904: "a": invalid identifier
(904)
Any thoughts...?? Ideas?? to make this thing work..
Message was edited by: Sagar Addepalli
