OAC: Analytics Reports Fail With "ORA-12152 TNS Unable To Send Break Message"

(Doc ID 2358354.1)

Last updated on FEBRUARY 08, 2018

Applies to:

Oracle Analytics Cloud Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

With an Oracle Database Cloud Service data source ...

In the RPD, the Database Type is "Oracle 12c" ... the Connection Pool Call Interface is "Default (OCI 10g/11g)" ... and the Data Source Name is an Oracle Client alias (which is defined in the tnsnames.ora file).

In Analytics, a simple analysis with one attribute column and one metric column executes successfully and returns results.  But, add any second (or more) metric column (from a different fact table) to the same report, and the report will fail after 15 minutes with the following error thrown onscreen:-

[nQSError: 17001] Oracle Error code: 12152, message: ORA-12152: TNS:unable to send break message at OCI call OCIStmtExecute.

In the obis1-query.log file, we see the Physical SQL is generated and is "sent" to the database, but it is never received at the Oracle database for execution. The following error is observed in the log file:-

-------------------- Query Status: [nQSError: 60009] The user request exceeded the maximum query governing execution time. [[
[nQSError: 17001] Oracle Error code: 12152, message: ORA-12152: TNS:unable to send break message
at OCI call OCIStmtExecute.
[nQSError: 43119] Query Failed:
]]

The issue is also encountered in Data Visualizer / Visual Analyzer.

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