Problem Note 48458: SAS® Data Integration Studio jobs with Loop transformations incorrectly complete with nonzero return codes
SAS Data Integration Studio jobs that are executed in batch incorrectly complete with a nonzero return code under the following conditions:
- The job contains a Loop transformation.
- Iterations within the Loop transformation processing are being executed in parallel.
- During code execution at least one sign-on attempt fails, but a subsequent attempt to sign on succeeds.
- The job completes without any errors.
Scheduling tools (for example, Platform LSF, or OS Host Scheduler) interpret this nonzero return code as a job failure. This results in the termination of any remaining processing that depends on successful job completion.
The incorrect return code is caused by the following events:
One workaround for this problem is to insert the following SAS code in the Postcode panel under Job Properties on the Precode and Postcode tab. This code checks the job return code (job_rc) and resets SYSCC to 0 if there were no errors during job execution:
%macro Reset_SYSCC;
%if &job_rc = 0 and &SYSCC ne 0 %then %let SYSCC=0;
%mend Reset_SYSCC;
%Reset_SYSCC
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
SAS System | SAS Data Integration Studio | Microsoft® Windows® for x64 | 4.2 | 4.4_M1 | 9.2 TS2M0 | 9.3 TS1M2 |
Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 4.4_M1 | 9.2 TS2M0 | 9.3 TS1M2 |
Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 4.4_M1 | 9.2 TS2M0 | 9.3 TS1M2 |
Microsoft Windows Server 2003 Standard Edition | 4.2 | 4.4_M1 | 9.2 TS2M0 | 9.3 TS1M2 |
Microsoft Windows Server 2003 for x64 | 4.2 | 4.4_M1 | 9.2 TS2M0 | 9.3 TS1M2 |
Microsoft Windows Server 2008 for x64 | 4.2 | 4.4_M1 | 9.2 TS2M0 | 9.3 TS1M2 |
Microsoft Windows XP Professional | 4.2 | 4.4_M1 | 9.2 TS2M0 | 9.3 TS1M2 |
Windows Vista | 4.2 | 4.4_M1 | 9.2 TS2M0 | 9.3 TS1M2 |
Windows Vista for x64 | 4.2 | 4.4_M1 | 9.2 TS2M0 | 9.3 TS1M2 |
*
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: | medium |
Date Modified: | 2012-11-19 12:29:38 |
Date Created: | 2012-11-13 10:49:30 |