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
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.
Thanks Grim. I will raise a PMR.
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