Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 224 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.8K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 83 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations 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
