Hi,

We have two servers, on booth server we have Baan one production server and one test server.

After a Oracle crash we had to export and import all databases to make sure everything works.
We did this some weeks ago and tested first a production export to import on the test server (all seems to work).

Now I want to change some Baan reports on the test server and we get a lot of errors. As I see the software architecture of the test server is not the same as the production server, so the VRC are not the same. As we tested the production export on the test server the database things to have the same software architecture as the production server.

How to get the software VRC structure the same as the database VRC structure on the test server?

Thanks!

Dear hagenh,

as i understand you right:

You restored only the oracle db back to the server.

What about the filesystem under $BSE/ ???

To run Softwarecomponent you need both the database AND the filesystem (especially $BSE/application)

$BSE/dict can be created with the data stored in the database.

One solution would be a BaaN internal export / import of the DD which creates data in the database AND the filesystem for the softwarecomponents and others.

Regards,

Kozure

Dear Henk-peter,

If I understand you correctly you restored an oracle backup from production on your test server. It will help if you tell us what kind of errors you are getting but if I understand what happened correctly you are most likely getting 512 errors and maybe some 513 as well.
What you need is your dd<pack combo> directory from production on your test box.
Got to test (use bsp) and find your dd<pcomb> directory. You'll find it in $BSE/../dict (%BSE%\dict for windows). Once you've found it back it up (I would move it to dd<pcomb>.save or something inside the same directory). Now get the dd<pcomb> from production and copy it to test to the same location ($BSE/../dict). That alone should get rid of all the 512 and 513 (Run a wide open check tables to confirm this). However your application will be out of synch with your tables and domsins RTDD. To fix this log on to Baan and run Create RTDD for all domains and all tables with reconfiguration:Yes for the pack combination with problems. Make sure you do this with no users on the system and be prepare for long reconfigurations in case large tables are hit.

Kind regards,

Eduardo

Hi,

This is the error I get when I want to edit a report layout (ttadv3131s000) at the test server:

2007-01-08[11:31:59]:E:root: ******* S T A R T of Error message *******
2007-01-08[11:31:59]:E:root: Log message called from /port.6.1c.06.02/vobs/tt/lib/al_1/al_gtenv.c: #198 keyword: try_bse_tmp
2007-01-08[11:31:59]:E:root: Pid 6824 Uid 343 Euid 343 Gid 125 Egid 125
2007-01-08[11:31:59]:E:root: user_type S language 2 user_name root tty locale ISO88591/NULL
2007-01-08[11:31:59]:E:root: Errno 2 (No such file or directory) bdb_errno 0
2007-01-08[11:31:59]:E:root: Log_mesg: /lvtmp1//usr2/bse/tmp: not accessable; defaulting to $BSE/tmp
2007-01-08[11:31:59]:E:root: ******* E N D of Error message *******

2007-01-08[11:41:36]:E:root: ******* S T A R T of Error message *******
2007-01-08[11:41:36]:E:root: Log message called from /port.6.1c.06.02/vobs/tt/lib/al_1/al_gtenv.c: #198 keyword: try_bse_tmp
2007-01-08[11:41:36]:E:root: Pid 18782 Uid 343 Euid 343 Gid 125 Egid 125
2007-01-08[11:41:36]:E:root: user_type S language 2 user_name root tty locale ISO88591/NULL
2007-01-08[11:41:36]:E:root: Errno 2 (No such file or directory) bdb_errno 0
2007-01-08[11:41:36]:E:root: Log_mesg: /lvtmp1//usr2/bse/tmp: not accessable; defaulting to $BSE/tmp
2007-01-08[11:41:36]:E:root: ******* E N D of Error message *******

It looks like you are going to have to troubleshoot this one a little bit. Your BSE_TMP variable seems to be wrong which according to the messages in the log it should not be causing a fatal error since it is defaulting to $BSE/tmp. But again maybe that setup is erroring out as well (permissions problems?). However I'd start trying to fix that first. You'll need to find where the BSE_TMP variable is being setup. Places to look for it: The bwc file on your pc, a bshell wrapper script (if you have one), tabledef6.1 file... those are the places I can think of right now.
The error on the screenshot many times happens due to problems in the code. In this case since it is tools and it worked fine before and also because of the other errors in the log I am leaning towards issues on the configuration that might be triggering the "out of dims" error.
One more thing. It is not a good idea to use user root to work with baan. Files permissions might end up screwed up leaving sessions and maybe even the whole system inaccessible for regular users.

Hi,

The attachments shows what the database give (ttadv1414m000) and what unix has as directories.

Dear Henk-peter,
Look at the errors you sent before. Specially this line:

Log_mesg: /lvtmp1//usr2/bse/tmp: not accessable; defaulting to $BSE/tmp

Path "/lvtmp1//usr2/bse/tmp" does not look right to me. The setup of variable BSE_TMP is messed up somewhere. Try fixing that first.

As I said you are going to need to spend some time reviewing your environment (configuration files and stuff) to fix this one.

I see nothing wrong on the last screenshots you sent. All the directories for the VRCs on your derivation structure are out there. I assume dir usr2 is hanging from root dir "/", correct? Where is "/lvtmp1/" coming from? Do you have it on your production environment?

Hi,

This is the error I get when I want to edit a report layout (ttadv3131s000) at the test server:

2007-01-08[11:31:59]:E:root: ******* S T A R T of Error message *******
2007-01-08[11:31:59]:E:root: Log message called from /port.6.1c.06.02/vobs/tt/lib/al_1/al_gtenv.c: #198 keyword: try_bse_tmp
2007-01-08[11:31:59]:E:root: Pid 6824 Uid 343 Euid 343 Gid 125 Egid 125
2007-01-08[11:31:59]:E:root: user_type S language 2 user_name root tty locale ISO88591/NULL
2007-01-08[11:31:59]:E:root: Errno 2 (No such file or directory) bdb_errno 0
2007-01-08[11:31:59]:E:root: Log_mesg: /lvtmp1//usr2/bse/tmp: not accessable; defaulting to $BSE/tmp
2007-01-08[11:31:59]:E:root: ******* E N D of Error message *******

2007-01-08[11:41:36]:E:root: ******* S T A R T of Error message *******
2007-01-08[11:41:36]:E:root: Log message called from /port.6.1c.06.02/vobs/tt/lib/al_1/al_gtenv.c: #198 keyword: try_bse_tmp
2007-01-08[11:41:36]:E:root: Pid 18782 Uid 343 Euid 343 Gid 125 Egid 125
2007-01-08[11:41:36]:E:root: user_type S language 2 user_name root tty locale ISO88591/NULL
2007-01-08[11:41:36]:E:root: Errno 2 (No such file or directory) bdb_errno 0
2007-01-08[11:41:36]:E:root: Log_mesg: /lvtmp1//usr2/bse/tmp: not accessable; defaulting to $BSE/tmp
2007-01-08[11:41:36]:E:root: ******* E N D of Error message *******