OBIEE 11g -"[nQSError: 27002] Near <->: Syntax error" Due to Parser Logic not Accepting Negative Numbers in the Member Name of IsChild or IsDescendant Functions

(Doc ID 2028701.1)

Last updated on JANUARY 30, 2017

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.7.140715 and later
Information in this document applies to any platform.

Symptoms

Using this SQL test case with northwind_vh.rpd:

select employees.FirstName, employees.employeeID from ValueHierarchy where
IsChild(employees.employees, -5);

 The result is:

[NQODBC] [SQL_STATE: S1000]
[nQSError: 10058] A general error has occurred.
[nQSError: 43113] Message returned from OBIS.
[nQSError: 27002] Near <->: Syntax error
[nQSError: 26012] .

 

However, replacing the negative number to a positive number does work

select employees.FirstName, employees.employeeID from ValueHierarchy where 
IsChild(employees.employees, 5);

 

 Query result:

------------------
FirstName" yeeID"
------------------
------------------
Row count: 0
------------------


Processed: 1 queries

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms