DV 5.5 : [nQSError: 17001] ORA-00923: FROM keyword not found where expected
(Doc ID 2662864.1)
Last updated on APRIL 15, 2021
Applies to:Oracle Analytics Server - Version 5.5.0 and later
Information in this document applies to any platform.
On : 5.5.0 version, Analytics DV
Navigate to Data-connections-> create a test connection
select to enter the SQL manually and paste this query
select DEPARTMENTS.department_name, DEPARTMENTS.manager_id, EMPLOYEES.email
From HR.DEPARTMENTS, HR.EMPLOYEES
HR.DEPARTMENTS.DEPARTMENT_ID = HR.EMPLOYEES.DEPARTMENT_ID
notice no results are shown. the query sent to the database from
the obis1-diagnostic.log :
Description: At OCI call OCIStmtExecute
SAWITH0 AS (select T1000001.DEPARTMENT_NAME as c1,
T1000001.EMAIL as c2,
T1000001.MANAGER_ID as c3
(select DEPARTMENTS.department_name, DEPARTMENTS.manager_id,
HR.EMPLOYEESWHEREHR.DEPARTMENTS.DEPARTMENT_ID = HR.EMPLOYEES.DEPARTMENT_ID)
select D1.c1 as c1, D1.c2 as c2, D1.c3 as c3, D1.c4 as c4 from ( select 0 as
D101.c1 as c2,
D101.c2 as c3,
D101.c3 as c4
SAWITH0 D101 ) D1 where rownum <= 101
the error message from the manage sessions log is :
SET VARIABLE QUERY_SRC_CD='Visual
FETCH FIRST 101 ROWS ONLY
/* AdditionalDetail='VisualAnalyzer' */
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A
general error has occurred. (HY000)
State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS.
State: HY000. Code: 17001. [nQSError: 17001] Oracle Error code: 923, message:
ORA-00923: FROM keyword not found where expected at OCI call OCIStmtExecute.
State: HY000. Code: 17010. [nQSError: 17010] SQL statement preparation
Upgraded to DV 5.5 version
It works fine in DV 5.4 version
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document