Hi, whenever I am fiddling with the loadercli, I seem to run into new problems.
I just wanted to create a copy of an existing user schema to a new one. The loader script I use looks the following way: --- "cmd" - cutting here will probably damage your monitor --- USE USER "OIKOTEST" "TEST123" SERVERDB "TNG1" ON sapdb.tng.de // CATALOGEXTRACT USER OUTSTREAM FILE '/tmp/catalog.' // TABLEEXTRACT USER DATA OUTSTREAM FILE '/tmp/table.' PAGES PACKAGE OUTSTREAM FILE '/tmp/table-package.' // USE USER "OIKOIMP" "TEST123" SERVERDB "TNG1" ON sapdb.tng.de // TABLELOAD USER DATA INSTREAM FILE '/tmp/table.0001' PAGES PACKAGE OUTSTREAM FILE '/tmp/table-load-pkg.' // CATALOGLOAD USER INSTREAM FILE '/tmp/catalog.' // --- script end --- The user OIKOIMP has freshly been created. I run it with loadercli -b cmd All seems to be running fine, until the TABLELOAD (by the way, exchanging CATALOGLOAD and TABLELOAD does not help.). Then a segmentation fault on client side occurs. The loader protocol looks the following way: --- protocol start --- // M Loader 7.4.3 Build 027-121-048-452 // * // M Loader instance started at khorne // * // M Starting protocol at 2003102700083315 // * // * // * // M START 20031027 00083315 // * SET // * // M START 20031027 00083315 // * USE USER "OIKOTEST" * SERVERDB "TNG1" ON sapdb.tng.de // * // M USER: 'OIKOTEST' on DB: 'TNG1' // * // M START 20031027 00083315 // * CATALOGEXTRACT USER OUTSTREAM FILE '/tmp/catalog.' // * // M LOAD TRANSFORMATIONPACKAGE x'010000003BCA9C3F5C2C00004311FF064399D5B2FFFFFFFF' // * // M Number of tables to transform: 57 // * // M Number of views to transform: 1 // * // M Number of synonyms to transform: 0 // * // M EXECUTE PACKAGE TO TRANSFORM CATALOG // * // M Number of tables transformed : 57 // * // M Number of views transformed : 1 // * // M Number of synonyms transformed : 0 // * // M UNLOAD TRANSFORMATIONPACKAGE x'010000003BCA9C3F5C2C00004311FF064399D5B2FFFFFFFF' // * // M START 20031027 00083323 // * TABLEEXTRACT USER DATA OUTSTREAM FILE '/tmp/table.' PAGES PACKAGE OUTSTREAM FILE '/tmp/table-package.' // * // M LOAD TRANSFORMATIONPACKAGE x'0200000043CA9C3F5C2C00004311FF064399D5B2FFFFFFFF' // * // M Number of tables to transform: 57 // * // M Number of views to transform: 1 // * // M Number of synonyms to transform: 0 // * // M CONFIGURE TRANSFORMATIONPACKAGE // * // M EXECUTE PACKAGE TO TRANSFORM DATA // * // M Number of tables transformed : 57 // * // M UNLOAD TRANSFORMATIONPACKAGE x'0200000043CA9C3F5C2C00004311FF064399D5B2FFFFFFFF' // * // M START 20031027 00083449 // * USE USER "OIKOIMP" * SERVERDB "TNG1" ON sapdb.tng.de // * // M Releasing user connection (USER: 'OIKOTEST'). // * // M USER: 'OIKOIMP' on DB: 'TNG1' // * // M START 20031027 00083449 // * TABLELOAD USER DATA INSTREAM FILE '/tmp/table.0001' PAGES PACKAGE OUTSTREAM FILE '/tmp/table-load-pkg.' // * // M EXECUTE PACKAGE TO TRANSFORM DATA // * --- protocol end --- As you can probably see, I have no good indication of the error. A gdb backtrace looks the following way: #0 0x08105c7c in StudioOAL_WResult::openResult () #1 0x081b57a9 in CatalogObjectDefODBC::executeSQL () #2 0x08196fa8 in ls28_LoadUserTables () #3 0x08197a71 in ls28ExecTableLoad () #4 0x0815dcaa in ls10ExecTransformation () #5 0x0814bed3 in ls11ParseDispatchLoadCommand () #6 0x081494dd in ctrlservcommand () #7 0x0804efc8 in ls40_ServerCommand () #8 0x0804e797 in ls40_Batch () #9 0x0804f289 in main () #10 0x400df14f in __libc_start_main () from /lib/libc.so.6 So I think at least the source of the segmentation fault seems to be in your code, not any library code. I do not know, if any data got really loaded. Thanks a lot, Regards, Carsten -- -------------------------------------------------------------------------- Carsten Tolkmit, Geschaeftsfuehrer IT-Solutions | mailto:[EMAIL PROTECTED] TNG - the net generation GmbH | http://www.tng.de Projensdorfer Strasse 324 | Fon: +49 431 7097-470 24106 Kiel, Germany | Fax: +49 431 7097-555 -------------------------------------------------------------------------- -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
