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 MARCH 07, 2021
Applies to:Oracle Analytics Server - Version 5.5.0 and later
Information in this document applies to any platform.
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:-
SAWITH0 AS (select ...
SAWITH2 D102 left outer join SAWITH5 D101 On SYS_OP_MAP_NONNULL(D101.c1) = SYS_OP_MAP_NONNULL(D102.c1) ),
SAWITH7 AS (select ...
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