Hi,

Here goes my setup

Co. 000 Package Comb - STANDARD
Co. 800 Package Comb - DEVELOPMENT

I have created 2 customized tables in Development Package Combination which is attached to co. 800 , which is fine. I am able to store data in these 2 tables as well.

TABLES
tccom910
tccom911

Now i would like to create these tables in Co. 000, so i went into GTM and was able to create tccom910, but when i try to create table tccom911 via GTM in Co. 000 it gives me Error 512 and closes.

I know error 512 would come when the definition does not match with the table structure, but i checked the definition in DEVELOPMENT Package Combination its perfect, and moreover if definition wouuld have been a issue how did it allow me to create both the tables in 800 Co. ??

Any hints/ suggestions what i should be doing to create the second table in co. 000 by getting rid of error 512 ?

Waiting for your replies.

Regards

Learner

1. What is your user ID's package Combination? You will probably have to point it to "Standard" to create it in company 000.

2. Does the Package Combination (thus the package VRC) contain the new table definition?

Also why would you want to create these custom tables in company 000. In general only tools tables (tt) are created for company 000.

1. What is your user ID's package Combination? You will probably have to point it to "Standard" to create it in company 000.
Well I changed my user package comb. to STANDARD , n then i tried creating table via GTM but then it says "Definition not found" infact for both the tables.... i am wondering how this would have worked, because table def. lies in cust vrc which is attached to DEVELOP Package Comb. , so in any case STANDARD package combo. cannot access the table def present in cust vrc. or in other words the VRC structure for STANDARD Package Comb. will not contain my dev vrc where table def. resides. May be i am wrong in my explanation since it allows me to create standard table like tccom100 etc all the standard tables in 000 co.

2. Does the Package Combination (thus the package VRC) contain the new table definition?
Yaah my DEVELOPMENT package Combination contains dev vrc which contains the table def. that's how i was able to create table in 800 Co.

*Also why would you want to create these custom tables in company 000. In general only tools tables (tt) are created for company 000.
We normally refresh this 800 co. every 2 months or so, and the data which we have maintained in these 2 tables, we don't want to losse while refreshing data from Production, so to avoid doing mistake i though of creating these 2 tables in 000 co. and share it with my 800 Co., so that during data refresh i don't loose data present in these 2 tables.

Regards

Learner

... "in other words the VRC structure for STANDARD Package Comb. will not contain my dev vrc where table def. resides."

You are correct here. So it should not work.

What you have to remember with companies, users, and package combinations is a triangle: Each point of a triangle is one of the following: Company, users, Package Combination (sesion, table def, objects, etc). And they all have to equal each other(99% of the time). If they don't you will get different types of errors/messages from Baan.

You have company 000 in "Standard", User in "Develop", and the Package Combination in "Develop". So with this structure in the triangle analogy, won't work.

There are probably a couple of different ways you can go about to get this to work.
1. Create the 2 tables in a different Oracle SID. (I think I saw that you are Oracle)
2. Create the 2 tables in a different company # in the same Package Combination.
3. Just remember to restore these tables. If static, just have a backup copy of them. If dynamic, then create a script or job to bdbpre the tables on a frequent basis.