The Orphaned Job Component tool incorrectly identifies valid SAS^® Data Integration Studio job metadata targetTransformation Set objects as orphaned metadata during the analysis step. The repair step removes the identified job metadata objects.

The Metadata Analyze and Repair tools, which you can access from the Metadata Manager node in SAS^® Management Console, enable you to run selected tests on metadata to locate common problems. When it is possible, the tools also repair problems that the analysis identifies. The tools are available with the Analyze and Repair Metadata Batch Tool (sas-analyze-metadata).

The Orphaned Job Component tool checks the metadata repository for metadata that is no longer associated with its job. This tool has several component tools. Each component has a set of rules that are used to determine whether the metadata in question is orphaned from its orginal job. Listed for each component tool is the associations and attributes that will be checked. The object is an orphan if all the listed associations are empty and the attribute values are as specified. One of the rules that determine orphaned Job metadata uses code that looks for source transformations but not a target transformation for Select objects.

The tool assumes that Select objects will be identified as orphans whenever the source transformations are missing. There are some cases where Set objects have target-transformation objects, but no source-transformation objects. If it is identified as an orphan, the valid metadata is removed from the repository.

To prevent the removal of the incorrectly identified orphaned job metadata, it is recommended that you do not run the Orphaned Job Component tool. De-select the tool in the Analyze and Repair Metadata utility.

In addition, when you use the Analyze and Repair Metadata Batch tool (sas-analyze-metadata) do not specify -tool OrphJob.

Note: The Orphaned Job Component tool also runs if you submit the following:

To prevent the Orphan Job Metadata tool from running, submit the following command:

Click the Hot Fix tab in this note to access the hot fix for this issue.

Note: This problem is fixed in the second maintenance release for SAS^® 9.4 (TS1M2).

Operating System and Release Information

Product Family	Product	System	Product Release		SAS Release
			Reported	Fixed*	Reported	Fixed*
SAS System	SAS Management Console	64-bit Enabled Solaris	9.3_M2	9.4_M2	9.3 TS1M2	9.4 TS1M2
		64-bit Enabled HP-UX	9.3_M2	9.4_M2	9.3 TS1M2	9.4 TS1M2
		64-bit Enabled AIX	9.3_M2	9.4_M2	9.3 TS1M2	9.4 TS1M2
		Windows Vista for x64	9.3_M2		9.3 TS1M2
		Windows Vista	9.3_M2		9.3 TS1M2
		Windows 7 Ultimate x64	9.3_M2	9.4_M2	9.3 TS1M2	9.4 TS1M2
		Windows 7 Ultimate 32 bit	9.3_M2	9.4_M2	9.3 TS1M2	9.4 TS1M2
		Windows 7 Professional x64	9.3_M2	9.4_M2	9.3 TS1M2	9.4 TS1M2
		Windows 7 Professional 32 bit	9.3_M2	9.4_M2	9.3 TS1M2	9.4 TS1M2
		Windows 7 Home Premium x64	9.3_M2	9.4_M2	9.3 TS1M2	9.4 TS1M2
		Windows 7 Home Premium 32 bit	9.3_M2	9.4_M2	9.3 TS1M2	9.4 TS1M2
		Windows 7 Enterprise x64	9.3_M2	9.4_M2	9.3 TS1M2	9.4 TS1M2
		Windows 7 Enterprise 32 bit	9.3_M2	9.4_M2	9.3 TS1M2	9.4 TS1M2
		Microsoft Windows XP Professional	9.3_M2		9.3 TS1M2
		Microsoft Windows Server 2012 Std	9.3_M2	9.4_M2	9.3 TS1M2	9.4 TS1M2
		Microsoft Windows Server 2012 R2 Std	9.3_M2	9.4_M2	9.3 TS1M2	9.4 TS1M2
		Microsoft Windows Server 2012 R2 Datacenter	9.3_M2	9.4_M2	9.3 TS1M2	9.4 TS1M2
		Microsoft Windows Server 2012 Datacenter	9.3_M2	9.4_M2	9.3 TS1M2	9.4 TS1M2
		Microsoft Windows Server 2008 for x64	9.3_M2	9.4_M2	9.3 TS1M2	9.4 TS1M2
		Microsoft Windows Server 2008 R2	9.3_M2	9.4_M2	9.3 TS1M2	9.4 TS1M2
		Microsoft Windows Server 2008	9.3_M2	9.4_M2	9.3 TS1M2	9.4 TS1M2
		Microsoft Windows Server 2003 for x64	9.3_M2		9.3 TS1M2
		Microsoft Windows Server 2003 Standard Edition	9.3_M2		9.3 TS1M2
		Microsoft Windows Server 2003 Enterprise Edition	9.3_M2		9.3 TS1M2
		Microsoft Windows Server 2003 Datacenter Edition	9.3_M2		9.3 TS1M2
		Microsoft Windows 8.1 Pro 32-bit	9.3_M2	9.4_M2	9.3 TS1M2	9.4 TS1M2
		Microsoft Windows 8.1 Pro	9.3_M2	9.4_M2	9.3 TS1M2	9.4 TS1M2
		Microsoft Windows 8.1 Enterprise x64	9.3_M2	9.4_M2	9.3 TS1M2	9.4 TS1M2
		Microsoft Windows 8.1 Enterprise 32-bit	9.3_M2	9.4_M2	9.3 TS1M2	9.4 TS1M2
		Microsoft Windows 8 Pro x64	9.3_M2	9.4_M2	9.3 TS1M2	9.4 TS1M2
		Microsoft Windows 8 Pro 32-bit	9.3_M2	9.4_M2	9.3 TS1M2	9.4 TS1M2
		Microsoft Windows 8 Enterprise x64	9.3_M2	9.4_M2	9.3 TS1M2	9.4 TS1M2
		Microsoft Windows 8 Enterprise 32-bit	9.3_M2	9.4_M2	9.3 TS1M2	9.4 TS1M2
		Microsoft® Windows® for x64	9.3_M2	9.4_M2	9.3 TS1M2	9.4 TS1M2
		HP-UX IPF	9.3_M2	9.4_M2	9.3 TS1M2	9.4 TS1M2
		Linux	9.3_M2	9.4_M2	9.3 TS1M2	9.4 TS1M2
		Linux for x64	9.3_M2	9.4_M2	9.3 TS1M2	9.4 TS1M2
		Solaris for x64	9.3_M2	9.4_M2	9.3 TS1M2	9.4 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.

---

A fix for this issue for SAS Middle Tier 9.3_M2 is available at:

https://tshf.sas.com/techsup/download/hotfix/HF2/I14.html#54671

---

A fix for this issue for SAS Management Console 9.3_M2 is available at:

https://tshf.sas.com/techsup/download/hotfix/HF2/I15.html#54671

---

The Metadata Analyze and Repair tool, Orphaned Job Metadata, incorrectly identifies target-transformation objects that do not have a source transformation as orphaned metadata. These exceptions are removed, incorrectly, in the repair step. There are no warnings or errors.

Type:	Problem Note
Priority:	high

Date Modified:	2014-12-18 16:23:16
Date Created:	2014-11-19 11:39:23