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

Create a Tile in a D365FO Workspace with X++ - Microsoft Dynamics Finance and operations

Image
  Tiles : There are two ways through which we can create tile one by personalizing form and another through code. In this example   we’ll use code The diagram below  summarizes the operations we will perform to add a tile to a workspace Posted by : Hariharasudan Kandaswamy These are the steps we’ll do : Create an AOT Query object Create a simple list form to show the query results Create a menu item to call the form Create a tile to call the menu item Add the tile to a workspace Create an AOT Query object Create a project and add a query called “ DeliveredSalesOrdersQuery ” Add SalesTable as datasource in “ DeliveredSalesOrdersQuery ”. Set dynamic fields property to “Yes” Add range in it for showing sales orders whose status is delivered. Save the Query Create a simple list form to show the query results Add a  Form  object and call it “ DeliveredSalesOrderInquiry “ Add  DeliveredSalesOrdersQuery  as Form Data Source Apply  “Simple list”   pa...
Read more

X++ Code to fetch GST, SGST, IGST Sales amounts in D365FO -Indian GST calculation logic

 X++ Code : Syntax : this.calcGST("GSTTYPE" , InvoiceId) GST  Type : SGST,CSGT,IGST Assigning logic : this.calcGST(" SGST ",_ewaybillsales.invoiceid); Core Code Logic : public container calcGST(str _Type ,Invoiceid _invoiceid)         {             TmpTaxDocument tmpTax;             SalesCalcTax PurchCalcTax;             SalesTotals salesTotals;             ITaxableDocument taxableDocument;             ITaxDocumentComponentLineEnumerator lineEnumerator;             ITaxDocument taxDocumentObject;             ITaxDocumentMeasure taxMeasure;             ITaxDocumentMeasureEnumerator taxMeasureEnumerator;             ITaxDocumentMeasureValue partyTaxMeasureValue;       ...
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             && dimensio...
Read more