BICS Error Encountered While Running a Job: "FAILED TO CREATE CONNECTION POOL"

(Doc ID 2126529.1)

Last updated on JUNE 21, 2016

Applies to:

Oracle Business Intelligence Cloud Service - Version 15.2.4.0.0 and later
Information in this document applies to any platform.

Symptoms

On Business Intelligence Cloud Services (BICS), you try to execute a load job and you see the below error on the Tasks screen:

FAILED TO CREATE CONNECTION POOL <pool_name> Process failed during creation of connection pool <pool_name>.

 In the job log, you see:

::: CAUSE :::
MESSAGE :::Got minus one from a read call
EXCEPTION CLASS::: oracle.net.ns.NetException

oracle.net.ns.Packet.receive(Packet.java:296)
oracle.net.ns.NSProtocol.connect(NSProtocol.java:295)
oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1056)
oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:308)
oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:538)
oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:228)
oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
java.sql.DriverManager.getConnection(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
com.siebel.etl.database.ConnectionPool.createConnection(ConnectionPool.java:632)
com.siebel.etl.database.ConnectionPool.populate(ConnectionPool.java:704)
com.siebel.etl.database.ConnectionPool.<init>(ConnectionPool.java:216)
com.siebel.etl.database.ConnectionPool.<init>(ConnectionPool.java:170)
com.siebel.etl.database.ConnectionManager.createPool(ConnectionManager.java:295)
com.siebel.etl.database.DBUtils.createPool(DBUtils.java:1867)
com.siebel.etl.database.DBUtils.createPool(DBUtils.java:1721)
com.siebel.etl.database.WeakDBUtils.createPool(WeakDBUtils.java:91)
com.siebel.etl.engine.core.ETL.createConnectionPool(ETL.java:1267)
com.siebel.etl.engine.core.ETL.thisETLProcess(ETL.java:289)
com.siebel.etl.engine.core.ETL.run(ETL.java:802)
com.siebel.etl.engine.core.ETL.execute(ETL.java:1156)
com.siebel.analytics.etl.concurrentetl.ETLProcess.<init>(ETLProcess.java:75)
com.siebel.analytics.etl.concurrentetl.ETLProcess.main(ETLProcess.java:204)
32 SEVERE Thu Mar 24 14:47:47 CDT 2016 FAILED TO CREATE CONNECTION POOL <pool_name> Process failed during creation of connection pool <pool_name>.

IO Error: Got minus one from a read call
33 SEVERE Thu Mar 24 14:47:47 CDT 2016 MESSAGE:::FAILED TO CREATE CONNECTION POOL <pool_name> Process failed during creation of connection pool <pool_name>.

 

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