Problem Note 16898: Change Data Capture adds invalid records to an ODS table in SAS/ACCESS Interface to SAP BW software
 |  |  |  |  |
When using SAS/ACCESS® Interface to SAP BW software to perform a delta extraction using change data capture, a change log is created which contains records for individual ODS keys. If the change log of a request contains multiple records with the same ODS key, then all records are used for updating the ODS table in SAS. This results in multiple records for this ODS key, which is incorrect.
The work-around is to perform a post-extraction step on the ODS table and use the last record of an ODS key group only.
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 | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to R/3 | Microsoft Windows XP Professional | 9.1 TS1M0 | 9.1 TS1M3 |
| Microsoft Windows NT Workstation | 9.1 TS1M0 | 9.1 TS1M3 | ||
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M0 | 9.1 TS1M3 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M0 | 9.1 TS1M3 | ||
| Microsoft Windows 2000 Server | 9.1 TS1M0 | 9.1 TS1M3 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M0 | 9.1 TS1M3 | ||
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M0 | 9.1 TS1M3 | ||
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M0 | 9.1 TS1M3 | ||
| Microsoft Windows 2000 Professional | 9.1 TS1M0 | 9.1 TS1M3 | ||
| 64-bit Enabled Solaris | 9.1 TS1M0 | 9.1 TS1M3 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M0 | 9.1 TS1M3 | ||
| Linux | 9.1 TS1M0 | 9.1 TS1M3 | ||
| HP-UX IPF | 9.1 TS1M0 | 9.1 TS1M3 | ||
| OpenVMS Alpha | 9.1 TS1M0 | 9.1 TS1M3 | ||
| 64-bit Enabled AIX | 9.1 TS1M0 | 9.1 TS1M3 | ||
| Tru64 UNIX | 9.1 TS1M0 | 9.1 TS1M3 | ||
A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:
http://www.sas.com/techsup/download/hotfix/e9_sbcs_prod_list.html#016898A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at :
http://www.sas.com/techsup/download/hotfix/e9_dbcs_prod_list.html#016898| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2006-01-31 08:39:00 |
| Date Created: | 2006-01-19 14:24:00 |