How to enable maintenance mode

Hi Folks,

Now when most of the project management stuff needs to handle via LCS for D365FO project implementation. In each cloud-hosted environment, we use to have the option to enable maintenance mode for an environment. But for DevTest/Demo environments we don’t have that option on LCS. So, here are some steps to enable maintenance mode,

1. Open SQL server management studio (SSMS) in the dev box.

2. Go to AXDB and use the below queries as per your requirement,

a. To check current state

select Value from sqlsystemvariables a where a.PARM = 'configurationmode'

b. To enable maintenance mode

update sqlsystemvariables set VALUE = 1 where PARM = 'configurationmode'

c.  Now you need to restart word wide web service. Sometimes it doesn't work and you need to just restart this service for more than once.

d. Once you done with your activities run below query to disable maintenance mode

update sqlsystemvariables set VALUE = 0 where PARM = 'configurationmode'

3. Whenever you made a change to it.

Cheers!!!

Harry

Follow us on Facebook to keep in rhythm with us. https:fb.com/theaxapta

This post is referenced from MS Docs.

Book review Implementing Microsoft Dynamics 365 for Finance and Operations Apps

Hello Everyone,

Since many months I have been reviewing this much awaited book, titled "Implementing Microsoft Dynamics 365 for Finance and Operations Apps: Learn best practices, architecture, tools, techniques, and more, 2nd Edition". I review each chapter of this book and found very useful for every consultant. 

I would say it’s a one spot destination for overall D365 FnO solution including the neighbor technology, which are pretty much used in every implementation. It covers in depth details on every area you can think of while behind the wheel including but not limited to D365 Architecture, Methodology, LCS, Logic apps, Integrations, common issues, comparison between different available tools, best use of each tool and many more.

You will get more insight on below points

—   Understand the architecture of Dynamics 365 for Finance and Operations Apps

—   Implement Dynamics with confidence to manage finances in your business

—   Get up to speed with different methodologies and support cycles of the Microsoft Dynamics architecture

—   Explore best practices to analyze the requirements of your business

—   Understand the technique of data migration from legacy systems

—   Leverage the capabilities of Power BI to make informed business decisions

—   Manage all your upgrades through One Version service updates

I really appreciated the hard work of all authors who put their best of best and delivered this amazing book for us. Authors of this book are JJ Yadav , Sandeep Shukla , Rahul Mohta, Yogesh Kasat.

Here is the link to this book at

Amazon

https://www.amazon.com/Implementing-Microsoft-Dynamics-Finance-Operations-ebook/dp/B0855XHDS1/ref=sr_1_1?keywords=Implementing+Microsoft+Dynamics+365+for+Finance+and+Operations+Apps+-+Second+Edition&qid=1583985567&s=digital-text&sr=1-1

PacktPub:

https://www.packtpub.com/business-other/implementing-microsoft-dynamics-365-for-finance-and-operations-apps-second-edition

-Harry Follow us on Facebook to keep in rhythm with us. https:fb.com/theaxapta