Oracle Analytics Server with Postgres and "Rownum" error

Question

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

Gianni Ceresa · Accepted 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.