March 18, 2024

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

February 24, 2024

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