QuickFix: "Value cannot be null. Parameter name: proxy" in DIXF

Problem: After creating a new data entity and refreshing the entity list, the new entity doesn’t appear in DIXF data entity list. Interestingly, no errors are encountered when compiling the project. However, the following error message was received when trying to add the data entity in list manually. 

Value cannot be null. Parameter name: proxy

Possible Reason: While building your project or solution exclusively, your code may not exhibit any issues. However, inspect the output window messages in Visual Studio to identify any error messages originating from objects not included in your code.

Proposed Solution: Attempt to build the entire model and rectify any errors. Upon successful build, perform a database synchronization and try again. You should then be able to view new entities after refreshing or manually add them to the list.

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

Issue while installing ExFlow ISV

Error:

Request for the permission of type 'System.Security.Permissions.FileIOPermission, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

   at System.Security.CodeAccessSecurityEngine.Check(Object demand, StackCrawlMark& stackMark, Boolean isPermSet)

   at System.Security.CodeAccessPermission.Demand()

   at System.Security.Permissions.FileIOPermission.QuickDemand(FileIOPermissionAccess access, AccessControlActions control, String[] fullPathList, Boolean checkForDuplicates, Boolean needFullPath)

   at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)

   at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize)

   at System.Xml.XmlDownloadManager.GetStream(Uri uri, ICredentials credentials, IWebProxy proxy, RequestCachePolicy cachePolicy)

   at System.Xml.XmlUrlResolver.GetEntity(Uri absoluteUri, String role, Type ofObjectToReturn)

   at System.Xml.XmlSecureResolver.GetEntity(Uri absoluteUri, String role, Type ofObjectToReturn)

   at System.Xml.XmlTextReaderImpl.FinishInitUriString()

   at System.Xml.XmlReaderSettings.CreateReader(String inputUri, XmlParserContext inputContext)

   at Microsoft.Dynamics.AX.AXUpdateInstallerBase.ServiceModelData.InitFromFile(String filePath)

   at Microsoft.Dynamics.AX.AXUpdateInstallerBase.AXUpdateInstallerBase.CreateQuickInstallRunbookGeneratorParameter(String updatePackageFilePath, String serviceModelFile)

   at Microsoft.Dynamics.AX.AXUpdateInstallerBase.AXUpdateInstallerBase.Install(String updatePackageFilePath, Boolean versionCheck, String serviceModelFile, Boolean parallel, Boolean devInstall, Parameters parameters)

   at Microsoft.Dynamics.AX.AXUpdateInstaller.Program.InstallUpdate(String[] args)

   at Microsoft.Dynamics.AX.AXUpdateInstaller.Program.Main(String[] args)

Solution:

It’s crucial to ensure that the Package zip file is unblocked before extracting it. If it’s blocked, the AXUpdateInstaller won’t be able to access the files even after they are extracted.

To verify this, one can right-click on any file in the extracted package folder, go to Properties, and look for the Unblock checkbox. If it’s unchecked, it means the file is still blocked.

This is a valuable tip for anyone working with zip files and encountering issues with the AXUpdateInstaller.

Just before extracting the zip file, right-click on it > Properties and tick Unblock. and try again. 

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

Database log full causing Application Access issue

Hi Folks, 

Lately last day I put a 3rd party solution on my DEV box, and the build and synch were successful. But the next morning the application was not working and it was saying (with a 'Hmmm....' sound).

Interestingly, I was able to access VM and Visual stuido was working normally. All services were running fine including IIS. Tried with certificate rotation via LCS, but nothing on the Azure portal. 

(I have still didn't realized to check on event logs :) ) It was a very strange error, after spending a few min here and there, let's check on the events and it says something like the below

{"Class":17,"Number":9002,"State":2,"Message":"The transaction log for database 'AxDB' is full due to 'LOG_BACKUP'.","ErrorCode":-2146232060,"Procedure":"","LineNumber":9,"Errors":[{"Class":17,"Number":9002,"State":2,"Message":"The transaction log for database 'AxDB' is full due to 'LOG_BACKUP'.","Procedure":"","LineNumber":9,"Source":".Net SqlClient Data Provider"}],"ConnectionId":"<345234534523453>","Source":".Net SqlClient Data Provider"}

Machine: VM001-1

The Solution:

Check the MSSQL Logs drive and this must be full and running out of space. To fix this, 

1. Open SQL management Studio on VM and connect with the local server. 

2. Right-click on AXDB and select properties. Navigate to Options and set 'Recovery model' to simple.

3.  Now, right-click on ACDB, select Task > Shrik > File, and set the below values

4. Click ok and restart the WWW service, the issue should be resolved. 

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

QuickFix: D365FO Dev Box prompting for User name and Password

Hi Folks, 

After doing get latest or build you may get the issue of accessing the environment where its keeps asking for a username and password, 

Solution:

Login into VM and check the below services if they are up and running, 

1. World Wide Web Publishing service

2. Microsoft Dynamics 365 Unified Operations: Batch Management Service

3. Microsoft Dynamics 365 Unified Operations: Data export import framework Service

Once all these services are up and running without any issues try again. 

Thanks

Harry 

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

QuickFix: Build pipeline failing at 'Prepare for Build' step

[This is my own experience which worked for me. Pay attention to other troubleshooting as well like checking for any error on other steps, checking event viewer etc]

Issue: Build pipeline failing at step of 'Prepare for build' or it's taking a very long time, it's stuck at the below step,

/LOG:"C:\DynamicsSDK\VSOAgent\_work\1\s\Backup-AX7Packages_RoboCopy.log"

Solution: If you read the previous steps carefully it may give you some more details something like the below, 

If you RDP to your build machine and check for the folder delete this from the Build machine and try to run the pipeline, if should create this from scratch. 

/LOG:"C:\DynamicsSDK\VSOAgent\_work\1\s\Backup-AX7Packages_RoboCopy.log"

/LOG:"C:\DynamicsSDK\VSOAgent\_work\1\s\Backup-AX7Packages_RoboCopy.log"

/LOG:"C:\DynamicsSDK\VSOAgent\_work\1\s\Backup-AX7Packages_RoboCopy.log"/LOG:"C:\DynamicsSDK\VSOAgent\_work\1\s\Backup-AX7Packages_RoboCopy.log"

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

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