My Oracle Support Banner

After Upgrading to OBI12.2.1.4, nQSError:59162 Error May Occur When using Average Function (Doc ID 2615695.1)

Last updated on JULY 27, 2020

Applies to:

Business Intelligence Suite Enterprise Edition - Version 12.2.1.4.0 to 12.2.1.4.200714 [Release 12g]
Information in this document applies to any platform.

Symptoms

 After upgrading to OBI12c 12.2.1.4, following error may occur when using average function(AVG).

------------------------------------------------
Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)
State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)
State: HY000. Code: 43119. [nQSError: 43119] Query Failed: (HY000)
State: HY000. Code: 59140. [nQSError: 59140] The evaluation of the index 1 expression on row count -1 failed. (HY000)
State: HY000. Code: 59162. [nQSError: 59162] The values generated during the execution of the SubtractUInt function exceeded the minimum allowed numeric size,please change the function to ensure that values less than 0 are not generated. (HY000)
------------------------------------------------

For example, simple testcase is the result of below column formula.
---------------
avg(10) - 30
---------------

In OBI12c 12.2.1.3 and earlier version (including OBI 11g), the result returns as following.


But in OBI12c 12.2.1.4,


Changes

 Upgraded to OBI12.2.1.4 from OBI12.2.1.3 or earlier version (including OBI 11g).

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


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