Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
None of the calendar functions are working on OBIEE11g on Redshift.

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
Answers
-
Anything in this archived thread of help?
0 -
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.
0 -
@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.
0