XQE-DAT-0001 Data source adapter error: com.ibm.db2.jcc.am.SqlException: [jcc][t

[mrcool]

Hello All,

I am facing the below error only on few dimensions in DMR with DQM. I have tried various options like upgrading the driver and setting Ddb2.jcc.charsetDecoderEncoder=3 at query service level but no luck. I am not getting this error on relational query subjects when I test them in dynamic query mode.
The problem is only with DMR.
We are using Db2 version 10.5
XQE-DAT-0001 Data source adapter error: com.ibm.db2.jcc.am.SqlException: [jcc][t4][1065][12306][3.62.56] Caught java.io.CharConversionException

Thanks in advance
mc

[Grim]

Invalid char in your data?
http://www-01.ibm.com/support/docview.wss?uid=swg21684365

Are you using the JDBC driver that came with the 10.5 (Same FP level) as the DB?

This definitely sounds like one for IBM Cognos Support. Seems like you're most likely to need a code tweak (Hotsite) if it works with relational and not with DMR.

[mrcool]

Thanks Grim. I will raise a PMR.

[sagar_d125]

Hi MrCool,

Are you able to resolve the issue, we are also facing the same issue while displaying special charected from JDBC drivers in 10.2.2. Please let me know what needs to be done to fix it.

Thanks in advance

Sagar