Problem Note 20576: Jobs that contain SCD Type 2 Loader transformations can fail when you
attempt to execute them simultaneously
If you have multiple jobs that meet the following criteria:
1. The jobs contain an SCD Type 2 Loader transformation
2. The target tables for the SCD Type 2 Loader transfomations reside in
a database management system (DBMS)library like Oracle or DB2.
3. The Schema and User options are the same for the target table
library definitions.
4. The jobs are executed simultaneously.
One or more of the job executions might fail due to temporary library
file contention in the DBMS temporary work area.
To avoid this contention, modify the following table names in the
generated code so they are different across all jobs:
ETLS_NEWRCDS
ETLS_MATCH
ETLS_CLOSE
This issue will be addressed in an upcoming hot fix.
Operating System and Release Information
| SAS System | SAS Data Integration Studio | Microsoft Windows Server 2003 Enterprise Edition | 3.3 | 4.2 | 9.1 TS1M3 SP3 | 9.2 TS1M0 |
| Microsoft Windows Server 2003 Standard Edition | 3.3 | 4.2 | 9.1 TS1M3 SP3 | 9.2 TS1M0 |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 3.3 | 4.2 | 9.1 TS1M3 SP3 | 9.2 TS1M0 |
| Microsoft Windows XP Professional | 3.3 | 4.2 | 9.1 TS1M3 SP3 | 9.2 TS1M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 3.3 | 4.2 | 9.1 TS1M3 SP3 | 9.2 TS1M0 |
| Microsoft Windows 2000 Server | 3.3 | 4.2 | 9.1 TS1M3 SP3 | 9.2 TS1M0 |
| Microsoft Windows 2000 Advanced Server | 3.3 | 4.2 | 9.1 TS1M3 SP3 | 9.2 TS1M0 |
| Microsoft Windows 2000 Datacenter Server | 3.3 | 4.2 | 9.1 TS1M3 SP3 | 9.2 TS1M0 |
| Microsoft Windows 2000 Professional | 3.3 | 4.2 | 9.1 TS1M3 SP3 | 9.2 TS1M0 |
*
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.
| Type: | Problem Note |
| Priority: | alert |
| Date Modified: | 2008-03-18 11:47:52 |
| Date Created: | 2007-07-10 15:15:02 |
