Checked the error encountered when parsing, as per checking, there is a limit that exceeded when extracting data from JDA, suspects that this might be on the iSeries or the ODBC as it is what the error message indicating, before starting checking the application, checked the details first from sir Christian, no feedback yet.