QuickFix: Stop script for service model: AOSService on machine:

If you are getting errors while upgrading your tier-1 environment, trust me you are not alone, many of us facing this error say, 

Error 1: 

Stop script for service model: AOSService on machine

If you remember this is the same issue we had with the earlier version, and to fix this you have to update the VC++ runtime. You can download this from the below link and run it on our tier-1 environment (s).

New VC++ runtime requirement for cloud-hosted environments and VHD images running version 10.0.36 or later

Error 2:

GlobalUpdate script for service model: RetailServer on machine:(VM Name)

Let's understand why, (Or let's see what the fix is :) )

Whenever you Apply any update from LCS, it will create a package on VM local disk normally at the below location 

ServiceVolume\DeployablePackages  and you have to select the most recent folder (in case you already tried a few times with this error).

Navigate to RetailServer\Scripts and find the file name 'DropAllRetialChannelDbObjects'. 

Here is the entire path in case you need it (ServiceVolume\DeployablePackages\RetailServer\Scripts\DropAllRetialChannelDbObjects), run this SQL query on AXDB on VM and try again to apply the update. 

Tip: This SQL script sometimes takes hours and hours to finish, you can try to stop this execution and select one query at a time from the script. 

-Harry Follow us on Facebook to keep in rhythm with us. https:fb.com/theaxapta

ENum values in BYOD

While exporting data in BYOD ENUMS are exporting with values (numerical) than its string values. 

All ENUMS are sitting in this table with their values and IDs, 

SRSANALYSISENUMS 

Sometimes this table doesn't update automatically you can write a small job to populate all EUMs in this table, below is the code

 public static void generateEnum(Args _args)

    {

        BIHelper::populateSRSAnalysisEnums();

    }

-Harry Follow us on Facebook to keep in rhythm with us. https:fb.com/theaxapta