Hello,

After adding a new field, I tried to create the DD for this table, but it was impossible. For this reason I killed the process, lossing all the information of this table.

In $BSE/tmp I can see the R.<table> field which includes all the information, but I don't know how to recover it.

Does anyone know how to restore this information??

Dear pitfloner,

please try this link:

http://www.baanboard.com/baanboard/showthread.php?t=12261&highlight=error+reorganize+table


"In case of interrupted reconfiguration while the R.<table> file still exists, the following command:

bdbreconfig6.1 -N ttadv100222+

will use the dump R.ttadv100222 to rebuild the table."

BEFORE using this command check on Unix Level how many records are inside:

$>wc -l R.file

You could also check ttadv501 (Comp. 000) and ttadv502, ttadv503 Table for entries.

If so you could try to restart the Reconfigure Table from BaaN Menue, BaaN normaly mentions this is a restart of an abortet Reorg of the Tabel.

Backup the "R." file before, afterwards BaaN will delete it if reorg was successfully.

Hope it helps!

Regards,

Kozure

Hi,

Does the field which you added is the part of index.? If yes then remove the field from index and execute "Run DD" session and see if data recovers.


waiting for your reply.