Hi, I'm encountering a strange problem (WinXP, verified on Win2K) when trying to extract all data for a given user via the Sapdb loader. Maybe a simple oversight - I hope sombody can help. What I do is the following: I call the loader with "loadercli -b ofbizexport.dat"; the file "ofbizexport.dat" looks like this
USE SERVERDB OFBIZ // USE USER OFBIZEK PASSWRD // TABLEEXTRACT USER DATA OUTSTREAM FILE 'C:\ofbizexp.dat' About 16 Megs of data are extracted to the specified file and then the process dies, actually the whole database instance gets killed; console output looks like this: ----- USE SERVERDB OFBIZ Successfully executed USE USER OFBIZEK OFBIZEK Successfully executed TABLEEXTRACT USER OFBIZEK DATA OUTSTREAM FILE 'C:\ofbizexp.dat' Error during execution -->-25281 Syntax error at position 19 (Unexpected token: OFBIZEK). Defined maximum number of errors (1) reached 1 error(s) during execution of command file 'exportOfbiz.dat'. ---> See log file(s) for more information. Some error(s) occurred running command. ---> See log file(s) for more information. ----- Looking at the loader logfile "loader.prt" I find the following entries: ----- // M Loader 7.4.3 Build 027-123-048-452 // * // M Loader instance started at LT011007 // * // M Starting protocol at 2003110500174629 // * // * // * // M START 20031105 00174629 // * SET // * // M START 20031105 00174629 // * USE SERVERDB OFBIZ // * // M USER: '' on DB: 'OFBIZ' // * // M START 20031105 00174629 // * USE USER OFBIZEK * // * // M USER: 'OFBIZEK' on DB: 'OFBIZ' // * // M START 20031105 00174629 // * TABLEEXTRACT USER DATA OUTSTREAM FILE 'C:\ofbizexp.dat' // * // M LOAD TRANSFORMATIONPACKAGE x'0100000065BAB9F5240A0000FD190000BA20C2FFD2AD2DDC' // * // M Number of tables to transform: 531 // * // M Number of views to transform: 0 // * // M Number of synonyms to transform: 0 // * // M CONFIGURE TRANSFORMATIONPACKAGE // * // M EXECUTE PACKAGE TO TRANSFORM DATA // * // E -25009: Failure in db communication (receive): 4 = connection broken . // E -25801: Internal error [vls26_TETable.cpp, 1886, -25009]; contact technical support // E -25349: Error extracting PRIMARY data of table WORKFLOW_PARTICIPANT. See server logfile for more information. // M Loader 7.4.3 Build 027-123-048-452 // * ----- In knldiag the following entry can be found: ----- 2003-11-05 17:46:41 0xFCC ERR 18358 File: 'vgg04.p', Line: 8107, no match in case statement without otherwise! 2003-11-05 17:46:41 0xFCC ERR 18006 EXCEPT EXCEPTION:0xc0000005 Addr:0x770b77 ( 0x1:0:0:0 ) 2003-11-05 17:46:42 0xFCC ERR 19999 BTRACE SymbolSearchPath: c:\programme\sapdb\indep_data\wrk\OFBIZ;C:\PROGRAMME\SAPDB\DEPEND\pgm;C:\PRO GRAMME\SAPDB\DEPEND\ 2003-11-05 17:46:42 0xFCC ERR 19999 BTRACE symbols;C:\PROGRAMME\SAPDB\DEPEND\sap;C:\WINDOWS;C:\PROGRAMME\SAPDB\DEPEND\s ap\ 2003-11-05 17:46:42 0xFCC ERR 19999 BTRACE ----> Register Dump <---- 2003-11-05 17:46:42 0xFCC ERR 19999 BTRACE Eax=0x00000000 Ebx=0x047fbb8c Ecx=0x00000000 Edx=0x007e4f0c Esi=0x00000154 Edi=0x6d8de050 2003-11-05 17:46:42 0xFCC ERR 19999 BTRACE Eip=0x00770b77 Esp=0x047fb1d4 Ebp=0x047fb200 2003-11-05 17:46:42 0xFCC ERR 19999 BTRACE Cs=0x001b Ss=0x0023 Ds=0x0023 Es=0x0023 Fs=0x0038 Gs=0x0000 Efl=0x10216 2003-11-05 17:46:42 0xFCC ERR 19999 BTRACE ----> Module List <---- 2003-11-05 17:46:43 0xFCC ERR 19999 BTRACE |.text Start |.text End | Module File Name 2003-11-05 17:46:43 0xFCC ERR 19999 BTRACE | 0x00400000 | 0x008bf000 | C:\PROGRAMME\SAPDB\DEPEND\pgm\kernel.exe 2003-11-05 17:46:43 0xFCC ERR 19999 BTRACE | 0x04410000 | 0x044c5000 | C:\PROGRAMME\SAPDB\DEPEND\pgm\dbghelp.dll 2003-11-05 17:46:43 0xFCC ERR 19999 BTRACE | 0x10000000 | 0x10054000 | C:\PROGRAMME\SAPDB\DEPEND\pgm\liboms.dll 2003-11-05 17:46:43 0xFCC ERR 19999 BTRACE | 0x71a00000 | 0x71a08000 | C:\WINDOWS\System32\WS2HELP.dll 2003-11-05 17:46:43 0xFCC ERR 19999 BTRACE | 0x71a10000 | 0x71a25000 | C:\WINDOWS\System32\WS2_32.dll 2003-11-05 17:46:43 0xFCC ERR 19999 BTRACE | 0x76000000 | 0x7600d000 | c:\programme\sapdb\indep_prog\pgm\sqltcp.dll 2003-11-05 17:46:43 0xFCC ERR 19999 BTRACE | 0x76c50000 | 0x76c72000 | C:\WINDOWS\system32\imagehlp.dll 2003-11-05 17:46:43 0xFCC ERR 19999 BTRACE | 0x76ee0000 | 0x76f05000 | C:\WINDOWS\System32\DNSAPI.dll 2003-11-05 17:46:43 0xFCC ERR 19999 BTRACE | 0x76f50000 | 0x76f60000 | C:\WINDOWS\System32\Secur32.dll 2003-11-05 17:46:43 0xFCC ERR 19999 BTRACE | 0x76f80000 | 0x76f85000 | C:\WINDOWS\System32\rasadhlp.dll 2003-11-05 17:46:43 0xFCC ERR 19999 BTRACE | 0x772a0000 | 0x77304000 | C:\WINDOWS\system32\SHLWAPI.dll 2003-11-05 17:46:43 0xFCC ERR 19999 BTRACE | 0x77310000 | 0x7739b000 | C:\WINDOWS\system32\comctl32.dll 2003-11-05 17:46:43 0xFCC ERR 19999 BTRACE | 0x773a0000 | 0x77ba1000 | C:\WINDOWS\system32\SHELL32.dll 2003-11-05 17:46:43 0xFCC ERR 19999 BTRACE | 0x77bd0000 | 0x77bd7000 | C:\WINDOWS\system32\VERSION.dll 2003-11-05 17:46:43 0xFCC ERR 19999 BTRACE | 0x77be0000 | 0x77c33000 | C:\WINDOWS\system32\msvcrt.dll 2003-11-05 17:46:43 0xFCC ERR 19999 BTRACE | 0x77c40000 | 0x77c80000 | C:\WINDOWS\system32\GDI32.dll 2003-11-05 17:46:43 0xFCC ERR 19999 BTRACE | 0x77d10000 | 0x77d9c000 | C:\WINDOWS\system32\USER32.dll 2003-11-05 17:46:43 0xFCC ERR 19999 BTRACE | 0x77da0000 | 0x77e3c000 | C:\WINDOWS\system32\ADVAPI32.dll 2003-11-05 17:46:43 0xFCC ERR 19999 BTRACE | 0x77e40000 | 0x77f38000 | C:\WINDOWS\system32\kernel32.dll 2003-11-05 17:46:43 0xFCC ERR 19999 BTRACE | 0x77f40000 | 0x77fee000 | C:\WINDOWS\System32\ntdll.dll 2003-11-05 17:46:43 0xFCC ERR 19999 BTRACE | 0x78000000 | 0x78086000 | C:\WINDOWS\system32\RPCRT4.dll 2003-11-05 17:46:43 0xFCC ERR 19999 BTRACE | 0x78090000 | 0x78174000 | C:\WINDOWS\WinSxS\x86_Microsoft.Windows.Common-Controls_6595b64144ccf1df_6.0 .10.0_x-ww_ 2003-11-05 17:46:43 0xFCC ERR 19999 BTRACE : : : f7fb5805\comctl32.dll 2003-11-05 17:46:43 0xFCC ERR 19999 BTRACE | 0x7c000000 | 0x7c054000 | C:\WINDOWS\System32\MSVCR70.dll 2003-11-05 17:46:43 0xFCC ERR 19999 BTRACE | 0x7ccc0000 | 0x7cde1000 | C:\WINDOWS\system32\ole32.dll 2003-11-05 17:46:43 0xFCC ERR 19999 BTRACE ----> Stack Back Trace <---- 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE kernel!_sql__perrorp + 23 bytes 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE SFrame: IP:00770b77 RA:007707d4 FP:047fb1d0 SP:047fb1d4 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE Params: 01:007d6914 02:007a4e1c 03:00001fab 04:006a79d1 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE kernel!_sql__caseerr + 20 bytes 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE SFrame: IP:007707d4 RA:006a79d1 FP:047fb1e0 SP:047fb1d4 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE Params: 01:007a4e1c 02:00001fab 03:6d8de050 04:00000154 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE kernel!g04locate_col + 753 bytes 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE SFrame: IP:006a79d1 RA:00435848 FP:047fb200 SP:047fb208 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE Params: 01:7f69e005 02:6d8de050 03:047fb2b8 04:047fbb24 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE Source: vgg04.c ( Line: 2239 ) 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE kernel!bd37rewrite_record + 152 bytes 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE SFrame: IP:00435848 RA:00436125 FP:047fbb40 SP:047fbb48 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE Params: 01:047ff010 02:017fbb8c 03:7f69dfc5 04:6d8de050 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE Source: vbd37.c ( Line: 1912 ) 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE kernel!b37_unload_rewrite_table + 405 bytes 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE SFrame: IP:00436125 RA:0048a093 FP:047fdc34 SP:047fdc3c 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE Params: 01:047ff010 02:043f02a0 03:00000000 04:00008de0 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE Source: vbd37.c ( Line: 2236 ) 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE kernel!a09unload + 115 bytes 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE SFrame: IP:0048a093 RA:005806b1 FP:047fdc60 SP:047fdc68 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE Params: 01:043f02c8 02:00000001 03:047fe17b 04:047fe180 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE Source: vak09.c ( Line: 5468 ) 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE kernel!ak93one_command + 785 bytes 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE SFrame: IP:005806b1 RA:005814e6 FP:047fdcc0 SP:047fdcc8 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE Params: 01:007fe180 02:00000001 03:043f01c8 04:00000001 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE Source: vak93.c ( Line: 6382 ) 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE kernel!a93_user_commands + 758 bytes 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE SFrame: IP:005814e6 RA:0043430e FP:047fdd4c SP:047fdd54 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE Params: 01:007fe180 02:047fe16f 03:047fe17b 04:047fff14 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE Source: vak93.c ( Line: 5550 ) 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE kernel!ak91run_sql_process + 94 bytes 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE SFrame: IP:0043430e RA:00434421 FP:047fe170 SP:047fe178 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE Params: 01:007fe180 02:047fff14 03:043f01a8 04:043f0248 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE Source: vak91.c ( Line: 5284 ) 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE kernel!ak91run_user_process + 225 bytes 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE SFrame: IP:00434421 RA:00434469 FP:047ff798 SP:047ff7a0 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE Params: 01:047fff14 02:00000003 03:047fff14 04:047ffefc 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE Source: vak91.c ( Line: 5329 ) 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE kernel!a91mainprogam_with_allocator + 57 bytes 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE SFrame: IP:00434469 RA:006a23d2 FP:047ff7ac SP:047ff7b4 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE Params: 01:037fff14 02:77f4150c 03:7fed94a8 04:00000000 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE Source: vak91.c ( Line: 5355 ) 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE kernel!gg941CreateAllocatorAndCallMainprog + 194 bytes 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE SFrame: IP:006a23d2 RA:00434498 FP:047ffefc SP:047fff04 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE Params: 01:047fff03 02:047fff5c 03:0000000c 04:047fff14 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE Source: vgg941.cpp ( Line: 127 ) 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE kernel!a91mainprogram + 40 bytes 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE SFrame: IP:00434498 RA:006f3e1f FP:047fff78 SP:047fff80 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE Params: 01:77f4150c 02:77f41502 03:7ff30200 04:00000000 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE Source: vak91.c ( Line: 5342 ) 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE kernel!sql88k_kernel_fiber + 191 bytes 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE SFrame: IP:006f3e1f RA:77e5d33b FP:047fffb4 SP:047fffbc 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE Params: 01:7ff30200 02:77f4150c 03:77f41502 04:7ff30200 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE Source: vos88k.c ( Line: 435 ) 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE kernel32!RegisterWaitForInputIdle + 67 bytes 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE SFrame: IP:77e5d33b RA:77e546cf FP:047fffec SP:047fffbc 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE Params: 01:006f3d60 02:7ff30200 03:00000000 04:00000000 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE kernel32!ConvertThreadToFiber + 137 bytes 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE SFrame: IP:77e546cf RA:00000000 FP:047ffef0 SP:047fffbc 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE Params: 01:00000000 02:047fff78 03:00434498 04:047fff03 2003-11-05 17:46:46 0xFCC ERR 19999 BTRACE No crash dump file 'knlcrash.dmp' written 2003-11-05 17:46:48 0xFCC 19820 EXCEPT calling ak dump for T16 2003-11-05 17:46:48 0xFCC 19624 EXCEPT Kernel aborts 2003-11-05 17:46:48 0xFCC 19684 TASKING Tracewriter termination timeout: 1200 sec 2003-11-05 17:46:48 0xF7C 19617 VOLUMEIO Single I/O attach, 'knltrace', UKT:1 2003-11-05 17:46:56 0xF7C 19619 TASKING Releasing tracewriter 2003-11-05 17:46:56 0xFCC 19890 DIAGHIST Backup of diagnostic files will be forced at next restart 2003-11-05 17:46:56 0xFCC 19600 VERSION 'Kernel 7.4.3 Build 027-123-048-452' 2003-11-05 17:46:56 0xFCC 19654 DBSTATE SERVERDB 'OFBIZ' has stopped ----- --Matthias -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
