MySQL Forums
Forum List  »  Oracle

Invalid column number - Delayed binding at fetch time failed
Posted by: Ashok Kumar Jayaraman
Date: December 11, 2016 11:15PM

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.].

Options: ReplyQuote


Subject
Views
Written By
Posted
Invalid column number - Delayed binding at fetch time failed
4429
December 11, 2016 11:15PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.