Hi Team,
I imported a table into FM , but when i test the same, i get error as below
XQE-DAT-0001 Data source adapter error: com.ibm.db2.jcc.am.SqlException: [jcc][t4][1065][12306][4.19.26] Caught java.io.CharConversionException. See attached Throwable for details. ERRORCODE=-4220, SQLSTATE=null:
Input length = 1
I tested each query item individually, all are giving data, but only one column which is throwing above, how to resolve that, i am not able to find out the root cause.
Please suggest guys..
Regards,
Inam
Quote from: inu on 30 Apr 2017 12:22:07 AM
Hi Team,
I imported a table into FM , but when i test the same, i get error as below
XQE-DAT-0001 Data source adapter error: com.ibm.db2.jcc.am.SqlException: [jcc][t4][1065][12306][4.19.26] Caught java.io.CharConversionException. See attached Throwable for details. ERRORCODE=-4220, SQLSTATE=null:
Input length = 1
I tested each query item individually, all are giving data, but only one column which is throwing above, how to resolve that, i am not able to find out the root cause.
Please suggest guys..
Regards,
Inam
Did you search on the forum?
Looks a lot like this post...
http://www.cognoise.com/index.php?topic=26277.0
Is it possible you have some invalid data values?
MF.
The issue is in your data. In essence, the jCC driver is throwing an exception. For more details refer to the IBM JCC documentation with respect to db2.jcc.charsetDecoderEncoder
Hi,
Were you able to solve this? I am facing exactly the same issue. The problem in with a column which carries special (CZE characters). My database team won't agree to any problem as they are able to display data using DB2 studio and some other tools as well.
But cognos FM won't read the table. We have tried setting db2.jcc.charsetDecoderEncoder =3, in cognos configuration but no help.
TIA.