Keyword: Reorganize tables were killed while busy

Class: Error Session: ttaad4225m000 Object: various

Country: F

Description:
Situation Description:
The session 'Reorganize Tables' [ttaad4225m000] were killed or stopped while the job were busy.
The system is not able to be started any more.

Solution Description:
While running, the session first creates a file called R.<tablename>. Then the table will be rebuilt using
this R.<tablename> file. When everything runs well, when the table is reorganized, the R.<tablename>
is removed from the system. After the session is killed (while running), the original table will not be
complete - it is not suitable for use anymore.
In this case you will have to rebuild the table using the R.<tablename> file manually. Shell down to
Unix or DOS level and go to the directory where the reorganize session started from, search for the
R.<tablename> file(s) and run the command given below:

Unix: bdbreconfig6.1 -N <tablename><company no>+
NT: bdbreconfig -N <tablename><company no>+

Example: In most cases the file(s) can be found in the TMP-directory of the root-path. The name of
such a file could be 'R.tibom000822'. If you have a NT-System the command you will have to run will
be:
bdbreconfig -N tibom000822+

This command reads the tablename and company number given as arguments and converts them
into a new table definition matching the new data dictionary definition. It requires a new data dictionary
with a '.new' extension, the current data dictionary and tables matching those in the current data dic-
tionary. After successful completion, old tables are deleted and new are generated.
The command finds the optimum way to reconfigure and if there is no real change in two data
dictionaries it prints the massage 'No conversion required'. Furthermore it sees to it that a database
remains consistent. When more than one table is given to be reconfigured and if an error occurs in the
middle of the operation, it reverts to the orriginal state.

Warning: make copy of the dump/file(s) before doing this!!

Good post Phoenix! Not that many people are aware of this 'recovery' procedure throug bdbreconfig6.1 although it is documented in the Tools Technical Manual.

Alright - where are you getting this cool stuff?
How long have some of you been involved with Baan-Oracle?
How can I get a copy of a Tools Technical Manual?
What other toys do you have that might help we BaaN/Oracle rookies?

Thanks!

Were to get those info from?
- BGS, search with keyword Oracle.
- Take a look at the quick guides.
- Ask your tools consultant for scripts/documentation.
- Look on the net on boards like this one.
- Ask colleque's.
- Manuals like a programmers manual can be printed out by the documentation sessions, not sure if you can do that also for the tools technical manual.

Baan already started in 1988 to develop a driver for Oracle, I was supporting the programmer then. However I started to use it reguarly since 1997.

Does that answer some of your questions?

One comment on your first posting: analyze on $IDX1 does not do all indexes! I am used to do an analyze on a weekly basis and simply generate the analyze statements by quering all tables which are owned by baan.

Regards,
Han

Dear Gurus
I am also facing the same issues and getting more than 9 R FILES created in tmp folder. How to bdbreconfig each single file or just run the command and the system will recover all available R files?

Thanks

Dear Gurus
I am also facing the same issues and getting more than 9 R FILES created in tmp folder. How to bdbreconfig each single file or just run the command and the system will recover all available R files?

Thanks

I think this is the format of the bdbreconfig command

# bdbreconfig6.1 -Ntimcs016 -C100

And i have used bdbpre and bdbpost,so based on that i can suggest create a text file and input all the tables in that you want.For example

Input.txt

timcs016
timcs017
timcs018
timcs019
timcs020

And put this input.txt as input to the bdbreconfigure6.1 command like

bdbreconfig6.1 -I /temp/Input.txt -C100

Not entirely sure about the syntax but you can check in your respective shell about it.

Thanks Ajesh,

manage to recover the data accordingly.

Hi,

thanks for this excellent thread.

In my case, I used "bdbreconfig6.1 -Ntfacp200<Company> -m -n -f", but nothing happend (okay, output three lines; line 1 = Table ..., line 2 = --- ..., line 3 = tfacp200<Company>, but column "New" did not display any Counter).

After a "ps -ef" I found a hanging inf_srv6.1 process which had to be killed before.

After that, when I restarted bdbreconfig6.1, the "New" counter started like a charm.

Regards
Günther