while running masking in DB2 linux using FDM for BLOB column data we are getting error

Article Id: 129940

Status: Published

Updated On: 25-03-2019 00:27

Products:

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction:

I have followed below steps and masking functions.

1. Created connection Profile to connect to DB.
2. Tried masking functions( FORMATENCRYPT, RANDOMBLOB, FORMATHASH) to mask BLOB column data.

While running the masking, received below error:
Illegal conversion: can not convert from "java.lang.String" to "java.sql.Blob" ERRORCODE=-4474, SQLSTATE=null

Cause:

If there is a string data in BLOB column, it will throw an error during conversation from String to BLOB.

Environment:

Data source connection: DB2
OS: Linux
FDM 4.7

Resolution:

Since there is a string data in BLOB column, you are getting type casting error as "Illegal conversion: can not convert from "java.lang.String" to "java.sql.Blob" ERRORCODE=-4474, SQLSTATE=null ".
Please insert some image files or text files in BLOB column and apply masking using RANDOMBLOB.