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
- MaxDB DBMS Install
- MaxDB Studio Install
- MaxDB Database Creation
- MaxDB Post Installation
- BOBJ4 Install
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
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
The license stuff
Nothing to do next
I kept the defaults
I kept the defaults
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.
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
I kept defaults
A look at what new Windows Services we now have, presents an extra MAXDB entry.
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
I supplied the Database Name “BOBJ4”. You will need to remember this for the BOBJ4 installation.
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 !
I Kept all defaults
I kept defaults
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
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.
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
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
From the selection of Database Types, I chose “MaxDB”
I didn’t care much for installing the Audit Database
I supplied the SIA “Node Name”
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
“Finish” and Re-boot the System
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
I waited a couple of minutes for the “MAXDB: BOBJ4” to complete
4. Start the SIA
In the CCM, I started the SIA Server
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
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”
Finally, log on to the Central Management Console (CMC)
Again, a little waiting game for Tomcat to initially get going, and finally