D365 Enable/Disable maintenance mode for DEV and UAT

-
There are two ways you can enable maintenance mode.


1. COMMAND:

To enable maintenance mode open command prompt as Admin and execute below command

J:\AosService\PackagesLocalDirectory\Bin\Microsoft.Dynamics.AX.Deployment.Setup.exe --metadatadir J:\AosService\PackagesLocalDirectory --bindir J:\AosService\PackagesLocalDirectory\Bin --sqlserver . --sqldatabase axdb --sqluser axdbadmin --sqlpwd ********* --setupmode maintenancemode --isinmaintenancemode true'

To disable maintenance mode open command prompt as Admin and execute below command

J:\AosService\PackagesLocalDirectory\Bin\Microsoft.Dynamics.AX.Deployment.Setup.exe --metadatadir J:\AosService\PackagesLocalDirectory --bindir J:\AosService\PackagesLocalDirectory\Bin --sqlserver . --sqldatabase axdb --sqluser axdbadmin --sqlpwd ********* --setupmode maintenancemode --isinmaintenancemode false

Make sure you give the correct path of AOS service directory.

2. SQL:

To enable maintenance mode write below query on sql server

update dbo.SQLSYSTEMVARIABLES
set dbo.SQLSYSTEMVARIABLES.VALUE = 1
where dbo.SQLSYSTEMVARIABLES.PARM = 'CONFIGURATIONMODE'

Then go to LCS select your environment go to Maintain tab and select Restart service. New dialog form will open from drop down select IIS and click on confirm button.

To disable maintenance mode change SQLSYSTEMVARIABLES.VALUE to 0 and restart IIS again.

Comments

Post a Comment

Popular posts from this blog

X++ Get Start Date and End Date of Month

-
Use following methods to get Month Start Date and Month End Date. Pass any date of month in parameter. Month Start Date :    TransDate dateInMonth=today(); TransDate firstDateOfMonth; ; firstDateOfMonth = DateStartMth(dateInMonth); Month End Date : TransDate dateInMonth=today(); TransDate endDateOfMonth; ; endDateOfMonth= endmth(dateInMonth);
Read more

Dynamics AX 365 : The name does not denote a class, a table or an extended data type

-
Image
I was getting following error during customization of Dynamics AX. After some debugging i found that it is due to model. Error can be resolved by updating model. In this blog i am working with smmActivities but it can applied for any table. Goto your table in AOT you will see model name in square brackets in light color grey. You have to add this model to resolve issue. In my case model name is "Case Management". In toolbar go to Dynamics 365 →Model Management → Update model parameters. Select your model in which you are doing your customization, in my case it is "testModel" and click on next, scroll down and select "Case Management" and select next and then click on finish. Build your solution error should be gone now.
Read more

Error while setting server report parameters. Error message: The permissions granted to user are insufficient for performing this operation. (rsAccessDenied)

-
Image
When ever you receive this error when you try to open any  report "Error while setting report server parameters.Error Message The permissions granted to user are insufficient for performing this operation".   This is the permission issue means user does not have sufficient permission to access report. To give permission to user follow these steps. 1. Hold the shift key and click the mouse right click on the Internet Explorer. then select run as administrator. If you do not get option to run IE as administrator then go to C:\Program Files\Internet Explorer right click on "iexplore.exe" and choose run as administrator. 2.  Go to "localhost\reports" 3. Click The small arrow beside the DynamicsAX Folder them select Security 4. Click "New Role Assignment" 5. Type the domain and user name in textbox and select the Browse option and click on Ok button.    Open Dynamics AX and run report again.
Read more