Hi,

While executing the ttaad4227m000(Reorganisation) we found following messages on event viewer with indicating as Error:
" Overflow file required sess bdbrefconfig table tiitm001"
" Overflow file required sess bdbrefconfig table tccom010"

What is the reason ? do we need to rectify any thing .

We are using Window 2003 ; SQL 2000.Baan IV c4.

Please Advice.

VERSION(S):
all

SITUATION IDENTIFIED IN:
bdbreconfig on audit-tables

ATTACHMENTS:
not applicable

SITUATION DESCRIPTION:
during bdbreconfig on audit-tables messages occur:

Message Overflow file required. Sess bdbreconfig Table xxx

SOLUTION DESCRIPTION:
Audit server has per-table buffer where table changes are saved till end of
transaction. There is default buffer size for all tables. If the table data
needs more memory than the buffer, an overflow file is used to save the table data. The fact that an overflow file is required means that there were lot of table changes within a transaction ( possibly indicating a long transaction ).

This message is pure informative to the user.

The size of the buffers can't be changed by the user; they are fixed.
Use of an overflow files indicate a long transaction but this can be normal.
You migth want to check the transaction to see if there is a problem.

EXAMPLE(S):
not applicable

WORK-AROUND:
not applicable