Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor

Main

Google search


Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
14%
200 - 500 GB
32%
500 - 800 GB
4%
800 - 1200 GB
4%
1200 - 1500 GB
11%
1500 - 2000 GB
14%
> 2000 GB
21%
Total votes: 28

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 17th October 2012, 20:46
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,135
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
tibom1213m000(Detect low level code and loop) Issue
Baan: Baan IVc4
C/S: None/Unknown

Thought I would try this forum first to see if anyone has seen anything like this for this session or others. We have a case where tibom1213m000(Detect Low Level Code) has been increasing in run for months. You can see the chart below. We moved to new equipment in November of 2011 and expected a slight increase. Now it kept increasing until April 6th - we cannot figure out what happened on April 6th 2012 to drop the run time back down to about 40 minutes. The run times continue to grow for this session is now over 6 hours. Any clues? Of course nobody claims to have made any changes that weekend for the run.

We logged a ticket with infor and they basically said I/O was the issue - but we have been on the same hardware and storage up until about two weeks ago. At that time we moved from tier 2 storage to tier 1 storage(I don't have the types of drives or any information around this). As it was a lot of other things perform great now, but this job continues to grow. Anything anyone can think of to look at?

We have two sessions showing this trend tibom1213m000 and calculate cost prices - don't have the session number handy. We are going to try exporting and importing the main tables for the session this weekend. See what happens after that. We did just clone our production company a couple of weeks ago - this session runs under 1 hour all test environments and in 30 minutes in the recently cloned copy(export/import basically). OH - database is Oracle 10g. Any clues or thoughts appreciated.

30 tibom1213m10b Update Low Level Codes and Detect Loops No 08-05-2011 17:14 08-05-2011 17:45 101 0.52
30 tibom1213m10b Update Low Level Codes and Detect Loops No 08-12-2011 17:14 08-12-2011 17:49 101 0.58
30 tibom1213m10b Update Low Level Codes and Detect Loops No 08-19-2011 17:14 08-19-2011 17:52 101 0.63
30 tibom1213m10b Update Low Level Codes and Detect Loops No 08-26-2011 19:18 08-26-2011 19:58 101 0.67
30 tibom1213m10b Update Low Level Codes and Detect Loops No 09-02-2011 17:14 09-02-2011 17:59 101 0.75
30 tibom1213m10b Update Low Level Codes and Detect Loops No 09-09-2011 17:14 09-09-2011 18:04 101 0.83
30 tibom1213m10b Update Low Level Codes and Detect Loops No 09-16-2011 17:16 09-16-2011 18:12 101 0.93
30 tibom1213m10b Update Low Level Codes and Detect Loops No 09-23-2011 17:14 09-23-2011 18:11 101 0.95
30 tibom1213m10b Update Low Level Codes and Detect Loops No 09-30-2011 17:18 09-30-2011 18:29 101 1.18
30 tibom1213m10b Update Low Level Codes and Detect Loops No 10-07-2011 17:14 10-07-2011 18:17 101 1.05
30 tibom1213m10b Update Low Level Codes and Detect Loops No 10-14-2011 17:14 10-14-2011 18:17 101 1.05
30 tibom1213m10b Update Low Level Codes and Detect Loops No 10-23-2011 17:52 10-23-2011 20:36 101 2.73
30 tibom1213m10b Update Low Level Codes and Detect Loops No 10-29-2011 02:21 10-29-2011 05:26 101 3.08
30 tibom1213m10b Update Low Level Codes and Detect Loops No 11-04-2011 17:13 11-04-2011 20:20 101 3.12
30 tibom1213m10b Update Low Level Codes and Detect Loops No 11-11-2011 17:16 11-11-2011 21:02 101 3.77
30 tibom1213m10b Update Low Level Codes and Detect Loops No 11-18-2011 17:16 11-18-2011 20:48 101 3.53
30 tibom1213m10b Update Low Level Codes and Detect Loops No 11-25-2011 17:15 11-25-2011 20:52 101 3.62
30 tibom1213m10b Update Low Level Codes and Detect Loops No 12-02-2011 17:18 12-02-2011 21:14 101 3.93
30 tibom1213m10b Update Low Level Codes and Detect Loops No 12-09-2011 17:12 12-09-2011 20:58 101 3.77
30 tibom1213m10b Update Low Level Codes and Detect Loops No 12-16-2011 17:11 12-16-2011 21:18 101 4.12
30 tibom1213m10b Update Low Level Codes and Detect Loops No 12-23-2011 17:11 12-23-2011 21:16 101 4.08
30 tibom1213m10b Update Low Level Codes and Detect Loops No 12-30-2011 17:11 12-30-2011 21:42 101 4.52
30 tibom1213m10b Update Low Level Codes and Detect Loops No 01-06-2012 17:11 01-06-2012 21:40 101 4.48
30 tibom1213m10b Update Low Level Codes and Detect Loops No 01-13-2012 17:12 01-13-2012 21:57 101 4.75
30 tibom1213m10b Update Low Level Codes and Detect Loops No 01-20-2012 17:11 01-20-2012 22:01 101 4.83
30 tibom1213m10b Update Low Level Codes and Detect Loops No 01-27-2012 17:12 01-27-2012 22:32 101 5.33
30 tibom1213m10b Update Low Level Codes and Detect Loops No 02-03-2012 17:11 02-03-2012 22:28 101 5.28
30 tibom1213m10b Update Low Level Codes and Detect Loops No 02-10-2012 17:12 02-10-2012 23:00 101 5.80
30 tibom1213m10b Update Low Level Codes and Detect Loops No 02-17-2012 17:11 02-17-2012 22:44 101 5.55
30 tibom1213m10b Update Low Level Codes and Detect Loops No 02-24-2012 17:11 02-24-2012 22:53 101 5.70
30 tibom1213m10b Update Low Level Codes and Detect Loops No 03-02-2012 17:53 03-02-2012 23:50 101 5.95
30 tibom1213m10b Update Low Level Codes and Detect Loops No 03-09-2012 17:13 03-09-2012 23:20 101 6.12
30 tibom1213m10b Update Low Level Codes and Detect Loops No 03-16-2012 17:13 03-16-2012 23:28 101 6.25
30 tibom1213m10b Update Low Level Codes and Detect Loops No 03-23-2012 17:13 03-23-2012 23:40 101 6.45
30 tibom1213m10b Update Low Level Codes and Detect Loops No 03-30-2012 17:13 03-30-2012 23:52 101 6.65
30 tibom1213m10b Update Low Level Codes and Detect Loops No 04-06-2012 17:14 04-06-2012 17:53 101 0.65
30 tibom1213m10b Update Low Level Codes and Detect Loops No 04-13-2012 17:13 04-13-2012 17:58 101 0.75
30 tibom1213m10b Update Low Level Codes and Detect Loops No 04-20-2012 17:13 04-20-2012 18:09 101 0.93
30 tibom1213m10b Update Low Level Codes and Detect Loops No 04-27-2012 17:13 04-27-2012 18:17 101 1.07
30 tibom1213m10b Update Low Level Codes and Detect Loops No 05-04-2012 17:14 05-04-2012 18:28 101 1.23
30 tibom1213m10b Update Low Level Codes and Detect Loops No 05-11-2012 17:14 05-11-2012 18:43 101 1.48
30 tibom1213m10b Update Low Level Codes and Detect Loops No 05-18-2012 17:14 05-18-2012 18:53 101 1.65
30 tibom1213m10b Update Low Level Codes and Detect Loops No 05-25-2012 17:13 05-25-2012 19:05 101 1.87
30 tibom1213m10b Update Low Level Codes and Detect Loops No 06-01-2012 17:14 06-01-2012 19:12 101 1.97
30 tibom1213m10b Update Low Level Codes and Detect Loops No 06-08-2012 17:13 06-08-2012 19:22 101 2.15
30 tibom1213m10b Update Low Level Codes and Detect Loops No 06-15-2012 17:14 06-15-2012 19:33 101 2.32
30 tibom1213m10b Update Low Level Codes and Detect Loops No 06-22-2012 17:14 06-22-2012 19:44 101 2.50
30 tibom1213m10b Update Low Level Codes and Detect Loops No 06-29-2012 17:13 06-29-2012 19:56 101 2.72
30 tibom1213m10b Update Low Level Codes and Detect Loops No 07-06-2012 17:14 07-06-2012 20:04 101 2.83
30 tibom1213m10b Update Low Level Codes and Detect Loops No 07-13-2012 17:13 07-13-2012 20:23 101 3.17
30 tibom1213m10b Update Low Level Codes and Detect Loops No 07-20-2012 17:13 07-20-2012 20:27 101 3.23
30 tibom1213m10b Update Low Level Codes and Detect Loops No 07-27-2012 17:14 07-27-2012 20:41 101 3.45
30 tibom1213m10b Update Low Level Codes and Detect Loops No 08-03-2012 17:14 08-03-2012 20:53 101 3.65
30 tibom1213m10b Update Low Level Codes and Detect Loops No 08-10-2012 17:14 08-10-2012 20:58 101 3.73
30 tibom1213m10b Update Low Level Codes and Detect Loops No 08-17-2012 17:14 08-17-2012 21:11 101 3.95
30 tibom1213m10b Update Low Level Codes and Detect Loops No 08-24-2012 17:13 08-24-2012 21:20 101 4.12
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
  #2  
Old 17th October 2012, 23:01
GaryEd GaryEd is offline
Senior Member
 
Join Date: Sep 2001
Location: CT, USA
Posts: 139
GaryEd is on a distinguished road
Baan: 4c4 sp 30 - DB: SQL 2008 R2 - OS: Windows 2008 R2
Is there any output from running the session? ie do you actually have a loop in one of your boms?
Maybe someone messed up a bom a couple of weeks ago.
__________________
Gary
Reply With Quote
  #3  
Old 18th October 2012, 00:22
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,135
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Thanks for the response. That was one of the things we looked for - we could not find any loops any place. Tibom1213m000 generates an error report, and I was told that if a part has a loop then the regen run would also generate an error for the part. So we looked, but could not find anything wrong with the data itself. As a matter of fact everything else in this batch job(except calculate cost price) runs pretty consistently. Those two sessions seems to keep creeping up in time.
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
  #4  
Old 22nd October 2012, 16:25
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,135
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Well we re-org'ed the three main tables and rebooted the whole environment. Session still runs slow in production. Not sure what else to look at for now.
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
  #5  
Old 22nd October 2012, 16:29
GaryEd GaryEd is offline
Senior Member
 
Join Date: Sep 2001
Location: CT, USA
Posts: 139
GaryEd is on a distinguished road
Baan: 4c4 sp 30 - DB: SQL 2008 R2 - OS: Windows 2008 R2
Are you running the job with update low level codes set to yes?
What is the performance like if you run it manually?
__________________
Gary
Reply With Quote
  #6  
Old 22nd October 2012, 17:08
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,135
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Yes - runs slow. I have also just learned the 3 main tables are being audited in production, but not in all the test companies. I am leaning towards that - plus the audit flat files are on tier 2 storage making it even slow. I am going to try to get those admins to look at that.
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
  #7  
Old 2nd November 2012, 19:54
shah_bs's Avatar
shah_bs shah_bs is offline
Guru
 
Join Date: Jan 2002
Location: Lewisville, Texas
Posts: 390
shah_bs is on a distinguished road
Baan: BAAN IVc3 with A&D2.2b - DB: ORACLE 9 - OS: HPUX
This was too long ago (1999), but at the time tibom1213m10b used to go into an infinite loop if the session hits a retry point. The suspect was the volume of data because it used to work without failure in the pilot company - in the production company it failed - we had to stop running it for a while till it was fixed.

See if the log files throw up anything - though I do not think there was errors logged since the session was in a loop.

If you have the source code, you could place debug messages to dig out where the issue is - which is what I had to do. Otherwise you may have to get a fix from BAAN - in fact they may require to actually debug with the real data - like I said - it works just fine in a test environment with low volume data.

The main modification I had to do was to apply suitable retry points and change the way the Item Master is updated.

Unfortunately, I cannot post the code for obvious reasons.
Reply With Quote
  #8  
Old 4th November 2012, 13:54
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,135
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Appreciate the thought - but since we do not own source code I could not use it anyway. No includes, etc. In our case it does not appear to loop and I am still waiting for an admin to try something around the auditing. They are also talking about moving the application to tier1 storage, but no word on when.
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
Sponsored Links
  #9  
Old 3rd December 2012, 19:29
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,135
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Just thought I would let everyone know it was the Auditing on the tables that caused the issue. The audit log for tibom010 went back to .001 this past weekend and the runtime dropped to 36 minutes.
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
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:41.


©2001-2018 - Baanboard.com - Baanforums.com