Problem during migration of sapdb 7.5 to 7.8

[rubenamestoy]

Dear,

I'm doing the migration of MaxDB 7.5 to 7.8. And so far all attempts were unsuccessful.

The upgrade of the database ends badly, and there is no way to lift it again.

The error it shows is "-24994, ERR_RTE: Runtime environment error", I changed all the permissions, I gave read and write access, and still have problems.

At first, we restore the database in 7.5, and we can logon and use the instance. But, when we have to migrate to 7.8, the first step (catalog unicode conversion, shows "ok"), then i run the upgrade script to 7.8, and it fails. The database can´t be in online mode.

The errors are:

- ERR_RTE - runtime environment error,4

- fdir migrate

Thanks!

Regards,

Leandro

[rubenamestoy]

attached log.

STDOUT: ok

MSG: packagedata of package SQLDBC 76 changed

MSG: writing 16 packages

MSG: net install registry size = 133123 bytes

MSG: wrote install registry (155687 bytes)

STDOUT: installation of MaxDB Server finished successfully We, Jan 19, 2011 at 17:06:41

x_server is not running

SYS: "e:\sapdb\programs\bin\x_server" start: 19720 INFO: XSERVER started

x_server is running

got following x_server data:

version = W64/AMD64 7.7.06 Build 010-123-204-327

dbmsrv uses db_online

dbmsrv uses db_admin

STDOUT: finding instance type...

instance type is OLTP

getting catalog encoding...

catalog encoding is UNICODE

STDOUT: starting release already known

starting release is 7.5.0.32

STDOUT: migration strategy already known

migration strategy is COMPATIBLE_LOG

STDOUT: running finalize check...

STDOUT: looking for domain user...

user profile container contains:

CONTROL

DOMAIN

SUPERDBA

found domain user in user profile container

STDOUT: current database state is OFFLINE

STDOUT: checking parameters...

STDOUT: switch database state to ADMIN

STDOUT: switch database state to ONLINE

cannot switch database mode, error during dbm command:

db_online

ERR

-24994,ERR_RTE: Runtime environment error

4,connection broken

looking for error messages in knldiag

...

2011-01-19 17:06:54 0x89C ERR 18196 DBCRASH vabort:Emergency Shutdown, FileDir_Wrapper.cpp: 1335

2011-01-19 17:06:54 0x89C WNG 16 FileDir fdir migration: error during short column entry creation; table fileNo 000000000000AA18, fileTypeSet perm concurr, root page 146525,ERR=5

2011-01-19 17:06:54 0x89C 61 RTEKerne rtedump written to file 'rtedump'

2011-01-19 17:06:54 0x89C 3 RunTime State changed from ADMIN to ABORT

2011-01-19 17:06:54 0x89C 60 RTEKerne Kernel aborts

2011-01-19 17:06:54 0x89C ERR 0 DIAG -

---

> Emergency stack backtrace <----

2011-01-19 17:06:54 0x89C ERR 0 DIAG Using 'StackWalk64' for stack tracing

2011-01-19 17:06:54 0x89C ERR 0 DIAG Using dbghlp version 4.0 rev 5

2011-01-19 17:06:54 0x89C ERR 0 DIAG Symbol search path:

2011-01-19 17:06:54 0x89C ERR 0 DIAG e:\sapdb\data\wrk\DES;e:\sapdb\des\db\pgm;e:\sapdb\des\db\symbols;e:\sapdb\des\db\sap;C:\WINDOWS

2011-01-19 17:06:54 0x89C ERR 0 DIAG (0):0x0000000077d67ded [F0x0000000009f68b60](0x9f68eb0,0x9f68c80,0x9f68c20,0x1)

2011-01-19 17:06:54 0x89C ERR 0 DIAG (1):0x000000000096fa2f [F0x0000000009f68b90](0xf582e0,0x9f68c80,0xf582e0,0xf582e0)

[markus_doehr2]

> 2011-01-19 17:06:54 0x89C WNG 16 FileDir fdir migration: error during short column entry creation; table fileNo 000000000000AA18, fileTypeSet perm concurr, root page 146525,ERR=5

There seems to be a problem converting a table with the mentioned root page.

If you restore the system on 7.5 check with an SQL statement which object is affected:

SELECT * FROM ROOTS WHERE ROOT = 146525

Markus