OFS ALMBI Dashboard Errors [nQSError: 10092] The Oracle BI Server Is Not Currently Running and ORA-12154 (Doc ID 3051368.1)

Last updated on OCTOBER 04, 2024

Applies to:

Symptoms

On ALMBI 8.1.2 for new installation, after following all the steps mentioned in the guide Oracle Financial Services Asset Liability Management Application Pack Installation and Configuration Guide Release 8.1.2.0.0, the Dashboard reports are getting the below error after configuring as mentioned in 6.7.1.1 Deploying OFS ALMBI:

ERROR

Odbc driver returned an error (SQLExecDirectW).
  Error Details
Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:OI2DL65P
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)
SQL Issued: SELECT 0 s_0, VALUEOF(NQ_SESSION.DBNAME) s_1 FROM "ALM BI" FETCH FIRST 65001 ROWS ONLY

In addition, expanding the text details of the dashboard errors shows:

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: 43275. [nQSError: 43275] Message returned from OBIS [ecid:f4399dc3-8737-47f5-981b-226e42cf6a23-000c9b3f,0:2:107:6 ts:2024-09-10T09:17:50.114+02:00 obis1]. (HY000)
State: HY000. Code: 43119. [nQSError: 43119] Query Failed: (HY000)
State: HY000. Code: 17001. [nQSError: 17001] Oracle Error code: 12154, message: ORA-12154: TNS:could not resolve the connect identifier specified at OCI call OCIServerAttach. (HY000)
State: HY000. Code: 17014. [nQSError: 17014] Could not connect to Oracle database. (HY000)
SQL Issued: SELECT 0 s_0, "FTP BI"."

Changes

 New installation.

Cause

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