Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile

• Print  |
• Feedback  |
• Share

  • E-mail

  
  
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

If you are using Change Management within SAS^® ETL Studio you may receive a MDEXCEPTION error with text similar to the following:

"This transaction failed because it attempts to implicitly update/delete an associated object in repository XXXXXXXX and this repository does not have a dependency defined in the repository identified in the XML request. We suggest you also notify your metadata administrator that a dependency no longer exists between the repositories."

When logged into a Foundation or Custom repository, this error can occur when attempting to Save or Delete an existing ETL Job.

When logged into a Project repository, this error can occur when attempting to Check Out or Check In an existing ETL Job.

This problem gets introduced into the metadata when a Job is Checked In from a Project repository, and the Job contains associated objects that exceed 1000 characters (e.g. User-written transformation code stored in metadata, Descriptions, Where Clauses, Expressions).

Once the problem has been introduced, the effected Job can no longer be Saved, Checked In, or Deleted without receiving a variation on the error listed above.

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

Operating System and Release Information

A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at :