Dear Frnds,

We were on SP 17.We installed SP 18.I think SP 18 adds tiit001.exkb field in Item Master Table standard table.But we copied the table in customized VRC and added some more fields in the table tiitm001.so new field "tiitm001.exkb" is not coming in tiitm001 customized table,so i tried to add the field "tiitm001.exkb" in tiitm001 customized table.after doing CRDD.table got courrpted.This is 2nd time i faced the problem after installing SP 18.HOw to take care of the problem bcoz we customized TIITM 001 table.

Please help

Regards,
Hardei

your idea was correct you must have just done something wrong.

Just add the new field to your custom table.

Or contrarily - add your customizations to the new table def that baan provides.

DAve

Dear hardei,

please post your tabledefinition (..Print Table definitions) for your tiitm001 from the customer vrc after adding the field.

Is the domain for the baan field visible in the vrc path?

Did you run "Convert to RDD" or "Create RDD" with reorg of the table?

What is the exakt error message if the table gets corrupted?

My normal way is:

(1) Add the field in the customer VRC e.g. tiitm001
(2) If you import the table modification from a test system via "internal Software distribution" i mark the table as expired, press save button , unmark the "expire" -> a Record is written to the ttaad501 / ttaad502 Table -> Baan knows which table has to be reconfigured.
(3) Convert to RDD with reorg Table option (shell appears with records exported/imported)
(4) Afterwards check ttaad501 ...etc. Tables if still entries exist (should be empty)
(5) Log out from BaaN, Login BaaN (because Dictonary is read at startup of the BaaN Client), otherwise error appears that data dictonary is corrupted because it uses the version read before the modification which does not fit to the current table definition.
(6) Check with ttaad4500 if no error appears and the new field is visible.

Hope it helps,

Regards

Kozure


Regards,

Kozure