Hi!
I ran into some strange trouble while trying to migrate a database from 7.4.30 to
7.5.01:
When I create a Backup and try to restore it to the 7.5, I succed to read it into the
new created database, but as soon as I try to get the db online, I get:
2004-04-22 02:28:36 0x4114 ERR 51381 MIGRAT migrating failed with error -9400
Ok. Never mind. Next try:
Then I tried to export data with loadercli from the 7.4.3.30:
I created a DBExtract.txt with this content:
DBEXTRACT CATALOG OUTSTREAM 'catalog.out' DATA OUTSTREAM 'data.out'
And then executed:
LOADERCLI -d NSWVORN -u dba,dba -b DBExtract.txt -E 20
It succeded to export the Table Structure and crashed midway during data extract.
kndiag looks like this:
2004-04-22 03:05:09 --- Starting GMT 2004-04-22 03:05:09
7.4.3 Build 030-123-056-274
2004-04-22 03:06:06 0x11C ERR 18358 File: 'vgg04.p', Line: 8110, no
match in case statement without otherwise!
2004-04-22 03:06:06 0x11C ERR 18006 EXCEPT EXCEPTION:0xc0000005 Addr:0x778fc7 (
0x1:0:0:0 )
2004-04-22 03:06:06 0x11C ERR 19999 BTRACE SymbolSearchPath:
h:\NSWVORN;C:\PROGRAMME\SAPDB\DEPEND\pgm;C:\PROGRAMME\SAPDB\DEPEND\symbols;C:\PROGRAMME\SAPDB\DE
2004-04-22 03:06:06 0x11C ERR 19999 BTRACE
PEND\sap;C:\WINDOWS;C:\PROGRAMME\SAPDB\DEPEND\sap\
2004-04-22 03:06:06 0x11C ERR 19999 BTRACE ----> Register Dump <----
2004-04-22 03:06:06 0x11C ERR 19999 BTRACE Eax=0x00000000 Ebx=0x06b5bb84
Ecx=0x00000000 Edx=0x007edffc Esi=0x00000079 Edi=0x62070050
2004-04-22 03:06:06 0x11C ERR 19999 BTRACE Eip=0x00778fc7 Esp=0x06b5b1d0
Ebp=0x06b5b1fc
2004-04-22 03:06:06 0x11C ERR 19999 BTRACE Cs=0x001b Ss=0x0023 Ds=0x0023
Es=0x0023 Fs=0x0038 Gs=0x0000 Efl=0x10212
2004-04-22 03:06:07 0x11C ERR 19999 BTRACE ----> Module List <----
2004-04-22 03:06:07 0x11C ERR 19999 BTRACE |.text Start |.text End | Module
File Name
2004-04-22 03:06:07 0x11C ERR 19999 BTRACE | 0x00400000 | 0x008c5000 |
C:\PROGRAMME\SAPDB\DEPEND\pgm\kernel.exe
2004-04-22 03:06:07 0x11C ERR 19999 BTRACE | 0x06770000 | 0x06825000 |
C:\PROGRAMME\SAPDB\DEPEND\pgm\dbghelp.dll
2004-04-22 03:06:07 0x11C ERR 19999 BTRACE | 0x10000000 | 0x10055000 |
C:\PROGRAMME\SAPDB\DEPEND\pgm\liboms.dll
2004-04-22 03:06:07 0x11C ERR 19999 BTRACE | 0x70a70000 | 0x70ad5000 |
C:\WINDOWS\system32\SHLWAPI.dll
2004-04-22 03:06:07 0x11C ERR 19999 BTRACE | 0x71a00000 | 0x71a08000 |
C:\WINDOWS\System32\WS2HELP.dll
2004-04-22 03:06:07 0x11C ERR 19999 BTRACE | 0x71a10000 | 0x71a25000 |
C:\WINDOWS\System32\WS2_32.dll
2004-04-22 03:06:07 0x11C ERR 19999 BTRACE | 0x76000000 | 0x7600d000 |
c:\programme\sapdb\indep_prog\pgm\sqltcp.dll
2004-04-22 03:06:07 0x11C ERR 19999 BTRACE | 0x76c50000 | 0x76c72000 |
C:\WINDOWS\system32\imagehlp.dll
2004-04-22 03:06:07 0x11C ERR 19999 BTRACE | 0x76ee0000 | 0x76f05000 |
C:\WINDOWS\System32\DNSAPI.dll
2004-04-22 03:06:07 0x11C ERR 19999 BTRACE | 0x76f50000 | 0x76f60000 |
C:\WINDOWS\System32\Secur32.dll
2004-04-22 03:06:07 0x11C ERR 19999 BTRACE | 0x76f80000 | 0x76f85000 |
C:\WINDOWS\System32\rasadhlp.dll
2004-04-22 03:06:07 0x11C ERR 19999 BTRACE | 0x77310000 | 0x7739b000 |
C:\WINDOWS\system32\comctl32.dll
2004-04-22 03:06:07 0x11C ERR 19999 BTRACE | 0x773a0000 | 0x77b9c000 |
C:\WINDOWS\system32\SHELL32.dll
2004-04-22 03:06:07 0x11C ERR 19999 BTRACE | 0x77bd0000 | 0x77bd7000 |
C:\WINDOWS\system32\VERSION.dll
2004-04-22 03:06:07 0x11C ERR 19999 BTRACE | 0x77be0000 | 0x77c33000 |
C:\WINDOWS\system32\msvcrt.dll
2004-04-22 03:06:07 0x11C ERR 19999 BTRACE | 0x77c40000 | 0x77c80000 |
C:\WINDOWS\system32\GDI32.dll
2004-04-22 03:06:07 0x11C ERR 19999 BTRACE | 0x77d10000 | 0x77d9c000 |
C:\WINDOWS\system32\USER32.dll
2004-04-22 03:06:07 0x11C ERR 19999 BTRACE | 0x77da0000 | 0x77e3c000 |
C:\WINDOWS\system32\ADVAPI32.dll
2004-04-22 03:06:07 0x11C ERR 19999 BTRACE | 0x77e40000 | 0x77f38000 |
C:\WINDOWS\system32\kernel32.dll
2004-04-22 03:06:07 0x11C ERR 19999 BTRACE | 0x77f40000 | 0x77fee000 |
C:\WINDOWS\System32\ntdll.dll
2004-04-22 03:06:07 0x11C ERR 19999 BTRACE | 0x78000000 | 0x78086000 |
C:\WINDOWS\system32\RPCRT4.dll
2004-04-22 03:06:07 0x11C ERR 19999 BTRACE | 0x78090000 | 0x78174000 |
C:\WINDOWS\WinSxS\x86_Microsoft.Windows.Common-Controls_6595b64144ccf1df_6.0.10.0_x-ww_
2004-04-22 03:06:07 0x11C ERR 19999 BTRACE : : :
f7fb5805\comctl32.dll
2004-04-22 03:06:07 0x11C ERR 19999 BTRACE | 0x7c000000 | 0x7c054000 |
C:\WINDOWS\System32\MSVCR70.dll
2004-04-22 03:06:07 0x11C ERR 19999 BTRACE | 0x7ccc0000 | 0x7cde1000 |
C:\WINDOWS\system32\ole32.dll
2004-04-22 03:06:07 0x11C ERR 19999 BTRACE ----> Stack Back Trace <----
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE kernel!_sql__perrorp + 23 bytes
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE SFrame: IP:00778fc7
RA:00778c24 FP:06b5b1cc SP:06b5b1d0
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE Params: 01:007dfa08
02:007ae1e8 03:00001fae 04:006ac951
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE kernel!_sql__caseerr + 20 bytes
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE SFrame: IP:00778c24
RA:006ac951 FP:06b5b1dc SP:06b5b1d0
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE Params: 01:007ae1e8
02:00001fae 03:62070050 04:00000079
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE kernel!g04locate_col + 753 bytes
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE SFrame: IP:006ac951
RA:00438828 FP:06b5b1fc SP:06b5b204
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE Params: 01:7f29dffd
02:62070050 03:06b5b2b4 04:06b5bb1c
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE Source: vgg04.c ( Line: 2240 )
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE kernel!bd37rewrite_record + 152
bytes
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE SFrame: IP:00438828
RA:00439115 FP:06b5bb38 SP:06b5bb40
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE Params: 01:06b5f008
02:01b5bb84 03:7f29dfbd 04:62070050
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE Source: vbd37.c ( Line: 1912 )
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE kernel!b37_unload_rewrite_table +
405 bytes
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE SFrame: IP:00439115
RA:0048d003 FP:06b5dc2c SP:06b5dc34
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE Params: 01:06b5f008
02:067502a0 03:00000000 04:00008de0
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE Source: vbd37.c ( Line: 2240 )
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE kernel!a09unload + 115 bytes
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE SFrame: IP:0048d003
RA:005842e1 FP:06b5dc58 SP:06b5dc60
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE Params: 01:067502c8
02:00000001 03:06b5e173 04:06b5e178
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE Source: vak09.c ( Line: 5469 )
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE kernel!ak93one_command + 785 bytes
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE SFrame: IP:005842e1
RA:00585116 FP:06b5dcb8 SP:06b5dcc0
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE Params: 01:00b5e178
02:00000001 03:067501c8 04:00000001
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE Source: vak93.c ( Line: 6390 )
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE kernel!a93_user_commands + 758
bytes
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE SFrame: IP:00585116
RA:0043730e FP:06b5dd44 SP:06b5dd4c
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE Params: 01:00b5e178
02:06b5e167 03:06b5e173 04:06b5ff14
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE Source: vak93.c ( Line: 5558 )
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE kernel!ak91run_sql_process + 94
bytes
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE SFrame: IP:0043730e
RA:00437421 FP:06b5e168 SP:06b5e170
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE Params: 01:00b5e178
02:06b5ff14 03:067501a8 04:06750248
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE Source: vak91.c ( Line: 5285 )
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE kernel!ak91run_user_process + 225
bytes
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE SFrame: IP:00437421
RA:00437469 FP:06b5f790 SP:06b5f798
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE Params: 01:06b5ff14
02:00000003 03:00000000 04:06b5fefc
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE Source: vak91.c ( Line: 5330 )
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE
kernel!a91mainprogam_with_allocator + 57 bytes
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE SFrame: IP:00437469
RA:006a7362 FP:06b5f7a4 SP:06b5f7ac
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE Params: 01:03b5ff14
02:77f83996 03:7feb67f0 04:00000000
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE Source: vak91.c ( Line: 5356 )
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE
kernel!gg941CreateAllocatorAndCallMainprog + 210 bytes
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE SFrame: IP:006a7362
RA:00437498 FP:06b5fefc SP:06b5ff04
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE Params: 01:06b5ff03
02:06b5ff5c 03:0000000c 04:06b5ff14
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE Source: vgg941.cpp ( Line:
133 )
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE kernel!a91mainprogram + 40 bytes
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE SFrame: IP:00437498
RA:006f91ef FP:06b5ff78 SP:06b5ff80
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE Params: 01:77f83996
02:77f8398c 03:7fd0c060 04:00000000
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE Source: vak91.c ( Line: 5343 )
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE kernel!sql88k_kernel_fiber + 191
bytes
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE SFrame: IP:006f91ef
RA:77e5d33b FP:06b5ffb4 SP:06b5ffbc
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE Params: 01:7fd0c060
02:77f83996 03:77f8398c 04:7fd0c060
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE Source: vos88k.c ( Line: 435 )
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE kernel32!RegisterWaitForInputIdle
+ 67 bytes
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE SFrame: IP:77e5d33b
RA:77e546cf FP:06b5ffec SP:06b5ffbc
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE Params: 01:006f9130
02:7fd0c060 03:00000000 04:00000000
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE kernel32!ConvertThreadToFiber +
137 bytes
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE SFrame: IP:77e546cf
RA:00000000 FP:0684fef0 SP:06b5ffbc
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE Params: 01:00000000
02:00000000 03:00000000 04:00000000
2004-04-22 03:06:09 0x11C ERR 19999 BTRACE No crash dump file 'knlcrash.dmp'
written
2004-04-22 03:18:44 --- Starting GMT 2004-04-22 03:18:44
7.4.3 Build 030-123-056-274
Thanks!
(Gerald)
