Getting error while testing after importing a table into dimensional layer.

[inu]

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

[MFGF]

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.

[the6campbells]

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

[shradha]

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.