SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 59892: The orm_job_create_all_full_load.sas job in SAS® Enterprise GRC fails when the customMessages.properties file contains duplicate entries

DetailsHotfixAboutRate It

If the customMessages.properties file in SAS Enterprise GRC contains more than one entry with the same key, the orm_job_create_all_full_load.sas job might fail. When the problem occurs, the log file contains the following error:

ERROR: Subquery evaluated to more than one row.

To work around the problem, remove duplicate keys from the customMessages.properties file before running the orm_job_create_all_full_load.sas job.

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 Enterprise GRCWindows 7 Enterprise x646.19.4 TS1M2
Windows 7 Home Premium 32 bit6.19.4 TS1M2
Windows 7 Enterprise 32 bit6.19.4 TS1M2
Microsoft Windows Server 2012 Std6.19.4 TS1M2
Microsoft Windows Server 2012 R2 Std6.19.4 TS1M2
Microsoft Windows Server 2012 R2 Datacenter6.19.4 TS1M2
Microsoft Windows Server 2012 Datacenter6.19.4 TS1M2
Microsoft Windows Server 2008 for x646.19.4 TS1M2
Microsoft Windows Server 2008 R26.19.4 TS1M2
Microsoft Windows Server 20086.19.4 TS1M2
Microsoft Windows 106.19.4 TS1M2
Microsoft Windows 8.1 Pro x646.19.4 TS1M2
Microsoft Windows 8.1 Pro 32-bit6.19.4 TS1M2
Microsoft Windows 8.1 Enterprise x646.19.4 TS1M2
Microsoft Windows 8.1 Enterprise 32-bit6.19.4 TS1M2
Microsoft® Windows® for x646.19.4 TS1M2
Microsoft Windows 8 Enterprise 32-bit6.19.4 TS1M2
Microsoft Windows 8 Enterprise x646.19.4 TS1M2
Microsoft Windows 8 Pro 32-bit6.19.4 TS1M2
Microsoft Windows 8 Pro x646.19.4 TS1M2
Windows 7 Home Premium x646.19.4 TS1M2
Windows 7 Professional 32 bit6.19.4 TS1M2
Windows 7 Professional x646.19.4 TS1M2
Windows 7 Ultimate 32 bit6.19.4 TS1M2
Windows 7 Ultimate x646.19.4 TS1M2
64-bit Enabled AIX6.19.4 TS1M2
64-bit Enabled Solaris6.19.4 TS1M2
HP-UX IPF6.19.4 TS1M2
Linux for x646.19.4 TS1M2
Solaris for x646.19.4 TS1M2
* 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.