Baan 5.0B
Oracle 8.0
Win2K server
Company 111 - main company (logistic+finance)
Company 122 - financial company
Company 133 - financial company

We have a live and test server, which were both running ok, without problems. I realise now, that we have a problem on our test system: when zooming to a field using logistic tables from within a finance session in company 122, we get an error 506 " Table does not exist ".

Example: in session tfcmg4120s000 (direct debit advices) on second form the field debiter's bank (table tccom115), when zooming to select the bank via session tccom4515m100, error 506 and fatal error " cannot continue in tccom4515m100 "

This happens only in the test system, not the live. This test server is running since about 1.5 years. I cannot say for 100% sure that the problem didn't exist in the past, since normally we test in the main company 111, which doesn't have this problem.

The logical tables seem ok. When I call the logistic tables via GTM for comany 122, it works fine without any error.

Can anyone help me with this?

Thanks a lot in advance!

En

Mostly multisite configurations seems to be a problem. Check if the logistcs companies by finance companies are correctly set. (session tfgld0100m000)

Actually our configuration works fine for over 5 years already. It is just that on our test server something must have gotten messed up...

The logistic companies by finance companies are alright...

Anyone different idea?

Probably the runtime file compnr6.1 in $BSE/lib is overwritten by a subsequent change in ttaad4120m000 and CRDD in that session .

If that be the case ,restore this file from backup and c if the error still comes.

The file compnr6.1 was ok.
However, it seems that when migrating to higher service pack, only existing tables were created for the financial companies, but the new added tables (/fields) were not created...... (??!!)

After create tables for all tables in company 122, the problem was solved.