My Oracle Support Banner

Answers reports using AGO function fails with [nQSError: 46008] Internal error (Doc ID 2741471.1)

Last updated on JANUARY 04, 2021

Applies to:

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

Symptoms

Executing Answer Report which has a column that uses AGO function results in following error :

Error
View Display Error

Odbc driver returned an error (SQLExecDirectW).
Error Details
Error Codes: OPR4ONWY: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: 46008. [nQSError: 46008] Internal error: File server/Query/Optimizer/SmartScheduler/PhysicalRequestGenerator/Src/SQOSPMarkMultiTargetSupport.cpp, line 2636. (HY000)

This issue is only seen in the dev environment, prod environment works fine and AGO based column formulas do not result in any error.

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

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