Problem Note 38009: Sequence numbers might reset to 0 after you migrate from SAS® Customer Intelligence 5.1 to SAS Customer Intelligence 5.3
 |  |  |  |  |
After you upgrade and migrate SAS Customer Intelligence 5.1 to 5.3, the automatically generated sequence numbers that are used by various objects within SAS Customer Intelligence might reset to 0. The numbers might also reset with a new SAS Customer Intelligence 5.3 installation if a Mamisc.Sequence table already exists and is in SAS 9.1.3 format rather than SAS 9.2 format.
This is a serious problem because it could result in the generation of duplicate sequence numbers.
If duplicate sequence numbers are generated, then the sequence table will need to be manually rebuilt. Contact SAS Technical Support for assistance if you need to rebuild the sequence table.
Click 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 Customer Intelligence Core Mid-Tier | Microsoft® Windows® for x64 | 5.3 | 5.3_M2 | 9.2 TS2M2 | 9.2 TS2M3 |
| Microsoft Windows Server 2003 Datacenter Edition | 5.3 | 5.3_M2 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 5.3 | 5.3_M2 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Standard Edition | 5.3 | 5.3_M2 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2008 | 5.3 | 5.3_M2 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Microsoft Windows XP Professional | 5.3 | 5.3_M2 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Windows Vista | 5.3 | 5.3_M2 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| 64-bit Enabled AIX | 5.3 | 5.3_M2 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| 64-bit Enabled Solaris | 5.3 | 5.3_M2 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| HP-UX IPF | 5.3 | 5.3_M2 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Linux for x64 | 5.3 | 5.3_M2 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Solaris for x64 | 5.3 | 5.3_M2 | 9.2 TS2M2 | 9.2 TS2M3 | ||
A fix for this issue for SAS Marketing Automation Data Server 5.3 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/A84.html#38009| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2009-12-16 09:13:23 |
| Date Created: | 2009-12-03 08:26:49 |