Problem Note 37484: Performance and data-integrity issues are possible with the REREAD_EXPOSURE=YES and UPDATEBUFF= options in SAS® 9.2
 |  |  |  |  |
In SAS/ACCESS® 9.2 Interface to Oracle, you might notice performance and data-integrity issues when you use a MODIFY statement in a DATA step. Incorrect rows might be updated. In addition, it might take unusually long for the updates to take place when you use the UPDATEBUFF= option or the REREAD_EXPOSURE=YES option when you try to update an Oracle table.
No errors are generated. However, if you check the rows, you will see that rows are updated that should not have been updated, while rows that should be updated are not.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Note: This issue has been fixed in the third maintenance release for SAS® 9.2 (TS2M3).
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Oracle | 64-bit Enabled Solaris | 9.2 TS1M0 | 9.2 TS2M3 |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.2 TS1M0 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.2 TS1M0 | 9.2 TS2M3 | ||
| OpenVMS on HP Integrity | 9.2 TS1M0 | 9.2 TS2M3 | ||
| Linux for x64 | 9.2 TS1M0 | 9.2 TS2M3 | ||
| Linux | 9.2 TS1M0 | 9.2 TS2M3 | ||
| Solaris for x64 | 9.2 TS1M0 | 9.2 TS2M3 | ||
| HP-UX IPF | 9.2 TS1M0 | 9.2 TS2M3 | ||
| 64-bit Enabled HP-UX | 9.2 TS1M0 | 9.2 TS2M3 | ||
| 64-bit Enabled AIX | 9.2 TS1M0 | 9.2 TS2M3 | ||
| Windows Vista for x64 | 9.2 TS1M0 | 9.2 TS2M3 | ||
| Windows Vista | 9.2 TS1M0 | 9.2 TS2M3 | ||
| Microsoft Windows XP Professional | 9.2 TS1M0 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Standard Edition | 9.2 TS1M0 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 9.2 TS1M0 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 9.2 TS1M0 | 9.2 TS2M3 | ||
| Microsoft® Windows® for x64 | 9.2 TS1M0 | 9.2 TS2M3 | ||
| Microsoft Windows XP 64-bit Edition | 9.2 TS1M0 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.2 TS1M0 | 9.2 TS2M3 | ||
A fix for this issue for SAS/ACCESS Interface to Oracle 9.21_M1 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/A70.html#37484| Type: | Problem Note |
| Priority: | high |
| Topic: | Data Management ==> Data Sources ==> External Databases ==> Oracle |
| Date Modified: | 2010-08-12 12:48:44 |
| Date Created: | 2009-10-16 11:19:52 |