My Oracle Support Banner

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 JULY 16, 2020

Applies to:

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


Using this SQL test case with northwind_vh.rpd:

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

 The result is:

[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



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

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