Working on DB2 v11.1 data masking in FDM 4.9.195 and getting below error.
com.ibm.db2.jcc.am.SqlException: [jcc][t4][1065][12306][4.19.66] Caught java.io.CharConversionException. See attached Throwable for details. ERRORCODE=-4220, SQLSTATE=null
This issue is happening with below data in the database:
寿å¥è¿±å¿¿ , æ¿ å·¿å¸¿ä»²æºé«¿æ¿
These are some special characters where FDM tool is not able to handle.
FDM 4.9+
This issue/error is caused due to the limitation with the third party DB2 driver not able to work with the special characters in the data stored in DB and TDM/FDM doesn't have control over that.
To resolve this issue, work with your DBA to correct the data in the source DB or work with DB2 support for getting support on these characters.
At this point, TDM is restricted by the options provided by DB2.