SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 59933: When you use a null value in data-masking functions in SAS® Federation Server 4.2, "Error: HY000 Error occurred building the Execution Tree..." occurs

DetailsHotfixAboutRate It

A query that contains a null value in data-masking functions generates an error in SAS Federation Server 4.2.  For example, the following mask function illustrates the problem:

SELECT SYSCAT.DM.MASK('RANSTR', NULL, 'MINPREC', 10, 'SOURCE', 'Hello World')

This function produces the following error:

Error: HY000 Error occurred building the Execution Tree. Error occurred initiating Filter.

If you pass in a value instead of the null, the query runs without any problems:

SELECT SYSCAT.DM.MASK('RANSTR', 151281359, 'MINPREC', 10, 'SOURCE', 'Hello World')

Click the Hot Fix tab in this note to access the hot fix for this issue.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Federation ServerSolaris for x644.24.29.4 TS1M39.4 TS1M5
Linux for x644.24.29.4 TS1M39.4 TS1M5
Microsoft® Windows® for x644.24.29.4 TS1M39.4 TS1M5
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.