OTBI Analysis Errors Out With - A Drive Table join exceeded the limit of 10 (Doc ID 2825698.1)

Last updated on DECEMBER 14, 2021

Applies to:

Symptoms

OTBI analysis that includes a CLOB based lookup column with other dims/facts errors with

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: 59034. [nQSError: 59034] A Drive Table join exceeded the limit of 10
backend database queries. (HY000)

A simple example,

SELECT
"Workforce Goals - Goal Status Overview Real Time"."Performance Goal Plan"."Goal Plan Name" s_1,
length("Workforce Goals - Goal Status Overview Real Time"."Performance Goals"."Description") s_2,
length("Workforce Goals - Goal Status Overview Real Time"."Performance Goals"."Success Criteria") s_3
FROM "Workforce Goals - Goal Status Overview Real Time"

Changes

Cause

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