A Project with Snowflake DataSets in Oracle Analytics Server Fails with Error - Unknown Function SYS_OP_MAP_NONNULL
(Doc ID 2757654.1)
Last updated on JANUARY 09, 2025
Applies to:
Oracle Analytics Server - Version 5.5.0 and laterInformation in this document applies to any platform.
Symptoms
On OAS 5.5
A Dataset is created on a Snowflake database connection, and a duplicate of the Dataset is created.
In a Project, a new ("key") column is created and added to each Dataset, and the Datasets are joined via the new columns.
A visualization, with columns from both Datasets, fails and throws a Query Error.
In the obis1-query.log file, the following error is observed:-
[nQSError: 77031] Error occurs while calling remote service DatasourceService. Details: [JDSError : 115] Invalid Database Name - Cause: SQL compilation error: [[
Unknown functions SYS_OP_MAP_NONNULL, SYS_OP_MAP_NONNULL
Action: Please refer to logs for more Details
[nQSError: 43119] Query Failed:
It is also observed that the Physical Query includes the SYS_OP_MAP_NONNULL function, which is an unknown function for Snowflake:-
WITH
SAWITH0 AS (select ...
from
SAWITH2 D102 left outer join SAWITH5 D101 On SYS_OP_MAP_NONNULL(D101.c1) = SYS_OP_MAP_NONNULL(D102.c1) ),
SAWITH7 AS (select ...
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |