Hi all,

I have problem in "copy components" from one VRC (test/development) to another VRC (Live environment) on the same machine. I used session ttadv6265m000 to copy components from one VRC to another, selected following components in range :

Session, Reports, Form, Program scripts, Table & domian.

all components copied successfully, no error in process. In the second step when tried to compile the program scripts and libraries, I got errors like

No definition in definition file for sopen(F_BRDD:dtcais002, dtcais002)
ptcais04010( 13): Error: Can't read dd for table 'ttcais002'.

I also tried to create tables in session ttadv4520m000, it give error as

cannot find table definition ttcais002

any idea?

thanks in advance
Mahmood

Have you done a create or convert to run time data dictionary on the tables? You need to do that first before the new VRC will recognize the tables. Then the compiles should work.

Mark

Let me know the difference of Convert runtime and create runtime data dictionary, Actually what it does....

In create runtime data dictionary, I got session options...

thanks in advance

Hi Mark,

Yes I ran the "create run time data dictionary" on the tables & domains, but still the table definition are missing. I tried to acces the table informaion using the session "Display general table information" (ttaad4500), I got the error as

file ttcais002 does not exist.

Any idea and/or suggestion?


Thanks in advance
mostrightfuture

Senthil - I was talking about session ttadv5210m000. You can pick tables, sessions or domains. I typically pick domains and then run a specfic table. What you all might want to try is in the VRC where the new table is located, make a change to it. So change a label, then change it back. The do the convert to runtime. I have see this before in somecases, making the change and then changes it back lets baan know that a table change happened and needs to be converted. I have seen cases where moving from one VRC to another does not trigger it to actually make the change. Once you actually see the convert work, log out and then back into Baan. Then you should be able to allocate the table.

Mark

Hi Mark,

I tried what u suggested, but still its not work. Also I manually created the same table in the target VRC, and created the runtime data dictionary for that table, then logout and login. Now the error is changed as :

"can't read dd for table tcais002".

Also in session session "Display general table information" (ttaad4500), I got the error as :

"Data definition ttcais002 not present"

Any idea/suggestion
Thanks in advance

If you are on Windows environment, a possible explanation is that you need to reresh shared memory. The surefire way to do this is reboot the server.
If you cannot do that, you need to run Shared Memory Manager & refresh it in there.

hi All,

I refreshed the share memory through the share memory manager, and aslo restarted the machine but ........... :( it not works.

Hellllllllppppppppppppppp.
Hellllllllppppppppppppppp.
Hellllllllppppppppppppppp.


Thanks in advance
Mahmood

Is the dictionary file actually there? On our system the dict level is located the same place as the bse. Under the dict directory you should see a dd file - for example on ours it is ddB40C_prd. Under this you should see something like dtcais. If not make sure the ais module has been created in your production VRC. Go into the dtcais directory and make sure you see a file like dtcais002. Ours has rw permissions for the owner and the group. Make sure bsp is the group. We just had a case where my user id was changed from bsp group to another group. Everybody received errors except me when trying to access the new tables. They also received "data definition not present" errors.

Mark

Can you supply the vrc structure you are working with.

Other suggestions:

Did you copy the table definitions to the new vrc?
Are there other users in the Package Combo when you converted/created runtime?
Try running convert followed by create runtime.
Is the package vrc in the structure that your user connects to? or is it on a different branch?

hi mark, toolswizard and others,

Directoy dtcais and file within the directoy "dtcais002" is existed. Package ais is successfully created, other scripts & sessions which are using the existing tables of baan are compiled and running error free, but only those session and scripts which are using that new table "tcais002" having that problem.

Thanks toolswizard for your time, I have already checked/done those points which you mentioned. I dont think so that this is the problem of "package vrc in the structure " or like that.

Thanks
Mahmood

I had the same problem when I was working on Win NT, and I resolve that problem with shutdown the server, not restart. I think that is becouse of new domains.

Pedja

Hi all,

One thing I forget to tell, I dont know it could be the cause of prblem or not, I tried the "Export/Import process" when the user where working with Baan. but the package "ais" is totally new for the Live environment. When I tried that "Copy procedure", there were no user login into Baan.

I dont know it could be the reason, becaues I tried to create the table manually and created run time data disctionary. While I compile the session which is using that table, I am getting error as

cannot find table definition ttcais002

Also in session session "Display general table information" (ttaad4500), I got the error as :

"Data definition ttcais002 not present"


Thanks
Mahmood

Sometimes that darn convert gets stuck and you are hosed unless you remove everything and try again.

Can you try 1 thing? In your new VRC, try and copy that table in Maintain Table Definition to a new name. Convert to runtime, exit, come back, can you create the table now?

If so, you need to remove the other version all together, delete the table def in maintain table definition, and remove any references to the DD in the OS. Run a convert with everything gone, exit and come back. Then copy back to the right number from your backup.

If you still can't create the table under a new name, maybe there is some real problem with the table def.

Hi all,

Thanks every one who spent time.

lbencic, I tried the same as u suggested and problem resolved. In the maintain table session, when I tried to access the table, it asked that

"file is not alocated, do you want to alocate?" (Yes/No)

I said Yes, and problem resolved.


Thanks again to every one.
Mahmood