None of the calendar functions are working on OBIEE11g on Redshift.

Question

None of the calendar functions are working on OBIEE11g on Redshift.  I am using PostgreSQL driver to connect to Redshift

I am getting the following error

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 16001] ODBC error state: 51 code: 0 message: [DataDirect][ODBC 20101 driver]6022. [nQSError: 16014] SQL statement preparation failed. (HY000)

Do I need to change any settings in RPD file.

All the calendar functions are checked in my RPD

[Deleted User] · Answer

@Chet Justice welcome to the best forum here

To add to your input: in 11g it's really the drivers which are the issue, less what's emitted. Even with more support coming you'll never get to a real native query translation.

Chet Justice · Answer

As you're probably aware, Redshift is not certified to work with OBIEE. That (supposedly) changed in 12c.

I currently have a client with 11g sitting on Redshift using the Postgres drivers. My colleague determined that Redshift (but more likely the Postgres driver) doesn't play nicely with the OBIEE date functions. We've resorted to using EVALUATE and using Redshift functions for all our date calculations.

Thomas Dodds · Answer

Anything in this archived thread of help?

Connecting OBIEE to Redshift