My Oracle Support Banner

nQSError: 22023 Returns With CURRENT_DATE Calculation in Visualization (Doc ID 2769761.1)

Last updated on NOVEMBER 03, 2023

Applies to:

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

Symptoms

nQSError: 22023 returns when my calculation with CURRENT_DATE is added in a visualization.

In this case, my calculation is 


An arithmetic operation is being carried out on a non-numeric type.

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000]
[nQSError: 10058] A general error has occurred.
[nQSError: 43113] Message returned from OBIS.
[nQSError: 43119] Query Failed:
[nQSError: 22023] An arithmetic operation is being carried out on a non-numeric type. (HY000)

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.