Install BOBJ4 on SAP MaxDB

Here I install the BOBJ4 on a SAP Max DB database, and not the packaged MS SQL.

I will download the database software, install it, create a database, then begin the BOBJ4 installation.

Here’s a summary of what’s coming

• System
• Download
• MaxDB DBMS Install
• MaxDB Studio Install
• MaxDB Database Creation
• MaxDB Post Installation
• BOBJ4 Install
• Test

System

I have a very basic system for demonstration. Here are the VM details.

 

Loopback adaptor, as there is no DHCP server present.

 

 

About 10GB already used

 

Current existing directories

 

In “Program Files”

 

In “Program Files (x86)”

All current services

 

In Control Panel->Programs and Features

Note: Java VM 64bit is required, for MaxDB Studio

 

Windows Start->Programs

 

Download

This time, I found it from SDN, Downloads, half way down SAP MaxDB software of version 7.8. This link is likely to expire. But you should be able to perform a search on “MAXDB 7.8”, in Installations and Upgrades on the SMP.

There are two files to download, the actual DBMS, and the DBMS Management tool (Studio).

 

Files and sizes

 

MaxDB DBMS Install

Note, you will need the 64bit JVM already installed, see System, above.

I began by running the downloaded “exe”, to commence setup

It begins

 

 

The license stuff

 

“Accept”

Nothing to do next

 

“Next”

I kept the defaults 

 

“Next”

I kept the defaults

 

“Next”

I chose NOT to create a database, as I would do this manually, after installation. But I guess it could be done here.

I kept the other defaults.

Note the “Network Port Number”. This is a parameter we will be using for the BOBJ4 install, later.

 

“Next” 

 

“Next” 

 

and … 

Done. 

In Start->Programs 

 

And now to view what Windows Services aquired

2 extra ones here

 

and 2 extra ones here

 

MaxDB Studio Install

Now to install Studio, the DBMS GUI Manager, from the downloaded “exe” to commence installation

 

 

 

License stuff

 

“Accept” 

I kept defaults

 

“Next”

 

“Next”

 

and finished

 Done.

A look at what new Windows Services we now have, presents an extra MAXDB entry.

 

Windows Programs

 

MaxDB Database Creation

For the BOBJ4 installation, we need to create a database. This can be performed during the database installation, however, I chose to create it manually here, for demonstration purposes.

I began by running the “Database Studio”. For the first time, a “User management” screen appears.

 

Shortly after, I was presented with a blank Studio canvas

 

Now to create the database

 

I created the database by, right-clicking on the “Servers”, then to Administrator Tasks->Create Database…

I kept the default

 

“Next”

I supplied the Database Name “BOBJ4”. You will need to remember this for the BOBJ4 installation.

 

“Next”

Important: I kept the default User Name “DBADMIN”, and gave it a password. In my case “abcd1234”. I am showing you this now, as it will need to be supplied during the BOBJ4 installation, ONLY IN CAPITALS !

 

“Next”

I Kept all defaults

 

“Next”

I kept defaults

 

“Next”

I chose to put the logging mode to “Overwrite”. Without this, the BOBJ4 installation will fill it up the log, and not complete, until you return to the log and either extend, delete or use overwrite

 

 “Next”

 

 “Start”

 

“Close”

Done

Now in Studio, we can see our BOBJ4 database

 

Another look at the Windows Services reveals an extra three “MAXDB” entries

 

 and an extra “XServer” entry

 

 

MaxDB Post Installation

I started the BOBJ4’s specific database Service found on port 7200, so that the BOBJ4 installation can see it.

 

I changed the System Environment Variable, “PATH”, to include the following path.

C:Program FilessdbMaxDBpgm

 

I’m not a MaxDB person in the slightest, so any other deeper information, will have to be sought elsewhere, but here’s a good start http://maxdb.sap.com/doc/7_8/default.htm

 

BOBJ4 Install

Now on to the actual BOBJ4 installation. I zip through the standard installation screens, and pay more attention to the separate database selection screens.

 

 

 

 

 

 

 

 

 

Now to deselect the “Integrated Database” option, so I will be prompted for my specific database 

 

 “Next”

 

 From the selection of Database Types, I chose “MaxDB”

 

“Next”

I didn’t care much for installing the Audit Database

 

 “Next”

I supplied the SIA “Node Name”

 

 “Next”

 

 

Now to supply the Database parameters

CMS Database Name: “BOBJ4”. Set during the creation of the database. Parameter name “Database Name”, see section “MaxDB Database Creation”.

MaxDB Server: “localhost”. Self explanatory.

MaxDB Port: “7200”. Set during the installation of the DBMS. Parameter name “Network Port Number”, see section “MaxDB DBMS Install”.

Username: “DBADMIN” (must be supplied in capitals, regardless of what you actually used during the database creation). Set during the creation of the database. Parameter name “User Name”, see section “MaxDB Database Creation”.

Password: “ABCD1234” (must be supplied in capitals, regardless of what you actually used during the database creation). Set during the creation of the database. Parameter name “Password”, see section “MaxDB Database Creation”.

 

 

 

 

 

 

 

 

Nearly a couple of hours past

 

“Next”

 

“Finish” and Re-boot the System

Test

After much trial and error, I eventually managed to successfully test my installation. Here are the steps I followed

1. Stop SIA

In the Central Configuration Manager (CCM), I stopped the SIA Server.

 

2. Start MaxDB BOBJ4

In Windows->Services, I started the MaxDB BOBJ4 Service – “MAXDB: BOBJ4”

 

FYI, there are four other MaxDB Services, that start automatically

• MAXDB: .UMDB
• XServer
• XServer-7200
• XServer-7299

 

3. Wait

I waited a couple of minutes for the “MAXDB: BOBJ4” to complete

 

4. Start the SIA

In the CCM, I started the SIA Server

 

5. Wait

This one is important. I had to wait a good ten to twenty minutes for the SIA to complete it’s important Services.

This is where I was going wrong. I tried too soon, and was receiving the following message

 

 

 

So …

Q: How long to you wait for ?

A: When you can successfully log into the SIA Manage Servers (see next)

 

In CCM, select the “Manage Servers” icon for the SIA

 

Supply your User Name & Password

 

Wait until you can see all the SIA Servers “Enabled”, & “Running”

 

Good

Finally, log on to the Central Management Console (CMC)

 

Again, a little waiting game for Tomcat to initially get going, and finally

 

 

Done