Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Informatica work flow fails with the error CWB0111

user12221504Aug 16 2011 — edited Aug 22 2011
My environment: Informatica 9.0.1, Dac Build AN 10.1.3.4.1.patch.20110427.0538, Build date: April 27 2011 on Windows server, database - iSeries V6R1. Informatica connects to As/400 using an ODBC DSN name.

Upon execution several mappings do fail with the following error code
Severity: ERROR
Timestamp: 8/15/2011 6:39:44 PM
Node: node01_HSCUSCHLWS00112
Thread: READER_1_1_1
Process ID: 113076
Message Code: RR_4035
Message: SQL Error [
FnName: Fetch -- [IBM][System i Access ODBC Driver]Column 16: CWB0111 - A buffer passed to a system call is too small to hold return data
FnName: Fetch -- [IBM][System i Access ODBC Driver]String data right truncation.
FnName: Fetch -- [IBM][System i Access ODBC Driver]Column 16: CWB0111 - A buffer passed to a system call is too small to hold return data
FnName: Fetch -- [IBM][System i Access ODBC Driver]String data right truncation.
FnName: Fetch -- [IBM][System i Access ODBC Driver]Column 16: CWB0111 - A buffer passed to a system call is too small to hold return data
FnName: Fetch -- [IBM][System i Access ODBC Driver]String data right truncation.

I’ve searched the web and it seems like the Linux/Unix driver for iSeries has some issues with Unicode, but my environment is Windows-only.

Any suggestions are welcome. Thank you!
This post has been answered by Ahsan Shah on Aug 17 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 19 2011
Added on Aug 16 2011
#business-intelligence-applications, #odbc
2 comments
2,003 views