nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

OAC generates invalid ROWNUM clause against Snowflake when using RPD subject area

Dennis Paredes

When running an analysis built on an RPD-based Data Model that connects to Snowflake, OAC incorrectly injects an Oracle-specific WHERE rownum <= 500001 clause into the generated SQL.Snowflake does not support ROWNUM → query fails immediately with:

SQL compilation error: error line X at position Y invalid identifier 'ROWNUM'

Example of the failing generated SQL:

SELECT ...FROM ...WHERE ... AND rownum <= 500001 -- ← This causes the error in Snowflake

Expected Behavior: OAC should generate Snowflake-compatible row-limiting syntax when the database type is Snowflake, for example:

FETCH FIRST 500001 ROWS ONLY

LIMIT 500001

Any tips, known workarounds, or patches would be greatly appreciated to fix this error!

Find more posts tagged with

OAC

rpd

Accepted answers

Dennis Paredes

Resolved by deleting existing connection pool and creating a new one as Snowflake DB.

All comments

Steve F-2

Hi @Dennis Paredes ,

This may be difficult to resolve on a forum. Additional details of the RPD configuration, and review of the logs may be required.

A general question, if you create a connection in /dv against the same schema, then create a workbook against a dataset or a local subject area, does the same issue occur?

Dennis Paredes

Resolved by deleting existing connection pool and creating a new one as Snowflake DB.

Steve F-2

Glad you resolved it.