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 11.1.1.7.140715 and laterInformation 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
IsChild(employees.employees, 5);
Query result:
------------------
FirstName" yeeID"
------------------
------------------
Row count: 0
------------------
Processed: 1 queries
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 |
Cause |
Solution |
References |