My Oracle Support Banner

After Migration To Oracle Analytics Server, Some Analysis Fail With nQSError 12010,10092, 23004 (Doc ID 2669966.1)

Last updated on JULY 21, 2020

Applies to:

Oracle Analytics Server - Version 5.5.0 and later
Information in this document applies to any platform.

Symptoms

After Migration to OAS, a few reports are causing crash


state: HY000. Code: 12010. [nQSError: 12010] Communication error connecting to remote end point: address = xxx.yyy.zzz; port = nnnn. (HY000).
and any other reports running at same time are failing with error
State: 08004. Code: 10092. [NQODBC] [SQL_STATE: 08004] [nQSError: 10092] The Oracle BI Server is not currently running. (08004)
State: 08004. Code: 10092. [NQODBC] [SQL_STATE: 08004] [nQSError: 10092] The Oracle BI Server is not currently running. Cannot connect to server machine (08004)

OR

[nQSError: 23004] Invalid request: Subtotal GROUP
BY clause cannot contain an aggregate expression case when Achivement

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.