dear all,


I want to build a test server exacly the same with my live server.
I have tries this way

I install the baan from master cd
I copy the baan folder from live server and put that on my test server.
and run bdbpost command.

I have problem with the bdbpost. I can't use the command
I want to import the 000 company dump to my test server.

please advice on building my test server.
right now I using baanIV c4 and SQL 2000


please advice

regards,
-wei

Hi wei

I am having a procedure received from one of my colleagues but I have never used this procedure.

You can follow the following steps

Step 1: Install the Baan on the Test server using the master CD.

Step 2: Take the sequential dump of the sessions

ttiex3100m000,
ttiex3101m000, and
ttiex3102m000, from the live server
you can take the sequential dump using the the session ttaad42226m000.

Step 3: Import the sequential dump of the sessions which you had taken from liveserver onto the testserver, to import the sequential dump you can use ttaad42227m000.

Step 4: Edit the file in test server under $BSE/lib/license (in unix) or $BSE/lib/license6.1 (in windows), here include the liveserver name followed by a (,) commo and then followed by your test server name.

Step 5: Configure the application by running the session ttiex3225m000.

Step 6: Install all the service packs on the test server as many as you have on the live server.

Best luck

Hi,
I hope you had changed tabledef6.1 on your new to point your new database on new server.

What is the error you are getting with bdbpost on new server?
Follow below procedure:
1. Open command prompt
2. Change directory to %BSE%/bin --> fillenv
3. set USER=baan
4. run bdbpost command.

Let me know the error?
Thank you
Srini

You can also move the database using sp_detach and sp_attach command or full backup and restore on new server.

After the above procedure, you need to correct the orphan database users. You need to link them back corresponding SQL Logins.
Srini

dear all,


Thank you for your respond.
right now I'm a lil bit confused
due to many version to make a identical test server from live server.

I have a different version.
1. install from master cd
2. copy dict, tools and application from live to test
3. import the 000 dump using ttaad4227m000
4. import the other company dump using ttaad4227m000

I already done this. but I recieve error that said
"package combination of company is 40Ccd481 ; package VRCs in package combination are different" when I want to change company from 000 to my company.

do anyone have experience on this one
help please........


regards,
-wei

Hi there,

in $BSE the lib directory is very important.
Here you find files beginning with fd6.1.
These files contain the package VRC informations.
According to what you wrote, you didn't copy the $BSE/lib directory.
Also the $BSE/lib/user directory contains the informations which user uses which company and which package combination ..

I would try to copy $BSE/lib directory too, although, as you have imorted the company 000, a convert to runtime data dictionary should recreate these files. Don't forget to convert the users to runtime, this will recreate the files in $BSE/lib/user

good luck

Norbert

hallo norwim,


I have try your suggestion,
and right now I change company and get in to my company.

but when I try to run session.
there is an error that said:
error : read row error 506 on tipcf000888 (error 0)
fatal error : table 506 ( table does not exist ) on select
fatal error : can not continue in tdsls4110m000 (mess)

I have try to import table tipcf000888 at db level from my live server.
but still it doesn't work.

help please....

regards,
-wei

dear all,


I've been thinking about this case.
is it possibe if I build my test server from backup of my live one.
we do backup our live server using tape.

could I just restore the backup to my test server.
is it possibe. we've backup baan folder from live server.
the problem is we have to use diff host name.
anybody has experience on this on


thanks

Yes, this can be done (we are using this method in Baan 5c), however there a quite a few steps involved, mostly resetting ownership / authorizations etc on the test server

Hi,

I have test server identical like production server. Instalation of test server is simple:

Install base instalation of Baan on test server .

Stop all baan services.

Then rename Baan dir on test sever and on tests server copy whole baan dir from production sever.

Make backup baandb database from production sever and then restore that backup on test sever.

Delete and recreate baan users on baan test.

Start all baan services.

On this way you will have identical instalation of baan on test sever

hallo eibrahimovic,


do I have to change the data base mapping on the test server.
because in live server we put the DB on drive E
and in the test server we put the DB at drive C

do you used a different host name ?
if I wanto used a different host name what should I do?


thanks

Hello

We use different hostname, and we have same disk mapping like on prodution sever. BSE dir is on c:\, and database is on D:\.
Data comes from test sever because in client we specify with ip address our test server. Licences comes from production sever.

Hi eibrahimovic,

I'm already did what was wrote here.

My question is:
1. Can i make my testing server not take the license from live server?
Cause now when i'm log in to my new test server. the license in live server was took.

I tried to change the filelicence6.2 in lib folder, i change it from the name of my live server into the name of my test server.
and when i click baan, it gave me message "You have no license anymore to start the bshell"

Please advice.

Hi,
You can do below.
1. Change the %BSE/lib/licence6.x file to your development server.
2. On your developmen server, open BW configuration --> put session --> ttiex3228m000 in the command field.
When you run this session, it will give demo licence for 7 days. You need to re-validate the server with in 7 days.
3. Login to Baan -> When you login, the session 'patch objects after system crash' ttiex3228m000 will start.

This is work around.
Hope this helps.

Wei,

Have you or anybody succeeded in setting up a exact copy of your production server to test server. If so can you please give me directions on how to go about it ? I need to do the same next week and look forward to your views ?

Are there any SSA documents that specify how to setup and migrate environment to test server