OBIEE 11g: Error: "Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P ... [nQSError: 10092] The Oracle BI Server is not currently running." when Applying Prompt Values (Doc ID 1573020.1)

Last updated on MARCH 25, 2016

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.7.1 and later
Business Intelligence Suite Enterprise Edition - Version 11.1.1.7.1 and later
Information in this document applies to any platform.

Symptoms

After upgrading from OBIEE 11.1.1.6.x to 11.1.1.7.1, when you try to apply prompt values on a specific analysis, you get the following error:

Odbc driver returned an error (SQLSetSmtAttrW).
Error details
  Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
  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 Issue: SELECT s_0,...

 

Changes

Upgraded from OBIEE 11.1.1.6.x to 11.1.1.7.1.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms