RE: [Axapta-Knowledge-Village] Axapta gets hanged !!!

2010-01-21 Thread James Flavell
There can be many issues so you need to provide as much detail as possible (server and SQL DB specs plus idea of the CPU/disk load when things hang. Also AX kernel and application versions). It might be a certain operation a user does starts a large SQL and that then slows everybody else down.

Re: [Axapta-Knowledge-Village] Axapta gets hanged !!!

2010-01-21 Thread Anitha S
Hi James, Here are the details. *Kernel Version* : 5.0.1000.52 *Application Version* : 5.0.1001.96 We are using *SQL server 2005 SP2*. AOS and SQL server are in *different* machines. Even when any of the AOT object iscompiled, the application goes to Not Responding Status. And I guess,it is

RE: [Axapta-Knowledge-Village] Axapta gets hanged !!!

2010-01-21 Thread James Flavell
Sorry just to clarify You mean when you compile a single AOT object then every goes slow (even if say there are only 2 users on the system)? Are there other situations where the it goes slow not related to doing anything in the AOT? The hotfix I vaguely remember seeing was slowness caused

Re: [Axapta-Knowledge-Village] Axapta gets hanged !!!

2010-01-21 Thread M Anass
Hi Anitha, I think you are working in  Windows Server 2003 or XP, and your SQL or OS is x64, if it is the case, so I can guess this is because of  SQL Server dynamic memory management and how it manage the page out and buffer. I think you will find the answer in the following link,

Re: [Axapta-Knowledge-Village] Axapta gets hanged !!!

2010-01-21 Thread Anitha S
James, We are using 2 Instances. One is Test and Production. Amount of Data in test Instance is same like in Prod.(might be around * less15*% of data than prod). Test instance is used by limited number of users. But after we started using Production instance , we see the Test instance has also

RE: [Axapta-Knowledge-Village] Axapta gets hanged !!!

2010-01-21 Thread James Flavell
Still not clear the issue happens only when you are doing things in the AOT or also when nothing at all is done in the AOT (regardless of the instance)? Example: 2 users login and begin to do their daily work of oopen customer forma nd sales order etc. Does the system slow down? Is

Re: [Axapta-Knowledge-Village] Axapta gets hanged !!!

2010-01-21 Thread Anitha S
Yes James.. System gets hanged when the user access the forms also : like posting an invoice, payment etc., I could see only this message in event log : Terminating the session . When the system goes to Not Responding mode, we forcibly close the application. Regards, Anitha On Thu, Jan 21,

[Axapta-Knowledge-Village] Re: Axapta gets hanged !!!

2010-01-21 Thread Navid
Hi Anitha, We also had a similar issue when we migrated to Dynamics AX 2009. Our problem was caused by Dynamics logging every item(Form/Report/Table) that is being used by any user. The table SysUtilElementsLog was having locks So we made the table SysUtilElementsLog as temporary and this

RE: [Axapta-Knowledge-Village] Re: Axapta gets hanged !!!

2010-01-21 Thread James Flavell
I think this SysUtilElementsLog was related to the hotfix I saw and the fix about switching to temp table was mentioned (disclaimer: this is all from my memory banks which are getting older and more prone to errors!) I would give what Navid says a try since it is easy to make the change

[Axapta-Knowledge-Village] Autostart form when starting Axapta

2010-01-21 Thread surfing2alien
Hi, I want to start a form automatically when Axapta starts, for some computers. the login is already automatic, now I need to open a specific form automatic. Can somebody tell me how?

Re: [Axapta-Knowledge-Village] Autostart form when starting Axapta

2010-01-21 Thread mni_col
Hi, perhaps http://gurudynamicsax.spaces.live.com/Blog/cns!F6C101CEB694FB4E!190.entry can help you. best regards Michael From: surfing2alien Sent: Thursday, January 21, 2010 3:42 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Autostart form when

RE: [Axapta-Knowledge-Village] Re: Axapta gets hanged !!!

2010-01-21 Thread James Flavell
Just to update that what Navid talked about is KB 959598 and this is the one I was also referring to. Are you a partner? If so go get the article: https://mbs.microsoft.com/knowledgebase/kbdisplay.aspx?wtntzsmnwukntmmyxupyz qpouxnxspsymmtyvwnzmxqlwyxs If you are a customer go ask your

[Axapta-Knowledge-Village] UNION QUERY PROBLEM

2010-01-21 Thread Irshad
Alcon i am facing following errors while synchronizing the database in dynamics ax 2009. i tried my best to find its solution in google but could not. i am not sql server expert. if you probide me guide lines i hope i shall be able to solve it. errors are below 1. There is a field mismatching in