OK, I have created a new table from scratch.

I have set it up in maintain Table Defs, Created Runtime DD, converted to Runtime DD ( a number of times actually ), no error messages, every thing seems good. Exit baan and back in and trying to create the table.

... Cannot find table def ... Grrr .... Any ideas why not ?

I have done this so many times in the past and sometimes it is hit and miss with the error popping up. Why would this be happening on a freshly created table ?

In the past, we have needed to restart the server in some instances probably because of shared memory, but this is a first time new table ....

I read in a post about the shared memory service may need to be started and stopped. Is this true? If so, this I assume cannot be done while users are active and I'll need to do this on the windows 2003 services somewhere ... ? I'm not too familiar with services under W2003 Server....

I found that it created a file in the baan\dict\dd'my live name'\dtccom folder.

It appears to be a file with name and domain information in it ....

:RELE:6.1
F
:NAME:tccom806.uid
:DOMA:tccom.uid
F
:NAME:tccom806.group
:DOMA:tcmcs.str6
F
:NAME:tccom806.type
:DOMA:tcmcs.str8
F
:NAME:tccom806.rate
:DOMA:tcratp
F
:NAME:tccom806.Refcntd
:DOMA:tcRefcnt
F
:NAME:tccom806.Refcntu
:DOMA:tcRefcnt
I
:IDNO:001
:KEYF:tccom806.uid
:ACTI:1
L
:RELA:tccom806.group tccom806.rate tccom806.type tccom806.uid
A
:AUDT:tccom806.group tccom806.rate tccom806.type tccom806.uid


This seems to be the only place I see something ofr my new table tccom806 ....

Well, recreated the table on my backup system and same problem. Reset the server and everything is golden ... nuts .....

Now, with respect to Windows 2003 and BaanSharedMemory Service. I read people can disable, then enable this service again instead of a reset ?

What effects does this have on users logged into the system ?

I would prefer not to restart the server if I don't have to ... affects too many production activities ... thanks ..

Well, recreated the table on my backup system and same problem. Reset the server and everything is golden ... nuts .....

Now, with respect to Windows 2003 and BaanSharedMemory Service. I read people can disable, then enable this service again instead of a reset ?

Yes, you can restart shared memory for this. No need to reboot OS.

What effects does this have on users logged into the system ?

If users are logged into the system, they will be thrown off the system. This is not recommended..

When users are connected, a Shared Memory Restart may not necessarily work. This happened on our Live environment. We had to customize a domain and update all the tables using that domain and after doing all the converting business, I stopped and restarted the Shared Memory (as i had no choice and only few users were on) and it flashed a message suggesting some users were connected and that memory may not have been flushed or something like that.
Had to finally restart the server to get the customized domain to work...

sk

Thanks for the info guys ...

Sukesh75, yes, I got the same message when i tried to stop and restart the service, so I also ended up resetting the server too. Oh well :) ... Only interrupted 3 users this time ...

Thanks .....

a new table should get loaded into shared memory when accessed. if it is not then it is a bug.... UNLESS you also added/modified a domain as well.

For changes to existing tables / domains you can manually remove the offending table/domain from shared memory by using the shared memory manager. no effect* on users and no reboot required.

Dave


* if you change a table users may be effected anyway regardless of the DD.

Hi Dave,
Mind telling us how its done (step-by-step) in the Shared Memory Manager? I am sure this issue would pop up again sooner..

Thanks
sk

I was just gonna ask that question too ( Shared memory Manager ) :) ..

Yes, actually, I did add a domain this time around .... so now I know why sometimes I have to reset server and others I don;t ....

I actually don't have access to a baan windows environment anymore so I'll have to give you the "step-by-step" from memory.

Open the "Baan NT Manager" or "bentman.exe"

Find the Baan Shared Memory section. Right click and choose "show loaded"
(or something like that.)

It will pop up a window that lists all of the DD contents of your shared memory.
It's sorted oddly (not necessarily alphabetical). Find the object you'd like to remove from shm in the list, select it and click "remove from memory".

It's actually listing filenames not tables or domains. so if you want to remove a domain from shared memory you'd need to remove the entire domain file (dtc.pd for example.)

The next time one of those objects is accessed Baan will load the new copy of the file into shm.

Existing users in the system will still use the old version of the object until they logout/log back in. (because baan caches it in the driver and the bshell as well) So you could get 512s or index out of dims, etc if you've done table changes with people on the system.

Dave

Interesting stuff.

I tried this in both my NT4 environment and windows 2003 envt. I ran bentman and get the manager, rt click on shared memory service only gets me "Configure" or "Shared memory manager" Stop or restart.

Selecting Shared mem mgr gives me an error "Link to Shared Memory Failed: error errno 22 shm_errno 0

I will show this to our Server guru when he returns next week and see if we has seen this before.


I can also view the shared memory mgr under 'Services" on the 2003 server as well, but no option to 'see' what is in there. Too bad ......

Thanks for the tips Dave_23 ...

are you connecting to the server via Terminal Services / RDP?

Dave

Ah, yes I am. I'll go over to the server now and check from there ... From RDP, I logged into command prompt with the baan user id.

OK, from command prompt as baan admin, I ran bentman. Runs fine.
Then click on Shared memory Service, Shared memory manager. This time from the server, the box pops up !

There is a Show loaded box in there. And, sure enough, it shows all.

So, from here, I select my object and rt click, select unload.

Then, once done, I guess I hit load again to reload it all ?

I remember seeing this a long time ago when I first worked with Baan but it was way over my head back then as to it's usefullness :) .....

glad it's working!

you don't need to "reload all" because baan will load it automatically the next time it accesses the file.

Dave