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