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
 |  |  |  |  |
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 Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Federation Server | Solaris for x64 | 4.2 | 4.2 | 9.4 TS1M3 | 9.4 TS1M5 |
| Linux for x64 | 4.2 | 4.2 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Microsoft® Windows® for x64 | 4.2 | 4.2 | 9.4 TS1M3 | 9.4 TS1M5 | ||
A fix for this issue for SAS Federation Server 4.2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/Y46.html#59933
Several data-masking functions abend when using a null for a value in SAS Federation Server 4.2.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2018-10-12 11:51:46 |
| Date Created: | 2017-02-09 11:50:35 |