Oracle connections dropping with Spotfire Cloud, ORA-03114

[James Watts]

We're using hosted Spotfire Cloud, and connecting to on-premise data. Over the last month or so we've been getting a lot of dropped connections in WebPlayer to on-premise Oracle databases. The connections are made successfully, and sometimes data is returned, but then one of the queries will fail with something like:

 

 

 

Oracle.DataAccess.Client.OracleException (0x80004005): ORA-03114: not connected to ORACLE

 

 

at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck, Int32 isRecoverable, OracleLogicalTransaction m_OracleLogicalTransaction)

 

 

at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck, OracleLogicalTransaction m_OracleLogicalTransaction)

 

 

at Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)

 

 

at Oracle.DataAccess.Client.OracleCommand.ExecuteReader()

 

 

at Spotfire.Dxp.Data.Adapters.Oracle.OracleAdapterConnection.QueryExecution(SqlQuery query, CommandType commandType, String queryString, List`1 parameters, Dictionary`2 parameterValues, IList`1 storedProcedureColumns, QueryResultWriter resultWriter, NativeQueryExecutionDiagnostics executionDiagnostics, CancellationToken cancellationToken)

 

 

 

There are also timeout messages, always around the 19,000ms mark.

where bgownerobject='PO') "SpotfireCustomQuery2") failed after 19309 ms (Number of columns = N/A). Cause: An error occurred when executing a query in the external data source.

Tibco are still investigating their side. Our network vendor is not seeing dropped connections between us and Tibco. Our DBA is seeing the odd drop, but the DB timeout is set to four hours.

 

Anybody else seen something similar, or have suggestions where to look please