SUPPORT / SAMPLES & SAS NOTES
Problem Note 40247: SAS® Web Analytics 5.3.1 datamart MD5 tables must be recreated during migration to 5.3.3
 |  |  |  |  |
During migration from SAS® Web Analytics 5.3.1 to 5.3.3, duplicate "natural keys" are present in the MD5 dimension tables. Values in MD5 tables must be unique. If duplicates are present, errors similar to the following can occur:
MPRINT(WEBA_SET_REFERRER_TYPE_CD): proc format cntlin=work.cntlin; ERROR: This range is repeated, or values overlap: wlseures.cc.cec.eu.int-wlseures.cc.cec.eu.int. MPRINT(WEBA_SET_REFERRER_TYPE_CD): run; WARNING: RUN statement ignored due to previous errors. Submit QUIT; to terminate the procedure.
The problem is caused by code in SAS Web Analytics 5.3.1 that
created the MD5 values.
When these records are migrated using the SAS Web Analytics 5.3.3 code, the
resulting MD5 values are identical, and
the page_md5 data set contains duplicate MD5 values.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Web Analytics | Microsoft® Windows® for x64 | 5.3_M3 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 5.3_M3 | 9.2 TS2M3 | ||||
| Microsoft Windows Server 2003 Enterprise Edition | 5.3_M3 | 9.2 TS2M3 | ||||
| Microsoft Windows Server 2003 Standard Edition | 5.3_M3 | 9.2 TS2M3 | ||||
| Microsoft Windows Server 2003 for x64 | 5.3_M3 | 9.2 TS2M3 | ||||
| Microsoft Windows Server 2008 | 5.3_M3 | 9.2 TS2M3 | ||||
| Microsoft Windows Server 2008 for x64 | 5.3_M3 | 9.2 TS2M3 | ||||
| Microsoft Windows XP Professional | 5.3_M3 | 9.2 TS2M3 | ||||
| Windows 7 Enterprise 32 bit | 5.3_M3 | 9.2 TS2M3 | ||||
| Windows 7 Enterprise x64 | 5.3_M3 | 9.2 TS2M3 | ||||
| Windows 7 Home Premium 32 bit | 5.3_M3 | 9.2 TS2M3 | ||||
| Windows 7 Home Premium x64 | 5.3_M3 | 9.2 TS2M3 | ||||
| Windows 7 Professional 32 bit | 5.3_M3 | 9.2 TS2M3 | ||||
| Windows 7 Professional x64 | 5.3_M3 | 9.2 TS2M3 | ||||
| Windows 7 Ultimate 32 bit | 5.3_M3 | 9.2 TS2M3 | ||||
| Windows 7 Ultimate x64 | 5.3_M3 | 9.2 TS2M3 | ||||
| Windows Vista | 5.3_M3 | 9.2 TS2M3 | ||||
| Windows Vista for x64 | 5.3_M3 | 9.2 TS2M3 | ||||
| 64-bit Enabled AIX | 5.3_M3 | 9.2 TS2M3 | ||||
| 64-bit Enabled Solaris | 5.3_M3 | 9.2 TS2M3 | ||||
| HP-UX IPF | 5.3_M3 | 9.2 TS2M3 | ||||
| Linux for x64 | 5.3_M3 | 9.2 TS2M3 | ||||
| Solaris for x64 | 5.3_M3 | 9.2 TS2M3 | ||||