Hi On other things: I would pay more attention to the error message about exhausted memory. Please check out CPU and Mem utilization on AOS as well as SQL server
Regards Harry ________________________________ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Ax Dev Sent: 18 December 2006 12:18 To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Problem with the explosion feature at the sales line!!!! Hi Harry, I also have some problem related to Master Planning where InventSumLogTTS table is the main culprit. We had a client with huge database, and they tried to run Master Planning using Principle as Regeneration. It took more than 8 hours for execution and at last it gives the error like Deletion of records from InventSumLogTTS table exhausted the memory. We analyzed the code and found that during Regeneration, we don't need the records in InventSumLogTTS table(as these are required for Incremental Run). So we created a truncate job to delete the records from InventSumLogTTS table before Regeneration Run. And now it took around 1 hour and it executed successfully. Now the problem is; if we are doing Incremental Run, it took more than 3 hours, which is not exceptable from client's point of view, if Regeneration is taking 1 hour, then Incremental Run should take less than that. But Incremental Run is using records from InventSumLogTTS table, we can't delete/truncate this table. Do you have any suggestions how to improve the Incremental Run process, it would be really helpful.? Thanks & Regards, Harsh On 12/18/06, Harry Deshpande <[EMAIL PROTECTED]<mailto:harryd%40microsoft.com>> wrote: > > Hi > > It looks like the problem is with InventSumLogTTS and not with master > planning. > > Check the records in inventsumlogtts after each step (the steps are > slightly different) > > i.e > > 1. create sales order > 2. create purchase order > 3. receive item > 4. post sales > > Ideally you should have records created in InventSumLogTTS after each > step. Please also try this on standard installation. > > regards > > harry > > ________________________________ > From: > Axapta-Knowledge-Village@yahoogroups.com<mailto:Axapta-Knowledge-Village%40yahoogroups.com><Axapta-Knowledge-Village%40yahoogroups.com>[mailto: > Axapta-Knowledge-Village@yahoogroups.com<mailto:Axapta-Knowledge-Village%40yahoogroups.com><Axapta-Knowledge-Village%40yahoogroups.com>] > On Behalf Of Ricardo Cortés > Sent: 18 December 2006 02:00 > To: > Axapta-Knowledge-Village@yahoogroups.com<mailto:Axapta-Knowledge-Village%40yahoogroups.com><Axapta-Knowledge-Village%40yahoogroups.com> > Subject: RE: [Axapta-Knowledge-Village] Problem with the explosion feature > at the sales line!!!! > > Hi Harry, > > I'm running in ax 3.0 sp 5. > > After invoice the first sales order there isn't any record on that table > (InventSumtts) for the item. There are only two records on inventSum table. > The net requirement form for that item shows two lines with on hand, one > with positive quantity and other with negative quantity. > > Do you know what is happening? > > Regards > > Ricardo Cortes > > Harry Deshpande <[EMAIL PROTECTED]<mailto:harryd%40microsoft.com> > <harryd%40microsoft.com><mailto: > harryd% <harryd%25>40microsoft.com>> escribió: > hi > > Which version are you running? > > You will have to do some investigation > > after you invoice the first sales order, what are the records in > InventSumLogtts table? > > regards > > harry > > ________________________________ > From: > Axapta-Knowledge-Village@yahoogroups.com<mailto:Axapta-Knowledge-Village%40yahoogroups.com><Axapta-Knowledge-Village%40yahoogroups.com> > <mailto:Axapta-Knowledge-Village%40yahoogroups.com> [ > Axapta-Knowledge-Village@yahoogroups.com<mailto:Axapta-Knowledge-Village%40yahoogroups.com><Axapta-Knowledge-Village%40yahoogroups.com> > <mailto:Axapta-Knowledge-Village%40yahoogroups.com>] On Behalf Of Ricardo > Cortés [EMAIL > PROTECTED]<mailto:ricardocortesrivero%40yahoo.com.mx><ricardocortesrivero%40yahoo.com.mx> > <mailto:ricardocortesrivero%40yahoo.com.mx>] > Sent: Friday, December 15, 2006 10:53 PM > To: foro > Subject: [Axapta-Knowledge-Village] Problem with the explosion feature at > the sales line!!!! > > Hi all, > > I've been having troubles with the explosion at the sales line, it is > showing that i have inventory on hand when there isn't. > > The scenario to reproduce teh problem is: > > Create a sales order for an item without inventory on hand > Run the explosion from the sales line > The explosion form will show you a planned purchased order, this is > correct. > Firm the planned purchased order, receive the item and invoice the sales > order. > > Create a new sales order for the same item (the item don't have inventory) > Run the explosion from the sales line again > The explosion form will show that the item has inventory onhand when the > reality there isn't. > > If you check the net requirement thru the sales order you can see that > axapta is showing two lines in on hand one with a positive quantity and > other with neative. So, like axapta is seeing lines with on hand for this > item is not calculating the requirement and is not plannig the purchase > order. > > I know that Axapta in the explosion only take into account a few > transaction for the item, but in this case it seems that is not settling the > previous transaction and that is why the result from the explosion is wrong. > > Only running the Master planning for all the items in the regeneration > mode fix the problem. > > Does any one have an idea of what is happening or if this is a bug? > > Thanks in advance > > Ricardo Cortes > > __________________________________________________ > Correo Yahoo! > Espacio para todos tus mensajes, antivirus y antispam ¡gratis! > Regístrate ya - http://correo.yahoo.com.mx/ > > [Non-text portions of this message have been removed] > > --------------------------------- > Do You Yahoo!? La mejor conexión a Internet y 2GB extra a tu correo por > $100 al mes. http://net.yahoo.com.mx > > [Non-text portions of this message have been removed] > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]