Error during upgrade to MAX DB

[Former Member]

Hi all

I would like to upgrade my MAXDB 7.6 system (which I migrated from 7.4) to 7.8. During the upgrade with sdbinst (I also tried with SDBUPD) I get error messages with empty error message (I have several empty popups with title "error in database upgrade finalization") .

Now my db is in a inconsistent state. When I try to connect to the database I get the error:

DBM connect failed: Could not start DBM server.

-24562,ERR_MIGRATION: Error during migration of data

-24609,ERR_MIGRUNICODE: Migration of a ASCII database is not possible

Now I'm blocked. I even cannot delete the database.

Any idea what I did wrong?

Thanks in advance.

Regards

Marco

[Former Member]

Could solve the problem now. After migrating the catalog (see above) I had the error with sdbupd. Then I tried with the graphical interface and it worked!

[markus_doehr2]

> Now my db is in a inconsistent state. When I try to connect to the database I get the error:

> DBM connect failed: Could not start DBM server.

> -24562,ERR_MIGRATION: Error during migration of data

> -24609,ERR_MIGRUNICODE: Migration of a ASCII database is not possible

>

> Now I'm blocked. I even cannot delete the database.

You have a backup of the database?

Upgrade should always be accomplished by SDBUPD.

Markus

[Former Member]

Hello Markus

Yes of course. This is a sandbox system. I recovered the database with another SID and retried but still the same error (with sdbupd).

Regards

Marco

[markus_doehr2]

> Yes of course. This is a sandbox system. I recovered the database with another SID and retried but still the same error (with sdbupd).

Ok.

So you executed something like

sdbupd -u <dbmuser>,<dbmpassword> -d <database-ID>

and you got popups?

Markus

[Former Member]

No the popup I got from sdbsetup (with the graphical upgrade). Now I retried with your command I now I think I have to do the unicode migration first....

Finding migration strategy...

ERR: Upgrade failed

ERR: Error checking Upgrade

ERR: Finding migration strategy...

migration not allowed

from 7.6.3 Build 009-123-163-622 ASCII catalog

to 7.8.01.14

Upgrade to releases >= 7.7 with ASCII catalog not allowed. Please perform the un

icode migration of the database catalog first.

[markus_doehr2]

No the popup I got from sdbsetup (with the graphical upgrade). Now I retried with your command I now I think I have to do the unicode migration first....

>

> Finding migration strategy...

> ERR: Upgrade failed

> ERR: Error checking Upgrade

> ERR: Finding migration strategy...

> migration not allowed

> from 7.6.3 Build 009-123-163-622 ASCII catalog

> to 7.8.01.14

> Upgrade to releases >= 7.7 with ASCII catalog not allowed. Please perform the un

> icode migration of the database catalog first.

- bring the database offline

- execute

dbmcli -u <user>,<password> -d <database> db_migratecatalog

Markus

[Former Member]

Thanks for your reply.

I migrated the catalog with mcli -u <dbadmin> -d SDB db_migratecatalog.

Now I could perform the upgrade and I got the error Install registry file not found: directory .... doesn't exist.

When I retried to install now I get the error "installation path doesn't exist".

Regards

Marco

[markus_doehr2]

> Now I could perform the upgrade and I got the error Install registry file not found: directory .... doesn't exist.

And you upgraded again using sdbupd with the above given command?

What is the exact error message?

Markus

[Former Member]

I could start the upgrade with sdbupd. But the upgrade failed with the error message (shown in Dos-Box):

"Install registry file not found: directory .../install does not exist".

Any idea what could be the problem here?I am on platform Windows Server 2008.

Thanks and Regards

Marco

[markus_doehr2]

Are you running this command in an elevated administrator cmd.exe?

Markus

[Former Member]

Yes, I logged in with a Domain Administrator.

Regards

Marco

[markus_doehr2]

> Yes, I logged in with a Domain Administrator.

Windows 2008 has UAC - start the cmd.exe as elevated (http://answers.microsoft.com/en-us/windows/forum/windows_vista-windows_programs/need-help-for-this-error-cmdexe-application-failed/44055dc8-d835-45d3-84bf-52df8ccb8e9f) and try the upgrade again.

Markus

[Former Member]

Hello Markus

Thanks again for your quick response. Yes I did it with the elevated administrator from the beginning. When I retry now I get this error message:

SAP MaxDB Installation Manager - Database Upgrade 7.8.01.14

***********************************************************

ERR: Upgrade failed

ERR: installation path doesn't exist

Regards

Marco

[Former Member]

I think the problem now is that there is already a wrong upgrade installation. I think I have to delete some temporary upgrade files...

Sorry for my questions...I'm a complete MaxDB-newbie coming from Oracle-World. The documentation was a bit confusing.

Regards

Marco

[Former Member]

Hello Markus

Because I thought that it could be a problem of my many tests I formated Windows and reinstalled the complete windows. Then I installed 7.6 made the recovery from 7.3 system. Migrated the catalog and restarted the update. Unfortunately I get the same error:

SAP MaxDB Installation Manager - Database Upgrade 7.8.01.14

***********************************************************

Please enter Database Manager Operator: DBM

Please enter Database Manager Operator Password:

Please enter Installation Name [SDB]: SDB

Please enter Network Port Number [7200]: 7200

Checking upgrade...

Finding instance type...

Finding starting release...

Finding migration strategy...

Looking for running instances...

Checking paramfile modifications...

Checking data consistency for database migration...

Value of MCOD-Parameter is NO

Switching database state to OFFLINE

Preparing package "Base" ...

Preparing package "SQLDBC" ...

Preparing package "SQLDBC 77" ...

Preparing package "Fastload API" ...

Preparing package "SQLDBC 76" ...

Preparing package "SAP Utilities" ...

Preparing package "Server Utilities" ...

Preparing package "Database Kernel" ...

Preparing package "Redist Python" ...

Preparing package "Loader" ...

Preparing package "ODBC" ...

Preparing package "DB Analyzer" ...

Preparing package "Messages" ...

Preparing package "JDBC" ...

Looking for running processes of package Base

Looking for running processes of package SQLDBC 76

Looking for running processes of package Messages

Looking for running processes of package SQLDBC

Looking for running processes of package ODBC

Looking for running processes of package Redist Python

Looking for running processes of package Server Utilities

Looking for running processes of package JDBC

Looking for running processes of package Database Kernel

Looking for running processes of package SAP Utilities

Looking for running processes of package Fastload API

Looking for running processes of package SQLDBC 77

Looking for running processes of package DB Analyzer

Looking for running processes of package Loader

unregister 7.6.03.09

ERR: Upgrade failed

ERR: error upgrading

ERR: Install registry file not found: directory C:\ProgramData\sdb\data\ins

\config\install doesn't exist

Any idea?

Regards Marco