My Oracle Support Banner

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.

Symptoms

On : 5.5.0 version, Analytics DV



http://<hostname>:<port>/dv/ui

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
WHERE
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
Oci8Status:OCI_ERROR
RequestID:682a0010
SQL Query:WITH
SAWITH0 AS (select T1000001.DEPARTMENT_NAME as c1,
T1000001.EMAIL as c2,
T1000001.MANAGER_ID as c3
from
(select DEPARTMENTS.department_name, DEPARTMENTS.manager_id,
EMPLOYEES.emailFrom HR.DEPARTMENTS,
HR.EMPLOYEESWHEREHR.DEPARTMENTS.DEPARTMENT_ID = HR.EMPLOYEES.DEPARTMENT_ID)
T1000001)
select D1.c1 as c1, D1.c2 as c2, D1.c3 as c3, D1.c4 as c4 from ( select 0 as
c1,
D101.c1 as c2,
D101.c2 as c3,
D101.c3 as c4
from
SAWITH0 D101 ) D1 where rownum <= 101

the error message from the manage sessions log is :
SET VARIABLE QUERY_SRC_CD='Visual
Analyzer',SAW_SRC_PATH='{"viewID":"DatasetPreviewTable","currentCanvas":"canva
s!1"}',DISABLE_CACHE_SEED=1,DISABLE_XSA_CACHE_SEED=1,ENABLE_DIMENSIONALITY=1;S
ELECT
0 s_0,

XSA('weblogic'.'0828747c-4d1c-46c7-9660-d215a2ec5f1a')."input"."Data"."DEPARTM
ENT_NAME" s_1,

XSA('weblogic'.'0828747c-4d1c-46c7-9660-d215a2ec5f1a')."input"."Data"."EMAIL"
s_2,

XSA('weblogic'.'0828747c-4d1c-46c7-9660-d215a2ec5f1a')."input"."Data"."MANAGER
_ID" s_3
FROM XSA('weblogic'.'0828747c-4d1c-46c7-9660-d215a2ec5f1a').input."Data"
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.
(HY000)

State: HY000. Code: 17001. [nQSError: 17001] Oracle Error code: 923, message:
ORA-00923: FROM keyword not found where expected at OCI call OCIStmtExecute.
(HY000)

State: HY000. Code: 17010. [nQSError: 17010] SQL statement preparation
failed. (HY000)







Changes

 Upgraded to DV 5.5 version

It works fine in DV 5.4 version

 

Cause

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
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.