Service Manager 2019 UR2

%3CLINGO-SUB%20id%3D%22lingo-sub-2060123%22%20slang%3D%22en-US%22%3EService%20Manager%202019%20UR2%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2060123%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EHas%20anyone%20else%20installed%20this%3F%20I'm%20going%20from%20RTM%20straight%20to%20UR2%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-gb%2Fhelp%2F4558753%2Fupdate-rollup-2-for-system-center-service-manager-2019%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-gb%2Fhelp%2F4558753%2Fupdate-rollup-2-for-system-center-service-manager-2019%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFirstly%20there's%20a%20step%20to%20disable%20the%20DW%20job%20schedules%20and%20no%20corresponding%20step%20to%20re-enable%20them%20again%20so%20surely%20anyone%20following%20this%20will%20end%20up%20with%20no%20syncing%20DW%20anymore%20as%20none%20of%20the%20jobs%20will%20trigger%20after%20following%20the%20instructions%2C%20unless%20I'm%20missing%20something%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESecondly%20the%20instructions%20get%20you%20to%20delete%20all%20the%20cubes%2C%20change%20a%20couple%20of%20data%20types%20in%20the%20SSAS%20views%20and%20then%20reimport%20the%20cubes%20management%20packs%20afterwards.%20The%20problem%20is%20that%20that%20management%20pack%20bundle%20hasn't%20been%20updated%20by%20the%20patch%20(it%20tells%20you%20to%20reimport%20cubes.mpb%20from%20the%20service%20manager%20directory).%20So%20you%20change%20a%20couple%20of%20data%20types%20from%20int%20to%20decimal%2C%20reimport%20the%20existing%20cubes%20management%20pack%20bundle%20which%20then%20errors%20trying%20to%20recreate%20the%20cubes%20because%20source%20and%20target%20data%20types%20now%20differ%20-%20because%20you've%20just%20changed%20them.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20don't%20know%20if%20the%20patch%20was%20supposed%20to%20replace%20the%20mpb%20file%20with%20a%20newer%20version%20that%20expects%20decimal%20or%20something%20but%20it%20hasn't%20in%20our%20environment%2C%20I%20can't%20find%20an%20updated%20version%20anywhere%20inside%20the%20patch%20file%20and%20it%20isn't%20listed%20under%20files%20modified%20in%20the%20article.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFortunately%20I%20was%20able%20to%20snapshot%20the%20whole%20environment%20before%20the%20attempt%20so%20rolled%20back%20and%20have%20now%20installed%20the%20update%20again%2C%20skipped%20the%20whole%20%22After%20the%20installation%22%20section%20and%20just%20did%20the%20provider%20update%20section%20instead.%20Everything%20seems%20fine%20and%20the%20cubes%20all%20processed%20successfully%20last%20night.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHas%20anyone%20else%20tried%20this%20yet%20and%20had%20similar%20issue%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESteve%3C%2FP%3E%3C%2FLINGO-BODY%3E
Senior Member

Hi,

Has anyone else installed this? I'm going from RTM straight to UR2

https://support.microsoft.com/en-gb/help/4558753/update-rollup-2-for-system-center-service-manager-2...

 

Firstly there's a step to disable the DW job schedules and no corresponding step to re-enable them again so surely anyone following this will end up with no syncing DW anymore as none of the jobs will trigger after following the instructions, unless I'm missing something?

 

Secondly the instructions get you to delete all the cubes, change a couple of data types in the SSAS views and then reimport the cubes management packs afterwards. The problem is that that management pack bundle hasn't been updated by the patch (it tells you to reimport cubes.mpb from the service manager directory). So you change a couple of data types from int to decimal, reimport the existing cubes management pack bundle which then errors trying to recreate the cubes because source and target data types now differ - because you've just changed them.

 

I don't know if the patch was supposed to replace the mpb file with a newer version that expects decimal or something but it hasn't in our environment, I can't find an updated version anywhere inside the patch file and it isn't listed under files modified in the article.

 

Fortunately I was able to snapshot the whole environment before the attempt so rolled back and have now installed the update again, skipped the whole "After the installation" section and just did the provider update section instead. Everything seems fine and the cubes all processed successfully last night.

 

Has anyone else tried this yet and had similar issue?

 

Thanks

 

Steve

0 Replies