Financial dimension activation - Finance & Operations!
The activation of dimensions is only allowed when the system is in maintenance mode. Maintenance mode can be enabled in this environment by running maintenance job from LCS, or using Deployment. Setup tool locally.
Issues were reported by my friend,
The activation of dimensions is only allowed when the system is in maintenance mode. Maintenance mode can be enabled in this environment by running maintenance job from LCS, or using Deployment. Setup tool locally.
Solution:
1.Log into LCS,
2. Access to the Server via adding the IP, Download the RDP
3. Now RDP onto the Microsoft-hosted dev/build machine
4. Open SQL Server Management Studio and connect to the database server using the credentials from LCS for the axdbadmin user (See the password in LCS)
5. Right click on the AxDB database and create a new query as follows:
update SQLSYSTEMVARIABLES SET VALUE = 1 where PARM = 'CONFIGURATIONMODE'
6. Restart the “World Wide Web Publishing Service” from the Windows Services app.
This restarts IIS.
7. After IIS is restarted, D365-FO will be in maintenance mode
8. Go to your financial dimensions screen and activate your dimensions.
9. When you are satisfied that your financial dimensions are good and active (confirm this by checking if you can add a financial dimension to an account structure in the "Configure account structures" form
10. Get D365-FO out of maintenance mode by executing the following query:
update SQLSYSTEMVARIABLES SET VALUE = 0 where PARM = 'CONFIGURATIONMODE'
11. Restart the “World Wide Web Publishing Service” from the Windows Services app. This restarts IIS.
12. Browse to D365-FO and verify that you are no longer in maintenance mode by trying to activate a financial dimension which should once again show you the warning message shown in the screenshot at the beginning of this screenshot.
Note:
Step 12 is very important as if the D365-FO system remains in maintenance mode only users who have the "Maintenance mode user" role can sign in to D365-FO.
The activation of dimensions is only allowed when the system is in maintenance mode. Maintenance mode can be enabled in this environment by running maintenance job from LCS, or using Deployment. Setup tool locally.
Issues were reported by my friend,
The activation of dimensions is only allowed when the system is in maintenance mode. Maintenance mode can be enabled in this environment by running maintenance job from LCS, or using Deployment. Setup tool locally.
Solution:
1.Log into LCS,
2. Access to the Server via adding the IP, Download the RDP
3. Now RDP onto the Microsoft-hosted dev/build machine
4. Open SQL Server Management Studio and connect to the database server using the credentials from LCS for the axdbadmin user (See the password in LCS)
5. Right click on the AxDB database and create a new query as follows:
update SQLSYSTEMVARIABLES SET VALUE = 1 where PARM = 'CONFIGURATIONMODE'
6. Restart the “World Wide Web Publishing Service” from the Windows Services app.
This restarts IIS.
7. After IIS is restarted, D365-FO will be in maintenance mode
8. Go to your financial dimensions screen and activate your dimensions.
9. When you are satisfied that your financial dimensions are good and active (confirm this by checking if you can add a financial dimension to an account structure in the "Configure account structures" form
10. Get D365-FO out of maintenance mode by executing the following query:
update SQLSYSTEMVARIABLES SET VALUE = 0 where PARM = 'CONFIGURATIONMODE'
11. Restart the “World Wide Web Publishing Service” from the Windows Services app. This restarts IIS.
12. Browse to D365-FO and verify that you are no longer in maintenance mode by trying to activate a financial dimension which should once again show you the warning message shown in the screenshot at the beginning of this screenshot.
Note:
Step 12 is very important as if the D365-FO system remains in maintenance mode only users who have the "Maintenance mode user" role can sign in to D365-FO.
Error you might face:
An error occurred at (UTC) 5/03/2019 9:55:05 PM
Solution:
Open Azure SQL,
update SQLSYSTEMVARIABLES SET VALUE = 0 where PARM = 'CONFIGURATIONMODE'
Happy Financial dimension activation!
Happy Financial dimension activation!
Thanks & Regards,
Mail ID: pandit.umesh@hotmail.com
Skype ID: pandit.umesh
