Problem Note 37200: An error occurs when you run a SAS® Warranty Analysis emerging issues process with the data mart residing on a SAS® Scalable Performance Data Server®
 |  |  |  |  |
When you run an emerging issues (EI) process with the data mart residing on a SAS Scalable Performance Data Server (SAS® SPD Server), it ends with the following error:
ERROR: Variable product_sk already exists on file SWADM.WARRANTY_CLAIM_FACT.
The error occurs because in the util_geteifiltereddata.sas file, a DATA step is renamed, even if it is not necessary. While SAS data sets do not experience errors when a DATA step is renamed unconditionally, this is not the case with the SAS SPD Server.
No workaround is available.
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 Warranty Analysis | Microsoft Windows Server 2003 Datacenter Edition | 4.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M2 |
| Microsoft Windows Server 2003 Enterprise Edition | 4.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M2 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M2 | ||
| 64-bit Enabled AIX | 4.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M2 | ||
| 64-bit Enabled Solaris | 4.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M2 | ||
| HP-UX IPF | 4.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M2 | ||
A fix for this issue for SAS Warranty Analysis 4.1 is available at:
http://www.sas.com/techsup/download/hotfix/warnty41.html#037200
The following error occurs when running an emerging issues process:
"ERROR: Variable product_sk already exists on file SWADM.WARRANTY_CLAIM_FACT."
The error occurs because in the util_geteifiltereddata.sas file, a DATA step is renamed, even if not necessary.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2009-10-16 11:16:40 |
| Date Created: | 2009-09-17 16:25:38 |