Problem Note 41389: The message "Validation Failed: Invalid Claims WHERE clause" appears after you edit Analysis Settings for the Enterprise-Analytic process
 |  |  |  |  |
After you edit the Analysis Settings for the Enterpise-Analytic process from the Emerging Issues section of the Administration workspace, a dialog box with the following message appears:
The message appears though the Claims WHERE clause is correct.
This issue occurs when a column from the Products table is used in the WHERE clause. The problem results because the application incorrectly validates the Claims WHERE clause against only the claims table. The clause should be validated against a join of both the Products and the Claims tables.
Because only the validation is incorrect, you can dismiss the dialog box with the error message.
A hox fix is planned for this this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Warranty Analysis | HP-UX IPF | 4.2 | 4.3 | 9.2 TS2M3 | 9.2 TS2M3 |
| 64-bit Enabled Solaris | 4.2 | 4.3 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| 64-bit Enabled AIX | 4.2 | 4.3 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2008 for x64 | 4.2 | 4.3 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2008 | 4.2 | 4.3 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 for x64 | 4.2 | 4.3 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.2 | 4.3 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 4.3 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 4.3 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Linux for x64 | 4.2 | 4.3 | 9.2 TS2M3 | 9.2 TS2M3 | ||
A fix for this issue for SAS Warranty Analysis 4.2_M1 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/D12.html#41389| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2010-12-08 09:28:17 |
| Date Created: | 2010-10-26 07:38:17 |