Wait or force execution of "Download Replication" job attached to one engine on the DOMAIN.
Follow this procedure to avoid creation of a new query when an exported SD MSI package is imported to another DOMAIN/ENTERPRISE (DM/EM) :
- Open Microsoft SQL Server Management Studio and connect to target mdb database on DM/EM (where package should be imported). Execute following SQL Query in order to find the uuid of AM query « Target = Userprofile »
SELECT convert(uniqueidentifier, query_uuid) FROM ca_query_def
WHERE label = 'Target = Userprofile' and target_type=0
and domain_uuid=(SELECT set_val_uuid FROM ca_settings WHERE set_id=1)
- In Exported package edit the file reginfo\itemproc.dat with text editor.
On line UUID under section [Prereq1] of Advertise procedure [ItemProc1] replace the value by one found in step 1.
Save the file
- Import the package. Advertise procedure will use query « Target = Userprofile » which is already present in Enterprise database and replicated to all DOMAIN. Distribution of package should not be delayed waiting replication.