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 APRIL 17, 2023

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.