To All Baan Gurus out there,

We recently imported our data into the the test environment using Oracle Export / Import. But after that when we try to insert a sales order it gives error 510, Data dictionary corrupt. I investigated this problem more and found that the problem is with tcmcs036 table. This table has an extra text field when compared with our live system. Probably some solution that was imported into development and not in live.

I tried doing a convert to RDD and create RDD... did not work!

What do I do? :confused:
Do I need to delete and recreate the table? Once I do that can I then import
the data using bdpre and bdpost.

Or is there any other smart way of doing this?
Thanks in advance
BG

Because the data definitions are different try th efollowing:

1. Be sure you are the only one in the system.
2. Start session ttaad1120m000
3. Check path table defintions
4. Move the file dtcmcs36 in this path to dtcmcs036.save
(PATH example: /baan/dict/ddPACKAGECOMBINATION/dtcmcs)
5. Load the table
6. Run 'Create runtime DD' ('reconfigure tables = yes')

Thanks for that Jelle.

Your referred to package combination there...

Which package combination do I do it in. When I went into the directories I find that the definition exists in all the package combinations including the customised comb on which the company is created.

So do I change the file in the Customised layer and then create RDD at this VRC. The table is not customised. If I look into Maintain table def then the table exists only in C4 and stnd package combinations.

Bhaswar

Use the package combination linked to the company in ttaad1100m000
This is the company # you want to load the data for.

hi Jelle,
This did not work. :( From what I can infer is that the table definition in maintain tables is the new one. So baan just creates another file dtcmcs036 with the same size and does not re configure tables!

Just thinking of other possibilities. Will I blow away my env by doing this:

1) copy the dtcmcs036 file in the customised (company level) to dtcmcs036.new
2) copy the dtcmcs036 file from live into the development env.
3) Run Create RDD.

Will baan now look at the new file and say, hey this table needs to be reconfigured as well?!

Also a doubt on the dict directory:
I see that although the table defn is in the stnd package comb the dtcmcs036 file exists in all the directories including the customised (company level). Is this how it works?

Thanks

BG