Hi friends,

I have this problme since long time and I asked about it in different threads but never able to fix it. I dont know process detail behind the "convert Runtime DD" for table, domain or user etc. Unfortunatly Baan never logs any thing (error or problem) during "convert runtime DD" but the process never ends.

What could be the reasons for it? If it is the problem of directory access right, user rights, path definition problem, object corrupted, etc. I have no clue about it. I observed that during the "Convert runtime DD", the file is created in the TMP directory but it always remains empty.

I will appriciate the all suggestions to resolve this problem. If someone expalin the process detail behind the wall, may be this helps to fix this problem.

Thanks in advance
MRF

Hi MRF,

first let's define, what kind of CRDD are you trying to do?

a) CRDD after user data ws changed

This is actually the most easy one. Here Baan will just rewrite the u<LOGIN> file in $BSE/lib/user. This takes usually just a sec and is most likely not your issue.

b) CRDD after change of a table

Here Baan will do the following:
- write the new DD file of this table in $BSE/dict/dd<PKG>/...
- compare the existing old and the new DD file
- if the files differ, then baan will dump the table, recreate it
and load the data again. This should create a temporary file
in $BSE/tmp, a process called bdbreconfig should run and a
logfile in $BSE/log is written (even on windows!)

c) CRDD after change of DD

Basically baan will do the same here as in (b), but for all tables, which use the domain.

Hope this helps you a bit to followup, what is happening on your side and you can give us some more details, what's going wrong.

Regards

Markus

HI Markus Schmitz,

First of all thanks for quick and detail response.

At my side problem is whenever I tried to convert runtime DD for any thing, table, domain or user, it get stuck and never comes end.

A similar problem is with printing of report (I have started a thread for this porblem but not get any resolution Select device session not started (http://www.baanboard.com/baanboard/showthread.php?t=24115) ), the select device session never started and I am not able to proceed and print the report. I noticed that the temp file for report is created in the TMP directory but it always remains empty (size 0k).

I am sure that all these problems are related and require just a very small configuration, but not know what and where?

Thanks
MRF

ok, lets have a look at the most simple of the three first:

The convert to runtime in ttaad2100m000 (user management) for a single user.

Can you execute this?
Does ist start writing the file in $BSE/lib/user? (You know most likely, that it only writes the file, if the user data was actually changed)

This is really such a simple action. No Reports are involved, just a bit of file IO and it should return immediately.

Regards

Markus

HI Markus Schmitz,

I tried to convert runtime DD for user. I changed few attributes for a test user and start convert to runtime, it runs for long time but never come to end, file remains unchange. I am not able to complete even for this simplest case.


Thanks
MRF

Hmm - not to butt-in, but can you set DBSLOG=01570 prior to running it and then attach the results?

Dave

hi dave_23,

where I should set this value?

Thanks
MRF

HI friends,

After enable the BDB/SQL tracing, got the following lines at the end of the trace log file:

Info on RDS:
(t204)DBV_SEND_BREAK (bu4)1 (bu4)7
(t201)DBV_SEND_HVARS (bu1)5 (bu1)0
(t33)QpString (s)2 (bu1)1
(t33)QpString (s)tt (bu1)2
(t33)QpString (s)genconvert (bu1)3
(t33)QpString (s)b50ocfby (bu1)4
(t33)QpString (s)tt
(t203)DBV_SEND_FETCH
(t206)DBV_SEND_END_MSG
(T222)DBV_RCV_FETCH_END (Bu4)51 (Bu4)1 (M51) After fetch(1)
Info on RDS:Converting... 2 1 b50ocfby tt 1

I noticed in another thread that you copied BSE/lib from one server to another. This would have moved the fd* file - are the paths in all of the files correct? Two - when you log into this new company are you getting the correct $BSE path? Just another thought I had.

Hi Mark,

Yes, the path in all fd.* files are correct, and it should be correct becasue the directory structure on the actual server and copy server is same.

Yes, on log on to the new server/company, getting the correct BSE Path.

I dont know if it the issue, becasue I can work on the new environment, can update and compile scripts etc, but not able to convert RDD and printing any report.

Thanks
MRF

Another thought - have you tried rebuild dd in ttaad1121m000? Just a stab - I would recommend contacting Baan. You might also want to check ttaad1120m000. Just glancing through the menus. Last thought have your tried starting and stopping Baan on this server. Wondering if something could be hung up in shared memory.

Hi there,

don't feel offended if you already considered/checked this ... but when you copied the $BSE directories ... you did it as Administrator? Did you change the permissions of these dirs afterwards? (even M$ has something like this :-)

Although I would expect a clear error message and immediate abort in case of access problems, but one never knows ...

Good luck to you and let us know what the prob finally was.

regards

Norbert

Hi friends,

mark_h: I tried to rebuild dd in ttaad1121m000, it ends with a message that there is no change in package combination. Yes, I have restarted the Baan service several time, there is no problem with it but I am not able to start the shared memory manager. It always give error as

"Link to shared memory failed: error errno 22 shm_errno 0"

In system's application log, the following information is logged:

Event Type: Error
Event Source: Baan
Event Category: Shmserv
Event ID: 1000
Date: 15.06.2005
Time: 08:56:05
User: NT AUTHORITY\SYSTEM
Computer: SERVER
Description:
Env SERVER-Baan (e:\Baan)
Prog shmserv file \general\lib\al_1\AL_FPATH.C # 243
Keyword sopen
Username baan type S language 2
Process 0x3e4
ProcessSet SYSTEM@SERVER:996
Lasterror 3 (The system cannot find the path specified.)
Errno 2 (No such file or directory)
bdberrno 0
Message
No definition in definition file for sopen({package=b50ocfby}F_BRDD:dtczzb002, dtczzb002)

The same error message for few other tables. I checked these table in the specified package "b50ocfby" in session table definition but these tables are not existed in the specified package.


norwim: Yes you are right, I copied all directories as baan user (having administrator rights on machine) and after that updated the directory rights as full control to every one. Yes, I dont think so that it is the problem of access rights becasue the file is created in the TMP directory but it remains always empty.

Any thing other that we can check?

Thanks
MRF

just another guess:

if you have the directory structures 1:1 on the 2 servers ... do you get this warning
--quote
Message
No definition in definition file for sopen({package=b50ocfby}F_BRDD:dtczzb002, dtczzb002)
--endofquote
on the (source-)system too?
You should, shouldn't you? But this is just a warning, shared memory should work though.
I assume that you can start the shared memory service on the other system.

On the new system: Does a file called srdd_tab6.2 exist in $BSE/lib? If so, can you start the shmmanager if you rename it?

I found something about ERRNO 22, but this has to do with kernel values on unix machines .... I have no idea what might have to be adjusted on a M$ server, sorry.

Do you know filemon? Small shareware proggy that shows file accesses .... always worth a try.

good luck

Norbert

Hi friends,

norwim: The interesting thing is that the directoy structure is 1:1 on both server but not getting any warning message on the source server. Yes, share memory service is started on the other server but not able to connect to share memory manager.

File srdd_tab6.2 exist in $BSE/lib is existed and after renaming this file, still not able to start the share memory manager, getting error message as follows:

Error in reading '${BSE}/lib/srdd_tab6.2;${BSE_REM}!${BSE}/lib/srdd_tab6.2': Error 2

I dont have any idea abt the proggy "filemon", let me check on net.

Thanks
MRF

Hi,

Are you by any chance logged using Terminal Server when you try to start the shared memory manager? That doesn't work. It will probably work if you log on through VNC, or directly on the server's console....

Nick

HI friends,

nick66: You are right, as soon as I logon on to the server through the VNC, the Share memory manager is started. Thanks a lot.

Now we can come to the actual issue, the conver runtime DD is not work and I am not able to print any report. I tried this also by connecting over the VNC but it still not working.

One interestig point that comes in my mind after "nick66" information, the actual server is running on windows NT while the new server is running on Windows 2000 and "Terminal Services" are also running on the new machine. The SQL server version is same on both machines. The installation of Baan on both servers is done by the same software CDs. I dont know if this difference is causing problem?

Thanks
MRF

Hello friends,

This problem is still not resolved, I am waiting for further suggestions.

Thanks in advance
MRF

http://www.baanboard.com/twiki/bin/view/Main/WebSearch?search=dbslog&web=on&scope=text

I found multiple results when searching for forums and Wiki for DBSLOG
have a look and see if you can figure out how to set it.

If it's a database problem, that will tell you. But personally still I think that it's a problem with permissions (or something) in your temp directory. (even though the file gets created) Windows is strange that way sometimes.

Dave

Hi,
i Know its too late reply but till u not satisfied with soution plz try the following.. Hope u already might be tried this.

1. patch the objects after error solving.
2. drop and rebuid shared memory.[shm parameter]
3. Run configure application once.
4. Logoff and login and then try crdd for tools..

Hope it definately works..

Amolpk