My Oracle Support Banner

OBIEE reports generate physical SQLs that contain "<=ALL" clause are not compatible with redshift database. (Doc ID 2745074.1)

Last updated on JANUARY 24, 2021

Applies to:

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

Symptoms

On : Oracle Business Intelligence Enterprise Edition 12.2.1.4.x version,

Changing to Redshift from DB2,OBIEE reports throws below error.

Error message

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)

 

Changes

Moving to Redshift from DB2 database.

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
References


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