COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Framework Manager => Topic started by: inu on 30 Apr 2017 12:22:07 AM

Title: Getting error while testing after importing a table into dimensional layer.
Post by: 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
Title: Re: Getting error while testing after importing a table into dimensional layer.
Post by: MFGF on 02 May 2017 03:46:50 AM
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.
Title: Re: Getting error while testing after importing a table into dimensional layer.
Post by: the6campbells on 02 May 2017 09:25:47 PM
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
Title: Re: Getting error while testing after importing a table into dimensional layer.
Post by: shradha on 24 Jul 2019 11:07:52 AM
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.