OBIEE reports generate physical SQLs that contain "<=ALL" clause are not compatible with redshift database.
(Doc ID 2745074.1)
Last updated on DECEMBER 03, 2021
Applies to:Business Intelligence Suite Enterprise Edition - Version 184.108.40.206.200714 and later
Information in this document applies to any platform.
On : Oracle Business Intelligence Enterprise Edition 220.127.116.11.x version,
Changing to Redshift from DB2,OBIEE reports throws below error.
State: HY000. Code: 16001. [nQSError: 16001] ODBC error state: 0A000 code: 30 message: [Amazon][Amazon Redshift] (30) Error occurred while trying to execute a query: [SQLState 0A000] ERROR: ALL with <, >, <=, >=, or = comparison condition is not supported.(HY000)
Moving to Redshift from DB2 database.
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