SUPPORT / SAMPLES & SAS NOTES
Problem Note 19849: If the USER_FIELD_ID field is blank a sort order problem can occur in the OWNER_REPORT program
 |  |  |  |  |
If the USER_LONG_ID field is blank and you merge users and the alerts that they own, the following error message can occur in the OWNER_REPORT:
"BY variables are not properly sorted"
The problem occurs because the field USER_LONG_ID is blank, then it is formatted with the the value of 'NO OWNER'. The table, work.creator_count2, then does not merge with the other data in the subsequent step because it is not sorted correctly.
Select 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 Anti-Money Laundering Alert Generation Server | Microsoft Windows XP Professional | 2.1 | 2.2 | 9.1 TS1M3 SP4 | |
| Microsoft Windows NT Workstation | 2.1 | 2.2 | 9.1 TS1M3 SP4 | |||
| Microsoft Windows 2000 Server | 2.1 | 2.2 | 9.1 TS1M3 SP4 | |||
| Microsoft Windows 2000 Datacenter Server | 2.1 | 2.2 | 9.1 TS1M3 SP4 | |||
| Microsoft Windows 2000 Advanced Server | 2.1 | 2.2 | 9.1 TS1M3 SP4 | |||
| Linux | 2.1 | 2.2 | 9.1 TS1M3 SP4 | |||
| Solaris | 2.1 | 2.2 | 9.1 TS1M3 SP4 | |||
| 64-bit Enabled Solaris | 2.1 | 2.2 | 9.1 TS1M3 SP4 | |||
| Microsoft Windows 2000 Professional | 2.1 | 2.2 | 9.1 TS1M3 SP4 | |||
| 64-bit Enabled AIX | 2.1 | 2.2 | 9.1 TS1M3 SP4 | |||
| AIX | 2.1 | 2.2 | 9.1 TS1M3 SP4 | |||