Invalid column number - Delayed binding at fetch time failed

[Ashok Kumar Jayaraman]

Hi

We use Informatica service to read from MySQL DB. We are experiencing an inconsistent issue where the job fails with the below error. When we simply restart the job, it completes without any issues. The columns are mapped to their corresponding equivalent data types available in Informatica and most of the times the job completes without any issues.

Can you please advise what situation the below error would occur?
Note:
It takes less than 5 mins to complete the job, but whenever there is issue, the job runs for over 2 hrs and then eventually gives the below error, at which point we restart the job that completes as expected.


2016-12-11 13:46:40 : ERROR : (43956 | READER_1_2_1) : (IS | uat_integration_service_bd) : node09_dukebiqd88 : RR_4035 : SQL Error [
FnName: Bind Col -- [MySQL][ODBC 3.51 Driver][mysqld-5.6.20-log]Invalid column number
Database driver error...Delayed binding at fetch time failed.].