My Oracle Support Banner

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:

Oracle Analytics Server - Version 5.5.0 and later
Information 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


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