300th Post and still a long way to go...

This is my 300th post today, Yet, there's still a long way to go and lot of articles, troubleshooting tips, technical know hows etc to come, I'm really running short of time because of a busy work schedule but still will try and keep up the posts whenever I get a breather!

Thanks a lot to you all guys out there who are avid readers of my blog and who gets benefitted in their day to day work life with my blog articles, Any suggestions/comments are always welcome..Just drop me a mail on mail.dilipn@gmail.com

...Happy Dax'ing.. :-)

Object Server 01: Internal Error occured executing stored procedure when creating session for the AOS

We were getting this error when trying to start the AOS Service after we restored an AX Database from one of our existing environments:

Error : Object Server 01: Internal Error occured executing stored procedure when creating session for the AOS

By seeing this error, I was quickly able to conclude that it has to do something related to the stored procedures which creates server sessions and client sessions, I compared the permissions of the sp's with our other AX databases and found that the aos service account didn't have "Execute" permissions on these 2 sp's and hence the errors, After assigning the permissions, we could start the service without any hiccups

I had a similar experience troubleshooting these stored procedures in the past which has been blogged http://daxdilip.blogspot.com/2009/02/sysserversessions-and-sysclientsessions.html

 

How to install AX Debugger without actually running the setup :-)

For troubleshooting one of our interface, I had to run the AX Debugger from AOS Server. And, on our DEV AOS Server, I didn't have the AX install/setup files.

So, I just tried to give this quick workaround a shot hoping that it works and it actually worked!

Copy the "AxDebug.exe" from my local box "C:\Program Files\Microsoft Dynamics AX\50\Client\Bin"
and just paste it in the path on the AOS box where client is installed and this did the trick!

No need to go through the boring installation, Quick and easy :-)

Back to blogging from a short break...

...Been on a vacation for 3 weeks. I have some interesting posts coming up, so watch out for this space..

Happy Dax'ing...