My Oracle Support Banner

OAC : Report Error with "NQSError: 59161 The Values Generated During The Execution Of The MultiplyFloat Function Exceeded" when upgrade from OBIEE 12c (Doc ID 2712024.1)

Last updated on SEPTEMBER 18, 2020

Applies to:

Oracle Analytics Cloud - Version 105.6.0 and later
Oracle Analytics Cloud - Classic - Version 105.6.0 and later
Information in this document applies to any platform.

Symptoms

When the reports are upgraded from OBIEE 12.2.1.x to Oracle Analytics Cloud(OAC) few reports fail with below error which uses a complex formula in columns with case statements.

ERROR
-----------------------

 'nQSError: 59161' : The values generated during the execution of the MultiplyFloat function exceeded the maximum allowed numeric size, Please change the function to ensure that values larger than 1.11111111111111111e+308 are not generated.

Note : The value in the above error "1.11111111111111111e+308" is just for example purpose and it can be of any value with similar or different format.

 

Changes

 Upgraded the catalog from OBIEE 12.2.1.x to Oracle Analytics Cloud(OAC)

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
Changes
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.