OBIEE 11g: With SSL Enabled, Nqcmd Command Does Not Retrieve All Rows (intermittently), Appears To Hang And Fails With '[nQSError: 12002] Socket communication error at call=SSL_read: (Number=5) No such file or directory' (Doc ID 1961122.1)

Last updated on AUGUST 24, 2015

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.7.141014 and later
Business Intelligence Server Enterprise Edition - Version 11.1.1.7.141014 and later
Oracle Business Intelligence Enterprise Edition - Version N/A and later
Information in this document applies to any platform.

Symptoms

When SSL is enabled for system components, nqcmd intermittently stops writing to the output file. In some cases, it will complete. In other cases, it will stop. 

The following symptoms also apply:

 

Note: This document is specifically detailing the symptoms when using NQCMD; however, this issue could affect any large dataset download or query within OBIEE Answers / Analysis.  NQCMD is a good test to confirm behavior.

 

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