Are you using database clusters? There are currently issues when replicating from SQL clusters to a roll-up database.
We are not using SQL clusters. Single instance for each DB.
1 of 1 people found this helpful
I've also seen a case where the Inventoried Vendor for Managed Planet products is NULL (empty) while the RollUp core accepts no NULL's in this attribute.
You can fix this by running the following SQL query on the databases that need to be rolled up (as always, although this is a harmless query, please make sure you have a proper backup of your DB before running this):
with MP (ManID) as
select SLM_Manufacturer_Idn from SLM_Manufacturer where name = 'LANDesk(R) Software'
set Manufacturer_Idn = ManID, Orig_Manufacturer_Idn = ManID
where Manufacturer_Idn is null
We have been working with the developers over the last few months and they were able to correct a number of issues that have resolved most of the replication problems. There are still a couple things they are working on, but for the most part it is looking better.