ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Issue with masking with RESTART in FDM 4.9.143.0

book

Article ID: 212354

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Hello,

With version 4.9.143.0 we have an using the restart column. Using 10 process at the sametime. 

For some reason at the end of the process, to update the field to de_ident_ind = 'P' we get deadlock.

FDM sends, 10 process like this :

WITH TempResult AS(
SELECT "NUM_FOLI_ENCO","ID_SEQ_EADM", de_ident_ind
FROM "EADM_TEST"."TDM_FDM_001" WHERE 1 = 1
ORDER BY "ID_SEQ_EADM" ASC OFFSET 0 ROWS FETCH NEXT 100000 ROWS ONLY
)
select "NUM_FOLI_ENCO","ID_SEQ_EADM" FROM TempResult WHERE de_ident_ind IS NULL OR de_ident_ind IN ('N', 'U')

The next step is the query (below), but there is no filtering on (SC OFFSET 0 ROWS FETCH NEXT 100000 ROWS ONLY) : 

update EADM_TEST.TDM_FDM_001 set de_ident_ind = 'P' WHERE de_ident_ind = 'U'

So you get 10 time of the same query to update. We get a deadlock.

 

Environment

Release : 4.9

Component : CA Test Data Manager - Fast Data Masker

Resolution

Resolved in FastDataMasker-4.9.149.0.zip