OBIEE 12c: Analysis failed after a fixed time – Error Codes: 12609, message: ORA-12609: TNS: Receive timeout occurred at OCI call OCIStmtFetch:
Error:
View Display Error
Odbc driver returned an error (SQLExecDirectW).
Error Details:
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: 17001. [nQSError: 17001] Oracle Error code: 12609, message: ORA-12609: TNS: Receive timeout occurred at OCI call OCIStmtFetch. (HY000)
State: HY000. Code: 17012. [nQSError: 17012] Bulk fetch failed. (HY000)
Solution:
Step 1: Take a backup of sqlnet.ora file from the below path in OBIEE MT server.
For 12.2.1.3 and lower: [DOMAIN_HOME]/config/fmwconfig/bienv/core/sqlnet.ora
For 12.2.1.4 and higher: [DOMAIN_HOME]/bidata/components/core/serviceinstances/ssi/oracledb/sqlnet.ora
Step 2: Add and provide proper value for sqlnet.expire_time in OBIEE sqlnet.ora file
SQLNET.INBOUND_CONNECT_TIMEOUT=360
SQLNET.SEND_TIMEOUT=1200
SQLNET.RECV_TIMEOUT=1200
sqlnet.expire_time=20
Step 3: Restart the services.