Thursday, April 11, 2013

Errors in ODI(Oracle Data Integrator)

Error Description:

ODI-1227: Task SrcSet0 (Loading) fails on the source MICROSOFT_EXCEL connection Incident_data.
Caused By: java.sql.SQLException: Invalid Fetch Size

Solution:You will get above error  after executing "Interface" in "Operation" Tab.
step to Fixed this issue:--Go to Topology-->Physical Architecture-->Technology-->Microsoft Excel-->Select Your data server-->Check Array Fetch Size Column   .By default the value in this column is 30.
Just remove the value from this column  

1 comment:

  1. HI Pushpendra dhakad;

    We have many ODI interfaces. Some times it fails because of the time out issues
    on Source and Target also.

    Could you please help me how to find the root causes?
    Here is the error:
    ODI-1227: Task SrcSet0 (Loading) fails on the source ORACLE connection DS_CSID_PR.
    Caused By: oracle.odi.jdbc.datasource.ConnectionTimeoutException: A login timeout occured while connecting to the database
    at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.doGetConnection(LoginTimeoutDatasourceAdapter.java:117)
    at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.getConnection(LoginTimeoutDatasourceAdapter.java:62)
    at oracle.odi.core.datasource.dwgobject.support.OnConnectOnDisconnectDataSourceAdapter.getConnection(OnConnectOnDisconnectDataSourceAdapter.java:75)
    at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)
    at com.sunopsis.sql.SnpsConnection.connect(SnpsConnection.java:348)
    at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2875)
    at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2609)
    at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:537)
    at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:453)
    at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1740)
    at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:582)
    at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:214)
    at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1070)
    at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:123)
    at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)
    at java.lang.Thread.run(Thread.java:662)

    I'd appreciate your feedback.

    Rahman


    ReplyDelete