Problem Note 46995: SAS® Enterprise GRC might report errors when you are working with Risk Event Types and Control Types in Questionnaire Templates
 |  |  |  |  |
Working with Questionnaire Templates in SAS Enterprise GRC, errors might occur when you try to perform actions related to Risk Event Types or Control Types.
If you try to add a Risk Event Type or Control Type, you might get an error message:
If you try to search the Risk Event Type table or the Control Type table, then your browser might report an "HTTP 500" error message.
If you try to export the Risk Event Type table or the Control Type table to Excel, then your browser might report an "HTTP 404" error message.
After any of these errors occur, the database connection for SAS Enterprise GRC is lost. You are not able to log on to SAS Enterprise GRC. You must restart the application server.
This problem happens when you define thousands of Risk Event Types or thousands of Control Types.
There is no workaround to the problem.
Click the Hot Fix tab in this note to access the hot fix for this issue.
With the hot fix, two new configuration properties can be added to the configdata.properties file:
- monitor.custfield.sort.riskEventTypes=false
- monitor.custfield.sort.controlTypes=false
Setting these configuration properties to false disables sorting for custom fields for Risk Event Types and Control Types. The errors do not occur with these configuration properties set to false.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Enterprise GRC | Microsoft® Windows® for x64 | 4.3 | 5.1_M3 | 9.2 TS2M3 | 9.3 TS1M2 |
| Microsoft Windows Server 2003 Datacenter Edition | 4.3 | 5.1_M3 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.3 | 5.1_M3 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.3 | 5.1_M3 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2003 for x64 | 4.3 | 5.1_M3 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2008 | 4.3 | 5.1_M3 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2008 for x64 | 4.3 | 5.1_M3 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Microsoft Windows XP Professional | 4.3 | 5.1_M3 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Windows 7 Enterprise 32 bit | 4.3 | 5.1_M3 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Windows 7 Enterprise x64 | 4.3 | 5.1_M3 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Windows 7 Home Premium 32 bit | 4.3 | 5.1_M3 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Windows 7 Home Premium x64 | 4.3 | 5.1_M3 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Windows 7 Professional 32 bit | 4.3 | 5.1_M3 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Windows 7 Professional x64 | 4.3 | 5.1_M3 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Windows 7 Ultimate 32 bit | 4.3 | 5.1_M3 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Windows 7 Ultimate x64 | 4.3 | 5.1_M3 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Windows Vista | 4.3 | 5.1_M3 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Windows Vista for x64 | 4.3 | 5.1_M3 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| 64-bit Enabled AIX | 4.3 | 5.1_M3 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| 64-bit Enabled Solaris | 4.3 | 5.1_M3 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| HP-UX IPF | 4.3 | 5.1_M3 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Linux for x64 | 4.3 | 5.1_M3 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Solaris for x64 | 4.3 | 5.1_M3 | 9.2 TS2M3 | 9.3 TS1M2 | ||