I want to start a list of all issues one may encounter when upgrading to v9 on premise and how to resolve them.1.) Could not load SQL Management Objects dll- Install SMO and SQLSysClrTypes
https://www.microsoft.com/en-us/download/details.aspx?id=290652.) Issues with Marketing Sales Patch
- Comment out <configsolutionfile solutionpackagefilename="msdynce_MarketingSalesPatch_managed.cab" publishworkflowsandactivateplugins="true" /> in Program Files\Dynamics 365\Setup\Serviceability\Latest\Actions_Org\Install\Packages\CRMApps\PkgCache_9_0_0002_3034\msdynce_MarketingSales\msdynce_MarketingSales\importConfig.xml
3.) Issues with full text- Turn off full text and use Drop fulltext index sql commandhttps://crmtipoftheday.com/766/tip-766-drop-your-full-text-index-the-supported-way/4.) Issues with dropping clustered index constraints- I am still working on this issue. Anybody solved this issue?