OBIA 11g: ODI Load PLan Failed For Financial Analytics.(BIAPPS11.1.1.7.1) with Error ODI-1228: Task ... fails Caused By: java.sql.SQLException: IO Error: Got minus one from a read call (Doc ID 1624800.1)

Last updated on JANUARY 31, 2017

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.7.1 and later
Information in this document applies to any platform.

Symptoms

Run the Load Plan for Financial analytics after completing all the configurations.

The load plan fails with

ODI-1228: Task SIL_DayDimension.W_DAY_D (Integration) fails on the target ORACLE connection BIAPPS_DW.
Caused By: java.sql.SQLException: IO Error: Got minus one from a read call

 Error may show:

ODI-1519
ODI-1519: Serial step "Start Load Plan (InternalID:6271500)" failed because child step "Global Variable Refresh (InternalID:6272500)" is in error.
ODI-1519: Serial step "Global Variable Refresh (InternalID:6272500)" failed because child step "Source Extract Phase (InternalID:6275500)" is in error.
ODI-1519: Serial step "Source Extract Phase (InternalID:6275500)" failed because child step "1 General (InternalID:6276500)" is in error.
ODI-1519: Serial step "1 General (InternalID:6276500)" failed because child step "2 General PRE-SDE (InternalID:6277500)" is in error.
ODI-1519: Serial step "2 General PRE-SDE (InternalID:6277500)" failed because child step "3 PRE-SDE Day (InternalID:6285500)" is in error.
ODI-1519: Serial step "3 PRE-SDE Day (InternalID:6285500)" failed because child step "Serial with Dual_G and DAY_D (InternalID:6288500)" is in error.
ODI-1519: Serial step "Serial with Dual_G and DAY_D (InternalID:6288500)" failed because child step "SIL_DAYDIMENSION (InternalID:6292500)" is in error.
ODI-1217: Session SILOS_SIL_DAYDIMENSION (326500) fails with return code 8000.
ODI-1226: Step SIL_DayDimension.W_DAY_D fails after 1 attempt(s).
ODI-1240: Flow SIL_DayDimension.W_DAY_D fails while performing a Integration operation. This flow loads target table Day Dimension.
ODI-1228: Task SIL_DayDimension.W_DAY_D (Integration) fails on the target ORACLE connection BIAPPS_DW.
Caused By: java.sql.SQLException: IO Error: Got minus one from a read call
               at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.doGetConnection(LoginTimeoutDatasourceAdapter.java:133)
               at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.getConnection(LoginTimeoutDatasourceAdapter.java:62)
               at oracle.odi.core.datasource.dwgobject.support.OnConnectOnDisconnectDataSourceAdapter.getConnection(OnConnectOnDisconnectDataSourceAdapter.java:74)
               at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)
               at com.sunopsis.sql.SnpsConnection.createConnection(SnpsConnection.java:390)
               at com.sunopsis.sql.SnpsConnection.connect(SnpsConnection.java:348)
               at com.sunopsis.dwg.dbobj.SnpSessTaskSql.getExecutor(SnpSessTaskSql.java:2962)

...

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