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

User login

Frontpage Sponsor


Google search

How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
200 - 500 GB
500 - 800 GB
800 - 1200 GB
1200 - 1500 GB
1500 - 2000 GB
> 2000 GB
Total votes: 41

Baanboard at LinkedIn

Reference Content

Closed Thread
Thread Tools Display Modes
Old 2nd January 2006, 09:41
kaukul's Avatar
kaukul kaukul is offline
Senior Member
Join Date: Jun 2005
Location: Mumbai
Posts: 228
kaukul is on a distinguished road
Baan: Baan IV C4, LN, FP2 - DB: Informix, Oracle - OS: Unix, Windows
Temporary device file created in BaaN report printing

Hi all,

This is my first post in the BaaN forum.

I have one query regarding the temporary file that got created while running reports. When one of our users ran a customised session for report printing, the size of the temporary file that gets created in $BSE/tmp path increased upto 122 MB and just at the end of the report, the file size reduced to 0.8 MB (In device que, I checked the name of file in table ttaad320 corresponding to the report. The actual name of the file in ttaad320 was different. Please note that the actual file used in repeat request was a different file). In between the execution, the size of the file increased to such a high value and reduced to .8 MB.
It is obvious that this file was used by BaaN report for sorting and some other operations. Can anyone tell me why such a high size file is created ? Is there any alternative that a programmer can use to prevent creation of such high-size files in between ?
Old 2nd January 2006, 11:39
Markus Schmitz's Avatar
Markus Schmitz Markus Schmitz is offline
Join Date: Feb 2002
Location: Cyprus
Posts: 668
Markus Schmitz is on a distinguished road
Baan: Ivc4 - DB: Oracle8i/9i/10g - OS: HP-Ux11i
Maybe "as prepared set"

Maybe you should adress this request to the developer forum to get a betteranswer. Anyway here my two bits:

a) You are right, the file is used by Baan for sorting etc.

b) It usually gets so large, if Baan sees itself forced to basically dump the complete table to get a consistent view on the data. This does not only create a huge file, but also slows down the whole thing.

Sometimes this is even enforced by the programmer, by using the "as prepared set" in the select statement. Some time ago, Baan advised programmers to use this statement to avoid the "Snapshot too old " error in baan together with Oracle. In my opinion this was a pretty stupid advise and there are other means around it.


Markus Schmitz
Senior Consultant
SOFTimpact Ltd.
Old 6th January 2006, 19:17
Hitesh Shah's Avatar
Hitesh Shah Hitesh Shah is offline
Join Date: Nov 2001
Location: Mumbai,India
Posts: 1,853
Hitesh Shah is on a distinguished road
Baan: triton,Baan IVc4 , ERP Ln - DB: Oracle/Bisam/SQL 2000/SQL 2005 - OS: Sun Solaris/Windows 2003
big tmp files

This happens when there are sort fields and detail lines are not actually printed and after.field summary section is printed .

Alternative to this (though not recommended for performance considerations ) , is to summarising information program script only and do the rprt_send for summary information only.

A good long term solution would be to add hard disk space to tmp area and have trouble-free administration .
Old 9th January 2006, 05:03
kaukul's Avatar
kaukul kaukul is offline
Senior Member
Join Date: Jun 2005
Location: Mumbai
Posts: 228
kaukul is on a distinguished road
Baan: Baan IV C4, LN, FP2 - DB: Informix, Oracle - OS: Unix, Windows
Thanks a lot

Thanks for your suggestions. I will make sure our development team gets these points.
Closed Thread

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

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to incorporate report in baan standard session ??? learner Tools Development 5 24th March 2003 19:57
Baan World Users conference in Orlando chadwickh General Discussion & Chat 7 3rd November 2001 22:55
BSP-US (LLC) added as a Baan Education Alliance svandenh General Discussion & Chat 1 20th August 2001 20:44

All times are GMT +2. The time now is 12:30.

©2001-2018 - -