Maintenance Mode Exception

Batch Service Exception (Maintenance Mode) D365FO

Recently, My office colleague faced an issue while starting  Microsoft D365 windows batch services in Update 15. after 10 seconds of processing it's getting failed 

When we check in Event Viewer with below Path

Application and services Logs > Microsoft > Dynamics > AX-BatchService > Operations

Batch service throwing below Error 

After spending some hours on the internet root cause was found. this issue occurs When D365FO is On Maintenance Mode.

There are two ways to fix this issue...

The proper way; Use the Microsoft.Dynamics.AX.Deployment.Setup.exe command; 

Run this from the command line:

C:\AOSService\PackagesLocalDirectory\Bin\Microsoft.Dynamics.AX.Deployment.Setup.exe –metadatadir C:\AOSService\PackagesLocalDirectory –bindir C:\AOSService\PackagesLocalDirectory –sqlserver . –sqldatabase axdb –sqluser AOSUser –sqlpwd AOSWebSite@123 –setupmode maintenancemode –isinmaintenancemode false 

The Hack way; Use the Microsoft SQL Server Management Studio, and edit the following record in the table dbo.SQLSystemvariables ; CONFIGURATIONMODE

Update SQLSystemvariables set Value=0 where parm='CONFIGURATIONMODE'