Troubleshooting : Globalupdate script for service model: RetailServer on machine error

when you upgrade Dev machine you would run into error that says “Globalupdate script for service model: RetailServer on machine”. First step to resolve this issue is to download the log file and look at the error log from LCS.

1. If the error log file look something like below, you can try resuming upgrade after dropping the objects mentioned in the error log.
   
2. If the upgrade fails again with different object name, then you can you can drop all retail objects if retail functionalities are not required. To do so follow below steps
   • Login to the dev machine
   • Navigate to deployable packages folder under service volume drive (<ServiceVolumn>\Deployablepackages). You will see multiple folders with random GUID numbers as name. open the most recent one.
   • Copy the script from below path RetailServer\Scripts\DropAllRetailChannelDbObjects.SQL
   • Your folder path should look like this
     “<Servicevolume>\DeployablePackages\<GUID>\RetailServer\Scripts\”
   • Execute this script in SQL against the AxDB. This will take few minutes to complete
   • Resume the package deployment again from LCS 
3. There should be no problems after step 2 of the upgrade process; if the upgrade still fails after removing all retail objects, then object failed to update properly during recreation. To fix this, empty the updateretailchannelDatabase.ps1 file in the same path as 2.d. and resume the upgrade again.