Enable/disable D365 maintenance mode- Tier 1 & Higher Versions - Microsoft Dynamics Finance and operations


Tier 1 : 

There are the following ways to enable/disable maintenance mode on DEV/could hosted boxes:

Posted by : Hariharasudan Kandaswamy

SQL

Query status:
1
2
use AXDB;
select * from dbo.SQLSYSTEMVARIABLES where PARM = 'CONFIGURATIONMODE';
Enable maintenance mode:
1
2
use AXDB;
update SQLSYSTEMVARIABLES SET VALUE = 1 where PARM = 'CONFIGURATIONMODE';
Restart IIS Express/IIS and do the required steps like enable/disable configuration keys.

if required, Execute DB sync

Disable maintenance mode:
1
2
use AXDB;
update SQLSYSTEMVARIABLES SET VALUE = 0 where PARM = 'CONFIGURATIONMODE';

CMD

Open command prompt as administrator.
Enable maintenance mode (replace **axdbadmin_from_lcs** value):
1
K:\AosService\PackagesLocalDirectory\Bin\Microsoft.Dynamics.AX.Deployment.Setup.exe --metadatadir J:\AosService\PackagesLocalDirectory --bindir J:\AosService\PackagesLocalDirectory\Bin --sqlserver . --sqldatabase axdb --sqluser axdbadmin --sqlpwd **axdbadmin_from_lcs** --setupmode maintenancemode --isinmaintenancemode true
Disable maintenance mode (replace **axdbadmin_from_lcs** value):
1
K:\AosService\PackagesLocalDirectory\Bin\Microsoft.Dynamics.AX.Deployment.Setup.exe --metadatadir J:\AosService\PackagesLocalDirectory --bindir J:\AosService\PackagesLocalDirectory\Bin --sqlserver . --sqldatabase axdb --sqluser axdbadmin --sqlpwd **axdbadmin_from_lcs** --setupmode maintenancemode --isinmaintenancemode false

D365FO.Tools

Open PowerShell as Administrator
Installation of d365fo tools:
1
Install-Module -Name d365fo.tools
Query status:
1
Get-D365MaintenanceMode
Enable maintenance mode:
1
Enable-D365MaintenanceMode
Disable maintenance mode:
1
Disable-D365MaintenanceMode

References Link :

List of all d365fo tools commands:

References Author : Max

Posted by : Hariharasudan Kandaswamy

Tier 2  

Tier 2: Enable/disable D365 maintenance mode can be done from LCS:


Comments

Post a Comment

Popular posts from this blog

Advanced & Auto Bank Reconciliation in Dynamics 365 Finance

Image
  Introduction In any accounting software, it is always important to keep track of all real-time bank transactions and record them in the ERP. Since bank transactions are booked manually in the ERP, it is necessary to ensure that the bank statements and ERP records are matched on any given date. This is where bank reconciliation comes into play. Posted by : Hariharasudan Kandaswamy Reference : Cloud Fronts Bank Reconciliation Bank reconciliation is an activity done by any finance user for the purpose of reconciling book transactions w.r.t bank statements and ensuring that both are as closely matched as possible. D365 Finance offers two ways of performing bank reconciliations. One is by entering the bank statement amount manually and reconciling the ERP statements for each record against the amount. The other is by importing the bank statement into the system and letting the system match the records of the statement against the ERP based on a certain criteria. The blog is made with the
Read more

Disable editing of specific financial dimensions on form -Microsoft Dynamics Finance and operations(D365FO)

Posted by : Hariharasudan kandaswamy [FormEventHandler(formStr(Custtable), FormEventType:Initialized)] public static void Custtable_OnInitialized(xFormRun _sender, FormEventArgs _e) {     DimensionEntryControl dimControl = _sender.design().controlName(identifierStr(DimensionEntryControlTable));     DimensionEnumeration dimensionSetId = DimensionCache:getDimensionAttributeSetForLedger();     DimensionAttributeSetStorage dimensionAttributeSetStorage;     DimensionAttribute dimensionAttribute;     DimensionAttributeSetItem dimAttrSetItem;     const str Department= 'Department';     const str Brand= 'Brand';     dimensionAttributeSetStorage = new DimensionAttributeSetStorage();     while select dimensionAttribute         where dimensionAttribute.Name != Department // Exclude specific dimension which should be not editable             && dimensionAttribute.Name != Brand// Exclude specific dimension which should be not editable         join dimAttrSetItem            
Read more