OTBI: Not Able To Load or Access Subject Areas After 22A or 22B Upgrade (Doc ID 2850396.1)

Last updated on MAY 03, 2024

Applies to:

Symptoms

Issue happens in different flavors:

(1)

On : 11.13.22.01.0 version, Analytics

ACTUAL BEHAVIOR
---------------
Customer is unable to access or see the list of subject areas after 22A or 22B upgrade.

EXPECTED BEHAVIOR
-----------------------
User is able to access subject areas

STEPS TO REPRODUCE
==================================
Try to run any report , see error

==================================
Error generating view. Error getting cursor in GenerateHead
Error Details
Error Codes: OAMP2OPY:OPR4ONWY:U9IM8TAC:OI2DL65P:OI2DL65P
Odbc driver returned an error (SQLExecDirectW).
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.
[nQSError: 43113] Message returned from OBIS.
[nQSError: 27047] Nonexistent table: "xxxx".


(2)

Create New > Analysis
The list of subject areas is empty

(3)

On :  11.13.22.04.0 version, Analytics

After a planned/unplanned bounce of database, when attempting to run existing BI reports the following error occurs.

ERROR
-----------------------
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: 17001. [nQSError:
17001] Oracle Error code: 1005, message: ORA-01005: null password given;
logon denied at OCI call OCISessionBegin. (HY000)State: HY000. Code: 17014.
[nQSError: 17014] Could not connect to Oracle database. (HY000)

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.