Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Distribution, Transportation & Warehousing

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 31st March 2003, 16:27
Erik Konrath Erik Konrath is offline
Member
 
Join Date: Nov 2001
Location: Cork (Ireland
Posts: 32
Erik Konrath is on a distinguished road
Baan: BaaNIVc4 -
Performance problems in tdinv0250m000 and MPS

Hi,

Over the past three weeks we are experiencing performance problems in both "Rebuild Inventory Transactions" and "Generate MPS orders". We think that the two are related, because of the following sequence of events:

06.03. New Manufactured items added to the item table.

07.03. First time the session "Rebuild Inventory Transactions" (tdinv0250m000) runs much longer than usual (before: 12 minutes run; since 07.03.: 1h10 minutes).

21.03. The new items have been added as planned Items to the MPS.

22.03. First time MPS runs much longer than usual (before: 30 minutes; now 12 hours!!!).

We would like to identify which of the new items cause the problem. Any hints what to look at?

Thank you for any hints.

Erik
Reply With Quote
  #2  
Old 31st March 2003, 17:15
Djie-En's Avatar
Djie-En Djie-En is offline
Senior Member
 
Join Date: Apr 2002
Location: The Netherlands
Posts: 197
Djie-En is on a distinguished road
Baan: BaanIVc4 - DB: Oracle11.2 - OS: AIX6.1
Performance

Hi,

Just add a datafile to the tablespace and put it on the same disk as the RollBackSegments?
Pls. what's your OS, Database?

GN
Reply With Quote
  #3  
Old 2nd April 2003, 07:43
JamesV JamesV is offline
Senior Member
 
Join Date: Aug 2001
Location: Grand Rapids, MI, USA
Posts: 225
JamesV is on a distinguished road
Baan: Baan IV/5 - DB: Oracle 7/8/8i,Informix, SQL Server, UDB - OS: AIX, HP-UX, Tru64, Solaris, NT/2000
It may not be appropriate for the new items to be included in the planning bills. If these new parts are referenced by a variety of BOMs, and there is contention for these items if you are using multiple bshells, it could easily extend the runtime.

Also, if there was a mass load of items, were database statistics recently regenerated?

Also, if the distribution of data changed, you may have different execution plans for the queries versus when there was less data.

What is the planning horizon for these new items, perhaps your time fence is set out too far in the future.

-- Jim
__________________
Jim VanderMey
VP of Technical Operations
Open Systems Technologies
Grand Rapids, Michigan, USA
jvandermey@ostusa.com
Reply With Quote
  #4  
Old 2nd April 2003, 11:13
Erik Konrath Erik Konrath is offline
Member
 
Join Date: Nov 2001
Location: Cork (Ireland
Posts: 32
Erik Konrath is on a distinguished road
Baan: BaaNIVc4 -
Estimated Statistics

Jim,

Thank you for your response.

We run Estimated Statistics on all our Oracle tables every night.

However we have discovered that the problem might at least partly be linked to the table timps520 (Planned MPS Production Orders). We deleted that table and recreated it with just one Planned Production Order, and the runtime was normal when generating MPS for the relevant item, whereas before the deletion of the table, the runtime was very long for the same item.

Unfortunately we don't know why...

Thanks & Regards,

Erik
Reply With Quote
  #5  
Old 27th March 2009, 17:24
osoleil74 osoleil74 is offline
Newbie
 
Join Date: Mar 2009
Posts: 2
osoleil74 is on a distinguished road
Baan: b40c3 - DB: oracle - OS: nt4
hello

i have the same problem with this session 7 minute to 12 heurs but we dont use mps we follows the solution but we dont work for me.

do you have a explanation of this

thanks
osoleil
Reply With Quote
  #6  
Old 28th March 2009, 06:46
sushil's Avatar
sushil sushil is offline
Guru
 
Join Date: Jan 2006
Posts: 451
sushil is on a distinguished road
Baan: BAAN IV C4 - DB: Oracle - OS: Windows
Quote:
but we dont use mps
Which Session / Process is getting Slower.!!
Reply With Quote
  #7  
Old 30th March 2009, 09:38
osoleil74 osoleil74 is offline
Newbie
 
Join Date: Mar 2009
Posts: 2
osoleil74 is on a distinguished road
Baan: b40c3 - DB: oracle - OS: nt4
Smile Resolved

Hello


I have resolved the problem of the session Tdinv0250m000 wiht the cpu at 100 % for 12 hours. I have make a dump of the the table article tiitm001 and after i have deleted this table anc re create from the dump.

I don't no why but it's work. the session run in 12' minutes after that.

it' very strange

thanks for your help
Reply With Quote
Sponsored Links
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +2. The time now is 23:05.


©2001-2017 - Baanboard.com - Baanforums.com