The sys_domain_path value in my update set does not look correct - Support and Troubleshooting

The sys_domain_path value in my update set does not look correct Details When domain support is enabled on an instance, update sets for domain separated tables include and elements. When looking at the XML generated, in some cases the value of does not match the domain specified by .

This is not an issue because when the update set is imported, only they value is used to determine the domain. During import the value of must be recalculated. This is because there are use cases where the may have been modified between the time the update set was created and the time it is imported.

Example A One example is when importing an update set into a separate instance. Both instances may have the same domain hierarchy but the domain paths can be different. Therefore the import process must recalculate the value of based on .

Say both instances have a domain hierarchy where ACME and Initech are under TOP. In one instance the sys_domain_path values may be

TOP = !!!/ ACME = !!!/!!$/ Initech = !!!/!!!/

It is possible that in the other instance they are different

TOP = !!!/ ACME = !!!/!!!/ Initech = !!!/!!$/

So the value of sys_domain_path must be recalculated during the import process.

Example B Another example is when importing an update set into the same instance (or a different instance) after the domain hierarchy has changed. In this case one or more domain paths are going to be different at the time the data is imported.

Say we again start with a domain hierarchy where domains ACME and Initech are both under TOP:

TOP = !!!/ ACME = !!!/!!!/ Initech = !!!/!!$/

After an update set is created, we realize that Initech should really be under ACME so the hierarchy is modified. Our new domain hierarchy might be:

TOP = !!!/ ACME = !!!/!!!/ Initech = !!!/!!!/!!!/

When the update set is imported, the sys_domain_path for Initech is no longer the same and must be recalculated.

Additional Information Avoiding domain path in scripts