Hi Team,
During masking of one of the DB2 LUW table I am getting error .
While the job fails without any error on portal , when I checked in logs I could see this "EntityKey was already known; should only happen on root returns with an optional identifier specified"
Attached logs for reference captured in DEBUG mode after clearing all existing logs.
TDM Portal
Test Data Manager
FDM
Fast Data Maker
This is a message only and can be ignored it is NOT an error.
The problem, in this case, was the below error found later in the logs.
c.c.t.f.s.CallFastDataMasker: #0: 2022-08-18 17:21:48.423 main - Masking of data type VARGRAPHIC not supported for DB2
The problem can be found later in the logs:
2022-08-18 13:21:49.462 UTC [INFO ] [SimpleAsyncTaskExecutor-2] --- [U:][M:][P:] c.c.t.f.s.CallFastDataMasker: #0: 2022-08-18 17:21:48.423 main - message not found Masking for function:HASHLOV for language:en()
2022-08-18 13:21:49.462 UTC [INFO ] [SimpleAsyncTaskExecutor-2] --- [U:][M:][P:] c.c.t.f.s.CallFastDataMasker: #0: 2022-08-18 17:21:48.423 main - Masking of data type VARGRAPHIC not supported for DB2
2022-08-18 13:21:49.462 UTC [INFO ] [SimpleAsyncTaskExecutor-2] --- [U:][M:][P:] c.c.t.f.s.CallFastDataMasker: #0: 2022-08-18 17:21:48.424 main - close: closing down. Final job state: FAILED
We believe the problem is the first field you are trying to use HASHLOV on has an invalid data type.
CREATE TABLE "DMP_STG "."S1500_020_COLLSMST" (
"CS_FNAME" VARGRAPHIC(250 CODEUNITS16) ,
"LOAD_DATE" TIMESTAMP ,
"CS_CIF_NO" VARCHAR(15 OCTETS) ,
"CS_BASE_NO" VARCHAR(15 OCTETS) ,
"CS_PROD_CODE" VARCHAR(10 OCTETS) ,
"CS_PROD_TYPE" VARCHAR(5 OCTETS) ,
Masking of data type VARGRAPHIC not supported for DB2
(As of 4.10.x of portal and FDM)