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

Color code the cell in Excel export

Hi Folks, 

Below is a sample code to color code your Excel cell while exporting. In this code, we will be using two assemblies as below

using OfficeOpenXml;

using OfficeOpenXml.Style; 

and standard Excel export code with a bit of creativity, 

You can be more creative by writing separate methods for major colors and calling them based on cell values. 

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

[Solved]Error while importing/Exporting opening balances DIXF (No active format for data entities has been set up)

Hi Folks, 

We were trying to import some opening balances and encountered some issues which say error as below,  

Error 1:

Results. The account type Ledger is not valid

Results. Validations failed

Error 2:

Results. No active format for data entities has been set up.

Set up an active format for each dimension format type.

Results. Error found when validating record.

Data written to target 'General journal' ('0' records created, '0' records updated)

Solution:

To fix this issue, Navigate to the below form

"General ledger > Chart of accounts > Dimensions > Financial dimension configuration for integrating applications"

Now here you need to set up two records as below, please make a note of the 'Dimension format type' and select the required dimension from available dimension types. 

Save your changes and retry to import/export your file, it should work this time. 

If you want to learn more about this specific form, I would recommend reading below Microsoft document.

Financial dimension configuration for Data Entities

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