Migration from MaxDB 7.7.06 to 7.9.10.05 crashes. Please advice

[thomas_huebner2]

Hello,

we asked this question a while ago but haven't got any help so this is another try.

We're trying to upgrade the existing MaxDB installation using the "upgrade"-option in the installer. Everyone works smooth till the installer tries to bring the instance to ONLINE.

There the installation crashes.

I attached the SDBSETUPmsg file and a screenshot.

Would highly appreciate some help as this is a big blocker for us.maxdb-1.pngsdbsetupmsg1646311581log.txt

Thank you very much for your help,
Christoph

[sveabecker]

Welcome and Thank you for visiting SAP Community to get answers to your questions. I would like to recommend our Q&A tutorial https://developers.sap.com/tutorials/community-qa.html

Please always remember, the more details you provide, the more likely it is that members will be able to assist you.

Finally, if you're hoping to connect with readers, please consider adding a picture to your profile. Here's how you do it: https://www.youtube.com/watch?v=F5JdUbyjfMA&list=PLpQebylHrdh5s3gwy-h6RtymfDpoz3vDS. By personalizing your profile with a photo of you, you encourage readers to respond.

Regards, Svea

SAP Community Global Moderator

[holger_becker]

Hi Christoph,

looks like you hit a so far unknown bug within MaxDB kernel.
The kernel crashed while trying to migrate old DB Procedures/Functions from 7.7 layout to 7.9.
Have you created DB Procedures/Functions in this database?
If this is the case you can try to drop these objects in version 7.7, do the upgrade and recreate them in 7.9.
As I'm interested to fix this problem in a future MaxDB version do you think it would be possible to get a backup of the database?

Kind regards
Holger Becker

[thomas_huebner2]

Hey Holger,

I'm not that experienced with this board. Please find my reply to your comment below as "answer".

Christoph

[thomas_huebner2]

Hi Holger,

I tried so send you my mail address but the moderator has deleted my post an wrote:

"Inclusion of your email address violates our rules of engagement (https://community.sap.com/resources/rules-of-engagement).
Please submit again but ask Holger to follow your profile, and you can follow him back, then you can take the conversation to direct messages."

Can you please try that to get in contact.

Thank you very much and sorry for the delay

Christoph

[holger_becker]

Hi,

after some offline discussions we finally nailed down the problem to a new MaxDB bug with outdated catalog objects.
The problem will be solved with one of the next MaxDB patches.
Here is the link to the ticket in our problem tracking system with the details:
https://maxdb.sap.com/webpts/?wptsdetail=yes&ErrorType=0&ErrorID=1274557

Kind regards
Holger

[thomas_huebner2]

Hello Holger,

Thanks a lot for your effort and time!

I also found a hint in a previous post from a colleague of mine who asked the same question as I did some time ago. Here a guy named Ralf Wahlen answered:

"Check that SAP Note out! Hinweis 763972 - Laden von Systemtabellen scheitert mit

dem Fehler -8022

Lösung
Bitte ändern Sie den Benutzer SUPERDBA, wie im Hinweis 754140 beschrieben
ist, und wiederholen Sie das Laden vom Systemtabellen.
Wenn das Laden von Systemtabellen innerhalb der Catalog-Migration bei dem
Upgrade gescheitert ist, setzen Sie bitte zwei folgende Kommandos
nacheinander ab:
dbmcli -d <SID> -u control,<pwd> load_systab -u superdba,<pwd> -ud
domain
dbmcli -d <SID> -u control,<pwd> load_systab -u superdba,<pwd> -m
In anderen Fällen reicht es aus, nur das erste von oben angeführten
Kommandos abzusetzen.
Wichtig: Sollte das Laden der Systemtabellen innerhalb des Software Updates
(SDBUPD) abgebrochen sein, schließen Sie den Update unbedingt durch
erneutes Ausführen des SDBUPD erfolgreich ab. Ansonsten kann der nächste
Update scheitern.

That was our error in 2012 during the upgrade of the DB. Try to solve!"

My problem is, that with a regular user account I cannot access the mentioned "note".
Would it maybe possible to just get a copy of this note. Maybe this fixes the problem already.

We are not using any DB procedures or functions in the database. In fact our structure is pretty simple. What we use are sequences but this is the fanciest we have I would say,.

Yes, it would of course also be possible to get a backup of the database.
Maybe we could get in touch via mail so I don't have to publish my database here? What do you say?

I am so thankful for any help I can get!

Christoph

[holger_becker]

Hi Christoph,

I doubt that the error -8022 and note 754140 is related to your current problem.
I can contact you directly via email if you post here your contact data.

Kind regards
Holger