Can some body help me to explain about BaaN installation.

First, i am a new bie in BaaN Tools and i still learn in developing BaaN for the first time..In my company it has used for BaaN (the person who developing it had resigned)..

And i want to make simulation server for BaaN, i have already install for Windows 2000 Server Advanced for the OS and using MS.SQL 2000 SP3 and i had followed the documentation in BaaN installation.

And i will start to install for BaaN itself, but i confused with the SP/VRC. Should i do installation from SP1 to SPXX??With the information in the CD??
And when i do installation/setting for the VRC??
After that all, i set for the business process or in the beginning??


Thanx..

Hi Danny,
1) Install Baan4 from the Master CD followed by the post-installation tasks mentioned in the installation documents.
2) If you have the latest Baan4 Master CD then it would take care of installing the latest porting set. If not then install it separately from the same CD (usually provided).
3) Then setup the PMC & Update VRCs.
4) Go for the SPs after that. If you are going for service packs beyond 18 then i would recommend using either the 1-18 or 1-21 (whichever is available from Infor) SP batch installation utility. The documentation would be available when you download this batch utility files.
5) This can be followed by your customized VRCs or implementing your business processes.

Hope i haven't missed out on anything..

sk

Hi Danny,

from your post I conclude that you seek a test environment to play around in and test things. Shouldn't this system be exactly like your productive one?
If you do a clean install and apply all service packs you will lack every single individual solution/development that has been applied by your predecessor.
As you are on a windows system, have you thought of cloning the whole server using VM?
Just an idea.

good luck

Norbert

Thanx to all for ur kindness to help me :D

To Sukesh75 :
Yup, i have all the master cd + the documentation and i will try it as soon as possible..

What is PMC? (i'm sorry but i never hear this word mean :p)
And about VRC, in my place i have two VRC (standard and VRC private in my place).

To norwim :
Yup, but if something happen in our system in future i can handle it from zero :D

And can you help me to get backup data from 2007-2008 in my BaaN live and restore it in BaaN simulation i create later??How can i do that?

Thanx before

Hi Danny,
PMC stands for Product Maintenance & Control. The PMC sessions are the ones you would be using to apply new solutions or service packs in Baan. Earlier, the service packs or solutions were applied using session Import Patch {ttiex1284m000} but post SP3 (i guess), this was replaced with the PMC Sessions.
Therefore, its important to initialize the PMC in baan prior to applying the SP batch utility program. Go through your documentation and i am sure you would find info on PMC.

As far as your VRC is concerned, the bare minimum you need while updating your Baan SP would be the Standard VRC (present by default) and your Update VRC. All the rest of the customized VRC (i hope this is what you mean by Private VRC) can wait till after the SP (doesn't make a diff actually).

sk

To Sukesh : Thanx you for ur information. I will try it.

I have tried to install BaaN from the master cd.But when in step choosing kind of the database why MS SQL Server 2000 it was not show??

The database in the steps of installation were :
1. Microsoft SQL Server 7.0
2. Informix 7.3
3. Oracle 7.3/8.0.4
4. IDM DB2 UDB version 5

Did i use wrong source CD or i must doing something setting from the PC??

And it failed in the next step..

I need ur help guys please help me..

Thanx

You got the right CD. Select Microsoft SQL Server 7.0 and it will work. What did you select and what was the error message when it failed?

sk

Yeah i tried to select that option and after that i choose for instalation User interface, User interface and logic, and Full..
And i choosen full after that enter password for baan and then making group name for baandb and the problem after this..

The error said that rebuild your database because it was not binary..But i have followed the instruction when i installed for MS SQL Server 2000 by choosing binary in the steps.

And i tried to rebuild the database by binary as instruction in help SQL Server but it failed even i stop all the services in SQL.

So, i uninstall SQL and install again the SQL with the same instruction and it still same..

Do you know what problem in my SQL Server 2000 SP3..Because i choosen for the binary in the steps..

Thanx for ur kindness

Hi Danny,
How old is your Baan4 Master CD? Any idea when you got it?
Secondly, could you just outline the steps you have taken for installing SQL Server 2000?

sk

How old is your Baan4 Master CD? Any idea when you got it? -->
Maybe 2000/2001.

This is the step i install my SQL Server 2000 :
1. Type of instalation client and tools
2. Checklist for default
3. Setup type custom
4. Use the same account for each services + use the local system account
5. Authentication Mode : Mixed mode+ blank password
6. Collation setting : Latin1_General + Sort Order Binary
7. Network libraries : Names Pipe (\\.\pipe\sql\query)+ TCP/IP Socket(1433) without proxy + MultiProtocol checklist without enabling Multiprotocol encryption
8. Choosing license for seat : I choose 100
9. Finish..
10. I execute this query in SQL
execute sp_configure “show advanced options”, 1
reconfigure with override
execute sp_configure “max degree of parallelism”, 1
execute sp_configure "priority boost", 0
execute sp_configure “lightweight pooling”, 1
execute sp_configure "max worker threads", 255
execute sp_configure “open objects”, 0
to maximize performance according to the documentation :p

Shoult it caused because i used SQL Server SP3 not SP1 because the documentation from Infor using SP1??

And yesterday when i tried to rebuild database using SQL server it didn't work at all..And make the SQL couldn't start any more..

PLs give me advice..

Thanx you in advance

1. Type of instalation client and toolsBy the above statement, do you mean you selected "Server and Client Tools" or "Client Tools Only" ?

sk

By the above statement, do you mean you selected "Server and Client Tools" or "Client Tools Only" ?

sk

I select for "Server and Client Tools"..

And when i install for BaaN after i choosed type of my database (i choose Microsoft SQL v 7.0) and the next step write down for baan password (according to the documentation it missed for choosing Enter locale settings "ISO_BIN (binary sort)"..

I attach my documentation from infor

So you missed out on selecting the locale (ISO-8859-1) is it?

sk

So you missed out on selecting the locale (ISO-8859-1) is it?

sk

Yes, you are right..Not skipping..But from the step in my instalation after choosed for Database (i choose MS SQL 7.0)..It didn't show this step and directly go to fill password baan..

Can u help me to explain about this?or i must download for new master cd baaN???


Thx

I find that strange. Usually after you select the type of baan installation you want, it goes to this screen. My Baan master CD is as old as yours but never skipped this screen in all the installations that i have done. Its beyond me as to why it wouldnt come in your scenario. Maybe you want to try it again by creating a new instance of SQL and installing Baan on that instance or if time permits, wipe the slate clean and start from the beginning.

sk

Yesh..Should i change install from my sql cd??

But i will try with find another SQL Server 2000(my SQL using SP3)..Thanx you your advice..And i will find to solve this problem

-regards

You can definitely try installing from a different SQL Cd but Baan works well with both SQL Server 2000 Sp3 & Sp4.

sk

Maybe i will try to format again my simulation PC :p..Get headache because it..

And try to find another source SQL Server in my office..By the way can use SQL Server SP3 after that upgrade to SP4 and then install for the BaaN??

Or must SP3 and then install BaaN and finally i upgrade the SP4?

But from the documentation i attach in, is the way right?

thx sk..

In all my installations, i have applied SP4 after installing Baan. It worked for me and so i never tried tinkering with that setup as its become a sort of habit.

sk

It stil didn't work. Even i already doing from the beggining instalation from Windows Server 2000. Maybe i will take a new cd from infor..If u have information about this, can you give me information..

And thanx you so much with ur help..

If you have a support contract with Infor, then you could request them for a new Master CD. This could be done from the Infor site (http://www.infor365.com) or by calling their support lines.

It wouldn't be a bad idea to log in a support case with them on this issue (installation problem).

sk

Dear sukesh,

the latest information i get from infor was
"
Baan IV c4 Backoffice (with ss7.0 support)



This means you need to pre-install Microsoft SQL Server Version 7 and NOT SQL Server 2000 before you install this copy of Baan IV. That is the cause of you getting the binary sort error.
"

So it means, i use wrong master cd/i should install SQL V7.0 before?

Can u explain to me?Because they always told me to rebuild database, but i did it for serveral times and i checked it that it is right i use Latin1_General and sort Binary..

Please give ur advice thanx

Hi,
Its been a while since we moved from SQL 7.0 and so the recollection of the steps (exactly what and how we did it) are a bit sketchy. However, i am attaching a document which will help you in upgrading a sql7 installation to sql2k.

Its best that you request Infor to send you a Master CD for the combination of Win2k3/SQL2k so that you wouldnt have to take this tricky installation route.

sk

Yup i think i don't do that because i am not upgrade but create a new one BaaN :-D

And i will ask u anymore if i get a new problem :p

Thanx ur help

I have sucees to install BaaN :D..

And what step i must do??After i have install BaaN server? *because i have checked the database was empty*

Should i install update CD and SP 1-18??

And then if I want to use my company database using '< 2008' data from real server..
How i can do that?

But if i want build a new one..How i can do that??


PLease give me instruction because i don;t know :p.Or you have a documentation to do the next steps :D

thanx

Hi,
What do you mean by "Database was empty"? During the final stages of Baan installation, it creates & populates certain tables for Baan to start. So your Baan Database could not be empty, if the installation was successful.

sk

Yup..I just finished install BaaN from Master CD..Should i install the update and sp batch install from SP1-SP18 ???

And then install demo??

Please give me instruction thanx a lot sk :D

Hi Danny,
Once after you installed the demo companies and prior to installing the patches you might want to setup the Shared Memory .
1) Run session Maintain Shared Memory Data {ttaad4150m000}
2) Click on Group Insert and select "Program Object" as Shared Memory Data Type.
3) Click on Special Menu & select Copy Objects From DD
4) Supply the following information in the next session
package: tt
version: (std VRC)
Program from: dll to dllzzzzzzz
Repeat for dsk to dskzzzzzz
& stp to stpzzzzzz
Once this is done, select Convert to Runtime from the Special Menu & Restart.

sk

Hello Friends,

I have done sucessfully installation of Baan IVc4 on SQL 2005. but when i am starting connection of BW its giving me bdb_error 1017.

Any body can help me to figure out the problem

regards
Shiv

Dear sk,

I'm sorry because so busy for this month with my jobs.

Yeah i had tried it again when i installed it, the database is still empty (qithout the table for company 000) and the error message was 'canot lock the database' when installation..And i checked for the database is already in that folder with size 2Gb for *.mdf and 2Mb for the *.ldf.

And then i tried to import like the documentation in appendix B when the database import was crash/failed. With using bdbpost..But it same no result too..

"%BSE%\bin\bdbpost -k -f -m -n -I D:\Prefiles\comp000.pre -C000"

Can you help me to describe it??

And i want ask you about sollution '149550' where i can get the documentation to that sollution?I had asked for infor but until now no response >.<..

Pls your advice

BR,

danny

Danny,
Does the user with which you have logged on to the server has enough security privileges for creating databases and db objects? If "baan" has been given as the default admin user at the setup, does this username exist on the server as an OS user and is part of the administrator group?

sk

I had default that baan is a group of administrator. And i log as 'baan' when i install it.

And what you mean with OS User?It means like usual user?

Pls your advice.Because the database already exists without table. Can we do it manually?

Thx

Somebody can help me or comment or share ur experience to do it?

Pls advice..

Thx