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
HI Pushpendra dhakad;
ReplyDeleteWe 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