Oracle Analytics Server with Postgres and "Rownum" error

user593849

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

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.