Hi, as far as I know you cannot load data files created with TABLEEXTRACT USER because this is a binary data file the data format is not binary compatible with sapdb (anymore?). If you search the archive however you find examples and instructions of how a migration of data from adabas to sapdb can (probably) be done with a CATALOGEXTRACT and DATAEXTRACT FOR DATALOAD combination.
I'm working on a little java tool for making the whole process easier (there have to be some changes done in the DDL files crated with xload, and that can be alot of work on large catalogs). Currently I'm once again lacking the time to continue working on it. Marco ----- Original Message ----- From: "Armin Haaf" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, January 13, 2003 8:04 PM Subject: Problem with xload > Hi, > > we are using sapdb quite some time for testing and we decided > to migrate from our adabasd 11 database to sapdb. So I thought > I could use xload to extract the user data from adabasd and load it > in the sapdb. > > Because it did not work to extract and load with the adabasd xload nor > with the sapdb xload, I extracted the adabasd data with the adabasd xload. > After the catalog load with sapdb xload, I wanted to load the > table data with the sapdb xload using tableload user ... > It did not work, in fact, the database kernel crashed (see kernel message below). > > Is there another way to migrate the data? > (there is a tool from automatix, which did not work for me, because the sapdb perl > module is not working on the suse 7.2 system and the adabas perl module not on suse >8.1) > > The new system is suse 8.1 the old one suse 7.2 > > > Greetings > > Armin > > PS.: the search in the mail archives did not work: > http://listserv.sap.com/searchbin/htsearch, no results at all > > > > The kernel message: > > 2003-01-13 19:22:38 --- Starting GMT 2003-01-13 18:22:38 7.3.0 Build 024-000-000-000 > 2003-01-13 19:32:31 0 ERR 11330 COREHAND ABORTING due to signal 11 > 2003-01-13 19:32:31 0 ERR 11599 BTRACE ----> Emergency Stack Back Trace <---- > 2003-01-13 19:32:31 0 ERR 11599 BTRACE (0):0x809a1fd >[0x4135777c](0x4135c1d4,0x4135a4f4,0x8,0x809b5f1) > 2003-01-13 19:32:31 0 ERR 11599 BTRACE (1):0x809b971 >[0x4135777c](0x4135c1d4,0x4135a4f4,0x8,0x809b5f1) > 2003-01-13 19:32:31 0 ERR 11599 BTRACE (2):0x809df30 >[0x4135a47c](0x4135c1d4,0x4135a4f4,0x1,0x809de96) > 2003-01-13 19:32:31 0 ERR 11599 BTRACE (3):0x807eaf3 >[0x4135a49c](0x4135c1d4,0x4135a4f4,0x40,0x4135d304) > 2003-01-13 19:32:31 0 ERR 11599 BTRACE (4):0x80de30d >[0x4135b88c](0x4135c1d4,0x30,0x51,0x80de1b2) > 2003-01-13 19:32:31 0 ERR 11599 BTRACE (5):0x80dd248 >[0x4135b8fc](0x4135c1d4,0x42567178,0x40,0x80dc35a) > 2003-01-13 19:32:31 0 ERR 11599 BTRACE (6):0x822952d >[0x4135b95c](0x4135c1d4,0x4135d064,0x40,0x837ee1c) > 2003-01-13 19:32:31 0 ERR 11599 BTRACE (7):0x822a106 >[0x4135ba5c](0x4135c1d4,0x4135baa8,0x4135baac,0x4135bb94) > 2003-01-13 19:32:31 0 ERR 11599 BTRACE (8):0x822ae20 >[0x4135bbcc](0x4135c1d4,0x0,0x0,0x0) > 2003-01-13 19:32:31 0 ERR 11599 BTRACE (9):0x822e5f0 >[0x4135bc1c](0x4135c1d4,0x0,0x0,0x822e240) > 2003-01-13 19:32:31 0 ERR 11599 BTRACE (10):0x822d5cc >[0x4135bcac](0x4135c1d4,0x1,0x4135bcdc,0x1) > 2003-01-13 19:32:31 0 ERR 11599 BTRACE (11):0x8051b81 >[0x4135bd5c](0x4135c1d4,0x4135bd82,0x4135bd81,0x4135bd83) > 2003-01-13 19:32:31 0 ERR 11599 BTRACE (12):0x8051cd3 >[0x4135c1ac](0x4135c1d4,0x4135d784,0x4135d75c,0x8051cdb) > 2003-01-13 19:32:31 0 ERR 11599 BTRACE (13):0x8051d4f >[0x4135d75c](0x4135d784,0x3,0x4135d7dc,0x8051cfd) > 2003-01-13 19:32:31 0 ERR 11599 BTRACE (14):0x83beea1 >[0x4135d7dc](0x8473c48,0xbbbbbbbb,0x4135d7fc,0x83bf9d4) > 2003-01-13 19:32:31 0 ERR 11599 BTRACE (15):0x83bf9d4 >[0x4135d7ec](0x206,0xbbbbbbbb,0x0,0x0) > 2003-01-13 19:32:31 0 ERR 11599 BTRACE ----> Register Dump <---- 2003-0 1-13 >19:32:31 0 ERR 11599 BTRACE ------------------------------- > 2003-01-13 19:32:31 0 ERR 11599 BTRACE ds es 0x0000002b 0x0000002b > 2003-01-13 19:32:31 0 ERR 11599 BTRACE fs gs 0x00000000 0x00000000 > 2003-01-13 19:32:31 0 ERR 11599 BTRACE trap err 0x0000000e 0x00000004 > 2003-01-13 19:32:31 0 ERR 11599 BTRACE efl ss 0x00010202 0x0000002b > 2003-01-13 19:32:31 0 ERR 11599 BTRACE edi esi 0x41357728 0x425692e4 > 2003-01-13 19:32:31 0 ERR 11599 BTRACE eax ebx 0x00000008 > 2003-01-13 19:32:31 0 ERR 11599 BTRACE ecx edx 0x4135a4fc > 2003-01-13 19:32:31 0 ERR 11599 BTRACE esp uesp 0x41355d44 0x41355d44 > 2003-01-13 19:32:31 0 ERR 11599 BTRACE ebp eip 0x4135777c 0x0809a1fd > 2003-01-13 19:32:31 0 ERR 11599 BTRACE cs cr2 0x00000023 0x0000000c > 2003-01-13 19:32:31 0 ERR 11599 BTRACE ------------------------------- > 2003-01-13 19:32:31 0 ERR 11599 BTRACE cw - sw - tag 0xffff037f 0xffff4020 0xffffffff > 2003-01-13 19:32:31 0 ERR 11599 BTRACE ipoff - cssel 0x00000000 0x00000000 > 2003-01-13 19:32:31 0 ERR 11599 BTRACE dataoff-datasel 0x00000000 0x00000000 > 2003-01-13 19:32:31 0 ERR 11599 BTRACE f00 [0x0000 0x0000 0x0000 0x0000 - 0x0000] > 2003-01-13 19:32:31 0 ERR 11599 BTRACE f01 [0x0000 0x0000 0x0000 0x9000 - 0x4002] > 2003-01-13 19:32:31 0 ERR 11599 BTRACE f02 [0x0000 0x0000 0x0000 0x8000 - 0xbfff] > 2003-01-13 19:32:31 0 ERR 11599 BTRACE f03 [0x0000 0x0000 0x0000 0x8000 - 0x4000] > 2003-01-13 19:32:31 0 ERR 11599 BTRACE f04 [0x0000 0x0000 0x0000 0x8000 - 0xc000] > 2003-01-13 19:32:31 0 ERR 11599 BTRACE f05 [0xc800 0xf768 0xf5b0 0xc06d - 0x3ffa] > 2003-01-13 19:32:31 0 ERR 11599 BTRACE f06 [0x0000 0x0000 0x0000 0x8c60 - 0x4009] > 2003-01-13 19:32:31 0 ERR 11599 BTRACE f07 [0x0000 0x0000 0x0000 0x8c00 - 0x4008] > 2003-01-13 19:32:31 0 ERR 11599 BTRACE ------------------------------- > 2003-01-13 19:32:31 0 ERR 11599 BTRACE ----> Module List <---- > 2003-01-13 19:32:31 0 ERR 11599 BTRACE module file name |.text start |.text end > 2003-01-13 19:32:31 0 ERR 11599 BTRACE /opt/sapdb/depend/pgm/kernel | 0x08048000 | >0x08417000 > 2003-01-13 19:32:31 0 ERR 11599 BTRACE /lib/ld-2.2.5.so | 0x40000000 | 0x40012000 > 2003-01-13 19:32:31 0 ERR 11599 BTRACE /lib/libpthread.so.0 | 0x40025000 | 0x40033000 > 2003-01-13 19:32:31 0 ERR 11599 BTRACE /lib/libdl.so.2 | 0x4003a000 | 0x4003c000 > 2003-01-13 19:32:31 0 ERR 11599 BTRACE /usr/lib/libstdc++.so.5.0.0 | 0x4003d000 | >0x400d6000 > 2003-01-13 19:32:31 0 ERR 11599 BTRACE /lib/libm.so.6 | 0x400f0000 | 0x40112000 > 2003-01-13 19:32:31 0 ERR 11599 BTRACE /lib/libgcc_s.so.1 | 0x40113000 | 0x4011a000 > 2003-01-13 19:32:31 0 ERR 11599 BTRACE /lib/libc.so.6 | 0x4011c000 | 0x40230000 > 2003-01-13 19:32:31 0 ERR 11599 BTRACE /opt/sapdb/depend/lib/liboms.so | 0x477f2000 >| 0x47847000 > 2003-01-13 19:32:31 0 ERR 11599 BTRACE > 2003-01-13 19:32:31 0 ERR 11599 BTRACE ----> Symbolic Stack Back Trace <---- > 2003-01-13 19:32:31 0 ERR 11599 BTRACE 0: 0x0809a1fd ak17incopy_baserecords +0x0145 > 2003-01-13 19:32:31 0 ERR 11599 BTRACE /opt/sapdb/depend/pgm/kernel > 2003-01-13 19:32:31 0 ERR 11599 BTRACE [0x4135777c] >(0x4135c1d4,0x4135a4f4,0x8,0x809b5f1) > 2003-01-13 19:32:31 0 ERR 11599 BTRACE 1: 0x0809b971 ak17incopy_table +0x0391 > 2003-01-13 19:32:31 0 ERR 11599 BTRACE /opt/sapdb/depend/pgm/kernel > 2003-01-13 19:32:31 0 ERR 11599 BTRACE [0x4135777c] >(0x4135c1d4,0x4135a4f4,0x8,0x809b5f1) > 2003-01-13 19:32:31 0 ERR 11599 BTRACE 2: 0x0809df30 a17incopy +0x00a6 > 2003-01-13 19:32:31 0 ERR 11599 BTRACE /opt/sapdb/depend/pgm/kernel > 2003-01-13 19:32:31 0 ERR 11599 BTRACE [0x4135a47c] >(0x4135c1d4,0x4135a4f4,0x1,0x809de96) > 2003-01-13 19:32:31 0 ERR 11599 BTRACE 3: 0x0807eaf3 a11_call_semantic +0x0c2b > 2003-01-13 19:32:31 0 ERR 11599 BTRACE /opt/sapdb/depend/pgm/kernel > 2003-01-13 19:32:31 0 ERR 11599 BTRACE [0x4135a49c] >(0x4135c1d4,0x4135a4f4,0x40,0x4135d304) > 2003-01-13 19:32:31 0 ERR 11599 BTRACE 4: 0x080de30d ak35call_semantik +0x0169 > 2003-01-13 19:32:31 0 ERR 11599 BTRACE /opt/sapdb/depend/pgm/kernel > 2003-01-13 19:32:31 0 ERR 11599 BTRACE [0x4135b88c] (0x4135c1d4,0x30,0x51,0x80de1b2) > 2003-01-13 19:32:31 0 ERR 11599 BTRACE 5: 0x080dd248 a35_asql_statement +0x0efc > 2003-01-13 19:32:31 0 ERR 11599 BTRACE /opt/sapdb/depend/pgm/kernel > 2003-01-13 19:32:31 0 ERR 11599 BTRACE [0x4135b8fc] >(0x4135c1d4,0x42567178,0x40,0x80dc35a) > 2003-01-13 19:32:31 0 ERR 11599 BTRACE 6: 0x0822952d ak92not_only_execute +0x05e1 > 2003-01-13 19:32:31 0 ERR 11599 BTRACE /opt/sapdb/depend/pgm/kernel > 2003-01-13 19:32:31 0 ERR 11599 BTRACE [0x4135b95c] >(0x4135c1d4,0x4135d064,0x40,0x837ee1c) > 2003-01-13 19:32:31 0 ERR 11599 BTRACE 7: 0x0822a106 ak92analyze_messagetype +0x064a > 2003-01-13 19:32:31 0 ERR 11599 BTRACE /opt/sapdb/depend/pgm/kernel > 2003-01-13 19:32:31 0 ERR 11599 BTRACE [0x4135ba5c] >(0x4135c1d4,0x4135baa8,0x4135baac,0x4135bb94) > 2003-01-13 19:32:31 0 ERR 11599 BTRACE 8: 0x0822ae20 a92_mode_analyzer +0x010a > 2003-01-13 19:32:31 0 ERR 11599 BTRACE /opt/sapdb/depend/pgm/kernel > 2003-01-13 19:32:31 0 ERR 11599 BTRACE [0x4135bbcc] (0x4135c1d4,0x0,0x0,0x0) > 2003-01-13 19:32:31 0 ERR 11599 BTRACE 9: 0x0822e5f0 ak93one_command +0x03be > 2003-01-13 19:32:31 0 ERR 11599 BTRACE /opt/sapdb/depend/pgm/kernel > 2003-01-13 19:32:31 0 ERR 11599 BTRACE [0x4135bc1c] (0x4135c1d4,0x0,0x0,0x822e240) > 2003-01-13 19:32:31 0 ERR 11599 BTRACE 10: 0x0822d5cc a93_user_commands +0x0340 > 2003-01-13 19:32:31 0 ERR 11599 BTRACE /opt/sapdb/depend/pgm/kernel > 2003-01-13 19:32:31 0 ERR 11599 BTRACE [0x4135bcac] (0x4135c1d4,0x1,0x4135bcdc,0x1) > 2003-01-13 19:32:31 0 ERR 11599 BTRACE 11: 0x08051b81 ak91run_sql_process +0x0093 > 2003-01-13 19:32:31 0 ERR 11599 BTRACE /opt/sapdb/depend/pgm/kernel > 2003-01-13 19:32:31 0 ERR 11599 BTRACE [0x4135bd5c] >(0x4135c1d4,0x4135bd82,0x4135bd81,0x4135bd83) > 2003-01-13 19:32:31 0 ERR 11599 BTRACE 12: 0x08051cd3 ak91run_user_process +0x011f > 2003-01-13 19:32:31 0 ERR 11599 BTRACE /opt/sapdb/depend/pgm/kernel > 2003-01-13 19:32:31 0 ERR 11599 BTRACE [0x4135c1ac] >(0x4135c1d4,0x4135d784,0x4135d75c,0x8051cdb) > 2003-01-13 19:32:31 0 ERR 11599 BTRACE 13: 0x08051d4f a91mainprogram +0x006b > 2003-01-13 19:32:31 0 ERR 11599 BTRACE /opt/sapdb/depend/pgm/kernel > 2003-01-13 19:32:31 0 ERR 11599 BTRACE [0x4135d75c] >(0x4135d784,0x3,0x4135d7dc,0x8051cfd) > 2003-01-13 19:32:31 0 ERR 11599 BTRACE 14: 0x083beea1 en88_CallA91Main +0x00df > 2003-01-13 19:32:31 0 ERR 11599 BTRACE /opt/sapdb/depend/pgm/kernel > 2003-01-13 19:32:31 0 ERR 11599 BTRACE [0x4135d7dc] >(0x8473c48,0xbbbbbbbb,0x4135d7fc,0x83bf9d4) > -- > Armin Haaf, mercatis information systems GmbH > Marlene-Dietrich-Str. 5 Fon +49 (0) 731 98588 - 615 ___o > 89231 Neu-Ulm, Germany Fax +49 (0) 731 98588 - 511 _\ <_ > http://www.mercatis.de mailto:[EMAIL PROTECTED] (_)�(_) > > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
