Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 34 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 273 Oracle Analytics and AI News
- 48 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.3K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 100 Oracle Analytics and AI Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Oracle Analytics Server with Postgres and "Rownum" error
Hi,
We recently pointed our OAS to a Postgres Db but are getting the error below which I have establish it relates to the psudo filter from OAS for rownum.
What setting is causing this and how can i make it postres compatible?
Odbc driver returned an error (SQLExecDirectW). |
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. |
(HY000) |
State: HY000. Code: 43275. [nQSError: 43275] Message returned from OBIS [ecid:e48bd1ba-ac20-4ff3-83cf-61bc8cd936f3-00017271,0:3:7:6 ts:2024-07-04T16:19:10.171+03:00 obis1]. |
(HY000) |
State: HY000. Code: 100041. [nQSError: 100041] Failed to read data from Java Datasource server. (HY000) |
SQL Issued: SET VARIABLE ENABLE_DIMENSIONALITY = 1; SELECT |
FETCH FIRST 65001 ROWS ONLY |
Best Answer
-
Did you configure the database properties in the RPD accordingly to what Postgres understands/accept?
The piece of message you posted above is LSQL, it isn't the query sent to your database, if you want to know what query the server tried to send to your database you should look in the logs.
1
