After Upgrade To Oracle Analytics Server (OAS), Reports with Position Function Are Failing with 'nQSError: 100041' Error (Doc ID 2944394.1)

Last updated on APRIL 27, 2023

Applies to:

Oracle Analytics Server - Version 2022 (6.4.0.0.220921) and later
Information in this document applies to any platform.

After upgrade from OBIEE 12.2.1.4 to Oracle Analytics Server, Reports based on Snowflake datasource are failing with the below error.

These reports have filters with POSITION function and the POSITION function is converted into REGEXP_INSTR in the physical query.

Upgrade from OBIEE 12.2.1.x to Oracle Analytics Server 6.4.

	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

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