ODI-1227 : Invalid Fetch Size while loading data from microsoft xls to oracle

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

 This is 11g bug.

so u can download the patch from oracle support (p12798243_111150_Generic)or

Follow the below solution.

 Solution:
-----------------

Goto => Physical Architecture =>Technologies=> Microsoft Excel=>Data Server

ex: i have created MOCROSOFT_EXCEL data server

open data server and change the Arry Fetech Size to zero (0).