Error using LARGETABLESPLITENABLED option with masking function SQLFUNCTION

book

Article ID: 141979

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Hello,

 

We have an issue with the query that is getting build using SQLFUNCTION in the masking. 

 

We have seen the issue with Oracle and SQL SERVER. 

 

Masking logs show

 

2019-12-02 10:50:13.791 Thread:6 - Error executing select statement for update

2019-12-02 10:50:13.791 Thread:6 - No column name was specified for column 1 of 'A'.

2019-12-02 10:50:13.791 Thread:6 - selectSQL: SELECT [DOUTILS].[SCRAMBLE].[trouver_transit]('ABC_TRANSIT',inst, transit),"Transit","Folio","Compte","EADM_GuiID"

FROM

(SELECT  [DOUTILS].[SCRAMBLE].[trouver_transit]('DESJ_TRANSIT',inst, transit),"Transit","Folio","Compte","EADM_GuiID",  de_ident_ind, ROW_NUMBER() OVER (ORDER BY "EADM_GuiID" ) R

FROM "dbo"."TB_ACT_CREANCE_MENSUEL_ARCHIVES_HIST"

WHERE 1 = 1

) A

WHERE  A.R > 0

AND A.R  <= 1000000  AND de_ident_ind IS NULL

 

 

Environment

Release : 4.8

Version of FDM  : 4.8.140

Component : CA Test Data Manager

Resolution

This issue is fixed  in  patch   FastDataMasker-4.8.152.0