Monday, August 24, 2009

Upgrade and migrate ContentServer with MAXDB

I have tried to figure out how to solve this issue, but I find it hard.
The problem is that we do not have any dev- or qa-system to practice on.

I had to migrate the system anyway because of the hardware. I moved it to a vmware-client to by me some time . It's easier to do a roll back on vmware.
Now I want to migrate it to a new server (not vmware).

Source System:
SAPDB 7.3.0.35 - 32bit windows
Target System:
MAXDB 7.7 - 64bit windows

Note 962019 is very important!
Here is some prerequisites with my answers:
- In your source system, you use SAPDB Kernel Version 7.3.00 Build 57 (PTS 1143300) or higher, or MaxDB Kernel Version 7.5.00 Build 40 (PTS 1143301) or 7.6.00 Build 31 or higher.
My answer: NO, I use 7.3.0.35
-If the minimum required version 7.3.00 Build 57 is not yet available on the SAP Service Marketplace, you must first upgrade the Content Server Version 7.3. to Version 7.5.00 Build 40 before you can execute a heterogeneous system copy.
My answer: 7.3.00 Build 57 is NOT available and have never been. The same for version 7.5.00 Build 40.

So what can I do?
In point 4 (note 962019) it says:
- In your source system, you use SAPDB Kernel Version 7.3.00 Build 57 (PTS 1143300) or higher, or MaxDB Kernel Version 7.5.00 Build 40 (PTS 1143301) or 7.6.00 Build 31 or higher.

The conclusion is that I have to upgrade my source system to 7.6.00 Build 31 or higher....

Now I'm going to make som pancakes for my family. Continue in a few days!

Tuesday, August 18, 2009

SQL error in the database when accessing a table

I received this message when I tried to logon to my ECC 6.0 system (IDES):
"SQL error in the database when accessing a table"

It's a mssql 2005 database and windows 2003 server.
Usually you have to focus on the table causes the problem, but in this scenario the db-disk was full.
Increase the db-disk or move db-files to an empty partition.
Do you need help with moving db-files please let me know.

PS! Did you know that SAP loves Formula 1?
This picture is from
http://www.flickr.com/photos/mosokul/194054577/
and shows a McLaren formula 1 car.