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
| 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 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Performance Improvements for SAS® Customer Intelligence Studio 5.1
| Date Modified: | 2009-07-14 12:52:40 |
| Date Created: | 2009-06-25 14:26:00 |
