Field Fixed Relation and Related Field Fixed Relation In Microsoft Dynamics AX

Field Fixed Relation and Related Field Fixed Relations are not commonly used in AX but its Good to understand there concept as in some scenarios they are very useful.

Below are the two links that explains both Field Fixed Relation and Related Field Fixed Relation in Microsoft Dynamics AX.

https://amazingax.wordpress.com/2013/04/15/microsoft-dynamics-ax-2012-understanding-related-field-and-fixed-field-relation-on-ax-tables/

https://msdn.microsoft.com/en-us/library/bb190115.aspx?ranMID=24542&ranEAID=TnL5HPStwNw&ranSiteID=TnL5HPStwNw-CzrYWf0.SeiooLURSsjHrQ&tduid=(7765185542a4606ade00d00d5716e203)(256380)(2459594)(TnL5HPStwNw-CzrYWf0.SeiooLURSsjHrQ)()


Let me know if you have any questions related to this.

Thanks,
Muhammad Zahid.

Ending Blocked User Session in Microsoft Dynamics AX 2009

Some times there are session in AX that are in ending blocked mode and causing the AX perfomance impact.

What you can do just right the below query to check if there is blocked session in AX or not.

'select * from SysClientSessions where SysClientSessions.STATUS = 3'

if you got any record than it means that there is blocked session in AX.

Before deleting it first verify the 'same session id' in AX -> administration -> online users.

filter the record with that session id and u will see the record with status 'ending blocked'

Now go to sql and delete the record that you find in above query or call the Sql Stored Procedure [KillDBSession] with correct session id.

Once you kill the session the user will be successfully able to login again in AX.

For more details on this please refer to the following blog:

https://axatoz.wordpress.com/2014/04/10/how-to-kill-a-blocking-session/

Thanks,

Muhammad Zahid.