SUPPORT / SAMPLES & SAS NOTES
Usage Note 36362: SAS® Customer Intelligence Concurrency performance improvements
 |  |  |  |  |
The following changes have been made available for SAS® Customer Intelligence Studio 5.1 via a hot fix, resulting in performance improvements:
- Replace statements have been eliminated, because new records need to be
added and existing records do not have any changes, so they should not be replaced.
Previously, the replacement statements in the mastspub.sas macro could cause collisions in
Oracle and cause an error message like the following in the stored process:
ERROR: Update/delete failed. The observation may have been changed or deleted since the time it was read. ORACLE execute error: ORA-08177: can't serialize access for this transaction.
- Handling of concurrency within the MAInformationMap has been improved to prevent the following warning from occurring in the macore.log:
[WARN ] SAS Demo User ics.crm.custdata.datapattern.MAIQService - Exception null executing MAQuery. Dumping stack, backing off and trying unoptimized execution
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 Customer Intelligence Studio | Microsoft Windows 2000 Advanced Server | 5.1 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Datacenter Server | 5.1 | 9.1 TS1M3 SP4 | ||||
| Microsoft Windows 2000 Server | 5.1 | 9.1 TS1M3 SP4 | ||||
| Microsoft Windows 2000 Professional | 5.1 | 9.1 TS1M3 SP4 | ||||
| Microsoft Windows NT Workstation | 5.1 | 9.1 TS1M3 SP4 | ||||
| Microsoft Windows Server 2003 Datacenter Edition | 5.1 | 5.3 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 5.1 | 5.3 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 5.1 | 5.3 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows XP Professional | 5.1 | 5.3 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Windows Vista | 5.1 | 5.3 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||