Wednesday, December 26, 2018

ADFS configuration error Invalid scope names

I am about to finish On-Prem deployment, where i was facing error at step number 18  as below:
"ADFS configuration for premises deployment Invalid scope names"

Grant-AdfsApplicationPermission : MSIS7628: Scope names should be a valid Scope Description name in AD FS configuration.
At C:\smcondc\adfschkns\fi\D365FO-OP\D365FO-OP-ADFSApplicationGroup.psm1:204 char:5

Link below helped me to solve this issue.

https://community.dynamics.com/ax/f/33/t/262091

Tuesday, December 25, 2018

Add Financial default dimension on form AX 2012

Followings are some useful links to understand Financial default dimension on Form AX 2012.

1) https://www.intergen.co.nz/blog/Tim-Schofield/dates/2011/12/how-to-add-a-financial-dimension-in-ax-2012/
2) https://community.dynamics.com/ax/b/mukeshhirwani_dynamicsax/archive/2012/09/07/how-add-financial-dimension-on-forms-inside-ax2012
3) https://dynamicscognizance.wordpress.com/2017/02/02/adding-financial-dimensions-of-form-ax-2012/
4) http://www.axdeveloperconnection.it/webapp/blog/financial-dimension-control-no-data-source

Tuesday, November 27, 2018

Enable single user multiple sessions windows server.

Follow steps below to enable single user multiple sessions in Windows server 2012 & 2016
1.Open registry editor using regedit from Run.
2. Navigate to path below.
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\TerminalServer.
3. Select Terminal Server registry.
4. Update value of fSingleSessionPerUser from 1 to 0, which will allow to login multiple session for single user.

1. Log into the server using Remote Desktop.
2. Open the start screen (press the Windows key) and type gpedit.msc and open it
3. Go to Computer Configuration > Administrative Templates > Windows Components > Remote Desktop Services > Remote Desktop Session Host > Connections.
4. Set Restrict Remote Desktop Services user to a single Remote Desktop Services session to Disabled.
5. Double click Limit number of connections and set the RD Maximum Connections allowed to 999999.


Tuesday, October 16, 2018

Transaction log backup

In this post, i want to populate good to know information about log backup in SQL Server.

Query to know the history of transaction log backup.

SELECT      bs.backup_start_date, bs.backup_finish_date, *
FROM        msdb..backupfile bf
JOIN        msdb..backupset bs ON bf.backup_set_id = bs.backup_set_id
WHERE       bf.File_Type = 'L'

OR using

select database_name, max(backup_finish_date)
from msdb..backupset
where type = 'L'
group by database_name

Detailed reference for above query : Link

How often we should take transaction log backup: Link

 Recover data from transaction log backup: Link

Import Export model Dynamics 365 for operations

Following model management commands i have tried on Demo VM downloaded from LCS, which i found working as per the expectations.

Export model in Dynamics 365 operations.
C:\AOSService\PackagesLocalDirectory\Bin>ModelUtil.exe -export -metadatastorepath=C:\AOSService\PackagesLocalDirectory -modelname="FleetManagement" -outputpath=c:\temp

Import model in Dynamics 365 operations.
C:\AOSService\PackagesLocalDirectory\Bin>ModelUtil.exe -import -metadatastorepath=C:\AOSService\PackagesLocalDirectory -file=C:\Test\XYZDevelopments.axmodel

Delete model in dynamics 365 operations.
C:\AOSService\PackagesLocalDirectory\Bin>ModelUtil.exe -delete -metadatastorepath=C:\AOSService\PackagesLocalDirectory -modelname="FleetManagement"

Wednesday, October 10, 2018

Object Server XX: Fatal SQL condition during login.


Message in event viewer on AOS server:

Object Server XX:  Fatal SQL condition during login. Error message: "The internal time zone version number stored in the database is higher than the version supported by the kernel (11/10). Use a newer Microsoft Dynamics AX kernel."


select * from SQLSystemVariables
WHERE PARM = 'SYSTIMEZONESVERSION'

Execute query above and check value in field "VALUE", it should look like image below. Please note that message in event viewer is helpful to update this value.



Event viewer message shows kernel (11/10) means current value is 11 and supported is 10, so here we need to update value to 10 using query below. - in your environment it can be 8/7 instead of 11/10 or it can be anything. I don't come across any MS documentation for the same. Please share your experience for the same error, does it works for you or have you solved by any other way.

update SQLSystemVariables set VALUE = 10
WHERE PARM = 'SYSTIMEZONESVERSION'

Happening

Upgrade from AX 2012 to Latest Dynamics 365 Finance and Operation

Below are the steps defined by sequence. 1. Create new Upgrade project in Dynamics LCS. 2. Create VSTS Project and connect it with L...

Trending now